Curated OER
Excel Turns Data Into Information
Learners use excel to analyze data. In this technology lesson, students enter data into the excel program to find averages and organize data.
Curated OER
Interpreting Graphs
Sixth graders interpret linear and nonlinear graphs. They create graphs based on a problem set. Next, they represent quantitive relationships on a graph and write a story related to graphing.
Radford University
Discovering Quadratics
Get to know quadratics from a couple of different perspectives. Classmates work in small groups to determine the optimal cooking time for microwave popcorn. Group members pop bags of popcorn for different times and collect data on the...
Curated OER
Pike Problems in Lake Davis
Pike fish pose a threat to native trout and catfish in lakes. Would you drain and poison a lake to get rid of the Pike fish? If the lake was drained and poisoned, then refilled and repopulated with trout and catfish, how would you...
Curated OER
That's Predictable - Stream Side Science
Research the impact that changes in biotic or abiotic factors might have on an ecosystem. Debate for or against the changes and take action in the community. This resource ideally follows stream studies that young ecologists may have...
American Statistical Association
The Taste of Yellow
Does lemonade taste better when yellow? A tasty experiment has scholars determine the answer to the question. It requires conducting a taste test with lemonades of different colors (from food coloring), and then collecting and analyzing...
University of California
Heating and Cooling of the Earth's Surface
Scholars collect data from heating sand and water before forming testable hypotheses about why sand heats up faster. Afterward, they develop and run experiments to test their hypotheses.
American Statistical Association
Speedster
Catch me if you can. Scholars collect data on reaction time by catching a falling ruler or by using an Internet app. They determine the median of the data, create graphs, and analyze the results. They also compare their data to the rest...
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 instructional activity, 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. In 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
Learners 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, students will visit a Web site to test their data collection skills...
Curated OER
Excel Lesson
Students 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.
Curated OER
What's Up With My Class
Learners 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 the...
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 instructional activity, they use the data to...
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...