Course Unit Code | 635-2044/01 |
---|
Number of ECTS Credits Allocated | 3 ECTS credits |
---|
Type of Course Unit * | Compulsory |
---|
Level of Course Unit * | First Cycle |
---|
Year of Study * | Third Year |
---|
Semester when the Course Unit is delivered | Summer Semester |
---|
Mode of Delivery | Face-to-face |
---|
Language of Instruction | Czech |
---|
Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
---|
Name of Lecturer(s) | Personal ID | Name |
---|
| RIG005 | Ing. et Ing. David Rigo |
| MAC589 | Ing. Mario Machů, Ph.D. |
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 Part of the course will be the VBA programming language. |
Learning Outcomes of the Course Unit |
---|
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. |
Course Contents |
---|
• 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.
• The design of the tables in the MS Excel environment, the auto-searching methods. Practical example from the field of the thermal processes.
• Approximation of thermophysical properties by regression functions.
• Use of logic functions in convective heat transfer using critical equations.
• The determination of the extreme values of a function and the equations roots. Practical example from the field of the thermal processes.
• The principle of stationary heat conduction by iterative method.
• The processing of the measured data. The statistics essentials – the moving average, the median, t-test, and the like. Data filtering.
• Design of results presentation, pictures and graphs. Creating static and interactive graphs.
• 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.
• Using macros in MS Excel - View card developer, creating macros, use the the control elements of the form.
• Basics of programming in VBA - Sub and Function, variable declarations, creation of custom formulas. Creating and using supplements.
• A method InputBox Excel and VBA, the function MsgBox of VBA, work with objects Range
• Design With-End With, For Each-Next, GoTo, If-Then, Select Case. Object variable.
• Error handling.
• Creation of user forms.
• Creating technical text in MS Word.
|
Recommended or Required Reading |
---|
Required Reading: |
---|
[1] KRAUSE, E. Fluid Mechanics. Berlin: Springer Verlag, 2005. ISBN 3-540-22981-7.
[2] LIENHARD IV, J. H., LIENHARD V, J. H. A Heat Transfer Textbook. 4th ed. Cambridge: Phlogiston Press, 2012.
[3] BEJAN, A., KRAUS, A. D. Heat Transfer Handbook. John Wiley & Sons, 2003. ISBN 978-0-471-39015-2.
[4] SIENIUTYCZ, S., JEŻOWSKI, J. Energy Optimization in Process Systems. Oxford: Elsevier, 2009. ISBN 978-0-08-045141-1. |
[1] RÉDR, M., PŘÍHODA, M. Základy tepelné techniky. Praha: SNTL, 1991. 680 s. ISBN 80–03–00366–0.
[2] BÁLEK, S. Tepelně technické tabulky a diagramy. Ostrava: VŠB TUO, 1999. 129 s. ISBN 80-7078-974-3.
[3] WALKENBACH, J. Microsoft office Excel 2007 - Vzorce a výpočty. 1. vyd. Brno: Computer Press a.s., 2008. 712 s. ISBN 978–80–251–1765–1.
[4] PŘÍHODA, M., RÉDR, M. Sdílení tepla a proudění. 2. přeprac. vyd. Ostrava: VŠB TUO, 2008. 177 s. ISBN 978–80–1748–4.
[5] TALER, J., DUDA, P. Solving Direct and Inverse Heat Conduction Problems. Berlin: Springer, 2006. ISBN 978-3-540-33470-5.
|
Recommended Reading: |
---|
[1] FEYNMAN, R., LEIGHTON, R., SANDS, M. The Feynman Lectures on Physics: Vol.1. 2nd ed. Boston: Addison Wesley, 2005. 544 p. ISBN 978-0805390469.
[2] MULLINGER, P., JENKINS, B. Industrial and Process Furnaces: Principles, Design and Operation. 1st ed. Oxford: Butterworth-Heinemann, 2008. ISBN 978-0-7506-8692-1.
[3] HENS, H. Building physics: heat, air and moisture: fundamentals and engineering methods with examples and exercises. 2nd ed. Berlin: Ernst & Sohn, 2012. ISBN 978-3-433-03027-1. |
[1] WALKENBACH, J. Microsoft office Excel 2007 Programování ve VBA. 1. vyd. Brno: Computer Press a.s., 2008. 912 s. ISBN 978–80–251–2011–8.
[2] BREDEN, M., SCHWIMMER, M. Excel 2007 VBA Velká kniha řešení. Computer Press, a.s. 2009. 685 s. ISBN 978-80-251-2698-1.
[3] KŘIVDA, V., ŠIROKÝ, J. Zpracování podkladů pro projekty a diplomové práce. VŠB-TU Ostrava, 2006. 82 s. ISBN 80-248-1269-X |
Planned learning activities and teaching methods |
---|
Lectures, Tutorials |
Assesment methods and criteria |
---|
Task Title | Task Type | Maximum Number of Points (Act. for Subtasks) | Minimum Number of Points for Task Passing |
---|
Graded credit | Graded credit | 100 | 51 |