|
Lecturer(s)
|
-
Fučík Ibrahim, Ing.
-
Šmrhová Anežka, Ing.
-
Svobodová Jana, Ing.
-
Lachman Petr, Ing.
-
Neupauer Yevgeniy, doc. Ing. Ph.D.
-
Kučerová Hana, Ing. Ph.D.
-
Prunner Jaroslav, Ing.
-
Hajžman Milan, Ing.
-
Fialka Jiří, Ing.
-
Holý Richard, Ing. Bc. Ph.D.
|
|
Course content
|
The course is focused on a practical processing of a technical documents, calculations using a spreadsheet and creating the presentation containing processed results. The MS Office apllications (Word, Excel and Powerpoint) is used in the course. 1. Organization of the course 2. Tasks in MS Word (styles - creation, editing, copying) 3. Tasks in MS Word (fields, building blocks, galleries, equations, cross-references, headers - linking with style, footer ...) 4. Tasks in MS Word (extraction of images into folders, sections, contents, sources ...) + consultation of individual task processed by MS Word 5. Tasks in MS Excel (MS Excel functionalities, series, custom lists, relative and absolute addressing, cell format) 6. Tasks in MS Excel (naming of a range, sheets, reference, formatting using condition) 7. Tasks in MS Excel (table style, data import, charts) 8. Tasks in MS Excel (operators, processing an examples) + consulting of an individual task processed by MS Excel 9. Tasks in MS PowerPoint (templates, fields, smart art, theme, layout) 10. Tasks in MS PowerPoint (animation, grouping and separating of objects, assigning of action to an object) 11. Tasks in MS PowerPoint (slide layout, processing examples) + consulting of an individual task in MS PowerPoint 12. Presentation of semester work 13. Presentation of semester work
|
|
Learning activities and teaching methods
|
Discussion, Instruction based on dialogue, Multimedia supported teaching, Students' portfolio
- Individual project (40)
- 40 hours per semester
- Contact hours
- 39 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| to know the basic operations in the operating system |
| to know the basics of working with the Internet |
| to know the basic functionality of the computer |
| Skills |
|---|
| have basic operating system skills |
| have basic internet skills |
| have basic PC skills |
| Competences |
|---|
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| to know the basic functionality of MS Word |
| to know the basic functionality of MS Excel |
| to know the basic functionality of MS Powerpoint |
| describe a technical problem using the office productivity software |
| Skills |
|---|
| work with the office productivity software |
| prepare a presentation |
| process a larger-scale document |
| Competences |
|---|
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecture with visual aids |
| E-learning |
| Multimedia supported teaching |
| Students' portfolio |
| Discussion |
| Interactive lecture |
| Self-study of literature |
| One-to-One tutorial |
| Individual study |
| Collaborative instruction |
| Skills |
|---|
| Practicum |
| Skills demonstration |
| Interactive lecture |
| Students' portfolio |
| E-learning |
| Lecture with visual aids |
| Multimedia supported teaching |
| Task-based study method |
| Individual study |
| Self-study of literature |
| One-to-One tutorial |
| Competences |
|---|
| Task-based study method |
| Individual study |
| E-learning |
| Self-study of literature |
| Multimedia supported teaching |
| assessment methods |
|---|
| Knowledge |
|---|
| Continuous assessment |
| Skills |
|---|
| Seminar work |
| Individual presentation at a seminar |
| Competences |
|---|
| Seminar work |
| Individual presentation at a seminar |
|
Recommended literature
|
-
Karel Klatovský. Powerpoint 2016 nejen pro školy. Computer Media, 2016. ISBN 978-80-7402-251-7.
-
Karel Klatovský. WORD 2016 nejen pro školy. Computer Media, 2016. ISBN 978-80-7402-249-4.
-
Klatovský, Karel. Microsoft PowerPoint 2010 nejen pro školy. Vyd. 1. Kralice na Hané : Computer Media, 2010. ISBN 978-80-7402-077-3.
-
Navarrů Miroslav. Excel 2019. Grada, 2019. ISBN 978-80-247-2026-5.
-
Pecinovský, Josef; Pecinovský, Rudolf. Excel 2010 : podrobný průvodce. 1. vyd. Praha : Grada, 2010. ISBN 978-80-247-3496-5.
-
Pecinovský Josef, Pecinovský Rudolf. Office 2019 - Průvodce uživatele. Grada, 2019. ISBN 978-80-247-2303-7.
-
Pírková, Kateřina. Microsoft Word 2010 : podrobná uživatelská příručka. Vyd. 1. Brno : Computer Press, 2010. ISBN 978-80-251-3033-9.
|