Course detail

Economic practicum

FP-KepPAcad. year: 2023/2024

This course introduces students to managerial calculations and economic analyses using a spreadsheet program MS Excel 2002. All areas of practical examples will be solved by the form of case studies.

Language of instruction

Czech

Number of ECTS credits

3

Mode of study

Not applicable.

Entry knowledge

Knowledge of economic subjects obtained in one’s study to date, especially from the subject of Business economics, computer skills, and knowledge of the spreadsheet program of Microsoft Excel 2010 are expected.

Rules for evaluation and completion of the course


                             


The participation on concentration trainings.
The continuous preparation for concentration trainings (self study from literature.
Working on the exercises.

Aims

Aim of the course is to deepen students' ability to classify, analyze, and present information in response to specific decision-making tasks. This subject directly relates to the knowledge that students gained in the economically-oriented subjects within their studies. After a successful completion of this course, students will be able to use MS Excel for the purposes of managerila calculations and economic analyses.

The student applies the theoretical knowledge gained from the previous study of economic subjects in bachelor study and is able to solve practical economic and managerial tasks using computer technology.

Study aids

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

KOCMANOVÁ, A. Ekonomické řízení podniku. Praha: Linde Praha, 2013, 358 s. ISBN 978-80-7201-932-8.
SYNEK, M. Manažerská ekonomika. 5.vyd. Praha: Grada Publishing, 2011. 471 s. ISBN 978-80-247-3494-1.
BROŽ, M. Microsoft Excel 2007 pro manažery a ekonomy. 1.vyd. Praha: CP Books, 2009. 435 s. ISBN 978-80-251-2116-0.
SYNEK, M.; KOPKÁNĚ, H.; KUBÁLKOVÁ, M. Manažerské výpočty a ekonomická analýza. V Praze: C.H. Beck, 2009, xviii, 301 s. : il. 1 CD-ROM. ISBN 978-80-7400-154-3.

Recommended reading

BÁRTA, Z. Finanční gramotnost: výpočty v Excelu. Praha: Wolters Kluwer, 2014, 370 s. ISBN 978-80-7478-483-5.

Classification of course in study plans

  • Programme BAK-EP Bachelor's, 2. year of study, summer semester, elective

Type of course unit

 

Exercise

26 hours, compulsory

Teacher / Lecturer