352-0340/02 – Technical Calculations (TV)
| Gurantor department | Department of Control Systems and Instrumentation | Credits | 4 |
| Subject guarantor | doc. Ing. David Fojtík, Ph.D. | Subject version guarantor | Ing. Pavel Smutný, Ph.D. |
| Study level | undergraduate or graduate | Requirement | Compulsory |
| Year | 1 | Semester | winter |
| | Study language | English |
| Year of introduction | 2015/2016 | Year of cancellation | |
| Intended for the faculties | FS | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Learning oucome in the subject Technical Calculations is to get through the creation and description of algorithms for the typical technical calculations, implementation in the environment of the spreadsheet, to get through the realization of basic programs for technical calculation realization, like aggregation, sequencies, equation root, extremes, numerical integration and derivation.
Teaching methods
Lectures
Tutorials
Experimental work in labs
Summary
Learning oucome in the subject Technical Calculations is to get through the creation and description of algorithms for the typical technical calculations, implementation in the environment of the spreadsheet, to get through the realization of basic programs for technical calculation realization, like aggregation, sequencies, equation root, extremes, numerical integration and derivation.
Compulsory literature:
Excel help & learning [online]. Microsoft [cit. 2021-03-08]. Dostupné z: https://support.microsoft.com/en-us/excel
Recommended literature:
Additional study materials
Way of continuous check of knowledge in the course of semester
Students have to pass tests and fullfil tasks.
LMS
E-learning
http://lms.vsb.cz
Other requirements
Students have to pass tests and fullfil tasks.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
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.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.