Name _________________________ Date ___________

Systems Analysis & Design Excel 2002 Chapter 93 – Multiple Choice

Instructions: Circle the correct response.

1. If you assign the value 42 to cell E5, the value 11 to cell F5, and cell G5 contains the function =IF(E5>4*F5,“Deductions”,“No deductions”), then cell G5 displays the message, ____________ is the process of constructing programs and code modules that are building blocks of an information system. .

a. Hardware developmentDeductions
b. Application developmentNo deductions
c. Software Engineering#REF!
d. ODBC F5

2. Use Athe ____________ functioncommand? when the value you want to assign to a cell is dependent on a logical teconsists of related program code organized into small units that are easy to understand and maintain. st.

a. moduleASSIGNssign
b. consoleIFf_THENhen_ELSElse
c. data couple WHAT IFhat_If
d. controlIFIf

3. In structure charts, a higher-level module called a ____________ directs lower-level modules called a ____________. A cell reference of $B17 is a(n) ____________ cell reference.

a. data couple, storage coupleabsolute
b. data couple, library modulerelative
c. control module, subordinate modulemixed
d. top-down module, partitioning moduleinvalid

4. In structure charts, a curved arrow represents a You can use the Split command to split a window into ____________. .

a. decisionhorizontal panes
b. librarytwo vertical panes
c. messagefour panes
d. loopof the above

5. Modules that are independent are considered to be ____________ coupled..

a. looselyQtr 5, Qtr 6, Qtr 7
b. tightlyQtr 1, Qtr 2, Qtr 3
c. partitionQtr 3, Qtr 3, Qtr 1
d. loop#REF!

6. The testing of an individual program or module is called When copying a range of cells using the drag and drop method, you first point to the border of the selected range so that the mouse pointer changes to a (n) ____________.

a. system testingcross hair
b. integration testingarrow
c. unit testingblock plus sign
d. desk checkingsplit double arrow

7. The environment that analysts and programmers use to develop and maintain programs is called theo freeze worksheet titles use the ___________ command on the ___________ me environment. nu.

a. operationalSplit, Format
b. analystSplit, Window

c. managementFreeze Panes, Window
d. testFreeze Panes, Tools

8. Using a ___________ strategy to train users, you can select knowledgeable users who then conduct sessions for others. o indicate when there is a cell reference error.

a. train-the-trainer######
b. classroom******
c. operational#REF!
d. errtutorialor

9. TheYou can use the Shadow button on the ____________ approach for a system changeover causes the new system to be used immediately as soon as it becomes operationaltoolbar to add a drop shadow to a .

a. parallel operationStandard
b. direct cutoverDrawing
c. smooth cutoverFormatting
d. pilot operationChart

10. The ____________ changeover method requires that both the old and the new information systems operate fully for a specified period.

a. direct rmat Data Series
b. lateral 3-D View
c. parallel operationFormat 3-D Pie Group
d. horizontal operation

Systems Analysis & Design Chapter 9 – True/False

Instructions: Circle T if the statement is true or F if the statement is false.

T	F	1. In the systems implementations phase, the system design specification serves as a blueprint for constructing the new system.
T	F	2. In a top-down program design, the overall objectives are defined and broken down into modules.
T	F	3. In a structure chart, an arrow with an empty circle is called a pointer control.
T	F	4. A module that performs many tasks and functions has a high degree of cohesion.
T	F	5. Pseudocode is the process of turning program logic into specific instructions that a computer system can execute.
T	F	6. It is recommended to consider a training plan after a system has been installed and tested.
T	F	7. ODBC is an industry-standard protocol that allows DBMSs from various vendors to interact and exchange data.
T	F	8. System changeover is the process of putting a new information system online and retiring the old one.
T	F	9. The phased operation changeover method involves implementing the complete new system at a selected location of a company.
T	F	10. A post-implementation evaluation assesses the overall quality of the information system, and verifies that it meets the specified requirements.

Chart Type