| Course Unit Code | 545-0157/01 |
|---|
| Number of ECTS Credits Allocated | 3 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Third Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| SOU70 | RNDr. Radmila Sousedíková, Ph.D. |
| ROL74 | Ing. Markéta Laštůvková, Ph.D. |
| Summary |
|---|
| The subject concerns modern working processes in Microsoft Office and their application to written professional text, presentation and economic analysis in raw-materials industry with spreadsheet. |
| Learning Outcomes of the Course Unit |
|---|
| Generating knowledge concerning modern working processes in Microsoft Office, application to written professional text, simple economic analysis with spread sheet in raw-materials industry. |
| Course Contents |
|---|
1. Word, principles of creating text documents, advanced techniques (working with sections, use of styles)
2. Word, working with tables, graphic editing, inserting and editing images, writing formulas in text
3. Word, advanced techniques (titles of tables and figures, footnotes, cross-references, generation of content, list of tables and figures)
4. Word, editing of documents processed by word processors - standard ČSN 01 6910 (2014)
5. Instructions for Bachelor's thesis writing – work organization, structure and range of thesis
6. Instructions for Bachelor's thesis writing – formal requirements
7. Excel, graph creation and modification – application to technical and production indicators of mining company
8. Excel, trend analysis of technical and production indicators of mining company
9. Excel, mining company financial analysis – horizontal and vertical analysis
10. Excel, mining company financial analysis – financial ratio calculation
11. Excel, investment project efficiency in mining company
12. Excel, financial investment in mining company
13. Excel, smoothing of time series of mining company stock prices
|
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
MAYES, Timothy R. Financial analysis with Microsoft Excel 2019. 9th edition. Boston: Cengage, 2021. ISBN 978-0357-44205-0.
CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. Upper Saddle River: Pearson Education, 2019. ISBN 978-0-7897-5958-0.
LAMBERT, Joan. Microsoft Office 2019 Step by Step. Microsoft Press U.S., 2018. ISBN 9781509307685.
LAMBERT, Joan. Microsoft Word 2019 Step by Step. Microsoft Press U.S., 2019. ISBN 978150930587. |
PECINOVSKÝ, Josef. Microsoft Word 2013: podrobná uživatelská příručka. Brno: Computer Press, 2013. ISBN 978-80-251-3831-1.
PECINOVSKÝ, Josef. Excel 2013: podrobný průvodce. Praha: Grada Publishing, 2013. ISBN 978-80-247-4729-3.
SOUSEDÍKOVÁ, Radmila. Aplikace VT pro manažery II: e-learningová opora.
MELTON, Beth et al. Microsoft Office Professional 2013: Step by Step. Sebastopol, Calif.: O'Reilly Media, 2013. xxix, 1184 p. ISBN 9780735669413. |
| Recommended Reading: |
|---|
WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. New York: Pearson Education, 2019. ISBN 978-1-5093-0588-9.
LAMBERT, Joan. Microsoft Word 2016 Step by Step. Microsoft Press, 2015. ISBN 9780735699236.
MELTON, Beth et al. Microsoft Office Professional 2013: Step by Step. Sebastopol, Calif.: O'Reilly Media, 2013. ISBN 9780735669413.
MURRAY, Katherine. Microsoft Office Professional 2013. Sebastopol, Calif.: O'Reilly Media, 2013. ISBN 9780735669321. |
PECINOVSKÝ, Josef. Microsoft Office 2013: podrobná uživatelská příručka. Brno: Computer Press, 2013. ISBN 978-80-251-4102-1.
ČSN 01 6910 (2014). Úprava dokumentů zpracovaných textovými procesory. Praha: Český normalizační institut.
ŠIMEK, Tomáš. Word 2013: podrobný průvodce. Praha: Grada Publishing, 2013. ISBN 978-80-247-4730-9.
MURRAY, Katherine. Microsoft Office Professional 2013. Sebastopol, Calif.: O'Reilly Media, 2013. 472 p. ISBN 9780735669321. |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Graded credit | Graded credit | 100 (100) | 51 |
| semestrální projekt | Semestral project | 15 | 8 |
| semestrální projekt | Semestral project | 10 | 6 |
| prezentace | Other task type | 5 | 3 |
| písemný test | Written test | 70 | 34 |