Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2023/2024
UPOZORNĚNÍ: Jsou dostupné studijní plány pro následující akademický rok.

Software for Business Practice

Login to KOS for course enrollment Display time-table
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
roomTH:B-475

08:00–09:50
(parallel nr.103)
Thákurova 7 (budova FSv)
B475
roomTH:B-475

14:00–15:50
(parallel nr.102)
Thákurova 7 (budova FSv)
B475
roomTH:B-475

12:00–13:50
(parallel nr.101)
Thákurova 7 (budova FSv)
B475
The course is a part of the following study plans:
Data valid to 2024-04-21
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet6280506.html