Lesson Plan
Curated OER

How is Your Driver Doing?

For Teachers 6th
Sixth graders explore the concept of averaging of numbers and the function of a spreadsheet. Data is collected, analyzed, and displayed in this lesson. The NASCAR race results provides the basis for the collection of data.
Lesson Plan
Curated OER

Graphing Data on Ellis Island

For Teachers 3rd
Third graders use data to make a bar graph. In this graphing and social studies instructional activity, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.
Lesson Plan
Curated OER

Food for Thought

For Teachers 3rd
Third graders conduct a survey of their class' favorite foods voting on 3-4 favorites overall. They then go to the computer lab and examine how to produce a horizontal bar graph by graphing the favorite foods of the class.
Lesson Plan
Curated OER

Bean Sprout

For Teachers 1st - 2nd
Student will track the growth of his/her bean sprout with sunlight and without sunlight over the course of 3 weeks. They will enter the results into an excel data base then graph the results of both variables to make the comparison.
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
Learners 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 learners learn to enter data into a spreadsheet, create...
Lesson Plan
Curated OER

Data! Data! Graph that Data!

For Teachers 5th
Fifth graders create data graphs using Microsoft Excel. In this data collection instructional activity, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
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 plan, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint...
Lesson Plan
Curated OER

Building My Dream House

For Teachers 7th - 8th
Learners create their dream house using a spreadsheet for measurements. In this measurements and drawings lesson plan, students apply concepts of units and conversions as they build and create different shapes. They use Google...
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

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

Bunny Cakes and Graphing

For Teachers 3rd
Third graders graph and analyze data relating to the book "Bunny Cakes" by Rosemary Wells. They listen to and discuss the book, vote on their favorite cake using Excel computer software, and discuss the results.
Lesson Plan
Curated OER

My Community

For Teachers 1st
First graders design a Powerpoint presentation to reflect information about their community.  In this community lesson plan, 1st graders create slides to explain the weather, geography and other information about the city.
Lesson Plan
Curated OER

How Much Does That Car Cost?

For Teachers 8th - 12th
Young scholars calculate how much it costs to buy a used car and finance it through a bank. They select a car from the newspaper, conduct Internet research on current auto loan interest information for four different states, and create...
Lesson Plan
Curated OER

Credit Cards and Compound Interests-Exponential Growth

For Teachers 11th
Eleventh graders investigate the way credit cards work when collecting interest. In this algebra lesson, 11th graders investigate the growth of interest exponentially when using a credit card. They calculate what the cheapest rate is to...
Lesson Plan
Curated OER

Graphically Speaking

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

Who Am I Like?

For Teachers 2nd - 3rd
Learners examine family structures. In this family structure lesson, students discover things about their own families and those of their classmates. They make a chart as they discuss nature versus nurture, complete a worksheet about who...
Lesson Plan
Curated OER

How Do Plants Grow?

For Teachers 3rd - 5th
Students investigate plant growth. In this plant growth lesson, students investigate what would happen to plants if they did not have water and sunlight. Students conduct experiments to determine what plants need. Students create a...
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Middle schoolers practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson.
Lesson Plan
Curated OER

Problem Solving with Batting Averages

For Teachers 5th
Fifth graders use data from an Excel document to analyze and predict trends in batting averages.
Lesson Plan
Curated OER

Credit Card Danger and Abuse

For Teachers 9th - 11th
Students, utilizing the computer, excel and internet, study all the downfalls of consumer debts and the complications that come with them. They assess a spreadsheet to graph their data and then present their graphs to their classmates.
Lesson Plan
Curated OER

Linear and Exponential Growth

For Teachers 8th - 11th
Students explore the concept of linear and exponential growth. In this linear and exponential growth lesson, students collect data about China's population. Students model the data to determine if it is linear or exponential.
Lesson Plan
Curated OER

Graph It

For Teachers 1st - 2nd
Students create a spreadsheet and graph using Open House attendance data.
Lesson Plan
Curated OER

Weather Watchers

For Teachers 1st - 3rd
Students practice using objective and quantitative means to describe and compare the weather. They compile weather conditions and create a spreadsheet to record their findings.