EUSES Spreadsheet Problems for Teachers

Introduction to the Problems

These problems were created as part of the EUSES research studies about teaching students to use spreadsheets. They have proven very useful and helpful to students so we post them here for free use among teachers. Primarily these problems are of the level of middle to high school students and feature math concepts taught through the use of spreadsheets. The files used are available, you will need Microsoft Word and Excel.

Please feel free to send us your comments: For general comments about the EUSES Consortium or the web page eusesconsortium@eecs.oregonstate.edu and for comments about the problems niessm@onid.orst.edu.

Scaffolding of Problems

The list of problems below is a scaffolded enumeration of problems. We recommend that you teach with them in the order listed.

# Problem Math Concept Spreadsheet Skills Files
1 M&M Activity Average and percentage The "ROUND", "AVERAGE", and "SUM" functions. Graphing and labeling
2 Target Math Simple algebraic operations Relative referencing and formula entry
3 Multiplication Chart Multiplication Absolute cell reference and auto Copy
4 Soft Drink Volume and Surface area. Graphing Percent, dollar, auto cell copy, and graphing

5 M & M Probability, mean, median, mode, and percents Cell, mean, median, mode, and percents
6 Maggie Mystery Pie chart and probability Pie chart and percent
7 Climate The concept of "range", graphical analysis of data "MAX" and "MIN" functions, and basic formula entry, graphing
8 Hand Dominance Pattern recognition through analyzing graphs Graphing
9 Hermione Shopping Estimating and basic algebraic operations Relative referencing and basic general formula entry
10 Hogwarts Expansion Basic algebraic operations Relative and absolute referencing, "IF" statements
11 Fencing Quadratic equation, maximum area, and area XY scatter plot and auto copy
12 Animals Least fencing Graphing, minimum, absolute cell reference, and auto copy
13 Hurricane Katrina Cost analysis based on unit price and quanity Formula entry. absolute and relative referencing. The "SUM" and "IF" functions
14 Pay Plan Addition and total Sum
15 Cell Phone Linear function, slope, and Y-intercept Cell reference, dynamic change, absolute and relative cell reference
16 Calculator Sale Total cost and comparing Sum and if statement
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
19 Vacation Plan Distance = velocity * time and total cost Cell reference, sum, dynamic
20 Number Trick Operation Cell reference and = sign
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
22 Marbles Graphical relationship between mass and volume data for a set of marbles Relative referencing
23 A Dynamic Function Machine Solution of a system of linear functions Absolute and relative referencing, formula entry, algebraic operations, and graphing
24 Linear function Linear function and slope Graphing
25 The Airport Problem Solution of a system of linear functions Relative referencing and basic formula entry