+
Lesson Plan
Curated OER

Penny Pushing

For Teachers 5th
Fifth graders use an Excel spreadsheet to show them how to enter the amount of pennies they bring each week to school for a fundraising project. They count their pennies each Friday and enter the total amount in the correct columns. In...
+
Lesson Plan
Curated OER

Flavorful Spreadsheets

For Teachers 4th - 8th
Students create a spreadsheet which includes a bar graph. They sort and classify information and use the average function on a spreadsheet. They research Skittles candy and summarize their findings on a spreadsheet.
+
Lesson Plan
Curated OER

Introduction to Spreadsheets

For Teachers 6th
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
+
Lesson Plan
Curated OER

The Viewing Tube

For Teachers 5th - 8th
Looking for an excellent lesson that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet.  This is a very...
+
Lesson Plan
Curated OER

Moving Day!

For Teachers 8th
Eighth graders continue their geometry unit by focusing on volume. Using data, they create a spreadsheet, estimate and calculate volume. They solve real-life problems and round their answers to the hundredths place. They also practice...
+
Lesson Plan
Curated OER

Louisville's Best Field Day Park

For Teachers 7th - 12th
Students create a survey to hand out to determine the best field day park. Using their local area, they select five parks, if possible, that meet the criteria and calculate the distance and estimated time travel. They use this...
+
Lesson Plan
Curated OER

Getting It Right!

For Teachers 6th - 8th
Pupils construct right triangles, measuring the sides and recording the measurements in spreadsheets. They analyze their measurements for patterns and research the Internet for information on Pythagoras.
+
Lesson Plan
Curated OER

"Reality Math: Fact or Fiction"

For Teachers 6th - 8th
Students investigate the use of math in everyday life. They investigate several occupations and pay scales. They complete spreadsheets that show how monthly bills can be organized using technology. They use word processing software to...
+
Lesson Plan
Curated OER

Excel Lesson

For Teachers 4th - 5th
Students explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
+
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
+
Lesson Plan
Curated OER

Computer Science: Pendulum

For Teachers 7th - 9th
Students investigate the basic properties of pendulums as a function of spreadsheets. Working in groups, they measure the period for a pendulum at six different lengths and record the results. They prepare a file using Microsoft Excel...
+
Lesson Plan
Curated OER

Electronic Hydrology Lesson Plan - Revised

For Teachers 8th - 12th
Students use Excel spreadsheets. They predict time and height of peak flow on river
+
Lesson Plan
Curated OER

Scale Basketball

For Teachers 7th - 8th
Students discuss scale diagrams and maps as well as the use of spreadsheets to find the best scale to use in a model before practicing scale and ratio problems on their own.
+
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. For this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
+
Lesson Plan
Curated OER

What Color Are Your Skittles?

For Teachers 7th - 10th
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.
+
Lesson Plan
Curated OER

Pollution Assessment: Is Wood Lake a Good Lake?

For Teachers 7th - 8th
Young scholars become aware of pollution in Richfield Minnesota's Wood Lake, identify sources of pollution in Wood Lake, learn to use variables, equations, spreadsheets and modeling software, and generate solutions for the problem.
+
Lesson Plan
Curated OER

Baseball Statistics

For Teachers 7th - 8th
Students read "Casey at the Bat" and then use individual player statistics (found through internet research)to determine if their players could be considered baseball "heroes". They must justify their choices for "hero" by creating...
+
Lesson Plan
Curated OER

Graphs and Spreadsheets

For Teachers K - 12th
Students collect data and present it in a graph and/or a spreadsheet, depending on their previous understanding of technology.
+
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Students create arrays using Microsoft Excel. In this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
+
Lesson Plan
Curated OER

Using Computer for Statistical Analysis

For Teachers 6th - 12th
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
+
Lesson Plan
Curated OER

A Self Directed Inquiry into the Identification of Unknowns

For Teachers 9th - 12th
High schoolers gain experience in designing an experiment and use logic in selecting specific tests for unknowns. Students recognize the use of spreadsheets in helping one to make clear comparisons.
+
Lesson Plan
Curated OER

Listen to Your Heart

For Teachers 6th
Sixth graders explore how exercise affects heart rate and use spreadsheets to record and analyze data.
+
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

Mmm, Mmm, M&M's

For Teachers 3rd - 5th
Here is another version of the classic M&M math lesson. In this one, upper graders utilize the ClarisWorks Spreadsheet program in order to document the data they come up with from their bags of M&M's. After making their initial...

Other popular searches