VŠTE:INF_z Informatics - Course Information

INF_z Informatics

Extent and Intensity

2/3/0. 6 credit(s). Type of Completion: zk (examination).

Teacher(s)

Ing. Bc. Karel Antoš, Ph.D. (seminar tutor)
Ing. Jiří Jelínek, CSc. (seminar tutor)
Mgr. Václav Karafiát (seminar tutor)
Ing. Miroslav Ludvík, Ph.D., LL.M., MBA (seminar tutor)
RNDr. Ivo Opršal, Ph.D. (seminar tutor)
Mgr. Petr Pánek (seminar tutor)

Guaranteed by

Ing. Jiří Jelínek, CSc.
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

Timetable of Seminar Groups

INF_z/D6: Sat 30. 9. 8:00–9:30 B2, 9:40–11:10 B2, 11:25–12:10 B2, Sun 26. 11. 14:50–16:20 B1, 16:30–18:00 B1, 18:10–18:55 B1, J. Jelínek
INF_z/D6a: Sat 21. 10. 8:00–9:30 D315, 9:40–11:10 D315, 11:25–12:55 D315, Sat 11. 11. 13:05–14:35 D315, 14:50–16:20 D315, 16:30–18:00 D315, K. Antoš
INF_z/D6b: Sun 22. 10. 8:00–9:30 D215, 9:40–11:10 D215, 11:25–12:55 D215, Sun 12. 11. 13:05–14:35 D215, 14:50–16:20 D215, 16:30–18:00 D215, K. Antoš
INF_z/D6c: Sat 21. 10. 8:00–9:30 D316, 9:40–11:10 D316, 11:25–12:55 D216, Sat 11. 11. 13:05–14:35 D215, 14:50–16:20 D215, 16:30–18:00 D215, P. Pánek
INF_z/D6d: Sun 22. 10. 8:00–9:30 D315, 9:40–11:10 D315, 11:25–12:55 D315, Sun 12. 11. 13:05–14:35 D315, 14:50–16:20 D315, 16:30–18:00 D315, P. Pánek
INF_z/P01: Wed 13:05–14:35 E1, J. Jelínek
INF_z/S01: Wed 14:50–16:20 D215, Wed 16:30–17:15 D215, K. Antoš
INF_z/S02: Mon 14:50–16:20 D215, Mon 16:30–17:15 D215, K. Antoš
INF_z/S03: Tue 13:05–14:35 D215, Tue 14:50–15:35 D215, K. Antoš
INF_z/S04: Mon 8:45–9:30 D315, Mon 9:40–11:10 D315, M. Ludvík
INF_z/S06: Tue 16:30–18:00 D215, Tue 18:10–18:55 D215, P. Pánek
INF_z/S08: Thu 16:30–18:00 D215, Thu 18:10–18:55 D215, P. Pánek
INF_z/S09: Thu 13:05–14:35 D215, Thu 14:50–15:35 D215, I. Opršal

Prerequisites

MAX_KOMBINOVANYCH ( 200 ) && MAX_PREZENCNICH ( 252 )
The student has the basic knowledge in the range of the ECDL modules M1, M2, M7 among topics taught in the course and listed below.

Course Enrolment Limitations

The course is offered to students of any study field.
The capacity limit for the course is 452 student(s).
Current registration and enrolment status: enrolled: 0/452, only registered: 0/452

Course objectives supported by learning outcomes

The aim of the course is to supplement or to gain knowledge and practical skills in the use of information technology on the level of advanced user with further extended knowledge in the fields of information theory, enterprise IS management, hardware, software and its creation and data processing. After successful completion of the course the student understands the concepts generaly related to ICT, hardware and software. HStudent is able to work efficiently with the   key applications from MS Office and use their advanced features. Students also know how to process data with databases and are able to use tools for data retrieval. They also know how to algorithmize tasks suited to their overall knowledge and create simple programs. Their skills can be used in further studies, the creation of seminar and undergraduate works and in practice.

Syllabus

• Presentation techniques - the advanced features of MS Powerpoint, other presentation tools and data visualization. Working with text - advanced functions of MS Word and other (eg. online) tools for word processing. Working with tabular data - MS Excel and solving problems in it, both basic and advanced level. Computer Basics - data, information, knowledge, information measurement, information theory, numerical systems. Hardware - history, architecture and components, computer networks, Internet and cloud technologies, practical work with corresponding technologies on seminars. Software - data storage in PCs, the layer structure of software, operating systems, application and system software. Security in IT - security threats in ICT, data security, computer network. Basics of algorithmization - algorithm, process and data structures, flowcharts, task algorithmization, methods for describing algorithms. Basics of prorgamming - software and programming languages, ​​PHP basics, basics of programming for Arduino platform. Data processing - data and databases, relational databases, SQL, data analysis and design, other database models, work with MS Access. Business Informatics - IS in the organization, strategic management of IS/IT, system integration, Business Intelligence.

Literature

required literature
• Prezentace vyučujících k předmětu

