Hi, what do you want to do?
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
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...
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,...
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
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...
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...
Curated OER
Excel Lesson
Young scholars 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...
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
Using Excel To Teach Probability And Graphing
Learners 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
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.
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
Students use models and symbols to represent properties of the Pythagorean Theorem. In this right triangle lesson, students connect real jobs to properties of right triangles. They solve word problems applying the correct ratios and...
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...
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
Sales Spreadsheet
Middle schoolers 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.
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
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Students improve data entry in a spreadsheet.
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
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.
Curated OER
Why Are Hot Things Red?
In 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
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
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
Solving Polynomial Equations
Students 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.