Name _________________________ Date ___________

Systems Analysis & Design Excel 2002 ProjectChapter 323 – - Multiple Choice

Instructions: Circle the correct response.

1. Which of the following activities areis not includeds in the systems analysis phase?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, ____________ planning is the process of identifying long-term organizational goals, strategies, and resources.

a. FeasibilityDeductions
b. Requirements ModelingStrategicNo deductions
c. Development StrategiesSystems#REF!
d. Enterprise ModelingITF5

2. The systems analysis skill that will enable you to identify a problem, evaluate the key elements, and develop a useful solution is calledIn a SWOT analysis, the S stands for Use the ____________ skills functioncommand? when the value you want to assign to a cell is dependent on a logical test.

a. sSystem ystemASSIGNssign
b. interpersonalSoftwareIFf_THENhen_ELSElse
c. analyticalStrength WHAT IFhat_If
d. enterpriseStudyIFIf

3. TheIn A SWOT analysis, the O stands forA cell reference of $B17 is a(n) ____________ phase using the RAD technique ends when the team agrees on key issues and obtains authorization to continue cell reference.

a. User DesignObjectabsolute
b. ConstructionOperationrelative
c. Requirements PlanningObjectionsmixed
d. CutoverOpportuniesinvalid

4. During the Stakeholders____________ phase using the RAD technique, users interact with systems analysts and develop models and prototypes that represent all systems processes, outputs, and inputs. in a company are which of the following? You can use the Split command to split a window into ____________.

a. InputCommunitytwo horizontal panes
b. OutputSupplierstwo vertical panes
c. ConstructionEmployeesfour panes
d. User Designall of the above of the above

5. AThe starting point for a project is called a(n)If cell E8 contains the label, Qtr 4, and you select cell E8 and then drag the fill handle to the left, then cells D8, C8, and B8 will contain the labels ____________ diagram visually represents the interaction between users and the information system.

a. use casesystems requestQtr 5, Qtr 6, Qtr 7
b. CASEfeasibility studyQtr 1, Qtr 2, Qtr 3
c. FDDkey performance indicatorQtr 3, Qtr 3, Qtr 1
d. UMLproject definition#REF!

6. A(n)The coding of data to keep it safe from unauthorized users is called ___________ diagram shows the timing of transactions between objects as they occur.

a. locking
b. interlockinghiding

c. sequenceshading
d. TCOencryption

7. WIn a(n) ___________ hich structure, some people have more influence or knowledge than appears on an organizational chartof the following is not an external factor that will affect a projecten 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. Zachman FrameworkCustomerscross hair
b. informalExisting Systemsarrow
c. HawthorneEconomyblock plus sign
d. formalTechnologysplit double arrow

To freeze worksheet titles use the ___________ command on the ___________ menu.

a. Split, Format
b. Split, Window

c. Freeze Panes, Window
d. Freeze Panes, Tools

8. In an interview, Excel displays the error message ____________ tfeasibility questions encourage spontaneous and unstructured responsesmeans that a proposed system will be used effectively after it has been developedo indicate when there is a cell reference error.

a. Open-endedrational######
b. Closed-endedTechnical******
c. Range-of-responseEconomic#REF!
d. FeasibilityPreliminaryerror

9. A You can use the Shadow button on the ____________ is a document containing a number of standard questions that can be sent to many individualscan be measured in dollarstoolbar to add a drop shadow to a cell.

a. Tangible Bbenefits Diagram efitsStandard
b. Zachman DiagramIntangible benefitsDrawing
c. Hawthorne DiagramProjected salesFormatting
d. sFuture growthurveyChart

10. To To ensure that a sample is balanced geographically, use a change the elevation of a selected pie chart, click ____________ feasibility means that the projected benefits of a proposed system outweigh the estimated costson the Chart menu.

a. systematic sampleOperational Format Data Series
b. stratified sampleTechnical3-D View
c. random sampleEconomicFormat 3-D Pie Group
d. acute sample

Systems Analysis & Design Chapter 3 – True/False

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

T	F	1. The deliverable, or end product of the systems analysis phase is a working prototype that is ready for testing.
T	F	2. JAD is a popular fact-finding technique that brings users into the development process as active participants.
T	F	3. The JAD approach is a relatively inexpensive approach, and easily handles large groups, even for small projects.
T	F	4. The construction phase using a RAD technique focuses on program and application development.
T	F	5. One disadvantage to RAD is that it stresses the mechanics of the system itself, and does not emphasize a company’s strategic business needs.
T	F	6. The primary advantage to RAD is that systems can be developed more quickly with significant cost savings.
T	F	7. A functional decomposition diagram is a time based representation of a business process.
T	F	8. Both direct and indirect costs contribute to the Total Cost of Ownership (TCO).
T	F	9. When performing an interview, it is best to ask leading questions to help the person feel more comfortable, and make the interview flow better.
T	F	10. The process of listening to verbal communications and noticing nonverbal communications during an interview is called engaged listening.

DiscretionaryC

hart Type