Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Lesson Plan
Curated OER

Data! Data! Graph that Data!

For Teachers 5th
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Lesson Plan
Curated OER

Cold, Clouds, and Snowflakes

For Teachers 4th - 7th
Students explore satellite data and graphing. In this weather data analysis math and science lesson, students analyze NASA satellite data to draw conclusions about geographical areas where precipitation might have happened. Students...
Lesson Plan
Curated OER

kind of Bean

For Teachers 3rd
Third graders sort different types of beans and collect the data. They create a data table, put the information on the data table and then graph their results. They answer follow-up questions.
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.
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation

For Students 9th - 12th
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 5: Histogram

For Students 9th - 12th
A professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...
Lesson Plan
Curated OER

Pollution and Environmental Studies- Daily Water Use

For Teachers 4th - 9th
In this environmental studies worksheet, students create a data table to discover how much water each person uses on a daily basis and what it is used for. They complete a post activity to make and test solutions for pollution using a...
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Lesson Plan
Curated OER

M&M Graphing

For Teachers 4th
Fourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.
Unit Plan
1
1
Florida Department of Health

Safe and Happy: Safety for All at School and Online Unit

For Teachers 9th - 12th
Bystander or upstander and advocate? Three lessons have high schoolers investigating data about bullying and school safety. Participants then learn how to take a stand against bullying and use what they have learned to create a PSA to...
Lesson Plan
Curated OER

Graphing Family Reading Habits

For Teachers 2nd
Second graders collect data from their families about their reading habits and graph them. In this graphing family reading habits lesson, 2nd graders interview family members about their reading habits. They then use a graphing computer...
Activity
Curated OER

A Research Project and Article For the Natural Inquirer

For Teachers 4th - 10th
Get your class to use the scientific process to solve a scientific problem. They utilize the Natural Inquirer magazine to identify a research question which they write an introduction to and collect data to answer. They use graphs,...
eBook
Open Oregon Educational Resources

Beginning Excel

For Students 9th - Higher Ed Standards
How can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Students gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Lesson Plan
Curated OER

Moon Craters Lab

For Teachers 4th - 6th
Learners explore characteristics of mass. In this scientific inquiry about mass lesson, students drop rocks of different weights from various heights and record the depth of the "crater" created.  Learners record their findings on a...
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

Wordle It

For Teachers 4th - 6th
Students discuss, define, and give themselves character traits. In this character traits lesson, students create a list of ten character traits that describe themselves. Students create a data table and poll their classmates about the...
Lesson Plan
Curated OER

Banquet Menu Assessment: Exposure Investigation Exercise

For Teachers 9th - 12th
Students identify sources of Food Borne illness and their prevention. They formulate hypotheses based on collected information. Pupils become aware of Nutrintional value of food. Students collected data are synthesized to formulate...
Lesson Plan
Curated OER

Internet Shopping Business Idea

For Teachers 9th - 12th
Students create their own Internet business based on data they find concerning trends in Internet shopping. They discuss advantages and disadvantages to selling specific products and/or services over the Internet.
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

Creating a Nutrition Table in MicroSoftExcel

For Teachers 6th - 8th
Students 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

Statistics Newscast in Math Class

For Teachers 7th - 9th
Students study sports teams, gather data about the teams, and create a newscast about their data. In this sports analysis lesson, students research two teams and define their statistical data. Students compare the two teams, make...
Lesson Plan
Curated OER

Using Computers to Produce Spreadsheets and Bar Graphs

For Teachers 4th - 12th
Students review graphing terminology and how to plot data points, how to input data into a spreadsheet, and how to make a chart using a computer.