Lesson Plan
Curated OER

Acid Rain in our State

For Teachers 6th - 12th
Students conduct internet research on acid rain, a serious environmental problem. They examine the pH levels of rainwater for their state, collect data from their community and investigate the causes and solutions for acid rain.
Lesson Plan
Curated OER

Geometric Sequences and Series

For Teachers 9th - 12th Standards
Learn to calculate the nth term of a sequence defined by an algebraic expression. They examine geometric sequences and series, relate geometric sequences to their explicit forms, find the partial sums of a sequence in a table, and...
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature instructional activity, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend...
Lesson Plan
Curated OER

Using Tables to Solve Linear Functions

For Teachers 9th - 12th Standards
Oh that intercept! Budding algebra masters solve linear equations from standard to intercept form. They identify the slope and y-intercept to help graph the lines, an then create coordinate pairs using a table of values. Great TI tips...
Lesson Plan
Curated OER

Number and Algebra: Again and Again

For Teachers 5th - 9th
Students use a given spreadsheet to investigate an iterative process by changing the variables. They design their own spreadsheet to investigate the iterative process.
Lesson Plan
Curated OER

Measuring "pHacts" about Acid Rain

For Teachers 6th
Sixth graders gather and graph information regarding the pH of rain. Working cooperatively with an internet partner, 6th graders gather and record information about the pH of the rain in their local area. They graph this information...
Lesson Plan
Curated OER

Rouge River Data

For Teachers 3rd - 5th
Students participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.
Lesson Plan
Curated OER

Open Door, Closed Door Lesson Plan: Discrimination in Immigration And Migration

For Teachers 6th - 8th
Students read The Northern Migration and research immigration policies of different nations for the past and the present. They create a bulletin board or spreadsheet using their information.
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction instructional activity, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Lesson Plan
Curated OER

Graphing Data on Ellis Island

For Teachers 3rd
Third graders use data to make a bar graph. In this graphing and social studies lesson, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.
Lesson Plan
Curated OER

Peopling the New World -- An Archaeological Exercise in Excel

For Teachers 6th - 8th
Students examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in other...
Lesson Plan
Curated OER

Who's Going to the Convention?

For Teachers 9th - 12th
High schoolers practice planning budgets as they create a budget for ten employees of a company to attend a professional convention. They use the Internet, and spreadsheet software to complete their assignment.
Lesson Plan
Curated OER

Trends in Precipitation

For Teachers 8th
Eighth graders study about precipitation and graph the information. They look for patterns in a scatter graph and make inferences based on what they see. They need to see a relationship between location and the amount of precipitation.
Lesson Plan
Curated OER

The Breathtaking Nature of the Urban Explosion, Part 2

For Teachers 9th - 12th
Students explore ozone levels. They measure the concentrations of ground-level ozone in the atmosphere. Students observe changes in the concentrations of ozone over time. Students complete a data sheet to record ozone readings over a...
Lesson Plan
Curated OER

Personal Budgeting Project

For Teachers 8th - 11th
Students create an Excel spreadsheet of a personal budget by estimating their possible income and monthly expenses from a worksheet. They group together to create a family unit and use the personal budget sheets to plan a family budget.
Lesson Plan
Curated OER

Investigation of Hooke's Law Lab

For Teachers 11th - 12th
Students determine the spring constant by conducting an investigation. In this physics lesson, students collect data and create a graph of force vs. displacement. They compare the results of two different methods to find spring constant.
Lesson Plan
Curated OER

Canadian Cities

For Teachers 5th
Fifth graders gather population data on twelve cities in Canada. They present the information on a spreadsheet and sort the data on two different types of graphs. They create a generalization for the data that they collected.
Lesson Plan
Curated OER

World Education Statistics

For Teachers 9th - 12th
Students use a spreadsheet from The Digest of Education Statistics and convert the statistics to percentages, and create a chart of their new data. Students discuss their findings about the disparities in educational spending among...
Lesson Plan
Curated OER

Four 4's

For Teachers 7th - 8th
Students use the numbers 24 and 44 as well as four more fours to create a series of equations. Each equation should equal a number from 1-20. They work to find an equation for each number.
Lesson Plan
Curated OER

Inching Our Way Into The Metric System

For Teachers 6th - 8th
Students investigate the Metric System. They discuss the history of the Metric System, convert various units of measurement into the Metric System, and solve problems on a spreadsheet.
Lesson Plan
Curated OER

How Many M&M's

For Teachers 4th - 6th
Learners explore sets and collections. Students find the colors of M&M's and the amount of M&M's each student has. They organize this information into an Excel spreadsheet. Learners use the chart wizard to create a graph.
Lesson Plan
EngageNY

Federal Income Tax

For Students 9th - 10th Standards
Introduce your class to the federal tax system through an algebraic lens. This resource asks pupils to examine the variable structure of the tax system based on income. Young accountants use equations, expressions, and inequalities to...
Lesson Plan
Curated OER

Technology - Data Collection

For Teachers 8th - 10th
Students collect and analyze data from the United States Census Bureau. Using spreadsheet technology, students explore their results and make preductions about income groups. Students compute the mean, median and mode. They create...
Lesson Plan
Curated OER

African Safari

For Teachers 5th - 7th
Students create an Excel spreadsheet that show a budget for a trip to Africa to see wildlife. In small groups, they complete internet research to determine the countries and sites to visit then calculate the costs involved for the trip....