Lesson Plan
Other

Nearpod: Spreadsheets: Using Formulas

For Teachers 9th - 10th
In this lesson on spreadsheets, students explore the different parts of a spreadsheet and use equations within spreadsheets to learn about their applications.
Activity
National Council of Teachers of Mathematics

The Math Forum: Algebraic Problem Solving Using Spreadsheets

For Students 9th - 10th Standards
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.
Lesson Plan
National Council of Teachers of Mathematics

The Math Forum: A Collection of Secondary Math Units

For Teachers 9th - 10th Standards
Teachers of grades 9-12 can explore these seven math units for their classes. Data collection and analysis, problem solving with spreadsheets, and linear transformation are just a few of the topics covered here.
Lesson Plan
National Council of Teachers of Mathematics

The Math Forum: Seventh Grade Mathematics: Data Sense

For Teachers 6th - 8th
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...
Article
LD Online

Ld Online: 10 Tips for Software Selection for Math Instruction

For Teachers Pre-K - 1st
Article at LD Online provides 10 tips to guide teachers and parents in selecting instructional math software. The focus is on instructional software such as concept development, drill and practice, tutorial and simulation software rather...
Activity
University of Waterloo (Canada)

Wired Math: Organizing Data Grade 7 [Pdf]

For Students 6th - 8th
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.
Handout
National Council of Teachers of Mathematics

The Math Forum: Spreadsheet Basics

For Students 9th - 10th
A simple introduction on how to create a spreadsheet.
Lesson Plan
Microsoft

Microsoft Education Lesson Plan: Candy Is Dandy

For Teachers 3rd - 8th
Explore color distribution of M&M candies using this detailed lesson plan. An engaging integrated lesson plan that requires understanding of spreadsheets and formulas, and logical reasoning. Links to related websites.
Interactive
American Association of Physics Teachers

Com Padre Digital Library: Open Source Physics: Data Tool Program

For Students 9th - 10th
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.
Activity
National Council of Teachers of Mathematics

The Math Forum: How to Make a Bar Graph

For Students 9th - 10th
Site contains specific directions for making bar graphs using a Claris Works spreadsheet file.
Lesson Plan
PBS

Pbs Teachers: Sports and Math: Batting Averages and More

For Teachers 9th - 10th Standards
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.
Lesson Plan
Utah Education Network

Uen: Design Your Own Bedroom

For Teachers 6th - 8th
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...