Instructor: Dr. Karen KetlerLumpkin College of Business and Applied SciencesSchool of BusinessCIS 3300 – Information Systems Design and DevelopmentFall, 2001Instructor: Dr. Karen KetlerLumpkin Hall 4012 (formerly LH 350)(217) 581-6906E-Mail Address: [email protected] Hours: 9:00 – 9:45 M W F3:00 – 4:00 T 1:00 – 2:00 Hand by appointmentCourse Description: A study of the systems development life cycle. Emphasis on requirements determination, modeling techniques, and development, implementation and maintenance strategies. Includes project management techniques and software, Computer Aided Systems Engineering (CASE) with Oracle Designer and Visual Basic asthe development tool.Prerequisites: BUS 1950, CIS 2000, junior standingRequired Texts: Modern Systems Anlaysis and Design (3rd edition) by J. Hoffer, J. George and J. Valacich. Published by Prentice Hall, 2002. Class Meetings: 8:00 – 8:50 M W F LMPH 202010:00 – 10:50 M W F LMPH 2041Course Objectives: As a result of this course, students should be able to:1. Understand the activities of the system development life cycle.2. Examine the different types of information systems, including transaction processing systems, management information systems, decision support systems and expert systems.3. Analyze, design, develop, and implement a new information systems project.4. Investigate project management techniques, including GANTT and PERT charts.5. Enhance the project management activities with project management software.6. Analyze user needs and requirements.7. Create a data flow diagram, entity relationship diagram and functional hierarchy diagram.8. Experiment with a client-server tool, such as Oracle Designer, in the analysis and design process.9. Implement a system, utilizing the Visual Basic language.Teaching Method: The class will be taught as a combination of lectures, discussions, exercises and problem solving.Grading:Item Total Value Percent ofTotal PointsExaminations First Examination Second Examination Final (comprehensive) examination10010015020.0%20.0%30.0%Projects Design Project Development Project507510.0%15.0%Quizzes No quiz will be worth more than 10 points25 5.0%Total Points 500Grading Scale: A 450 - 500 (90.0 – 100%)B 400 - 449 (80.0 – 89.9%)C 350 - 399 (70.0 – 79.9%)D 300 - 349 (60.0 – 69.9%)F below 300Examinations: The exams will cover the material discussed in class and in the readings. The first two examinations are comprehensive, but will emphasize the “new” material presented sincethe last exam. The final examination is comprehensive. Detailed topics for study will be discussed in class before the examination. The examinations are closed books and closed notes.Quizzes: Three or four quizzes worth between 5 and 10 points inclusive will be given randomly throughout the semester to ensure that the students are keeping up on the daily activities. You must be present on the day of the quiz to receive any points for the activity. You will not be allowed to make up any missed quizzes.Projects: Students will be asked to investigate, analyze and design an information system in the first half of the project (the design project). Deliverables for this part of the project include:1. A description of the project, and the functions it will perform2. A GANTT chart and PERT chart for the entire project3. TWO data flow diagramsa. Physical data flow diagram of the current systemb. Logical data flow diagram of the proposed system including Logic Modeling4. Entity Relationship Diagram5. Functional Hierarchy Diagram6. Normalized Database Design7. Input/Output Design8. Process Design (pseudocode)In addition, the student must document/explain the deliverables. The point value for each deliverable will be reflective of its importance and the amount of time required to complete that deliverable. Thus, the point value to the deliverables in the design project will be similar to: Deliverable Value1. A descriptive of the project, and the functions it will perform 32. A GANTT and PERT chart for the entire project 33. TWO data flow diagramsc. Physical of the current system 3d. Logical of the proposed system including Logic Modeling 64. Entity Relationship Diagram 45. Functional Hierarchy Diagram 36. Normalized Database Design 67. Input/Output Design 68. Process Design (pseudocode) 16 You may be required to turn in parts of your project for partial credit at various check points during the semester. However, you must submit the entire design project on 10/26/01 by noon. There is a 20% penalty for each day or partial day that the entire project is not submitted.The second half of the project will center on the development and implementation of the project. Deliverables for this part of the project include:1. Visual Basic Programs (hard and soft copies) 402. Documentation 10a. User (operational) manualb. Systems manual3. Description of the test cases including the Access Test Database 84. Implementation Method 2The remaining 15 points will be awarded based on consistency between the design project and the actual project developed and in general the overall quality and completeness of the project. The design project must be updated to reflect any changesmade during the final development phase and resubmitted with the development project.The entire project is due on 12/03/01 by noon. There is a 20% penalty for each dayor partial day that the entire project is not submitted.Teams: You must work in groups of 4 or 5 students. This class requires a major systems design and development project that does require group interaction. You can learn much from your teammates. In addition, many organizations stress the ability to work in groups. A commonly-asked question at interviews is to describe a team on which you have participated and why it was successful (or unsuccessful). Think about this during the semester!Groups will be expected to select, design and develop a project. This project can be 1) a project of unique interest to the group or 2) a college placement center, or 3) a child care system. No more than ½ the class can select the same project. Each group is expected to investigate the issues associated with their project (the web is an excellent source) and select the three most important functions for their system. Groups of five must select an additional function. Please note that file