338-0306/01 – Utilization of Computers within the Branch (VPvO)
Gurantor department | Department of Hydromechanics and Hydraulic Equipment | Credits | 2 |
Subject guarantor | prof. RNDr. Milada Kozubková, CSc. | Subject version guarantor | prof. RNDr. Milada Kozubková, CSc. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 3 | Semester | winter |
| | Study language | Czech |
Year of introduction | 2001/2002 | Year of cancellation | 2017/2018 |
Intended for the faculties | FS | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Students will become familiar with possibilities of the MS Office package and thus be able to create electronic text in MS Word using the links and automatic numbering of chapters, images, formulas, etc. will become acquainted with possibilities of MS PowerPoint. Students will be familiarized with the basic requisites of quality presentation. Become acquainted with the possibilities of MS Excel. They will create automatic spreadsheet calculations, based on fundamental fluid mechanics problems. They graphically analyze tabular data, and regression analysis to evaluate the measured data and perform simple iterative calculations.
Teaching methods
Tutorials
Summary
Acquaint students with MS Word, Excel, PowerPoint
Basics of MS Word text editor, creating of automatic page numbering, tables, formulas, etc., making records and lists
Basic skills in MS PowerPoint, presentation creation.
Basic skills in MS Excel, creating charts, graphs, an overview of basic functions.
Regression analysis of measured data and evaluation
Iterative solution of a simple implicit function
Compulsory literature:
DRÁBKOVÁ, S. a kol.: Mechanika tekutin, VŠB-TU Ostrava, 2007
Recommended literature:
JANALÍK, J., ŠŤÁVA,P.: Mechanika tekutin, VŠB-TU Ostrava, 2002
DRÁBKOVÁ, S., KOZUBKOVÁ, M.: Cvičení z mechaniky tekutin, VŠB-TU Ostrava, 2002
Way of continuous check of knowledge in the course of semester
no
E-learning
no
Other requirements
noo ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
1. E: Repetition of Fluid Mechanics
2. E: MS Word, text, save the file, subtitle creation, automatic numbering of chapters, equations, tables and images, records and generated content
3. E: MS PowerPoint presentation creation, the basic menus, input text, animated images. Instructions for creating presentations
4. E: MS Excel, the basic controls, program options
5. E: Example of using MS Excel with a simple example of fluid mechanics, graphs. Program 1 - word processing with graphics, charts and graphs, a simple example of fluid mechanics
6. E: Solution pumping system operating point, the derivation of pipe equations, calculation of two parabolas intersect analytically using the solver
7. E: More tools solver, practicing on simple examples
8. E: Solution of transient problems. Application Bernouliho equation for unsteady of flow
9. E: Solution the basic parameters of a piston pump. Derivation of equation for the pressure on the surface of the piston versus time
10. E: Solution of global warming of hydraulic system with cooler. Exact solution and solving by Euler method.
11. E: Analysis of measured data. Multiparametric regression. Determination of the oil viscosity coefficients depending on pressure and temperature.
12. E: Completing the calculation of regression coefficients, three-dimensional graphs. General recommendations for the regression analysis. Program 2 - data analysis using multiparametric regression analysis
13. E: Solution explicitly specified functions of simple iterative method. Program 3 - solving friction loss according to the formula by author Colebrook-White for a defined range of pipe diameter and roughness.
14. E: Development programs. Discussion
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction