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...
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...
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...
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
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...
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....
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...
Howard Hughes Medical Institute
Lesson 8: WildCam Gorongosa Data Analysis
How do scientists analyze data to get a specific answer to a question? The final chapter in an eight-part series of activities centered around Gorongosa National Park encourages scholars to dig deeper into the scientific process. After...
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
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...
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....
Texas Education Agency (TEA)
Advanced Technical Skills in Business
Scholars put their technical skills to the test as they practice writing a business letter, creating charts and spreadsheets, and designing a flyer. Additionally, pupils create a PowerPoint presentation about a professional topic of...
Open Oregon Educational Resources
Beginning Excel
How can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...
Inside Mathematics
Graphs (2006)
When told to describe a line, do your pupils list its color, length, and which side is high or low? Use a learning exercise that engages scholars to properly label line graphs. It then requests two applied reasoning answers.
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,...
Conneticut Department of Education
Personal Finance Project Resource Book
Balancing a budget, paying taxes, and buying a home may feel out of reach for your high schoolers, but in their adult years they will thank you for the early tips. A set of five lessons integrates applicable money math...
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...
American Institutes for Research
Digital Smiles
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
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...