10-week Calendar
| Week | Chapter/Topic/Lab |
|---|---|
| Week 1 | Class begins, review Syllabus, setup MyLab IT, and review LMS. Chapter 1 “Create, Navigate, Work with, and Print Worksheets” 1. Start Here Assignment 2. Ch 1 Prepare Case – Restaurant Analysis Part A 3. Ch 1 Prepare Case – Restaurant Analysis Part B 4. Ch 1 Problem Solve – Car Purchase 5. Ch 1 Assessment – Athletics 6. Ch 1 Quiz |
| Week 2 | Chapter 2 “Formats, Functions, and Formulas” 1. Ch 2 Prepare Case – Weekly Sales 2. Ch 2 Problem Solve 1 – Books Inventory 3. Ch 2 Assessment – Auto Body 4. Ch 2 Quiz |
| Week 3 | Chapter 3 “Cell References, Named Ranges, and Functions” 1. Ch 3 Prepare Case – Wedding 2. Ch 3 Problem Solve 1 – Renovations 3. Ch 3 Assessment – Car Rental 4. Ch 3 Quiz 5. Business Unit 1 Assessment 1 – Room Service Chapter 4 “Effective Charts” 1. Ch 4 Prepare Case – Spa Sales 2. Ch 4 Problem Solve 1 – Express 3. Ch 4 Assessment – Advertising 4. Ch 4 Quiz |
| Week 4 | Chapter 5 “Complex Logical and Retrieval Functions” 6. Ch 5 Prepare Case – Pro Shop Sales Analysis 7. Ch 5 Problem Solve 1 – Resource Center 8. Ch 5 Assessment – Music Lessons 9. Ch 5 Quiz 10. Business Unit 2 Assessment 1 – Guest Survey |
| Week 5 | Chapter 6 “Integrating Complex Functions into Business Analysis” 1. Ch 6 Prepare Case Part A – Golf Data 2. Ch 6 Prepare Case Part B – Sales Analysis 3. Ch 6 Problem Solve 1 – Auto Sales Analysis 4. Ch 6 Assessment – Video Game Sales 5. Ch 6 Quiz |
| Week 6 | Chapter 7 “Multiple Worksheets, Workbooks, and Templates” 1. Ch 7 Prepare Case – Spa 2. Ch 7 Problem Solve 1 – Parks 3. Ch 7 Assessment – Music Lessons 4. Ch 7 Quiz 5. Business Unit 3 Assessment 1 – Kelly Computers Chapter 8 “Building an Application with Multiple Worksheet and Workbooks” 1. Ch 8 Prepare Case – Spa Invoice 2. Ch 8 Problem Solve 1 – Gift Shop Sales 3. Ch 8 Assessment – Ticket 4. Ch 8 Quiz |