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

Mmm, Mmm, M&M's

For Teachers 3rd - 5th
Here is another version of the classic M&M math lesson. For 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

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
Middle schoolers 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...
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
Students 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
Students 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
Pupils 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. Pupils answer statistical questions regarding the data.
Lesson Plan
Curated OER

MAISA and the REMC Association of Michigan

For Teachers 5th - 7th
Students complete online research to study geography's impact on weather. In this geography and weather lesson plan, students research weather in their city for ten days using an online website. Students bookmark the site, enter data...
Lesson Plan
Curated OER

European Elevation Sort

For Teachers 6th
Given a prepared database of European countries, sixth graders sort the countries in ascending order by elevation and identify the five countries with the highest elevations. This cross-curricular lesson combines elements of computer...
Lesson Plan
Curated OER

WebQuest: Thrills and Spills- Pick Your Park!

For Teachers 4th - 6th
Students participate in a WebQuest in which they must determine which amusement park is the "median priced" park. Students visit park websites to accumulate prices for parking, activities, restaurants, and gift shops.
Lesson Plan
Curated OER

Window-Eyes Lesson 11 Numbers and Capitalization Alert In the Screen Menu

For Teachers 6th - 8th
Pupils practice using the Window Eyes setting to work with numbers settings, and upper and lower case letter alerts.
Lesson Plan
Curated OER

First Grade Shoe Sizes

For Teachers 3rd
Third graders collect shoe size data from classmates in their room and another third grade. They predict what the most common shoe size will be. They place the data in an spreadsheet on the computer. They design a graph using the...

Other popular searches