Systems Analysis and Design (CIS270/54)

Professor: Priscilla Grocer

Office: K-112
Phone: 508-678-2811 ext 2403
Email: Check with me about other email address to use for homework.

Course Description (from catalog):
Analyzing and designing effective business systems is the focus of this course. Emphasis is placed on today's tools for analyzing business problems, designing solutions and documenting the results. The student will learn the effective use of systems tools, the use and integration of microcomputer applications, the development of an effective database and they will develop an understanding of the analysis and design process.

Course Objectives: Students who successfully complete Systems Analysis and Design Seminar will be able to:

Slightly older editions are acceptable.
Systems Analysis and Design (Shelly Cashman) (9th 2012)
Gary B. Shelly, Harry J. Rosenblatt
Course Technology
ISBN-13: 9780538481618 ISBN-10: 0538481617

Material to be covered:

  1. Introductionto Systems Analysis and Design
  2. Systems Planning
  3. Preliminary Investigation
  4. Systems Analysis
    1. Requirements Modeling
    2. Data and Process Modeling
    3. Object Modeling
    4. Transition to Systems Design
  5. Systems Design
    1. User Interface, Input and Output Design
    2. Data Design
    3. Application Architecture
  6. Systems Operation and Support
  7. Systems Analysis Toolkit
    1. Communication Tools
    2. Feasibility and Cost Analysis Tools
    3. Project Management Tools
    4. Alternative Systems Development Methodologies

Requirements and Grading: The student will be expected to complete all assigned work. Homework assignments will be due in a week unless otherwise specified. Quizzes, when given, will count as a homework assignment unless otherwise specified. In addition there will be a final exam. A schedule of assignments, projects, exams, quizzes etc. will be posted on the Web site in a weekly chart. Students should check on a regular basis. During a week, additions and changes to the week of chart should be anticipated.


Your committment: For each hour in class, you should plan to put in 2 to 3 hours outside of class so you need to recognize that committment and include it in your planning.
Below there is a TENATIVE schedule of homework based on previous semesters that will give you an idea of what you need to accomplish to be successful in the class. You are also required to read the chapters in the book and do outside research as assigned.

Week #1 eCommerce, spreadsheet, ongoing case study chap 1/2        Week #2 copyright, fairuse and ethics quiz, ongoing case study chap 3
Week #3 tool assignment, ongoing case study chap 4        Week #4 data flow assignment, ongoing case study chap 5
Week #5 Analysis/Powerpoint assignment, DFD assignment        Week #6 relational database assignment, ongoing case study chap 6
Week #7 relational database assignment, ongoing case study chap 7        Week #8 database, ongoing case study chap 8, start another system
Week #9 ongoing case study chap 9, continue another system, portfolio        Week #10 tools/RSS assignment, ongoing case study chap 10, continue another system, portfolio
Week #11 ongoing case study chap 11, continue another system, evaluate software, portfolio        Week #12 ongoing case study chap 12, finish another system, review book tools, portfolio
Week #13 finish portfolio, another system, ongoing case study        Week #14 finish portfolio, another system, ongoing case study
Week #15 Prepare for final        Final Final exam and status sheet required

It is very important that you let me know if you are having problems so we can work out a plan. I set up help sessions you can attend every week and I also am available for help via email. Please take advantage of my availability and don't let yourself get behind! I truly want to see you succeed!


Assignments, programs and exams are graded using either number grades or letter grades based on the following (A=90-100, B=80-89, C=70-79, D=60-69, F=below 60). The student's grade for the course will use the same scale and will be based on the percentages explained in the grading section. Plus and minus grades will be given.
Many of the assignments in this class are open ended - the grading will be based on how well the project demonstrates mastery of the material. Students who do a minimum of work will be graded accordingly. Assignments are only accepted if they are credible work and meet the minimum requirements and standards for that assignment. Assignments that are not accepted can be resubmitted. Resubmission is allowed on graded assignments, with permission of the instructor. You cannot earn an A+ on an assignment that is resubmitted. The instructor will only accept, without penalty, resubmissions on credible work. Resubmissions must be done within a week to avoid additional penalties for late assignments.
Note: To achieve an A+, students must have done sufficient extra work in design or implementation that makes the assignment standout. In doing assignments, students must do their own work. Relying too heavily on my examples or working too closely with someone else will be penalized.
Assignments are due the week after they are assigned. Late assignments will be penalized within the class participation points.
For purposes of this class, the week will end at midnight on Thursday. The new week will start on Monday morning.

Attendance: Attendance is based on email communication. Students must report their status once a week. This report can be combined with the submission of an assignment.

Bristol Community College Withdrawal Policy:
Students are responsible for withdrawing officially if they stop attending any or all classes. Faculty no longer have the ability to withdraw a student from a class. A grade of "F" will be assigned to any student who stops attending a course but does not officially withdraw. Students are encouraged to meet with an advisor before making any changes to their schedule. Withdrawals effect Satisfactory Academic Progress and can place the student at risk for academic probation or dismissal. Students who use financial aid and who subsequently withdraw may be required to return some or all funds received. Withdrawals are accepted until the tenth week of classes. Students may withdraw online in accessBCC, in person at any Enrollment Center, or via their college email to Email requests must come from the student's BCC college email address and must include the student's name, BCC student ID number, and course information (CRN, course and section number). Email from non-college accounts will not be accepted. If a student officially withdraws after the third week of classes, there will be no tuition or college fee refunds. For more information, see the College Catalog at: Students with questions should contact Enrollment Services via any of the methods mentioned above or at 774-357-2590.

Methodology: This course is sometimes offered using Student Option and sometimes as a Hybrid. The material is available in class and on the web: it is a combination of lectures and interactive projects with supplementary information available on the Web site for the course. Lectures are recorded and put online and Smartboard notes are captured and put on line for all inclass sessions. For other classes, lectures and notes are available. All students should read the assigned notes, study the presentations available and avail themselves of other resources at the web site in mastering the course material. In addition, students will be working independently on projects designed to give them additional computer skills and practical experience in Visual Basic. When appropriate, exercises and problem solving techniques are used. This syllabus is not to be construed as a contract in any way, shape, manner or form. This syllabus contains a suggested course outline and will be generally followed, subject to change according to the instructor’s discretion and needs. Academic flexibility is important!

Interaction Plan: This is an asynchronous course with synchronous components if you decide to attend classes. Communication includes email, audio of lectures, Smartboard notes of inclass notes, and on line office hours and help sessions. Other methods of on line communications may also be used. In addition open lab help session are scheduled and students may request in person meetings. Students must communicate with the instructor at least once a week via email and must turn in homework and participate in on line communication to be successful.