SubjectsSubjects(version: 954)
Course, academic year 2019/2020
Technical Calculations on PC - N215001
Title: Technické výpočty na PC
Guaranteed by: Department of Petroleum Technology and Alternative Fuels (215)
Faculty: Faculty of Environmental Technology
Actual: from 2019 to 2020
Semester: winter
Points: winter s.:4
E-Credits: winter s.:4
Examination process: winter s.:
Hours per week, examination: winter s.:0/4, C [HT]
Capacity: unknown / 8 (unknown)
Min. number of students: unlimited
State of the course: taught
Language: Czech
Teaching methods: full-time
Teaching methods: full-time
Additional information:
Guarantor: Matějovský Lukáš Ing. Ph.D.
Examination dates   Schedule   
Annotation -
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.
Last update: ROZ215 (20.11.2012)
Aim of the course -

Students will know:

Use of advanced functions of MS Excel.

Solve more difficult problem using MS Excel.

Last update: Straka Petr (25.04.2017)
Literature -

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

Last update: ROZ215 (26.09.2013)
Learning resources -

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

Last update: ROZ215 (26.09.2013)
Syllabus -

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

Last update: Straka Petr (25.04.2017)
Registration requirements -

Application of Computer Techniques or Applications of Computer Science

Last update: Straka Petr (13.08.2013)
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