Unit Plan
Radford University

How Is Your Gender Represented?

For Teachers 9th - 12th Standards
Does the media shape people's views on gender? Scholars use data on gender portrayal in magazines to explore the idea. They use a spreadsheet program to create bar graphs and perform a chi-square test. They also use provided data to...
Unit Plan
Radford University

Real World Data

For Teachers 9th - 12th Standards
Make math class feel more real by using real-world data. Scholars research or collect data on several different topics, such as nutrition, the motion of moving objects, cooling curves, and daylight hours. They create scatter plots using...
Unit Plan
Radford University

Being Green – Minimizing the Surface Area of a Soda Can

For Teachers 9th - 12th Standards
Save the world by designing a new soda can! Learners first measure the dimensions of a typical soda can and calculate its surface area and volume. They then use spreadsheet software to minimize the surface area for the volume, thus...
Lesson Plan
Curated OER

Discovering Pi

For Teachers 6th
Sixth graders measure circumference and diameter to the nearest eighth of an inch, record measurements on a spreadsheet, and use the internet to complete a "scavenger hunt" of facts concerning pi.
Lesson Plan
Curated OER

Graphing Pendulum Results

For Teachers 6th
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...
Lesson Plan
Curated OER

Excel Lesson

For Teachers 5th
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
Lesson Plan
Curated OER

Buying a Car

For Teachers 8th
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
Lesson Plan
Curated OER

Sweet Data

For Teachers 3rd - 12th
Students input data about the colors of their serving of M&M candies onto a spreadsheet. They create charts and graphs based on this information.
Lesson Plan
Curated OER

Integers in the Weather

For Teachers 6th - 7th
Middle schoolers engage in a clever lesson that combines meteorology with mathematical thinking. They use integers in relation to high and low temperatures that they record. They use a spreadsheet of weather data, a computer, and gain...
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.

Other popular searches