# 352-0340/01 – Technical Calculations (TV)

 Gurantor department Department of Control Systems and Instrumentation Credits 4 Subject guarantor 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 Czech Year of introduction 2010/2011 Year of cancellation Intended for the faculties FS Intended for study types Bachelor
Instruction secured by
BAB75 doc. Ing. Marek Babiuch, Ph.D.
BAT0034 Ing. Yasin Batiha
FOJ74 Ing. David Fojtík, Ph.D.
GEB050 Ing. Jan Gebauer, Ph.D.
PAV0201 Ing. Václav Pavelka
PUD0012 Ing. Tomáš Puda
SIK0082 Ing. Jan Sikora
SMU78 Ing. Pavel Smutný, Ph.D.
STR0284 Ing. Radek Štramberský
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 2+2
Part-time Graded credit 12+4

### 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:

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

### Way of continuous check of knowledge in the course of semester

Students have to pass tests and fullfil tasks.

### E-learning

https://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:

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.

### Conditions for subject completion

Part-time form (validity from: 2018/2019 Winter semester, validity until: 2019/2020 Winter semester)
Task nameType of taskMax. number of points
Min. number of points
Graded credit Graded credit 100 (100) 51
Úkol 1 Project 1  1
Úkol 2 Project 1  1
Závěrečný test Written examination 98  51
Mandatory attendence parzicipation: Fulfillment of 2 practical tasks and passing the final test.

Show history

### Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2021/2022 (B0588A170003) Applied Sciences and Technologies MAR P Czech Ostrava 1 Choice-compulsory type A study plan
2021/2022 (B0588A170003) Applied Sciences and Technologies CHE P Czech Ostrava 1 Choice-compulsory type B study plan
2021/2022 (B0588A170003) Applied Sciences and Technologies FYZ P Czech Ostrava 1 Choice-compulsory type B study plan
2021/2022 (B0588A170003) Applied Sciences and Technologies MTR P Czech Ostrava 1 Choice-compulsory type B study plan
2021/2022 (B0588A170003) Applied Sciences and Technologies PRJ P Czech Ostrava 1 Choice-compulsory type B study plan
2021/2022 (B0715A270011) Engineering K Czech Ostrava 1 Compulsory study plan
2021/2022 (B0715A270011) Engineering K Czech Uherský Brod 1 Compulsory study plan
2021/2022 (B0715A270011) Engineering P Czech Ostrava 1 Compulsory study plan
2021/2022 (B0715A270011) Engineering P Czech Šumperk 1 Compulsory study plan
2021/2022 (B0715A270011) Engineering K Czech Šumperk 1 Compulsory study plan
2021/2022 (B0713A070002) Energetics and Environments K Czech Ostrava 1 Compulsory study plan
2021/2022 (B0713A070002) Energetics and Environments P Czech Ostrava 1 Compulsory study plan
2021/2022 (B0715A040001) Transport Systems and Equipment P Czech Ostrava 1 Compulsory study plan
2021/2022 (B0715A040001) Transport Systems and Equipment K Czech Ostrava 1 Compulsory study plan
2021/2022 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2021/2022 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2020/2021 (B0715A270011) Engineering P Czech Ostrava 1 Compulsory study plan
2020/2021 (B0715A270011) Engineering K Czech Ostrava 1 Compulsory study plan
2020/2021 (B0715A270011) Engineering K Czech Šumperk 1 Compulsory study plan
2020/2021 (B0715A270011) Engineering K Czech Uherský Brod 1 Compulsory study plan
2020/2021 (B0715A270011) Engineering P Czech Šumperk 1 Compulsory study plan
2020/2021 (B0713A070002) Energetics and Environments K Czech Ostrava 1 Compulsory study plan
2020/2021 (B0713A070002) Energetics and Environments P Czech Ostrava 1 Compulsory study plan
2020/2021 (B0588A170003) Applied Sciences and Technologies MAR P Czech Ostrava 1 Choice-compulsory type A study plan
2020/2021 (B0588A170003) Applied Sciences and Technologies CHE P Czech Ostrava 1 Choice-compulsory type B study plan
2020/2021 (B0588A170003) Applied Sciences and Technologies FYZ P Czech Ostrava 1 Choice-compulsory type B study plan
2020/2021 (B0588A170003) Applied Sciences and Technologies MTR P Czech Ostrava 1 Choice-compulsory type B study plan
2020/2021 (B0588A170003) Applied Sciences and Technologies PRJ P Czech Ostrava 1 Choice-compulsory type B study plan
2020/2021 (B0715A040001) Transport Systems and Equipment P Czech Ostrava 1 Compulsory study plan
2020/2021 (B0715A040001) Transport Systems and Equipment K Czech Ostrava 1 Compulsory study plan
2020/2021 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2020/2021 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2019/2020 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2019/2020 (B2341) Engineering P Czech Šumperk 1 Compulsory study plan
2019/2020 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2019/2020 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2019/2020 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2019/2020 (B2341) Engineering K Czech Šumperk 1 Compulsory study plan
2019/2020 (B2341) Engineering K Czech Uherský Brod 1 Compulsory study plan
2019/2020 (B0713A070002) Energetics and Environments P Czech Ostrava 1 Compulsory study plan
2019/2020 (B0588A170003) Applied Sciences and Technologies MAR P Czech Ostrava 1 Choice-compulsory type A study plan
2019/2020 (B0715A040001) Transport Systems and Equipment P Czech Ostrava 1 Compulsory study plan
2019/2020 (B0715A270011) Engineering P Czech Ostrava 1 Compulsory study plan
2019/2020 (B0715A270011) Engineering K Czech Ostrava 1 Compulsory study plan
2019/2020 (B0715A270011) Engineering P Czech Šumperk 1 Compulsory study plan
2019/2020 (B0715A270011) Engineering K Czech Šumperk 1 Compulsory study plan
2019/2020 (B0715A270011) Engineering K Czech Uherský Brod 1 Compulsory study plan
2019/2020 (B0713A070002) Energetics and Environments K Czech Ostrava 1 Compulsory study plan
2019/2020 (B0588A170003) Applied Sciences and Technologies CHE P Czech Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B0588A170003) Applied Sciences and Technologies FYZ P Czech Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B0588A170003) Applied Sciences and Technologies MTR P Czech Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B0588A170003) Applied Sciences and Technologies PRJ P Czech Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B0715A040001) Transport Systems and Equipment K Czech Ostrava 1 Compulsory study plan
2018/2019 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2018/2019 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2018/2019 (B2341) Engineering K Czech Šumperk 1 Compulsory study plan
2018/2019 (B2341) Engineering P Czech Šumperk 1 Compulsory study plan
2018/2019 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2018/2019 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2017/2018 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2017/2018 (B2341) Engineering P Czech Šumperk 1 Compulsory study plan
2017/2018 (B2341) Engineering K Czech Šumperk 1 Compulsory study plan
2017/2018 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2017/2018 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2017/2018 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2017/2018 (B2341) Engineering K Czech Uherský Brod 1 Compulsory study plan
2016/2017 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2016/2017 (B2341) Engineering P Czech Šumperk 1 Compulsory study plan
2016/2017 (B2341) Engineering K Czech Šumperk 1 Compulsory study plan
2016/2017 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2016/2017 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2016/2017 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2015/2016 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2015/2016 (B2341) Engineering P Czech Šumperk 1 Compulsory study plan
2015/2016 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2015/2016 (B2341) Engineering K Czech Šumperk 1 Compulsory study plan
2015/2016 (B2341) Engineering K Czech Uherský Brod 1 Compulsory study plan
2015/2016 (B3712) Air Transport Technology (3708R036) Air Operation Technology P Czech Ostrava 1 Compulsory study plan
2015/2016 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2015/2016 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2014/2015 (B3712) Air Transport Technology (3708R036) Air Operation Technology P Czech Ostrava 1 Compulsory study plan
2014/2015 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2014/2015 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2014/2015 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2014/2015 (B2341) Engineering P Czech Šumperk 1 Compulsory study plan
2014/2015 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2014/2015 (B2341) Engineering K Czech Šumperk 1 Compulsory study plan
2013/2014 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2013/2014 (B2341) Engineering P Czech Šumperk 1 Compulsory study plan
2013/2014 (B2341) Engineering K Czech Šumperk 1 Compulsory study plan
2013/2014 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2013/2014 (B3712) Air Transport Technology (3708R036) Air Operation Technology P Czech Ostrava 1 Compulsory study plan
2013/2014 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2013/2014 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2013/2014 (B2341) Engineering K Czech Uherský Brod 1 Compulsory study plan
2012/2013 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2012/2013 (B2341) Engineering P Czech Šumperk 1 Compulsory study plan
2012/2013 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2012/2013 (B2341) Engineering K Czech Šumperk 1 Compulsory study plan
2012/2013 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2012/2013 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2012/2013 (B3712) Air Transport Technology (3708R036) Air Operation Technology P Czech Ostrava 1 Compulsory study plan
2011/2012 (B2341) Engineering P Czech Ostrava 1 Compulsory study plan
2011/2012 (B2341) Engineering P Czech Šumperk 1 Compulsory study plan
2011/2012 (B2341) Engineering K Czech Ostrava 1 Compulsory study plan
2011/2012 (B3712) Air Transport Technology (3708R036) Air Operation Technology P Czech Ostrava 1 Compulsory study plan
2011/2012 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2011/2012 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2011/2012 (B2341) Engineering K Czech Šumperk 1 Compulsory study plan
2011/2012 (B2341) Engineering K Czech Uherský Brod 1 Compulsory study plan

### Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner