Document Type


Date of Award

Spring 5-15-1997


College of Science, Engineering, and Technology (COSET)

Degree Name

MS in Chemistry

First Advisor

Professor Curtis W. McDonald


Microsoft Excel, an integrated spreadsheet, database and graphics software package, was used to solve some problems in analytical chemistry. The problems focus on the princ.iples of chemical equilibrium of complex formation, volumetric analysis, activity, solubility of complex systems, fractional composition of polyprotic acid-base systems, acid-base titrations, complexometric titrations and redox titrations. The worksheets and charts were developed in Microsoft Excel on a Macintosh Performa computer. This software was sufficiently logical, well-documented, and easy for student use. It allowed students to do some novel and interesting assignments that would have been impossible without the computer. In addition, it introduces students to the power and utility of microcomputers with present-day software. A few problems were encountered in implementing spreadsheet use, but they were outweighed by the benefits incurred. Spreadsheet Analytical Chemistry is worth considering for further applications.