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

Gurantor departmentDepartment of Materials FormingCredits4
Subject guarantordoc. Ing. Radim Kocich, Ph.D.Subject version guarantorIng. Tomáš Kubina, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semestersummer
Study languageCzech
Year of introduction2004/2005Year of cancellation2012/2013
Intended for the facultiesFMTIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
KOC15 doc. Ing. Radim Kocich, Ph.D.
KUB66 Ing. Tomáš Kubina, 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

elaboration of semester project

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: 1960/1961 Summer semester, validity until: 2011/2012 Summer 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 (30) 0
                Other task type Other task type 30  0
        Examination Examination 70 (70) 0
                Oral Oral examination 70  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2011/2012 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan
2011/2012 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2011/2012 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Třinec 3 Compulsory study plan
2010/2011 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2010/2011 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Třinec 3 Compulsory study plan
2010/2011 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan
2009/2010 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan
2009/2010 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2009/2010 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Třinec 3 Compulsory study plan
2008/2009 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan
2008/2009 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2008/2009 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Třinec 3 Compulsory study plan
2007/2008 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan
2007/2008 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2007/2008 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Třinec 3 Compulsory study plan
2006/2007 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan
2006/2007 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2006/2007 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Třinec 3 Compulsory study plan
2005/2006 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment P Czech Ostrava 3 Compulsory study plan
2005/2006 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Ostrava 3 Compulsory study plan
2005/2006 (B2109) Metallurgical Engineering (2109R034) Forming Technologies and Material Treatment K Czech Třinec 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner