| Course Unit Code | 545-0176/01 |
|---|
| Number of ECTS Credits Allocated | 4 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | Second 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 |
|---|
| CER25 | Ing. Igor Černý, Ph.D. |
| ROL74 | Ing. Markéta Laštůvková, Ph.D. |
| Summary |
|---|
The course develops and deepens basic knowledge and skills about the environment of the MS Excel spreadsheet calculator. The subject focuses on advanced MS Excel features and techniques, including basic macro programming. The student will be able to apply the acquired theoretical knowledge in solving practical technical and economic tasks from the environment of the mining company.
|
| Learning Outcomes of the Course Unit |
|---|
| The aim of the course is to be able to explain the advanced functions and techniques of MS Excel and to be able to apply this knowledge in solving practical technical and economic tasks from the mining company environment. |
| Course Contents |
|---|
1. MS Excel environment
2. Advanced formatting and editing techniques
3. Formula creation and data analysis
4. Advanced techniques of data processing
5. Database and list management
6. Analyzing data using PivotTables
7. Using macros
8. Collaboration in MS Excel
9. MS Excel application in benchmarking
10.MS Excel application in inventory management
11.MS Excel applications in project management
12.MS Excel applications in economic modeling
13.MS Excel applications in statistical applications |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
ALEXANDER, Michael a Dick KUSLEIKA. Excel 2016 Power Programming with VBA. Indianapolis, IN: Wiley. Mr. Spreadsheet's bookshelf. ISBN 9781119415503.
DECOURSEY, William,James. Statistics and probability for engineering applications: with Microsoft Excel. Amsterdam: Elsevier, 2007. ISBN 978-0-7506-7618-2.
HÄCKER, Joachim a Dietmar ERNST. Financial modeling: an introductory guide to Excel and VBA applications in finance. London: Palgrave Macmillan. Global financial markets. ISBN 9781137426581.
MAYES, Timothy R. Financial analysis with Microsoft Excel 2019. 9th edition. Boston: Cengage. ISBN 978-0357-44205-0. |
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: |
|---|
ANDERSON, David Ray, Dennis J. SWEENEY a Thomas Arthur WILLIAMS. Modern business statistics with Microsoft Office Excel. 4th ed. Mason: South-Western Cengage Learning. ISBN 978-0-538-47976-9.
BENNINGA, Simon. Principles of finance with Excel. 2nd ed. New York: Oxford University Press. ISBN 978-0-19-975547-9.
FAIRHURST, Danielle Stein. Using Excel for business and financial modelling: a practical guide. Third edition. Chichester, United Kingdom: Wiley. Wiley finance series. ISBN 9781119520375.
PERSON, Ron. Balanced Scorecards and operational dashboards with Microsoft Excel. Indianapolis: Wiley, c2009. ISBN 978-0-470-38681-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 |
|---|
| Lectures, 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 |
|---|
| Graded credit | Graded credit | 100 (100) | 51 |
| Zápočtové testy | Other task type | 100 | 51 |