633-0407/02 – Computer-aided Forming (PPT)

Gurantor departmentDepartment of Materials FormingCredits6
Subject guarantordoc. Ing. Radim Kocich, Ph.D.Subject version guarantorIng. Tomáš Kubina, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semestersummer
Study languageCzech
Year of introduction2012/2013Year of cancellation
Intended for the facultiesFMTIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
KOC15 doc. Ing. Radim Kocich, Ph.D.
RUS37 Ing. Stanislav Rusz, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 16+0

Subject aims expressed by acquired skills and competences

Student will be able to: - construction of elementary function attached to materials forming in sheet processor Excel; - calculations with nested conditions; - solve of graphic display of real measured data - different functions testing during regression analysis.

Teaching methods

Lectures
Seminars
Individual consultations
Tutorials

Summary

The course is aimed to exploitation of advance possibilities the spreadsheet Excel. Subtasks are join on selected problems from forming technology.

Compulsory literature:

BANABIC D. Advanced Methods in Material Forming, IX, 362 p., Springer Verlag, 2007 RAABE,D., ROTERS, F., BARLAT, F., CHEN, L. Continuum Scale Simulation of Engineering Materials, Wiley – VCH, 862 p., 2004

Recommended literature:

RAABE, D. Computational Materials Science, Wiley – VCH, 402 s., 1998

Way of continuous check of knowledge in the course of semester

3 pointwise assessed reports, presentation of the paper

E-learning

-

Další požadavky na studenta

-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Lectures: 1. Control Word processor. 2. Page formatting, text, work with styles. Multi-level numbered list. Working with tables. 3. Graphical objects in the document. Writing mathematical expressions and equations. 4. Document Automation. The use of executive boxes. User options settings, macros. 5. Header and Footer. Create a template. Mail Merge. Print. 6. Setup and control Excel spreadsheet. Insert formulas and functions. Filling out the ranks. Array formula. 7. Types, formatting and editing charts. Curves, surfaces. 8. Formatting cells, leaves, styles, templates. Conditional format. Print. Lists and databases in Excel. 9. Importing data. Filters, subtotals, pivot table and chart. Tools for data analysis. 10. Cooperation Word and Excel. Macros. Custom functions. 11. PowerPoint presentation program - to set the formatting and presentation. Exercise: 1. Formatting a document, use of curriculum, styles, numbered lists 2. Working with tables, inserting objects into a document, writing equations 3. User settings, document automation, macro 4. Header and Footer. Create a template. Mail Merge. Print. - Protocol 5. Working with cells in the spreadsheet Excel. Insert formulas and functions. Filling out the ranks. Array formula. 6. Types, formatting and editing charts. Curves, surfaces. 7. Leaves, styles, templates. Conditional format. Print. - Protocol 8. Lists and databases in Excel. Importing data. Filters, subtotals, pivot table and chart. Tools for data analysis. - Protocol 9. Cooperation Word and Excel. Macros. Custom functions. - Protocol 10. PowerPoint - to set the formatting data for presentation 11. PowerPoint - Presentation

Conditions for subject completion

Combined form (validity from: 2012/2013 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 30  15
        Examination Examination 70  35
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2015/2016 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan
2015/2016 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2014/2015 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan
2014/2015 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2013/2014 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan
2013/2014 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2012/2013 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2012/2013 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner