 |
|
CS172 Spring 2009 Schedule
This schedule is flexible, based on the needs of the class
| Mon - Jan 26 | Lab Day - Review Syllabus and Schedule | Note: if you are using a Mac computer, you will have some software problems because the Mac version of Excel does not have all the functionality to finish some assignments. | |
| Wed - Jan 28 | Lecture - Introduction to Excel | The Excel interface; moving around in Excel; using worksheets; printing worksheets; formatting in Excel | Excel: Assignment 1 |
| Fri - Jan 30 | Lab Day - start Excel Assignment 1 | Demonstration: how to copy and paste from the web; how to add a comment to a spreadsheet |
Email Assignment due at midnight |
| Mon - Feb 2 | Lecture: Excel Assignment 1 | Data types; the structure of formulas and functions; what went wrong? | Excel: Assignment 2 |
| Web - Feb 4 | Lab: Excel Assignment 2 | Excel Assignment 1 due at midnight | |
| Fri - Feb 6 | Lab: Excel Assignment 2 | Review formulas, relative and absolute cell referencing. |
|
| Mon - Feb 9 | Lecture: Excel Assignment 2 | Functions: Min, Max, Median, Date | |
| Wed - Feb 11 | Lab: Excel Chapter 2 | More about spreadsheet layout planning, Excel 2007 interface and the VLookup function | Excel: Assignment 3 |
| Fri - Feb 13 | Lab: Excel Chapter 3 | Excel Assignment 2 due at midnight | |
| Mon - Feb 16 | No class - Washington-Lincoln Day, Holiday |
||
| Wed - Feb 18 | Lecture: Excel Chapter 3 | ||
| Fri - Feb 20 | Lab: Excel Chapter 3 | Excel: Assignment 4 | |
| Mon - Feb 23 | Lab: Excel Chapter 4 | Excel Assignment 3 due at midnight | |
| Wed - Feb 25 | Lecture: Excel Chapter 4 | ||
| Fri - Feb 27 | Lab: Excel Chapter 5 | ||
| Mon - Mar 2 | Lab: Excel Chapter 5 | ||
| Wed - Mar 4 | Lecture: Excel Chapter 5 | How to 1) Use the Subtotal function, 2) create Conditional Formatting | Excel Assignment 4 due at midnight |
| Fri - Mar 6 | Lab: Excel Chapter 6 | How to 1) Create a hyperlink in Excel, 2) Concatenate with a function and an operator 3) Export a tab-delimited text file from an Excel worksheet. | Excel: Assignment 5 |
| Mon - Mar 9 | Lab: Excel Chapter 6 | Creating Dropdown menus in Excel | |
| Wed - Mar 11 | Lecture: Excel Chapter 6 | The Amortization Table | |
| Fri - Mar 13 | Lab: Excel Chapter 7 | Ideas for #6 on your presentation: - Round() - page 654 - Formatting with Grouping - page 694-695 - Finding duplicates - page 629 |
|
| Mon - Mar 16 | Lab: Excel Chapter 7 | Ideas for #6 on your presentation: - Creating a table from data in a spreadsheet - page 505 |
Excel Assignment 5 due at midnight |
| Wed - Mar 18 | Lecture: Finish Excel | Ideas for #6 on your presentation: Show how you made mistakes in your formulas and how you fixed them. (auditing formulas) |
|
| Fri - Mar 20 | Presentation work day | Remember that this is your midterm | Excel Presentation |
| Mon - Mar 23 | Lab: Excel Presentation | 5 points Extra Credit for going this day | |
| Wed - Mar 25 | Lab: Excel Presentations | ||
| Fri - Mar 27 | Lab: Access Chapter 1 | Presentation Skills: The importance of a good introduction Importing your Subscribers List into Access |
Access: Assignment 1 |
| Mar 30 - April 3 | Spring Break |
||
| Mon - April 6 | Lecture: Access Chapter 1 - Database Basics | Presentation Skills: Are You Interested in your Own Topic? Why do we take time to design databases? 10 Ways to Mess up your Database |
|
| Wed - April 8 | Lab: Access Chapter 1 | Presentation Skills: Turning in materials that are competitive in the professional world. Database Skills: Planning your Tables - we will go through the Word document |
|
| Fri - April 10 | Lab: Access Chapter 2 | Presentation Skills: Introduce your team! Access Skills: Building the tables in Access. |
|
| Mon - April 13 | Lecture: Access Chapter 2 | Presentation Skills: What are you trying to say? Access Skills: Building Relationships and Forms in Access |
Access 1 Assignment 1 due at midnight |
| Wed - April 15 | Lab: Access Chapter 2 | Access: Assignment 2 | |
| Fri - April 17 | Lab: Access Chapter 3 | ||
| Mon - April 20 | Lecture: Access Chapter 3 | Access Skills: Beginning queries | Access 2 Assignment 1 due at midnight |
| Wed - April 22 | Lab: Access Chapter 3 | Access Skills: Query Examples | Access: Assignment 3 |
| Wed - April 24 | Lab: Access Chapter 4 | Access Skills: How to build a report | |
| Mon - April 27 | Lecture: Access Chapter 4 | Access Skills: Review remaining Access Assignment 3 Queries and Reports | |
| Wed - April 29 | Lab: SQL | A day for extra credit! The information from today's lab will also give you an opportunity for extra credit on the final. | |
| Fri - May 1 | Lab: Presentation work day | As we discussed in class, I will be in the CS Department today to help you with your presentations. You can also email my personal account to schedule presentation help on Friday. | Access3 Assignment 1 due at midnight |
| Mon - May 4 | Lab: Access Presentations | Presentation Requirements | |
| Web - May 6 | Lecture: Access Presentations | ||
| Fri - May 8 | Lab: Finals Review | ||
| May - 11 - 15 | FINALS
SCHEDULE
|
Our final is normally scheduled in a regular classroom. To use the labs, I may have to schedule for an alternative time. Watch here for updates |
|
|
|||
© 2008, Nora McDougall