National Wildlife Federation
I’ve Got the POWER! Solar Energy Potential at Your School
Should every school have solar panels? The 19th lesson 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...
Curated OER
Excel Turns Data Into Information
Students use excel to analyze data. In this technology lesson, students enter data into the excel program to find averages and organize data.
Curated OER
Students Favorites
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...
Curated OER
kind of Bean
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.
Curated OER
Graphing Our Marbles
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Curated OER
Graph Frenzy!!
Young scholars brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.
Curated OER
Water Chestnut Graphing Activity
Students are taught how to format and enter data into an Excel spreadsheet. They make a graph and interpret graphed data. Students discuss possible impacts of water chestnut invasion. They graph data on water chestnut. Students report...
Curated OER
What's Your Shoe Size? Linear Regression with MS Excel
Learners collect and analyze data. In this statistics lesson, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Curated OER
Creating Circle Graphs with Microsoft Excel
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
Curated OER
Graphing Surveys and Analyzing Data
Students analyze data and graph the results of their surveys. In this statistics lesson, students create graphs using excel to make graphs to be able to better observe their data. They conclude how great we as unique individuals.
Curated OER
The Viewing Tube
Looking for an excellent lesson that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet. This is a very...
Curated OER
A Picture is Worth a Thousand Words
Pupils create various types of graphs. They go to suggested websites to collect data and create graphs to organize the data. Then they answer questions according to their graph.
Curated OER
Starting With Stats
Statisticians analyze a data set of student IQs by finding measures of central tendency and dispersion such as mean, median, mode, and quartiles. They practice using a graphing calculator to find the values and analyze box plots and...
Curated OER
Does cloud type affect rainfall?
Student use MY NASA DATA to obtain precipitation and cloud type data. They create graphs of data within MY NASA DATA. Students compare different cloud types, compare precipitation, and cloud type data They qualitatively describe graphs...
Utah Education Network (UEN)
The Human Line Plot
Learners collect data and use charts and line plots to graph the data. Some excellent worksheets and activities are embedded in this fine lesson plan on line plots.
Curated OER
Graphing With Paper and Computers
Fourth graders construct bar graphs. For 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.
Curated OER
Using Averages to Create Graphs Through Excel
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...
Curated OER
What's Up With My Class
Middle schoolers collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display...
Curated OER
Farm Stories, Animal Webbing, Favorite Farm Animal Graph
Students brainstorm animals they would expect to see on a farm. They save these on a Kidspiration web. Students watch or read a farm story. They discuss the characters. Students vote for their favorite farm animal and crate a graph using...
Curated OER
Excel for Beginners
In this Excel lesson plan, young scholars set a formula to check their homework. Students also use clipart, work in groups, and learn to use the tools in the drop-down list.
Curated OER
Apple Graph
Students sample three types of apples. They choose their favorite apple. They create a graph, charting the favorite apples of their classmates. They answer a series of questions.
Illustrative Mathematics
Identifying Quadratic Functions
Put your high schoolers to the test and see how well they know their quadratic functions. With excellent thought-provoking questions, learners use what they know about creating quadratic equations based off different pieces of...
PBL Pathways
Students and Teachers 2
Examine trends in student-to-teacher ratios over time. Building from the first task in the two-part series, classes now explore the pattern of student-to-teacher ratios using a non-linear function. After trying to connect the pattern to...
Curated OER
Relations and Graphs
Here is a simple, yet clever lesson on how to teach the important concepts of greater than, less than, and equal to. Pupils write their names down on grid paper - one letter per box. They compare their names and find a name that is...