Lesson Plan
Curated OER

Environmental Risk Analysis

For Teachers 9th - 12th
Students 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
Students 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 their...
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 lesson plan 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 instructional...
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

The Expenditure Sheet

For Teachers 9th - 10th
Students differentiate between expenditure and income. In this algebra lesson, students create a spreadsheet labeling the date, item and amount as they track their expenses. They format the cells of the spreadsheet to do all the...
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. Students make a grocery...
Lesson Plan
Curated OER

A Birthday Basket for Tia

For Teachers Pre-K
Students practice reading and math skills using technology.  In this main idea lesson, students retell the important events of A Birthday for Tia in sequence using Kid Pix.  Students create a bar graph using The Graph Club...
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 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
Learners 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 identify the...
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

Using Computers to Produce Spreadsheets and Bar Graphs

For Teachers 4th - 12th
Students review graphing terminology and how to plot data points, how to input data into a spreadsheet, and how to make a chart using a computer.
Lesson Plan
Curated OER

Finding Percent When Given A Fraction

For Teachers 7th
Seventh graders calculate percentages when given a fraction. They convert a percentage to a fraction. All of this be done by each student's ability to read the graphs made available by the spreadsheet information.
Lesson Plan
Curated OER

Spreadsheets and Database in Social Studies

For Teachers 5th
Fifth graders create/use spreadsheets to solve real-world problems, explore patterns and make predictions, select/explain most appropriate types of graph to display data, and enter data into a prepared spreadsheet to perform calculations.
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.

Other popular searches