Math Tools Browse

Resource Name	Topic (Course)	Technology	Type	Rating
Browsing: All Content on Spreadsheet Browse discussions			Login to Subscribe / Save Results
Investigating the Height of a ...	Length/height (Math 6)+	Excel	Activity	[0]
How do you get started at mathematical modeling? Here is an easy, quick, and engaging activity and a “just add data” interactive Excel spreadsheet to accomplish that first modeling task. The task ... More: lessons, discussions, ratings, reviews,...
Median-Median Line	Scatterplots (Probability & Statistics)+	Excel	Activity	[0]
This is a student handout to accompany an Excel file in which students use a spreadsheet, and knowledge about the point-slope equation for a line, to develop the median-median line. They compare tota... More: lessons, discussions, ratings, reviews,...
A Graphical Analysis of M&M’s ...	Bar graphs (Math 5)+	Excel	Lesson Plan	[0]
Students will create bar graphs and pie graphs, use these graphs and the statistical calculations done in a previous activity to compare individual data with class data and discuss the effect of sampl... More: lessons, discussions, ratings, reviews,...
Analyzing Temperature Trends f...	Bar graphs (Math 6)+	Excel	Lesson Plan	[1]
Students will collect temperature data from the data archive of the National Climatic Data Center website. They will choose three cities with similar latitude or longitude and compare the average tem... More: lessons, discussions, ratings, reviews,...
Analyzing Birth Rates	Data analysis (Math 7)+	Excel	Lesson Plan	[0]
The data in this activity include the number of live births per 1,000 23-year-old women in the United States between 1917 and 1975. Students create a scatterplot and historically analyze the trends i... More: lessons, discussions, ratings, reviews,...
Sunspots and Geomagnetic Distu...	Data analysis (Math 7)+	Excel	Lesson Plan	[0]
In this activity, students will analyze two sets of scientific data and discuss possible relationships between them. Students will compare two data sets demonstrating periodic cycles, compare the cycl... More: lessons, discussions, ratings, reviews,...
Collecting and Numerically Ana...	Finding percentages (Math 5)+	Excel	Lesson Plan	[1]
In this investigation, students collect, organize, and analyze color data from individual sized bags of plain M&Ms (1.69 oz.). This activity is designed to be an introduction to the calculation capabi... More: lessons, discussions, ratings, reviews,...
Rational Number Relationships	Fractions <--> decimals (Math 6)+	Excel	Lesson Plan	[0]
In this activity, students use an interactive spreadsheet template to explore relationships and patterns in rational numbers. The students will also learn how to create the template. Students will exp... More: lessons, discussions, ratings, reviews,...
Relationships Between Area and...	Quadrilaterals (Geometry)+	Excel	Lesson Plan	[0]
In this activity, students explore the relationships between area and perimeter by fixing one value and maximizing the other. Students will explore the relationship between perimeter and area of recta... More: lessons, discussions, ratings, reviews,...
Fibonacci-Like Sequences and t...	Ratios (Math 7)+	Excel	Lesson Plan	[0]
In this activity, students develop the Fibonacci sequence and use a spreadsheet to investigate several of its interesting properties, drawing on a recursive formula to discuss arithmetic and geometric... More: lessons, discussions, ratings, reviews,...
Analyzing Smoking and Lung Can...	Scatter plots (Math 7)+	Excel	Lesson Plan	[0]
This activity uses a data set from an actual study to explore the relationship between smoking and deaths from lung cancer. Students will use real world data to explore an important issue in our socie... More: lessons, discussions, ratings, reviews,...
Exploring Sunspots	Scatter plots (Math 7)+	Excel	Lesson Plan	[0]
In this activity, students will analyze historical sunspot data and discuss the cyclic pattern in the data. Students will analyze scientific data demonstrating a periodic cycle, interpret a graph of t... More: lessons, discussions, ratings, reviews,...
Exploring and Analyzing Sequen...	limit (PreCalculus)+	Excel	Lesson Plan	[0]
In this activity, students generate sequences and cumulative sequences, and analyze each numerically and graphically. Students explore sequences, cumulative sequences, convergence, divergence, functio... More: lessons, discussions, ratings, reviews,...
Developer’s Guide to Excelets	General (Math 6)+	Excel	Support Material	[0]
Excelets are interactive Excel spreadsheets or simulations of mathematical models. The user changes a variable and the spreadsheet changes in numerical, graphical, and/or even symbolic form (equation... More: lessons, discussions, ratings, reviews,...
Using Excel for Handling, Grap...	General (Math 6)+	Excel	Support Material	[0]
A step-by-step illustrated guide to use Excel in science and mathematics written by Scott Sinex and Barbara Gage, Prince George's Community College. More: lessons, discussions, ratings, reviews,...
Make 24 If You Can	Addition (Math 5)+	Excel	Tool	[4]
This is an Excel spreadsheet that implements a game similar to the card-based 24 Game by Suntex International Inc. The game presents four digits at random. The challenge is to devise a numerical exp... More: lessons, discussions, ratings, reviews,...
The Best-Fit Straight Line: H...	Analyzing Linear Data (Algebra)+	Excel	Tool	[2]
Linear regression is a powerful technique for fitting data as students begin mathematical modeling. This is a quick introduction to the technique using an interactive spreadsheet that gives students ... More: lessons, discussions, ratings, reviews,...
Portable Media Players	General (Algebra)+	Excel	Tool	[0]
Students investigate the costs and storage capabilities of portable media players (e.g.: iPods). More: lessons, discussions, ratings, reviews,...
Excel Statistics Lab Manual	General (Probability & Statistics)	Excel	Tool	[0]
Excel Statistics Lab Manual is a problem set with instructions written into column A of an Excel Spresdsheet. Descriptive statistics problems are followed by probability problems which gi... More: lessons, discussions, ratings, reviews,...
Fun and Sun Rent-A-Car Spreads...	Graphing (Algebra)+	Spreadsheet	Tool	[0]
The Green family is planning a one-week vacation in Florida and needs to rent a car while there. They must decide which of four rental plans to choose. Students will enter data into a spreadsheet and ... More: lessons, discussions, ratings, reviews,...
Interpolation and Extrapolatio...	Is It Linear? (Algebra)+	Excel	Tool	[1]
Interpolation and extrapolation are two concepts in mathematical modeling that are very important for making predictions, an important science process, especially as students begin exploring linear mo... More: lessons, discussions, ratings, reviews,...
MedMed	Least-Squares Regression (Probability & Statistics)+	Excel	Tool	[0]
Excel file to accompany an activity in which students construct a median-median line for a data set with an outlier. Includes data and color-coded boxes for formula and discussion entry. More: lessons, discussions, ratings, reviews,...
Investigating the Height of a ...	Length/height (Math 6)+	Excel	Tool	[0]
How do you get started at mathematical modeling? Here is an easy, quick, and engaging activity and a “just add data” interactive Excel spreadsheet to accomplish that first modeling task. The task ... More: lessons, discussions, ratings, reviews,...
Interactive Story Problem: The...	Linear Systems (Algebra)+	Excel	Tool	[1]
Students explore some of the costs associated with smoking cigarettes. Note the User's Guide link (MS Word file download) provides additional notes for the instructor. More: lessons, discussions, ratings, reviews,...
Interactive Multiplication Gri...	Multiplication (Math 3)+	Excel	Tool	[0]
An interactive multiplication grid designed for students who are having difficulty learning their times tables. More: lessons, discussions, ratings, reviews,...
Page 1 2 next »