SubjectsSubjects(version: 948)
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
Language: Czech
Teaching methods: full-time
Teaching methods: full-time
Level:  
For type:  
Additional information: http://web.vscht.cz/strakap
Guarantor: Matějovský Lukáš Ing. Ph.D.
Examination dates   Schedule   
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.
Aim of the course -
Last update: Straka Petr Ing. Ph.D. (25.04.2017)

Students will know:

Use of advanced functions of MS Excel.

Solve more difficult problem using MS Excel.

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

 
VŠCHT Praha