Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
Lesson Plan
Curated OER

Students Favorites

For Teachers 7th - 8th
Students complete activities using a frequency table and construct a pie graph for the data. In this frequency table lesson, students complete a survey to find data for a frequency table. Students use the given link to make a pie graph...
Lesson Plan
Curated OER

Data Collection

For Teachers 3rd - 5th
Students write a journal exercise that relates to pets. They collect information from each other in order to practice making and interpreting bar graphs. They Continue building different kinds of graphs with the group.
Lesson Plan
Curated OER

Class Birthday Graph

For Teachers 2nd - 3rd
Young scholars analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.
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

Fairy Tales

For Teachers 6th
Sixth graders explore the elements of fairy tales. In this fairy tales lesson, 6th graders analyze several versions of Cinderella from around the world. Students graph fairy tale elements using Excel and create Venn diagrams comparing...
Lesson Plan
Curated OER

EXCEL It!

For Teachers 5th - 8th
Young scholars surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
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

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

Get the Picture with Graphs

For Teachers 5th
Fifth graders examine line, bar and circle graphs in the newspaper and on the Internet. They complete sketches of graphs with an emphasis on selecting the best model to depict the data collected.
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 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 groundhog...
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

It's Your Life - Safe or Sorry/Safety Issues

For Teachers 6th - 8th
Middle schoolers examine and chart data about safety hazards and unsafe situations. In this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the...
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, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius degrees and use...
Lesson Plan
National Wildlife Federation

I’ve Got the POWER! Solar Energy Potential at Your School

For Teachers 9th - 12th Standards
Should every school have solar panels? The 19th activity in a series of 21 has scholars research the feasibility of using solar panels at their school. They begin by gathering data on the solar energy in the area before estimating the...
Lesson Plan
Alabama Learning Exchange

What's Your Favorite Chocolate Bar?

For Teachers 5th - 6th Standards
Students complete a math survey. In this math graphs lesson, students complete a survey about their favorite candy bars. Students create different kinds of graphs using Microsoft Excel to show their results.
Lesson Plan
Curated OER

Lemonade Business

For Teachers 12th
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.
Lesson Plan
Curated OER

Student Costs Graph

For Teachers 5th - 7th
Students calculate the mileage, gasoline costs, and travel time and costs for a vacation. They conduct a virtual field trip, and create a comparison graph of costs using Microsoft Excel software.
Lesson Plan
National Wildlife Federation

Get Your Techno On

For Teachers 9th - 12th Standards
Desert regions are hotter for multiple reasons; the lack of vegetation causes the sun's heat to go straight into the surface and the lack of moisture means none of the heat is being transferred into evaporation. This concept, and other...
Lesson Plan
Curated OER

The Numbers Tell the Story

For Teachers 3rd - 9th
Students demonstrate how to gather and interpret statistical data. In this data analysis instructional activity, students search for statistics on the health effects of smoking and place the information into charts. Students create these...
Lesson Plan
Curated OER

Using a Statistical Procedure To Search A Database For Out of the Ordinary Values

For Teachers 7th - 10th
Students develop a spreadsheet containing formulas and find summaries for them.  In this investigative instructional activity students choose a topic, investigate it and use MS Excel to sort data. 
Activity
Teach Engineering

Air Pollution in the Pacific Northwest

For Teachers 6th - 8th Standards
Scholars investigate levels of nitrogen dioxide in the Pacific Northwest by examining the role of nitrogen in air pollution and how remote sensing can be used to measure nitrogen levels. An Excel spreadsheet calculates the difference...
Lesson Plan
Curated OER

Using My Nasa Data To Determine Volcanic Activity

For Teachers 8th - 12th
Students use NASA satellite data of optical depth as a tool to determine volcanic activity on Reunion Island during 2000-2001. They access the data and utilize Excel to create a graph that has optical depth as a function of time for the...
Lesson Plan
Curated OER

Name Count and Graph

For Teachers 6th - 8th
Young scholars find the frequency of a name in selected states by using the Internet. They input data into a spread sheet. They create a graph that illustrates the gathered information.