Calculations in analytical chemistry using the MS EXCEL
| Type of study | Doctoral |
|---|---|
| Language of instruction | English |
| Code | 651-0971/02 |
| Abbreviation | VACH |
| Course title | Calculations in analytical chemistry using the MS EXCEL |
| Credits | 10 |
| Coordinating department | Department of Chemistry and Physico-Chemical Processes |
| Course coordinator | doc. Mgr. Lucie Bartoňová, Ph.D. |
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).
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).
E-learning
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).
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).
Advised literature
FREISER, H., Calculations in Analytical Chemistry – a Spreadsheet Approach. USA: CRC Press, 1992. ISBN-13: 978-0849347177 .
LIENGME, B.V. and D.J. ELLERT. A Guide to Microsoft Excel 2002 for Scientists and Engineers, 3rd edition. Oxford: Elsevier Butterworth – Heinemann Publisher, 2002. ISBN 978-0-12-374623-8 .
BOURG, D. M. Excel – Scientific and Engineering Cookbook. Sebastopol: O´Reilly Media, Inc., 2006. ISBN 0-596-00879-1 .
DE LEVIE, R. Aqueous Acid-Base Equilibria and Titrations. Oxford: Oxford University Press, 1999. ISBN: 978-0198506171 .
DE LEVIE, R. Advanced Excel for Scientific Data Analysis. Oxford: Oxford University Press, 2008. ISBN-13: 978-0195152753 .
LIENGME, B.V. and D.J. ELLERT. A Guide to Microsoft Excel 2002 for Scientists and Engineers, 3rd edition. Oxford: Elsevier Butterworth – Heinemann Publisher, 2002. ISBN 978-0-12-374623-8 .
BOURG, D. M. Excel – Scientific and Engineering Cookbook. Sebastopol: O´Reilly Media, Inc., 2006. ISBN 0-596-00879-1 .
DE LEVIE, R. Aqueous Acid-Base Equilibria and Titrations. Oxford: Oxford University Press, 1999. ISBN: 978-0198506171 .
DE LEVIE, R. Advanced Excel for Scientific Data Analysis. Oxford: Oxford University Press, 2008. ISBN-13: 978-0195152753 .