|
Lecturer(s)
|
-
Vais Jiří, doc. Ing. Ph.D.
|
|
Course content
|
Learning outcomes of the course unit The subject is focused on the analysis of business activities using software tools. 1. Organizational instructions, introductory presentation 2. Statistical analysis as a basic analysis tool 3. Linear programming 4. Solving linear programming tasks (material division, production planning) 5. Solving linear programming problems (transport problem, assignment method) 6. Solving linear programming problems (orbital transport problem) 7. Project Management (CPM) 8. Project Management (PERT) 9. Simulation methods (Monte Carlo simulation, discrete simulation examples) 10. Simulation methods (heuristic methods)
|
|
Learning activities and teaching methods
|
Discussion, Instruction based on dialogue, Multimedia supported teaching, Students' portfolio
- Individual project (40)
- 40 hours per semester
- Contact hours
- 39 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| basic prerequisite is basic knowledge of algorithms and company economics. |
| have basic knowledge of MS Word |
| have basic knowledge of MS Excel |
| Skills |
|---|
| is able to work with MS Word at the basic level |
| is able to work with MS Excel at the basic level |
| Competences |
|---|
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| describe simple business activities using a spreadsheet |
| Skills |
|---|
| analyze simple business activities using a spreadsheet |
| solve linear programming tasks using a spreadsheet |
| apply simulation methods within a spreadsheet |
| manage projects using a spreadsheet |
| teaching methods |
|---|
| Knowledge |
|---|
| Discussion |
| Skills |
|---|
| Skills demonstration |
| Interactive lecture |
| assessment methods |
|---|
| Knowledge |
|---|
| Continuous assessment |
| Skills |
|---|
| Seminar work |
|
Recommended literature
|
-
Barilla, Jiří; Simr, Pavel. Microsoft Excel pro techniky a inženýry. Vyd. 1. Brno : Computer Press, 2008. ISBN 978-80-251-2421-5.
-
Jablonský, Josef. Operační výzkum : kvantitativní modely pro ekonomické rozhodování. Praha : Professional Publishing, 2007. ISBN 978-80-86946-44-3.
-
Laurenčík, Marek. Excel - pokročilé nástroje : funkce, marka, databáze, kontingenční tabulky, prezentace, příklady. První vydání. 2016. ISBN 978-80-247-5570-0.
-
Pecinovský Josef, Pecinovský Rudolf. Office 2019 - Průvodce uživatele. Grada, 2019. ISBN 978-80-247-2303-7.
-
Plevný, Miroslav; Žižka, Miroslav. Modelování a optimalizace v manažerském rozhodování. Vyd. 2. Plzeň : Západočeská univerzita, 2010. ISBN 978-80-7043-933-3.
|