+
Lesson Plan
Curated OER

Tech Smart

For Teachers 6th
Sixth graders practice computer skills. In this technology lesson, 6th graders use programs such as Microsoft Word, Excel, Print Shop, and PowerPoint. They use the Internet for research and data collection to be incorporated in their...
+
Lesson Plan
Curated OER

Graphically Speaking

For Teachers 4th - 6th
Students discover the links between population and Congressional representation. In this government lesson plan, students research population statistics and create spreadsheets that compare population to the number of Congress members...
+
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 plan 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

What Color Are Your Skittles?

For Teachers 7th - 10th
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.
+
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 sample...
+
Lesson Plan
Curated OER

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

For Teachers 4th - 12th
Young scholars 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...
+
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
Learners 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 instructional activity, 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 instructional activity, 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
Learners 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
Young scholars 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 lesson 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
Students calculate gas prices. In this transportation lesson, 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 over time. 
+
Lesson Plan
Curated OER

Who is Being Left Behind?

For Teachers 7th - 9th
Students investigate scores as they relate to race. In this algebra instructional activity, 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.