USING SPREADSHEETS IN CHEMICAL EDUCATION TO AVOID SYMBOLIC MATHEMATICS

Traditionally, quantum theory has traditionally relied heavily on the use of  mathematics. However, there is a significant cohort of students who are  weak in mathematics, for example, students who are majoring in   biochemistry, biological sciences, etc. This paper reports on the use of  spreadsheets to generate approximate numerical solutions and visual  (graphical) descriptions as a method of avoiding or minimizing symbolic  manipulations, mathematical derivations and numerical computation. A  specific example from quantum theory is provided. Some aspects of  educational pedagogy of spreadsheet usage are discussed.

[1]  William H. Press,et al.  Numerical Recipes in Fortran 77: The Art of Scientific Computing 2nd Editionn - Volume 1 of Fortran Numerical Recipes , 1992 .

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

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

[4]  Edward F. Redish,et al.  Student programming in the introductory physics course: M.U.P.P.E.T. , 1993 .

[5]  Robert J. Hinde,et al.  Quantum Chemistry, 5th Edition (by Ira N. Levine) , 2000 .

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

[7]  Judith Body Wood.  Utilizing the spreadsheet charting capabilities of Microsoft Works in the mathematics classroom , 1990 .

[8]  Dermot Diamond,et al.  Spreadsheet Applications in Chemistry Using Microsoft Excel , 1997 .

[9]  Danny G. Miles,et al.  A survey of computer use in undergraduate physical chemistry , 2002 .

[10]  Robert de Levie,et al.  How to Use Excel® in Analytical Chemistry and in General Scientific Data Analysis: Numerical simulation of chemical kinetics , 2001 .

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

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

[13]  E. Bono.  Lateral Thinking: A Textbook of Creativity , 1970 .

[14]  Michael Kaess,et al.  Visual Basic and Excel in Chemical Modeling , 1998 .

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

[16]  Jerry Willis,et al.  Educational Computing: Learning with Tomorrow's Technologies , 1992 .