Course detail
Methods for Solving Managerial Tasks
FP-MRMUAcad. year: 2022/2023
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
Number of ECTS credits
Mode of study
Guarantor
Department
Learning outcomes of the course unit
Students will acquire knowledge and skills to support managerial decision-making using common office applications and effective work with data.
Prerequisites
Co-requisites
Planned learning activities and teaching methods
Teaching takes place in the form of lectures, which have the character of explaining the discipline, content, terms, structure, methods and practical examples.
The exercises are focused on the development of practical skills in connection with the lectured topics.
Assesment methods and criteria linked to learning outcomes
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).
Course curriculum
01. System Approach for Solving Managerial Tasks (system and its modelling, analysis and simulation).
02. Use of Models in Managerial Practice (tabular, non-tabular and graphic models, engineering tables in MS Excel).
03. Use of MS Excel to Solve Managerial Tasks
04. Working with Data in MS Excel (Common tools and PowerPivot add-on)
05. Data Analysis in PowerPivot for MS Excel
06. DAX and Its Use
07. Working with Data in MS Power BI
08. Data analysis in MS Power BI
09. Advanced work with MS Power BI (own visualization, R language, ...)
10. - 12. Selected Optimization and Analysis Tasks (Case studies + involvement of experts from practice)
13. Interpretation of Outputs for Managers
Work placements
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 effective work with data.
Specification of controlled education, way of implementation and compensation for absences
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.
Recommended optional programme components
Prerequisites and corequisites
Basic literature
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
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.
Elearning
Classification of course in study plans
- Programme BAK-MIn Bachelor's 2 year of study, summer semester, compulsory
Type of course unit
Lecture
Teacher / Lecturer
Syllabus
- System Approach for Solving Managerial Tasks
- Use of MS Excel to Solve Managerial Tasks
- Effective Work with Data in MS Excel
- Use of MS Power BI to Solve Managerial Tasks
- Selected Optimization and Analysis tasks
- Interpretation of Outputs for Managers
Exercise
Teacher / Lecturer
Syllabus
01. System Approach for Solving Managerial Tasks (system and its modelling, analysis and simulation).
02. Use of Models in Managerial Practice (tabular, non-tabular and graphic models, engineering tables in MS Excel).
03. Use of MS Excel to Solve Managerial Tasks
04. Working with Data in MS Excel (Common tools and PowerPivot add-on)
05. Data Analysis in PowerPivot for MS Excel
06. DAX and Its Use
07. Working with Data in MS Power BI
08. Data analysis in MS Power BI
09. Advanced work with MS Power BI (own visualization, R language, ...)
10. - 12. Selected Optimization and Analysis Tasks (Case studies + involvement of experts from practice)
13. Interpretation of Outputs for Managers
Elearning