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: | Pearson Michael M., Mundell Lee |
Keywords: | learning, location, decision theory, spreadsheets |
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.