338-0306/01 – Utilization of Computers within the Branch (VPvO)

Gurantor departmentDepartment of Hydromechanics and Hydraulic EquipmentCredits2
Subject guarantorprof. RNDr. Milada Kozubková, CSc.Subject version guarantorprof. RNDr. Milada Kozubková, CSc.
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2001/2002Year of cancellation2017/2018
Intended for the facultiesFSIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
HIM0007 Ing. Daniel Himr, Ph.D.
RAU01 Ing. Jana Jablonská, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 0+2

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

Další požadavky na studenta

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

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
2012/2013 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan
2011/2012 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan
2010/2011 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan
2009/2010 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan
2008/2009 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan
2007/2008 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan
2006/2007 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan
2005/2006 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan
2004/2005 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan
2003/2004 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan
2002/2003 (B2341) Engineering (2302R007) Hydraulics and Pneumatics P Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner