B_IPP Informatics for HR professionals

Institute of Technology and Business in České Budějovice
summer 2026
Extent and Intensity
0/2/0. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Štěpán Kouba (lecturer)
Ing. Jiří Jelínek, CSc. (seminar tutor)
Ing. Josef Šedivý, Ph.D. (seminar tutor)
Guaranteed by
Ing. Roman Danel, Ph.D.
Department of Informatics and Natural Sciences – School of Expertness and Valuation – Rector – Institute of Technology and Business in České Budějovice
Supplier department: Institute of Technology and Business in České Budějovice
Timetable of Seminar Groups
B_IPP/K03: Sat 21. 2. 14:50–16:20 D315, Sat 16. 5. 11:25–15:55 D315, J. Jelínek
B_IPP/S01: Mon 11:25–12:55 D316, Š. Kouba
B_IPP/S02: Wed 11:25–12:55 D316, J. Šedivý
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives supported by learning outcomes
The aim of the course is to acquire practical skills in the use of modern information and communication technologies to the extent appropriate to advanced users. The focus is on the Microsoft Office office suite and the use of business information systems with a focus on the HR agenda.
Learning outcomes
Upon successful completion of this course, students will: 35.1 use basic concepts in the field of informatics and explain the interrelationships between concepts in the field of informatics; 35.2 applies basic functions in the MS Office office suite; 35.3 can apply basic functions in programming languages ​​35.4 can apply basic queries in a database environment of the SQL type 35.5 has basic knowledge and skills for using human resources enterprise information systems.
Syllabus
  • Seminars
  • 1. Working with text - basic functions of MS Word (35.1, 35.2)
  • 2. Working with text - advanced functions of MS Word (35.1, 35.2)
  • 3. Presentation techniques - advanced functions of MS Powerpoint (35.1, 35.2)
  • 4. Working with spreadsheets I. - MS Excel, basic level, equations, working with graphs, formatting, text, logical functions and date and time (35.1, 35.2)
  • 5. Working with spreadsheets II. - MS Excel, advanced level, contingency tables, mathematical and statistical (35.1, 35.2).
  • 6. Working with spreadsheets III. - MS Excel, advanced level, search, databases (35.1, 35.2)
  • 7. Basics of programming - program and programming languages, basic algorithms and code writing in PHP (35.3)
  • 8. Working with databases - data and databases, basic SQL queries on MySQLi example, basic queries in the program code environment in PHP (35.3, 35.4)
  • 9. Programming - a simple application in PHP (35.3)
  • 10. Applications for HR I - use of cloud services Google Apps, Office 365 (35.5)
  • 11. Applications for HR II - use of ERP systems, payroll (35.5)
  • 12. Applications for HR professionals III - use of employee registration tools (35.5)
  • 13. Applications for HR professionals IV - evaluation and planning of employees (35.5)
Literature
    required literature
  • GÁLA, L., J. POUR a Z. ŠEDIVÁ, 2015. Podniková informatika: počítačové aplikace v podnikové a mezipodnikové praxi. 3., aktualiz. vyd. Praha: Grada. ISBN 978-80-247-5457-4.
  • BORONCZYK, T., 2016. MySQL okamžitě. Brno: Computer Press. ISBN 978-80-251-4737-5.
  • TOPOLOVÁ, I., T. KUBÁLEK a M. KUBÁLKOVÁ, 2017. Textový procesor Microsoft Word 2016. [Praha]: Oeconomica. ISBN 978-80-245-2198-5.
  • SKLAR, D., 2018. PHP 7: praktický průvodce nejrozšířenějším skriptovacím jazykem pro web. Brno: Zoner Press. ISBN 978-80-7413-363-3.
  • KUBÁLKOVÁ, M., T. KUBÁLEK a I. TOPOLOVÁ, 2017. Tabulkový program Microsoft Excel 2016. Praha: Oeconomica. ISBN 978-80-245-2229-6.
    recommended literature
  • FEREBAUEROVÁ, R. a O. PEKÁREK, 2014. Aplikovaná informatika. České Budějovice: Vysoká škola evropských a regionálních studií. ISBN 978-80-87472-74-3.
  • TOPOLOVÁ, I., T. KUBÁLEK a M. KUBÁLKOVÁ, 2016. Prezentační program Microsoft PowerPoint 2016. Praha: Oeconomica. ISBN 978-80-245-2138-1.
  • PAVLÍČEK, A., A. GALBA a M. HORA, 2017. Moderní informatika. 2. rozš. vyd. [Praha]: Professional Publishing. ISBN 978-80-906594-6-9.
  • WELLING, L. a L. THOMSON, 2017. Mistrovství PHP a MySQL. Brno: Computer Press. ISBN 978-80-251-4892-1.
  • NAVRÁTIL, P., 2015. Příklady a cvičení z informatiky: zadání. 3. vyd. Prostějov: Computer Media. ISBN 978-80-7402-160-2.
Organizační formy výuky
Lecture
Seminar
Exercise
Tutorial
Komplexní výukové metody
Frontal Teaching
Group Teaching - Cooperation
Project Teaching
Brainstorming
Critical Thinking
Individual Work– Individual or Individualized Activity
Teaching Supported by Multimedia Technologies
Student Workload
ActivitiesNumber of Hours of Study Workload
Daily StudyCombined Study
Preparation for the Mid-term Test77
Preparation for Seminars, Exercises, Tutorial624
Preparation for the Final Test1313
Attendance on Seminars/Exercises/Tutorial/Excursion268
Total:5252
Metody hodnocení a jejich poměr
Test – mid-term 30%
Test – final 70%
Podmínky testu
To successfully complete the course, it is necessary to achieve a total of at least 70% of the ongoing and final evaluation under the conditions set out below. In the continuous evaluation, 30 points can be obtained, ie 30%. Students of the combined form of study will obtain points of continuous assessment by submitting a seminar project by the end of the 12th week of the semester. In the final evaluation for both forms of study, a total of 70 points can be obtained, ie 70%. Overall classification of the course, ie points for the final evaluation (70 - 0) + points from the continuous evaluation (30 - 0): Successful graduates of the course have to get totally at least 70 points. The student of the full-time form of study is obliged to fulfill the obligatory 70% attendance at contact teaching, ie everything except lectures. If the participation is not met, the student will be automatically classified "-".
Language of instruction
Czech
Teacher's information
Attendance at classes in all forms is governed by a separate internal standard of VŠTE (Records of student attendance at VŠTE). For full-time students, 70% attendance at seminars is mandatory.
  • Enrolment Statistics (recent)
  • Permalink: https://is.vstecb.cz/course/vste/summer2026/B_IPP