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...
Federal Reserve Bank
Creating a Budget
Learning to create and maintain a budget is an important life skill. Guide individuals in the discovery of their spending habits and how to track them. They then use what they learned to create a budget and make decisions on where they...
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...
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...
Concord Consortium
Boards II
Build spreadsheet skills while investigating decimal multiplication. An open-ended task asks learners to edit a spreadsheet to create a multiplication table for decimals. Provided with a specific interval, pupils create formulas...
Concord Consortium
Boards IV
Build a connection between algebraic sequences and spreadsheets. Learners examine a specific folding pattern and convert the pattern into a spreadsheet. The goal of the spreadsheet is to produce a sequence of a specific pattern modeled...
Concord Consortium
Boards III
Learn to visualize mathematical patterns as a folded pattern. Beginning with a visual display, the task encourages pupils to view sequences as a folded table. The pattern of the table then becomes a formula in a spreadsheet that...
Curated OER
A Model Solar System
If Earth is modeled by a grapefruit, what planet could be represented by a golf ball? This activity uses everyday and not-so-everyday objects to create a model of the Solar System.
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...
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...
Curated OER
Endangered Species
In this geography worksheet, students identify how to manipulate data on a range of endangered species. They create a bar graph of endangered animals from Africa, Asia, Australia, North America, or South America. Students use a...
Curated OER
Spreadsheet Page 2
In this technology instructional activity, students examine the definitions. The words are used in order to match the them with the bullet points.
Curated OER
What's Alike, What's Different Worksheet
In this occupations worksheet, students create a spreadsheet by answering the 3 short answer questions in order to find similarities and differences among occupations.
Curated OER
Buying My First Car Worksheet 3
In this math worksheet, students create a spreadsheet for the different costs of the purchase of a car and use the information to answer 3 questions.
Concord Consortium
Boards I
Learners create patterns in a table to mimic the function of an electronic spreadsheet. The result is a table that creates an addition table for decimals in intervals of one-tenth. While creating the pattern, pupils must thoroughly...
Yummy Math
Parametric Equations and a Heart
Trigonometry, art, and Valentine's Day come together in a creative activity about parametric equations. Learners calculate several equations before graphing them either by hand, on a graphic calculator, or Excel spreadsheet to curve...
Noyce Foundation
Ducklings
The class gets their mean and median all in a row with an assessment task that uses a population of ducklings to work with data displays and measures of central tendency. Pupils create a frequency chart and calculate the mean and median....
Inside Mathematics
Aaron's Designs
Working with transformations allows the class to take a turn for the better. The short assessment has class members perform transformations on the coordinate plane. The translations, reflections, and rotations create pattern designs on...
California Education Partners
T Shirts
Which deal is best? Learners determine which of two companies has the best deal for a particular number of shirts. They begin by creating a table and equations containing each company's pricing structure....
Teachers Pay Teachers
What Kind of Smart Are You
Gain insight into the type of learners that fill your classroom. An eight-question survey asks scholars questions about themselves. Using their color-coded answers, they conclude their degree of intelligence in multiple areas—music,...
Curated OER
Dude, You Gotta Move
In this biomes worksheet, learners create a project about biomes after completing online research with websites given. Students complete 4 steps in completing their project.
Curated OER
Modeling the Keeling Curve with Excel
In this modeling the Keeling Curve worksheet, high schoolers use given data beginning in 1960 to create a mathematical model for the changes in atmospheric carbon dioxide over time. Students manipulate the equation to predict the carbon...
Curated OER
A Mathematical Model of the Sun
In this mathematical model of the sun worksheet, students read about the way scientists use the sun's radius and mass to determine a mathematical model of the sun using the volume of a sphere, and the relationship between density, volume...
Curated OER
Experiment-Using Formulas and Spreadsheets
In this Algebra I instructional activity, 9th graders track information relating to a sporting event and create a spreadsheet and appropriate formulas used to track data. The one page instructional activity contains the...