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

Which Color Will You Pick?

For Teachers 5th - 6th
Students create a spreadsheet to chart the different colors found in a package of M&M's or Skittles. They collect data, create appropriate charts, and use percentages to describe quantities.
Lesson Plan
Curated OER

Technology Integration Lesson Plan: Civil War Spreadsheet

For Teachers 8th
Eighth graders discuss and analyze Civil War data, manually graph data on handout, work with partners to enter data into spreadsheets, and create charts on spreadsheet for each data set.
Lesson Plan
Curated OER

The People Behind the Numbers

For Teachers 10th
Tenth graders brainstorm potential definitions for "developed" and "developing" countries. They work in groups of four and research using Web sites listed to find information about their country then they create a spreadsheet which...
Lesson Plan
Curated OER

Fraction Strips on Excel

For Teachers 6th
Sixth graders create three different sets of fraction strips using Excel by following a packet of instructions that taper off as the students gain confidence in their knowledge of Excel. They copy and paste the strips into Word so that...
Lesson Plan
Curated OER

Phenomenal Weather-Related Statistics

For Teachers 8th
Eighth graders research, collect and interpret data about weather statistics. They record that data on spreadsheets. they create Powerpoint presentations on their individual or group research.
Lesson Plan
Curated OER

Bubble Gum Chemistry

For Teachers 8th - 10th
Students explore the concept of graphing data. In this graphing data instructional activity, students determine the percentage of sugar in bubble gum. Students graph type of gum vs. sugar percentage. Students create a table of their data.
Lesson Plan
Curated OER

Following the Stock Market With a Palm

For Teachers 10th - 12th
Students research and explore the stock market. They research a three-year history of stocks, develop a group and individual spreadsheets, and follow their stocks and prices for a ten-day period, graphing the results.
Lesson Plan
Curated OER

Understanding Cloud Formation

For Teachers 3rd - 5th
Students read and relate the poem, "Clouds" by Aileen Fisher to a demonstration on cloud formation. They create clouds in jars using ice water and matches then discuss the ways clouds can be used to predict weather.
Lesson Plan
Curated OER

Escape The Hangman

For Teachers 7th
Seventh graders investigate the concept of probability. They use the game of hangman to create engagement and context for conducting the lesson. They create a spreadsheet with data that is given. Students make predictions based on data.
Lesson Plan
Curated OER

SolidWorks for Sheet metal

For Teachers Higher Ed
Students practice using the different tools on the Sheet Metal toolbar. In this engineering lesson, students create a sketch given a set of procedures to follow.
Lesson Plan
Curated OER

Irish Eyes: Taking a Look at Local Landscape

For Teachers 9th - 11th
Students create landscape flyers of local landscapes using digital photography, educational software, and examples of Irish landscapes. This creative-project lesson lasts two weeks, including class time spent collecting photographs...
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

Texas Weather Report

For Teachers 4th - 5th
Young scholars use provided links to observe selected weather sites and collect temperature and precipitation data for listed cities. They enter the information onto their spreadsheet. Students study maps of the Texas natural reagions,...
Lesson Plan
Curated OER

Polygons

For Teachers 4th
Fourth graders identify and describe lines, shapes, and solids using formal geometric language. They use Inspiration to create a graphic organizer and outline of polygons.
Lesson Plan
Curated OER

Weather Systems

For Teachers 4th
Fourth graders research weather phenomenon in groups on the Internet and create a slide for the class power point presentation. They include 5 key points (temperature, air pressure, and fronts and descriptions for each type of cloud or...
Lesson Plan
Curated OER

Reaching the Solar System

For Teachers 3rd - 5th
Students sing the Rap of the Solar System, view pictures of the planets, and calculate their weights and ages on all the planets and the sun. They create a presentation comparing themselves with a planet or object in the solar system.
Lesson Plan
Curated OER

Data Days

For Teachers 6th
Sixth graders practice collecting, organizing and displaying data. They create circle, bar, line and picto graphs. They analyze data in small and large sample groups.
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

Around and Around

For Teachers 6th - 8th
Students create a spreadsheet to record information about circular objects. They measure and record information from a variety of objects. Students calculate the ratio of the circumference to the diameter of each object. They find the...
Lesson Plan
Curated OER

Graphing Grazy Crayons

For Teachers 2nd
Children create crazy crayons they made to sort and construct a floor bar graph. Then, using technology resources, they make a simple bar graph to compare the top four colors produced. Students will then interpret the printed graph by...
Lesson Plan
Curated OER

Best Buy!!

For Teachers 6th - 8th
Students use newspaper ads to determine the best buy on products. They enter the information into a spreadsheet and then use word processing software to complete a written analysis, complete with graphs.
Lesson Plan
Curated OER

Home on the Biome

For Teachers 5th
Fifth graders study six major biomes, graph temperature and rainfall, and present their findings to the class.
Lesson Plan
Curated OER

The Transformer

For Teachers 4th
Fourth graders practice measuring different objects in inches. Individually, they estimate the length of the same object in centimeters and then calculate the actual length. They compare and contrast their estimate to the actual length...