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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
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...
Curated OER
Excel Lesson
Students investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
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...
National Council of Teachers of Mathematics
National Debt and Wars
Take a functional approach to the national debt. Learners collect information about the national debt by decade and plot the data. They determine whether an exponential curve is a good fit for the data by comparing the percent changes...
Curated OER
Using Excel To Teach Probability And Graphing
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...
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.
PBL Pathways
Doctors and Nurses
How many nurses does it take to support one doctor? A project-based activity asks learners to analyze state data to answer this question. Classes create polynomial functions from the data of doctors and nurses over a seven-year...
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
Why Are Hot Things Red?
For this radiation and temperature worksheet, students use 2 methods to derive the Wein Displacement law that shows the relationship between the temperature of a body to the frequency where the Planck curve's value is at its maximum....
Curated OER
What's Your Favorite? Survey And Graphing Project
Sixth graders create and edit spreadsheet documents using all data types, formulas and functions, and chart information. They collect and organize data that be portrayed in a graph that they create using EXCEL.
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...
Curated OER
Using Electronic Manipulatives in Multiplication
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Curated OER
Soil Excavation
Students comprehend how percent of change and multipliers are used to determine volume for removal and replacement of soils. They calculate soil volume percent changes using data tables. They apply formulas to solve a variety of...
Curated OER
Star Light...Star Bright
For this brightness of stars worksheet, students use a given formula using the temperature in Kelvins of a star to find its brightness. Students solve 4 problems using this equation.
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...
Curated OER
Solving Polynomial Equations
Young scholars demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Radford University
Sleep and Teen Obesity: Is there a Correlation?
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...
Curated OER
Roofing and Right Triangles
Young scholars use models and symbols to represent properties of the Pythagorean Theorem. In this right triangle instructional activity, students connect real jobs to properties of right triangles. They solve word problems applying the...
Curated OER
Interest Calculation and Spreadsheets
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Curated OER
Worksheet 2 - Spring 1996
In this math learning exercise, students state the two fundamental laws of Calculus. Then they investigate finding the area of a rock in cross-sectional pieces.
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.
University of Illinois
University of Illinois: Quadratic Formula
This site from the University of Illinois offers an excellent simulation of the quadratic formula, where you can type in different values for a, b, and c, and then view the change in the answer for x.