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

Files