Council for Economic Education
GDP Data: Is the Economy Healthy?
Does the economy needs a check-up? Scholars analyze the gross domestic product (GDP) to determine the overall health of the current economy. They use a short video clip as well as economic data to determine the current growth of the...
Curated OER
What's Playing Tonight?
Students collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Students answer statistical questions regarding the data.
Curated OER
Graph Lesson
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Curated OER
How to Graph in Excel
Fourth graders construct data graphs on the Microsoft Excel program. In this statistics lesson, 4th graders formulate questions and collect data. Students represent their results by using Excel.
Curated OER
Graphing and Analyzing Biome Data
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...
Curated OER
Beginning Graphs in MS Excel
Students practice creating graphs in Microsoft Excel. For this technology lesson, students conduct a random survey and collect data. Students use the Microsoft Excel program to create a bar graph of the data.
Curated OER
Counting
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
Curated OER
All in the Family
Students use data to make a tally chart and a line plot. They find the maximum, minimum, range, median, and mode of the data. Following the video portion of the lesson plan, students will visit a Web site to test their data collection...
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
Excel Lesson
Young scholars explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Statistics Education Web
How High Can You Jump?
How high can your pupils jump? Learners design an experiment to answer this question. After collecting the data, they create box plots and scatter plots to analyze the data. To finish the lesson, they use the data to draw conclusions.
Curated OER
Foliage Tracker
Young scholars discuss the change of leaf colors and the role that climate and elevation play in those changes. They then track leaf changes, input data, and graph foliage changes with a free online tool.
Curated OER
Matchstick Math: Using Manipulatives to Model Linear, Quadratic, and Exponential Functions
Playing with matches (unlit, of course) becomes an engaging learning experience in this fun instructional unit. Teach pupils how to apply properties of exponential functions to solve problems. They differentiate between quadratic and...
Statistics Education Web
Walk the Line
How confident are you? Explore the meaning of a confidence interval using class collected data. Learners analyze data and follow the steps to determine a 95 percent confidence interval. They then interpret the meaning of the confidence...
Teach Engineering
Building-Testing-Improving Paper Airplanes: Head's Up!
Take foldables to all new heights. Pupils build and fly different types of paper airplanes in the 14th portion of a 22-part unit on aviation. Groups collect data on distance and flight time for each plane and compare the data from the...
Teach Engineering
Energy on a Roller Coaster
Roll with your class into the idea of conservation of energy. Pupils use a roller coaster track to collect data to reinforce the concept of conservation of energy and the influence of friction. Class members then create a graph from...
NOAA
The Oceanographic Yo-yo
How does chemistry help deep-sea explorers? Part four of a five-part series of lessons from aboard the Okeanos Explorer introduces middle school scientists to technologies used in ocean exploration. Groups work together to analyze data...
Curated OER
Little Auk Survival Challenge
A bird's life is one of danger and intrigue as it struggles for survival in sometimes harsh environments. To understand how difficult surviving in the wild can be, children play a simulation game where they act as little auks, birds from...
Curated OER
Identifying Ozone Variations over Different Locations
Students analyze ozone data. In this atmosphere lesson plan, students will use a NASA resource to gather data for different regions of the Earth. Students will then create a graph for their data and answer related...
Radford University
Got Slope?
Go around and around with slope. The class investigates tornadoes by watching videos, building a homemade tornado, and performing research on the Storm Prediction Center website. Groups gather data and create scatter plots for twisters...
Institute of Electrical and Electronics Engineers
Get Connected with Ohm's Law
Ideal for your electricity unit, especially with middle schoolers, this lesson plan gets engineers using multimeters in electrical circuits to explore the relationships among voltage, current, and resistance. Older learners may even plot...
Curated OER
Mystery Liquids: Linear Function
High schoolers determine the linear equations of the density of water and oil by collecting data on the mass of various volumes of each liquid. They construct scatter plots from the data and use these to write the linear equations for...
Curated OER
Murder in the First Degree - The Death of Mr. Spud
Secondary learners investigate exponential functions in a real-world scenario. They collect data on the temperature of a cooling baked potato, enter the data into lists, and graph the data using a scatter plot before finding an...
Curated OER
Mathemafish Population
It's shark week! In this problem, young mathematically minded marine biologists need to study the fish population by analyzing data over time. The emphasis is on understanding the average rate of change of the population and drawing...