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

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.
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,...
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
Young scholars explore satellite data and graphing. In this weather data analysis math and science instructional activity, students analyze NASA satellite data to draw conclusions about geographical areas where precipitation might have...
Lesson Plan
Curated OER

Pollution and Environmental Studies- Daily Water Use

For Teachers 4th - 9th
In this environmental studies worksheet, young scholars 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...
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 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

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.
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,...
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Learners 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.
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

Moon Craters Lab

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

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

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...
Assessment
Georgia Department of Education

Analytic Geometry Study Guide

For Students 9th - 12th Standards
Are you looking for a comprehensive review that addresses the Common Core standards for geometry? This is it! Instruction and practice problems built specifically for standards are included. The material includes geometry topics from...
Lesson Plan
Curated OER

Making and Using a Graphic Organizer for Solving a Mystery

For Teachers 3rd - 5th
Students create tables in a word processing program which helps them organize their text clues when reading a mystery story. They develop reading comprehension strategies while using a computer based graphic organizer in order to solve...
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Young scholars 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...
Lesson Plan
Curated OER

Using a Spreadsheet

For Teachers 8th - 10th
Learners create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
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

Organizing our Favorite Books

For Teachers K - 3rd
Learners identify the title and author of stories. They create a database that supplies both graphic and written information to identify a book.