Concord Consortium
Broken Spreadsheet II
Work in reverse with the product becoming the given. Using a spreadsheet image of the graph of a trigonometric function, young scholars investigate methods of creating spreadsheet data that results in the given graph. The catch? The data...
Georgia Department of Education
Math Class
Young analysts use real (provided) data from a class's test scores to practice using statistical tools. Not only do learners calculate measures of center and spread (including mean, median, deviation, and IQ range), but also use this...
Concord Consortium
Broken Spreadsheet I
There is power in spreadsheet formulas and learners use this power to model quadratic data. Given a scatterplot of a parabola, pupils create formulas in a spreadsheet to populate the data. The formulas they use lead to an understanding...
University of Missouri
Money Math
Young mathematicians put their skills to the test in the real world during this four-lesson consumer math unit. Whether they are learning how compound interest can make them millionaires, calculating the cost of remodeling their bedroom,...
Curated OER
The Remainder Theorem Using TI-Nspire CAS
Investigate the Remainder Theorem in this algebra lesson. Explore the relationship between the remainders of polynomial division and the function. Each of the four problems gets progressively more complicated. This might be a great...
Curated OER
Sunrise, Sunset
What locations on Earth get the longest number of hours of daylight in the summer? Hint: It's not the equator! Use real-world sunrise and sunset data to develop trigonometric models that can be used to estimate the number of hours of...
Curated OER
Dino-Myte Spreadsheet
Do your learners like dinosaurs and theme parks? An ambitious instructional activity invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which...
Howard Hughes Medical Institute
Spreadsheet Tutorial 4: t-Test
The t-test tutorial will fit your needs to a T. After calculating the mean, sum of squares, standard deviation, and variance of two data sets on a spreadsheet, scholars learn to calculate the t-values. They then learn to use the TTEST...
Curated OER
Math Hunt
Go on a scavenger hunt around your school to find evidence of math. Investigate different areas of your school for patterns, fractions, and different geometric shapes. Finally, create a spreadsheet and plot the data you've collected.
Kenan Fellows
Saving Those Who Save Us: Exploring the Use of Sensors with Data Visualization
Sensor technology is amazingly accurate and useful. Combining the sensor technology and mathematical knowledge, scholars design experiments to answer a question they have developed. Questions may focus on light sensing, temperature...
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.
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...
Curated OER
Using Electronic Manipulatives in Multiplication
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Concord Consortium
Be Well
How much do you spend on healthcare each year? Data shows the expenditures in the US rise significantly each year. Young scholars use the data to calculate a rate of change over a 30-year period and look for—as well as provide— possible...
Balanced Assessment
Sales Tax Table
Sales tax rates vary; do the math to find the right rate! Pupils use before tax amounts and after tax amounts to determine the tax rate. Rounding makes the task challenging.
CK-12 Foundation
Newton's Method
Does the accuracy of the first guess make a difference down the line? Learners investigate the effects of the iterative process of finding roots, using Newton's Method. By moving the initial guess of a root on a graph, pupils observe the...
Curated OER
Cross Cultural Transportation and Resources Exchange
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Curated OER
Analyzing Discrete and Continuous Data in a Spreadsheet
You are what you eat! Your statisticians keep a log of what they eat from anywhere between a day to more than a week, keeping track of a variety of nutritional information using a spreadsheet. After analyzing their own data, individuals...
Curated OER
Parts of a Spreadsheet
Students create their own spreadsheet. They identify the different parts that make up a spreadsheet and organize their data. They practice using functions and formats.
Curated OER
Parts of a Spreadsheet
Students experiment with the basic functions of a spreadsheet. They practice using headers, footers, functions and fonts. They also organize information.
Curated OER
Down the Drain: How Much Water Do You Use?
Participate in an Internet-based project to share information about water usage with other students. Collect information about water usage and compare it to the average used by people in other parts of the world.
Curated OER
Reading & Using a Nutrition Label
Students discover the importance of healthy eating. Using food nutrition labels, they read and examine the nutritional value. Students collect the data on a spreadsheet and create a graph. They analyze the media influences on product...
Curated OER
Using Computer for Statistical Analysis
Students use the computer and S'COOL data for statistical analysis.
Curated OER
Adding and Subtracting Decimals With Excel
What a great way to have pupils apply classroom learning to real-world skills! They complete problems involving the addition and subtraction of decimals related to banking-type questions, and then use a spreadsheet to display their results.