Test Bank -- Past Final Questions with pages and answer spaces removed


Fall 2003


Question 1 (25 points). System Development Environments

a. Draw the traditional picture of the 4(four) phases in the Systems Development Life Cycle (SDLC) including their names (5 points).

b. Define in a sentence or two, what each of the phases in your diagram means(4 points each >< 4 phases).

c. What part does the SDLC play in software development on the CSUSB campus? (4 points)


Question 2 (25 Points). Project Management

The table below describes the activities in the maintenance phase of a project. It shows the activities that must be completed before (preceding) each activity and the expected duration of each activity in days. Earliest and Latest times are left blank.

Activity

Preceding activities

Time (days)

Earliest Start

Earliest Completion

Latest Completion

Latest Start

1. Collect New Requirements

-

2

0

 

 

 

2. Redesign and update data base

1

2

 

 

 

 

3. Design new processing

2

1

 

 

 

 

4. Design new user interfaces

1

1

 

 

 

 

5. Reprogram user interface

4

1

 

 

 

 

6. Change processing code

3

2

 

 

 

 

7. Test Processing

6

1

 

 

 

 

8. Test user interface

5

2

 

 

 

 

9. Integrate and test

7,8

1

 

 

 

 

10. Acceptance tests

9

2

 

 

 

 


a. Draw a simple network diagram of the activities (10 points)


b. Suppose that activity 1 starts at time 0(zero), calculate the earliest time each activity can start and the earliest time it can finish using your diagram, and putting the times in the correct blank entries in the table.(5 points)


c. Calculate the latest time it can finish and the latest time each activity can start without delaying the completion of the whole project, put the times in the blank entries in the table.(5 points)


d. Mark or highlight the critical path on your network diagram above.(5 points)


Question 3 (25 Points). Identifying and selecting projects

How are projects identified and selected? In your answer mention the people who are typically involved and the kinds of decisions that they have to make. (Scoring: people: 9 points, decisions 9 points, process 7 points)


Question 4 (25 Points). Planning projects

Write one or two sentences explaining or defining each of the following terms as defined in the text book (5 points max each):


Business case

Tangible benefit

Technical feasibility

Walkthrough

EDI


Question 5 (25 points). System Requirements: Elicitation

a. Describe four(4) traditional methods of discovering system requirements (5 points each).

b. How have new development tools (eg CASE, Visual Environments, etc. ) and RAD methods changed the requirements elicitation? (5 points)


Question 6 (25 points). System Requirements: Use cases

Draw a simple use case diagram expressing the requirements for a system that handles grades for faculty and students. The diagram should show at least two (2) actors and at least three(3) use cases. It should only show communication associations between actors and use cases. No flowcharts! (Correct icons (5 points), correctly drawn links (5 points), good actor names (5 points), good use case names(5 points), good logic( 5 points)).


Question 7 (25 points). System Analysis

Draw a Data Flow Diagram (DFD) that fits the following system:

  

Students login with an email Id and password and the system provides access to the schedule for the current quarter. Students pick classes and enrol in them. Enrolments are recorded in rosters. The system formats rosters for each class and sends them to teachers. Teachers can drop students on their rosters.

The DFD should have more than one process, more than source/sink and more than one data store. The words in bold in the above box should appear in your diagram at least once. You may have to invent some names. (Scoring: correct symbols 5 points, correct data flows 5 points, good process names 5 point, good data storage names 5 points, good logic 5 points).


Question 8 (25 points). Data Requirements

Draw a simple UML class diagram (conceptual model) for a student registration data base that expresses the following facts:

A student can be enrolled in from 0 to 5 classes and a class has any number students enrolled in it. A class takes place in a unique room and in a unique time-slot. Each class is taught by a teacher. Each class is scheduled by a department, and each teacher works for a unique department

The words in bold above should appear in your diagram at least once. You may have to invent some names. No flowcharts! Hide attributes and operations. (Scoring: correct icons 5 points, correct associations 5 points, good names 6 points, correct multiplicities 6 points, replacing any many-to-many associations by classes correctly 3 points).


Question 9 (25 points). Alternative Strategies

Describe five(5) different sources of software components (5 points each). For each option: name it(1 point), say when this kind of organization is a good choice (2 points), and what internal staffing is needed to develop/support/integrate it (2 points).


Question 10 (25 points). Human Interfaces

a. What makes a good human interface? (essay 15 points)


b. In what ways (if any) are Web-based interfaces (using a browser) different to using paper-based interfaces? (essay 10 points)


Question 11 (25 points max). Implementation and operation phase.

a. Write a list of the activities that occur when implementing and operating a computer system (3 points each, only 7 activities earn credits ).


