+
Lesson Plan
Curated OER

Data Analysis and Probability: Graphing Candy with Excel

For Teachers 5th - 8th
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...
+
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

Adding and Subtracting Decimals With Excel

For Teachers 5th
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.
+
Lesson Plan
Illustrative Mathematics

Writing Constraints

For Teachers 9th - 12th Standards
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...
+
Worksheet
Math Worksheets Land

Recognize Area Word Problems - Matching Worksheet

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

Graphing Using Excel

For Teachers 5th
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information.  In this graphing lesson plan, 5th graders graph favorite desserts of the class. Student put their results into the computer and...
+
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.
+
Assessment
Mt. San Antonio Collage

Quiz 1: Types of Functions

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

Excel Lesson Plan Coin Statistics

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

Springfield Digital Storytelling Project #6: Grapes Commercial

For Teachers 6th
Here is a fabulous lesson that should have your class very excited! They utilize the GRAPES formula in order to produce a commercial like ones we see on TV. Working in pairs, they must come up with a script, take video, provide music,...
+
Activity
1
1
Curated OER

Access Ramp

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

All About Me

For Teachers 6th - 8th
Students complete various biographical and autobiographical writing activities. They write an autobiographical essay, biopoem, biographical essay, and design and decorate a bag presenting character traits.
+
Lesson Plan
Curated OER

My Teacher Can Teach Anyone!

For Teachers 1st - 2nd
Begin the school year with enthusiasm using the book entitled My Teacher Can Teach Anyone! In this reading for meaning lesson, primary readers listen to the story and discuss what is happening and why the boy in the story might be...
+
Lesson Plan
Curated OER

Code Crackers

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

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Students improve data entry in a spreadsheet.
+
Activity
Illustrative Mathematics

Slopes and Circles

For Teachers 9th - 12th Standards
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 from...
+
Unit Plan
Curated OER

All About Me

For Teachers 7th
Students practice biographical and autobiographical forms of writing: autobiography, biopoem, character traits, classmate biography.
+
Lesson Plan
Curated OER

Christmas Makes Me Think

For Teachers 3rd
Third graders discover that Christmas is a time for giving and sharing. In this Christmas spirit lesson, 3rd graders read a book about a child who is excited about Christmas trees and presents, but comes to realize that Christmas is...
+
Assessment
Houghton Mifflin Harcourt

Simple and Compound Interest

For Students 7th - 12th Standards
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...
+
Unit Plan
Mathematics Vision Project

Circles: A Geometric Perspective

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

Love Canal-A Man Made Disaster

For Teachers 9th - 12th
Students watch a "Waste Management" Power Point as well as a "Love Canal" PowerPoint (a link is provided for the second presentation). Students write the chemical formula for each chemical and convert the contamination to grams using...
+
Lesson Plan
Curated OER

Back-To-School Shopping

For Teachers 5th
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...
+
Lesson Plan
Discovery Education

Sonar & Echolocation

For Teachers 9th - 12th Standards
A well-designed, comprehensive, and attractive slide show supports direct instruction on how sonar and echolocation work. Contained within the slides are links to interactive websites and instructions for using apps on a mobile device to...
+
Lesson Plan
Curated OER

Down the Drain: How Much Water Do You Use?

For Teachers 4th - 8th
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.