Lesson Plan
Curated OER

Ornithology and Real World Science

For Teachers 5th - 6th
Double click that mouse because you just found an amazing lesson plan! This cross-curricular Ornithology lesson plan incorporates literature, writing, reading informational text, data collection, scientific inquiry, Internet research,...
Lesson Plan
Curated OER

Student News And Weather Channel

For Teachers 5th
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Lesson Plan
Curated OER

Surname Survey

For Teachers 3rd - 12th
Students use data from the U.S. Census Bureau to determine whether last names in a local phone directory reflect the Census Bureau's list of the most common surnames in the country. In this surnames lesson plan, students use the Internet...
Lesson Plan
Curated OER

Graphing Our Marbles

For Teachers K
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Lesson Plan
Curated OER

Are You Full of Hot Air?

For Teachers 2nd - 3rd Standards
Explore the concept of measuring and recording circumference. In this physical science and measurement lesson, young learners blow up balloons, measure the circumference, and record the data on an interactive graphing website.
Lesson Plan
Code.org

Good and Bad Data Visualizations

For Teachers 9th - 12th
Good versus bad data. Pairs rate online collections of data representations from good to bad and then suggest ways to improve the visualizations. The class then creates a list of best practices and common errors in data representations...
Lesson Plan
Curated OER

Rockin' Data

For Teachers 5th
Fifth graders are given the questions, "What type of music would you suggest the manager place in front of the store?". Students collect data by talking with 20 adults and create a bar graph on the computer to present the data.
Lesson Plan
Curated OER

Gummy Bear Math

For Teachers 1st
First graders predict, collect data, and create a graph based on gummy bear colors they are given. In this graphing lesson plan, 1st graders first predict how many colors of gummy bears there are. They then count the colors, graph them,...
Lesson Plan
Curated OER

Get the Picture with Graphs

For Teachers 5th
Fifth graders examine line, bar and circle graphs in the newspaper and on the Internet. They complete sketches of graphs with an emphasis on selecting the best model to depict the data collected.
Activity
2
2
Teach Engineering

Using Hooke's Law to Understand Materials

For Teachers 10th - 12th Standards
Provide a Hooke for a lesson on elasticity with an activity that has groups investigate a set of springs. They use a set procedure to collect data to calculate the spring constant for each spring using Hooke's Law. The groups...
Lesson Plan
Curated OER

Data Lesson Vital Information

For Teachers K - 2nd
Students prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.
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...
Lesson Plan
Curated OER

Graphing and Analyzing Biome Data

For Teachers 4th - 6th
Students explore biome data. In this world geography and weather data analysis lesson, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius degrees and use...
Lesson Plan
Kenan Fellows

Designing and Analyzing Data Collected from Wearable Devices to Solve Problems in Health Care

For Teachers 9th - 12th Standards
Wearable devices have become more the norm than the exception. Learners analyze data from a sample device with a regression analysis in a helpful hands-on lesson. Their focus is to determine if there is a connection between temperature...
Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Lesson Plan
Curated OER

Beginning Graphs in MS Excel

For Teachers 3rd - 5th
Students practice creating graphs in Microsoft Excel. In this technology lesson, students conduct a random survey and collect data. Students use the Microsoft Excel program to create a bar graph of the data.
Activity
1
1
Teach Engineering

Building-Testing-Improving Paper Airplanes: Head's Up!

For Teachers 5th - 7th Standards
Take foldables to all new heights. Pupils build and fly different types of paper airplanes in the 14th portion of a 22-part unit on aviation. Groups collect data on distance and flight time for each plane and compare the data from the...
Activity
1
1
Teach Engineering

Energy on a Roller Coaster

For Teachers 9th - 12th Standards
Roll with your class into the idea of conservation of energy. Pupils use a roller coaster track to collect data to reinforce the concept of conservation of energy and the influence of friction. Class members then create a graph from...
Lesson Plan
Curated OER

Identifying Ozone Variations over Different Locations

For Teachers 7th - 12th
Students analyze ozone data.  In this atmosphere lesson, students will use a NASA resource to gather data for different regions of the Earth.  Students will then create a graph for their data and answer related questions. 
Lesson Plan
Curated OER

Computer Graphing

For Teachers 7th - 8th
Young scholars research the Internet or create surveys to find graphable data. They collect, organize, analyze and interpret the data. Finally, they choose the appropriate type of graph to display the data and find the measures of...
Lesson Plan
Curated OER

Weather

For Teachers 5th - 7th
Students create a spreadsheet and chart using data collected.  In this weather instructional activity, students select five cities from their state, including the city they live in.  Students take daily temperature readings...
Lesson Plan
Curated OER

Creating a Spreadsheet and Graph

For Teachers 4th - 5th
Students create graphs in Excel.  In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the...
Lesson Plan
1
1
Teach Engineering

Android Acceleration

For Teachers 9th - 12th Standards
Prepare to accelerate your Android. Pupils prep for the upcoming activity in this third installment of a four-part series. The lesson progresses nicely by first introducing different types of acceleration to the class. The teacher...
Organizer
Curated OER

Tides at the Battery, NY

For Students 7th - 12th
Skill in using Excel and increasing proficiency in manipulating data are challenged with this data analysis work.  A web link supplies data and step-by-step instructions help learners create a graph.  There are many extension...