Instructor: Dr. Karen KetlerLumpkin College of Business and Applied SciencesSchool of BusinessCIS 3000 001 – Information Systems Design and DevelopmentFall 2004Instructor: Dr. Karen KetlerLumpkin Hall 4012 (217) 581-6906E-Mail Address: [email protected]: www.ux1.eiu.edu/~cfkjkOffice Hours: 1:15 PM – 1:45 PM M 1:45 PM – 2:15 PM T12:15 PM – 3:15 PM Fand 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: Essentials of Systems Analysis and Design (2nd edition) by J. Valacich, J. George and J.Hoffer. Published by Prentice Hall, 2004. Class Meetings: 8:00 – 9:15 AM T H COLE 1621Course 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 Examination (Comprehensive) 100100 4025.0%25.0%10.0%Projects Design Project Pseudocode Visual Basic Testing6020301015.0% 5.0% 7.5% 2.5%Quizzes 4 @ 10 points each 40 10.0%Total Points 400Grading Scale: A 360 - 400 (90.0 – 100%)B 320 - 359 (80.0 – 89.9%)C 280 - 319 (70.0 – 79.9%)D 240 - 279 (60.0 – 69.9%)F below 240Examinations: The exams will cover the material discussed in class and in the readings. The examinations are comprehensive, but will emphasize the “new” material presented sincethe last exam. The examinations are closed books and closed notes.Quizzes: Four quizzes will be given during the semester. Each quiz will be worth 10 points and will be closed books and closed notes. The quizzes will be from class notes or possibly from a homework assignment. The students who attend class regularly and review their notes should have no problems with the quizzes.Quizzes cannot be made up. You must be present on the day of the quiz to get any points.Projects: Teams of 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:A description of the project, and the functions it will perform 4 pointsA GANTT chart and PERT chart for the entire project 5 pointsLogical data flow diagram of the proposed system including Logic Modeling 10 pointsEntity Relationship Diagram 8 pointsFunctional Hierarchy Diagram and CRUD analysis 5 pointsInput/Output Design with navigation and logic explanation 15 pointsNormalized Database Design 8 pointsAn ACCESS database with 5 - 10 test records in each table 5 pointsThis project is worth 60 points. To receive full credit for the design project, each team must submit a diskette with the Input/Output Forms created in Visual Basic 6 and with anACCESS database of the normalized tables. Each table should have 5-10 test records in it.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 by the START of class on 10/12. There is a 20% penalty for each day or partial day that the entire project is not submitted.The instructor will select the most "doable" project and assign the functions to the various teams in the class. Each team will be assigned a portion of the project to pseudocode and program in Visual Basic. Failure to submit a workable visual basic program will eliminate that team from completing the remainder of the project. Each team will be assigned the pseudocode and Visual Basic project from another team for testing. The process of trading projects will be discussed in class.Hopefully, at the end of the semester we will have completed a quality project.Partial deadlines for the second half of the project are:Psuedocode 11/11Visual Basic 11/11Testing 12/02There is a 20% penalty for each day or partial day that any assignment is late.Teams: You must work in groups of 3 to 4 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 design a project and develop a function of the selected class project. All groups will design the same project. This will allow me to give hints and describe the project during class time. Each student is responsible for participating in the team project. There will be an opportunity for you to evaluate your team members. The instructor reserves the right to assign unique grades to each team member on the project, based on these evaluations and her personal observations. If the instructor anticipates a problem in the group, she will notify the students involved as early as possible so that the problem can be resolved before the grade is adversely affected. Your project grade will be reduced if you do not personally contribute your fair share (in the estimate of your instructor based on comments by your teammates) to the project.Business 1. Upon completion of a program in the School of Business, studentsPerspectives should