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:
none
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:
Basic:
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.