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.
FOJ74 Ing. David Fojtík, Ph.D.
GEB050 Ing. Jan Gebauer, Ph.D.
PAV0201 Ing. Václav Pavelka
PET0032 Ing. Filip Peterek
POD134 Ing. Petr Podešva, Ph.D.
SIK0082 Ing. Jan Sikora
SMU78 Ing. Pavel Smutný, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent

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:

ORVIS, William J. Excel for scientists and engineers. 2nd ed. San Francisco: Sybex, c1996, xxvii, 547 s. ISBN 0-7821-1761-9.

Recommended literature:

ORVIS, William J. Excel for scientists and engineers. 2nd ed. San Francisco: Sybex, c1996, xxvii, 547 s. ISBN 0-7821-1761-9.

Way of continuous check of knowledge in the course of semester

Students have to pass tests and fullfil tasks.

E-learning

http://lms.vsb.cz

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

Conditions for completion are defined only for particular subject version and form of study

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
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 (B0588A170003) Applied Sciences and Technologies P Czech Ostrava 1 Choice-compulsory type A study plan
2019/2020 (B0715A270011) Engineering 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