Lesson Plan
Curated OER

Zoo Poo

For Teachers 10th - 12th
Students use Internet research to determine the amount of carbon dioxide produced per unit energy for biomass and coal. In this alternative energy lesson, students research to find out how much energy and carbon dioxide several coal and...
Lesson Plan
Curated OER

Who Am I Like?

For Teachers 2nd - 3rd
Students 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

Atlatl Lessons Grades 4-12: Lesson for Beginning Users of Atlatl

For Teachers 6th
Sixth graders determine the mean, range median and mode of a set of numbers and display them. In this data lesson students form a set of data and use computer spreadsheet to display the information. They extend of the process by...
Lesson Plan
Curated OER

Watch Me Grow

For Teachers 2nd - 3rd
Students observe that plants need air, food, light, and water to survive.  In this plant biology lesson, students observe the growth and development of two plants, one is the control plant and the other is denied either air, water,...
Lesson Plan
Curated OER

How Much Is It?

For Teachers 6th - 8th
Learners explore foreign currencies. In this foreign currencies lesson, students simulate travel to another country and determine the value of the US dollar compared to other countries. Learners use a conversion table and search Internet...
Lesson Plan
Curated OER

Better Traffic Flow

For Teachers 11th - 12th
Students calculate the maximum number of cars passing a point in a given amount of time.  In this better traffic flow lesson, students work with an existing  Excel spreadsheet to solve the traffic flow problem.  Students...
Lesson Plan
Curated OER

Temperature High and Lows

For Teachers 5th - 8th
Students gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. students interpret the graphs to compare and contrast the data from different...
Lesson Plan
Curated OER

Kindergarten Class Favorites

For Teachers K
Students discuss their favorite foods, a list of four favorite food are compiled on the board or a chart. They each vote for their favorite food and the data is entered onto a spread sheet and a graph is created while the students watch...
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

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
Virginia Department of Education

Mystery Iron Ions

For Teachers 9th - 12th Standards
Young chemists perform an experiment to determine if a compound is iron (II) chloride or iron (III) chloride. Then they determine the formula, balance the equation, and answer analysis questions. 
Lesson Plan
1
1
Chicago Botanic Garden

Micro-GEEBITT Climate Activity

For Teachers 5th - 6th Standards
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...
Lesson Plan
Curated OER

Calculating & Graphing Using a Spreadsheet

For Teachers 11th - 12th
Students use the lab apparatus to calculate the average velocity and average acceleration at several points and record the data. They use the spreadsheets to plot distance vs. time, velocity vs. time and acceleration vs. time graphs.
Lesson Plan
Curated OER

Pedestrian Safety for Students

For Teachers 3rd - 4th
Students create a spreadsheet. For this spreadsheet lesson, students take the responses they received from a pedestrian safety survey to create their spreadsheet. Then they turn this information into a graph.
Lesson Plan
Curated OER

Getting to Know the Thirteen Colonies

For Teachers 5th
Fifth graders analyze information about the thirteen colonies. Using the information, they can manipulate and identify a region in which the colony is located. As a class, they make generalizations about the various regions and time...
Lesson Plan
Curated OER

A Healthy Heart

For Teachers 6th
Sixth graders create a spreadsheet using specific data. A speaker comes to discuss the heart, and the difference between anaerobic and aerobic activity. They make posters to encourage a healthy heart lifestyle.
Lesson Plan
Curated OER

Environmental Risk Analysis

For Teachers 9th - 12th
Young scholars complete a survey and enter the responses in a spreadsheet. The spread sheet is used to create a bar graph. Students complete spreadsheets listing types of hazards in their community.
Lesson Plan
Curated OER

M & Ms in a Bag

For Teachers 3rd - 5th
Students make predictions about the number and colors of M&M's in a snack size package. They create an Excel spreadsheet to record the data from their small group's bag, create a graph of the data, and discuss the variations of data...
Lesson Plan
Curated OER

Daily Time Ratios

For Teachers 7th - 9th
Students track and record how much time they spend on each activity. In this spreadsheet instructional activity, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time...
Lesson Plan
Curated OER

Rock Creek Water Quality

For Teachers 9th
Ninth graders test water in a local creek using chemical kits and probes. They take GPS readings and digital photos. They calculate the Water Quality Index and create a spreadsheet of the test data.
Lesson Plan
Curated OER

Rock Creek Water Quality

For Teachers 9th
Ninth graders test water in a local creek using chemical kits and probes. They take GPS readings and digital photographs. They calculate the Water Quality Index and create a spreadsheet.
Lesson Plan
Curated OER

Did Somebody Say...? Where to Work?

For Teachers 6th - 8th
Middle schoolers conduct research on four fast food restaurants to determine where they might apply for a job. They conduct research on hourly rate, working conditions, and benefits, construct a spreadsheet with a graph, and present...
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Students develop a spreadsheet containing statistical data. They describe and interpret the data to make conclusions. They review the differences between an unorganized spreadsheet verses an organized one.
Lesson Plan
Curated OER

Memory Game

For Teachers 6th - 9th
Students create cards for a memory game by entering data into a spreadsheet that is then merged into a word processing document. Tutorials are available through links on the activity page.

Other popular searches