Course unit code:
Course unit title:
Algorithms and Tools for Chemical Engineering Calculations I
Mode of completion and Number of ECTS credits:
Class req (3 credits)
Course supervisor:
doc. Ing. Ján Stopka, CSc.
Name of lecturer(s):
M. Kalúz, J. Oravec (2016/2017 – Winter)
M. Kalúz, J. Števek (2015/2016 – Winter)
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.
Prerequisites for registration:
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.
Planned learning activities and teaching methods:
seminar, active work with computer
Assesment methods and criteria:
classified credits
Language of instruction:
Slovak, English
Facebook / Youtube

Facebook / Youtube