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
Inserting Formulas in a Worksheet in Excel
Ninth graders study the vocabulary necessary to create formulas in Microsoft Excel. They complete assigned problems from the textbook for each type of function demonstrated by the teacher until they have developed competency with each...
Open Oregon Educational Resources
Beginning Excel
How can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...
Curated OER
Multiplication Tables Using Microsoft Excel
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
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...
Curated OER
Spreadsheet formulas
Students, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve...
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 Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Students improve data entry in a spreadsheet.
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.
Curated OER
WORKING WITH WORKBOOKS
Students work through problems in the textbook and teacher-made problems to reinforce the new learning. They turn in practice problems to instructor to be checked for accuracy and evidence of understanding
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...