Welcome to Modeling | Modeling News | Modeling Videos | Latest Modeling Trends


Friday, September 14, 2007

Interleaving Modeling and Writing Activities in Systems Analysis and Design

A Systems Analysis and Design course should develop both the technical as well as interpersonal skills of each student. Each student must be able to develop and use the various lifecycle models and be able to communicate with end users through these models. By creating interleaved modeling and writing assignments within the Systems Analysis and Design course both objectives can be met. This paper presents a series of integrated modeling and writing assignments-used in a Systems Analysis and Design course-that have been developed to enhance both the technical and interpersonal skills of an IS student.

The Systems Analysis and Design course within Information Systems curriculum provides the student with the skills necessary to analyze and design information systems (Gorgone, Davis et al. 2003). One of the major objectives of this course is to have the student develop and use each of the models-either structured or OO-in the Systems Development Life Cycle.

A second objective is to make each student aware of the interpersonal skills necessary for successful systems development (Guinan and Bostrom 1986; Gorgone, Davis et al. 2003). In particular, the Systems Analysis and Design course should emphasize "the factors for effective communication and integration with users" (Gorgone, Davis et al. 2003, pg. 29). In fact, the models developed in the SDLC are rendered useless unless "effective communication patterns are used by developers and users".

These two objectives-model development and interpersonal/communication skills-are met simultaneously through series of assignments developed for a Systems Analysis and Design course. In the course, the student is required-individually and then as part of a group-to develop a series of SDLC models and write a corresponding memo that explains the purpose, use, and their understanding of each model. This article describes how these assignments are used to meet these two learning objectives simultaneously.

In a typical Systems Analysis and Design course, topics range from planning to design and development activities, including the implementation of a database or other information system. However, this course is taught over a seven week period so only the activities within the planning, analysis, and design stages are addressed. The focus of the course is on the first objective-the development and use of the models in the structured approach-however, the course is regarded as a writing intensive course by the University; therefore a significant writing component must be incorporated into the course.

Each student is given a series of four models to develop throughout the course. The models are for economic feasibility (return on investment, breakeven analysis, and net present value), data modeling (an entity-relationship diagram), process modeling (a dataflow diagram), and database design (a database schema). As part of each modeling assignment, the student creates a two page memo that explains the purpose, use, and specifics of the corresponding model in their own words. These individual modeling and memo-writing assignments are done using a straightforward case adapted from a textbook (Satzinger, Jackson et al. 2004). Each assignment is then graded and returned to the student.

In order to assess the learning from the initial assignment, the same assignment, using a more complex case study (similar to ABC Churchb is completed by student groups; typically 2-3 students per group. Each student group develops the model, and writes a corresponding memo, for economic feasibility, data modeling, process modeling, and database design. In this way, concept learning is assessed.

1.The opening paragraph of the memo should state-in one to two sentences maximum-the recommendation on proceeding with the project. This recommendation needs to be clearly stated and include a statement on the number of years that the project should remain feasible; it may be less than the seven years.

2. The second paragraph justifies of the recommendation using the results of the feasibility calculations. This is an assessment of the student's knowledge of what ROI, NPV, and BEA indicate.

3. The third paragraph incorporates the intangible benefits of the project. In class, it is noted that intangible benefits are likely to be as important as the tangible benefits. The intangible benefits are to be used as further evidence toward the recommendation. This assesses the student's use of qualitative information in making a recommendation.

4. The final paragraph includes a list of action items (modeling activities) that need to be performed based on their recommendation. In this paragraph, the student's knowledge of the next steps within the SDLC is tested because the action items describe what models need to be developed next.

Note the benefits and costs in the individual assignment are designed so that the breakeven point occurs within the seven year period and the final NPV and ROI are positive. However, in the group assignment, the benefits and costs are modified so that the breakeven point is reached within the seven years, but the NPV and ROI at the end of seven years are negative; this forces the student group to consider a shorter project life recommendation.

2.2 Assignment 2: Entity-Relationship Diagram (ERD)

The second assignment requires the development of an Entity-Relationship Diagram (ERD). After developing the ERD, another memo, addressed to a "CEO-level" client about their development efforts surrounding the ERD is created.

1. The opening paragraph describes the purpose and role of the ERD within the development process. The student assumes that the client knows very little about database design and data modeling therefore it is important to state clearly the purpose and need for the ERD.

2. The second paragraph specifies the entities specified in the ERD and the rationale for collecting data on these entities.

3. The third paragraph describes the relationships that exist between the entities. The student must describe what the relationship is and its significance in the problem.

4. In the fourth paragraph the cardinality of each relationship and significance of the cardinality is discussed.

5. The final paragraph again consists of action items, i.e., modeling activities that need to be performed beyond the ERD.

2.3 Assignment 3: Data Flow Diagram (DFD)

The third modeling and writing assignment is to create a context diagram (Valacich, George et al. 2004); a high level DFD. After developing the context diagram, another memo, addressed to a "CEO-level" client about their findings with respect to the system scope is created.

1. The opening paragraph describes the purpose and role of a DFD, specifically a context diagram, within the SDLC; the same assumption about client knowledge of the process is made.

2. The second paragraph specifies the external agents that interact with the proposed system.

3. The third paragraph describes the nature of the interactions between the external agents and the system. The student must describe what type of information is either being provided to the system or requested from the system by each of the external agents.

4. The final paragraph again contains of a statement of action items. These activities must include some discussion of the functional decomposition of the system that still must take place, i.e., the development of lower level data flow diagrams.

2.4 Assignment 4: Database Schema

The final assignment involves the development of the database schema. The database schema is an important data model developed in the design phase of the SDLC that acts as the blueprint for the database itself (Valacich, George et al. 2004). After developing the database schema, the student must explain their model to the "CEO-level" through a two page memo which contains the following:

1. The opening paragraph of the memo describes the purpose and role of the schema. The student must also describe the relationship between the schema and the ERD.

2. The second paragraph begins the discussion of how the ERD was converted into the corresponding database schema by describing how each of the entities of the ERD was transformed into a database table including the identification of primary keys.

3. The third paragraph describes how the relationships of the ERD are represented within the database schema; this is primarily the discussion of the use of foreign keys.

4. The fourth paragraph explains, on a table-by-table basis, the normalization process and the transformation of each table into third normal form.

5. The final paragraph is the same as in each of the previous assignments, a discussion of the activities that need to be completed beyond the design stage.