JCE Online Journal of Chemical EducationDivision of Chemical Education, American Chemical SocietyAmerican Chemical Society
 | Subscriptions  | Software Orders  | Support  | Contributors  | Advertisers  | 

JCE Print

JCE Software

Only@JCE Online

About JCE



 Home > Only@JCE Online > Features > JCE WebWare > Collections > Reviewed >
From the Peer-Reviewed Collection
Some Unusual Applications of the "Error-bar" Feature in Excel Spreadsheets

Kieran F. Lim, My Chinese name
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.

* Article Adobe Acrobat
* Run/download:
Figure 1
Figure 3
Figure 5
Figure 6
Figure 7
Microsoft Excel
* Comment on this application  

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
 Home > Only@JCE Online > Features > JCE WebWare > Collections > Reviewed > Some Unusual Applications of the "Error-bar" Feature in Excel Spreadsheets


JCE WebWare

Submissions Wanted
Have you developed a teaching tool that is readily used over the Internet? Please submit it to JCE WebWare.

NSDL Collection
JCE WebWare is a collection of the National Science Digital Library.

Other Features
Only@JCE Online