RSb021 Electronic Agenda

Faculty of Arts
Autumn 2020
Extent and Intensity
0/2/0. 5 credit(s). Type of Completion: z (credit).
Teacher(s)
Mgr. Bc. Zbyněk Michálek (seminar tutor)
Guaranteed by
Mgr. Bc. Zbyněk Michálek
Department of Slavonic Studies – Faculty of Arts
Contact Person: doc. PhDr. Jiří Gazda, CSc.
Supplier department: Department of Slavonic Studies – Faculty of Arts
Timetable of Seminar Groups
RSb021/01: Wed 16:00–17:40 G21, Z. Michálek
RSb021/02: Wed 14:00–15:40 G21, Z. Michálek
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The main aim of the course is to teach students how to effectively and safely work with computer and to manage operations that are necessary in commercial practice, public administration and so on. This is primarily a matter of more advanced work with text and table processors and with presentation tools, making use of cloud services, searching data and materials (images, videos) on the internet and their following use or processing (editing, conversion), effective and safe administration of operating system, software and e-mail (actualization, back up).
Learning outcomes
After finishing the course, the student will:
- more effectively work with text and table processor;
- know advantages and disadvantages of online (cloud) services and will know how to work with them;
- know the principles of creating multimedia presentations;
- be able to convert various formats (of pictures, videos, sounds, …);
- be able to download necessary materials from the internet (pictures, videos, sounds) and then to work with them;
- be able to effectively surf the internet;
- know the principles of safe work with computer;
- effectively and safely work with e-mail;
- manage the principles of ordinary computer administration (OS and software actualization, disk back-up, …).
Syllabus
  • 1. Advanced operations in word processors (predominantly MS Word): content generation, styles, indices, mail merge, page break, sections, track changes, comparing two documents, insert pictures, page numbering, macros, …; possibilities and limits of using regular expressions (wildcard characters); keyboard shortcuts;
  • 2. advanced operations in table processors (predominantly MS Excel): cells formatting, formulas, functions, graphs, …;
  • 3. presentation tools (predominantly MS PowerPoint): principles of presentation creating, insert pictures, settings of transitions between slides, …;
  • 4. familiarization with Google Docs, LibreOffice, OpenOffice (advantages/disadvantages); cloud back-up (Google Drive, OneDrive);
  • 5. conversion between various formats (pictures, videos, sounds, PDF, …); downloading videos form the internet (YouTube etc.), extraction of soundtrack; pictures downloading and editing; OCR; virtual printers;
  • 6. surfing the internet (Google – pictures, advanced search, …), internet dictionaries and translators use; possibilities of downloading materials form various online web back-ups (like ulozto.cz, torrents etc.) and its legal effects;
  • 7. safety and privacy protection on the internet (browser settings, anonymous browsing, anti-virus software, passwords, …);
  • 8. working with e-mail (POP3 and IMAP protocols, sending attachments, sending large files, message filters, …);
  • 9. file compression and decompression (MS Windows, Total Commander, ALZip); installation and uninstallation of programs, disk cleanup;
  • 10. actualization of operating system (MS Windows), programs; disk and computer back-ups.
  • The list of areas is only orientational. Putting further topics according to student’s knowledge and needs during semester is allowed.
