Some Unusual Applications of the "Error-bar" Feature in Excel Spreadsheets
Kieran F. Lim, 
School of Biological and Chemical Sciences, Deakin University, Geelong Victoria 3217 Australia
WWW: http://www.deakin.edu.au/~lim
This paper demonstrates how the "error-bar" feature can be used to extend the utility of "worldware" spreadsheet packages in producing high-quality graphs for university teaching and learning, and for research. In order to further utilize the advantages of spreadsheets in university education, this paper seeks to overcome some of the earlier reservations about spreadsheet applications' lack of scientific plotting capabilities. Specific examples of educational material in the areas of enzyme kinetics, vibrational spectroscopy, vibronic spectroscopy, and mass spectrometry are discussed. It is argued that, where practical, university educators should use "worldware" packages to prepare teaching aids, since they would be better placed to prepare their students for future employment. The use of software features for purposes, which were not envisioned by the programmers, has additional educational benefits in fostering flexibility and innovation. The usage of the "error-bar" feature, discussed here, can also be applied to other graphing packages.
| Viewing Requirements |
| The spreadsheets require Microsoft Excel. If your browser is not set up to recognize Excel as a helper application, save the file to your disk and then open the saved file in Excel.
The spreadsheets correspond to Figures 1, 3, 5, 6, and 7 of the article and are meant to be viewed while reading the article.
This article requires Adobe Acrobat.
|
| Keywords |
Computer-aided instruction, Data analysis, Spreadsheet, Teaching/Learning Aids |
| Abstract |
Lim, K. F. J. Chem. Educ. 2002, 79, 135. |
| History |
Published: November 2001 |
|