Přístupnostní navigace
E-application
Search Search Close
Course detail
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
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
Course curriculum
Work placements
Aims
Specification of controlled education, way of implementation and compensation for absences
Recommended optional programme components
Prerequisites and corequisites
Basic literature
Recommended reading
Elearning
Classification of course in study plans
branch BAK-EP , 2 year of study, summer semester, compulsory-optional
branch BAK-MIn , 1 year of study, summer semester, compulsory
Lecture
Teacher / Lecturer
Exercise