SYLLABUS FOR APPLICATIONS IN DATA PROCESSING

Course Number: CIS250X

Instructor: Mr. Randall Noak

Office: Room # 521

Office Phone: 219 473-4278

E-mail: rnoak@netnitco.net

Home Phone: 219-662-9958

Course Time: Friday 6:30-9:30 p.m.

Course Description: This course will offer various current perspectives on popular application software packages. A specific application software package will be targeted for review during a single term. These reviews will range from threshold syntactical examinations to comprehensive analysis of syntax logic. The application package during any respective term will be decided upon by Computer Information Systems majors' request and the Computer Information Systems program faculty. The application packages that will be considered for review will include LOTUS dBASE IV, FoxBASE, CAD, Microsoft Excel, Microsoft Access, and Harvard Graphics with possible additions as required by advancements in software applications. Computer Information Systems 250 may be repeated with different applications for a maximum of six credit hours to fulfill major requirements.

Prerequisites: CIS 100 (CIS 125 and DOS experience). Laboratory Fee: See current fee schedule.

Textbooks: Access 97 Complete Concepts and Techniques (Students will also need a minimum of 7 diskettes for assignments)

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.

Calumet College of St. Joseph adheres to citation guidelines as prescribed by the particular discipline (i.e., MLA, APA, 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.

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).

Students will be responsible for attending class regularly. It is, however, recognized that missing class is occasionally unavoidable. If you are unable to attend class, call the instructor or send an email message. These messages must be sent before the scheduled class in order for the absence to be excused. Two unexcused absences will result in the loss of all attendance points!

 Class Policy For Assignments:

Homework and reading assignments will be given at the end of each class. due dates will announced at that time. It is expected that students will complete all assignments on time. Assignments turned in late will lose one whole letter grade per week. The granting of make-up exams is not an entitlement, but it is a courtesy granted to the student by the instructor. If this courtesy is abused by a particular student or the class as a whole, then the privilege will be revoked. There will be no make-up exam for the final exam.

Students successfully completing this course will: Be qualified to take Microsoft’s Access Expert MOUS (Microsoft Office User Specialist) exam.

Exams (Midterm, Final, Quizzes) ___25____% of grade

Class participation/collaboration/attendance/assignments ___25____% of grade

Class presentation and assessment instruments ___50____% of grade

A: 100-96% A-: 95% B+: 94-90% B: 89-85% B-: 84-80% C+: 79%

C: 78-75% C-: 74-70% D+: 69-65% D: 64-60% D-: 59% F: 58-0%

Passing the Microsoft Office User Specialist Access 97 Expert Exam will be considered proof of satisfactory completion of all exams, participation, and assignments and will result in a grade of "A" for the course.

Due to the nature of this class, all assignments will be practical assignments, with all work done on the computer. This includes weekly assignments. Formatting of these assignments will be discussed when the assignments are given.

Students are expected to be prepared to participate in class. Preparation consists of completing their assignments and being prepared to answer questions in class.

Class Assignments: (Subject to Change)

Week 1(January 14) Course Policies and Intro

Week 2(January 21) Project 1 (Read Chapter, Answer Questions 1.58 - .59 )

Week 3(January 28) Project 1 (Project 1 Due)

Week 4(February 4) Project 2 (Read Chapter, Answer Questions 2.47 - .48)

Week 5(February 11) Project 2 (Project 2 Due)

Week 6(February 18) Project 3 (Read Chapter, Answer Questions 3.46 - .47)

Week 7(February 25) Project 3 (Project 3 Due)

Week 8 (March 3) Project 4 (Read Chapter, Answer Questions 4.52 - .53)

Week 9 (March 10) Project 4 (Project 4 Due)

Week 10 (March 17) Project 5 (Read Chapter, Answer Questions 5.47 - .48)

Week 11 (March 24) Project 5 (Project 5 Due)

Week 12 (March 31) Project 6 (Read Chapter, Answer Questions 6.48 - .49)

Week 13 (April 7) Project 6 (Project 6 Due)

Week 14 (April 14) FINAL PROJECT & FINAL EXAM!