WeekChapter/Topic/Lab
Week 7Chapter 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 8Chapter 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 9Chapter 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
Week 10Final Project 3. Capstone Intro – Smart Rental 4. Capstone Comprehensive – Costumes