Curated OER
Baseball Relationships - Using Scatter Plots
Students use graphing calculators to create scatter plots of given baseball data. They also determine percentages and ratios, slope, y-intercepts, etc. all using baseball data and statistics.
Curated OER
Fast Food Survey Using Bar Graphs
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
Students collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
Curated OER
Moving Day!
Eighth graders continue their geometry unit by focusing on volume. Using data, they create a spreadsheet, estimate and calculate volume. They solve real-life problems and round their answers to the hundredths place. They also practice...
Curated OER
Louisville's Best Field Day Park
Students create a survey to hand out to determine the best field day park. Using their local area, they select five parks, if possible, that meet the criteria and calculate the distance and estimated time travel. They use this...
Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Bowland
Speed Cameras
Do speed cameras help reduce accidents? Scholars investigate this question using a series of spreadsheet activities. Along the way, they learn about randomness, probability, and statistical analysis.
Intel
Pedal Power
Show your classes the importance of mathematics in something as simple as bicycle design. The final lesson in the six-part STEM series has each group research a different aspect of the bicycle. Learners use mathematical formulas, linear...
Howard Hughes Medical Institute
Gorongosa: Scientific Inquiry and Data Analysis
How does the scientific process begin? Introduce ecology scholars to scientific inquiry through an insightful, data-driven lesson. Partners examine data from an ongoing research study to determine the questions it answers. The resource...
Vertex42
Class Attendance Template
Keep track of absences with an already-prepared attendance page. Simply enter your class information and pupils' names on the first sheet to get started. Along the bottom are tabs for each month. Use the key along the top of each of...
Curated OER
Weather, Weather, Everywhere!
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
Curated OER
Buying a Car
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
Curated OER
Solving Polynomial Equations
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Curated OER
Super Spreadsheets
Students develop a spreadsheet containing statistical data. They describe and interpret the data to make conclusions. They review the differences between an unorganized spreadsheet verses an organized one.
Curated OER
Multiplication Tables Using Microsoft Excel
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
Howard Hughes Medical Institute
Scientific Inquiry Using WildCam Gorongosa
How do scientists determine what questions to ask to meet their research goals? Help your class develop an inquiry mindset with a lesson based on studies in the Gorongosa National Park. Partners create their own research questions by...
Howard Hughes Medical Institute
Spreadsheet Tutorial 5: Histogram
A professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...
Curated OER
Super Spreadsheets
Students discover information about each of the fifty states in the United States. In groups, they create a spreadsheet organizing the information to show to the class. They discover different ways to display the data and identify the...
Curated OER
What Color Are Your Skittles?
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.
Curated OER
Electronic Spreadsheets & Iditarod 2000
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
Curated OER
Life Through Time: The Heart of the Phanerozoic
Young scholars gain a deeper understanding of geological time and the evolution of life on Earth. They use iMovie to tell a complex story of a discrete time period with narration and images.
Curated OER
Introduction to Spreadsheets
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
Curated OER
Simple Bar Graphs Using Excel
Pupils create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Curated OER
Building Arrays Using Excel Spreadsheets
Students create arrays using Microsoft Excel. In this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.