EKO_INF_EL Informatika pro ekonomy – e-learning

Institute of Technology and Business in České Budějovice
winter 2022
Extent and Intensity
0/0/0. 5 credit(s). Type of Completion: zk (examination).
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: Department of Informatics and Natural Sciences – Faculty of Technology – Rector – Institute of Technology and Business in České Budějovice
Prerequisites (in Czech)
OBOR ( CAP )
Course Enrolment Limitations
The course is offered to students of any study field.
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 corresponding to advanced contact. 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 the course, the student: 1. uses basic concepts in the field of informatics and explains the interrelationships between concepts in the field of informatics, 2. applies basic functions in the MS Office office suite, 3. can apply basic functions in programming languages, 4. can apply basic queries in a SQL database environment, 5. has basic knowledge and skills for using enterprise information systems.
Syllabus
  • Course syllabus Lectures: 1. Informatics - Information technology, data, information, system, management and processes. 2. Portfolio, infrastructure and functionality of applications. 3. Office software - advanced level of MS Excel and MS Word. 4. Introduction to programming and database languages. 5. Program and database languages. 6. Transaction applications - functionality of ERP products. 7. Applications for decision support and external relations management. 8. Applications aimed at supporting labor productivity. 9. Management of IT operations in the company. 10. Management of IT business processes. 11. Application life cycle. 12. Security in informatics. 13. Industry 4.0. Seminars: 1. Working with text - basic functions of MS Word. 2. Working with text - advanced functions of MS Word. 3. Presentation techniques - advanced functions of MS Powerpoint. 4. Work with spreadsheets I. - MS Excel, basic level, equations, work with graphs, formatting, text, logical functions and date and time. 5. Working with spreadsheets II. - MS Excel, advanced level, contingency tables, mathematical and statistical. 6. Working with spreadsheets III. - MS Excel, advanced level, search, database. 7. Basics of programming - program and programming languages, basic algorithms and writing code in PHP. 8. Working with databases - data and databases, basic SQL queries on the example of MySQLi, basic queries in the program code environment in PHP. 9. Programming - a simple application in PHP. 10. Applications for economists I - use of cloud services Google Apps, Office 365. 11. Applications for economists II - use of ERP systems. 12. Applications for economists III - use of registration tools. 13. Applications for economists IV - evaluation and planning of employees.
Literature
    required literature
  • 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, nakladatelství VŠE. ISBN 978-80-245-2229-6.
  • DASGUPTA, S., 2016. Computer Science: A Very Short Introduction. New York: OUP Oxford. ISBN 978-0198733461.
  • TOPOLOVÁ, I., T. KUBÁLEK a M. KUBÁLKOVÁ, 2017. Textový procesor Microsoft Word 2016. [Praha]: Oeconomica, nakladatelství VŠE. ISBN 978-80-245-2198-5.
  • BORONCZYK, T., 2016. MySQL okamžitě. Brno: Computer Press. ISBN 978-80-251-4737-5.
  • 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.
    recommended literature
  • TOPOLOVÁ, I., T. KUBÁLEK a M. KUBÁLKOVÁ, 2016. Prezentační program Microsoft PowerPoint 2016. Praha: Oeconomica, nakladatelství VŠE. ISBN 978-80-245-2138-1.
  • WELLING, L. a L. THOMSON, 2016. PHP and MySQL Web evelopment. 5 edition. ed. Addison Wesley, Hoboken, NJ.
  • 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.
  • PAVLÍČEK, A., A. GALBA a M. HORA, 2017. Moderní informatika. Druhé, 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
e-learning
Teaching Methods
E-learning
Student Workload
ActivitiesNumber of Hours of Study Workload
Daily StudyCombined Study
Preparation for the Final Test3030
Self-study100100
Total:130130
Assessment Methods and Assesment Rate
Test – final 100 %
Exam conditions
In order to successfully complete the course, it is necessary to achieve a total of at least 70% of the final evaluation under the conditions set out below. A total of 100 points, ie 100%, can be obtained in the final evaluation. Overall classification of the course, ie points for the final evaluation (100 - 0): A 100 - 90, B 89.99 - 84, C 83.99 - 77, D 76.99 - 73, E 72.99 - 70, FX 69.99 - 30, F 29.99 - 0.
Language of instruction
Czech
Further comments (probably available only in Czech)
General note: Předmět založený na základě dostudovaní potřebného e-learningu.
Information on the extent and intensity of the course: e-learning.
Teacher's information
Teaching will take place through self-study.
The course is also listed under the following terms winter 2021, summer 2022.
  • Enrolment Statistics (recent)
  • Permalink: https://is.vstecb.cz/course/vste/winter2022/EKO_INF_EL