Orient to the shared workbook, evidence blocks, and Definition of Done
Download and open the rehearsal workbook. Every group in class has the exact same café data.
Download:
unit04-cafe-rehearsal.xlsxThe student workbook uses the same data as the teacher workbook. When we compare work today, we're comparing the quality of reasoning, not different datasets.
Every sheet in this workbook serves a specific job in the evidence chain. Here's what each one proves:
Data Sheet
Raw café weekend sales data — the foundation. Without clean data, nothing else is trustworthy.
Analysis Sheet
Descriptive statistics (average, median, spread) that describe what a "normal" café weekend looks like.
Forecasting Sheet
Trend line and regression that predicts the next quarter — with clear limits on what it promises.
Dashboard Sheet
Visuals that tell the data story — clean, bound to tables, and decision-ready.
Recommendation Sheet
Final claim + evidence + risk. This is what the investor sees — and what must trace back to every sheet above.
A complete project workbook must include:
- Data sheet: Clean, analysis-ready data with documented source
- Analysis sheet: Descriptive stats that describe the "normal" pattern
- Forecasting sheet: Trend + regression with clear limits stated
- Dashboard sheet: At least two visuals that support the recommendation
- Recommendation sheet: One clear claim, evidence from data, and one risk or limitation
- Evidence trace: The recommendation can be traced back through all sheets to the raw data