Prev. Article Next Article Table of Contents

Tech Report

Some Unusual Applications of the "Error-bar" Feature in Excel Spreadsheets

Citing Articles

Kieran F. Lim

School of Biological and Chemical Sciences, Deakin University, Geelong, Victoria 3217, Australia

J. Chem. Educ., 2002, 79 (1), p 135

DOI: 10.1021/ed079p135.4

Publication Date (Web): January 1, 2002

Abstract

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.

Keywords (Audience):

First-Year Undergraduate / General

Keywords (Feature):

JCE WebWare

Keywords (Pedagogy):

Computer-Based Learning

Keywords (Subject):

Chemometrics

View: Hi-Res PDF | PDF w/ Links

Citing Articles

Citation data is made available by participants in CrossRef's Cited-by Linking service. For a more comprehensive list of citations to this article, users are encouraged to perform a search in SciFinder.

This article has been cited by 1 ACS Journal articles (1 most recent appear below).

Bond Length Dependence on Quantum States as Shown by Spectroscopy
Kieran F. Lim
Journal of Chemical Education2005 82 (1), 145
- Bond Length Dependence on Quantum States as Shown by Spectroscopy
  Kieran F. Lim
  Journal of Chemical Education2005 82 (1), 145
  Undergraduate students often have the misconception that molecules have fixed, unchanging bond lengths. This article discusses how linear-molecule rotational band spacings in infrared spectroscopy can be used as a qualitative, visual demonstration of the ...
  Abstract | Hi-Res PDF | PDF w/ Links