In this article we describe how to employ an inexpensive analog-to-digital converter
and a user interface to Microsoft Excel to make a useful computerized spectrophotometer.
Readily available types of data loggers, Vernier LabPro and digital multimeters
with an RS-232 interface, were utilized. The proposed design does not compromise
the quality of the measurements. The conversion of the data to the Microsoft
Excel format makes it a convenient tool for a wide range of data processing
applications. The software can operate in Windows 9x/NT/2000/XP environments
that are familiar to most chemistry students. The infrared and UV–vis
instruments were used for various laboratory experiments in instrumental analytical
chemistry and in organic chemistry laboratories.
Supplement
Several examples of code for digital multimeters and for LabPro are available.
Our Secondary School editors work hard to distill all the JCE materials to produce a fraction of particular interest to high school teachers. We call it CLIC.
In recent years we have worked hard to better match our advertisers with our readers. When shopping for chemistry education materials, visit our advertisers' WWW sites first.
Take JCE along on your outreach missions. Copies of the Journal, guest access to JCE Online, our publications catalog, and more are available for your participants.