352-0340/01 – Technical Calculations (TV)

Gurantor departmentDepartment of Control Systems and InstrumentationCredits4
Subject guarantorIng. David Fojtík, Ph.D.Subject version guarantorIng. Pavel Smutný, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2010/2011Year of cancellation
Intended for the facultiesFSIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
BAB75 doc. Ing. Marek Babiuch, Ph.D.
BRO0110 Ing. Stanislav Brožek
FOJ74 Ing. David Fojtík, Ph.D.
GEB050 Ing. Jan Gebauer, Ph.D.
PUD0012 Ing. Tomáš Puda
SMU78 Ing. Pavel Smutný, Ph.D.
STR0284 Ing. Radek Štramberský
TOM0287 Ing. Michal Tomeš
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.

LMS

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

Full-time form (validity from: 2011/2012 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Graded exercises evaluation Graded credit 100  51 3
Mandatory attendence participation: Participation in seminars min. 80%.

Show history

Conditions for subject completion and attendance at the exercises within ISP: Participation in the tests + completion of individual tasks after agreement with the teacher.

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2023/2024 (B0588A170003) Applied Sciences and Technologies MAR P Czech Ostrava 1 Choice-compulsory type A study plan
2023/2024 (B0588A170003) Applied Sciences and Technologies CHE P Czech Ostrava 1 Choice-compulsory type B study plan
2023/2024 (B0588A170003) Applied Sciences and Technologies FYZ P Czech Ostrava 1 Choice-compulsory type B study plan
2023/2024 (B0588A170003) Applied Sciences and Technologies MTR P Czech Ostrava 1 Choice-compulsory type B study plan
2023/2024 (B0588A170003) Applied Sciences and Technologies PRJ P Czech Ostrava 1 Choice-compulsory type B study plan
2023/2024 (B0713A070002) Energetics and Environments K Czech Ostrava 1 Compulsory study plan
2023/2024 (B0713A070002) Energetics and Environments P Czech Ostrava 1 Compulsory study plan
2023/2024 (B0715A040001) Transport Systems and Equipment P Czech Ostrava 1 Compulsory study plan
2023/2024 (B0715A040001) Transport Systems and Equipment K Czech Ostrava 1 Compulsory study plan
2023/2024 (B0715A270011) Engineering P Czech Ostrava 1 Compulsory study plan
2023/2024 (B0715A270011) Engineering K Czech Ostrava 1 Compulsory study plan
2023/2024 (B0715A270011) Engineering P Czech Šumperk 1 Compulsory study plan
2023/2024 (B0715A270011) Engineering K Czech Šumperk 1 Compulsory study plan
2023/2024 (B0715A270011) Engineering K Czech Uherský Brod 1 Compulsory study plan
2022/2023 (B0715A040001) Transport Systems and Equipment K Czech Ostrava 1 Compulsory study plan
2022/2023 (B0715A040001) Transport Systems and Equipment P Czech Ostrava 1 Compulsory study plan
2022/2023 (B0713A070002) Energetics and Environments P Czech Ostrava 1 Compulsory study plan
2022/2023 (B0713A070002) Energetics and Environments K Czech Ostrava 1 Compulsory study plan
2022/2023 (B0588A170003) Applied Sciences and Technologies MAR P Czech Ostrava 1 Choice-compulsory type A study plan
2022/2023 (B0588A170003) Applied Sciences and Technologies CHE P Czech Ostrava 1 Choice-compulsory type B study plan
2022/2023 (B0588A170003) Applied Sciences and Technologies FYZ P Czech Ostrava 1 Choice-compulsory type B study plan
2022/2023 (B0588A170003) Applied Sciences and Technologies MTR P Czech Ostrava 1 Choice-compulsory type B study plan
2022/2023 (B0588A170003) Applied Sciences and Technologies PRJ P Czech Ostrava 1 Choice-compulsory type B study plan
2022/2023 (B0715A270011) Engineering P Czech Ostrava 1 Compulsory study plan
2022/2023 (B0715A270011) Engineering K Czech Ostrava 1 Compulsory study plan
2022/2023 (B0715A270011) Engineering P Czech Šumperk 1 Compulsory study plan
2022/2023 (B0715A270011) Engineering K Czech Šumperk 1 Compulsory study plan
2022/2023 (B3712) Air Transport Technology (3708R037) Aircraft Operation Technology P Czech Ostrava 1 Compulsory study plan
2022/2023 (B3712) Air Transport Technology (3708R038) Aircraft Maintenance Technology P Czech Ostrava 1 Compulsory study plan
2022/2023 (B0715A270011) Engineering K Czech Uherský Brod 1 Compulsory study plan
2022/2023 (B1088A040001) Operation and management of air transport (S01) Air Transport Technology and Management P Czech Ostrava 1 Compulsory study plan
2022/2023 (B1088A040001) Operation and management of air transport (S02) Aviation Operation Management P Czech Ostrava 1 Compulsory study plan
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

Assessment of instruction



2021/2022 Winter
2020/2021 Winter
2019/2020 Winter
2018/2019 Winter
2017/2018 Winter
2016/2017 Winter
2015/2016 Winter
2014/2015 Winter
2013/2014 Winter
2012/2013 Winter
2011/2012 Winter