617-0971/01 – Calculations in analytical chemistry using the MS EXCEL (VACH)
| Gurantor department | Department of Chemistry | Credits | 10 |
| Subject guarantor | doc. Mgr. Lucie Bartoňová, Ph.D. | Subject version guarantor | doc. Mgr. Lucie Bartoňová, Ph.D. |
| Study level | postgraduate | Requirement | Choice-compulsory |
| Year | | Semester | winter + summer |
| | Study language | Czech |
| Year of introduction | 2019/2020 | Year of cancellation | 2022/2023 |
| Intended for the faculties | FMT | Intended for study types | Doctoral |
Subject aims expressed by acquired skills and competences
Students will gain theoretical knowledge and practical experience in complicated calculations and visualizations carried out on PC using MS Excel. The calculations will be focused to classical analytical chemisty as well as instrumental analysis.
The main advantage of this approach is practical application of easily available MS Excel (there is no need to use other specialized SW).
Teaching methods
Individual consultations
Summary
The main advantage is the practical application of readily available MS Excel without having to purchase other specialized programs (and including without knowledge of the Java programming language).
Compulsory literature:
BARTOŇOVÁ, L. Teaching of Analytical-Chemistry Calculations at University with the Aid of MS Excel. Ireland International Conference on Education IICE-2012, April 16-19, Dublin, p. 341-345, 2012, ISBN 978-1-90-8320-06-3.
DE LEVIE, R. How to Use Excel in Analytical Chemistry and General Scientific Data Analysis. Cambridge: Cambridge University Press, 2001. ISBN-13: 978-0521644846.
FERNANDO, Q. and M. D. RYAN. Calculations in Analytical Chemistry. New York, 1982.
BARTOŇOVÁ, L. Numerical Methods and MS Excel in Analytical Chemistry Calculations. Ostrava: VŠB-TU Ostrava, 2012 (PPT prezentace).
Recommended literature:
Additional study materials
Way of continuous check of knowledge in the course of semester
Spreadsheet calculations (MS Excel) and oral exam.
E-learning
Other requirements
Calculations / visualisations carried out on PC (MS Excel) and their presentation within oral exam.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
The subject Calculations in analytical chemistry using MS Excel is focused on complicated calculations in the field of classical and instrumental analytical chemistry.
Particular attention is paid to:
Calculation of chemical equilibrium and equilibrium concentrations of given species.
Construction of distribution diagrams for individual species in the solution (in dependence on pH, amount of added ligand etc.)
Calculations and construction of titration curves and their evaluation using various mathematic methods (including selection of the most suitable indicator).
More complex calculations in the field of instrumental analysis (e.g., peak interferences). Utilization of MS Excel in statistical evaluation of measured data.
MS Excel will be used with particular attention drawn to simulations of various effects on equilibrium concentrations, acid-base behaviour, reaction kinetics, titration curves, distribution diagrams etc. (including graphical illustration, which allows to inspect the studied effects visually).
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction