 |
|
CS172 Fall 2008 Schedule
This Schedule is subject to change, based on class needs. While every effort will be made to keep this online version up-to-date, you are responsible for any changes discussed in class.
| Aug 25 | Lab Day - Review Syllabus and Schedule | ||
| Aug 27 | Chapter 1 lecture | Skills for Chapter 1: the Excel interface, using formulas, formatting worksheets |
|
| Aug 29 | Lab Day - Intro to Excel | Email Assignment due at midnight | |
| Sept 3 | Chapter 1 lecture | Excel: Assignment 1 | |
| Sept 5 | Word Processing review 2 | ||
| Sept 8 | Excel Interface , number formatting, adding comments and layout in Excel | Part
2: Instructions for Computer Budget Assignment |
|
| Sept 10 | Introduction to computer equipment for a business and how to find computer prices on the web. | ||
| Sept 12 | Field Trip to Rural Institute (basement of the Curry Health Center) | Learning about adaptive computer equipment for disabilities | |
| Sept 15 | Creating formulas | ||
| Sept 17 | Review previous section and how Excel can be used for computer modeling and introduce Lease Budget Sheet | Part
3: Instructions for Lease Budget Assignment |
|
| Sept 19 | Cell addressing, fill, copy & paste, working with multiple sheets. Weighted Ranking formulas and Charting | Presentation Instructions | |
| Sept 22 | What is a "pay-per-click" and Introduce next business problem | Part 4: Instructions for Pay-per-click Budget Assignment | |
| Sept 24 | NO SCHOOL - PRESIDENT'S DAY | ||
| Sept 26> | Setting up the Pay-per-Click Sheet | ||
| Sept 29 | Using Subtotal, Sorting and Filtering a Spreadsheet | ||
| Oct 1 | Discuss more complicated functions and Introduce last spreadsheet business problem | Parts 5 & 6: Salary Budget Assignment and Budget Summary Assignment | |
| Oct 3 | Using IF function/Linking v. Copy | ||
| Oct 6 | Project Work session | ||
| Oct 8 | Project Work Session | ||
| Oct 10 | Presentation work session | ||
| Oct 13 | Presentation work session | ||
| Oct 15 | Group Presentations | ||
| Oct 17 | >Group Presentations | ||
| Oct 20 | What is a database? Introduction toAccess project | Access Project Overview | |
| Oct 22 | Documentation and your database users | Link to Complete Database System | Access Project Part 1: User Requirements |
| Oct 24 | Database design and how to do it all wrong. | Reference: 10 Ways to Mess up your Database | |
| Oct 27 | Guest Speaker - Specialized Industry Databases | Extra Credit Questions | |
| Oct 29 | Database design: defining tables and fields | There is information in Part 3 that will help you with Part 2. We will do the actual work of Part 3 on April 10. | Access
Project Part 2: Designing
Tables and Fields Access Project Part 3: Set up your tables in Access |
| Oct 31 | Database design: field constraints | ||
| Nov 3 | Introducing the Access interface | ||
| Nov 5 | Setting up your Access Tables | ||
| Nov 7 | Setting up Relationships in Access | Access Project Part 4: Define your relationships | |
| Nov 10 | Setting up Forms in Access | Access Part 5: Set up your Products Table, Invoices Table and Invoice form | |
| Nov 12 | Work Day | ||
| Nov 14 | Setting up Queries in Access | Access Part 6: Set up your queries and reports | |
| Nov 17 | Intro to SQL | Extra Credit | |
| Nov 19 | Creating Reports in Access | ||
| Nov 21 | Project Work session | Access Project Due Today at 5:00 | |
| Nov 24 | Presentation work session | Access Presentation Instructions | |
| Dec 1 | Group Presentations | ||
| Dec 3 | Group Presentations | ||
| Dec 5 | Final Exam Review | Final Exam Questions | |
| FINALS
SCHEDULE
|
|||
|
|||
© 2008, Nora McDougall