Curated OER
Mmm, Mmm, M&M's
Here is another version of the classic M&M math lesson. In this one, upper graders utilize the ClarisWorks Spreadsheet program in order to document the data they come up with from their bags of M&M's. After making their initial...
Curated OER
Excel Lesson
Students explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Federal Reserve Bank
Expense Tracking
Where does all your money go? Individuals keep a record of the money they spend over the course of 30 days. They then categorize where they are spending their money and write an essay detailing their findings.
EngageNY
Credit Cards
Teach adolescents to use credit responsibly. The 32nd installment of a 35-part module covers how to calculate credit card payments using a geometric series. It teaches terminology and concepts necessary to understand credit card debt.
Bowland
Outbreak: Infection Detection
Explore the mathematics of infection outbreaks with activities that ask learners to use coordinate grids to locate infected patients. They calculate amounts of ingredients for antidotes and determine which groups of people should be...
Curated OER
Bones and Math
students identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and organize...
Curated OER
Math: The Bone connection
Students examine the connection between bones of the human body and math. In groups, they locate bones and determine which instruments are used for measuring. Students organize their findings and create spreadsheets for calculating and...
Curated OER
Piecewise Linear Functions and Excel
In this linear function worksheet, students use Excel worksheets to solve piecewise linear functions. They plot functions and produce piecewise linear functions. This six-page worksheet contains detailed instructions on how to use...
Curated OER
Math Operations/Formulas
Students discuss the ways spreadsheets can help them solve story problems. In groups, they must set up a spreadsheet with the correct formulas based off of different scenerios using the correct order of operations. To end the lesson,...
Curated OER
Edible Math
Second graders use M&M candies to graph colors, illustrate story problems and practice hands-on math. They use spreadsheets, worksheets and graphs to organize math problems that use M&M's.
Curated OER
Using Calculators And Spreadsheets
Students discuss the advantages of using calculators and spreadsheets in balancing checkbooks. They also identify the pros and cons of using these tools in adult education classrooms.
Curated OER
Spreadsheets in Science
Fourth graders create spreadsheets, explore patterns and make predictions based on the information. They select the appropriate graph to display the spreadsheet data. They search and sort prepared data bases to gain knowledge for...
CK-12 Foundation
Compound Interest per Period: Credit Card Payment
Credit cards can be convenient, but are they worth it? Future consumers learn about compound interest and credit card payments. They use an interactive to create a table that shows the remaining balance after each month.
Concord Consortium
More or Less
How long can the cable get? A short performance task provides learners with information on the length of cables and the margin of error for each. They must determine the longest and shortest cable possible by splicing these cables.
Radford University
Money and Finance
Make the connection between money and exponential equations. Pupils continue financial lessons as they learn about compound interest in savings accounts. They extend the investigation of savings by looking at annuities, and then...
Curated OER
What Color Are Your Skittles?
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.
Curated OER
Pollution Assessment: Is Wood Lake a Good Lake?
Students become aware of pollution in Richfield Minnesota's Wood Lake, identify sources of pollution in Wood Lake, learn to use variables, equations, spreadsheets and modeling software, and generate solutions for the problem.
Curated OER
Baseball Statistics
Students read "Casey at the Bat" and then use individual player statistics (found through internet research)to determine if their players could be considered baseball "heroes". They must justify their choices for "hero" by creating...
Curated OER
Crispy Cookie Class Fundraiser
Seventh graders see the relationship of math and the real world application by manufacturing a product for making a profit. They create a food product from a recipe, record their sales and analyze and report their gross profit.
Curated OER
Shop 'Til You Drop
Students evaluate food prices. In this real world math lesson plan, students compare the cost of various grocery items to determine which is the best deal. They work in groups using grocery ads to decide how to get the most product for...
Curated OER
Polluting the Environment
Fourth graders construct mini-ecosystem, pollute the ecosystem, observe, collect, and record data on the effects of these pollutants on their ecosystem, organize data on spreadsheets, create graphs, and design presentations to share with...
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
Marvelous Math -- Colorful Fractions
Students begin the lesson by discovering that a fraction is one part of a whole. In groups, they practice reducting larger fractions into small fractions and discovering they are equal. They use blocks to identify the relationship...
Curated OER
Income Levels & Social Class: Is It All About Cash?
Students graph data and interpret that data after reading information about lifestyles and income levels. They calculate percentages, set up spreadsheets and calculate columnar data.