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

Excel

For Teachers 9th - 11th
In this technology worksheet, learners are taught how to create documents using Excel. They follow the directions on a handout to help them create documents. They print their final work and submit it.
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
Curated OER

Excel Lesson

For Teachers 9th - 10th
Students investigate Microsoft excel. In this technology lesson plan, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
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.  For this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the...
Lesson Plan
Curated OER

Excel for Beginners

For Teachers 4th - 5th
In this Excel lesson, students set a formula to check their homework. Students also use clipart, work in groups, and learn to use the tools in the drop-down list.
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...
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 1: Formulae, Functions, and Averages

For Students 9th - 12th
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Lesson Plan
Curated OER

Introductory Excel Lesson involving Problem Solving

For Teachers 6th
Sixth graders analyze an introductory lesson for Microsoft Excel. They go step by step through the creation of a basic spreadsheet and the use of simple formulas in a problem solving format.
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

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

Computing with Mathematical Formulas

For Teachers 9th - 12th Standards
Young scholars solve problems using formulas. In this algebra lesson, students evaluate numbers using substitution. They graph their answers using a TI and discuss the outcome.
Lesson Plan
Curated OER

We All Scream for Ice Scream

For Teachers 9th - 12th Standards
High schoolers explore the formulas for volume of three-dimensional objects. They participate in various activities involving ice cream, ice cream cones, small candies, and gum balls, recording their calculations on a lab sheet.
Lesson Plan
Curated OER

Sales Spreadsheet

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

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their graph.
eBook
Whitman College

Calculus - Early Transcendentals

For Teachers 9th - Higher Ed Standards
This textbook takes the learner from the basic definition of slope through derivatives, integrals, and vector multivariable calculus. Each section is composed primarily of examples, with theoretical introductions and explanations in...
Lesson Plan
Curated OER

Create and Analyze Rectangular Patterns

For Teachers 6th - 8th
Students explore the concept of geometric patterns. In this geometric pattern lesson, students use Microsoft Excel to explore geometric patterns. Students analyze growth rates of pattern growth. Students create their own patterns and...
Lesson Plan
Curated OER

Made Round To Go Round

For Teachers 2nd - 3rd
In this lesson students investigate what it would cost to furnish one room of their choice by shopping on the Internet. Both Australian and American dollars are to be given for each item to demonstrate the difference between two...
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...
Interactive
Curated OER

Midpoint

For Students 9th - 12th
In this online math worksheet, students compute the midpoint between two sets of coordinate pairs. This excellent resource allows the students to check their answers, and to get "hints" should they run into difficulties. A terrific...
Worksheet
Curated OER

Minima/Maxima

For Students 10th - 12th
In this minima/maxima worksheet, students solve systems of equations, identify the first derivative of a quadratic equation, and find the critical point in an equation. Using Excel worksheets, students graph four equations. There are...
Worksheet
Curated OER

Surface Area Formulas

For Students 5th - 10th
In this geometry learning exercise, students complete 21 problems where they find the surface area of pyramids, cubes, and rectangular prisms. This excellent learning exercise would be an ideal quiz, or homework assignment.
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

Super Shapes Part 2 - Circles

For Teachers 5th - 6th
Through the use of Internet, video, and hands-on activities, youngsters learn the parts and characteristics of a circle. This fantastic lesson has some excellent website activities included in the plan. Your kids will have a much greater...

Other popular searches