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 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...
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
Parts of a Spreadsheet
Learners 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
Create a Budget
Students develop a budget spreadsheet to manage finances for their business. For this finance lesson, students use a spreadsheet program to create a budget with credit and debit columns. There are step-by-step directions for...
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.
Curated OER
Creating a Spreadsheet and Graph
Students create graphs in Excel. In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data. The directions to create the...
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...
Curated OER
Creating a Spreadsheet
Students create a spreadsheet using ICT. In this algebra lesson, students collect and graph their data using a spreadsheet. They find solution to a given problem using trial and error.
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
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
M&M Graphing
Fourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.
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
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
Using a Spreadsheet
Students create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Curated OER
Data Analysis and Probability: Graphing Candy with Excel
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
Curated OER
Dino-Myte Spreadsheet
Do your learners like dinosaurs and theme parks? An ambitious lesson 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 must include a...
Teach Engineering
Searching for Bigfoot and Others Like Him
Individuals create a GIS data layer in Google Earth that displays information about where one might find seven different cryptids. The class members research to find data on cryptid sightings they can include in their data...
Las Cumbres Observatory
Plotting a Supernova Light curve
Supernovas burn for a short time but can give scientists extensive information about the universe. Learners analyze given data about the change in the light magnitude of a supernova. They look for patterns in the data and use them 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...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Curated OER
Graphing Our Marbles
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Curated OER
Hopes and Dreams: A Spreadsheet Lesson Using Excel
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Curated OER
How Much Does That Car Cost?
Young scholars calculate how much it costs to buy a used car and finance it through a bank. They select a car from the newspaper, conduct Internet research on current auto loan interest information for four different states, and create...