615-0904/02 – Calculations in analytical chemistry using the MS EXCEL (VACH)

Gurantor departmentDepartment of Analytic Chemistry ProcessesCredits10
Subject guarantordoc. Mgr. Lucie Bartoňová, Ph.D.Subject version guarantordoc. Mgr. Lucie Bartoňová, Ph.D.
Study levelpostgraduateRequirementChoice-compulsory
YearSemesterwinter + summer
Study languageEnglish
Year of introduction2013/2014Year of cancellation2013/2014
Intended for the facultiesFMTIntended for study typesDoctoral
Instruction secured by
LoginNameTuitorTeacher giving lectures
BAR57 doc. Mgr. Lucie Bartoňová, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Examination 0+0
Part-time Examination 0+0

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

Individual consultations


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:

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


Other requirements

There are no additional requirements for students.


Subject has no prerequisities.


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

Part-time form (validity from: 2013/2014 Winter semester, validity until: 2013/2014 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Examination Examination  
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2013/2014 (P3909) Process engineering (3909V003) Process engineering P Czech Ostrava Choice-compulsory study plan
2013/2014 (P3909) Process engineering (3909V003) Process engineering K Czech Ostrava Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner