# 635-2011/01 – PC support in thermal engineering (PPTP)

 Gurantor department Department of Thermal Engineering Credits 5 Subject guarantor Ing. Dalibor Jančar, Ph.D. Subject version guarantor Ing. Dalibor Jančar, Ph.D. Study level undergraduate or graduate Requirement Compulsory Year 3 Semester summer Study language Czech Year of introduction 2014/2015 Year of cancellation Intended for the faculties FMT Intended for study types Bachelor
Instruction secured by
JAN57 Ing. Dalibor Jančar, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 1+3
Combined Credit and Examination 16+0

### Subject aims expressed by acquired skills and competences

On the basis of analytical model the student will be able to numerically solve using the PC the simple as well as complicated problems in the filed of thermal processes including those in industrial thermal devices, walls of the residential buildings and during the fuel combustion. The student also will be capable of design a simple user applications useful for the customer who is not interested in detailed solution of the problem under consideration.

Lectures
Tutorials
Project work

### Summary

The main goal of this course is to make the students familiar with some basic function of the Microsoft Office Excel software and to teach the students to take advantage of this software in the numerical calculation of the problems in the filed of thermal processes including those in industrial thermal devices, walls of the residential buildings and during the fuel combustion. The lessons will be focused mainly on application of the mathematical, statistical and logical function of the Excel as well as on the application of the control elements useful for handle computation in the application form. The basic graphical capability of the Excel will be used for the presentation of the computation results. Finally the students will be getting to know the basic of the programming language VBA.

### Compulsory literature:

[1] TALER, Jan, DUDA, Piotr. Solving Direct and Inverse Heat Conduction Problems. Berlin Heidelberg: Springer Verlag, 2006. 889 p. ISBN 978-3-540-33470-5.

### Recommended literature:

[1] FEYNMAN, Richard, LEIGHTON, Robert, SANDS, Matthew. The Feynman Lectures on Physics: Vol.1. 2nd ed. Boston: Addison Wesley, 2005. 544 p. ISBN 978-0805390469.

### Prerequisities

Subject has no prerequisities.

### Co-requisities

Subject has no co-requisities.

### Subject syllabus:

1. MS Excel essentials. Cells labelling, absolute and relative references, data validation, the design of user application using the control elements of the form. Practical example from the field of the thermal processes. 2. The design of the tables in the MS Excel environment, the auto-searching methods. Practical example from the field of the thermal processes. 3. The linear and the polynomial regression. The practical application of the least square method – the approximation of the particular function. 4. The determination of the extreme values of a function and the equations roots. Practical example from the field of the thermal processes. 5. The solving the equation system. The matrix formulas and the iterations. 6. The processing of the measured data. The statistics essentials – the moving average, the median and the like. 7. The design of the obtained results presentation using the suitable graphs and the pictures. The formation of the static and the interactive graphs, the pictures drawing. 8. The application of the iterative methods. Practical example from the field of the thermal processes. 9. The finite element analysis. The mesh design, the determination of the sample time. The influence of the different kind of the boundary conditions on the computation results. 10. Using macros in MS Excel - View card developer, creating macros, use the the control elements of the form. 12. Basics of programming in VBA - Sub and Function, variable declarations, creation of custom formulas. Creating and using supplements. 13. A method InputBox Excel and VBA, the function MsgBox of VBA, work with objects Range. 14. Design With-End With, For Each-Next, GoTo, If-Then, Select Case. Object variable. 14th Error handling. 14. Creation of user forms.

### Conditions for subject completion

Combined form (validity from: 2014/2015 Summer semester)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
Exercises evaluation Credit 30 (30) 15
Semestrální projekt Semestral project 30  15
Examination Examination 70  36
Mandatory attendence parzicipation:

Show history

### Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials K Czech Ostrava 3 Compulsory study plan
2019/2020 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials P Czech Ostrava 3 Compulsory study plan
2018/2019 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials P Czech Ostrava 3 Compulsory study plan
2018/2019 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials K Czech Ostrava 3 Compulsory study plan
2017/2018 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials P Czech Ostrava 3 Compulsory study plan
2017/2018 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials K Czech Ostrava 3 Compulsory study plan
2016/2017 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials P Czech Ostrava 3 Compulsory study plan
2016/2017 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials K Czech Ostrava 3 Compulsory study plan
2015/2016 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials P Czech Ostrava 3 Compulsory study plan
2015/2016 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials K Czech Ostrava 3 Compulsory study plan
2014/2015 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials P Czech Ostrava 3 Compulsory study plan
2014/2015 (B2109) Metallurgical Engineering (2109R039) Thermal Engineering and Ceramic Materials K Czech Ostrava 3 Compulsory study plan

### Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner