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
Terminated in academic year 2020/2021
Calculations in analytical chemistry using the MS EXCEL
| Type of study | Doctoral |
|---|---|
| Language of instruction | English |
| Code | 617-1904/02 |
| Abbreviation | VACH |
| Course title | Calculations in analytical chemistry using the MS EXCEL |
| Credits | 10 |
| Coordinating department | Department of Chemistry |
| Course coordinator | doc. Mgr. Lucie Bartoňová, Ph.D. |
Subject syllabus
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.
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.
Advised 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.
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.