Lesson Plan
Curated OER

What's your favorite physical fitness activity?

For Teachers 4th
Fourth graders engage in a class discussion where they create a list of their favorite physical fitness activities. They tally the numbers on the board and use Microsoft Excel to create a spreadsheet and graph of the activities.
Lesson Plan
Curated OER

The Write Stuff

For Teachers 4th
Fourth graders share a previously written portfolio piece and the class guesses the genre. Students use tally marks to keep track of how many of each piece there are in class. Once the data collection is complete, 4th graders create a...
Lesson Plan
Curated OER

The Nifty Fifty-What's Your Size?

For Teachers 3rd - 5th
Students explore state populations. In this state geography activity, students use a variety of technology tools to research and graph population and area of assigned states.
Lesson Plan
Curated OER

The Election Connection

For Teachers 3rd - 5th
Learners participate in a mock election. In this election lesson, students vote online in a mock election, graph the results, and compare their results to the nationwide results.
Lesson Plan
Curated OER

Shared Birthdays

For Teachers 6th - 8th
Students gather information on their classmates birthdays and create a spreadsheet with the dates. Using the internet, they find a famous person who shares their own birthday. They research the life of the famous person and develop a...
Lesson Plan
Center Science Education

Weather and Climate Data Exploration

For Teachers 6th - 12th Standards
Access local temperature data online, graph averages, and critique it. Learners listen to a scenario where weather and climate are confused, and then answer questions to differentiate the two. The lesson itself is compact, but there is a...
Lesson Plan
Curated OER

Buying a Car

For Teachers 8th
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
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

Reading & Using a Nutrition Label

For Teachers 8th - 12th
Students discover the importance of healthy eating. Using food nutrition labels, they read and examine the nutritional value. Students collect the data on a spreadsheet and create a graph. They analyze the media influences on product...
Lesson Plan
Curated OER

I'm in the Money - Practical Money Skills

For Teachers 3rd - 6th
Students make a budget and utilize math skills to keep a record of what they spend. They use technology and spreadsheets to help them keep track of their money.
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders create a 3D Pie graph using the Chart Wizard in Excel to represent their assigned states' data. They discuss the similarities and differences between states, and form a hypothesis on the relationship between location and...
Lesson Plan
Curated OER

BRIDGING THE GENERATION GAP

For Teachers 9th - 12th
High schoolers create a hypothesis about the attitudinal differences between generations, test their hypothesis with a survey, chart their findings, and present their answers to the class.
Lesson Plan
Curated OER

Ready, Set, Go!

For Teachers 6th - 8th
Middle schoolers predict if the height of a ramp affect how far an object travels. They design and conduct an experiment to test their predictions. The results are recorded and a graph is created to show the relationship between ramp...
Lesson Plan
Curated OER

The Effects of Weather on People

For Teachers Pre-K - 2nd
Students discover the causes of different types of weather and it's effect on society.  In this environmental lesson, students utilize the Internet to examine cloud types, normal weather conditions and the type of weather considered...
Lesson Plan
Curated OER

Band Tour Across America

For Teachers 8th - 10th
Students plan the trip of a band across America. In this money planning lesson, students create a budget for the band using excel basic functions. They manage the band and its budget and relate the tour to future budgeting needs of the...
Lesson Plan
Curated OER

The Great Chile Challenge

For Teachers 5th
Fifth graders gather data, create a graph, and interpret information. They build vocabulary by negotiating the ideas that go into the graphs which they create. They use Excel to print a variety of graphs based on how much they like Chile...
Lesson Plan
Curated OER

Checking County Numbers

For Teachers 4th - 8th
Learners use their county's information page to gather information about their community. Using the information, they create graphs from the tables provided and interpret the data. They write a paragraph showing their interpretation of...
Lesson Plan
Curated OER

The Breathtaking Nature of the Urban Explosion, Part 2

For Teachers 9th - 12th
Students explore ozone levels. They measure the concentrations of ground-level ozone in the atmosphere. Students observe changes in the concentrations of ozone over time. Students complete a data sheet to record ozone readings over a...
Lesson Plan
Curated OER

Learning About Graphics

For Teachers 4th - 6th
Students practice using and filling in a spreadsheet. They also create graphs and charts that coorespond with the data. This is a unit comprised of four lesson plans.
Lesson Plan
Agriculture in the Classroom

The Garden Chef

For Teachers K - 7th
Introduce young chefs to nutritious eating with a cookbook that is divided into sections focusing on one of the five food groups. It includes lessons, activities, and recipes. How wholesome!
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

Technobiz

For Teachers 8th - 12th
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz instructional activity, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced...
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

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...