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...
5280 Math
Stories That Formulas Tell
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...
Curated OER
Adding and Subtracting Decimals With Excel
What a great way to have pupils apply classroom learning to real-world skills! They complete problems involving the addition and subtraction of decimals related to banking-type questions, and then use a spreadsheet to display their results.
Illustrative Mathematics
Writing Constraints
Use this resource to present your number crunchers with how to write a constraint equation and to determine viable solutions. The price of an object limits the amount that can be purchased. The speed at which you walk limits the number...
Math Worksheets Land
Recognize Area Word Problems - Matching Worksheet
Don't let the title fool you on this one; there aren't any word problems here. Scholars examine five rectangles that have been partitioned into rows and columns, determining the area based on these equal square units. Units aren't...
Curated OER
Graphing Using Excel
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information. In this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the...
Curated OER
Sales Spreadsheet
Students 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.
Mt. San Antonio Collage
Quiz 1: Types of Functions
Sometimes the best things are already done for you! Here is a six-problem quiz that has a variety of problems ranging from solving quadratic equations to interpreting a function. The piece-de-resistance is the worked out answer key in...
Curated OER
Excel Lesson Plan Coin Statistics
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Curated OER
Access Ramp
Just about every public building that your students are familiar with has an access ramp which complies with ADA requirements. As it turns out, designing such a ramp is an excellent activity to incorporate slope, the Pythagorean Theorem,...
Curated OER
Code Crackers
Learners work in teams creating and posing math rules and trying to guess them using a formula controlled worksheet they create with Excel. Student pairs take turns to see who can crack the other's code the fastest.
Curated OER
Calculating the Perimeter of a Square
A quick definition and the formula for finding the perimeter of a square is provided at the top of this worksheet. After reading the description, 4th graders must find the perimeter of the 3 given squares by adding or multiplying. This...
Curated OER
Calculating the Area of a Triangle
A quick definition and the formula for finding the area of a triangle is provided at the top of this instructional activity. After reading the description, 5th graders must find the area of the 3 given triangles. This is an excellent...
Illustrative Mathematics
Slopes and Circles
An upper-level treatment of what is often presented as a basic concept (the right angle of an inscribed circle on the diameter), this activity really elevates the mathematical thought of the learner! Expected to develop formulas...
Houghton Mifflin Harcourt
Simple and Compound Interest
Your learners will get lots of practice calculating simple and compound interest by the end of this lesson. Simple explanations and examples lead learners through the concepts and steps of calculating simple and compound interest...
Mathematics Vision Project
Circles: A Geometric Perspective
Circles are the foundation of many geometric concepts and extensions - a point that is thoroughly driven home in this extensive unit. Fundamental properties of circles are investigated (including sector area, angle measure, and...
Curated OER
Back-To-School Shopping
Fifth graders estimate the prices of items to be bought for back to school. They use catalogs and/or advertisements to research the cost of each of the items. They use problem solving strategies and a spreadsheet template to determine...
Curated OER
Calculating the Area of a Rectangle
A quick definition and the formula for finding the are of a rectangle is provided at the top of this worksheet. After reading the description, 4th graders must find the area of the 3 given rectangles by adding or multiplying. This is an...
Illustrative Mathematics
Complex number patterns
Start off with the definition of the imaginary number i, then have your class practice simplifying expressions involving powers of i and look for patterns. See how the cyclic nature of powers of i translate to sums of powers of i.
Curated OER
Down the Drain: How Much Water Do You Use?
Participate in an Internet-based project to share information about water usage with other students. Collect information about water usage and compare it to the average used by people in other parts of the world.
Curated OER
Do Vampires Really Exist?
Pupils identify and extend a number pattern into very large values. They create and interpret a graph based on their number patterns. Students compare a math model with real-world statistics about the existence of vampires.
Curated OER
Statistical Pictures of School and Life
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.
Curated OER
I'm in the Money - Practical Money Skills
Students make a budget and utilize math skills to keep a record of what they spend. They use technology and spreadsheets to help them keep track of their money.
Curated OER
Area graphics for 7th graders
Students randomly select dimensions for three geometric shapes (square, right triangle and circle). From the graphs they compare and contrast the graphical results of each shape.