633-0407/02 – Computer-aided Forming (PPT)
| Gurantor department | Department of Materials Forming | Credits | 6 |
| Subject guarantor | prof. Ing. Radim Kocich, Ph.D. | Subject version guarantor | Ing. Tomáš Kubina, Ph.D. |
| Study level | undergraduate or graduate | Requirement | Compulsory |
| Year | 3 | Semester | summer |
| | Study language | Czech |
| Year of introduction | 2012/2013 | Year of cancellation | 2020/2021 |
| Intended for the faculties | FMT | Intended for study types | Bachelor |
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
-
Other requirements
-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
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction