Some unusual applications of the `Error-bar` feature in Excel spreadsheets

Lim, Kieran 2002, Some unusual applications of the `Error-bar` feature in Excel spreadsheets, Journal of chemical education, vol. 79, no. 1, pp. 135-135.

Attached Files
Name Description MIMEType Size Downloads

Title Some unusual applications of the `Error-bar` feature in Excel spreadsheets
Author(s) Lim, Kieran
Journal name Journal of chemical education
Volume number 79
Issue number 1
Start page 135
End page 135
Publisher Division of Chemical Education of the American Chemical Society
Place of publication Bellmawr, NJ
Publication date 2002
ISSN 0021-9584
Keyword(s) computer-aided instruction
data analysis
spreadsheet
teaching/learning aids
Summary 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. To further utilize the advantages of spreadsheets in university education, this paper seeks to overcome some of the earlier reservations about the lack of scientific plotting capabilities of spreadsheet applications. 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 these would better prepare their students for future employment. The use of software features for purposes that were not envisioned by the programmers has additional educational benefits in fostering flexibility and innovation. Other graphing packages can also use the "error-bar" feature in a manner similar to that described here for Excel.
Language eng
Field of Research 030699 Physical Chemistry not elsewhere classified
HERDC Research category C1 Refereed article in a scholarly journal
Persistent URL http://hdl.handle.net/10536/DRO/DU:30001695

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

Versions
Version Filter Type
Access Statistics: 506 Abstract Views, 0 File Downloads  -  Detailed Statistics
Created: Mon, 07 Jul 2008, 08:04:08 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 drosupport@deakin.edu.au.