# EUSES Spreadsheet Problems for Teachers

## Probabilities and Statistics

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

### M & M

#### Mathematics Concepts

- Pobability, mean, median, mode, percents

#### Spreadsheet Skills

- Cell mean, median, mode, percents

#### Files

### Maggie's Mystery

#### Mathematics Concepts

- Pie chart
- Probability

#### Spreadsheet Skills

- Pie chart
- Probability

#### Files

### Climate

#### Mathematics Concepts

- The concept of "range"
- Graphical analysis of data

#### Spreadsheet Skills

- "MAX" and "MIN" functions
- Basic formula entry
- Graphing

#### Files

### El Nino/La Nina

#### Mathematics Concepts

- Data analysis

#### Spreadsheet Skills

- The "MAX" and "MIN" functions

#### Files

- downloadable Excel files from the website for "Western Regional Climate Center"

### Old Faithful - That Trusty Old Geyser

#### Mathematics Concepts

- Mean, median, mode, min, max, and quartiles
- Data analysis

#### Spreadsheet Skills

- The "AVERAGE", "MEDIAN", "MODE", "MIN", "MAX", and "QUARTILES" functions