|
Lecturer(s)
|
-
Šmrhová Anežka, Ing.
-
Neupauer Yevgeniy, doc. Ing. Ph.D.
|
|
Course content
|
The course is focused on the use of advanced features for processing bulk documents and advanced features for processing and analyzing data using a spreadsheet application with the use of the MS Office (MS Word and MS Excel). 1. Organization of the course 2. MS Word - basics repetition, mail merge - generating na envelope 3. MS Word - mail merge - template and merge, developer - form, tabs, controls, editing large documents 4. MS Excel - basics repetition 5. MS Excel - custom formatting using condition, pivot tables + charts, charts 6. MS Excel - mathematical and statistical functions 7. MS Excel - search and database functions 8. MS Excel - text and time functions 9. MS Excel - estimations, hypothesis testing 10. MS Excel - correlation, regression
|
|
Learning activities and teaching methods
|
Discussion, Instruction based on dialogue, Students' portfolio
- Presentation preparation (report) (1-10)
- 10 hours per semester
- Individual project (40)
- 40 hours per semester
- Contact hours
- 30 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| have a basic knowledge of MS Word |
| have a basic knowledge of MS Excel |
| have a basic knowledge of MS Powerpoint |
| Skills |
|---|
| is able to work with MS Word at the basic level |
| is able to work with MS Excel at the basic level |
| is able to work with MS Powerpoint at the basic level |
| Competences |
|---|
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| to know more advanced functionality of MS Word |
| to know more advanced functionality of MS Excel |
| describe an advanced technical problem in a spreadsheet environment |
| Skills |
|---|
| complexly analyze technical problems using a spreadsheet |
| process large-scale text documents efficiently |
| use more advanced functions in MS Excel |
| Competences |
|---|
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Discussion |
| Lecture with visual aids |
| E-learning |
| Multimedia supported teaching |
| Students' portfolio |
| Interactive lecture |
| Self-study of literature |
| Individual study |
| Collaborative instruction |
| Skills |
|---|
| Skills demonstration |
| Interactive lecture |
| Practicum |
| 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 |
| Project |
| Competences |
|---|
| Seminar work |
|
Recommended literature
|
-
Benáčanová, Helena. Tvorba aplikací v MS Excel : materiály ke cvičení. Vyd. 1. Praha : Oeconomica, 2005. ISBN 80-245-0953-9.
-
Kateřina Mičudová, Mikuláš Gangur, Milan Svoboda, Pavla Říhová. Základy statistiky a pravděpodobnosti. Západočeská univerzita v Plzni, 2016. ISBN 978-80-261-0660-9.
-
Laurenčík Marek. Excel 2016- Práce s databázemi a kontingenčními tabulkami. Grada, 2017. ISBN 978-80-271-0477-2.
-
Pecinovský Josef, Pecinovský Rudolf. Office 2019 - Průvodce uživatele. Grada, 2019. ISBN 978-80-247-2303-7.
-
Wewerka Peter. Office 2019 all-in-one. Hoboken, NJ: John Wiley & Sons, 2019. ISBN 978-1-119-51327-8.
|