b. Which of these activities is most important? Why? (one or two sentences, 4 points)

----------------------------------------------------------------------------------------------

Fall 2004

Question 1 (25 points). The System Development Environment

(a) Name the five (5) components of an information system as presented in the text.(2 points per name, 10 max)

(b) Name the five (5) phases in the SDLC as presented in the text.(2 points per name, 10 max)

(c) How do these descriptions fit the CSUSB campus?(essay, 5 points)


Question 2 (25 Points). The Business Case

(a) Give three (3) reasons for undertaking a Systems Project (3 words/phrases, 2 points each = 6 points)

(b) Define Economic Feasibility (a sentence or two, 5 points)

(c) Name the two kinds of benefits(2 words, 2 points each, = 4points)

(d) Name at least 5 sections that should be found in a "Preliminary Investigation Report"(5 section headings >< 2 points = 10 points).


Question 3 (25 Points). Requirements and Use Cases

(a) Define the acronym JAD(3 words, 3 points) . Describe the purpose and participants in JAD (1 paragraph, 5 points).


(b) Draw a use case diagram using the UML for a student wanting to add a class at CSUSB. (7 points)


(d) Complete the following description of the use case above (10 points)


Name of Use Case: __________________________


Actor: ______________________________________

Description: The student adds a class.

Successful Scenario:

Precondition:

Postcondition:


Question 3 (25 Points). Enterprise Models

(a) Draw an ERD that shows that a Student can Enrol in any number of Classes, and a class has many Students Enrolled (5 points). Show multiplicities(5 points). (You may either use traditional diagrams or the UML).


(b) Draw a context diagram DFD for registration and enrolment at CSUSB with a single process 0 (5 points), external entities (5 points), and data flows (5 points) . (You may either use traditional diagrams or the UML)


Question 5 (25 points). Development strategies: Analysis & Design

(a) Describe two (2) well known examples of standard, alphabetic abbreviation codes (2 short phases or sentences, 5 points each = 10 points).


(b) Describe the advantages and disadvantages of outsourcing, (5 points), in-house development, (5 points)

and purchasing software. (5 points) (1 paragraph for each)


Question 6 (25 points). Project Planning and Management

The table below describes the activities developing a data base. It shows the activities that must be completed before (preceding) each activity and the expected duration of each activity in days. Earliest and Latest times are left blank.

Activity

Preceding activities

Time (days)

Earliest Start

Earliest Finish

Latest Finish

Latest Start

1. Interviews

Start

3

0

 

 

 

2. Draw ERD

1

2

 

 

 

 

3. Draw DFD

1

1

 

 

 

 

4. Develop Data Dictionary

1

3

 

 

 

 

5. Review ERD and DFD

2,3

1

 

 

 

 

6. Normalize data design

4

2

 

 

 

 

7. Construct a logical design

5,6

3

 

 

 

 

Done

9

-

 

 

 

 


(a) Draw a simple activity or network diagram of the activities. Use either the traditional CPM notation or an UML activity diagram (10 points)


(b) Suppose that activity 1 starts at time 0(zero), calculate the earliest time each activity can start and the earliest time it can finish using your diagram, and putting the times in the correct blank entries in the table.(5 points)


(c) Calculate the latest time it can finish and the latest time each activity can start without delaying the completion of the whole project, put the times in the blank entries in the table.(5 points)


(d) Mark or highlight the critical path on your network diagram above.(5 points)


Question 7 (25 points). Data Design

Here is a slogan that describes Third Normal Form:

              The ____, the whole _____, and nothing but the _______.


(a) What word is deleted above? _______________(3 points)

(b) What does this word mean in a data base?(short paragraph, 7 points).



(c) Here is a quantified data base design with tables/entities shown as boxes and relations/keys by associations. The numbers show average multiplicities. {N=___} shows the expected number of entities. Fill in the blanks (______). (5 points a blank, 15 points total)

ole.gif

Question 8 (25 points). Human Computer Interfaces

(a) What makes a good human interface? (essay 15 points)


(b) In what ways (if any) are Web-based interfaces (using a browser) different to using paper-based interfaces? (essay 10 points)


Question 9 (25 points). Systems Architecture

Use UML deployment diagrams with nodes+components to describe the following system architectures:

(a) main frame, (b) stand alone, (c) file sharing, (d) client/server, (e) 3 tier. (5 points for each diagram)

 

Question 10 (25 points). Systems Operations

(a) Name and describe the four(4) kinds of maintenance mentioned in the book( 1 pt for the name, 4 points for a short description).

(b) Describe a typical procedure for handling a user change request. (5 points max, 1 point per step)

