RLZ_IPP Informatics for HR professionals

Institute of Technology and Business in České Budějovice
summer 2024
Extent and Intensity
0/2/0. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Bc. Karel Antoš, Ph.D. (seminar tutor)
Ing. Jiří Jelínek, CSc. (seminar tutor)
Guaranteed by
Ing. Roman Danel, Ph.D.
Department of Informatics and Natural Sciences – Faculty of Technology – 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
RLZ_IPP/S01: Wed 6. 3. 13:05–14:35 D216, Wed 13. 3. 13:05–14:35 D216, Wed 20. 3. 13:05–14:35 D316, Wed 27. 3. 13:05–14:35 D316, Wed 3. 4. 13:05–14:35 D316, Wed 10. 4. 13:05–14:35 D316, Wed 17. 4. 13:05–14:35 D316, Tue 23. 4. 16:30–18:00 D316, Tue 30. 4. 16:30–18:00 D316, Tue 7. 5. 16:30–18:00 D316, Tue 14. 5. 16:30–18:00 D316, Tue 21. 5. 16:30–18:00 D316, Tue 28. 5. 16:30–18:00 D316, J. Jelínek
RLZ_IPP/S02: Wed 14:50–16:20 D315, K. Antoš
RLZ_IPP/Z3: Sat 16. 3. 9:40–11:10 D316, 11:25–12:55 D316, Sat 13. 4. 14:50–16:20 D316, 16:30–18:00 D316, K. Antoš
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.
  • TOPOLOVÁ, I., T. KUBÁLEK a M. KUBÁLKOVÁ, 2017. Textový procesor Microsoft Word 2016. [Praha]: Oeconomica. ISBN 978-80-245-2198-5.
  • BORONCZYK, T., 2016. MySQL okamžitě. Brno: Computer Press. ISBN 978-80-251-4737-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
  • WELLING, L. a L. THOMSON, 2017. Mistrovství PHP a MySQL. Brno: Computer Press. ISBN 978-80-251-4892-1.
  • 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.
  • 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.
Forms of Teaching
Seminar
Tutorial
Teaching Methods
Frontal Teaching
Group Teaching - Cooperation
Brainstorming
Critical Thinking
Individual Work– Individual or Individualized Activity
Student Workload
ActivitiesNumber of Hours of Study Workload
Daily StudyCombined Study
Preparation for Seminars, Exercises, Tutorial624
Preparation for the Final Test1313
Seminar project77
Attendance on Seminars/Exercises/Tutorial/Excursion268
Total:5252
Assessment Methods and Assesment Rate
Test – final 70 %
seminar project 30 %
Exam conditions
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.
The course is also listed under the following terms summer 2022, SUMMER 2023.
  • Enrolment Statistics (recent)
  • Permalink: https://is.vstecb.cz/course/vste/summer2024/RLZ_IPP