VŠTE:EKO_INF_EL Informatika pro ekonomy – e-le - Course Information
EKO_INF_EL Informatika pro ekonomy – e-learning
Institute of Technology and Business in České Budějovicewinter 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
Activities Number of Hours of Study Workload Daily Study Combined Study Preparation for the Final Test 30 30 Self-study 100 100 Total: 130 130 - 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.
- Enrolment Statistics (recent)
- Permalink: https://is.vstecb.cz/course/vste/winter2022/EKO_INF_EL