SYLLABUS FOR APPLICATIONS IN DATA PROCESSING: Excel 97

Term: Summer, 2000 (19993) May 1 – August 5, 2000

Course Number: CIS 250

Instructor: Mr. Darren Henderson

Office: Room # 411

Office Phone: (219) 473-4346

E-mail: dhenderson@ccsj.edu

Office Hours: Friday 3:30 p.m.- 6:30 p.m.

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

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

CIS 100 (CIS 125 and DOS experience).

Laboratory Fee: See current fee schedule.

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 written in the Publication Manual of the American Psychological Association, Fourth Edition. A copy is available from the Calumet College of St. Joseph bookstore. This text outlines 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).

Attendance will be taken for administrative purposes. Although class attendance does NOT account for a percentage of the assigned semester grade, it is vital that students attend both the class lectures and laboratories on a regular basis in order to be informed of any important class announcements, any deviations from the course outline below, and of any supplemental material presented.

However, class/lab attendance and participation is used as a factor in deciding borderline cases. (if applicable)

Homework problems will be assigned throughout the duration of the term. Homework will be collected generally one week from the date assigned. Late homework is subject to an automatic deduction to be determined by the instructor.

The official class policy is that there is NO MAKE-UP EXAMS, however in recognition of the occasional personal and/or family emergency that may occur during the semester, a make-up exam may be granted provided all the following conditions are met:

1. The instructor is notified of the make-up exam request by the student on or before the scheduled exam date.
2. A suitable alternate time convenient to the instructor can be arranged.
3. The missed scheduled exam must be made-up within one-week of the scheduled exam date.

The granting of make-up exams is NOT an entitlement but 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 may be revoked.

A missed midterm exam or final exam will be assigned a score of zero.

Exams are typically closed book and closed notes.

The FINAL EXAM is comprehensive!

The function of the homework problems and class/laboratory activities is that they serve as exam preparation. The function of the exams is to confirm that the student has achieved the required level of proficiency.

Students in this course will:

• demonstrate the effective use of formulas and built-in functions in spreadsheets.
• understand the differences between absolute and relative cell addressing.
• build various types of charts (i.e. pie, line, bar, etc.) to graphically display spreadsheet data.
• employ the various methods (i.e. goal seeking, data tables, scenerio manager, etc.) in Excel to perform "what-if" analysis.
• introduce the use of Visual Basic for Applications (VBA) programming and macros for automation.
• illustrate Excel’s database capabilities.

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

Grading Scale: A = 100 to 90%

B = 89 to 80%

C = 79 to 70%

D = 69 to 60%

F = 59 and below

All requirements/specifications for written assignments will be provided at the appropriate time.

See "Class Policy on Attendance" above

See the "Course Outline" below. Additions and/or modifications to the assignments may be announced throughout the duration of the term.

Students are required to submit homework in both hardcopy and electronic form (via an appropriately labeled 3.5" floppy disk). See the "Homework Submission Guidelines" handout for further details.