Course: Economic applications in Excel

« Back
Course title Economic applications in Excel
Course code KEM/EAE
Organizational form of instruction Tutorial
Level of course Bachelor
Year of study not specified
Semester Winter and summer
Number of ECTS credits 3
Language of instruction Czech
Status of course unspecified
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Svoboda Milan, Ing. Mgr. 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
  • unspecified - 26 hours per semester
  • Contact hours - 26 hours per semester
  • Undergraduate study programme term essay (20-40) - 26 hours per semester
prerequisite
professional knowledge
The course supposes the basic knowledge of MS Excel in range of the course Fundamentals of Informatics.
learning outcomes
Student is in the program MS Excel able to: - perform economic calculation, - perform a sensitivity analysis and work with the scenario, - use the financial and accounting functions, - work with lists and contingency tables.
teaching methods
Practicum
assessment methods
Skills demonstration during practicum
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.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester