Teach Engineering
Understanding the Air through Data Analysis
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
Whitman College
Calculus - Early Transcendentals
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...
Curated OER
Create and Analyze Rectangular Patterns
Students explore the concept of geometric patterns. In this geometric pattern lesson plan, students use Microsoft Excel to explore geometric patterns. Students analyze growth rates of pattern growth. Students create their own...
Curated OER
Made Round To Go Round
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...
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
Minima/Maxima
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...
Curated OER
Midpoint
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...
Curated OER
Surface Area Formulas
In this geometry activity, students complete 21 problems where they find the surface area of pyramids, cubes, and rectangular prisms. This excellent activity would be an ideal quiz, or homework assignment.
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
Super Shapes Part 2 - Circles
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...
Curated OER
Peopling the New World -- An Archaeological Exercise in Excel
Young scholars examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in...
Curated OER
Making Money and Spreading the Flu!
Paper folding, flu spreading in a school, bacteria growth, and continuously compounded interest all provide excellent models to study exponential functions. This is a comprehensive resource that looks at many different aspects of these...
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
Credit Cards: The Good, the Bad, and the ugly
Students study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...
Curated OER
Turn UP the Volume!
Eighth graders find the surface area and volume of the figures and enter formulas into the spreadsheet to calculate surface area and volume for the given figures. They also find the volume and determine the shape which has the least...
Curated OER
Springfield Digital Storytelling Project #6: Grapes Commercial
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,...
Curated OER
Calculate the Slope of a Line Using Two Points
Find that slope! This video does an excellent job of demonstrating how to use the slope formula to find the slope of a line using two points. The instructor first reviews the definition of slope of a line, then works three problems using...
Chicago Botanic Garden
GEEBITT (Global Equilibrium Energy Balance Interactive TinkerToy)
Students use the GEEBITT excel model to explore how global average temperatures are affected by changes in our atmosphere in part two of this series of seven lessons. Working in groups, they discuss, analyze graphs, and enter data to...
Illustrative Mathematics
Ice Cream Cone
Every pupil with a sweet tooth will be clamoring for this lab and analysis, particularly when they're allowed to eat the results! Volume and surface area formulas for cones are developed from models, and then extended to the printing of...
Student Handouts
What's My GPA?
Here is an excellent, detailed one-page reference sheet to introduce students to what a grade point average (GPA) is and how to calculate their own.
Illustrative Mathematics
How Many Leaves on a Tree? (Version 2)
A second attack at figuring out the number of leaves on a tree, this activity makes both an excellent follow-up to version 1 and a stand-alone activity. Learners practice setting parameters and deciding acceptable estimate precision, and...
Illustrative Mathematics
Extensions, Bisections and Dissections in a Rectangle
Gaining practice in translating a verbal description into a diagram and then an equation is the real point of this similar triangles exercise. Once the diagram is drawn, multiple methods are provided to reach the conclusion. An effective...
Curated OER
Code Crackers
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.
Curated OER
Ict Activity 22
Students use Excel to solve quadratic equations by trial and improvement. They enter formulas and try different solutions to improve their solutions more quickly. Afterwards, they report the solutions to different levels of accuracy.
Other popular searches
- Microsoft Excel Formulas
- Teaching Excel Formulas
- Excel Formulas and Functions
- Writing Excel Formulas