Question 11 (25 points). Systems Implementation

(a) Name and describe four(4) changeover processes (1 point for each name, 3 points for each description, 16 total).

(b) How do the four changeover methods differ in terms of cost and risk? (draw a diagram, 4 points)

(c) Name one(1) form found at CSUSB(1 point). Where is it used(4 points).


----------------------------------------------------------------------------------------------

Fall 2005

Question 1 (25 points). The System Development Environment

(a) Name the five (5) types of components of an information system in the text.(2 points per name, 10 max)

(b) Name the five (5) phases in the SDLC as presented in the text.(2 points per name, 10 max)

(c) How do these descriptions fit the CSUSB campus?(essay, 5 points)

 

Question 2 (25 Points). The Business Case

(a) Give three (3) reasons for undertaking a Systems Project (3 words/phrases, 2 points each = 6 points)

(b) Name the four(4) Fact-Finding activities (2 or 3 words each, 1 points each, 4points)

(c) Define Technical Feasibility (a sentence or two, 5 points)

(d) Name at least 5 sections that should be found in a "Preliminary Investigation Report"(5 section headings >< 2 points = 10 points).

 

Question 3 (25 Points). Requirements and Use Cases

(a) Define the acronym RAD(3 words, 3 points) . Describe one advantage and one disadvantage of RAD (2 phrases/sentences >< 2 points, 4 points).

 

 

(b) Draw a use case diagram using the UML for when a student drops a class at CSUSB. (7 points)

 

(d) Complete the following description of the use case above (omitting all alternative scenarios) (11 points)

 

Name of Use Case: __________________________

 

Actor: ______________________________________

Description: A student drops a class.

Successful Scenario:

 

Precondition:

 

 

 

Postcondition:

 

Question 4 (25 Points). Enterprise Models: ERD + DFD

(a) Draw an ERD that shows that a Student can be Enrolled in any number of Classes, and a Class can have many Students Enrolled (5 points). Show multiplicities(5 points). (You may either use traditional diagrams or the UML).

 

(b) Draw a context diagram DFD for registration and enrolment at CSUSB with a single process 0 (5 points), external entities (5 points), and data flows (5 points) . (You may either use traditional diagrams or the UML)

 

Question 5 (25 points). Development strategies

(a)What do these acronyms mean? (9 words, 9 points)

 

                                                         TCO _________________________________________________________

 

                                                         ROI _________________________________________________________

 

                                                         NPV _________________________________________________________

 

 

(b) These are all part of analyzing the __________________ and __________________ of a system. (Fill in blanks, 2 words >< 1 point , 2 points)

 

(c) Describe the advantages and disadvantages of outsourcing, (1 paragraph, 5 points), in-house development, (1 paragraph, 5 points) and purchasing software. (1 paragraph, 4 points)

 

Question 6 (25 points). Project Planning and Management

The table below describes the activities/tasks involved in adding a new user requirement to an existing system. It shows the numbers of activities that must be completed before and after each activity and the expected duration of each activity in days.

Activity/Task

Duration

(days)

Before

After

1. Develop a use case

1

Start

2, 3, 4, 5

2. Design the user interface

2

1

6

3. Plan changes to data base

1

1

6

4. Design tests

2

1

10

5. Develop changes to business rules

1

1

7

6. Validate new data base vs user interface

1

2, 3

7, 8

7. Develop pages using PHP

3

5, 6

9

8. Modify data base and migrate data

4

6

9

9. Integrate pages and data base

1

7, 8

10

10. Test

4

4, 9

Terminate

 

(a) Draw a simple activity or network diagram of the activities/tasks. Use either the traditional CPM notation or an UML activity diagram (10 points)

 

(b) Suppose that activity 1 starts at time 0(zero), calculate the earliest time each activity can start and the earliest time it can finish using your diagram.(6 points)

 

(c) Calculate the latest time it can finish and the latest time each activity can start without delaying the completion of the whole project, putting the figures on your diagram.(6 points)

 

(d) Mark or highlight the critical path on your network diagram.(3 points)

 

Question 7 (25 points). Data Design

Here is a slogan that describes Third Normal Form:

              The ____, the whole _____, and nothing but the _______.

 

(a) What word is deleted above? _______________(3 points)

(b) What does this word mean in a data base?(short paragraph, 7 points)

 

 

ole1.gif

(c) Here is a quantified data base design with tables/entities shown as boxes and relations/keys by associations. The numbers show actual and average multiplicities. {N=___} shows the expected number of entities. Fill in the blanks (______). (5 points a blank, 15 points total)

Question 8 (25 points). Human Computer Interfaces

