Spreadsheet modeling of spatial problems for the classroom

Spreadsheet modeling of spatial problems for the classroom

0.00 Avg rating0 Votes
Article ID: iaor20042392
Country: United States
Volume: 1
Issue: 1
Start Page Number: 133
End Page Number: 139
Publication Date: Mar 2003
Journal: DSJIE
Authors: ,
Keywords: learning, location, decision theory, spreadsheets
Abstract:

A spatial problem is one that requires a decision to be made within a spatial area. Where do we put our warehouses? Where do we locate our stores within a trade area? How do we arrange departments in the retail store, or items on the retail shelf? These are problems that are often solved by modeling, and spreadsheet models are but one of the many types of models that can be used. The use of the LOOKUP command greatly increases the potential of the spreadsheet to solve spatial problems, and especially to solve spatial problems in a classroom setting. The command changes spreadsheet modeling in the classroom from simply a number-crunching exercise by students to a visual interaction between students and the spatial problem.

Reviews

Required fields are marked *. Your email address will not be published.