Calumet College of St. Joseph

SYLLABUS FOR INTRODUCTION TO SYSTEMS ANALYSIS AND DESIGN (Directed Study)

 

Term:  Fall, 2002-2003  (021)  (Sept. 3 – Dec. 14)

Course Number: CIS 420

Instructor:   Mr. Darren Henderson

Office: Room 411

Office Phone: (219) 473-4346

E-mail:  dhenderson@ccsj.edu

Office Hours:                  Monday                                 3:00 p.m.- 7:00 p.m.

                                Tuesday                 4:00 p.m.- 7:00 p.m.

                                Thursday              4:00 p.m.- 7:00 p.m.

                                Saturday                 12:00 p.m.- 2:00 p.m.

 

Instructor Background:

Darren Henderson earned a B. S. in Engineering from Purdue University Calumet and a M. S. in Electrical Engineering from Purdue University with a specialty in Communications and Signal Processing.  His undergraduate curriculum was characterized by a strong emphasis in mathematics and physics including courses in Advanced Calculus, Partial Differential Equations, Complex Analysis, Advanced Analysis, Electromagnetic Field Theory, Optics, and Quantum Mechanics.  As his undergraduate senior design team project, Darren worked on a prototype for a home security and convenience system that provided a speech synthesis capability.  His task was to write the assembly language software for the Motorola HC11 microcontroller and to work with the Texas Instruments speech synthesis chip.  Darren’s graduate coursework included courses in Digital Communications, Digital Signal Processing, Image Processing, Computer Networks, and Estimation Theory.

Darren joined the Computer Information Systems Program at Calumet College of St. Joseph in 1995.  He regularly teaches the courses C Programming I and II, Hardware and Software Concepts, and Data Communications and Networking Theory.  In addition to his teaching activities, Darren has worked for CCSJ's Computer Services Department.  He used his engineering background and skills to help lay the groundwork for the school's existing computer network and services.  He was responsible for initially creating the faculty and staff e-mail accounts and for making the school's computers (faculty, staff, and 4th floor computer labs) Internet accessible.  His duties involved Unix/Linux and Windows NT System Administration and TCP/IP Network Administration in support of DNS, DHCP, WWW, and e-mail services.  He was also responsible for implementing an early firewall to protect the school's Univers database system from unauthorized access.  He currently is working on ways of integrating the Blackboard 5 e-learning environment into his courses at CCSJ.

                Before his tenure at CCSJ, Darren was an adjunct instructor in the Electronics Technology Department at Ivy Tech State College in Valparaiso.  He taught a multitude of courses including: Circuits I and II, Solid State I and II, Digital Principals, Digital Applications, and Electricity for HVAC.

                His current research interests are in C++ programming, software engineering for Internet applications, and network security.

 

Course Time:  ARRANGED (see "Schedule of Meeting Times" below)

 

Course Description: As an overview of the systems development life cycle, this course will cover both the classical and structured tools and techniques for systems analysis and design.

 

Prerequisite: CIS 125, CIS 255, CIS 312 or CIS 320.

 


Learning Outcomes/ Competencies:

Students in this course will:

 

·         Be exposed to the major methods, techniques, and tools of the systems analyst.

·         Apply the scientific method of problem solving.

·         Develop an understanding of the five-phase systems development life cycle (SDLC) through the aid of textbook examples and the completion of a semester-long project.

·         Understand and apply the principles of data modeling and database design

·         Use the Microsoft Access RDBMS and Visual Basic for Applications (VBA) to create a prototype of a customized database application

 

Textbooks:

Systems Analysis and Design, 4th ed., Shelly, Cashman, and Rosenblatt, Course Technology, Cambridge, MA, 2001. (ISBN 0-7895-5957-9) (SA&D)

Microsoft Access 2000: Building Applications with Forms and Reports, http://msdn.microsoft.com/library/default.asp?URL=/library/officedev/bapp2000/acbatitle.htm (Access)

 

Learning Strategies:

With a directed study mode of delivery, the directed study student is responsible for learning the subject material during the time constraints specified in the “Course Outline” below.  Due to the technical nature of the subject matter, supplemental course material (e.g. instructor class notes, assessment exercises ) will be provided as required to the directed study student in either hard copy form or available in downloadable form (e.g. Adobe PDF files or Word documents) on the CIS 420 Blackboard supplement for the directed study student to printout.  Periodic consultation sessions will be held throughout the duration of the term.  Meeting/session times will be arranged in advance in order to best accommodate the schedules of the Instructor and/or the directed study student.  Instructor-Student consultations are also available via electronic mail (e-mail) where deemed appropriate.  The purpose of the sessions will be to address questions on reading assignments, supplemental material, homework problems/projetcs, and exam preparation.  However, the sessions should NOT be construed as a formal lecture as with a regularly scheduled class.  Students demonstrate the course competencies in part by completing periodic assignments and projects.

 

Assessment:

The student’s grade is computed using the weights shown below:

 

                                Homework Assignments        50%

                                Semester Project              25%

                                Final Exam                     25%

                                                                        ------

                                                                        100%

 

Class Policy for Assignments/Exams:

Homework problems will be assigned throughout the duration of the term. Homework will be collected generally two weeks from the date assigned unless otherwise directed.  Late homework is subject to an automatic deduction to be determined by the instructor.

 

Failure to submit a required homework assignment and/or the semester project by the instructor-specified deadlines will result in an assigned score of zero.  Failure to take the Final exam before the conclusion of the term will result in an assigned score of zero.

 

