Use of spreadsheet simulations in university chemistry education

Lim, Kieran 2006, Use of spreadsheet simulations in university chemistry education, Journal of computer chemistry, vol. 5, no. 3, pp. 139-146.

Attached Files
Name Description MIMEType Size Downloads

Title Use of spreadsheet simulations in university chemistry education
Author(s) Lim, Kieran
Journal name Journal of computer chemistry
Volume number 5
Issue number 3
Start page 139
End page 146
Publisher Society of Computer Chemistry, Japan
Place of publication Japan
Publication date 2006
ISSN 1347-1767
Keyword(s) spreadsheets
chemical education
Summary 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.
Language eng
Field of Research 030799 Theoretical and Computational Chemistry not elsewhere classified
130212 Science, Technology and Engineering Curriculum and Pedagogy
HERDC Research category C1 Refereed article in a scholarly journal
Copyright notice ©Copyright 2006 Society of Computer Chemistry, Japan. This paper was published in “Kieran Lim, J. Comput. Chem. Jpn., vol.5, no.3, 139-146, 2006. The Internet address of the above Journal is as follows:
Persistent URL

Connect to link resolver
Unless expressly stated otherwise, the copyright for items in DRO is owned by the author, with all rights reserved.

Version Filter Type
Access Statistics: 601 Abstract Views, 89 File Downloads  -  Detailed Statistics
Created: Mon, 07 Jul 2008, 09:05:03 EST

Every reasonable effort has been made to ensure that permission has been obtained for items included in DRO. If you believe that your rights have been infringed by this repository, please contact