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.
FOJ74 Ing. David Fojtík, Ph.D.
GEB050 Ing. Jan Gebauer, Ph.D.
GUR0017 Ing. Radek Guráš
PAV0201 Ing. Václav Pavelka
POD134 Ing. Petr Podešva, Ph.D.
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
Combined 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:

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.

LMS

E-learning

https://lms.vsb.cz

Další požadavky na studenta

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

Combined form (validity from: 2018/2019 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
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.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 (B0713A070002) Energetics and Environments P Czech Ostrava 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 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 P Czech Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B0588A170003) Applied Sciences and Technologies P Czech Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B0588A170003) Applied Sciences and Technologies P Czech Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B0588A170003) Applied Sciences and Technologies P Czech Ostrava 1 Choice-compulsory type B 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