Skip to main content
Skip header

Technical Calculations

Type of study Bachelor
Language of instruction Czech
Code 352-0340/01
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

1. The application of algorithms and programming in engineering.
2. Spreadsheet - Excel as a tool for solving mathematical and statistical tasks and decision-making.
3, Tools and Options in Excel - Examples of practical use (processing and presentation of experimental data obtained by simulation or measurement).
4. Processing and creating charts, practical use - obtaining results by differentiation and integration.
5. Data validation, matrix functions, pivot tables.
6. Advanced features and processing data in a spreadsheet.
7. Recording and using macros in MS Excel environment.
8. Advanced recording and editing macros, basic commands, data types and expressions in Visual Basic.
9. Debugging and if-then structures in Visual Basic
10. Cycles in Visual Basic, methods of cell referencing.
11. Subroutines, functions and arguments in the "Visual Basic for Application".
12. Advanced arguments, objects and events.
13. Linear regression analysis of the measured data.
14. 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 .