| Course Unit Code | 545-0144/01 |
|---|
| 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 |
|---|
| ROL74 | Ing. Markéta Laštůvková, Ph.D. |
| SVU008 | Ing. Jiří Švub, Ph.D. |
| Summary |
|---|
| Students will learn to use Word for writing semestral papers, Bachelor and Master theses, Excel for the creation of economic models, application of economic and financial analysis and Powerpoint for presentation of the results. |
| Learning Outcomes of the Course Unit |
|---|
| The aim of the course is to obtain professional knowledge of Microsoft Office and know how to apply them in economic practice. |
| Course Contents |
|---|
1. Preparation of a document in Word - document structure (size, margins, headers, footers, sections, paragraphs, fonts, styles, windows, navigation), edit of text, spelling, grammar, the mail merge.
2. Operation with tables (creation, automatic subtitling, calculations), citations, cross-references, indexes, footnotes, the equation editor.
3. Revision of the document-tracking changes, acceptance/rejection of the changes, comments, translations.
4. Preparation of the document in Excel - document structure (size, orientation, margins, header, footer), font, formatting, conditional formatting, windows.
5. Operations with the data in Excel - sorting, grouping, filtering, separation, summary, search.
6. Operations with tables and graphs, the equation editor.
7. Matrix calculations in Excel.
8. Operations with functions in Excel - financial functions.
9. Operations with functions in Excel - mathematical functions for economists.
10.Operations with functions in Excel - statistical functions (descriptive statistics, distribution function, probability density function).
11.Operations with functions in Excel – the search functions, the information functions and the text functions.
12.Operations with functions in Excel - database functions.
13.Operations with functions in Excel - logical functions.
14.Creation of PowerPoint presentations.
|
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
BOYCE, Jim, PIERCE, John, ed. 2007 Microsoft Office system inside out [CD-ROM]. Redmond: Microsoft Press, c2007. ISBN 978-0-7356-2324-8.
CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. [Upper Saddle River]: Pearson Education. ISBN 978-0-7897-5958-0.
ANDERSON, David Ray, Dennis J. SWEENEY a Thomas Arthur WILLIAMS. Modern business statistics with Microsoft Office Excel. 5th ed. Stamford: Cengage Learning. ISBN 978-1-305-08218-2.
KVANLI, Alan H., Robert J. PAVUR a Kellie B. KEELING. Introduction to business statistics: a Microsoft Excel integrated approach. 6th ed. Mason: Thomson South-Western. ISBN 0-324-27156-5. |
ANDRÝSKOVÁ, Jana. Microsoft PowerPoint: podrobná uživatelská příručka. Brno: Computer Press, 2010. ISBN 978-80-251-3076-6.
BENNINGA, Simon. Principles of finance with Excel. 2nd ed. New York: Oxford University Press, 2011. ISBN 978-0-19-975547-9.
ČERNÝ, Igor. Počítačové praktikum pro manažery-studijní opora. 2018. 238 s. Dostupné z: https://lms.vsb.cz/
MATÚŠ, Zdeněk. Word: sbírka příkladů. Praha: BEN - technická literatura, 2002. ISBN 80-7300-071-7. |
| Recommended Reading: |
|---|
BORLAND, Russell. Microsoft Word 97 advanced topics step by step. Redmont: Microsoft Press. ISBN 1-57231-563-6.
BENNINGA, Simon a Tal MOFKADI. Principles of finance with Excel. Third edition. New York: Oxford University Press. ISBN 978-0-19-029638-4.
KUSLEIKA, Dick. Data visualization with Excel dashboards and reports. Indianapolis, Indiana: Wiley. ISBN 978-1-119-69872-2.
CHATFIELD, Carl S. a Timothy D. JOHNSON. Microsoft Office Project 2007 step by step. Redmond: Microsoft Press. Step by step (Microsoft Press). ISBN 978-0-7356-2305-7. |
ATKINSON, Cliff. Působivé prezentace v PowerPointu 2007. Přeložil Jiřina Šetková. Brno: Computer Press, 2008. ISBN 978-80-251-2119-1.
LAURENČÍK, Marek. Excel pro management, ekonomy a podnikatele. Kralice na Hané: Computer Media, 2012. ISBN 978-80-7402-096-4.
LAURENČÍK, Marek. Excel 2013: práce s databázemi a kontingenčními tabulkami. Praha: Grada Publishing, 2014. ISBN 978-80-247-5003-3.
MATÚŠ, Zdeněk. Excel 2007-2010 v příkladech. Vyd. 2. Kralice na Hané: Computer Media, 2011. ISBN 978-80-7402-073-5. |
| Planned learning activities and teaching methods |
|---|
| Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit | Credit | 100 | 51 |