Unit 4 • Lesson 40.8h
Forecasting Logic: Predicting the Future from Past Data
Students need to understand what forecasting can and cannot do before building Excel models. This lesson bridges descriptive statistics and outliers (Lessons 2-3) to the Excel build lessons (5-6) by establishing the logic that Excel will automate.
What You'll Learn
- ▶Explain what a trend line reveals about business data and what it does not promise
- ▶Interpret the slope and fit of a regression line in business terms
- ▶Identify when forecasting is appropriate and when it creates false confidence
- ▶Use patterns in historical data to make reasonable predictions about future outcomes
Key Concepts
Trend line: A visual representation of the general direction data is moving
Slope: The rate of change - how much the outcome changes for each unit increase in the input
Fit (R-squared): How closely data points cluster around the trend line - not quality, but consistency
+1 more concepts
Lesson Phases
This lesson follows a structured 6-phase learning model designed for authentic project-based learning.
Hook
The café manager asks: 'Last year this weekend was busy - what should we expect this year?'
Introduction
Trend lines and regression: Finding the story hidden in your data
Guided Practice
Drawing and interpreting trend lines with café data
Independent Practice
Forecasting challenges with auto-checking and feedback
Assessment
MCQ exit ticket on forecasting logic and common misconceptions
Closing
Reflection and preview to Excel build lessons
How You'll Learn
Concrete café examples showing how past weekend patterns predict future performance
Representational supports using scatter plots and trend lines before any formulas
Algorithmic practice with auto-checking for forecast interpretation under reduced scaffolding