| Course Unit Code | 352-0340/01 |
|---|
| Number of ECTS Credits Allocated | 4 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | First Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | There are no prerequisites or co-requisites for this course unit |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| FOJ74 | Ing. David Fojtík, Ph.D. |
| SMU78 | Ing. Pavel Smutný, Ph.D. |
| GEB050 | Ing. Jan Gebauer, Ph.D. |
| 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. |
| Learning Outcomes of the Course Unit |
|---|
| 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. |
| Course Contents |
|---|
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. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
| Excel help & learning [online]. Microsoft [cit. 2021-03-08]. Dostupné z: https://support.microsoft.com/en-us/excel |
FOJTÍK, David, 2012. Programovací techniky: učební text : studijní materiály pro studijní obor Aplikovaná informatika a řízení Fakulty strojní. Ostrava: Vysoká škola báňská - Technická univerzita. ISBN 978-80-248-2608-0.
NAVARRŮ, Miroslav. Excel 2019: podrobný průvodce uživatele. Praha: Grada, 2019. Průvodce. ISBN 978-80-247-2026-5.
LAURENČÍK, Marek. Excel 2019: práce s databázemi a kontingenčními tabulkami. Praha: Grada, 2020. Průvodce. ISBN 978-80-271-1391-0.
Excel help & learning [online]. Microsoft [cit. 2021-03-08]. Dostupné z: https://support.microsoft.com/en-us/excel |
| Recommended Reading: |
|---|
| WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. [New York]: Pearson Education, [2019]. ISBN 978-1-5093-0588-9. |
| WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. [New York]: Pearson Education, [2019]. ISBN 978-1-5093-0588-9. |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials, Experimental work in labs |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Graded exercises evaluation | Graded credit | 100 | 51 |