| Course Unit Code | 541-0277/05 |
|---|
| Number of ECTS Credits Allocated | 2 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | First Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | There are no prerequisites or co-requisites for this course unit |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| POR041 | Ing. Michal Matloch Porzer, Ph.D. |
| Summary |
|---|
| Algorithm – processor – computer. Hardware and software of personal computer. The development of operating systems – MS DOS, MS Windows. Computer networks – the Internet, World Wide Web. The creation documents in the text editor MS Word. Use of spreadsheets (MS Excel) for creation tables and graphs. |
| Learning Outcomes of the Course Unit |
|---|
| This course is dedicated to fundamentals of operating systems, computer networks, creation of documents in the text editor and use of spreadsheets for creation of tables and graphs. These problems can arise from other courses as well as from practice. |
| Course Contents |
|---|
1. Implementing an algorithm on a computer.
2. How a computer works -- the principle of a digital computer.
3. Personal computer hardware.
4. Personal computer software.
5. Operating Systems - MS DOS.
6. Operating Systems - MS Windows.
7. Local and remote computer networks. The Internet and its services, the World Wide Web.
8. Writing and processing texts in MS Word text editor – basic controls, working with files.
9. MS Word – working with blocks, formats.
10. MS Word – working with styles, tables, etc.
11. Creating tables and charts in MS Excel.
12. MS Excel - basic controls, writing data, formulas, working with files.
13. MS Excel– editing a table, working with blocks, formats.
14. MS Excel– Table Appearance, Charting. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
| Up-to-date computer literature (MS Windows, MS Word and MS Excel). |
PECINOVSKÝ, Josef a Rudolf PECINOVSKÝ. Office 2019: & Office 365 : průvodce uživatele. Praha: Grada Publishing, 2019. Průvodce (Grada). ISBN 978-80-247-2303-7.
KRUCZEK, Aleš. Microsoft Office Access 2007: podrobná uživatelská příručka. Brno: Computer Press, 2007. ISBN 978-80-251-1608-1.
NOVOTNÝ, Petr. CorelDRAW X4: praktická příručka. Praha: Grada Publishing, 2009. Průvodce (Grada). ISBN 978-80-247-2746-2.
ANDERSON, David Ray, Dennis J. SWEENEY a Thomas Arthur WILLIAMS. Modern business statistics with Microsoft Office Excel. 5th ed. Stamford: Cengage Learning, c2015. ISBN 978-1-305-08218-2.
|
| Recommended Reading: |
|---|
MS Office programs books
http://bookboon.com/en/office-ebooks |
KLATOVSKÝ, Karel. 333 tipů a triků pro Microsoft Office 2013. Kralice na Hané: Computer Media, 2013. ISBN 978-80-7402-147-3.
HYNDRÁK, Karel. Microsoft Office Project: hotová řešení. Brno: Computer Press, 2007. K okamžitému použití. ISBN 978-80-251-1681-4.
BOYCE, Jim, PIERCE, John, ed. 2007 Microsoft Office system inside out. Redmond: Microsoft Press, c2007. Inside out. ISBN 978-0-7356-2324-8.
BOUTON, Gary David. CorelDRAW X4: the official guide. New York: McGraw-Hill, c2008. ISBN 978-0-07-154570-9. |
| Planned learning activities and teaching methods |
|---|
| Tutorials, Project work |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit | Credit | 85 | 85 |