Lesson Plan
Curated OER

United States Regions

For Teachers 5th
Fifth graders identify the regions of the United States. They gain general knowledge of Regions of the U.S., create a spreadsheet and use word processing to create a report.
Lesson Plan
Curated OER

Density Lab

For Teachers 9th - 12th
Pupils use an Excel spreadsheet to calculate the density various liquids. They take pictures of their results.
Lesson Plan
Curated OER

Camouflage in Animal Habitats

For Teachers 6th - 8th
Students investigate how animals in an ecosystem interact with a nonliving environment through camouflage. They work in cooperative groups to "go fishing" and record how many of each color of fish they "catch." After entering data on a...
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

Behold the Wonder of Creation

For Teachers 5th
Fifth graders explore and become familiar with U.S. National Parks. They research several parks and compile the information they find into a spreadsheet. They plan and write a report/booklet about one of the U.S. National parks.
Lesson Plan
Curated OER

Learning About Graphics

For Teachers 4th - 6th
Students practice using and filling in a spreadsheet. They also create graphs and charts that coorespond with the data. This is a unit comprised of four lesson plans.
Lesson Plan
Curated OER

Cloud Databases

For Teachers 7th - 9th
Students complete a unit on clouds and a report about one type of cloud. They collect data through observation about different types of cloud cover and then create a spreadsheet to reflect their observations over a 2 week period.
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

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

Sampling Variation in a Natural Population

For Teachers 9th - Higher Ed
Students examine the phenotypic variation within a natural population of a single species. They collect data on the species and analyze the data using statistical/spreadsheet software. Students interpret their results and present their...
Lesson Plan
Curated OER

Stock Market Math

For Teachers 7th - 9th
Students select a company that they like and using technology, in teams, they prepare a class presentation about their company. The class have the option to buy stock or choose a competitor. Each team research a company and buy...
Lesson Plan
Curated OER

Virtual Field Trip / Route, Mileage and Gasoline Cost Graphs

For Teachers 4th - 6th
Pupils use a spreadsheet program to graph and compare milage, gasoline costs and travel time for two travel routes in their virtual field trip in Michigan. They determine the most economical route based on the graphs and calculations.
Lesson Plan
Curated OER

How's the Weather

For Teachers 4th - 8th
Students explore weather patterns. They collect and record all aspects of the weather from various sites. Students investigate regional weather and use a spreadsheet to record and chart data. Students chart temperature, humidity,...
Lesson Plan
Curated OER

Animals In Your Neighborhood

For Teachers 3rd - 5th
Students make list of all animals they have seen in their backyards, neighborhoods, and around school in past week, graph animals using computer spreadsheet program, and compare graphs through email with students in another class.
Lesson Plan
Curated OER

How Many M&M's

For Teachers 4th - 6th
Students 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. Students use the chart wizard to create a graph.
Lesson Plan
Curated OER

Statistics and Graphing with Accelerated Math

For Teachers 3rd - 7th
Students create charts and graphs, using a spreadsheet program, of their results from their accelerated math lessons. Students discover how graphs can be used to interpret data in our everyday lives as well as how several different...
Lesson Plan
Curated OER

Body Part Measurements

For Teachers 2nd
Second graders participate in a review of how to use rulers and yard sticks while collecting measurement information. They measure assigned body parts and chart the data on collection sheets. They make a spreadsheet with the information...
Lesson Plan
Curated OER

Eerie Indiana!

For Teachers 11th
Eleventh graders research the population for ten cities in their state, in this example, Indiana, using census information. They design a spreadsheet using the data and create a bar graph with the data. They complete follow up questions.
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

A RealSim Surface Look at Descriptive Statistics

For Teachers 5th - 12th
Learners explore the concepts of mean and variance. They observe properties of materials to their basic atomic or molecular structure. Students use spreadsheet software to record, tabulate and analyze collected information.
Lesson Plan
Curated OER

Weight in Water

For Teachers 3rd - 4th
Students investigate why some materials are able to float while others sink. They carry out a scientific investigation, predict and test their predictions. They record their results in a spreadsheet, and use a forcemeter in another...
Lesson Plan
Curated OER

Demographic Changes in 19th Century England and Wales

For Teachers 7th - 12th
Students examine population in England and Wales during the period of 1801-1911. They calculate the percentage of population and how it changed from one census to the next in various towns. They record data on a spreadsheet and create...
Lesson Plan
Curated OER

Job Distribution After 1945

For Teachers 7th - 10th
Students research job distribution in the U.S. after 1945. They study a spreadsheet of employment data and identify changes in the distribution of jobs in America since World War II. They create pie charts reflecting the data of jobs...
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...

Other popular searches