Subjects

Hello,

On Monday, April 28 after 5 pm, some of the university's information systems will be unavailable due to maintenance work.

Affected systems are the Education Information System, Financial IS (iFIS), MIS/OBD/Verso, Kopla and related agendas.

It is anticipated that everything should be back online and running by Tuesday morning.

Work with e-mail or shared drives will not be affected.

Computer center

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 2014 to 2016
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
Qualifications:
State of the course:	taught
Language:	Czech
Teaching methods:	full-time
Level:
Additional information:	http://web.vscht.cz/strakap
Note:	course can be enrolled in outside the study plan enabled for web enrollment

Guarantor:	Straka Petr Ing. Ph.D. 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)

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)

Learning outcomes -

Students will know:

Use of advanced functions of MS Excel.

Solve more difficult problem using MS Excel.

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