Course unit code:
Course unit title:
Algorithms and Tools for Chemical Engineering Calculations I
Mode of delivery, planned learning activities and teaching methods:
laboratory practice – 2 hours weekly (on-site method)
Credits allocated:
Recommended semester:
Chemical Engineering – bachelor (full-time, attendance method), 1. semester
Level of study:
Prerequisites for registration:
Assesment methods:
two control tests during semester, minimum to pass is 56% of points from control tests
Learning outcomes of the course unit:
The aim of subject is to prepare students creatively and effectively employ computing technique to solve and present engineering problems in MS Excel environment. Special attention is devoted to problems in the chemical engineering field. They are able to solve basic problems, manipulate with data, present data, to write research text. They are able to solve systems of linear and non linear equations.
Course contents:
Basics of writing research texts
Presentations documents in PowerPoint
Preparing tables and spreadsheets
Graph generating
Trend lines in measured data
Work with macros
Solving of systems linear and nonlinear equations
Solving of material and energy balances in Excel

Recommended or required reading:
  • ACKLEN, L. Microsoft Office 2000: Word. Excel. Powerpoint. Publisher. Outlook. Acces:Několikaky kroky k okamžitým výsledkům: Potřebn= dovednosti získate za pouhých 10 minut. Brno : SoftPress, 2000. 180 s. ISBN 80-902824-5-8.
  • Microsoft Office 2010: Podrobná uživatelská příručka. Brno : Computer Press, 2010. 491 s. ISBN 978-80-251-3222-7.
  • URBÁNEK, T. – ŠKÁRKA, J. Excel 97 pro vědce a inženýry. Praha : Computer Press, 1998. 434 s. ISBN 80-7226-099-5.
Language of instruction:
Slovak, English
Assessed students in total:

A 50.2 %

B 22.7 %

C 10.6 %

D 10.3 %

E 4.8 %

FX 1.4 %

Name of lecturer(s):
M. Kalúz, J. Oravec (2016/2017 – Winter)
M. Kalúz, J. Števek (2015/2016 – Winter)
Course supervisor:
doc. Ing. Ján Stopka, CSc.
Last modification:
19. 9. 2019

Department of Chemical and Biochemical Engineering

AIS: 2021/2022   2019/2020   2018/2019   2017/2018  

Facebook / Youtube

Facebook / Youtube