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

Author Study (Chris Van Allsburg)

For Teachers 3rd
Third graders study a list of books written and illustrated by the author. They examine facts about the author's life. They take a survey of Allsburg's books read by the students using the Excel spreadsheet.
Lesson Plan
Curated OER

Better Traffic Flow

For Teachers 11th - 12th
Students calculate the maximum number of cars passing a point in a given amount of time.  In this better traffic flow lesson, students work with an existing  Excel spreadsheet to solve the traffic flow problem.  Students...
Activity
Teach Engineering

Energy Perspectives

For Teachers 8th - 10th Standards
The data says ... the resource is great to use. Using Microsoft Excel, pupils analyze data from the US Department of Energy in the fifth lesson of a 25-part Energy Systems and Solutions unit. Each group looks at a different data set and...
Activity
Howard Hughes Medical Institute

Gorongosa: Scientific Inquiry and Data Analysis

For Teachers 9th - 12th Standards
How does the scientific process begin? Introduce ecology scholars to scientific inquiry through an insightful, data-driven lesson. Partners examine data from an ongoing research study to determine the questions it answers. The resource...
Lesson Plan
Code.org

Making Data Visualizations

For Teachers 9th - 12th
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The...
Lesson Plan
Curated OER

What are they like Today

For Teachers 6th
Sixth graders compare the modern day countries that exist in the areas they study in Ancient History. They use a spreadsheet on the computer to organize data that includes population of the countries, along with other various types of...
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

Variables Affecting Earth's Albedo

For Teachers 6th - 12th
Students study the variables that affect the Earth's albedo.  In this environmental data analysis lesson plan students interpret and graph information and calculate changes. 
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

Made Round To Go Round

For Teachers 2nd - 3rd
In this lesson pupils investigate what it would cost to furnish one room of their choice by shopping on the Internet. Both Australian and American dollars are to be given for each item to demonstrate the difference between two...
Lesson Plan
Curated OER

Egyptian Weather Lesson

For Teachers 6th - 8th
Students chart temperatures in Egypt on spreadsheet to determine how weather conditions affect lifestyles.
Lesson Plan
Curated OER

What Goes Up Must Come Down!!

For Teachers 5th
Fifth graders look at actual sunrise and sunset times for their hometown to determine a pattern in the amount of daylight. They collect their data in Excel and create a chart to help them identify the pattern, then write an explanation...
Lesson Plan
Curated OER

Loan Amortization - Mortgage

For Teachers 9th - 12th
Upper graders explore the connection between interest and principal. They use an amortization schedule to determine the amount of principal paid vs interest on a $100,000 home loan. Fourteen discussion questions and a research-based...
Lesson Plan
Curated OER

USING MICROSOFT, POWERPOINT, WORD, EXCEL AND THE INTERNET TO CREATE A PRESENTATION

For Teachers 6th - 12th
Explore the basic PowerPoint commands and options. They research information (including the WWW) related to an approved topic for presentation development. They create a presentation defined by specific criteria. They document research...
Lesson Plan
PBS

March on Washington: A Time for Change

For Students 6th - 12th Standards
Young historians conclude their study of the events that lead up to and the planning for the March on Washington. After examining videos and primary source documents, they consider the civil rights objectives that still need to be...
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Lesson Plan
Curated OER

Earth Energy Budget Pre Lab

For Teachers 4th - 7th
Students explore energy by conducting an in class experiment. In this climate change lesson, students conduct a water vapor experiment in a soda bottle. Students utilize graphs and charts to analyze the results of the experiment and help...
Lesson Plan
ARKive

Biodiversity and Evolution – Darwin’s Finches

For Teachers 9th - 10th
Teens experience natural selection firsthand (or first beak) in an activity that has them act as finches foraging for food. Using different household items  to act as different beak styles, your little finches will collect as much...
Lesson Plan
Curated OER

Ice Melting Investigation

For Teachers 7th - 9th
Students conduct an ice melting investigation in which they observe and measure the melting of two ice spheres. They develop a hypothesis as to which sphere will melt the fastest, collect data every ten minutes, and graph the data using...
Lesson Plan
Curated OER

Creating a Nutrition Table in MicroSoftExcel

For Teachers 6th - 8th
Middle schoolers access the internet to find Nutritional information from a restaurant of their choice and compile their information into an excel spreadsheet.
Lesson Plan
Curated OER

Does Humidity Affect Cloud Formation?

For Teachers 6th - 8th
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
Lesson Plan
Curated OER

Analyzing Tree Rings to Determine Climate Change

For Teachers 6th - 8th
Students examine how to locate and access data sets.  In this climate change lesson students import data into Excel and graph it.   
Activity
1
1
Teach Engineering

Searching for Bigfoot and Others Like Him

For Teachers 7th - 9th
Individuals create a GIS data layer in Google Earth that displays information about where one might find seven different cryptids. The class members research to find data on cryptid sightings they can include in their data...