Lesson Plan
Curated OER

USING MICROSOFT, POWERPOINT, WORD, EXCEL AND THE INTERNET TO CREATE A PRESENTATION

For Teachers 6th - 12th
Explore the basic PowerPoint commands and options. They research information (including the WWW) related to an approved topic for presentation development. They create a presentation defined by specific criteria. They document research...
Lesson Plan
Bowland

Speed Cameras

For Teachers 6th - 9th
Do speed cameras help reduce accidents? Scholars investigate this question using a series of spreadsheet activities. Along the way, they learn about randomness, probability, and statistical analysis.
Lesson Plan
Curated OER

Lesson Plan Outline for Rainbow Science

For Students 7th - 12th Standards
Young scientists study light reflection and refraction as they determine the critical angle, the rainbow angle, and color separation in rainbows. Teams record the data they collect in a shared spreadsheet and discuss results with the class.
Lesson Plan
Curated OER

Student News And Weather Channel

For Teachers 5th
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Unit Plan
University of Missouri

Money Math

For Teachers 5th - 8th Standards
Young mathematicians put their skills to the test in the real world during this four-lesson consumer math unit. Whether they are learning how compound interest can make them millionaires, calculating the cost of remodeling...
Lesson Plan
Curated OER

Loan Amortization - Mortgage

For Teachers 9th - 12th
Upper graders explore the connection between interest and principal. They use an amortization schedule to determine the amount of principal paid vs interest on a $100,000 home loan. Fourteen discussion questions and a research-based...
Lesson Plan
Curated OER

Application and Modeling of Standard Deviation

For Teachers 9th - 12th Standards
The first activity in this resource has learners computing the mean and standard deviation of two different data sets and drawing conclusions based on their results. The second activity has them using a dice-rolling simulation to...
Lesson Plan
Curated OER

There's No Accountin with Ledgers

For Teachers 10th
Tenth graders create and maintain a ledger, write an essay for the process, and learn to keep financial accounts through the ledger. In this ledger lesson, 10th graders define an accounting ledger and create one for the money they've...