(a) Name six(6) input devices (2 points per name, 12 points max)

 

(b) Name five(5)user interface controls (1 point per name, 5 points)

 

(c) Describe two(2) data validation checks (2 short paragraphs, 4 points each, 8 points)

 

Question 9 (25 points). Systems Architecture

Use UML deployment diagrams with nodes & artifacts to describe the following system architectures:

(a) main frame, (b) stand alone, (c) client/server with a thin client, (d) client/server with a fat client, (e) 3 tier client/server. (5 points for each diagram)

 

Question 10 (25 points). Systems Operations

(a) Name and describe the four(4) kinds of maintenance mentioned in the book( 1 pt for the name, 4 points for a short description).

(b) Describe a good procedure for handling a user change request. (5 points max, 1 point per step)

 

Question 11 (25 points). Systems Implementation

(a) Name and describe four(4) changeover processes (1 point for each name, 3 points for each description, 16 total).

(b) How do the four changeover methods differ in terms of cost and risk? (draw a diagram, 4 points)

(c) Name one(1) form found at CSUSB(1 point). Where is it used?(4 points).

 

 

----------------------------------------------------------------------------------------------

Fall 2006

Question 1 (25 points). System Development Environments

a. List the names of the phases in the traditional Systems Development Life Cycle (SDLC) (4 points).

b. Define in a sentence or two, what is done in each of these phases(16 points each).

c. What is different about an agile life cycle? (5 points)

 

 

Question 2 (25 Points). Project Management

The table below describes the activities in the maintenance phase of a project. It shows the activities that must be completed before (preceding) each activity and the expected duration of each activity in days.

Activity

Preceding activities

Duration (days)

1. Collect new requirements

-

2

2. Redesign and update data base

1

2

3. Develop and test new processing

2

4

4. Develop and test new user interfaces

1

5

5. Integrate and test

3 and 4

1

6. Acceptance tests

5

2

 

a. Draw a UML activity diagram of the process. You should abbreviate activity names to fit them on the page. (start 1 point + activities 5 points + fork/join 2 points + arrows 5 points + finish 1 point = 14 points)

b. Add the durations of the activities to your diagram. Suppose that activity 1 starts at time 0(zero), calculate the earliest time each transition (arrow) can happen using your diagram.(4 points)

c. Calculate the latest times without delaying the completion of the whole project. (4 points)

d. Mark or highlight the critical path on your diagram.(3 points)

 

Question 3 (25 Points). Systems

a. Describe 3 different techniques used in fact finding ( 2 sentences each, 5 points * 3 = 15 points).

b. Name the 5(five) types of components in a system ( 1 points * 5 = 5 points).

c. Describe a common way that each type of component is changed ( 1 points * 5 = 5 points).

 

Question 4 (25 Points). Data Flows

Draw a level 0 Data Flow Diagram (DFD) that fits the following system:

  

Students login with an email Id and password and the system provides access to the schedule for the current quarter. Students pick classes and enrol in them. Enrolments are recorded in rosters. The system formats rosters for each class and sends them to teachers. Teachers can drop students on their rosters.

The DFD should have more than one process, more than one source/sink and more than one data store. The words in bold in the above box should appear in your diagram at least once. You may have to invent some names. (Scoring: correct symbols 5 points, correct data flows 5 points, good process names 5 points, good data storage names 5 points, good logic 5 points).

 

Question 5 (25 points max). Process Details

When I hand graded work back to a large class I often fold it so that only the student's name is visible and sort the work so that the names are in alphabetical order. You can find your work rapidly by using the "divide-and-conquer" binary search algorithm: You divide the work into two halves and look at the piece of work at the division. If this your work you remove it and hand the rest (unchanged) to the next person. Otherwise if it's name is before your name in the alphabetic sequence then you repeat the same procedure on the second half. Else the name is after yours and you repeat the same binary search procedure to the first half of the work.

 

Draw a correct UML activity diagram for this process. Points are for using the UML notation correctly, an informal flowchart can not earn more than 15 points. (start 3 points, finish 3 points, actions 7 points, decisions 4 points, conditions 4 points, arrows 4 points).

 

Question 6 (25 points). Developing Requirements

a. What does JAD mean (one paragraph description, 7 points)

b. What does RAD mean (one paragraph description, 7 points)

c. How does an iteration differ from a prototype? (one or two sentences, 7 points)

d. How does a non-functional requirement differ from a functional requirement? (one or two sentences, 4 points)

 

Question 7 (25 points). Use cases

Write one use case from your project (10 points for matching project, 15 points for correct format and information)

 

Question 8 (25 points). The Business Case and Feasibility

