Skip to main content
Skip header
Terminated in academic year 2012/2013

Computer-aided Forming

Type of study Bachelor
Language of instruction Czech
Code 633-0407/01
Abbreviation PPT
Course title Computer-aided Forming
Credits 4
Coordinating department Department of Materials Forming
Course coordinator Ing. Tomáš Kubina, Ph.D.

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

E-learning

-

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

Advised literature

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