Lesson Plan
Curated OER

Graphing Pockets

For Teachers 2nd
Second graders explore graphing. They count the number of pockets on their clothes and use Microsoft Excel to enter their data. Students create a class graph displaying their findings.
Lesson Plan
Curated OER

Eerie Indiana!

For Teachers 11th
Eleventh graders research the population for ten cities in their state, in this example, Indiana, using census information. They design a spreadsheet using the data and create a bar graph with the data. They complete follow up questions.
Lesson Plan
Curated OER

How Well Will I Eat This Week?

For Teachers 8th
Eighth graders develop a healthy menu for the coming week using Palm technology to develop healthy eating habits. They develop a spreadsheet for the seven days and for each menu using the Palm.
Lesson Plan
Curated OER

Cloud Discovery

For Teachers 3rd - 5th
Students create a slideshow that pictorially depicts a variety of cloud types. They research clouds, develop and present the slideshow and then evaluate their efforts based on a rubric for self-evaluation.
Lesson Plan
Curated OER

Cloud Discovery

For Teachers 4th - 6th
Students create a HyperStudio stack that describes and illustrates twelve different kinds of clouds. They then make inferences about which types of weather the different types of clouds could help predict.
Lesson Plan
Curated OER

Virtual Field Trip / Route, Mileage and Gasoline Cost Graphs

For Teachers 4th - 6th
Students use a spreadsheet program to graph and compare milage, gasoline costs and travel time for two travel routes in their virtual field trip in Michigan. They determine the most economical route based on the graphs and calculations.
Lesson Plan
Curated OER

Remembering Our Veterans Data Management Project

For Teachers 7th
Seventh graders utilize data collected from various sources based on Canadian military statistics to consolidate their understanding of data management. Students plan and create a PowerPoint presentation using this data including in...
Lesson Plan
Curated OER

The Solar System

For Teachers 7th - 8th
Students research the characteristics of planets in our solar system. In this space science lesson, students create a solar system model with each planet arranged according to their distance from the sun. They solve problems using the...
Lesson Plan
Curated OER

Accounting

For Teachers 10th - 11th
Learners create bank reconciliation spreadsheet. In this algebra lesson, students discuss the basics about business, money and bank accounts. They use a bank reconciliation statement correctly.
Lesson Plan
Curated OER

Fruit Loop Graphing

For Teachers 5th
Fifth graders interpret data and create graphs. Given Fruit Loops, they sort and classify according to color. Using spreadsheet technology, 5th graders record their data and create bar and circle graphs. Students analyze data and...
Lesson Plan
Curated OER

The Stock Market Game

For Teachers 5th - 8th
Young scholars participate in a variety of stock market games within their classmates. They study the concepts of stocks and investments as well as the criteria for selecting of stocks. Each student is shown how to keep track of the...
Lesson Plan
Curated OER

When Dinosaurs Ruled the World

For Teachers 3rd - 4th
Students graph the varying sizes of dinosaurs.  In this math and dinosaur lesson, students view dinosaur models and compare the different shapes and sizes of the dinosaurs.  Students complete a dinosaur math activity, read The...
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...
Lesson Plan
Curated OER

Not So Simple Machines

For Teachers 6th - 8th
Students design a simple machine for a simple machine contest. In this simple machine lesson plan, students design a simple machine that will solve a problem. They draw a diagram, label it, and test the machine before they present it in...
Lesson Plan
Curated OER

Bingo!

For Teachers 1st
First graders practice and reinforce phonics and/or math skills by creating Bingo! game using computer spreadsheet. Students incorporate phonics or math skills class has been practicing onto Bingo! cards, which can be printed and made...
Lesson Plan
Curated OER

Let's Measure

For Teachers 2nd - 3rd
Students measure shells using 3 different methods.  In this measurement lesson, students work in two groups to measure the length of a shell using two different units of measure.  The groups compare their results, measure the...
Lesson Plan
Curated OER

Does Your Fitness Compute?

For Teachers 4th
Fourth graders chart and analyze baseline data pertaining to improving and maintaining fitness levels. Personal trainers calculate their clients' charts and write a one-page report on the findings for the evaluation portfolio of each...
Lesson Plan
Curated OER

Linear and Exponential Models

For Teachers 9th - 12th
Learners investigate the differences between linear and exponential models.  In this linear and exponential models instructional activity, students make a table of given data.  Learners determine if the data is linear or...
Lesson Plan
Curated OER

Lemonade Business

For Teachers 12th
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.
Lesson Plan
Curated OER

The Iditarod Adventure

For Teachers 9th - 12th
Students use the internet to follow the Alaskan Iditarod race as well as perform research. This project-based activity will result in students creating many desktop publishing documents.
Lesson Plan
Curated OER

Small Business

For Teachers 6th - 12th
Students simulate owning and running a small business by playing Lemonade Stands. They play the game for three weeks, then work with a partner to produce a Power Point presentation which would be given to a Board of Directors showing...
Lesson Plan
Curated OER

Giving'Em The Business

For Teachers 1st - 2nd
Students work in groups of 4-5 to form a business, create, market & sell their product, and track their expenses and profits. They experience the roles of producer, distributor, and consumer of goods. They collect, organize and...
Lesson Plan
Curated OER

Polluting the Environment

For Teachers 4th
Fourth graders construct mini-ecosystem, pollute the ecosystem, observe, collect, and record data on the effects of these pollutants on their ecosystem, organize data on spreadsheets, create graphs, and design presentations to share with...
Lesson Plan
Curated OER

Catholic Schools in the Community

For Teachers 3rd - 4th
Students are provided with a multimedia Power Point presentation that explains the educational opportunities that are available at the St. Mary Catholic School. They are presented with all facts along with the community as a whole and...