Course detail

Methods for Solving Managerial Tasks

FP-MRMUAcad. year: 2024/2025

Students will primarily acquire knowledge and skills enabling effective analysis and transformation of source data into information usable in managerial decision-making, including subsequent interpretation (presentation) of results. At the same time, practical skills are developed using MS Office applications (with the main focus on MS Excel) for solving practical tasks and case studies.

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

Ing. Jan Luhan, Ph.D., MSc

Department

Institute of Informatics (ÚI)

Entry knowledge

Basic knowledge of the use of office applications is assumed. Good knowledge of data modelling, database systems and principles of algorithmization and programming is an advantage.

Rules for evaluation and completion of the course

To get a Unit-course credit, you need to get at least 50% of the points divided between activity (10 points), Tests (15 points), and Semester project, including its defence (25 points).

The exam consists of a practical and an oral part, while the resulting classification of the subject is according to the ECTS scale.

Completion of the course for students with an individual study plan:
Development and defence of a Semester project for Unit-course credit;
Standard exam (practical and oral part).

Attendance is controlled in predetermined terms related to the project's implementation or tests. Attendance in lectures and exercises is not obligatory but recommended. Students prove their activity by completing tasks for which they earn points for assessment.

Aims

To acquaint the listeners with the possibilities and tools that can be used in managerial decision-making with a focus on increasing the efficiency of the entire process based on efficient work with data.

Students will acquire knowledge and skills to support managerial decision-making using standard office applications and efficient work with data.

Study aids

The study materials and additional resources are concentrated in the e-learning of the subject.

Prerequisites and corequisites

Not applicable.

Basic literature

BEZVODA, V. A M. BROŽ. Microsoft Excel 2007 pro manažery a ekonomy. 5. vyd. Brno: Computer Press, 2012. 440 s. ISBN 978-80-251-2116-0.
SÝKOROVÁ, K., J. BARILLA A P. SIMR. Microsoft Excel 2016: Podrobná uživatelská příručka. 1.vyd. Brno: Computer Press, 2016. 456 s. ISBN 978-80-251-4838-9.
ŽITNIAK, J. Microsoft Office 2016: Podrobná uživatelská příručka. 1. vyd. Brno: Computer Press, 2017. 528 s. ISBN 978-80-251-4891-4.

Recommended reading

MYŠÁK, M. Kontingenční tabulky a grafy: Výukový průvodce. 1. vyd. Brno: Computer Press, 2013. 224 s. 978-80-251-4113-7.
RALSTON, B. PowerPivot for Business Intelligence Using Excel and Sharepoint Berkeley: Apress, 2011. 299 p. ISBN 978-1-4302-3380-0.
RUSSO, M. and A. FERRARI. Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Washington: Microsoft Press, 2017. 250 p. ISBN 978-1-5093-0276-5.
RUSSO, M. and A. FERRARI. The Definitive Guide to DAX: Business Intelligence with Microsoft Excel, SQL Server Analysis Services and Power BI. Washington: Microsoft Press, 2015. 1182 p. ISBN 978-0-7356-9835-2.
WINSTON, W. L. Microsoft Excel 2013: Data Analysis and Business Modeling. 1st ed. California: O’Reilly Media, Inc., 2014. 889 p. ISBN 978-0-7356-6913-0.

Classification of course in study plans

  • Programme BAK-MIn Bachelor's 2 year of study, summer semester, compulsory

Type of course unit

 

Lecture

13 hod., optionally

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc

Exercise

26 hod., compulsory

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc