Lesson Plan
Curated OER

Elastic Forces

For Teachers 3rd
Third graders predict and experiment to discover the amount of force exerted by a stretched elastic band. They construct a spreadsheet and make a bar graph showing the results of their experiment.
Lesson Plan
Curated OER

School Yard Waste

For Teachers 4th
Fourth graders examine the types of garbage that they collect on the playground. They collect the information in a spreadsheet and create a graph that displays the number of types of trash found. They design and monitor a playground...
Lesson Plan
Curated OER

Height and Weight

For Teachers 3rd
Third graders explore their height and weight. They measure the heights and weights of their peers. Students record their data using an Excel spreadsheet. They create a graph to compare the data and analyze it for a correlation between...
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

Is the Rainbow Fair?

For Teachers 3rd
Third graders perform statistical calculations. Given a bag of Skittles, 3rd graders sort and collect data regarding the colors included in their bag. Using spreadsheet software, students create a bar graph of the information collected....
Lesson Plan
Curated OER

Heartbeat Project

For Teachers 9th - 12th
Students enter information about their heartbeats into a spreadsheet. They construct data displays and calculate statistics. They describe and justify their conclusions from the data collected.
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...
Lesson Plan
Curated OER

Apple Adjectives

For Teachers 3rd - 5th
Study different apple varieties and use appropriate adjectives to describe them. Learners alphabetize both the apple names and the adjectives before creating spreadsheet, bar, and pie graphs. A mix of language arts, technology, and...
Lesson Plan
Curated OER

Graphing Iron Data

For Teachers 8th - 10th
Students apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Lesson Plan
Curated OER

Comparing Temperatures and Latitudes

For Teachers 8th
Eighth graders collect weather data from a variety of cities at the same latitudes, but on different continents. They organize data using spreadsheet program, generate graphs, and incorporate into a word processing document. Students...
Lesson Plan
Curated OER

Magic Number

For Teachers K
Students create addition sentences. They review number lines and how to jump between numbers to solve equations. They play the "Magic Number" game by using a spreadsheet and guessing numbers. They discuss how they found the magic numbers.
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

What's Up With My Class

For Teachers 6th - 8th
Learners collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display the...
Lesson Plan
Curated OER

And the Winner Is...

For Teachers 6th - 8th
Students read the sports section of the daily newspaper to find daily totals of what countries have won medals and find articles to keep in their journal (notebook) on the different events and athletes. They then create a spreadsheet to...
Lesson Plan
Curated OER

Do You Measure Up?

For Teachers 4th - 5th
Students measure their height and then they will input the information into a spreadsheet. After the data is entered, students will use the material gathered to create a bar graph showing the heights of people in their class.
Lesson Plan
Curated OER

What's Your Shoe Size? Linear Regression with MS Excel

For Teachers 8th - 12th
Learners collect and analyze data. In this statistics instructional activity, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Lesson Plan
Curated OER

Fitness plan: number 3

For Teachers 7th - 12th
Learners monitor their fitness levels for six weeks of their P.E. course through the use of an Excel spreadsheet. They also research the obesity epidemic among youth in the U.S. today, presenting their findings to the class. This lesson...
Lesson Plan
Curated OER

How Much Do You Burn?

For Teachers 6th
Sixth graders discover their weight relative to the other children in their class. They determine how many calories they burn through exercise and compare it with their classmates. Using the internet, they calculate their body mass index...
Lesson Plan
Curated OER

What Does George W. Bush Have in Common With Past U.S. Presidents?

For Teachers 6th
Sixth graders discover what it takes to become President of the United States. Using a database, they complete a scavenger hunt to determine what George W. Bush has in common with past Presidents. They also create a spreadsheet which...
Lesson Plan
Curated OER

Growing a Seed

For Teachers 2nd - 3rd
Seeing how seeds grow into plants is such an enjoyable for students! They plant lima bean seeds and take pictures to record the growth of their plants. Students write in a journal to describe their daily observations of their plants, and...
Lesson Plan
Curated OER

Graphing Your Favorite Pizza Topping

For Teachers 5th
Fifth graders can survey the students just in their classroom, the grade level, or other grade levels. Upon finishing the surveys and compiling the data, the students can input their results in an Excel template or create their own...
Lesson Plan
Curated OER

Turn UP the Volume!

For Teachers 8th
Eighth graders find the surface area and volume of the figures and enter formulas into the spreadsheet to calculate surface area and volume for the given figures. They also find the volume and determine the shape which has the least...
Lesson Plan
Curated OER

Reading & Using a Nutrition Label

For Teachers 8th - 12th
Learners 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

What's Playing Tonight?

For Teachers 5th - 9th
Students collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Students answer statistical questions regarding the data.

Other popular searches