Lesson Plan
Curated OER

Student Costs Data Table

For Teachers 5th - 7th
Students compare and contrast two routes selected for a virtual field trip. They create a data table of educational activities, lodging, and meal costs using Microsoft Excel software.
Lesson Plan
Curated OER

Graphing Iron Data

For Teachers 8th - 10th
Students apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Lesson Plan
Curated OER

Making Logic Out of Madness

For Teachers 10th
Tenth graders organize and interpret data from a student health program.  In this physical education activity, 10th graders use a body composition analyzer over 8 weeks to determine the validity of a student health...
Worksheet
Curated OER

Generate Measurement Data Word Problems

For Students 2nd - 3rd
Bar and line graphs are an excellent way to visually analyze data: give your scholars practice both analyzing graphs and creating their own! First, they examine five basic bar graphs, indicating the number of squares on specific days....
Lesson Plan
Curated OER

All Choked Up By Smoking Statistics

For Teachers 9th - 12th
Scholars use the article "More College Students Are Smoking, Study Says" as a springboard for discussion on the reasons why people smoke cigarettes. They investigate different methods of graphing statistics by using the data provided in...
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

Using Spreadsheets and Graphs

For Teachers 3rd
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

For Teachers 4th
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Lesson Plan
Curated OER

Creating Circle Graphs with Microsoft Excel

For Teachers 7th
Seventh graders will learn how to construct circle graphs using paper and pencil. Then they will learn how to construct circle graphs using Microsoft Excel. This lesson uses technology and shows learners how to cross skills into the...
Lesson Plan
Curated OER

Graphing on the Computer

For Teachers 6th - 8th
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this...
Lesson Plan
Curated OER

Graphing Pendulum Results

For Teachers 6th
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...
Lesson Plan
Curated OER

Graph It

For Teachers 5th - 8th
Elementary and middle schoolers engage in a lesson of graphing in quadrant I of the coordinate plain. They use the graph to create shapes and symbols. While using a graphing calculator, they locate the points on the coordinate plane. In...
Lesson Plan
Curated OER

Excel Lesson Plan Coin Statistics

For Teachers 2nd
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Handout
Jacaranda

First Australians

For Students 4th - 7th Standards
Here you'll find an extensive textbook chapter on Australia's indigenous people and the impact of European settlers on aboriginal tribes. The text includes several images, graphs, primary and secondary sources, follow-up...
Lesson Plan
Curated OER

Scatter-Brained

For Teachers 7th
Seventh graders graph ordered pairs on a coordinate plane. They create a scatterplot. Additionally, they determine the line of best fit and investigate the slope of the line. Multiple resources are provided. An excellent resource!
PPT
Curated OER

Year 5 - Term 2

For Teachers 4th - 6th
This incredibly thorough and challenging presentation should engage all of your young math whizzes. Each of the 94 slides has tips, problems, puzzles, and brain teasers that will test the math abilities of even your top learners. An...
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

Graphing Your Favorite Pizza Topping

For Teachers 5th
Fifth graders can survey the students just in their classroom, the grade level, or other grade levels. Upon finishing the surveys and compiling the data, the students can input their results in an Excel template or create their own...
Lesson Plan
Curated OER

Graphing and Analyzing Biome Data

For Teachers 4th - 6th
Students explore biome data. In this world geography and weather data analysis lesson plan, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius degrees...
Lesson Plan
Curated OER

Graphing With Paper and Computers

For Teachers 4th
Fourth graders construct bar graphs. In this graphing lesson, 4th graders create bar graphs in connection with the story, The Copycat Fish. After creating the initial graphs on paper, students use MS Excel to create graphs.
Lesson Plan
Curated OER

Data Analysis Challenge

For Teachers 5th - 6th
In this data analysis worksheet, young scholars work with a partner to collect information for a survey. The information is then compiled into a graph. Learners must indicate their survey question, the target audience, predict the...
Lesson Plan
Curated OER

Wind Effects- A Case Study

For Teachers 5th - 7th
Students explore hurricanes.  For this weather data interpretation lesson, students draw conclusions about the impact of Hurricane Floyd as it related to weather conditions. Students read and interpret a tide data table, a...
Lesson Plan
Curated OER

What's Your Shoe Size? Linear Regression with MS Excel

For Teachers 8th - 12th
Learners collect and analyze data. In this statistics instructional activity, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
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....

Other popular searches