Skip to main content
Skip header

Calculations in analytical chemistry using the MS EXCEL

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).

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).

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 .


Language of instruction čeština, angličtina
Code 651-0971
Abbreviation VACH
Course title Calculations in analytical chemistry using the MS EXCEL
Coordinating department Department of Chemistry and Physico-Chemical Processes
Course coordinator doc. Mgr. Lucie Bartoňová, Ph.D.