618-2032/01 – Usage of PC (KomP)

Gurantor departmentDepartment of Metallurgy and FoundryCredits3
Subject guarantorIng. Jaroslav Beňo, Ph.D.Subject version guarantorIng. Jaroslav Beňo, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2014/2015Year of cancellation
Intended for the facultiesFMTIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
BEN001 Ing. Jaroslav Beňo, Ph.D.
MEN096 Ing. Martin Menšík
S1I28 doc. Ing. Ivo Špička, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 1+3

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

Další požadavky na studenta

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

Full-time form (validity from: 2014/2015 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  21
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2019/2020 (B2109) Metallurgical Engineering (2109R031) Art Foundry Engineering P Czech Ostrava 1 Compulsory study plan
2018/2019 (B2109) Metallurgical Engineering (2109R031) Art Foundry Engineering P Czech Ostrava 1 Compulsory study plan
2017/2018 (B2109) Metallurgical Engineering (2109R031) Art Foundry Engineering P Czech Ostrava 1 Compulsory study plan
2016/2017 (B2109) Metallurgical Engineering (2109R031) Art Foundry Engineering P Czech Ostrava 1 Compulsory study plan
2015/2016 (B2109) Metallurgical Engineering (2109R031) Art Foundry Engineering P Czech Ostrava 1 Compulsory study plan
2014/2015 (B2109) Metallurgical Engineering (2109R031) Art Foundry Engineering P Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner