Lesson Plan
Curated OER

Graphically Speaking

For Teachers 4th - 6th
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
Lesson Plan
Curated OER

Dental Detectives

For Teachers 1st
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Students use NASA satellite data to compare water vapor over the United States.  In this data analysis instructional activity students use an Excel spreadsheet to map their data. 
Lesson Plan
Council for Economic Education

Loan Amortization - Mortgage

For Teachers 9th - 12th Standards
When you buy a home for $100,000, you pay $100,000—right?  On the list of important things for individuals to understand, the lesson presents the concept of interest rates and loan amortization using spreadsheets and online sources....
Lesson Plan
Curated OER

"Reality Math: Fact or Fiction"

For Teachers 6th - 8th
Students investigate the use of math in everyday life. They investigate several occupations and pay scales. They complete spreadsheets that show how monthly bills can be organized using technology. They use word processing software to...
Lesson Plan
Curated OER

Money Math: Lessons for Life

For Teachers 11th - Higher Ed
Students develop a budget for a college student using all of the influences that the student would have.  In this budgeting lesson plan, students use real life examples to create a budget spreadsheet.  Students read and study...
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Lesson Plan
Curated OER

What Temperature Is It?

For Teachers 3rd - 5th
Students use the internet to research information on the average maximum and minimum temperature for a city in their state. They create spreadsheets and enter data to analyze the information, focusing on averages, maximums, minimums and...
Lesson Plan
Curated OER

American History Through Architectural Masterpieces: Monticello

For Teachers 3rd - 5th
Students examine the life of Thomas Jefferson, explore great American landmark Monticello, discover relationships between climate, geographical factors, and time as to what kind of architecture was used, conduct research online, write a...
Lesson Plan
Curated OER

Numbers, Patterns, and Algebraic Thinking

For Teachers 5th
Fifth graders use spreadsheets.
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

Creating Climographs

For Teachers 6th - 8th
Students use satellite data to compare precipitation and surface temperatures on different islands.  In this satellite lesson students create graphs and explain the differences between weather and climate. 
Lesson Plan
Curated OER

Lesson 14: Genetic Disorders

For Teachers 9th - 10th
Students create PowerPoint presentation on the topic they researched. In this biology lesson, students fill out a storyboard about their topic. They share their project in class.
Lesson Plan
Curated OER

DNA Technology

For Teachers 9th - 10th
Students prepare PowerPoint presentation on DNA and cells. In this biology lesson, students create a storyboard of their presentation. They share the finished project in class. 
Lesson Plan
Curated OER

Drawing One and Two Playing Cards With Replacement

For Teachers 6th - 9th
Math whizzes use data from simulations to make theoretical generalizations and discuss possible relationships between several given events. They use a simple card game to generate data to be analyzed.
Lesson Plan
Curated OER

Marvelous Math -- Colorful Fractions

For Teachers 2nd - 6th
Students begin the lesson by discovering that a fraction is one part of a whole. In groups, they practice reducting larger fractions into small fractions and discovering they are equal. They use blocks to identify the relationship...
Lesson Plan
Curated OER

WORKING WITH WORKBOOKS

For Teachers 5th - 8th
Students work through problems in the textbook and teacher-made problems to reinforce the new learning. They turn in practice problems to instructor to be checked for accuracy and evidence of understanding
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Lesson Plan
Curated OER

Let's Keep Track of Grades

For Teachers 7th - 8th
Students participate in a technology project. This activity is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create...
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 3rd - 6th
Learners calculate gas prices. In this transportation instructional activity, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices...
Lesson Plan
Curated OER

Who is Being Left Behind?

For Teachers 7th - 9th
Students investigate scores as they relate to race. In this algebra lesson, students analyze standardized scores and how race can affect these scores. They plot their findings on a graph and draw conclusions.
Lesson Plan
Curated OER

What Do Plants Need to Grow?

For Teachers 4th
Fourth graders control variables to determine the effect on plant growth. They collect information by observing and measuring and construct simple graphs, tables, maps and charts to organize, examine and evaluate information.
Lesson Plan
Curated OER

Fighting Obesity with Footsteps

For Teachers 1st - 5th
Analyze the influence of culture, media, technology, and other factors in health through the use of pedometers and daily walking/jogging logs with this activity. The key focus is in dealing with obesity and how small steps can help...
Lesson Plan
Curated OER

Tell Me a Story

For Teachers 10th
Tenth graders read short story, "The Storyteller" by Saki, and expand on concept of stories for students by reading and evaluating several popular students's stories as well as writing their own original students's stories.