352-0340/02 – 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 graduateRequirementChoice-compulsory type B
Year1Semesterwinter
Study languageEnglish
Year of introduction2015/2016Year of cancellation
Intended for the facultiesFSIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
FOJ74 Ing. David Fojtík, Ph.D.
POD134 Ing. Petr Podešva, Ph.D.
SMU78 Ing. Pavel Smutný, Ph.D.
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

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

Full-time form (validity from: 2015/2016 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Graded credit 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 tests + completion of individual tasks after agreement with the teacher.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2024/2025 (B0588A170002) Applied Sciences and Technologies MR P English Ostrava 1 Choice-compulsory type A study plan
2024/2025 (B0588A170002) Applied Sciences and Technologies CH P English Ostrava 1 Choice-compulsory type B study plan
2024/2025 (B0588A170002) Applied Sciences and Technologies F P English Ostrava 1 Choice-compulsory type B study plan
2024/2025 (B0588A170002) Applied Sciences and Technologies MT P English Ostrava 1 Choice-compulsory type B study plan
2024/2025 (B0588A170002) Applied Sciences and Technologies PJ P English Ostrava 1 Choice-compulsory type B study plan
2024/2025 (B0713A070003) Energetics and Environments P English Ostrava 1 Compulsory study plan
2024/2025 (B0715A270012) Engineering P English Ostrava 1 Compulsory study plan
2023/2024 (B0588A170002) Applied Sciences and Technologies MR P English Ostrava 1 Choice-compulsory type A study plan
2023/2024 (B0588A170002) Applied Sciences and Technologies CH P English Ostrava 1 Choice-compulsory type B study plan
2023/2024 (B0588A170002) Applied Sciences and Technologies F P English Ostrava 1 Choice-compulsory type B study plan
2023/2024 (B0588A170002) Applied Sciences and Technologies MT P English Ostrava 1 Choice-compulsory type B study plan
2023/2024 (B0588A170002) Applied Sciences and Technologies PJ P English Ostrava 1 Choice-compulsory type B study plan
2023/2024 (B0713A070003) Energetics and Environments P English Ostrava 1 Compulsory study plan
2023/2024 (B0715A270012) Engineering P English Ostrava 1 Compulsory study plan
2022/2023 (B0713A070003) Energetics and Environments P English Ostrava 1 Compulsory study plan
2022/2023 (B0588A170002) Applied Sciences and Technologies MR P English Ostrava 1 Choice-compulsory type A study plan
2022/2023 (B0588A170002) Applied Sciences and Technologies CH P English Ostrava 1 Choice-compulsory type B study plan
2022/2023 (B0588A170002) Applied Sciences and Technologies F P English Ostrava 1 Choice-compulsory type B study plan
2022/2023 (B0588A170002) Applied Sciences and Technologies MT P English Ostrava 1 Choice-compulsory type B study plan
2022/2023 (B0588A170002) Applied Sciences and Technologies PJ P English Ostrava 1 Choice-compulsory type B study plan
2022/2023 (B0715A270012) Engineering P English Ostrava 1 Compulsory study plan
2021/2022 (B0588A170002) Applied Sciences and Technologies MR P English Ostrava 1 Choice-compulsory type A study plan
2021/2022 (B0588A170002) Applied Sciences and Technologies CH P English Ostrava 1 Choice-compulsory type B study plan
2021/2022 (B0588A170002) Applied Sciences and Technologies F P English Ostrava 1 Choice-compulsory type B study plan
2021/2022 (B0588A170002) Applied Sciences and Technologies MT P English Ostrava 1 Choice-compulsory type B study plan
2021/2022 (B0588A170002) Applied Sciences and Technologies PJ P English Ostrava 1 Choice-compulsory type B study plan
2021/2022 (B0713A070003) Energetics and Environments P English Ostrava 1 Compulsory study plan
2021/2022 (B0715A270012) Engineering P English Ostrava 1 Compulsory study plan
2020/2021 (B0715A270012) Engineering P English Ostrava 1 Compulsory study plan
2020/2021 (B0713A070003) Energetics and Environments P English Ostrava 1 Compulsory study plan
2020/2021 (B0588A170002) Applied Sciences and Technologies MR P English Ostrava 1 Choice-compulsory type A study plan
2020/2021 (B0588A170002) Applied Sciences and Technologies CH P English Ostrava 1 Choice-compulsory type B study plan
2020/2021 (B0588A170002) Applied Sciences and Technologies F P English Ostrava 1 Choice-compulsory type B study plan
2020/2021 (B0588A170002) Applied Sciences and Technologies MT P English Ostrava 1 Choice-compulsory type B study plan
2020/2021 (B0588A170002) Applied Sciences and Technologies PJ P English Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B2341) Engineering P English Ostrava 1 Compulsory study plan
2019/2020 (B0715A270012) Engineering P English Ostrava 1 Compulsory study plan
2019/2020 (B0588A170002) Applied Sciences and Technologies MR P English Ostrava 1 Choice-compulsory type A study plan
2019/2020 (B0713A070003) Energetics and Environments P English Ostrava 1 Compulsory study plan
2019/2020 (B0588A170002) Applied Sciences and Technologies CH P English Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B0588A170002) Applied Sciences and Technologies F P English Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B0588A170002) Applied Sciences and Technologies MT P English Ostrava 1 Choice-compulsory type B study plan
2019/2020 (B0588A170002) Applied Sciences and Technologies PJ P English Ostrava 1 Choice-compulsory type B study plan
2018/2019 (B2341) Engineering P English Ostrava 1 Compulsory study plan
2017/2018 (B2341) Engineering P English Ostrava 1 Compulsory study plan
2016/2017 (B2341) Engineering P English Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.