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.
Lesson Plan
Curated OER

Interest Calculation and Spreadsheets

For Teachers 5th - 12th
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Lesson Plan
Curated OER

Digestive System

For Teachers 6th - 8th
Students explore the parts of the digestive system. Using interactive spreadsheet software, students observe, name and describe the function of each part of the digestive system. Students may work individually or in pairs.
Lesson Plan
Curated OER

Introductory Excel Lesson involving Problem Solving

For Teachers 6th
Sixth graders analyze an introductory lesson for Microsoft Excel. They go step by step through the creation of a basic spreadsheet and the use of simple formulas in a problem solving format.
Lesson Plan
Curated OER

Math and the NFL - Statistical Representations

For Teachers 7th
Seventh graders use the Internet to get current sports information for data analysis. They use their data to find the mean, median, mode and range. Students then place their data on a spreadsheet.
Lesson Plan
Curated OER

There's No Accounting for Good Journals

For Teachers 10th
Tenth graders create journals on their spending habits. In this money-management lesson plan, 10th graders create and keep journals of their personal income and expenditures. Students learn to use Excel to create a spreadsheet for their...
Lesson Plan
Curated OER

Technology vs. Nontechnology

For Teachers 4th
Fourth graders determine the range, mean, median and mode using a computer spreadsheet. An identical set of calculations is done without using a computer. The results of each method are compared. They calculate the mode, median and range...
Lesson Plan
Curated OER

Real-World Linear Equations

For Teachers 8th
Eighth graders practice technology skills through the use of a spreadsheet and a discovery lesson plan focusing upon linear equations. The technology allows for the visual changes to be displayed for different lines of equations.
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Young scholars discover information about each of the fifty states in the United States. In groups, they create a spreadsheet organizing the information to show to the class. They discover different ways to display the data and...
Lesson Plan
Curated OER

A Christmas Project

For Teachers 7th
Seventh graders publish a letter and spreadsheet using the computer. They build a three-dimesnsional object with construction paper and develop a Christmas object using coordinates on a graph. Students compose a response in their journals.
Lesson Plan
Curated OER

Thanksgiving Feast

For Teachers 7th - 9th
Use the Tool Factory Workshop to have your class create a list of people to invite to their Thanksgiving Feast.They will take pictures related to the fall season and create invitations using Tool Factory Database. Learners make a grocery...

Other popular searches