+
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Young scholars engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
+
Activity
PBL Pathways

College Costs

For Students 10th - Higher Ed Standards
Predict the year that college costs will double in your state using linear modeling. The first part of this two-part project based learning activity asks young mathematicians to use data from the College Board. They graph the data, write...
+
Activity
5280 Math

Stories That Formulas Tell

For Teachers 8th - 10th Standards
Learn the stories a formula holds. An interesting lesson takes a unique approach to teach how to use formulas. Beginning with a formula, learners predict what the variables stand for and then use the formula to make calculations and tell...
+
Lesson Plan
Curated OER

Using Excel to Reference and Graph Live Data from a Web Site

For Teachers 6th - 8th
Students collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
+
Unit Plan
Mathematics Vision Project

Module 3: Arithmetic and Geometric Sequences

For Teachers 8th - 10th Standards
Natural human interest in patterns and algebraic study of function notation are linked in this introductory unit on the properties of sequences. Once presented with a pattern or situation, the class works through how to justify...
+
Lesson Plan
Curated OER

Using Excel to Draw a Best Fit Line

For Teachers 6th - 8th
Students create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Students print graphs without trend lines and manually draw...
+
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
+
Lesson Plan
2
2
Federal Reserve Bank

Creating a Budget

For Students 9th - 12th Standards
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...
+
Lesson Plan
2
2
Federal Reserve Bank

Saving and Investing for the Long Term

For Students 9th - 12th Standards
Create savvy investors with an activity that uses an online resource to allow individuals to invest in the stock market. The teacher is able to track activity and progress. Stock tips and strategies are shared.
+
Lesson Plan
Curated OER

Sales Spreadsheet

For Teachers 6th - 8th
Learners 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

Spreadsheet Function Machine

For Teachers 7th - 8th
Students create a spreadsheet to analyze functions. In this algebra lesson, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
+
Lesson Plan
Education Development Center

Micro-Geography of the Number Line

For Teachers 5th - 8th Standards
Young mathematicians dive into the number line to discover decimals and how the numbers infinitely get smaller in between. They click the zoom button a few times and learn that the number line doesn't just stop at integers. Includes a...
+
Lesson Plan
Curated OER

George and Sam Save for a Present

For Teachers 3rd
Third graders develop their algebraic thinking by recognizing a variety of patterns using concrete objects, numbers, tables, and pictures. In this George and Sam Save for a present lesson, 3rd graders communicate their mathematical...
+
Lesson Plan
Curated OER

Composting

For Teachers 8th
Eighth graders collect data from Bottle Biology compost columns and record using Excel spreadsheet.
+
Unit Plan
Radford University

Sleep and Teen Obesity: Is there a Correlation?

For Students 10th - 12th Standards
Does the number of calories you eat affect the total time you sleep? Young mathematicians tackle this question by collecting their own data and making comparisons between others in the class through building scatter plots and regression...
+
Lesson Plan
Curated OER

How Much Does That Car Cost?

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

Cook Me Up Some Equations

For Teachers 7th - 12th
Students study a variety of math concepts in the context of cooking up a meal. In this math lesson, students calculate surface area and volume. They draw and interpret different types of graphs.
+
Lesson Plan
Curated OER

First Degree Equations

For Teachers 9th - 12th
Students establish a solid competence in solving all types of equations and a solid understanding of how variables and equations can be utilitzed to solve real life problems.
+
Lesson Plan
Curated OER

Statistical Pictures of School and Life

For Teachers 9th - 10th
Students explore how mathematical data is used to summarize and illustrate everyday life. They apply mathematical concepts and skills to analyze data. Students conduct a five question survey of 50 people or more and graph the data.
+
Lesson Plan
Curated OER

Diameter, Radius and Area

For Teachers 9th - 10th
Students calculate the diameter, radius and area of a circle. In this geometry lesson, students investigate the different ratios of a circle. They calculate the surface are of each circle.
+
Lesson Plan
Curated OER

A Lottery of Learning

For Teachers 9th - 12th
Students investigate the probability necessary to win the lottery. They view a PowerPoint Presentation, evaluate combinations, calculate lottery probability, conduct analysis of a fair game, and design a lottery to meet various...