Curated OER
What's the Scoop?: Our Favourite Ice Cream Flavours
Sixth graders create a spreadsheet on the favorite ice cream flavors of their peers. They interview their classmates, documenting their findings on a "Favorite Flavors" spreadsheet. Students graph and analyze the data.
Curated OER
It's Your Life - Safe or Sorry/Safety Issues
Students examine and chart data about safety hazards and unsafe situations. For this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data and...
Curated OER
Metrically Me!
Students define the parts of a database, search strategies to locate information electronically, create/modify databases, etc. and enter data into a prepared spreadsheet to perform calculations.
ARKive
Biodiversity and Evolution – Darwin’s Finches
Teens experience natural selection firsthand (or first beak) in an activity that has them act as finches foraging for food. Using different household items to act as different beak styles, your little finches will collect as much food...
Chicago Botanic Garden
Micro-GEEBITT Climate Activity
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...
Curated OER
Using a Spreadsheet to Solve Gas Law Problems
High schoolers use a spreadsheet to solve gas law problems. In this gas laws lesson plan, students use the Express Calc program to load a spreadsheet for the gas law problems. High schoolers compute volume, temperature, or pressure...
Curated OER
Pythagorean Theorem Spreadsheet
Studetns use a spreadsheet to organize data on the sides of a triangle. They use the Pythagorean Theorem and the If then spreadsheet function to decide whether the three sides determine a right triangle. Middle schoolers work...
Curated OER
Using Excel To Teach Probability And Graphing
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...
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
Graphing Using Excel
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information. In this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the computer and then...
Curated OER
Using a Spreadsheet to Understand Density
Students use density to identify what metal a gold colored weight is made of. They use a spreadsheet to graph the experimental density of common metals and compare the know densities to their calculated density of the known metal.
Curated OER
Graphing the Past Using Today's Technology
Eighth graders research statistical data regarding their current social studies unit. They write questions about the measures of central tendency, collect and analyze the data, insert the data into a spreadsheet, and generate graphs.
Curated OER
Using Tables to Solve Linear Functions
Oh that intercept! Budding algebra masters solve linear equations from standard to intercept form. They identify the slope and y-intercept to help graph the lines, an then create coordinate pairs using a table of values. Great TI tips...
Curated OER
Using Fractions to Represent M&M Colors
Students investigate the concept of fraction and tangible application. For this algebra lesson, students use fractions to solve real life scenarios. They convert between fractions and decimals and identify the numerator and denominator.
Council for Economic Education
Loan Amortization - Mortgage
When you buy a home for $100,000, you pay $100,000—right? On the list of important things for individuals to understand, the lesson presents the concept of interest rates and loan amortization using spreadsheets and online sources....
Statistics Education Web
Are Female Hurricanes Deadlier than Male Hurricanes?
The battle of the sexes? Scholars first examine data on hurricane-related deaths and create graphical displays. They then use the data and displays to consider whether hurricanes with female names result in more deaths than hurricanes...
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.
Code.org
Discover a Data Story
"Data is so boring, there's no way to find any patterns in them." Or is there? Pairs investigate data sets using different data visualization tools to discover a trend that may exist in a data set. Once they find a trend or pattern,...
EngageNY
Buying a Car
Future car owners use geometric sums to calculate payments for a car loan in the 31st installment of a 35-part module. These same concepts provide the basis for calculating annuity payments.
Council for Economic Education
Understanding a Balance Sheet
Read any financial website or book, and it is bound to discuss the words asset and liability. But what do these words actually mean to the class? The resource effectively explains by using multiple formats and techniques, including...
EngageNY
More on Modeling Relationships with a Line
How do you create a residual plot? Work as a class and in small groups through the activity in order to learn how to build a residual plot. The activity builds upon previous learning on calculating residuals and serves as a precursor to...
EngageNY
Federal Income Tax
Introduce your class to the federal tax system through an algebraic lens. This resource asks pupils to examine the variable structure of the tax system based on income. Young accountants use equations, expressions, and inequalities to...
Polar Trec
Ozone Data Comparison over the South Pole
Did you know the hole in the ozone is seasonal and filled by January every year? The lesson uses scientific measurements of the ozone over the South Pole to understand patterns. Scholars learn that the hole grew bigger annually before...
Kenan Fellows
Applying Linear Regression to Marathon Data
It's not a sprint, it's a marathon! Statistic concepts take time to develop and understand. A guided activity provides an opportunity for individuals to practice their linear regression techniques in spreadsheet software. The activity...