Illustrating dynamic chemical processes with Microsoft Excel

CHED 438

Thomas S. Kuntzleman, tkuntzle@arbor.edu, Department of Chemistry, Spring Arbor University, Spring Arbor, MI 49283
The use of Microsoft Excel in animating chemical processes provides an innovative and useful technique in chemical pedagogy. A number of recent publications outline procedures for displaying animations using macros and other features in Microsoft Excel (1, 2). These methods may be employed in generating animations that allow students to visualize dynamic chemical processes on either the macroscopic or submicroscopic scale. Students may easily observe and quantitatively analyze data collected during animations. When students analyze separate animations of the same chemical process on both the large and small scales, relationships between macroscopic and submicroscopic properties of matter are reinforced. Finally, advanced students can be taught to write programs and spreadsheets that animate time-dependent chemical behavior.

References:

1. Robert de Levie (2004) Advanced Excel for Scientific Data Analysis. 2. E. Joseph Billo (2001) Excel for Chemists: A Comprehensive Guide, 2nd edition.