Lesson Plan
2
2
Federal Reserve Bank

Expense Tracking

For Students 9th - 12th Standards
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.
Lesson Plan
EngageNY

Credit Cards

For Teachers 10th - 12th Standards
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.
Lesson Plan
Bowland

Outbreak: Infection Detection

For Teachers 6th - 9th
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...
Lesson Plan
Curated OER

Bones and Math

For Teachers 5th - 12th
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...
Lesson Plan
Curated OER

Math: The Bone connection

For Teachers 5th - 12th
Young scholars 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...
Lesson Plan
Curated OER

Edible Math

For Teachers 2nd
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.
Lesson Plan
Curated OER

Using Calculators And Spreadsheets

For Teachers Higher Ed
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.
Lesson Plan
Curated OER

Spreadsheets in Science

For Teachers 4th
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...
Lesson Plan
Curated OER

Pollution Assessment: Is Wood Lake a Good Lake?

For Teachers 7th - 8th
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.
Lesson Plan
Curated OER

Baseball Statistics

For Teachers 7th - 8th
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...
Lesson Plan
Curated OER

Crispy Cookie Class Fundraiser

For Teachers 7th
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.
Lesson Plan
Curated OER

Shop 'Til You Drop

For Teachers 3rd - 5th
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...
Lesson Plan
Curated OER

Polluting the Environment

For Teachers 4th
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...
Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

For Teachers 4th
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.
Lesson Plan
Curated OER

Marvelous Math -- Colorful Fractions

For Teachers 2nd - 6th
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...
Lesson Plan
Curated OER

Income Levels & Social Class: Is It All About Cash?

For Teachers 5th - 8th
Young scholars graph data and interpret that data after reading information about lifestyles and income levels. They calculate percentages, set up spreadsheets and calculate columnar data.
Lesson Plan
Alabama Learning Exchange

Watch That Plant Grow

For Teachers 6th - 8th
Middle schoolers examine the growth of marigolds in a greenhouse environment. They chart data in spreadsheets showing plant growth over time and under a number of conditions. They record measures of plant height and greenhouse temperature.
Lesson Plan
Curated OER

Sales Spreadsheet

For Teachers 6th - 8th
Young scholars use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Lesson Plan
Curated OER

Function Graphing--ID: 8252

For Teachers 9th
Those graphing calculators can be tricky; good thing Texas Instruments has devised a lesson on how to use their TI-Nspire calculator to graph functions. Kids investigate functional notation as they graph ordered pairs in the form (a,...
Lesson Plan
Curated OER

Graphs and Spreadsheets

For Teachers K - 12th
Students collect data and present it in a graph and/or a spreadsheet, depending on their previous understanding of technology.
Lesson Plan
1
1
Texas Instruments

Is It or Isn't It Proportional

For Teachers 6th - 12th Standards
How can you tell if number relationships are proportional? Mathematicians investigate proportional relationships. They compare and contrast functions and graphs to determine the characteristics of proportional relationships, as well as...
Lesson Plan
Curated OER

Level III: Technology Integration

For Teachers 4th
Fourth graders prepare two spreadsheets each with an embedded line graph that displays data about the growth of the bitter rot fungus on apples and on petri dishes that were stored in the refrigerator and the classroom. They prepare a...
Lesson Plan
Code.org

Making Data Visualizations

For Teachers 9th - 12th
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The...
Lesson Plan
Curated OER

Macbeth Madness

For Teachers 10th - Higher Ed
Students research Macbeth online and complete computer and graphing activities for the play. In this Macbeth activities lesson, students research Macbeth and bookmark the URL's. Students complete activities for the topic on spreadsheets...