618-0413/01 – Computer Support of Technological Processes (PPTP)

Gurantor departmentDepartment of Metallurgy and FoundryCredits2
Subject guarantorprof. Ing. Karel Michalek, CSc.Subject version guarantorprof. Ing. Karel Michalek, CSc.
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2004/2005Year of cancellation2015/2016
Intended for the facultiesFMTIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
GRY04 doc. Ing. Karel Gryc, Ph.D.
HOR14 Ing. Dana Horáková
MIH50 prof. Ing. Karel Michalek, CSc.
SAW002 doc. Ing. Markéta Tkadlečková, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 0+2
Combined Credit 6+0

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.

Další požadavky na studenta

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

Conditions for completion are defined only for particular subject version and form of study

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2011/2012 (B2109) Metallurgical Engineering (2109R035) Technologies of Metal Production P Czech Ostrava 3 Compulsory study plan
2010/2011 (B2109) Metallurgical Engineering (2109R035) Technologies of Metal Production P Czech Ostrava 3 Compulsory study plan
2009/2010 (B2109) Metallurgical Engineering (2109R035) Technologies of Metal Production P Czech Ostrava 3 Compulsory study plan
2008/2009 (B2109) Metallurgical Engineering (2109R035) Technologies of Metal Production P Czech Ostrava 3 Compulsory study plan
2007/2008 (B2109) Metallurgical Engineering (2109R035) Technologies of Metal Production P Czech Ostrava 3 Compulsory study plan
2006/2007 (B2109) Metallurgical Engineering (2109R035) Technologies of Metal Production P Czech Ostrava 3 Compulsory study plan
2005/2006 (B2109) Metallurgical Engineering (2109R035) Technologies of Metal Production P Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner