Lesson Plan
Curated OER

School Yard Waste

For Teachers 4th
Fourth graders examine the types of garbage that they collect on the playground. They collect the information in a spreadsheet and create a graph that displays the number of types of trash found. They design and monitor a playground...
Lesson Plan
Curated OER

What's Your Shoe Size? Linear Regression with MS Excel

For Teachers 8th - 12th
Learners collect and analyze data. In this statistics instructional activity, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Lesson Plan
Curated OER

Pedestrian Safety for Students

For Teachers 3rd - 4th
Students create a spreadsheet. In this spreadsheet lesson, students take the responses they received from a pedestrian safety survey to create their spreadsheet. Then they turn this information into a graph.
Lesson Plan
Curated OER

Graphing Iron Data

For Teachers 8th - 10th
Students apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Lesson Plan
Curated OER

The Expenditure Sheet

For Teachers 9th - 10th
Students differentiate between expenditure and income. In this algebra lesson, students create a spreadsheet labeling the date, item and amount as they track their expenses. They format the cells of the spreadsheet to do all the...
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Learners discover information about each of the fifty states in the United States. In groups, they create a spreadsheet organizing the information to show to the class. They discover different ways to display the data and identify the...
Lesson Plan
Curated OER

What's Playing Tonight?

For Teachers 5th - 9th
Pupils collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Pupils answer statistical questions regarding the data.
Lesson Plan
Curated OER

MAISA and the REMC Association of Michigan

For Teachers 5th - 7th
Students complete online research to study geography's impact on weather. In this geography and weather lesson plan, students research weather in their city for ten days using an online website. Students bookmark the site, enter data...
Lesson Plan
Curated OER

Curious Clouds

For Teachers 2nd
Second graders explore clouds. They read The Cloud Book by Tomie dePola. Students sort the cloud pictures into three categories. Students create a graph using the cloud pictures. They use Excel to create a bar graph.
Lesson Plan
Curated OER

Data Lesson Vital Information

For Teachers K - 2nd
Students prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.
Lesson Plan
Curated OER

Interpreting and creating tables

For Teachers 3rd - 5th
Students observe examples and discuss how to interpret them. They then brainstorm examples of possible questions students could use to create a table. They take time to formulate a question and collect data.
Lesson Plan
Curated OER

Create Your Geometry Crossword

For Teachers 10th - 12th
Students learn how to identify cell addresses, format cell contents, add pop-up comments to a cell, and also apply conditional formatting. They use clues and words to make a geometry crossword puzzle pertaining to geometrical shapes.
Lesson Plan
Curated OER

Building A Portfolio

For Teachers K - 4th
Students gather images that are part of portfolio to be shared throughout the course of one school year. They complete written reflections based upon the images that are attained. The primary sources for the images is using a digital...
Lesson Plan
Curated OER

There's No Accounting for Good Journals

For Teachers 10th
Tenth graders create journals on their spending habits. In this money-management lesson plan, 10th graders create and keep journals of their personal income and expenditures. Students learn to use Excel to create a spreadsheet for their...
Lesson Plan
Curated OER

Rock Creek Water Quality

For Teachers 9th
Ninth graders test water in a local creek using chemical kits and probes. They take GPS readings and digital photos. They calculate the Water Quality Index and create a spreadsheet of the test data.
Lesson Plan
Curated OER

Rock Creek Water Quality

For Teachers 9th
Ninth graders test water in a local creek using chemical kits and probes. They take GPS readings and digital photographs. They calculate the Water Quality Index and create a spreadsheet.
Lesson Plan
Curated OER

Putting Your Money to Work

For Teachers 9th - 11th
Pupils create a collect data on expenses. In this algebra instructional activity, students create a spreadsheet to solve scientific equations. They incorporate math, science and technology in this instructional activity.
Lesson Plan
Curated OER

Buying My First Car Worksheet 3

For Teachers 10th - Higher Ed
In this math worksheet, students create a spreadsheet for the different costs of the purchase of a car and use the information to answer 3 questions.
Lesson Plan
EngageNY

Sampling Variability in the Sample Mean (part 2)

For Students 10th - 12th Standards
Reduce variability for more accurate statistics. Through simulation, learners examine sample data and calculate a sample mean. They understand that increasing the number of samples creates results that are more representative of the...
Lesson Plan
Curated OER

Credit Cards: The Good, the Bad, and the ugly

For Teachers 10th - 12th
Learners study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...
Lesson Plan
Curated OER

Magic Number

For Teachers K
Students create addition sentences. They review number lines and how to jump between numbers to solve equations. They play the "Magic Number" game by using a spreadsheet and guessing numbers. They discuss how they found the magic numbers.
Lesson Plan
Curated OER

Do You Measure Up?

For Teachers 4th - 5th
Students measure their height and then they will input the information into a spreadsheet. After the data is entered, students will use the material gathered to create a bar graph showing the heights of people in their class.
Lesson Plan
Curated OER

What's Up With My Class

For Teachers 6th - 8th
Middle schoolers collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display...
Lesson Plan
Curated OER

Look Into My Eyes!

For Teachers 1st - 2nd
Students explore collecting, analyzing, and graphing information. They collect data on the various eye colors of their classmates. Students tally the results and create a graph.