What information should you prepare to convince management that a project is worth doing (one page essay or list, 25 points)

 

Question 9 (25 points). Data Requirements

Draw a simple UML class diagram (conceptual model) for a student registration data base that expresses the following facts:

A student can be enrolled in many classes and a class has any number students enrolled in it. A class takes place in a unique room and in a unique time-slot. Each class is taught by a teacher. Each class is scheduled by a department, and each teacher works for a unique department

The words in bold above should appear in your diagram at least once. You may have to invent some other names. No flowcharts! Hide attributes and operations. (Scoring: correct icons 5 points, correct associations 5 points, good names 6 points, correct multiplicities 6 points, replacing any many-to-many associations by classes correctly 3 points).

 

Question 10 (25 points). Alternative Strategies

a. Describe three (3) different ways of obtaining a needed software component. For each one, include the reasons for doing it that way. (7 points each way, description 3, reasons 4)

b. How do you discover the new software components that you need? (2 or 3 reasons, 4 points)

 

Question 11 (25 points). Input and Output Options

I've just had to input the answers to a series of mock GRE exam answers into a spreadsheet. There were 20 students, and 48 multiple guess questions. Each answer should have been one of: A, B, C, D, or E. There are therefore about 1,000 answers to input and check. It took me an hour to put them into a spreadsheet which calculated the percentage of correct answers. We do this each year as part of the CSci Department's Outcomes Assessment procedures.

a. Invent and describe a better procedure (text and diagrams, 15 points).

b. List the costs and benefits of your proposal (2 or 3 sentences/list 9 points)

 

Question 12 (25 points max). Data Design

a. Describe 3 different types of code for data elements(3 points *3). Include an example of each code (2 points * 3)

b. What is a prime key and a foreign key (5 points for each definition).

 

Question 13 (25 points max). Systems Architecture and Deployment

Draw UML deployment diagrams showing how the information systems at CSUSB have evolved over the last 20 or so years (correct UML notation = 15 points, correct history=10 points)

 

Question 14 (25 points max). Implementation and operations.

a. Write a list of some of the many activities that occur when implementing and/or operating a computerized system (3 points each, only 7 activities earn credits ).

b. Describe 2(two) different cut-over strategies: one that is high cost + low risk, and the other high risk+low cost (one sentence each, 4 points)

 

Final Fall 2007

Question 1 (25 points max). System Development Environments

a. Name the 4(four) traditional phases in the Systems Development Life Cycle (SDLC) (4 points).

b. Define in a sentence or two, what each phase accomplishes (4 points each >< 4 phases).

c. What actually happened when CSUSB developed CMS? (5 points)




Question 2 (25 points max). Project Planning and Management

The table below describes the activities developing a data base. It shows the activities that must be completed before (preceding) and after(following) each activity and the expected duration of each activity.

Activity

Preceding #

Following #

Duration (days)

1. Interviews

Start

2, 3, 4

3

2. Draw ERD

1

5

2

3. Draw DFD

1

5

1

4. Develop Data Dictionary

1

6

4

5. Review ERD and DFD

2,3

7

1

6. Normalize data design

4

7

2

7. Construct a logical design

5,6

End

3

So the first activity must be "interviews" and this can be followed by either drawing ERDs, DFDs, or developing a data dictionary.


(a) Draw a simple activity or network diagram of the activities/tasks. Use an UML 2.0 activity diagram with fork/joins (10 points)


(b) Suppose that activity 1 starts at time 0 (zero), calculate the earliest time each transition(arrow) can happen using your diagram. Put the earliest time on the left of the arrows. (6 points)


(c) Calculate the latest time transitions can occur without delaying the completion of the whole project, putting the figures the other side of the arrows.(6 points)


(d) Mark or highlight the critical path.(3 points)




Question 3 (25 points max). Systems

(a) Name the five (5) types of component in an information system (2 points per name, 10 max)

(b) Describe "Feed Forward" and "Feed Back". (10 points)

(c) Give an example in your project or from a field trip of Feedback(5 points)



Question 4 (25 points max). Systems Architecture and Deployment

Name your team's project and draw its systems architecture. For full credit you must use a UML 2.0 Deployment diagram and it must match the description in your team's project -- even if it did not contain a UML deployment diagram.



Question 5 (25 Points max). Data Flow Diagrams

Use diagrams to illustrate a context DFD (5 points), a level 0 DFD (5 points) and a level 1 DFD(5 points) plus the relationships between them(5 points). To earn the last 5 points your diagrams should use the Gane and Sarson notation correctly.



Question 6 (25 points max). Alternative Strategies

