| Nicole Cook | CIS 53/53L | |
|---|---|---|
| Fall 2004 | Course Syllabus | Office ????? |
| email: nicdebcook@charter.net | Phone: 465-2390 x2474 |
| This class is designed to give you the skills necessary to understand the applications of spreadsheets in common Business Scenarios. We will cover how to create and use spreadsheets, how different spreadsheet applications work, how spreadsheet applications can interact with other business applications and how to design and use macros. |
| Day | Topic | Reading Assignment | Homework Assignment |
| Class 1 | Introduction, Review Of What I Expect You To Already Know, Why use a Spreadsheet | None | Lab 1 |
| Class 2 | Creating a Worksheet, Data Entry | Project 1 -- EX 4 - EX 36 & EX 42 - EX 47 | Lab 2 |
| Class 3 | Basic Calculations, Formulas and Functions | Project 2 -- EX 70 - EX 120 | Lab 3 |
| Class 4 | Formatting and Organizing your Spreadsheet | Project 3 -- EX 150 - Ex 169 & EX 177 - EX 202 | Lab 4 |
| Class 5 | Topic 5 | Reading Assignment | Lab 5 |
| Class 6 | Topic 6 | Reading Assignment | Lab 6 |
| Class 7 | Topic 7 | Reading Assignment | Lab 7 |
| Class 8 | Topic 8 | Reading Assignment | Lab 8 |
| Class 9 | Topic 9 | Reading Assignment | Lab 9 |
| Class 10 | Topic 10 | Reading Assignment | Lab 10 |
| Class 11 | Topic 11 | Reading Assignment |
All Labs Due Lab 11 |
| Text Book: |
| Required - Shelly Cashman Series - Excel 2003 Comprehensive Concepts and Techniques, By: Gary Shelly, Published by: Course Technology -- ISBN: 0-619-20034-0 |
| Course Work and Homework: |
| If you have a computer you can do your lab work at home. However, working at home is not an excuse for not getting your assignments done. I am in the lab for several hours each week. If you are working at home and start to fall behind, work in the lab while I am there !! All lab assignments are due the week after they are listed above. Late assignments lose 10% of their value for each week they are late. Reading should be done before the class they are listed for above. All assignments and several other useful items can be found on my website at http://www.nicoleanddebbie.com/classes/cor/ |
| Grading Policy: |
| I do not like the idea of the all or nothing final grade approach to grading. I will weight your grades from your assignments and your quizzes to count for the majority of your grade in this class. The final exam at the end of the class will not be worth more than 20% of your grade. This means two things: 1) If you do not do your assignments and quizzes, you will not pass the class and 2) No final grade can move you from an F to an A or vice versa. Just to make sure your work is your own, I will occasionally put one of the students assignments on screen during class and ask the creator questions about it. If something is in your assignment, I will expect you to know why. You cannot use work from another students assignment. |
|
How to Contact Me: If you need to contact me, the best way to reach me is by email. You can email me at nicdebcook@charter.net You can ask me questions by email also, either Debbie or I will respond to your questions. |
| Return to CIS 53/53L Class Links |