Lesson Plan
Curated OER

Spreadsheet Activity

For Teachers 7th - 8th
Young scholars create a spreadsheet to match a given sample. This includes adjusting column width and row height, changing alignment, changing size and style of print, changing number format.
Lesson Plan
Curated OER

Pollution Assessment: Is Wood Lake a Good Lake?

For Teachers 7th - 8th
Young scholars become aware of pollution in Richfield Minnesota's Wood Lake, identify sources of pollution in Wood Lake, learn to use variables, equations, spreadsheets and modeling software, and generate solutions for the problem.
Lesson Plan
Curated OER

The Mayflower Compact

For Teachers 8th
Eighth graders investigate historical documents of the United States by reading the Mayflower Compact.  In this U.S. History activity, 8th graders analyze the wording of the original Mayflower Compact of the first U.S. settlers and...
Lesson Plan
Curated OER

Dino-Myte Spreadsheet

For Teachers 4th - 8th
Do your learners like dinosaurs and theme parks? An ambitious lesson invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include a...
Lesson Plan
Curated OER

Introduction to Limits

For Teachers 9th - 12th
High schoolers practice using graphing calculators and spreadsheets as they explore numeric limits using sequences and functions. They complete a sequencing worksheet, and determine which sequence corresponds to story a story called...
Lesson Plan
Curated OER

Discovering Pi

For Teachers 6th
Sixth graders measure circumference and diameter to the nearest eighth of an inch, record measurements on a spreadsheet, and use the internet to complete a "scavenger hunt" of facts concerning pi.
Lesson Plan
Curated OER

Day And Night: Interdisciplinary Study of Cyclic Change

For Teachers 8th
Eighth graders conduct a "Length of Day Symposium." They complete a variety of activities and explorations regarding the earth's rotation, its revolution around the sun and the cyclic changes in climate and energy distribution on the...
Lesson Plan
Curated OER

What's Playing Tonight?

For Teachers 5th - 9th
Pupils collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Pupils answer statistical questions regarding the data.
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

ExplorA-Pond: 6th Grade Area and Random Number Tables

For Teachers 6th
Sixth graders estimate surface area of a pond using a random number table.
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

Excel Lesson

For Teachers 4th - 5th
Pupils explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Lesson Plan
Curated OER

Excel Lesson

For Teachers 5th
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
Lesson Plan
Curated OER

All About Me: Measuring Height and Weight

For Teachers 2nd - 4th
Students take personal fitness inventories. In this personal health instructional activity, students take measurements of their heights and weights. Students record the data, calculate their BMI, and then chart their physical activity.
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
Lesson Plan
Curated OER

American Colonies

For Teachers 6th - 8th
Students record information in a database about the three American colonies. They are comparing and contrasting them. They are to log into a given database and fill in the corresponding sections. Once it is filled in the similiarities...
Lesson Plan
Curated OER

Two-Variable Linear Inequalities

For Teachers 9th - 11th
Here is an engaging lesson on solving equations with two variables. Have the class rewrite linear equations in the slope intercept form, y=mx + b. They graph the lines using the slope and y-intercepts.
Lesson Plan
Curated OER

Nascar Unit Activity 2

For Teachers 8th
Eighth graders divide into groups of 4 or 5. They go to the track and have every student run/walk one lap around the school track. Call out their times as they cross the finish line. In the computer lab, have the students create a table...
Lesson Plan
Curated OER

ICT Activity 17

For Teachers 8th
Eighth graders use a spreadsheet for the first time. They work on a selected environmental issues as their theme. Students prepare costs or income for an event that raises money for an environmental issue. They use the costs and income...
Lesson Plan
Curated OER

Newspaper

For Teachers 8th
Eighth graders, in groups, create a newspaper using topics from an assigned chapter. They use ClarisWorks word processing, insert graphics, and create graphs using spreadsheets.
Lesson Plan
Curated OER

Language Arts: A "Perfect" Lesson

For Teachers 3rd - 4th
Learners read "Be A Perfect Person in Just three days," and participate in a host of activities. Connected to technology, they use online sources to create word searches and puzzles from vocabulary words. In addition, students create...
Lesson Plan
Curated OER

Texas Weather Report

For Teachers 4th - 5th
Students 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

Baseball Statistics

For Teachers 7th - 8th
Students read "Casey at the Bat" and then use individual player statistics (found through internet research)to determine if their players could be considered baseball "heroes". They must justify their choices for "hero" by creating...
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.