recommended literature
• N. Wirth: Algoritmy a štruktúry údajov, Alfa, Bratislava, 1989.
• Manažerské IS, https://is.mendelu.cz/eknihovna/opory/index.pl?cast=5119
• KRUCZEK, A.: Microsoft Access 2010 - Podrobná uživatelská příručka, Computer Press, 2010, 392 str., ISBN 978-80-251-3289-0
• O. Novotný, J. Pour, D. Slánský: Business Intelligence, GRADA, 2004, ISBN 80-247-1094-3
• J. Voříšek, Principy strategického řízení IS, http://nb.vse.cz/~vorisek/FILES/Clanky/1998_Principy_strategickeho_rizeni_IS.htm
• JELÍNEK, Jiří, FALADA Jaromír.Informatics 1, study support for combined study Bachelors, degree program, VŠTE České Budějovice, 2011.
• Andrýsková, Jana. Microsoft PowerPoint : podrobná uživatelská příručka. Jana Andrýsková. Vyd. 1. Brno : Computer Press, 2010. 400 s. (Podrobná uživatelská příručka). Obsahuje rejstřík. ISBN 978-80-251-3076-6.
• MESSMER, H. P.: Velká kniha hardware. CP Books, Brno, 2005. ISBN 80-251-0416-8.
• KUBÁLKOVÁ, Markéta, KUBÁLEK, Tomáš, TOPOLOVÁ, Ivana. Tabulkový program Microsoft Excel 2010. 1. vyd. Brno : Tribun, 2011. 165 s. ISBN 978-80-263-0047-2.
• KOPECKÝ, Ladislav. Prezentace v marketingové komunikaci. Praha: Grada, 2010. Žurnalistika a komunikace. ISBN 978-80-247-3123-0.
• Virius M. Základy algoritmizace. http://www.rudisweb.wz.cz/dokumenty/algoritmizace.pdf
• SILBERSCHATZ, A., KORTH, H.F., SUDARSHAN, S.: Database system concepts. Fourth Edition. McGraw - Hill. 2002, 1064 p.
• Aktuální zdroje na síti Internet
• PHP Power Programming. http://www.root.cz/knihy/php-5-power-programming/stahnout/903/
• MEDLÍKOVÁ, Olga. Přesvědčivá prezentace: špičkové rady, tipy a příklady. Praha: Grada, 2008. Manažer. ISBN 978-80-247-2278-8.
• Standard ECDL, http://www.ecdl.cz
• TOPOLOVÁ, Ivana, KUBÁLEK, Tomáš, KUBÁLKOVÁ, Markéta. Textový procesor Microsoft Word 2010. 1. vyd. Brno : Tribun, 2012. 117 s. ISBN 978-80-263-0216-2.
• Pecinovský, Josef, 1946-. Excel a Access 2010 : efektivní zpracování dat na počítači. Josef Pecinovský. 2., aktualiz. vyd. Praha : Grada, 2011. 198 s. (Průvodce). V tiráži uvedeno chybně 1. vyd. ISBN 978-80-247-3898-7.
• Free MS Office Programs Ebooks from the site http://bookboon.com/en/office-programs-ebooks
• PHP Homepage. https://secure.php.net/
• Arduino Home. https://www.arduino.cc/
• JELÍNEK, Jiří and Jaromír FALADA. Informatika I : studijní opora pro kombinované studium. 1. vyd. České Budějovice: Vysoká škola technická a ekonomická v Českých Budějovicích, 2012, 29 pp. ISBN 978-80-7468-003-8. info

Forms of Teaching

Lecture
Seminar
Exercise
Tutorial
Consultation

Teaching Methods

Frontal Teaching
Group Teaching - Competition
Group Teaching - Cooperation
Critical Thinking
Individual Work– Individual or Individualized Activity
Computer supported learning

Student Workload

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	26	34
Preparation for Lectures	13
Preparation for Seminars, Exercises, Tutorial	26	70
Preparation for the Final Test	26	42
Attendance on Lectures	26
Attendance on Seminars/Exercises/Tutorial/Excursion	39	10
Total:	156	156

Assessment Methods and Assesment Rate

Test – mid-term 30 %
Test – final 70 %

Exam conditions

Midterm test - scoring will be in the range of ~ 0-30 points. Content of the test are practical tasks and questionairies from topics Presentation techniques, Working with text and Working with tabular data. For the part-time study program students the test will be accessible for solution from home for one weekend specified by teacher. The final test - the form of questionaire in IS and possible practical tasks realized in examination period. The maximum score is 70 points. The contents of this test are topics covered in lectures and seminars not covered in the midterm test. Points for both tests are summed. Grading of the course: First Test/Seminar Work/ … : maximum 30% (0-30 points), Final Test: maximum 70% (0-70 points). Successful graduates of the course have to get totally at least 70 points: A: 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

• Enrolment Statistics (winter 2017, recent)
  
• Permalink: https://is.vstecb.cz/course/vste/winter2017/INF_z