EUSES Spreadsheet Problems for Teachers

Estimation

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

Hurricane Katrina

Mathematics Concepts

  • Cost analysis based on unit price and quanity

Spreadsheet Skills

  • Formula entry
  • Absolute and relative referencing
  • The "SUM and "IF" functions
  • "

Files

Calculator Sale

Mathematics Concepts

  • Total cost
  • Comparing
  • Cost Estimation

Spreadsheet Skills

  • Sum
  • "IF" function

Files

El Nino/La Nina

Mathematics Concepts

  • Round
  • Random

Spreadsheet Skills

  • Percent
  • Random between
  • Round
  • Absolute cell reference

Files

The Programmers' Problem

Mathematics Concepts

  • Algebraic operations
  • Percentage

Spreadsheet Skills

  • The "SUM" function
  • Absolute and relative referencing

Files