|
Lecturer(s)
|
-
Zikmundovská Eva, Ing.
-
Vít Václav, Ing.
-
Marek Vladislav, doc. RNDr. Ph.D.
-
Vácha Peter, Ing. Mgr. Ph.D.
-
Prchlík Jana, Ing.
-
Havránková Zuzana, Ing. Ph.D.
|
|
Course content
|
Introduction of the course Import and checking of the input data Work with lists Contingency table Sensitivity analysis Simulation Macros Economic functions Comprehensive sample
|
|
Learning activities and teaching methods
|
Practicum
- Preparation for comprehensive test (10-40)
- 35 hours per semester
- unspecified
- 40 hours per semester
- Contact hours
- 26 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| Control basic knowledge of MS office. |
| Skills |
|---|
| Master the basics of working in MS Office. |
| Competences |
|---|
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| Gain advanced knowledge of MS Excel software. |
| Skills |
|---|
| Solve economic tasks in MS office. |
| Competences |
|---|
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Practicum |
| Skills |
|---|
| Practicum |
| Competences |
|---|
| Practicum |
| assessment methods |
|---|
| Knowledge |
|---|
| Skills demonstration during practicum |
| Seminar work |
| Skills |
|---|
| Seminar work |
| Competences |
|---|
| Seminar work |
|
Recommended literature
|
-
Milan Brož, Václav Bezvoda. Microsoft Excel 2007: pro manažery a ekonomy. Brno, 2009. ISBN 978-80-251-2116-0.
-
Milan Brož, Václav Bezvoda. Microsoft Excel 2007/2010: vzorce, funkce, výpočty. Brno, 2011. ISBN 978-80-251-3267-8.
-
Navarrů, Miroslav. Excel 2016 : podrobný průvodce uživatele. První vydání. 2016. ISBN 978-80-271-0193-1.
-
Winston, Wayne L. Microsoft Excel 2010 : data analysis and business modeling. Redmond : Microsoft Press, 2011. ISBN 978-0-7356-4336-9.
|