EUSES Spreadsheet Problems for Teachers
Algebra
These problems were created as part of the EUSES research studies about teaching students to use spreadsheets. The full archive of problems can be found at the EUSES Spreadsheet Education Problems page.
They have proven useful and helpful to students so we post them here for free use by teachers. Primarily these problems are of the level of middle to high school students and feature math concepts taught through the use of spreadsheets.
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
Cellphone
Mathematics Concepts
- Linear Functions
- Slope, Y-intercept
Spreadsheet Skills
- Cell referencing
- Dynamic change
- Absolute, relative referencing
Files
DVD Cable
Mathematics Concepts
- Line graph
- Cost estimation
Spreadsheet Skills
- Line graph
- "IF" function
Files
A Dynamic Function Machine
Mathematics Concepts
- Solution of a system of linear functions
Spreadsheet Skills
- Absolute and relative referencing
- Formula entry and algebraic operations
- Graphing
Files
Linear Function
Mathematics Concepts
- Linear function, slope
Spreadsheet Skills
- Graph
Files
The Airport Problem
Mathematics Concepts
- Solution of a system of linear functions
Spreadsheet Skills
- Absolute referencing and formula entry
- Graphing
Files
Harry's Magic Wands and Spreadsheets
Mathematics Concepts
- Pattern recognition and generalizing
Spreadsheet Skills
- Relative referencing
- Basic formula entry
Files
Catching up with Hogwarts Express
Mathematics Concepts
- Cumulative travel time
- Relationship between constant velocity and distance traveled
Spreadsheet Skills
- Absolute and relative referencing
- Basic formula entry
Files
Vampires Problem
Mathematics Concepts
- Modeling couter-positive proof
Spreadsheet Skills
- Relative referencing
- Basic formula entry