Animated spreadsheets as a teaching resource on the freshman level

Computer animation can serve as a powerful teaching tool. Too often, however, interactive computer animation degenerates into a video game, with students blithely entering data and enjoying “gee-whiz” graphics while managing to ignore completely the underlying physics and math-the understanding of which is the actual intent of the animation! Such unfocused trial-and-error engagement can be largely avoided if the animation is introduced as a tool rather than as a “black box.” Spreadsheets lend themselves very well to this. One simple, easily-understood macro to “step” time is all that is required. Graphs based on formulas referencing this time immediately become animated if the student has entered and understood the spreadsheet formulas in the first place, the animation is a completely natural extension of a familiar tool. The visual impact is just as great as with more sophisticated animation but is a natural outgrowth of the underlying physics and math rather than being simply the output of a “black box”