Course detail

Advanced Methods for Solving Managerial Tasks

FP-PMMUAcad. year: 2019/2020

The course focuses mainly on the following areas: System approach for solving managerial problems (system and its modelling, analysis and simulation). Use of models in managerial practice (spreadsheet, netbook and graphical models, engineering tables in MS Excel). Using formulas and functions to solve managerial tasks. Using folded and combined functions to solve managerial tasks. Graphs and their use (creation, analysis and use of graphs in the work of the manager). Working with data (import, export, linking, input data authentication, conditional formatting and data transformation). Data analysis (working with filters, lists, summaries and pivot tables). Using PowerPivot to analyse and work with data. Selected analytical tasks (sensitivity analysis and work with scenarios, ...). Utilization and solution of optimization tasks (use of MS Excel analyser and analytical tools). Solving of selected mathematical problems (derivatives, integrals, equation systems and differential equations in MS Excel). Using interconnection and integration of applications to automate the solution of managerial tasks. Managing Outputs for Managers (using advanced MS Word and MS PowerPoint tools and functions for effective manager work).

Language of instruction

Czech

Number of ECTS credits

4

Mode of study

Not applicable.

Guarantor

Ing. Jan Luhan, Ph.D., MSc

Department

Institute of Informatics (ÚI)

Learning outcomes of the course unit

As learning outcomes of the course, students will acquire knowledge and skills to effectively analyse and transform source data into information usable in managerial decision-making process, including subsequent interpretation of results. Practical skills are developed with the use of MS Office applications (with the focus on MS Excel) for solving practical problems and case studies.

Prerequisites

Knowledge and skills of practical use of office applications as well as fundamental knowledge of algorithmization, programming techniques, maths, statistics and economics are required.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

The course contains lectures that explain basic principles, problems and methodology of the discipline and seminars that promote the practical knowledge of the subject presented in the lectures with the focus on real managerial examples.

Assesment methods and criteria linked to learning outcomes

Credit conditions:
Student has to obtain at least 50% of the possible maximum during the semester (20 points of 40).
If would be detected plagiarism or unauthorized collaboration on projects, or at mid-term test, credit will be granted with consideration of disciplinary proceedings.
Mid-term test - writing, (answers could be by selecting one of several possibilities, sentence answers or a combination thereof) and developing practical task by submission. (20 points)
Development of the project - one project by entering the appropriate documentations. The project assignment is presented to students in the second lecture. (20 points)

Exam conditions:
Final exam - written form, a test (answers could be by selecting one of several possibilities, sentence answers or a combination thereof) and an oral examination. (60 points for the written part of the exam, the successful completion of the exam, written exam has to be evaluated by at least 30 points, otherwise the test is scored 0 points with the evaluation of F.)

Course curriculum

1. System approach for solving managerial tasks (system and its modeling, analysis and simulation).
2. Use of models in managerial practice (spreadsheet, netbook and graphical models, engineering tables in MS Excel).
3. Use of formulas and functions to solve managerial tasks
4. Use of folded and combined functions to solve managerial tasks.
5. Graphs and their use (creation, analysis and use of graphs in the manager's work).
6. Working with data (import, export, linking, input data validation, conditional formatting, and data transformation).
7. Analysis of data (working with filters, lists, summaries and pivot tables).
8. Use PowerPivot to analyze and work with data.
9. Selected analytical tasks (sensitivity analysis and script work, ...).
10. Utilization and solution of optimization tasks (utilization of solver and analytical accessories MS Excel)
11. Solving of selected mathematical problems (derivatives, integrals, equation systems and differential equations in MS Excel).
12. Using interconnection and integration of applications for automation of management tasks.
13. Managing Outputs for Managers (Using Advanced Tools and MS Word and MS PowerPoint for Effective Managerial Work).

Work placements

Not applicable.

Aims

Hlavním cílem předmětu je, aby si studenti osvojili základní teoretické a především praktické znalosti nutné pro řešení manažerských úloh s využitím dostupných prostředků ICT.
Studenti získají především znalosti a dovednosti umožňující efektivní analýzu a transformaci zdrojových dat do podoby informací využitelných v manažerském rozhodování včetně následné interpretace (prezentace) výsledků. Přičemž praktické dovednosti jsou rozvíjeny s využitím kancelářských aplikací MS Office (s hlavním zaměřením na MS Excel) pro řešení praktických úloh a případových studií.

Specification of controlled education, way of implementation and compensation for absences

Not applicable.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

BARILLA, J. Microsoft Excel 2013: Podrobná uživatelská příručka. 1. vyd. Brno: Computer Press, 2013. 496 s. ISBN 978-80-251-4114-4. (CS)
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. (CS)
PECINOVSKÝ, J. Microsoft Office 2013 Podrobná uživatelská příručka. Brno: Computer Press, 2013. 496 s. ISBN 978-80-251-4102-1. (CS)

Recommended reading

DODGE, M. MOS 2013 Study Guide: Exams 77-427 & 77-428 Microsoft Excel Expert. 1st ed. Redmond: Microsoft Press, 2013. 184 p. ISBN 978-0-7356-6921-5. (EN)
RALSTON, B. PowerPivot for Business Intelligence Using Excel and Sharepoint Berkeley: Apress, 2011. 299 p. ISBN 978-1-4302-3380-0. (EN)
SAWYER, T. Y. Pro Excel Financial Modeling: Building Models for Technology Startups. Berkeley: Apress, 2009. 291 p. ISBN 978-1-4302-1898-2. (EN)
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. (EN)

eLearning

eLearning: currently opened course

Classification of course in study plans

  • Programme BAK-MIn Bachelor's

    branch BAK-MIn , 1. year of study, summer semester, compulsory

  • Programme BAK Bachelor's

    branch BAK-EP , 2. year of study, summer semester, compulsory-optional

Type of course unit

 

Lecture

13 hours, optionally

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc

Exercise

26 hours, compulsory

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc

eLearning

eLearning: currently opened course