Subjects

Your browser does not support JavaScript, or its support is disabled. Some features may not be available.

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 / unknown (unknown)
Min. number of students:	unlimited
State of the course:	taught
Language:	Czech
Teaching methods:	full-time
Teaching methods:	full-time
Level:
Additional information:	http://web.vscht.cz/strakap

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)

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)

Learning resources -

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

Last update: ROZ215 (26.09.2013)

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