617-1904/02 – Calculations in analytical chemistry using the MS EXCEL (VACH)

Gurantor departmentDepartment of ChemistryCredits10
Subject guarantordoc. Mgr. Lucie Bartoňová, Ph.D.Subject version guarantordoc. Mgr. Lucie Bartoňová, Ph.D.
Study levelpostgraduate
Study languageEnglish
Year of introduction2014/2015Year of cancellation
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
Combined 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

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

Další požadavky na studenta

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

Full-time form (validity from: 2014/2015 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Examination Examination  
Mandatory attendence parzicipation:

Show history
Combined form (validity from: 2014/2015 Winter 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.FormStudy language Tut. centreYearWSType of duty
2018/2019 (P3909) Process engineering (3909V003) Process engineering P Czech Ostrava Choice-compulsory study plan
2018/2019 (P3909) Process engineering (3909V003) Process engineering K Czech Ostrava Choice-compulsory study plan
2017/2018 (P3909) Process engineering (3909V003) Process engineering P Czech Ostrava Choice-compulsory study plan
2017/2018 (P3909) Process engineering (3909V003) Process engineering K Czech Ostrava Choice-compulsory study plan
2016/2017 (P3909) Process engineering (3909V003) Process engineering P Czech Ostrava Choice-compulsory study plan
2016/2017 (P3909) Process engineering (3909V003) Process engineering K Czech Ostrava Choice-compulsory study plan
2015/2016 (P3909) Process engineering P Czech Ostrava Choice-compulsory study plan
2015/2016 (P3909) Process engineering (3909V003) Process engineering P Czech Ostrava Choice-compulsory study plan
2015/2016 (P3909) Process engineering K Czech Ostrava Choice-compulsory study plan
2015/2016 (P3909) Process engineering (3909V003) Process engineering K Czech Ostrava Choice-compulsory study plan
2014/2015 (P3909) Process engineering (3909V003) Process engineering P Czech Ostrava Choice-compulsory study plan
2014/2015 (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