This Spreadsheet Modelling lesson plan also includes:
- Join to access all included materials
Young scholars utilize a spreadsheet to explore a mathematical model and to formulate answers to 'what if..?' questions. They assess how changes in a spreadsheet affects the results and identity of simple rules within math and statistics.
7 Views 10 Downloads
More on Modeling Relationships with a Line
How do you create a residual plot? Work as a class and in small groups through the activity in order to learn how to build a residual plot. The activity builds upon previous learning on calculating residuals and serves as a precursor to...
9th - 10th Math CCSS: Designed
New Review Creating a Payroll Spreadsheet
Automation—the easier way to determine net pay. Individuals create a spreadsheet that will calculate a person's net pay, including formulas to account for taxes. Pupils devise the calculations of gross pay based upon hourly pay, hours...
9th - 12th Math CCSS: Designed
Linear Modelling of the Life Expectancy of Canadians
Middle and high schoolers explore the concept of linear modelling. For this linear modelling lesson, pupils find the line of best fit for life expectancy data of Canadians. They compare life expectancies of men and women, and find the...
8th - 11th Math