CIS 147 (31)
Office Suite --- 3 Credit Hours
Course Syllabus
Winter 2000
INSTRUCTOR:
Larry Zielonka Office: IC-2070Phone:
942-2800 Ext. 52234MEETS:
Wednesday 6:00 P.M. To 8:50 P.M.Room SRC3675 (6:00P - 8:50P)
I. Course Description
An advanced spreadsheet course using a Windows platform. Topics include data tables, advanced formulas and functions, and macros.
II. Course Materials
1. Microsft Excel 97
Parsons, Oja, Ageloff, and Carey
2. Ten 3-1/2 inch, high density disks
(Prepare exterior labels with your last name )
III. Course Objectives
IV. Course Requirements and Procedures
You will complete assigned readings and activities each week as described in the Class Schedule included in this syllabus. Many exercises assume that previous ones have been completed.
To test your skills, you will be required to submit weekly activities listed in the Assignment Schedule included in this syllabus.
Attendance is crucial. Each session assumes you know the material covered in the previous classes and reading assignments. Some topics will be more difficult to understand if you have missed previous material. You are responsible for material covered in the classes you missed. You and another student should agree to share notes and pick up class handouts.
To test your skills, you will be required to submit weekly activities listed in the Assignment Schedule at the end of this syllabus. The assignments are to be done individually, but help can be obtained from other students and the instructor.
All assignments must include the following: your name, the name of the text, and the pages of the text. In addition to the page number, place the problem number or name of the file on each print-out.
Assignments are due once a week at the beginning of class on the day dependent on your class meeting time. Assignments turned in after the due date will receive half credit and none will be accepted more than one class session late. No late work will be accepted the final week of the quarter.
If you cannot attend class the day a project is due, either turn it in early or make sure it is mailed to COD and postmarked no later than the due date. Mailing address:
Larry Zielonka
College of DuPage
IC 2070
425 22nd Street
Glen Ellyn, IL. 60137-6599
VII. EXAMS
There will be three exams valued at 100 points each. Bring at least one Number 2 pencil and a good eraser to the exam. No retakes of the exams are allowed. Make-up exams after the test date are allowed for personal emergencies only. These exams must be taken within one week after the regularly scheduled exam.
VIII. GRADING
Your final grade will be based on the total number of points earned during the quarter as a percent of the total number of possible points:
Three exams --- 300 points
Student Workbook Assignments --- 200 points
To obtain a perfect score on the activities, the work submitted must be perfect.
Points will be deducted for the following:
Your final grade will be assigned as follows:
Grade Score
A 500 - 450
B 449 - 400
C 399 - 350
D 349 - 300
F < 299
Bonus points for teamwork can help raise a grade no more than five points from the next highest grade.
You may chose to be evaluated on the basis of the PASS/FAIL grade according to college policy. To do this you must obtain a registration form for your instructor’s signature. The PASS option requires at least 325 points. CAUTION: Some schools transfer a PASS as a "D".
A student may withdraw from a class at any time prior to the midterm date denoted by college policy. After that date, the student must receive written permission from the college instructor to withdraw. Written permission to withdraw will not be given if a student takes the last exam.
CLASS SCHEDULE
(Tentative)
|
DATE |
TOPIC |
CHAPTER |
|
1/5 |
Working With Excel Lists |
5 |
|
1/12 |
Integrating Excel With Other Windows Programs and the World Wide Web |
6 |
|
1/19 |
Developing an Excel Application |
7 |
|
1/26 |
EXAM 1 Working With Multiple Worksheets and Workbooks |
8 |
|
2/2 |
Data Tables and Scenario Management |
9 |
|
2/9 |
Using Solver for Complex Problems |
10 |
|
2/16 |
Importing Data Into Excel |
11 |
|
2/23 |
EXAM 2 Enhancing Excel |
12 |
|
3/1 |
Using Data Maps |
Appendix 1 |
|
3/8 |
Auditing & Custom Formatting |
Appendix 2 |
|
3/16 |
EXAM 3 |
|
IMPORTANT NOTE
Students are expected to be familiar with the college policies and are responsible for following the rules and guidelines as stated in the College of DuPage Catalog 1997-1999 (pages 40-47).
ASSIGNMENT SCHEDULE
|
DUE DATE |
ASSIGNMENT |
POINTS |
POINTS RECEIVED |
|
1/12 |
Tutorial 5 |
20 |
__________ |
|
1/19 |
Tutorial 6 |
20 |
__________ |
|
1/26 |
Tutorial 7 |
20 |
__________ |
|
2/2 |
Tutorial 8 |
20 |
__________ |
|
2/9 |
Tutorial 9 |
20 |
__________ |
|
2/16 |
Tutorial 10 |
20 |
__________ |
|
2/23 |
Tutorial 11 |
20 |
__________ |
|
3/1 |
Tutorial 12 |
20 |
___________ ____ |
|
3/8 |
Appendix A Tutorial |
20 |
__________ |
|
3/15 |
Appendix B Tutorial |
20 |
__________ |
Copyright © 1998
College of DuPage