CIS 115: Microcomputer Applications
Fall 2009 Daily Agenda
This is a TENTATIVE agenda, ALL future dates are subject to change!
| Date | Agenda / Topics | In Class Exercise(s) |
| W01-1 | Welcome Intro to Course Syllabus & Schedule |
Pre-Test |
| W01-2 | Information Processing Cycle Hardware System & Application Software Windows XP Fundamentals |
Name in Paint WinXP Project 1-11 |
| W02-1 | Web Browser Storage Measuring Storage Organizing Storage Windows Explorer WinXP File Management Handout Read MS-Word Chapter 1 & 2 |
Typing Test |
| W02-2 | WinXP Review |
Sample Cover Page |
| W03-1 | NO CLASS - LABOR DAY | |
| W03-2 | Word Chapter 2 | Week #3 Review |
| W04-1 | Word Chapter 3 Word Chapter 4 |
|
| W04-2 | Word Chapter 5 Word Chapter 6 Word Chapter 7 |
SNAP Sample Exam Word U1 A2 |
| W05 | Class Cancelled | |
| W06-1 | Review for Tests | SNAP Word Processing Review |
| W06-2 | Tests: Concepts + WP Written & Production |
|
| W07-1 | Review WP+OS Test Intro to Spreadsheets Excel Chapter 1 |
Excel C1 Proj 1 Math Review |
| W07-2 | Excel Chapter 2 | Computer Store Group EX SNAP Excel 1 |
| W08-1 | Excel Chapter 2 More Functions - PMT - IF Dates in Excel |
|
| W08-2 | Excel Ch 3+4 | Days Alive |
| W09-1 | Excel Ch 4+5+6 | Unit 1 Assessment #5 (pg 151) |
| W09-2 | Excel Ch 7 | Excel C7 Proj 2 Unit 2 Assessment #4 (pg 311) |
| W10-1 | Review | Quality Control - In Class + Homework SNAP - Excel Concepts Review A |
| W10-2 | Tests: Spreadsheet Written & Production |
|
| W11-1 | Intro to Databases Access Chapter 1 |
SNAP - Access Ch 1 Tutorial |
| W11-2 | Access Chapter 1 | Access Ch 1 Project 1 step 15 |
| W12-1 | Access Chapter 2 Access Chapter 3 |
Print the structure of Employees table from the Premium database |
| W12-2 | Access Chapter 2+3 | |
| W13-1 | Access Ch 4 Queries w/criteria Queries w/calculated fields |
Print the structure of Employees table from the Premium database |
| W13-2 | Access Ch 4 lab | Ac_Ch4_P1a_5_h (Indianapolis query) |
| W14-1 | Access Ch 5+6 | Using the Skyline Database in the Ch4 folder: Create a query to show the reservation date, name and contact phone for all Banquets booked by Employee Michelle Zachary |
| W14-2 | Thanksgiving - NO Class | |
| W15-1 | Access Ch 6+7 Review for Test |
Using the Skyline Database in the Ch4 folder: Create a Report to show the reservation date, name and contact phone for all Banquets grouped by Employee (show the Employee full name as well) |
| W15-2 | Tests: Database Written & Production |
|
| W16-1 | Class Cancelled | Explore PowerPoint on your own |
| W16-2 | Review for Final Exam |