National Council of Teachers of Mathematics
The Math Forum: Algebraic Problem Solving Using Spreadsheets
A unit is presented on instructing students how to build and use spreadsheets for algebraic problem solving. Easy-to-follow steps are provided along with problems for students to practice.
Other
Nearpod: Spreadsheets: Using Formulas
In this lesson on spreadsheets, students explore the different parts of a spreadsheet and use equations within spreadsheets to learn about their applications.
University of Waterloo (Canada)
Wired Math: Organizing Data Grade 7 [Pdf]
A collection of worksheets that focus on data analysis and organizing data. Includes detailed examples, colorful visuals, and a link to a related game. Acrobat Reader required.
PBS
Pbs Teachers: Sports and Math: Batting Averages and More
Set up a spreadsheet using a computer or graphing calculator, and perform calculations using columns. Calculate percentages and solve a system of equations regarding baseball statistics.
National Council of Teachers of Mathematics
The Math Forum: Seventh Grade Mathematics: Data Sense
This site has some interesting ways to collect and evaluate data. There are some activities about note taking, spreadsheets, surveys, and a cool bridge construction project. Teachers may want to use this site as a resource for some...
National Council of Teachers of Mathematics
The Math Forum: How to Make a Bar Graph
Site contains specific directions for making bar graphs using a Claris Works spreadsheet file.
Utah Education Network
Uen: Design Your Own Bedroom
Many students dream of designing their ideal bedroom. In this exercise, students will be required to limit their designs by size (as a specific volume) and price (a specific amount). They must design the floor plan, including furniture...
Microsoft
Microsoft Education Lesson Plan: Candy Is Dandy
Explore color distribution of M&M candies using this detailed lesson plan. An engaging integrated lesson that requires understanding of spreadsheets and formulas, and logical reasoning. Links to related websites.
American Association of Physics Teachers
Com Padre Digital Library: Open Source Physics: Data Tool Program
Use this online data analysis tool to build graphs and display results from scientific investigations. Data can be entered directly with the keyboard or imported from, and exported to spreadsheets.