# 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