Use of Spreadsheet Simulations in University Chemistry Education.

Students who are strong in logical-mathematical intelligence have a natural advantage in learning and understanding chemistry, which is full of abstractions that are remote from the material world. Simulations provide more-inclusive learning activities for students who are weak in logical-mathematical intelligence. A second advantage of using simulations is that they are not limited by (for example) the quantised energies, integral masses and discrete expectation values of real atoms and molecules. Numerical experiments can be used to investigate the effect of continuously varying atomic mass, bond distance or any other property, from one value to another. Finally, students are more familiar with spreadsheets than more advanced mathematical packages such as MathCAD, MAPLE, Mathematica and other symbolic algebra software. Use of these advanced packages presents additional learning hurdles for students and should be used only for advanced classes. Furthermore, spreadsheets are capable of a level of sophistication that is greater than commonly expected. This can be achieved without the use of MACROs. Examples from the author’s teaching are used to discuss the advantages of spreadsheet simulations for learning chemistry.

[1]  Hans Kuhn,et al.  A Quantum‐Mechanical Theory of Light Absorption of Organic Dyes and Similar Compounds , 1949 .

[2]  M. Hénon,et al.  The applicability of the third integral of motion: Some numerical experiments , 1964 .

[3]  H. Gardner,et al.  Frames of Mind: The Theory of Multiple Intelligences , 1983 .

[4]  Ron Day.  The Computer Simulation in the Education Process or Computer Simulations go to School , 1986 .

[5]  J. Haile.  Molecular Dynamics Simulation , 1992 .

[6]  R. Felder.  Reaching the Second Tier--Learning and Teaching Styles in College Science Education. , 1993 .

[7]  Kieran F. Lim.  Quasiclassical trajectory study of collisional energy transfer in toluene systems. I. Argon bath gas: Energy dependence and isotope effects , 1994 .

[8]  Kieran F. Lim.  Quasiclassical trajectory study of collisional energy transfer in toluene systems. II. Helium bath gas: energy and temperature dependences, and angular momentum transfer , 1994 .

[9]  Jeffery E. Olson,et al.  A Meta-Analytic Validation of the Dunn and Dunn Model of Learning-Style Preferences , 1995 .

[10]  Stephen C. Ehrmann,et al.  Asking the Right Questions: What Does Research Tell Us About Technology and Higher Learning? , 1995 .

[11]  Kieran F. Lim,et al.  IT skills of university undergraduate students enrolled in a first year unit , 2000 .

[12]  Kieran F. Lim.  Some unusual applications of the "Error-Bar" feature in excel spreadsheets , 2001 .

[13]  Peter Atkins,et al.  Physical Chemistry (7th ed.) , 2002 .

[14]  Peter Galbraith,et al.  Convergence or divergence? Students, maple, and mathematics learning , 2002 .

[15]  Kieran F. Lim,et al.  Computer and IT skills of Australian first-year university undergraduate students , 2002 .

[16]  Kieran F. Lim.  USING SPREADSHEETS IN CHEMICAL EDUCATION TO AVOID SYMBOLIC MATHEMATICS , 2003 .

[17]  Kieran F Lim.  Using spreadsheets to teach quantum theory , 2003 .

[18]  Kieran F. Lim.  The ability of beginning university chemistry students to use ICT (information and communication technology) in their learning in 2002 , 2003 .

[19]  Kieran Lim.  Using spreadsheets to teach quantum theory to students with weak calculus backgrounds , 2003 .

[20]  Tadayosi Yoshimura,et al.  Development and Testing of Chemistry Education Resources for a Mobile Phone , 2004 .

[21]  William F. Coleman,et al.  The effect of anharmonicity on diatomic vibration: A spreadsheet simulation , 2005 .

[22]  P. Campbell.  How to Solve It: A New Aspect of Mathematical Method , 2005 .

[23]  Kieran F. Lim.  Bond Length Dependence on Quantum States as Shown by Spectroscopy , 2005 .

[24]  T. Zielinski,et al.  Quantum States of Atoms and Molecules , 2005 .

[25]  William F. Coleman,et al.  Interactive Spreadsheets in JCE WebWare , 2005 .

[26]  Theresa Julia Zielinski.  Symbolic Mathematics Documents Large and Small , 2005 .

[27]  Gregory L. Waddoups,et al.  The "Virtual ChemLab" Project: A Realistic and Sophisticated Simulation of Organic Synthesis and Organic Qualitative Analysis , 2005 .

[28]  Norio Yoshimura.  Simulation of Acid-Base Titration Curve by Using Table-Function in Microsoft Excel , 2006 .

[29]  John E Baker,et al.  Spreadsheets in Education-The First 25 Years , 2007 .