(a) Name 5(five) different ways of obtaining or creating a needed piece of software for a new system(1 point each, 5 points)

(b) For each way describe the good and bad points of that strategy (4 points >< 5 = 20 points)



Question 7 (25 points max). The Business Case and Feasibility

(a) Give three (3) reasons for undertaking a Systems Project (3 words/phrases, 2 points each = 6 points)

(b) Define Economic Feasibility (a sentence or two, 5 points)

(c) Name the two kinds of benefits(2 words, 2 points each, = 4points)

(d) Explain what we mean by "the Present Value of a cash flow"and how we use it. (1 paragraph, 10 points).



Question 8 (25 points max). Input and Output Options

Essay The cell phone is the peripheral of the future. (Grading holistic and subjective, I expect a minimum of 3 paragraphs filling the rest of this page...)




Question 9 (25 points max). Data Design

(a) In a relational data base what is a table (5 points) and a key? (5 points)

(b) Define and describe: Candidate key (5 points), Prime key (5 points), Foreign key (5 points), and secondary Key (5 points)



Question 10 (25 points max). Data Requirements

Draw a conceptual model or ERD of either a fragment of the CMS system or your team's project. You can omit some details. To earn full credit you should either use the UML class diagram or the Chen ERD notation (4 points), match the system modeled (5 points), and include examples of: at least three entities (4 points), some relations (4 points), some attributes (4 points), and multiplicities (4 points).



Question 11 (25 points max). Process and Data Details

Draw an activity diagram for normalizing the data in system. You can omit low-level details. To earn full credit the diagram must use the UML 2.0 notation correctly.



Question 12 (25 points max). Requirements

(a) Give examples of: a typical high level functional requirement and a typical high level nonfunctional requirement (5 points each, 10 points max)

(b) How do you refine a functional requirement into a something that is more detailed prior to software development? (5 points)

(c) How do you refine a nonfunctional requirement into a something that is more detailed prior to software development? (5 points)

(d) The stakeholder's require you to use a particular operating system to implement the software in the system. Is this a functional or a non-functional requirement? Why? (5 points)



Question 13 (25 points max). Use cases

Write a fully dressed use case from your team's project. For full credit it should match or refine a use case in the project (10 points) and use a template like the fully dressed use case provided in this course(15 points). Draw no diagrams (10 point penalty)



Question 14 (25 points max). Implementation and operations.

(a) Name and describe four(4) kinds of maintenance( 1 pt for the name, 4 points for a short description).

(b) Describe a technique for moving from the old system to the new system which is cheap and risky. (5 points)

Final Questions 2008

Question 1 (25 points max). System Development Environments

a. Describe the phases in a traditional Systems Development Life Cycle (SDLC) (Essay. at least 5 phases, 3 points each, 15 points total).

