Course detail

Methods for Solving Managerial Tasks

FP-MRMUAcad. year: 2023/2024

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

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.
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.
Ž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.
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.
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.
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.
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.

eLearning

eLearning: currently opened course

Classification of course in study plans

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

Type of course unit

 

Lecture

13 hours, optionally

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc

Syllabus

01. System Approach for Solving Managerial Tasks
02. Use of Basic Tools and Functions for Solving Managerial Tasks and Their Interpretation
03. Working with Data and Data Models
04. Effective Data Analysis
05. Selected Optimization and Analysis tasks
06. Processing Outputs for Managers

Exercise

26 hours, compulsory

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc

Syllabus

01. System Approach for Solving Managerial Tasks
02. Models in Managerial practice (tabular, non-tabular and graphic models, engineering tables in MS Excel).
03.-04. Formulas and Functions for Solving Managerial Tasks (composite and combined functions, matrix formulas, use of selected functions for solving managerial tasks).
05. Graphs and Their Use (creation, analysis and use of graphs in the work of a manager).
06. Work with Data (imports, exports, linking, input data validation, conditional formatting and data transformation).
07.-08. Data Analysis (work with filters, lists, summaries, pivot tables, PowerPivot).
09.-10. Selected Optimization and Analytical Tasks (sensitivity analysis, work with scenarios, use of the Solver and MS Excel analytical add-ons).
11.-12. Solving Selected Mathematical Problems (derivatives, integrals, systems of equations and differential equations in MS Excel).
13. Processing of Outputs for Managers (use of advanced tools and functions of MS Word and MS PowerPoint for effective manager work).

eLearning

eLearning: currently opened course