Lesson Plan
Curated OER

Who's Speaking?

For Teachers 5th - 9th
Students study the components of a good speech. They write, practice and present a speech on a topic of interest.
Lesson Plan
Curated OER

Bats and Hot Dogs

For Teachers 7th - 10th
Students identify patterns and relationships from data that is collected and solve variables.  In this investigative lesson students study ocean productivity, the nitrogen cycle and phytoplankton then answer questions.
Lesson Plan
Curated OER

Eyes on the Estuaries

For Teachers 9th - 12th
Students study estuaries and compare several ones in the U.S. In this estuary lesson plan students interpret data and compare the distribution of different species. 
Lesson Plan
Curated OER

Getting Physical with Estuaries

For Teachers 9th - 12th
Students study estuaries and how the physical factors change over time.  In this investigative lesson students use a website to gain knowledge of estuaries then in groups they create and present their charts.
Lesson Plan
Curated OER

Making Math Meaningful in March Madness

For Teachers 6th - 8th
Students examine the statistics of March Madness, the college basketball tournament. They watch videotaped basketball games to collect data for further analysis using Word and Excel. They analyze the data in a variety of activities...
Lesson Plan
Curated OER

Digital Parts of Speech

For Teachers 9th - 12th
High schoolers investigate different parts of speech by creating digital skits. In this digital education lesson, students collaborate in groups to research the Internet for clips and music that represent the different parts of speech....
Lesson Plan
Curated OER

Predicting Monthly Precipitation

For Teachers 8th - 12th
Students should log onto, and collect data from, a specific site on the Internet. They average and compare the data using the Excel spreadsheet program, make predictions from their data, and determine the percent error of their predictions.
Lesson Plan
Curated OER

The Great Chile Challenge

For Teachers 5th
Fifth graders gather data, create a graph, and interpret information. They build vocabulary by negotiating the ideas that go into the graphs which they create. They use Excel to print a variety of graphs based on how much they like Chile...
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders create a 3D Pie graph using the Chart Wizard in Excel to represent their assigned states' data. They discuss the similarities and differences between states, and form a hypothesis on the relationship between location and...
Lesson Plan
Curated OER

Range and Measures of Central Tendency

For Teachers 3rd
Third graders take notes on a PowerPoint presentation featuring calculating and analyzing data. They practice skills highlighted in the presentation and create a table in Microsoft Excel showing data analysis.
Lesson Plan
Curated OER

Just Graph It!

For Teachers 4th
Fourth graders evaluate various graphs for the best way to reflect statistical data. They use a spreadsheet to organize data and generate varied graphic representations. They select the graph they feel best shows their results.
Lesson Plan
Curated OER

Temperature Graphing

For Teachers 5th
Fifth graders analyze temperature variations throughout the world by using computer graphing of select major national and international cities.
Lesson Plan
Curated OER

Creating Bar Graphs and Pie Graphs

For Teachers 2nd
Second graders observe a demonstration of the creation of a bar graph and a pie graph of their favorite colors. They gather information about various topics from their classmates, then organize the information, creating a bar and a pie...
Lesson Plan
Curated OER

Visit My Class Wikis

For Teachers 4th - 7th
Students visit the links on the blog site to learn about class wikis. In this technology integration lesson, students visit the links to view class wikis.
Lesson Plan
Curated OER

Graphing and Analysis of Water Quality Reports

For Teachers 9th - 11th
Students practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.
Lesson Plan
Curated OER

Learning and Population Information - Where I Live

For Teachers 4th - 5th
Learners study their county populations in a multimedia presentation format. In this populations lesson, students work in groups of 3 to research the county populations in their state. Learners chart their results in an Excel document...
Lesson Plan
Curated OER

Graphing the Standard Curve

For Teachers 7th - 8th
Srudents demonstrate analysis of colorimetric assay results by analyzing them using a computer graphing program and demonstrate application of standard curves by finding other areas of science that can utilize standard curves in analysis...
Lesson Plan
Curated OER

Composting

For Teachers 8th
Eighth graders collect data from Bottle Biology compost columns and record using Excel spreadsheet.
Lesson Plan
Curated OER

Names in the Field: A Simple GPS Field Exercise

For Teachers 11th - Higher Ed
Students explore basic methods of GPS data collection, uploading the data to a computer, and making simple maps of their data using GIS software. They create a map of the data using GIS software (or Excel)
Lesson Plan
Curated OER

The Difference is the Truss

For Teachers 7th - 9th
Students use a computer to simulate building and testing bridges with various types of trusses.
Lesson Plan
Curated OER

Enhancing Writing Through Technology

For Teachers 1st - 3rd
Students participate in a class survey of their favorite activity to do in the snow and organize the results in a graph. They write a paragraph about the graph using language from a class-developed word web and include both an opening...
Lesson Plan
Curated OER

Speed + Graphing = Winners!

For Teachers 5th
Fifth graders take addition timed tests every day for a two week period. Using the data from the timed tests, they create a bar graph using Microsoft Excel computer software, a personal bar graph using graph paper and colored pencils,...
Lesson Plan
Curated OER

The Queen's Empire

For Teachers 8th
Eighth graders study insects and make observations about their habitat.  in this insect research lesson students research the Internet to compile information on ants. 
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.