CIS 101 (24555)

CIS 108 (32)

Office Suite --- 3 Credit Hours

Course Syllabus

Winter 2000

INSTRUCTOR: Larry Zielonka Office: IC-2070

Phone: 942-2800 Ext. 52234

MEETS: Thursday 7:00 P.M. To 9:50 P.M.

Room SRC3675 (7:00P - 9:50P)

I. Course Description

An introduction to the integrative aspects of business suite software. Focus on the creation of word processing, spreadsheet, database and graphics files for the purpose of document integration.

II. Course Materials

1. Microsft Office 97 Professional Essentials

Acklen, Laura and Bird, Linda etal.
QUE E&T, 1998

2. Three 3-1/2 inch, high density disks

(Prepare exterior labels with your last name )

III. Course Objectives

Upon successful completion of this course, you will be able to:

Utilize the menus, dialog boxes and on-line help.

Create, format and print a word processing document.

Design a spreadsheet and display data in graphical format.

Create, modify and retrieve records using the database.

Generate output using presentation graphics.

Share information between documents through Object Linking and Embedding.

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 22^nd 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:

Missing Identification Number (Name of Text, Independent Project Number,

Page Number, Problem Number)

Input errors and not following instructions

Incorrect ordering of material

Not stapled or in a folder

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	PAGES
1/6	Appendix A: Working With Windows Project 1 --- Getting Started With MS Office	A1-A9 INT1-INT26
1/13	Project 2--- Working With Word Documents Project 3 --- Editing Word Documents	WD1-WD17 WD27-WD47
1/20	Project 4 --- Formatting Word Documents Project 5 --- Using Tables and Graphics In Word	WD55-WD76 WD85-WD106
1/27	EXAM 1 Project 6 --- Building A Spreadsheet Project 7 --- Creating Formulas	XL1-XL19 XL27-XL41
2/3	Project 8 --- Calculating With Functions Project 9 --- Improving The Appearance of Work Project 10 --- Using Charts & Maps	XL49-XL70 XL79-XL102 XL109-XL134
2/10	Project 11 --- Using EXCEL With Other Programs Project 12 --- Creating a Database Project 13 --- Entering and Editing Data	INT35-INT51 ACC1-ACC18 ACC27-ACC45
2/17	Project 14 --- Querying Your Database Project 15 --- Creating and Using Forms Project 16 --- Creating and Printing Reports	ACC55-ACC72 ACC81-AC99 ACC109-AC127
2/24	EXAM 2 Project 17 --- Managing Data and Files	INT59-INT83
3/2	Project 18 --- Getting Started With PowerPoint Project 19 --- Changing Appearance of Present.	PP1-PP26 PP37-PP61
3/9	Project 20 --- Integrating Office Applications	INT93-INT114
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/13	Project 1 Challenge Problems 1 thru 5	10	__________
1/20	Project 2 Challenge Problems 1 thru 5 Project 3 Challenge Problems 1 thru 5	10 10	__________ __________
1/27	Project 4 Challenge Problems 1 thru 5 Project 5 Challenge Problems 1 thru 5	10 10	__________ __________
2/3	Project 6 Challenge Problems 1 thru 5 Project 7 Challenge Problems 1 thru 5	10 10	__________ __________
2/10	Project 8 Challenge Problems 1 thru Project 9 Challenge Problems 1 thru 5 Project 10 Challenge Problems 1 thru 5	10 10 10	__________ __________ __________
2/17	Project 11 Challenge Problems 1 thru 5 Project 12 Challenge Problems 1 thru 5 Project 13 Challenge Problems 1 thru 5	10 10 10	__________ __________ __________
2/24	Project 14 Challenge Problems 1 thru 5 Project 15 Challenge Problems 1 thru 5 Project 16 Challenge Problems 1 thru 5	10 10 10	__________ __________ __________
3/2	Project 17 Challenge Problems 1 thru 5	10	__________
3/9	Project 18 Challenge Problems 1 thru 5 Project 19 Challenge Problems 1 thru 5	10 10	__________ __________
3/16	Project 20 Challenge Problems 1 thru 5	10	__________

Return to Home Page

Maps and Directions | Search

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