Lesson Plan
Curated OER

A Thanksgiving Survey

For Teachers 4th - 8th
Learners take a survey then use the information gained from the survey to help plan a typical Thanksgiving dinner for our last day of class. They create a graph which corresponds the the data gathered during interviews.
Lesson Plan
Curated OER

Survey Says...

For Teachers 3rd - 7th
Students practice taking surveys to answer different questions about radio.  For this communications lesson, students brainstorm to create questions they can ask strangers about how often they listen to their radio.  Students...
Lesson Plan
Curated OER

Gathering, Evaluating, And Organizing Information for a Report

For Teachers 6th - 9th
Students gather and organize information for a research report on a topic of their choosing. Each students selects a subject for their research. Using traditional and electronic data they reference four or more appropriate resources...
Lesson Plan
Curated OER

PLANNING A DIVERSIFIED INVESTMENT PORTFOLIO

For Teachers 12th
Twelfth graders research stocks and how to read and interpret financial data. They choose 5 companies to invest in and track their performance over 10 weeks. They create a spreadsheet which shows the results.
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

Using Electronic Manipulatives in Multiplication

For Teachers 9th - 11th
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Lesson Plan
Curated OER

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
Lesson Plan
Curated OER

Let's Get Organized

For Teachers 6th
Sixth graders identify table and each of its parts, including cell, column, row, header, and formula bar. Students then explain how tables are used to store and organize information in database, organize and categorize information...
Lesson Plan
Curated OER

An "Average" Golf Score

For Teachers 9th
Ninth graders investigate mean, median, and mode.  In this mean, median, and mode lesson, 9th graders research gold data for the top ten scores in two golf tournaments.  Students make tables and graphs of the data. ...
Lesson Plan
Curated OER

Comparing Costs

For Teachers 8th - 12th
Students compare the costs of two cellular phone plans and determine the best rate. They use a table and a graph of points plotted on a Cartesian plane to display their findings. Students write an equation containing variables that could...
Lesson Plan
Curated OER

A “Scientific” Approach to Buying a Car

For Teachers 9th - 12th
High schoolers examine what it takes to purchase a car and the resources out there to help find what you are looking for.  In this scientific method lesson students complete different problem solving situations.
Lesson Plan
Curated OER

Creating Personalized Stationery

For Teachers 10th - 12th
Students write, format, enter, save, revise, edit a full block style letter with open punctuation for printing. They produce a personalized letterhead using a computer and access information from the Internet using a variety of search...
Lesson Plan
Curated OER

Altering a Plant Environment

For Teachers 4th - 8th
Young scholars investigate what a controlled group is by creating an experiment.  In this plant growth lesson, students identify the different parts of a plant and discuss what is needed for a plant to be successfully grown....
Lesson Plan
1
1
University of Colorado

Planetary Distances on the Playground

For Students 6th - 8th Standards
Earth is 149,600,000 km, or 92,957,130.4 miles, from the sun. Young astronauts create an interactive model to learn the distances between planets. Nine groups, each representing a different planet, are spread around at class-calculated...
Lesson Plan
Curated OER

Heartbeat Project

For Teachers 9th - 12th
Pupils 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

Survey Says...

For Teachers 3rd - 5th
Young learners create and implement a school-wide survey about student body favorites! Learners record and analyze the data on a bar graph, picture graph, and line graph, and then display the data. Then, wrap it all up with a celebration...
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

Curious Clouds

For Teachers 2nd
Second graders explore clouds. They read The Cloud Book by Tomie dePola. Students sort the cloud pictures into three categories. Students create a graph using the cloud pictures. They use Excel to create a bar graph.
Lesson Plan
Curated OER

Investigation-How Many Toothpicks?

For Teachers 7th
Seventh graders use toothpicks to investigate a series of designs and identify patterns. Data is organized and analyzed using tables and graphs, and students make generalizations using algebraic expressions.
Lesson Plan
Curated OER

Where Are the Bugs?

For Teachers 6th - 7th
Students trap, collect and identify arthropods in a newly created desert tortoise preserve area over a period of one school year. They determine the rate at which various arthropods take up residence in the newly landscaped area. Data is...
Lesson Plan
Curated OER

Introduction to Graphs

For Teachers 2nd - 3rd
Students poll classmates to gather information for a graph. They identify three types of graphs (bar, line, table). Students create each type of graph using data gathered from classmates.
Lesson Plan
Curated OER

Old Glory

For Teachers 6th - 8th
Learners utilize mathematical concepts such as: measurement, ratio and proportion and geometric probability to analyze the components of the U.S. Flag. They collect, organize and interpret data by constructing charts, tables and graphs...
Lesson Plan
Curated OER

Favorite Apple Graph

For Teachers 1st
First graders record their favorite type of apple in the form of a graph. They each try one slice of a Red Delicious, Golden Delicious, and Granny Smith apple, select their favorite type, and create a class graph using the data collected.
Lesson Plan
Curated OER

Technical Literacy

For Teachers 9th - 12th
Students explore the components of the transference of technological information through this ten lesson plan unit. The applications to specific careers, the determination of responsible use of technology, and the affects of technology...