Innovative Teaching with Spreadsheets

SE06.1 Innovative Nonlinear Programming Models Cliff T. Ragsdale --- VA Polytech. Inst. & State Univ., Dept. of MS & Info., Blacksburg, VA 24061-0235, (cragsdal@mail.vt.edu)

Spreadsheet solvers make it possible to go beyond the linear¨ boundaries of the past and cover new and interesting NLP problems in¨ introductory OR/MS courses. This presentation will introduce several¨ innovative examples for problems in logistics, finance, project¨ selection and DA.

SE06.2 Toward a Collection of Excel Add-ins for OR/IE Paul A. Jensen --- Univ. of TX, Dept. of Mech. Eng., Austin, TX 78712 , (pjensen@mail.utexas.edu)

We describe add-in collections programmed by students during a¨ graduate course. As well as reviewing the content of the new¨ add-ins, we will discuss issues associated with teaching the course.

SE06.3 Deiteration: From Iterative to Instantaneous Sam Savage --- Stanford Univ., Dept. of EES & OR, 417 Terman Eng. Ctr., Stanford, CA 94305-4023, (savage@leland.stanford.edu)

The incredible speed of today's computers allows procedures once¨ considered iterative to be performed instaneously. This can impact¨ rich new insights into non-intuitive phenomena. Some examples¨ include the Blitzogram (an instantaneous histogram) and the¨ Stochastitron (an animated instantaneous convolution).