Linear Data, Equations and Least Squares Regression

Overview

Provides an opportunity for students to present their charts and analysis,
defend their work, and view the presentations of their classmates.

Materials and Equipment

- Computer Lab
- Microsoft Excel
- Microsoft PowerPoint
- LCD Projector connected to a computer in class

Learning Objectives

- Design a PowerPoint presentation
- Integrate an Excel spreadsheet and chart into their presentation
- Explain their reasoning for selecting data
- Defend their analysis about the slope, y-intercept and correlation coefficient of their least squares regression line

Guiding Questions

- What similarities did you notice among the graphs in the presentations?
- What differences did you notice? What caused these differences?
- Was the data presented in the graphs represented appropriately?
- Was the analysis of the slope, y-intercept intercept and correlation coefficient valid for the given data?
- Were some presentations more effective than others? What elements made them so?

Lesson Outline

- Use the same pairing of students as in Lesson Three.
- Have students create a 5 minute, 5 slide PowerPoint presentation based on one of the data sets from Lesson Three. Make sure they include an introductory slide, three informational and analysis slides, and one conclusion slide. Make sure they integrate the data and chart from their Excel spreadsheet created in Lesson Three.
- Have students present their presentations to the class. Make sure they make observations about the data and analysis, as well as the layout and presentation of the information.
- Use the presentations to facilitate answers to the Guiding Questions. Pay particular attention to the graphs, the analysis of the slope, y-intercept intercept and correlation coefficient, and the effectiveness of the presentations.

Assessment

- Homework or Quiz based on Guiding Questions
- Presentation Peer Review (Peer Review Worksheet)
- PowerPoint Presentation (Presentation Rubric)