Skip to main content
Skip header

Technical Calculations

Type of study Bachelor
Language of instruction English
Code 352-0340/02
Abbreviation TV
Course title Technical Calculations
Credits 4
Coordinating department Department of Control Systems and Instrumentation
Course coordinator Ing. Pavel Smutný, Ph.D.

Subject syllabus

• The application of algorithms and programming in engineering.
• Spreadsheet - Excel as a tool for solving mathematical and statistical tasks and decision-making.
• Tools and Options in Excel - Examples of practical use (processing and presentation of experimental data obtained by simulation or measurement).
• Processing and creating charts, practical use - obtaining results by differentiation and integration.
• Advanced features and processing data in a spreadsheet.
• Recording and using macros in MS Excel environment.
• Advanced recording and editing macros, basic commands, data types and expressions in Visual Basic.
• Debugging and if-then structures in Visual Basic
• Cycles in Visual Basic, methods of cell referencing.
• Subroutines, functions and arguments in the "Visual Basic for Application".
• Advanced arguments, objects and events.
• Linear regression analysis of the measured data.
• Approximation and numerical solution of algebraic equations.

E-learning

Literature

Excel help & learning [online]. Microsoft [cit. 2021-03-08]. Dostupné z: https://support.microsoft.com/en-us/excel

Advised literature

WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. [New York]: Pearson Education, [2019]. ISBN 978-1-5093-0588-9 .