INF_2z Informatics II

Institute of Technology and Business in České Budějovice
summer 2020
Extent and Intensity
1/2/0. 4 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Bc. Karel Antoš, Ph.D. (seminar tutor)
Ing. Jiří Jelínek, CSc. (seminar tutor)
Ing. Josef Šedivý (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_2z/T1: Sat 29. 2. 8:00–9:30 E1, 9:40–11:10 E1, 11:25–12:55 E1, J. Jelínek
INF_2z/T1a: Sun 19. 4. 8:00–9:30 D216, 9:40–11:10 D216, 11:25–12:55 D216, K. Antoš
INF_2z/T1b: Sun 22. 3. 8:00–9:30 D216, 9:40–11:10 D216, 11:25–12:55 D216, K. Antoš
INF_2z/P01: each odd Wednesday 11:25–12:55 B1, J. Jelínek
INF_2z/S02: Thu 11:25–12:55 D316, J. Šedivý
INF_2z/S03: Thu 9:40–11:10 D316, J. Šedivý
Prerequisites
INF_1z Informatics I.
Completion of the course Informatics 1z
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives supported by learning outcomes
Learning outcomes of the course unit The aim of the course is to supplement or acquire knowledge and practical skills in the use of information technologies in the extent corresponding to advanced users with further deepened knowledge in the areas of algorithms and algorithmization of tasks, data processing, programming basics and IS / ICT management. Upon successful completion of this course, the student understands concepts related to database technologies. It can work database applications efficiently using their advanced features including data search tools. They can also algorithmize tasks corresponding to the complexity of their overall knowledge and create simple programs for their solution. The student is also able to orientate in the field of business IS.
Learning outcomes
Upon successful completion of this course, the student understands and is able to explain key concepts related to databases. Can work with databases and can use data search tools. Furthermore, he / she is able to algorithmize tasks not only in the area of ​​informatics corresponding to the complexity of his / her overall knowledge and to write proposed algorithms in the standard form of flowcharts. It also manages the transformation of IT algorithms into executable programs. He also knows the principles of corporate IS / ICT systems administration. He / she can use his / her abilities in further studies as well as in practice.
Syllabus
  • 1-2. Algorithms and data structures - algorithm, process and data structures, flowcharts. 3-5. Fundamentals of algorithmization - algorithmization of tasks, basic algorithmic procedures, means for description of algorithms. 6-8. Fundamentals of programming - program and programming languages, basics of PHP language, basics of Arduino platform programming. 9-10. Working with data - data and databases, relational databases, SQL, data analysis and design 11-12. Other database models, work with MS Access and graphical database. 13. Business informatics - IS in organization, strategic management of IS / IT, system integration, Business Intelligence.
Literature
    required literature
  • KRUCZEK, A.: Microsoft Access 2010 - Podrobná uživatelská příručka, Computer Press, 2010, 392 str., ISBN 978-80-251-3289-0
  • Digitální fotografie v programu GIMP. Lubomír Čevela. 2., aktualiz. vyd. Brno : Computer Press, 2012. 200 s.Obsahuje rejstřík. ISBN 978-80-251-3582-2.
  • 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.
  • PECINOVSKÝ, J.: Excel a Access 2010 - Efektivní zpracování dat na počítači, Grada Publishing, 2011, 200 str., ISBN 978-80-247-3898-7
    recommended literature
  • VYBÍRAL, J.: GIMP - Praktická uživatelská příručka, Computer Press, 2008, 224 str., ISBN 978-80-251-1945-7
  • ATKINSON, C.: Působivé prezentace v PowerPointu 2007. [Překlad Jiřina Šetková]. Computer Press, 2008. 334 s. Přeloženo z angličtiny. ISBN 978-80-251-2119-1.
  • KUBÁLEK, Tomáš, KUBÁLKOVÁ, Markéta. Manažerská informatika : Databázový systém Microsoft Access verze 2007 CZ. 1. vyd. Praha : Oeconomica, 2009. 236 s. ISBN 978-80-245-1518-2.
  • KUBÁLEK, Tomáš, KUBÁLKOVÁ, Markéta. Manažerská informatika : Prezentační program Microsoft PowerPoint verze 2007 CZ. 1. vyd. Praha : Oeconomica, 2009. 82 s. ISBN 978-80-245-1523-6.
  • Free MS Office Programs Ebooks from the site http://bookboon.com/en/office-programs-ebooks
  • GNU GIMP documentation. http://docs.gimp.org/2.8/en/
Forms of Teaching
Seminar
Excursion - language
Tutorial
Consultation
Teaching Methods
Frontal Teaching
Group Teaching - Competition
Group Teaching - Cooperation
Project Teaching
Brainstorming
Critical Thinking
Individual Work– Individual or Individualized Activity
Teaching Supported by Multimedia Technologies
Computer supported learning
Student Workload
ActivitiesNumber of Hours of Study Workload
Daily StudyCombined Study
Preparation for the Mid-term Test3333
Preparation for Seminars, Exercises, Tutorial1010
Preparation for the Final Test3333
Attendance on Seminars/Exercises/Tutorial/Excursion2828
Total:104104
Assessment Methods and Assesment Rate
Test – mid-term 30 %
Test – final 70 %
Exam conditions
Continuous test - scoring will be in the range of 0 - 30 points. The content of the test are practical tasks and a questionnaire on the topic of algorithms and algorithmization. Final test - form of the ROPOT, with possible supplementation by practical tasks, carried out in the examination period. The maximum number of points is 70. The content of this test will be all topics discussed in lectures and seminars not included in the midterm test. Points for both tests are added up. Total classification of the course, ie points for test (70 - 0) + points from continuous evaluation (30 - 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
Teacher's information
Attendance in lessons is defined in a separate internal standard of ITB (Evidence of attendance of students at ITB). It is compulsory, except of the lectures, for full-time students to attend 70 % lesson of the subjet in a semester.
The course is also listed under the following terms summer 2021, summer 2022, winter 2022, SUMMER 2023, summer 2024.
  • Enrolment Statistics (summer 2020, recent)
  • Permalink: https://is.vstecb.cz/course/vste/summer2020/INF_2z