Literature
  • ŽITNIAK, Ján. Microsoft Office 2016 : podrobná uživatelská příručka. 1. vydání. Brno: Computer Press, 2017, 528 stran. ISBN 9788025148914. info
  • KOŽÍŠEK, Martin and Václav PÍSECKÝ. Bezpečně n@ internetu : průvodce chováním ve světě online. První vydání. Praha: Grada Publishing, 2016, 175 stran. ISBN 9788024755953. URL info
  • PECINOVSKÝ, Josef. Office 2016 : průvodce uživatele. Praha: Grada, 2016. 256. ISBN 978-80-247-5691-2. info
  • NAVRÁTIL, Pavel and Michal JIŘÍČEK. S počítačem nejen k maturitě. 9th ed. Prostějov: Computer Media, 2016. ISBN 978-80-7402-253-1. info
  • NAVRÁTIL, Pavel and Michal JIŘÍČEK. S počítačem nejen k maturitě. 2. díl. 9th ed. Prostějov: Computer Media, 2016. ISBN 978-80-7402-253-1. info
  • PECINOVSKÝ, Josef. 1001 tipů a triků pro Microsoft Windows 10. Brno: Computer Press, 2016, 376 pp. ISBN 978-80-251-4685-9. info
  • KRÁL, Mojmír. Bezpečný internet : chraňte sebe i svůj počítač. První vydání. Praha: Grada Publishing, a.s., 2015, 183 stran. ISBN 9788024754536. URL info
  • HERODEK, Martin. Microsoft Windows 10 : podrobná uživatelská příručka. 1. vydání. Brno: Computer Press, 2015, 297 stran. ISBN 9788025145951. info
  • PETROWSKI, Thorsten. Bezpečí na internetu pro všechny. Translated by Tomáš Kurka. Vyd. 1. Liberec: Dialog, 2014, 241 s. ISBN 9788074240669. info
  • CHÁBERA, Jiří. ECDL : průvodce přípravou na testy. 1. vyd. Brno: Computer Press, 2012, 200 s. ISBN 9788025131442. info
  • BLINKA, Aleš. Jak na dlouhé dokumenty ve Wordu 2007/2010, aneb, Píšeme diplomku, bakalářku, knihu, manuál, normu, výroční zprávu či jiný delší text. Vyd. 1. Brno: Akademické nakladatelství CERM, 2012, 163 s. ISBN 9788072047864. info
  • LACKO, Ľuboslav. Osobní cloud pro domácí podnikání a malé firmy. 1. vyd. Brno: Computer Press, 2012, 270 s. ISBN 9788025137444. info
  • LAPÁČEK, Jiří. Počítač pro seniory : vydání pro Windows 7 a Office 2010 : [Windows, Word, Excel, Internet]. Vyd. 1. Brno: Computer Press, 2011, 216 s. ISBN 9788025133972. info
  • FRANCŮ, Marie. Jak zvládnout testy ECDL. 3. aktual. a rozšíř. vyd. Brno: Computer Press, 2009, 176 s. ISBN 9788025126530. info
  • ROUBAL, Pavel. Počítač pro učitele. Vyd. 1. Brno: Computer Press, 2009, 312 s. ISBN 9788025122266. info
  • DUSÍKOVÁ, Tereza. Počítač pro ženy. Praktický průvodce pro práci, studium i zábavu. 2008th ed. Brno: Computer Press, 2008, 280 pp. ISBN 978-80-251-2029-3. info
  • LAPÁČEK, Jiří. Počítač pro živnostníky a podnikatele. Vydání první. Brno: Computer Press, 2008, 392 pp. ISBN 978-80-251-2220-4. info
  • LAPÁČEK, Jiří. Počítač v domácnosti : podrobný průvodce pro práci, zábavu i vzdělávání. Vyd. 1. Brno: Computer Press, 2006, 366 s. ISBN 8025110478. info
  • LAPÁČEK, Jiří. Počítač v kanceláři. Vyd. 1. Brno: Computer Press, 2006, 320 s. ISBN 8025112098. info
Teaching methods
The course has a form of practical exercises with the computer (either in computer classroom or with student’s own computer).
Assessment methods
The course contents pure practical exercises on the computer, so the attendance is compulsory. Two absences, not including the introductory lecture, are allowed. For passing the credit the student should successfully complete the final practical tasks and the test (minimum of 70%).
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Autumn 2021, Autumn 2022, Autumn 2023.
  • Enrolment Statistics (Autumn 2020, recent)
  • Permalink: https://is.muni.cz/course/phil/autumn2020/RSb021