NotesFAQContact Us
Collection
Advanced
Search Tips
Back to results
ERIC Number: EJ1444511
Record Type: Journal
Publication Date: 2024-Jan
Pages: 9
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-0021-9584
EISSN: EISSN-1938-1328
Use of Uncertainty Calculation Software as a Didactic Tool to Improve the Knowledge of Chemistry Students in Analytical Method Validation
Maria Cerrato-Alvarez; Samuel Frutos-Puerto; Eduardo Pinilla-Gil
Journal of Chemical Education, v101 n1 p104-112 2024
Calculating analytical uncertainties as a part of method validation is a relevant aspect of field and laboratory practices in instrumental analytical chemistry subjects, which usually require complex algorithms. This work describes the development and didactic use of an automatic and straightforward informatics tool, implemented in an Excel macro, for calculating and interpreting the uncertainty of an analytical method against a reference method on field measurements. The software was initially developed for field testing of low-cost air quality monitoring analytical methods against reference methods, and the present work shows its adaptation to a didactic environment. The uncertainty calculation software was implemented through an Excel macro based on Visual Basic as a graphical user interface. It finds a best-fit line that describes the relation between concentrations determined by the candidate and reference methods. The software generates the analytical validation results (slope and intercept with their respective confidence limits, and expanded uncertainty of a concentration determined by the candidate method), hiding the intermediate functions and calculations. The Excel interface eases uncertainty calculations for undergraduate students, although the background mathematics can be quickly unveiled to students for didactic purposes. This tool has been applied to a laboratory exercise focused on validating experimental results obtained in the measurement of ozone levels in ambient air by passive sampling and spectrophotometric detection. The uncertainty calculation software has proved valuable by providing the student a resource to check the analytical quality of the data generated in the laboratory, while assimilating the fundamentals behind the calculations.
Division of Chemical Education, Inc. and ACS Publications Division of the American Chemical Society. 1155 Sixteenth Street NW, Washington, DC 20036. Tel: 800-227-5558; Tel: 202-872-4600; e-mail: eic@jce.acs.org; Web site: http://pubs.acs.org/jchemeduc
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education; Postsecondary Education
Audience: N/A
Language: N/A
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A