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 instructional activity; 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...
Lesson Plan
Curated OER

Data! Data! Graph that Data!

For Teachers 5th
Fifth graders create data graphs using Microsoft Excel. For this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
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
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...
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...
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

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

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.
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

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.
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

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...
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

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

Holiday Cards

For Teachers 8th - 12th
Learners review basic computer skills needed to create a holiday card along with a database of at least twenty five contacts. They create their family greeting card including graphics, correct spelling an grammar. Using their database...
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

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

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

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

Organizing our Favorite Books

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

Excel

For Teachers 9th - 11th
In this technology worksheet, students are taught how to create documents using Excel. They follow the directions on a handout to help them create documents. They print their final work and submit it.
Lesson Plan
Curated OER

What's Up With the Water Cycle?

For Teachers 4th - 5th
Students explore the water cycle.  Students identify the stages in a water cycle and create a PowerPoint presentation based on their knowledge.
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their graph.