Technical Calculations on PC - N215001
Title: Technické výpočty na PC
Guaranteed by: Department of Petroleum Technology and Alternative Fuels (215)
Actual: from 2019
Semester: winter
Points: winter s.:4
E-Credits: winter s.:4
Examination process: winter s.:
Hours per week, examination: winter s.:0/4 C [hours/week]
Capacity: unknown / unknown (unknown)
Min. number of students: unlimited
Language: Czech
Teaching methods: full-time
For type:  
Additional information:
Note: course can be enrolled in outside the study plan
enabled for web enrollment
Guarantor: Matějovský Lukáš Ing. Ph.D.
Examination dates   
Annotation -
Last update: ROZ215 (20.11.2012)
The course is focused on solving complex engineering calculations using MS Excel. Students are acquainted with the advanced numeric functions of the program that are applied in the model examples.
Literature -
Last update: ROZ215 (26.09.2013)

R: Internal educational materials

A: Barilla J, Simr P.: Microsoft Excel pro techniky a inženýry, Computer Press, 2008, ISBN 978-80-251-2421-5

Learning resources -
Last update: ROZ215 (26.09.2013)

Straka P.: Technical Calculations on PC. Presentations for downloading on teacher's website

Syllabus -
Last update: Straka Petr Ing. Ph.D. (25.04.2017)

1. Introduction - using of MS Excel in technical calculations

2. Application exercises

3. Graph creation for presentation purpose, typographic rules, Import to MS Word and Power Point

4. Data import and processing (filtration, creation of histogram, etc.)

5. Application exercises

6. Optimization, non-linear equations (Solver)

7. Application exercises

8. Curve fitting (Function Solver)

9. Application exercises

10. Numerical integration

11. Application exercises

12. Application exercises

13. Application exercises

14. Credit test

Registration requirements -
Last update: Straka Petr Ing. Ph.D. (13.08.2013)

Application of Computer Techniques or Applications of Computer Science

Teaching methods
Activity Credits Hours
Příprava na zkoušku a její absolvování 2 56
Účast na seminářích 2 56
4 / 4 112 / 112
Coursework assessment
Form Significance
Continuous assessment of study performance and course -credit tests 100