Lesson Plan
Discovery Education

Sonar & Echolocation

For Teachers 9th - 12th Standards
A well-designed, comprehensive, and attractive slide show supports direct instruction on how sonar and echolocation work. Contained within the slides are links to interactive websites and instructions for using apps on a mobile device to...
Lesson Plan
Curated OER

Fish and Clips

For Teachers 1st - 2nd
Youngsters test magnetic strength by measuring the mass of paper clips that they "hook" with a magnet. Your first and second graders should love the hands-on activities associated with this plan. The reproducible materials are quite good...
Lesson Plan
Curated OER

Pet Count Excel Graphing

For Teachers 3rd - 5th
Students used collected data to distinguish what pets they have or would like to have. They correlate findings with appropriate technology--Excel. At the end of the lesson they tabulate a bar chart and present their findings to the class.
Lesson Plan
Curated OER

Student Costs Graph

For Teachers 5th - 7th
Young scholars calculate the mileage, gasoline costs, and travel time and costs for a vacation. They conduct a virtual field trip, and create a comparison graph of costs using Microsoft Excel software.
Lesson Plan
Curated OER

Tracking Your Favorite Web Sites

For Teachers 9th
Ninth graders track the hit count on their favorite web sites.  In this Algebra I activity, 9th graders record the number of hits on their favorite web site for twenty days.  Students explore the data to determine if the...
Lesson Plan
Curated OER

Graphically Speaking

For Teachers 4th - 6th
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
Lesson Plan
Curated OER

Alzheimer's Disease

For Teachers 9th - 12th
Investigate Alzheimer's disease. Conduct research using a variety of resources, obtain information, and input the data into a Microsoft Excel spreadsheet. Identify trends in the data and categorize them for an audience.
Lesson Plan
Curated OER

Blast the Fats

For Teachers 3rd - 4th
Young scholars examine the fats found in foods. In this nutrition activity, students identify the types and amounts of fats found in foods as they research food labels and the Internet. Young scholars classify the fats and record their...
Lesson Plan
Curated OER

You mean college costs that much?

For Teachers 7th
Seventh graders collect, organize, and analyze data as they research colleges on the Internet. They graph their collected data on a line graph and use a spreadsheet on Microsoft Excel in order to organize the data.
Lesson Plan
Curated OER

Graphing and Analysis of Water Quality Reports

For Teachers 9th - 11th
Students practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.
Lesson Plan
Curated OER

Virtual Field Trip

For Teachers 4th - 6th
Students calculate gasoline cost per mile on a virtual field trip. They calculate the gasoline costs and travel time for each of the 2 routes, and record on a data sheet. They use Excel to create data tables for mileage, gasoline...
Lesson Plan
Curated OER

The Nifty Fifty-What's Your Size?

For Teachers 3rd - 5th
Students explore state populations. In this state geography activity, students use a variety of technology tools to research and graph population and area of assigned states.
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction instructional activity, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Lesson Plan
Curated OER

Are You My Little Peanut?

For Teachers 4th
Fourth graders explore the mass and length of peanuts by pretending to parent a peanut. In this mode, median and range lesson plan students graph their measurements and then use them to find the mode, median and range. Students discuss...
Lesson Plan
Cornell University

Sound Off!

For Students 10th - 12th
Time to witness the effects of sound. Learners analyze different materials to determine their abilities to absorb sound waves. They use free software to monitor the amplitude of the waves to verify results.
Lesson Plan
Curated OER

Polar Bears in Peril - Climate Change Culprit?

For Teachers 9th - 12th
High schoolers explore the changes in sea ice over several years. In this life science lesson, students review and examine 20 years of data. They use Excel to graph data and analyze trends.
Activity
2
2
Teach Engineering

Preconditioning Balloons: Viscoelastic Biomedical Experiments

For Teachers 10th - 12th Standards
What does stretching a balloon have to do with equilibrium? Groups explore preconditioning by stretching a balloon to a point of equilibrium. They then measure the amount of force required to stretch the balloon to the same point several...
Lesson Plan
Kenan Fellows

Let's Move

For Teachers 6th - 12th Standards
Find a statistical reason for a fresh start. Using a hypothetical scenario, individuals research statistical data of three different cities. Their goal? Find the best statistical reason for a business to move to a new location. Their...
Lesson Plan
Curated OER

Graphing in Science

For Teachers 8th - 12th
Students manipulate and interpret data. They are given a dataset from a described experiment and interpret the data. A "How to Sheet for graphing" is included in lesson plan.
Lesson Plan
Curated OER

Integrating Math and Sports Project

For Teachers 5th - 6th
Students work in pairs to choose a set data from one of the sports websites for their chosen sports. They find the mean, median, mode, and range of their data set. Students create a graph on Microsoft Excel and write several...
Lesson Plan
Curated OER

Just Graph It!

For Teachers 4th
Fourth graders evaluate various graphs for the best way to reflect statistical data. They use a spreadsheet to organize data and generate varied graphic representations. They select the graph they feel best shows their results.
Lesson Plan
Curated OER

Graphing Galore!

For Teachers K
Students practice sorting and counting different objects. Using this information, they create graphs on a worksheet given to them. They describe and analyze the results and discuss them as a class to end the lesson. They also complete...
Lesson Plan
Curated OER

Pets Galore!

For Teachers 4th
Fourth graders conduct a class survey on the number of pets that the 4th grade owns and they record that data in their math notebooks. They make a bar graph displaying the results using a spreadsheet through Microsoft Excel.
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....