|
Problem |
Math Concept |
Spreadsheet Skills |
Files |
| 1 |
M&M Activity |
Average and percentage |
The "ROUND", "AVERAGE", and "SUM" functions. Graphing and labeling |
M&M_Experiment.xls
M&M_activity.doc
Dynamic_M&Ms.xls |
| 2 |
Target Math |
Simple algebraic operations |
Relative referencing and formula entry |
4_Target.xls
4_Target.doc |
| 3 |
Multiplication Chart |
Multiplication |
Absolute cell reference and auto Copy |
multiplication_chart.xls
multiplication_chart.doc |
| 4 |
Soft Drink |
Volume and Surface area. Graphing |
Percent, dollar, auto cell copy, and graphing |
soft_drink.xls
soft_drink.doc |
| 5 |
M & M |
Probability, mean, median, mode, and percents |
Cell, mean, median, mode, and percents |
M&M_group5.xls
M&M_group5.doc |
| 6 |
Maggie Mystery |
Pie chart and probability |
Pie chart and percent |
2_Maggie_Mystery.xls
2_Maggie_Mystery.doc |
| 7 |
Climate |
The concept of "range", graphical analysis of data |
"MAX" and "MIN" functions, and basic formula entry, graphing |
Climate.xls
Climate.doc |
| 8 |
Hand Dominance |
Pattern recognition through analyzing graphs |
Graphing |
HandDominance.xls
HandDominance.doc |
| 9 |
Hermione Shopping |
Estimating and basic algebraic operations |
Relative referencing and basic general formula entry |
Hermione_shopping.xls
Hermione_Shopping.doc |
| 10 |
Hogwarts Expansion |
Basic algebraic operations |
Relative and absolute referencing, "IF" statements |
HogwartsExpansion.xls
HogwartsExpansion.doc |
| 11 |
Fencing |
Quadratic equation, maximum area, and area |
XY scatter plot and auto copy |
2_Fencing.xls
2_Fencing.doc |
| 12 |
Animals |
Least fencing |
Graphing, minimum, absolute cell reference, and auto copy |
4_animals.xls
4_animals.doc |
| 13 |
Hurricane Katrina |
Cost analysis based on unit price and quanity |
Formula entry. absolute and relative referencing. The "SUM" and "IF" functions |
Katrina.xls
Katrina.doc
Katrina.ppt
Katrina.mov |
| 14 |
Pay Plan |
Addition and total |
Sum |
pay_plan.xls
PayPlan.doc |
| 15 |
Cell Phone |
Linear function, slope, and Y-intercept |
Cell reference, dynamic change, absolute and relative cell reference |
6_cell.xls
6_cell.doc |
| 16 |
Calculator Sale |
Total cost and comparing |
Sum and if statement |
calculator_sale1.xls
calculator_worksheet1.doc |
| 17 |
DVD Cable |
Line graph and intersection of line |
If statement and line graph |
1_DVD_Cable.xls
1_DVD_Cable.doc |
| 18 |
Old Faithful - That Trusty Old Geyser |
Mean, median, mode, min, max, and quartiles. Data analysis |
The "Average", "Median", "Mode", "Min", "Max", and "Quartiles" functions |
OldFaithful_durations.xls
OldFaithful_Intervals.xls
OldFaithfulMystery.doc |
| 19 |
Vacation Plan |
Distance = velocity * time and total cost |
Cell reference, sum, dynamic |
travel_template.xls
need_travel.doc |
| 20 |
Number Trick |
Operationnn |
Cell reference and = sign |
3_Number_trick.xls
3_Number_trick.doc |
| 21 |
Any Pattern in Circular Objects |
Relationship between the circumference and the diameter of a circle |
Relative referencing, basic algebraic operations, graphing, and formula entry |
Circle.xls
Circle.doc |
| 22 |
Marbles |
Graphical relationship between mass and volume data for a set of marbles |
Relative referencing |
marbles.xls
marbles.doc |
| 23 |
A Dynamic Function Machine |
Solution of a system of linear functions |
Absolute and relative referencing, formula entry, algebraic operations, and graphing |
Dynamic_Function_Machine.xls
Dynamic_Function_Machine.doc |
| 24 |
Linear function |
Linear function and slope |
Graphing |
slope_interactive.xls
slope_interactive.doc |
| 25 |
The Airport Problem |
Solution of a system of linear functions |
Relative referencing and basic formula entry |
planes.xls
Airplane_Problem.doc |
About EUSES