618-0413/03 – Computer Support of Technological Processes (PPTP)
| Gurantor department | Department of Metallurgy and Foundry | Credits | 4 |
| Subject guarantor | prof. Ing. Karel Michalek, CSc. | Subject version guarantor | prof. Ing. Karel Michalek, CSc. |
| Study level | undergraduate or graduate | Requirement | Compulsory |
| Year | 3 | Semester | summer |
| | Study language | Czech |
| Year of introduction | 2012/2013 | Year of cancellation | 2015/2016 |
| Intended for the faculties | FMT | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
- student will be able to work on advanced level in software products MS EXCEl and MS Word
- student will be able to apply methods of metallurgical calculations to the application MS Excel
- student will be able to formulate transparently conclusions of metallurgical calculations in the application MS Word
Teaching methods
Tutorials
Project work
Other activities
Summary
The subject is focused on applied possibilities of MS Excel, MS Word software in the domain of steel metallurgy.
Compulsory literature:
[1] Jack Zecher, Fereydoon Dadkhah: ANSYS Workbench Tutorial with Multimedia CD Release 12. Schroff Development Corporation. 2009. 256 s. ISBN-10: 1585035815
[2] Yogeshwar Sahai, Toshihiko Emi: Tundish Technology For Clean Steel Production. World Scientific Publishing Co. Pte. Ltd., Singapore, 2008. 328 s. ISBN-10: 9812706216
Recommended literature:
[1] Articles in magazines in the fund of the Central Library, Technical University of Ostrava, e.g. Hutnické listy, Iron Steel Technology, ISIJ International, Metallurgical and Materials Transaction, Revue de Métallurgie, Scandinavian Journal
of Metallurgy, Stahl und Eisen, Steel Research International, etc.
[2] Articles in the scientific publications from e-resources, such asSpringer Link, Scopus etc. or specialized databases, such asMetadex, Metal, etc.
[3] Proceedings of the conference, such as SteelSim, ISST, METAL etc.
Way of continuous check of knowledge in the course of semester
Two scored semester works and its presentation in relevant seminars during exercises.
Two scored progress tests.
E-learning
For electronic communication with the teachers enjoy the university e-mail addresses those can be found here: http://staff.vsb.cz/
Integration of e-learning elements into the subject is in progress.
Other requirements
There are not additional requirements on students in the field of this subject.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
1. Hardware and software requirements for the PC to perform basic balance calculations in the field of iron and steel metallurgy
2. Microsoft Word - basic features of technical tables, inserting objects from other applications
3. MS Word - Use an editor to create technical reports, using styles, templates, formatting, headings, insert symbols, list, bookmarks, links
4. Preparation and implementation of technical text with embedded images and tables
5. MS Excel - using relative and absolute links, creating tables, references, using functions, formatting text in tables
6. MS Excel - graphs, charts types, formatting, graphs, charts, operations, adding lines to graph
7. MS Excel - basic statistical concepts, data evaluation, using MS Excel. Mathematical and statistical processing of data using the program CurveExpert1.3.
8. MS Excel - using statistical analysis of data by trends, regression equation, value of reliability. Using the coefficient of variation in processing of experimental data.
9. MS Excel - CPU usage for the balance calculations in the field of metallurgy
10. Preparation and implementation of graphical output for a technical reports in Excel environment
11. Microsoft PowerPoint - Use of the technical presentations, inserting pictures, timing, transitions, formatting
12. Preparation and implementation of technical applications in MS PowerPoint
13. Balancing Exercises
14. Credit
To obtain credit in the combined study form is needed to develop a semester project.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction