|
|
Main menu for Browse IS/STAG
Course info
KPV / PPPS
:
Course description
Department/Unit / Abbreviation
|
KPV
/
PPPS
|
Academic Year
|
2023/2024
|
Academic Year
|
2023/2024
|
Title
|
Practices of computer support
|
Form of course completion
|
Pre-Exam Credit
|
Form of course completion
|
Pre-Exam Credit
|
Long Title
|
Practices of computer support in mechanical
|
Accredited / Credits
|
Yes,
3
Cred.
|
Type of completion
|
Combined
|
Type of completion
|
Combined
|
Time requirements
|
Tutorial
3
[Hours/Week]
|
Course credit prior to examination
|
No
|
Course credit prior to examination
|
No
|
Automatic acceptance of credit before examination
|
Yes in the case of a previous evaluation 4 nebo nic.
|
Included in study average
|
NO
|
Language of instruction
|
Czech
|
Occ/max
|
|
|
|
Automatic acceptance of credit before examination
|
Yes in the case of a previous evaluation 4 nebo nic.
|
Summer semester
|
0 / -
|
0 / -
|
0 / -
|
Included in study average
|
NO
|
Winter semester
|
0 / -
|
0 / -
|
0 / -
|
Repeated registration
|
NO
|
Repeated registration
|
NO
|
Timetable
|
Yes
|
Semester taught
|
Summer semester
|
Semester taught
|
Summer semester
|
Minimum (B + C) students
|
10
|
Optional course |
Yes
|
Optional course
|
Yes
|
Language of instruction
|
Czech
|
Internship duration
|
0
|
No. of hours of on-premise lessons |
|
Evaluation scale |
S|N |
Periodicity |
každý rok
|
Periodicita upřesnění |
|
Fundamental theoretical course |
No
|
Fundamental course |
No
|
Fundamental theoretical course |
No
|
Evaluation scale |
S|N |
Substituted course
|
None
|
Preclusive courses
|
N/A
|
Prerequisite courses
|
N/A
|
Informally recommended courses
|
N/A
|
Courses depending on this Course
|
N/A
|
Histogram of students' grades over the years:
Graphic PNG
,
XLS
|
Course objectives:
|
The aims of the subject are to increase knowledge and abilities in the area of analysis business activities with help software tools.
|
Requirements on student
|
To gain credits, the student must complete a project approved by the lecturer.
|
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)
|
Activities
|
|
Fields of study
|
|
Guarantors and lecturers
|
|
Literature
|
-
Basic:
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.
-
Extending:
Pecinovský Josef, Pecinovský Rudolf. Office 2019 - Průvodce uživatele. Grada, 2019. ISBN 978-80-247-2303-7.
-
Recommended:
Barilla, Jiří; Simr, Pavel. Microsoft Excel pro techniky a inženýry. Vyd. 1. Brno : Computer Press, 2008. ISBN 978-80-251-2421-5.
-
Recommended:
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.
-
Recommended:
Jablonský, Josef. Operační výzkum : kvantitativní modely pro ekonomické rozhodování. Praha : Professional Publishing, 2007. ISBN 978-80-86946-44-3.
-
On-line library catalogues
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Contact hours
|
39
|
Individual project (40)
|
40
|
Total
|
79
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
basic prerequisite is basic knowledge of algorithms and company economics. |
have basic knowledge of MS Word |
have basic knowledge of MS Excel |
Skills - students are expected to possess the following skills before the course commences to finish it successfully: |
is able to work with MS Word at the basic level |
is able to work with MS Excel at the basic level |
Competences - students are expected to possess the following competences before the course commences to finish it successfully: |
N/A |
|
Learning outcomes
|
Knowledge - knowledge resulting from the course: |
describe simple business activities using a spreadsheet |
Skills - skills resulting from the course: |
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 |
|
Assessment methods
|
Knowledge - knowledge achieved by taking this course are verified by the following means: |
Continuous assessment |
Skills - skills achieved by taking this course are verified by the following means: |
Seminar work |
|
Teaching methods
|
Knowledge - the following training methods are used to achieve the required knowledge: |
Discussion |
Skills - the following training methods are used to achieve the required skills: |
Skills demonstration |
Interactive lecture |
|
|
|
|