Enlisting excel—again

School of Computing and Mathematical Sciences, University of Brighton, Moulsecoomb, Brighton, UK
Email: K.Parramore{at}brighton.ac.uk
Submitted November 2008; accepted January 2009
In Volume 26, Number 2, we reported on a group case study run for level 3 mathematics students at the University of Brighton. At the core of the study was a quadratic assignment problem, and we reported on attempts by students to use Excel to solve the problem, and on the attendant difficulties. We provided an elegant solution. In this article, we report on another interesting case study, this time developed for level 2 mathematics students. Again Excel is used to achieve a solution. We report on our efforts—and on how student answers led to improvements.
Keith Parramore is principal lecturer in Mathematics at the University of Brighton. His interests are the mathematics of finance, optimization, and decision mathematics. He is a chief examiner for decision mathematics at A level.