618-2032/01 – Usage of PC (KomP)
| Gurantor department | Department of Metallurgy and Foundry | Credits | 3 |
| Subject guarantor | Ing. Jaroslav Beňo, Ph.D. | Subject version guarantor | Ing. Jaroslav Beňo, Ph.D. |
| Study level | undergraduate or graduate | Requirement | Compulsory |
| Year | 1 | Semester | winter |
| | Study language | Czech |
| Year of introduction | 2014/2015 | Year of cancellation | 2020/2021 |
| Intended for the faculties | FMT | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Acquired knowledge:
-student acquire an overview about how to use Basic Office package MS Office programs and their application for the creation of text documents, processing and presentation of data
Skills acquired:
- student will be able to write document with text editor according to random template
- student will be able to process data including graphical form
- student will be able to prepare easy presentation including the all requisites
Teaching methods
Lectures
Individual consultations
Tutorials
Summary
The subject is focused on basic operation with OS WINDOWS and office packet MS Office. The attention is devoted to writing a document according to random template, to process data including graphical form with the help of the MS EXCEL; and to prepare a basic presentation.
Compulsory literature:
[1] Weverka, P. Office 2010 All-in-One. 1 edition, 2010, For Dummies. P. 816 ISBN-10: 0470497483, Paperback: 816 pages
Recommended literature:
[1] Shoup, K. Office 2010: Simplified 1 edition. 2010, Visual; 2010 Paperback: p. 416 pages ISBN-10: 0470571942
Way of continuous check of knowledge in the course of semester
E-learning
http://www.fmmi.vsb.cz/cs/urceno-pro/studenty/podklady-ke-studiu/studijni-opory
Other requirements
Development of credit presentation and working protocols
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
1. Operating system MS Windows, basic operation with OS, work with folder, file, data archiving and backup
2. Windows explorer - introduction, basic operations with files and folders, cooperation with OS , other types of managers
3. MS Office WORD - introduction to text editor, optimization of background and quick access board, work and quick orientation at document, work with a few documents of MS WORD, script formats, fonts
4. MS Office WORD – files editing, paragraph formats, page formats, work with heading and footing, page arrangement, fixed space, printing
5. MS Office WORD – Styles, finding and replacement, cross reference, content displaying
6. MS Office WORD – tables, basic calculations at tables, work with pictures, work with objects, mail merge
7. MS Office WORD – spelling, document revise, underline notes and comments, segments - inserting of page with new format
8. MS Office EXCEL – introduction with spreadsheet, optimization of background and quick access board, content of cells – entry and editing work with a few documents
9. MS Office EXCEL - movement at table, selection determination cell format, editing of columns and lines size
10. MS Office EXCEL – Table editing, copy and transfer of selection references, formulas, functions, absolute coordinate
11. MS Office EXCEL – Printing, cross buntons, finding and replacement , aligning, filters
12. MS Office EXCEL - choice, creation and graph editing, main and secondary axis, work with data - connecting line
13. MS Office POWERPOINT - basic principles of presentation creation pre-defined and own motive of screen, work with screens, grid and guidances, heading and footing
14. MS Office POWERPOINT - animation, graph, picture, video and sound inserting, saving possibilities
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction