Software for Business Practice
| Code | Completion | Credits | Range | Language |
|---|---|---|---|---|
| 126SWPX | Z | 2 | 2C | Czech |
- Garant předmětu:
- Petr Dlask
- Lecturer:
- Petr Dlask
- Tutor:
- Petr Dlask
- Supervisor:
- Department of Construction Management and Economics
- Synopsis:
-
Modern construction practice requires the application of various supporting tools and methods. The course is focused on acquire practical skills in user control not only of office applications (especially MS Excel). The aim is to improve their existing skills and acquire new ones to save time at work. The main goal is to focus on such skills that are applicable in continuing subjects and practice. It includes the verification of knowledge when creating examples in the exercise.
- Requirements:
-
A prerequisite is the basic user knowledge of a computer and common office applications. The advantage is orientation in the structure of applications and their accessories.
- Syllabus of lectures:
-
The study subject does not have lectures.
- Syllabus of tutorials:
-
1. Basic breakdown of software tools for construction practice
(including VBA into tool creation, test example)
2. Tools for creating technical-economic processes
(flowchart rules, symbols, online/offline tools)
3. Tools for dynamic processes (definition of management processes)
(user functions, form application, extending the test case)
4. Tools for risk processes, their creation, terminology
(histogram charts, untypical charts, dynamic charts)
5. Decision Support System in construction practice
(monitoring and evaluation of parameters)
6. Reporting as a part of DSS
(data import, defining and compiling outputs)
7. Change Management not only in the environment of a construction company
(proposal of system changes and their evaluation)
8. Tools for process performance management
(proposal of changes to achieve defined goals)
9. Application creation
10. Creation of dashboards
(data studio, creating a dashboard in a test example)
11. Contingency analyses
(assembly of pivot table and pivot chart)
12. Analytical tools in office applications
(solution search, tabulation, data analysis, scenario manager)
13. Database applications I, creation, use
(data import, filtering, setting fields)
- Study Objective:
-
The goal of the study is to present various office and managerial tools applicable not only in the practice of a construction company. To create the practices which diferentiate the graduate of the subject from the standard user. The skills can be applied in other subjects across the study plan. Topics covered may include management, statistics, mathematics, data mining, management, and graphic presentation of data.
- Study materials:
-
Dlask, P., Modelování při řízení, Praha: Wolters Kluwer, 2011, ISBN: 978-80-7357-704-9
Tichý, M., Ovládání rizika, C. H. Beck, 2006, ISBN: 8071794155
Lasák, P., MS Office 2010 – krok za krokem, http://office.lasakovi.com
Belko, P.: MS Access 2013 Podrobná uživatelská příručka, AlbatrosMedia, 2013, ISBN: 978-80-251-4125-0
Laurenčík, M., Excel 2016 a 2019 - pokročilé nástroje, Grada, 2019, ISBN: 978-80-271-2471-8
Available online:
Excel tips: http://people.fsv.cvut.cz/~dlaskpet/Help/ExcelTipy.xlsm
Tutorials: http://people.fsv.cvut.cz/~dlaskpet/Help/data97.xls
Mind map online: https://www.mindmeister.com/1054512660/risk-management
Diagrams symbols: https://www.itnetwork.cz/navrh/uml/vyvojove-diagramy
Symbols Draw.io: https://app.diagrams.net/
- Note:
- Time-table for winter semester 2023/2024:
- Time-table is not available yet
- Time-table for summer semester 2023/2024:
-
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon Tue Wed Thu Fri - The course is a part of the following study plans:
-
- Management a ekonomika ve stavebnictví (compulsory course in the program)
- Management a ekonomika ve stavebnictví (compulsory course in the program)
- Management a ekonomika ve stavebnictví (compulsory course in the program)