Date of Award
College of Science, Engineering, and Technology (COSET)
MS in Chemistry
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.
Gedeon, Yokabet, "Some calculations in Analytical Chemistry Using the Spreadsheet" (1997). Theses (Pre-2016). 14.