Lesson Plan
Curated OER

The Statistics of Shoes

For Teachers 7th - 10th
Students open a blank spreadsheet and format it for a class survey about the number of shoes owned by the men and women in the class. They enter the data before finding the mean, median, mode, quartiles, variance, and the standard...
Lesson Plan
Curated OER

How Long...?

For Teachers 3rd - 5th
Students explore measurement. They use appropriate units of measurement for different sized objects. Students collect their data and enter it into an Excel data base. They graph their findings and analyze their outcomes.
Lesson Plan
Curated OER

All About Me: Measuring Height and Weight

For Teachers 2nd - 4th
Students take personal fitness inventories. In this personal health activity, students take measurements of their heights and weights. Students record the data, calculate their BMI, and then chart their physical activity.
Lesson Plan
Curated OER

Shared Birthdays

For Teachers 6th - 8th
Students gather information on their classmates birthdays and create a spreadsheet with the dates. Using the internet, they find a famous person who shares their own birthday. They research the life of the famous person and develop a...
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

The Election Connection

For Teachers 3rd - 5th
Students participate in a mock election. In this election lesson, students vote online in a mock election, graph the results, and compare their results to the nationwide results.
Lesson Plan
Curated OER

Composting

For Teachers 8th
Eighth graders collect data from Bottle Biology compost columns and record using Excel spreadsheet.
Lesson Plan
Curated OER

Density Lab

For Teachers 9th - 12th
High schoolers use an Excel spreadsheet to calculate the density various liquids. They take pictures of their results.
Lesson Plan
Curated OER

Survival of the Fittest – Battling Beetles

For Teachers 9th - 12th
Students explore natural selection. For this genetic adaptation lesson, students discover why certain traits continue and some traits disappear. Students discover how species evolve and change. Resources are provided.
Lesson Plan
Curated OER

The Hundred Penny Box

For Teachers 6th
Sixth graders research payload specialists and see how many are men and how many are women and what countries they come from. They then create an excel spreadsheet to reflect data they found and must have two graphs for interpretation.
Lesson Plan
Curated OER

Geographic Effects on Precipitation, Water Vapor and Temperature

For Teachers 9th - 12th
Students investigate the factors affecting climate using Live Access Server. In this geography lesson, students graph atmospheric data using Excel spreadsheet. They compare and contrast temperature, precipitation and water vapor of two...
Lesson Plan
Curated OER

How Many M&M's

For Teachers 4th - 6th
Young scholars explore sets and collections. Students find the colors of M&M's and the amount of M&M's each student has. They organize this information into an Excel spreadsheet. Young scholars use the chart wizard to create a...
Lesson Plan
Curated OER

The Breathtaking Nature of the Urban Explosion, Part 2

For Teachers 9th - 12th
Young scholars explore ozone levels. They measure the concentrations of ground-level ozone in the atmosphere. Students observe changes in the concentrations of ozone over time. Young scholars complete a data sheet to record ozone...
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

Super Spreadsheets

For Teachers 6th - 8th
Students 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

Metric Conversion

For Teachers 5th
Fifth graders access prior knowledge to complete a do now using metric conversion. In this metric conversion activity, 5th graders will respond to problems and analyze for a possible mnemonic device.
Lesson Plan
Curated OER

Stock Market Investment

For Teachers 6th - 8th
Students create a $100,000 stock portfolio by selecting stocks from a list of one hundred companies. They complete sell/buy orders, track their portfolio values through Yahoo Finance over an eight-week period, conduct Internet research...
Lesson Plan
Curated OER

The Lessons of Emmett Till

For Teachers 10th - 12th
Students participate in a WebQuest designed to take them on a journey into the darkness that is race predjudice and the often-violent means in which it is manifested. They investigate the murder of a 14-year-old Chicago boy visiting...
Lesson Plan
Curated OER

Social Studies, Civics Lesson

For Teachers 9th - 12th
Pupils examine the development of government. They identify different theories of political thought around the world. They participate in a play to discover their own political views on key issues.
Lesson Plan
Curated OER

Potato Chips Fragility

For Teachers 10th - 12th
Students investigate why some potato chips crumple faster than others. In this physics lessons, students relate the cooking time to potato's fragility. They write a lab report about their findings.
Activity
Howard Hughes Medical Institute

Human Impacts on Biodiversity

For Teachers 6th - 12th Standards
Have you always wanted to take your science class on an amazing field trip they will never forget? Now you can! Observe the wildlife in an African savanna through trail cameras with a five-part data analysis activity. Learners analyze...
Lesson Plan
Curated OER

Your Just Desserts

For Teachers 6th - 8th
Students write letters to town officials and local businesses asking for favorite dessert recipes. They tabulate their responses in a spreadsheet. Students turn their survey results into colorful graphs.
Lesson Plan
Curated OER

Technology - Data Collection

For Teachers 8th - 10th
Students collect and analyze data from the United States Census Bureau. Using spreadsheet technology, students explore their results and make preductions about income groups. Students compute the mean, median and mode. They create...
Lesson Plan
Curated OER

Rouge River Data

For Teachers 3rd - 5th
Learners participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.