| Week | Chapter/Topic/Lab |
|---|
| Week 10 | Chapter 9 “Organize, Import, Export, and Cleanse Data Sets”
1. Ch 9 – Prepare Case – Data Integration Part A
2. Ch 9 – Prepare Case – Data Integration Part B
3. Ch 9 – Prepare Case – Data Integration Part C
4. Ch 9 – Problem Solve 1 – Mailing List
5. Ch 9 – Assessment – Sports Store Customers
6. Ch 9 Quiz
7. Business Unit 4 Assessment 1 – Hotel Reservations |
|---|
| Week 11 | Chapter 10 “Data Tables, Scenario Manager, and Solver”
1. Ch 10 – Prepare Case – Expansion Analysis Part A
2. Ch 10 – Prepare Case – Expansion Analysis Part B
3. Ch 10 – Problem Solve 1 – Scheduling Employees
4. Ch 10 – Assessment – Extreme H2O
5. Ch 10 Quiz |
|---|
| Week 12 | Chapter 11 “Loan Amortization, Investment Analysis, and Asset Depreciation”
1. Ch 11 – Prepare Case – Constructing a Loan Analysis Part A
2. Ch 11 – Prepare Case – Constructing a Loan Analysis Part B
3. Ch 11 – Problem Solve 1 – New Investment Analysis
4. Ch 11 – Assessment – Loan Analysis
5. Ch 11 – Quiz
6. Business Unit 5 Assessment – Hotel Reservations and Room Rates Analysis |
|---|
| Week 13 | Chapter 12 “Business Statistics and Regression Analysis”
1. Ch 12 – Prepare Case – Statistical Analysis Part A
2. Ch 12 – Problem Solve – Sales Volume Analysis 1.2
3. Ch 12 Quiz |
|---|
| Week 14 | Chapter 13 “The Excel Data Model and Business Intelligence”
1. Ch 13 – Prepare Case – Dashboards KPIs and Data Visualizations 1.1
2. Ch 13 Quiz |
|---|
| Week 15/16 | Final Project
1. Capstone Intro – Smart Rental
2. Capstone Comprehensive – Costumes |
|---|