Exams are typically closed book and closed notes.

 

The FINAL EXAM is comprehensive!

 

The function of the homework assignments is that they serve as exam preparation.  The function of the final exam is to confirm that the student has achieved the required level of proficiency in the subject material.

 

Grading Scale:

 

A: 93-100                A-: 90-92                  B+:  87-89     B: 83-86         B-:  80-82    C+: 77-79

C: 73-76                 C-: 70-72                 D+:  67-69     D: 63-66         D-:  60-62    F:  59 & below

 

Class Policy on Attendance:

Periodic consultation sessions will be held throughout the duration of the term.  Meeting/session times will be arranged in advance in order to best accommodate the schedules of the Instructor and/or the Directed Study student(s).  Instructor-Student consultations are also available via electronic mail (e-mail) where deemed appropriate.  The purpose of the sessions will be to address questions on reading assignments, homework problems, and exam preparation.  However, the sessions should NOT be construed as a formal lecture as with a regularly scheduled class.

 

Course Outline (Tentative):

 

 

Topics/Assignments:

WEEK 1

Syllabus/Directed Study Orientation

WEEK 2

Introduction to Database Design Concepts (Handouts)

WEEK 3

SA&D 1 – Introduction to Systems Analysis and Design    (28 pgs)

SA&D 2 – Preliminary Investigation (27 pgs)

WEEK 4

SA&D 3 – Requirements Modeling (40 pgs)

WEEK 5

SA&D 4 – Data and Process Modeling (43 pgs)

WEEK 6

SA&D 5 – Object Modeling (34 pgs)

WEEK 7

SA&D 6 – Transition to Systems Design (34 pgs)

Access 1 – Creating an Application

WEEK 8

SA&D 7 – User Interface, Input, and Output Design (45 pgs)

Access 2 – Introducing VBA for Applications

WEEK 9

SA&D 8 – Data Design (41 pgs)

Access 3 – Using Forms to Collect, Filter, and Display Information

WEEK 10

SA&D 9 – Application Architecture (39 pgs)

Access 4 – Working with Objects and Collections

WEEK 11

SA&D 10 – Application Development (29 pgs)

Access 5 – Responding to Events

WEEK 12

SA&D 11 – Installation and Evaluation (21 pgs)

SA&D 12 – Systems Operation and Support (23 pgs)

WEEK 13

Access 6 – Working with Records and Fields

WEEK 14

Final Exam Review

Semester Project Due

WEEK 15

Final Exam

 


Schedule of Meeting Times: (Tentative)

 

 

Day

Date

Time/Agenda

WEEK 1

Thursday

9/5/2002

 

WEEK 2

Monday

9/09

 

WEEK 3

Monday

9/16

 

WEEK 4

Monday

9/23

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 5

Monday

9/30

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 6

Monday

10/07

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 7

Monday

10/14

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 8

Monday

10/21

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 9

Monday

10/28

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 10

Monday

11/04

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 11

Monday

11/11

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 12

Monday

11/18

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 13

Monday

11/25

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 14

Monday

12/02

5:00 P.M. - 6:00 P.M.   ROOM 411

WEEK 15

Monday

12/09

4:00 P.M. - 6:00 P.M.   ROOM 411

Final Exam

 

Class Participation:

See "Class Policy on Attendance" above

 

Center for Academic Excellence:

Tutoring assistance is free to all students of Calumet College of St. Joseph. Call the Center for Academic Excellence (CAE), to make an appointment at 473-4287. The Center has experienced and well-trained tutors in most subject areas to help students who are struggling in a course or who are doing well and would like to do better. Regular weekly tutoring sessions are likely to improve your grade.

 


Statement of Plagiarism:

If an instructor or other Calumet College of St. Joseph personnel find that a student has plagiarized or been involved in another form of academic dishonesty, the instructor or other personnel may elect to bring the matter up for judicial review. The maximum penalty for any form of academic dishonesty is dismissal from the College. The procedures for judicial review are listed under the section of CCSJ handbook that addresses student grievances. (Academic Planner 2001/2002 p.27)

 

Citation Guidelines:

Calumet College of St. Joseph adheres to citation guidelines as prescribed by the particular discipline (i.e., MLA, APA, and Chicago Manual of Style or Turabian.).  All of these guidelines are available in the Calumet College of St. Joseph library or bookstore.  These texts outline how to cite references from a variety of sources, including electronic media.

 

Withdrawal from Classes Policy:

After the last day for class changes has passed (see College calendar), students may withdraw from a course in which they are registered with permission from the faculty member conducting the course. A written request detailing the reason(s) for the withdrawal must be filed with the Registrar. Written request for withdrawal must be received by the Registrar by the last day of classes prior to the final examination dates specified in the catalogue. Written requests may be mailed to the Registrar or faxed to the College fax number 219-473-4259. Students are to make note of the refund schedule when withdrawing from courses. The request is forwarded to the faculty member, who makes the final determination to accept or deny the request. If the request is honored, the student will receive notification of official withdrawal; if denied, the notification will indicate why the withdrawal is disallowed. Note: Degree Completion Division (DCD) students should consult the DCD Student Handbook for information on DCD withdrawals.

 

An official withdrawal is recorded as a "W" grade on the student's transcript. Dropping a course without written permission automatically incurs an "F" grade for the course (see Refund Schedule).