Course detail
Advanced Methods for Solving Managerial Tasks
FP-PMMUAcad. year: 2018/2019
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
Number of ECTS credits
Mode of study
Guarantor
Department
Learning outcomes of the course unit
Prerequisites
Co-requisites
Planned learning activities and teaching methods
Assesment methods and criteria linked to learning outcomes
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
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
Aims
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
Recommended optional programme components
Prerequisites and corequisites
Basic literature
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
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)
Classification of course in study plans