Technology-Based Unit Plan for Algebra I:
Linear Data, Equations and Least Squares Regression
Kevin E Kalinowski - University of North Texas - CECS 5420: Web Authoring - SS2 2003 - Assignment 1
Students use a variety of techniques to collect data that is linear
in nature. Students interpret the slope, y-intercept and correlation coefficients
of the trend lines using least squares linear regression modeling. Students
use a spreadsheet program to store the data and generate scatter charts
based on the data. Students present their findings to their peers using
a presentation application, and publish their presentation to a web server
for peer review. Students analyze the effectiveness of various presentations
About the Plan
This Unit Plan consists of four connected lessons that spans five to
ten days, depending on the availability of technology resources and
skill level of the students. Its purpose is the connection of mathematical
concepts and integration of technology applications. Although lessons can
be used individually, it is recommended that this series of lessons be used
in its entirety and in the suggested sequence.
Prerequisite Skills and Knowledge
- Demonstrate basic Algebraic and Arithmetic skills and concepts
- State the definition of an equation, slope, and y-intercept
- Graph a linear equation on paper, using appropriate domain and range values, scales and labels
- Calculate the slope and y-intercept of a line
Materials and Equipment
- Computer Lab
- File Storage (floppy disks or networked file server)
- Internet Access
- LCD Projector connected to a computer in class
- Internet Browser
- Microsoft Excel
- Microsoft PowerPoint
- TI-83 Timer and Data Collection Programs
- Meter stick
- TI-83 Graphing Calculator
Lesson One: Cruisin'
- Introduces students to Microsoft Excel and how to use the application to produce charts and linear regression lines. Students analyze the slope, y-intercept and correlation coefficient of the lines.
Lesson Two: Down The Drain
- Continues with linear regression line analysis, but with data producing a negative slope and a y-intercept other than at the origin.
Lesson Three: Pick Some Data, Any Data
- Allows students to use the Internet to find their own real-life data to plot and analyze.
Lesson Four: It's Showtime!
- Provides an opportunity for students to present their charts and analysis, defend their work, and view the presentations of their classmates.
References and Resources