Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
Lesson Plan
Curated OER

Math Hunt

For Teachers 8th - 10th
Go on a scavenger hunt around your school to find evidence of math. Investigate different areas of your school for patterns, fractions, and different geometric shapes. Finally, create a spreadsheet and plot the data you've collected.
Lesson Plan
Howard Hughes Medical Institute

Lesson 8: WildCam Gorongosa Data Analysis

For Teachers 9th - 12th
How do scientists analyze data to get a specific answer to a question? The final chapter in an eight-part series of activities centered around Gorongosa National Park encourages scholars to dig deeper into the scientific process. After...
Lesson Plan
Curated OER

Build Your Dream Bedroom

For Teachers 7th Standards
Designers measure their own rooms and produce a scale drawing. They use the Internet to visit sites to find the costs of purchasing new carpet, paint, or anything else they would like to add to their room. Using a $1500 budget, they will...
Lesson Plan
Curated OER

A Line Graph of the Ocean Floor

For Teachers 4th - 5th
Students develop a spreadsheet and import the information into a line graph. In this spreadsheet and line graph lesson, students develop a spreadsheet of ocean depths. They import the information into a word processed document. They...
Lesson Plan
Curated OER

Spreadsheet Function Machine

For Teachers 7th - 8th
Students create a spreadsheet to analyze functions. In this algebra activity, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Lesson Plan
Alabama Learning Exchange

Find a Pattern Using Children's Literature

For Teachers 6th
Sixth graders listen to Demi's, On Grain of Rice: A Mathematical Folktale. They use the problem solving strategy of finding a pattern to determine the number of rice Rani will receive after 30 days. They create a spreadsheet which...
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
Virginia Department of Education

The Rate of Motion

For Teachers 9th - 12th
How much time does it take to jump over three balloons? Pupils calculate the speed of tasks that require different motions. They determine motions for tasks such as walking, skipping, hopping, and jumping before creating a...
Lesson Plan
Curated OER

Graphing Favorite Fruit

For Teachers 3rd
Third graders take poll and sort data, enter the data to create a spreadsheet and create bar and pie graphs.
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
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

Writing Fables

For Teachers 7th - Higher Ed
Young scholars write their own fables. In this writing fables lesson, students use handheld computers to write a fable. The class designs a spreadsheet to organize common elements of fables. Young scholars also edit each others' work.
Lesson Plan
Curated OER

It's Your Life - Safe or Sorry/Safety Issues

For Teachers 6th - 8th
Students examine and chart data about safety hazards and unsafe situations. In this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data and...
Lesson Plan
Code.org

Cleaning Data

For Teachers 9th - 12th
"Clean the data!" "I did not know it was dirty." Introduce your class to the process of cleaning data so that it can analyze it. Groups work through a guide that demonstrates the common ways to filter and sort data. Pairs then...
Lesson Plan
Curated OER

PowerPoint Project for Creating a New Business

For Teachers 9th - 12th
Students create a mock new business for which they design a PowerPoint presentation. They include company information, financial statements, graphs, advertising and management promotion pages in the final presentation.
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

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

Which Amusement Park Would You Choose?

For Teachers 5th - 10th
Young scholars analyze data related to amusement parks and create a spreadsheet to display the data. They read the data and predict which amusement park they think is safer, create a spreadsheet and graph, and write a proposal based on...
Lesson Plan
Statistics Education Web

Are Female Hurricanes Deadlier than Male Hurricanes?

For Teachers 9th - 12th Standards
The battle of the sexes? Scholars first examine data on hurricane-related deaths and create graphical displays. They then use the data and displays to consider whether hurricanes with female names result in more deaths than hurricanes...
Lesson Plan
Curated OER

A Birthday Basket for Tia

For Teachers Pre-K
Students practice reading and math skills using technology.  In this main idea lesson, students retell the important events of A Birthday for Tia in sequence using Kid Pix.  Students create a bar graph using The Graph Club...
Lesson Plan
Curated OER

Creating a Newscast on the Cold War

For Teachers 5th - 7th
Students research the events of a specific year of the Cold War. In this Cold War lesson plan, students investigate the causes of the Cold War and highlight the events of a particular year.  Students create a...
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...