| 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. Ch3 Prepare Case – Wedding
2. Ch3 Problem Solve 1 – Renovations
3. Ch3 Assessment – Car Rental
4. Ch3 Quiz
5. Business Unit 1 Assessment 1 – Room Service |
|---|
| Week 4 | Chapter 4 “Effective Charts”
1. Ch4 Prepare Case – Spa Sales
2. Ch4 Problem Solve 1 – Express
3. Ch4 Assessment – Advertising
4. Ch4 Quiz |
|---|
| Week 5/6 | Chapter 5 “Complex Logical and Retrieval Functions”
1. Ch5 Prepare Case – Pro Shop Sales Analysis
2. Ch5 Problem Solve 1 – Resource Center
3. Ch5 Assessment – Music Lessons
4. Ch5 Quiz
5. Business Unit 2 Assessment 1 – Guest Survey |
|---|
| Week 7 | Chapter 6 “Integrating Complex Functions into Business Analysis”
1. Ch6 Prepare Case Part A – Golf Data
2. Ch6 Prepare Case Part B – Sales Analysis
3. Ch6 Problem Solve 1 – Auto Sales Analysis
4. Ch6 Assessment – Video Game Sales
5. Ch6 Quiz |
|---|
| Week 8 | Chapter 7 “Multiple Worksheets, Workbooks, and Templates”
1. Ch7 Prepare Case – Spa
2. Ch7 Problem Solve 1 – Parks
3. Ch7 Assessment – Music Lessons
4. Ch7 Quiz
5. Business Unit 3 Assessment 1 – Kelly Computers |
|---|
| Week 9 | Chapter 8 “Building an Application with Multiple Worksheet and Workbooks”
1. Ch8 Prepare Case – Spa Invoice
2. Ch8 Problem Solve 1 – Gift Shop Sales
3. Ch8 Assessment – Ticket
4. Ch8 Quiz |
|---|