CIS 147 (31)

Office Suite --- 3 Credit Hours

Course Syllabus

Winter 2000


 










INSTRUCTOR: Larry Zielonka Office: IC-2070

Phone: 942-2800 Ext. 52234

MEETS: 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
Course Technology, 1998

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.


V. ATTENDANCE

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.


VI. ASSIGNMENTS

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

__________


 
 
 


Return to Home Page
 

Maps and Directions | Search

Copyright © 1998 College of DuPage
Computer Information Systems &middot; Business and Services
Instructional Center &middot; IC2070 &middot; (708) 484-6196
treas1@ix.netcom.com
Updated 6 Jan 2000
Disclaimer