Build the Scenario-Switch Dashboard
Lesson 06 extends Lesson 05 method outputs into a live decision tool. Students build a scenario+method selector chain, connect it to KPI interpretation, and defend recommendations with auditable workbook evidence.
- ▶Build a selector-driven workbook that switches scenario and inventory method from control cells
- ▶Use table lookups to return selected UnitsSold, COGS, and Ending Inventory from summary rows
- ▶Calculate turnover, days on hand, and gross margin from selected outputs
- ▶Run visible checks so the model is trusted before recommendation
This lesson follows a structured 6-phase learning model designed for authentic project-based learning.
Hook
Investor pressure: compare scenario and method outcomes in one live dashboard
Introduction
Teach selector controls, lookup chain anatomy, KPI formulas, and reference meanings
Guided Practice
Rehearse the workbook sheet flow with guided formula decoding and talk-through practice
Independent Practice
Build the real multi-sheet scenario-switch workbook with selector and KPI checks
Assessment
Technical check plus recommendation memo using workbook evidence
Closing
Reflect on selector fluency, model trust, and transfer to project rehearsal