b. When is rigid phased approach like this a good plan? Describe two different situations where you should use such an SDLC. (two situations * 5 points , 10 points max




Question 2 (25 points max). Project Planning and Management

The table below describes the activities in a simple Discounted Cash Flow analysis. It shows the activities that must be completed before (preceding) and after(following) each activity and the expected duration of each activity.

Activity

Preceding #

Following #

Duration (Mins)

1. Tabulate Costs

Start

4, 5

40

2. Tabulate Benefits

Start

5

50

3. Calculate discounts

Start

6

10

4. Calculate total investment

1

8

10

5. Calculate cash flows

1,2

6

10

6. Calculate discounted cash flows

3,5

7

10

7. Calculate Net Present Value

6

8

10

8. Calculate Return On Investment

4,7

End

5



(a) Draw a simple activity or network diagram of the above activities/tasks. Use an UML 2.0 activity diagram with fork/joins (10 points)


(b) Suppose that activity 1 starts at time 0 (zero), calculate the earliest time each transition(arrow) can happen using your diagram. Put the earliest time on the left of the arrows. (6 points)


(c) Calculate the latest time transitions can occur without delaying the completion of the whole project, putting the figures the other side of the arrows.(6 points)


(d) Mark or highlight the critical path.(3 points)




Question 3 (25 points max). Systems

(a) Name the five (5) types of component in an information system (2 points per name, 10 max)

(b) Describe the four(4) levels in a typical mid-size enterprise. (4 levels * 2 points = 8 points)

(c) Give an example of Feedback in your project or from a field trip(4 points for eaxmple, 3 points for source, 7 points)



Question 4 (25 points max). Systems Architecture and Deployment

Name your team's project (5 points) and draw its systems architecture. For full credit you must use a UML 2.0 Deployment diagram (10 points) and it must match the description in your team's project (10 points) -- even if your team used a different notation.



Question 5 (25 Points max). Data Flow Diagrams

Use diagrams to illustrate a context DFD (4 points), a level 0 DFD (4 points) and a level 1 DFD(4 points) plus the relationships between them(4 points). Your DFDs must not break any DFD rules (4 points). To earn the last 5 points your diagrams should use the Gane and Sarson notation.



Question 6 (25 points max). Alternative Strategies

(a) Name 5(five) different ways of obtaining or creating a needed piece of software for a new system(1 point each, 5 points)

(b) For each way describe the good and bad points of that strategy (4 points >< 5 = 20 points)



Question 7 (25 points max). The Business Case and Feasibility

(a) Give three (3) business reasons for undertaking a Systems Project (3 words/phrases, 2 points each = 6 points)

(b) Define Schedule Feasibility (a sentence or two, 5 points)

(c) Name the two kinds of benefits(2 words, 2 points each, = 4points).

(d) Define a Cash-flow (1 sentence, 4 points).

(d) Explain what we mean by "the Present Value of a cash flow"and how we use it. (1 paragraph, 6 points).



Question 8 (25 points max). Input and Output Options

Essay Give a one page history of output devices starting with the line printer and ending with the iPod (Grading holistic and subjective, I expect a minimum of 3 paragraphs filling the rest of this page...)




Question 9 (25 points max). Data Design

Define and give examples from your project the following concepts: (1) Data Element, (2) Data Record, (3) Coding, (4) Table, (5) Prime Key. (Definition 3 points + Example 2points = 5 points each * 5 terms = 25 points)



Question 10 (25 points max). Data Requirements

Draw a conceptual model (ERD) of your team's project. You can omit some details. To earn full credit you should either use the UML class diagram or the Chen notation (4 points), match the system modeled (5 points), and include examples of: at least three entities (4 points), some relations (4 points), some attributes (4 points), and multiplicities (4 points).



Question 11 (25 points max). Process Details

Draw an activity diagram for algorithm of the Critical Path Method. You can omit low-level details. Correct algorithm (12 points) To earn full credit the diagram must use the UML 2.0 notation correctly (13 points).



Question 12 (25 points max). Requirements

(a) Give examples of: a typical high level requirement that has a functional and a nonfunctional part (5 points). Identify the two parts (5 points each, 15 points max)

(b) Refine your nonfunctional requirement (above) into a something that is more detailed and useful (5 points)

(c) Your stakeholders require the system to operate 24/7 (every hour, every day). Is this a functional or a non-functional requirement? Why? (5 points)



Question 13 (25 points max). Use cases

Write a fully dressed use case from your team's project. For full credit it should match or refine a use case in the project (10 points) and use a template like the fully dressed use case provided in this course(15 points). Draw no diagrams (10 point penalty)



Question 14 (25 points max). Implementation and operations.

(a) Name and describe four(4) kinds of maintenance( 1 pt for the name, 4 points for a short description).

(b) Describe a technique for moving from the old system to the new system which is expensive but not risky. (5 points)

CS372 Fall 2009 Final Exam (Version A) Print your name at the top of the next page

 (200 points maximum, 40% of total for class, 110 minutes)

You may use a calculator and a single piece of 11><8.5 inch paper with notes on both sides. No wireless communication and no computers. Put answers on blank sheets of paper. You can write on both sides. Start each question on a new page and identify which question you are answering. Do not put your name on your answers. Instead write your Coyote Student Id in the top right hand corner of the papers. Diagrams don't have to be tidy but correctness and spelling is important. Partial credit is given for incomplete answers and working -- cross out but do not erase working. Start each question on a new page and identify it. An answer can continue over the page. There are 14 questions. Each is worth 25 points maximum. Attempt 8 questions only. Do your best question first. More than 8 answers will not count. List the numbers of the questions you want graded below. I will ignore questions that are not listed in the boxes below:

Qn #

___

 ___

 ___

___

 ___

 ___

 ___

 ___

Score

 

 

 

 

 

 

 

 

Question 1 (25 points max). System Development Environment

a. Describe the phases in a traditional Systems Development Life Cycle (SDLC) (Essay. at least 5 phases, 3 points each, 15 points total).

b. When is a rigid phased approach like this a good plan? Describe one situation where you should use such an SDLC. (paragraph, 5 points )

c. When is this approach not a good plan? Describe a common problem (one sentence, 2 points)

d. How does an iterative method avoid the above problem with the rigid SDLC? (short paragraph, 3 points)


Question 2 (25 points max). Project Planning and Management

The table below describes the activities in interviewing someone. It shows the activities that must be completed before (preceding) and after(following) each activity and the expected duration of each activity.

Activity

Preceding #

Following #

Duration (Mins)

1. Get name and phone number

Start

2

25

2. Phone and make an appointment

1

3

15

3. Email confirmation

2

5

5

4. Prepare questions

Start

5

40

5. Interview

3, 4

6, 7

30

6. Email "thank you"

5

End

5

7. Review notes

5

8

20

8. EMail follow up question

8

End

10

(a) Draw a simple activity or network diagram of the above activities/tasks. Use a correct UML 2.0 activity diagram with forks and joins (10 points)

(b) Suppose that the process starts at time 0 (zero), calculate the earliest time each transition(arrow) can happen using your diagram. Put the earliest time on the left of the arrows. (6 points)

(c) Calculate the latest time transitions can occur without delaying the completion of the whole project, putting the figures the other side of the arrows.(6 points)

(d) Mark or highlight the critical path.(3 points)


Question 3 (25 points max). Systems

(a) Name the five (5) types of component in an information system (2 points per name, 10 max)

(b) "Production" and " Information Technology" are two functions found in a typical manufacturing enterprise. Name four (4) other functions (4 functions * 2 points = 8 points)

(c) Name four typical parts or functions of an "Information Technology" department (2 points each, 7 points max)                                                                        

Question 4 (25 points max). Systems Architecture and Deployment

Name your team's project (5 points) and draw its systems architecture. For full credit you must use a correct UML 2.0 Deployment diagram (10 points) and it must match the description in your team's project (10 points) -- even if your team used a different notation.

 

Question 5 (25 Points max). Data Flow Diagrams

Use diagrams to illustrate a context DFD (4 points), a level 0 DFD (4 points) and a level 1 DFD(4 points) plus the relationships between them(4 points). Your DFDs must not break any DFD rules (4 points). To earn the last 5 points your diagrams should use the Gane and Sarson notation.

 

Question 6 (25 points max). Alternative Strategies

(a) Name and describe 4 (four) different ways of obtaining or creating a needed piece of software for a new system(5 points each, 20 points max)

(b) How did your team plan to obtain some software for its project ? ( 5 points).

 

Question 7 (25 points max). The Business Case and Feasibility

(a) Give three (3) business reasons for undertaking a Systems Project (3 words/phrases, 2 points each = 6 points)

(b) Define Economic Feasibility (a sentence or two, 5 points)

(c) Name two kinds of costs (2 words, 2 points each, = 4points).

(d) Define a Cash-flow (1 sentence, 4 points).

(e) Explain what PV=(1+r/100)^(-t)*CF[t]

means in Cost Benefit Analysis. (1 short paragraph, 6 points).

 

Question 8 (25 points max). Input/Output

Essay Give a one page history of output devices used over the last 30 years at a typical large organization like CSUSB (Grading holistic and subjective, I expect a minimum of 3 paragraphs filling a page...)

 

Question 9 (25 points max). Data Design

Define and give examples from your project the following concepts: (a) Data Element, (b) Data Record, (c) Table, (d) Prime Key, (e) Foreign Key. (Definition 3 points + Example 2 points = 5 points each * 5 terms = 25 points)

 

Question 10 (25 points max). Data Requirements

Draw a conceptual model (ERD) of your team's project. You can omit some details. To earn full credit you should either use the UML class diagram or the Chen notation (4 points), match the system modeled (5 points), and include examples of: at least three entities (4 points), some relations (4 points), some attributes (4 points), and multiplicities (4 points).

 

Question 11 (25 points max). Process Details

Draw a UML 2.0 activity diagram for the algorithm for Cost-Benefit Analysis. You can omit low-level formulas. (correct algorithm -- 12 points, correct UML 2.0 13 points).

 

Question 12 (25 points max). Requirements

(a) Give an examples of a typical high level requirement that contains both a functional requirement and a quality requirement(5 points).

(b) Identify the two parts (5 points each part, 10 points max)

(c) Your stakeholders require the system to operate 24/7 (every hour, every day). Is this a functional or a quality requirement? Why? (5 points)

(d) How does your systems architecture change to support 24/7 operations? (one paragraph, 5 points)

 

Question 13 (25 points max). Use cases

Write any fully dressed use case from your team's project. For full credit it should match or refine a use case in the project (10 points) and use a template like the fully dressed use case provided in this course(15 points). Draw no diagrams (10 point penalty)

 

Question 14 (25 points max). Implementation and operations.

(a) Describe a technique for moving from the old system to the new system which is cheap but risky. (5 points)

(b) Name and describe four(4) kinds of maintenance( 1 pt for the name, 4 points for a short description * 4 = 20 points).