Using Spreadsheet Software in a “Value-Added” Review of Infrared Spectroscopy in the Organic Chemistry Laboratory Course

TCE

The Chemical Educator

ISSN: 1430-4171 (electronic version)

Table of Contents

Abstract Volume 10 Issue 4 (2005) pp 308-309

Using Spreadsheet Software in a “Value-Added” Review of Infrared Spectroscopy in the Organic Chemistry Laboratory Course

Richard H. Wallace* and Suzanne R. Carpenter

Department of Chemistry and Physics, Armstrong Atlantic State University, Savannah, GA 31419, wallacri@mail.armstrong.edu
Received December 17, 2004. Accepted February 15, 2005.

Published online: 8 June 2005

Abstract. The expanding availability and popularity of spreadsheet software have resulted in its incorporation into academic and industrial laboratory practice. A novel application of spreadsheet software for the organic chemistry laboratory course is described. The primary objective of the exercise is to review the collection and interpretation of infrared (IR) spectra. The use of spreadsheet software to accomplish this task makes it a “value-added” exercise.

Key Words: Computers in Chemistry; organic chemistry; infrared spectroscopy; pedagogy; hands-on exercise; spreadsheet software

(*) Corresponding author. (E-mail: wallacri@mail.armstrong.edu)

Article in PDF format (119 KB) HTML format

Supporting Materials: