Text only

CSS 1200 – Microsoft Excel 2003 (from MS Office 2003 Suite)

Instructor: Sue Isermann                        Office: C-312
Office Phone: 224-2720 Ext 408                 e-mail: sue_isermann@ivcc.edu
Office Hours: 8am-4:30pm (Friday) – By appointment

Course Description
This course offers hands-on, practical instruction in the use of the Microsoft Excel spreadsheet program. Students will learn how to analyze and chart data.

Textbook and Materials Required
Microsoft Excel 2003 – New Perspectives Series – Brief by Parsons, Oja, etc.

Data disks will be provided by instructor or the data files can be downloaded from:  http://www.course.com/
IF YOU NEED THE DATA FILES ON A CD-ROM, CONTACT THE INSTRUCTOR AND I CAN SEND THEM TO YOU IN THAT FORMAT.

Attendance
There are no attendance requirements except to take final exam. If you wish to drop this course, you must contact the instructor. If you do not withdraw and do not take the final exam, you will receive a Failing grade.

Requirements
 1.    Complete all of the Tutorials, Review Assignments, and Case Problems as listed on the schedule below.

2.    Turn in all print outs from the Review Assignments and the Case Problems. Turn these in when you come to take the final exam.

3.    Take a written test over the Microsoft Excel material upon completion of the assigned Tutorials.

For your reference, answers to the "Quick Check" questions in the Tutorials are at the END of each Tutorial.

ABSOLUTE LAST DATE TO TAKE THE FINAL EXAM IS:

Tuesday, December 12

YOU MUST CALL THE ASSESSMENT CENTER (224-0542) AT LEAST ONE WEEK IN ADVANCE TO SCHEDULE THE DATE AND TIME FOR TAKING YOUR FINAL EXAM!

Grading Scale

90 - 100% = A 80 - 89% = B 70 - 79% = C 60 - 69% = D

TEST = 90% of grade REVIEW & CASE PROBLEMS = 10% of grade

CSS 1200 - Microsoft Excel 2003 Schedule

 

COMPLETE ALL YELLOW SHADED EXERCISES ON A COMPUTER USING MS EXCEL.

Using Common Features of Microsoft Office 2003
USE DATA DISK:  Common Features of Office

Tutorial 1 – Using Excel to Manage Data
 Review Assignments on pages EX 44-45 – All Steps
Case Problem # 1 – on pages EX 46-47 – All Steps

Tutorial 2 – Working with Formulas and Functions
 Review Assignments on pages EX 85-87 - All Steps
Case Problem 1 - on page EX 87 - All Steps

Tutorial 3 – Developing a Professional-Looking Worksheet
 Review Assignments on pages EX 135-137 – All Steps
Case Problem 1 on pages EX 137-138 - All Steps

Tutorial 4 – Working with Charts and Graphics
 Tutorial Assignments on page EX 187 - All Steps
Case Problem 1 on pages EX 187-188 - All Steps

Excel 2003 is one of the components of Microsoft Office 2003 Professional Suite. If you do not have the software package at home or at work, you can use a computer on campus to complete your assignments.

 

General Information about the IVCC Computer Resource Center – CRC - Building-D
  1. Each student enrolled in a class at Illinois Valley Comm. College has been assigned a login i.d. for our computer network. The i.d. consists of the first three letters of your last name and the last four digits of your social security number. For example, my i.d. would be ise9234.
     
  2. Your initial password for the system is your entire social security number without any spaces or hyphens.
     
  3. You must change your password immediately and then again each month to use the network. The password should be something that you can easily remember and that is unique. A pamphlet is available in the lab outlining the procedures to change your password.
     
  4. LRC-D is an open lab that will not have any classes scheduled in it. There will also be a lab assistant to instruction or student lab assistants in this lab to assist you in your computing endeavors.
     

  5. Information about the IVCC Computer Resource Center can be found at: 
    http://www.ivcc.edu/its/students/comp_open_labs.html   AND   http://www.ivcc.edu/its/students/comp_labs.html