617-1904/02 – 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 | English |
| Year of introduction | 2014/2015 | Year of cancellation | 2020/2021 |
| Intended for the faculties | FMT | Intended for study types | Doctoral |
Subject aims expressed by acquired skills and competences
The aim of the course is to provide theoretical knowledge and practical experience in performing complex calculations and simulations in analytical chemistry using the MS Excel.
Teaching methods
Lectures
Seminars
Individual consultations
Tutorials
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. Numerical Methods and MS Excel in Analytical Chemistry Calculations, VŠB-TU Ostrava, 2012.
DE LEVIE, R. How to Use Excel in Analytical Chemistry and General Scientific Data Analysis. Great Britain: Cambridge University Press, 2001.
BARTOŇOVÁ, L. Výpočty rovnovážných stavů v analytické chemii. Studijní opora, VŠB-TU Ostrava, 2009.
KOTOUČEK, M., SKOPALOVÁ, J. Příklady z analytické chemie. 4. doplněné vydání. Olomouc: Univerzita Palackého, 1997.
FERNANDO, Q., RYAN, M. D. Calculations in Analytical Chemistry. New York, 1982.
Recommended literature:
BERNARD, V., LIENGME, A. Guide to Microsoft Excel 2002 for Scientists and Engineers. 3rd edition. Great Britain: Elsevier Butterworth – Heinemann Publisher, 2002.
BOURG, D. M. Excel – Scientific and Engineering Cookbook. USA: O´Reilly Media, Inc., 2006.
DE LEVIE, R. Advanced Excel for Scientific Data Analysis. Great Britain: Oxford University Press, 2008.
FREISER, H., Calculations in Analytical Chemistry – a Spreadsheet Approach. USA: CRC Press, 1992.
DE LEVIE, R. Aqueous Acid-Base Equilibria and Titrations. Great Britain: Oxford University Press, 1999.
FOGL, J., VOLKA, K. Analytické tabulky. Praha: VŠCHT Praha, FCHI, 1995.
Way of continuous check of knowledge in the course of semester
E-learning
Other requirements
They will be specified according to the thesis topic.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Use MS Excel in analytical chemistry will focus inter alia on the following areas - the statistical processing of data to calculate more complex examples from the field of chemical equilibria, the calculation of titration curves and evaluation of various mathematical methods for performing complex calculations in instrumental analysis and in particular on formation simulations (including graphical representation) of various influences on the course of reaction, chemical equilibrium, the acid-base behavior of substances on the reaction kinetics, the final shape of the titration curve, distribution diagrams and UV-VIS spectra, the error of calculation or measurement, etc
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.