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)

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/X01: Sat 28. 11. 14:50–16:20 D316, 16:30–18:00 D316, 18:10–19:40 D316, Sat 12. 12. 8:00–9:30 D316, 9:40–11:10 D316, 11:25–12:55 D316, Sun 10. 1. 8:00–9:30 D316, 9:40–11:10 D316, 11:25–12:55 D316, 13:05–14:35 D316, 14:50–16:20 D316, K. Antoš
INF_z/PX01: Thu 9:40–11:10 D316, K. Antoš
INF_z/SX01: Thu 11:25–12:55 D315, Thu 13:05–13:50 D315, K. Antoš

Prerequisites

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.

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.

Learning outcomes

Upon successful completion of the course the student understands and can explain key concepts related to ICT, software and hardware. He can also effectively use the Internet and its core services. In addition, the student is familiar with the general features and requirements on applications for processing texts, spreadsheets, presentations and for work with databases. He is also able to work with selected MS Office applications on the level of advanced user. Besides, he can work with databases and can use data search tools. In addition, he can algorithmize tasks with complexity corresponding to his overall knowledge and write the proposed algorithms in the standard form. He is also able to transform these algorithms into executable programs. Student can use these abilities both in further studies and in practice.

Syllabus

• 1. Presentation Techniques - advanced MS Powerpoint features, other presentation and data visualization tools. 2. Working with Text - advanced MS Word and other (eg. online) word processing tools. 3. Working with table data - MS Excel and solving problems in it, basic and advanced level. 4. Fundamentals of Informatics - data, information, knowledge, information measurement, information theory, numerical systems. 5. Hardware - history, architecture and components 6. Computer networks - principles, Internet, cloud technologies. 7. Software - data storage in PC, layer software structure, operating systems, application and system software. 8. Security in IT - security threats in ICT, data security, computer networks. 9.Algorithms and data structures - algorithm, process and data structures, flowcharts. 10. Fundamentals of algorithmization – problem algorithmization, basic algorithmic procedures, algorithms description. 11. Fundamentals of programming - programming and programming languages, basics of PHP. 12. Working with data - data and databases, relational database, SQL, data analysis and design, other database models, working with   MS Access. 13. Business Informatics - IS in organization, strategic management of IS/ICT, system integration, business intelligence.

Literature

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

recommended literature
• Arduino Home. https://www.arduino.cc/
• 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.
• 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.
• SILBERSCHATZ, A., KORTH, H.F., SUDARSHAN, S.: Database system concepts. Fourth Edition. McGraw - Hill. 2002, 1064 p.
• JELÍNEK, Jiří, FALADA Jaromír.Informatics 1, study support for combined study Bachelors, degree program, VŠTE České Budějovice, 2011.
• Free MS Office Programs Ebooks from the site http://bookboon.com/en/office-programs-ebooks
• Virius M. Základy algoritmizace. http://www.rudisweb.wz.cz/dokumenty/algoritmizace.pdf
• PHP Homepage. https://secure.php.net/
• Aktuální zdroje na síti Internet
• Manažerské IS, https://is.mendelu.cz/eknihovna/opory/index.pl?cast=5119
• O. Novotný, J. Pour, D. Slánský: Business Intelligence, GRADA, 2004, ISBN 80-247-1094-3
• 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.
• N. Wirth: Algoritmy a štruktúry údajov, Alfa, Bratislava, 1989.
• J. Voříšek, Principy strategického řízení IS, http://nb.vse.cz/~vorisek/FILES/Clanky/1998_Principy_strategickeho_rizeni_IS.htm
• 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.
• 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.
• KRUCZEK, A.: Microsoft Access 2010 - Podrobná uživatelská příručka, Computer Press, 2010, 392 str., ISBN 978-80-251-3289-0
• KOPECKÝ, Ladislav. Prezentace v marketingové komunikaci. Praha: Grada, 2010. Žurnalistika a komunikace. ISBN 978-80-247-3123-0.
• Standard ECDL, http://www.ecdl.cz
• MESSMER, H. P.: Velká kniha hardware. CP Books, Brno, 2005. ISBN 80-251-0416-8.
• 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. 29 pp. ISBN 978-80-7468-003-8. 2012. 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 (recent)
  
• Permalink: https://is.vstecb.cz/course/vste/winter2020/INF_z