| Exploring Microsoft Word 2010 | |
| 7/5 Tuesday |
Obtaining QC Username Chapter 1: Hand-on Exercise 1 - Introduction to Word Processing(p76) Chapter 1: Hand-on Exercise 2 - Document Organization (p89) Download Microsoft Word Exercises |
| 7/6 Wednesday | Chapter 1: Practice Exercise 1 (p107) Chapter 1: Practice Exercise 2 (p108) Chapter 2: Hands-on Exercise 1 - Text Formatting Features(p119) Chapter 2: Hands-on Exercise 2 - Paragraph Formatting Features (p132) |
| 7/7 Thursday | Chapter 2: Hands-on Exercise 3 - Styles (p142) Chapter 2: Hands-on Exercise 4 - Graphical Objects (p152) Chapter 2: Practice Exercise 1 (p159) Chapter 2: Practice Exercise 2 (p160) |
| 7/11 Monday | Chapter 4: Hands-on Exercise 1 - Tables (p217) Chapter 4: Hands-on Exercise 2 - Advanced Table Features (p226) Chapter 4: Hands-on Exercise 3 - Mail Merge(p241) |
| 7/12 Tuesday | Chapter 4: Practice Exercise 1 (p251) Chapter 4: Practice Exercise 2 (p252) Chapter 5: Hands-on Exercise 1 - Desktop Publishing (p268) Chapter 5: Hands-on Exercise 2 - Decorative Text and Drawing Tools (p284) |
| 7/13 Wednesday | Chapter 5: Hands-on Exercise 3 - Object Linking and Embedding (p294) Chapter 5: Practice Exercise 1 (p299) Chapter 7: Hands-on Exercise 1 - Form (p361) |
| 7/14 Thursday | Review - Practice Word Exam Word Exam Sample 1 Word Exam Sample 2 |
| 7/18 Monday | Lab Exam 1 |
| Exploring Microsoft Excel 2010 | |
| 7/19 Tuesday | Chapter 1: Hands-on Exercise 1 - Intro to Spreadsheet (p74) Chapter 1: Hands-on Exercise 2 - Mathematics and Formulas (p81) Chapter 1: Hands-on Exercise 3 - Workbook & Worksheet Management (p97) Chapter 1: Hands-on Exercise 4 - Formatting (p106) Chapter 1: Hands-on Exercise 5 - Page Setup & Printing (p114) Download Microsoft Excel Exercises |
| 7/20 Wednesday | Chapter 2: Hands-on Exercise 1 - Formula Basics (p133) Chapter 2: Hands-on Exercise 2 - Function Basics (p145) Chapter 2: Hands-on Exercise 3 - Logical, Lookup, & Financial Functions (p155) Chapter 2: Hands-on Exercise 4 - Range Names (p162) |
| 7/21 Thursday | Chapter 3: Hands-on Exercise 1 - Chart Basics (p192) Chapter 3: Hands-on Exercise 2 - Chart Design (p202) Chapter 3: Hands-on Exercise 3 - Chart Layout (p213) |
| 7/25 Monday | Chapter 4: Hands-on Exercise 2 - Excel Tables (p245) Chapter 4: Hands-on Exercise 3 - Table Manipulation & Aggregation (p257) Chapter 4: Hands-on Exercise 4 - Conditional Formatting (p271) |
| 7/26 Tuesday | Chapter 5: Hands-on Exercise 1 - Outlines & Subtotals (p292) Chapter 6: Practice Exercise 2 - Goal Seek & Scenario Manager (p376) Chapter 6: Practice Exercise 3 - Solver (p377) Chapter 9: Practice Exercise 2 - Import Text Data (p521) |
| 7/27 Wednesday | Chapter 7: Hands-on Exercise 1 - Math & Statistical Functions (p394) Chapter 7: Hands-on Exercise 2 - Logical & Lookup Functions (p406) Chapter 7: Hands-on Exercise 3 - Database Filtering and Functions (p416) Cahpter 7: Hands-on Exercise 4 - Financial Functions (p425) |
| 7/28 Thursday | Review - Practice Excel Exam Excel Exam Sample 1 Excel Exam Sample 2 |
| 8/1 Monday | Lab Exam 2 |
| 8/2 Tuesday | Setting Up Your Web Page (Windows) [Dr. Svitak] Setting Up Your Web Page (Macintosh) |
| Exploring Microsoft Access 2010 | |
| 8/3 Wednesday |
Chapter 2: Hands-on Exercise 1 - Table Design, Properties, Views, & Wizards (p126) Chapter 2: Hands-on Exercise 2 - Multiple Table Databases (p141) Chapter 2: Hands-on Exercise 3 - Single Table Queries (p158) Download Microsoft Access Exercises |
| 8/4 Thursday | Chapter 2: Hands-on Exercise 4 - Multi-Table Queries (p166) Chapter 3: Hands-on Exercise 1 - Calculations, Expressions, & Functions (p190) Chapter 3: Hands-on Exercise 2 - Expression Builder Functions, & Date Arithmetic (p203) |
| 8/8 Monday | Chapter 3: Hands-on Exercise 3 - Aggregate Functions (p215) Chapter 4: Practice Exercise 1 - Form (p287) Chapter 4: Practice Exercise 2 - Report (p288) |
| 8/9 Tuesday | Chapter 6: Hands-on Exercise 1 - Data Validation in Tables (p361) |
| 8/10 Wednesday | Review - Practice Access Exam Access Exam Sample |
| 8/11 Thursday | Lab Exam 3 |
| 8/15 Monday | Final Exam in SB C-205 |