INF_2 Informatics II

Institute of Technology and Business in České Budějovice
summer 2021
Extent and Intensity
0/2/0. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Bc. Karel Antoš, Ph.D. (seminar tutor)
Ing. Jiří Čejka, Ph.D. (alternate examiner)
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_2/SX01: Tue 8:00–9:30 D315, K. Antoš
Prerequisites
The student has the knowledge in the range of the ECDL modules M1, M2, skills gained by studying the INF_1 course are an advantage.
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives supported by learning outcomes
The aim of this course is to gain and complement the knowledge and practical skills in using personal computers in the range of the ECDL modules M9, M5 and M6 and partly AM6. After the successful completing of the course, the students will have an overview of concepts of simple digital graphics processing and they will be able to create and edit this graphics. After that, students will learn the principles of the presentation design and about the tools for its creation, which will be able to use on advanced user level. Students will be able to effectively use the outputs of their work for their study. The third area, on which the student will get an overview, is using databases. They will also be familiar with basic concepts and be able to use applications for creating databases and working with them.
Learning outcomes
Upon completion of the course the student will be able to: - understand the basic terminology and principles of data processing in database applications with an emphasis on relational databases. - use relational database tools such as MS Access to retrieve the required information. - have insight into concepts related to the processing of raster graphics, and to create and edit the graphics - know the principles how to make successful presentations - use presentation tools such as MS Powerpoint and their advanced capabilities The abilities listed above will be in the range of ECDL modules M9, M6 and M5 and partly also AM6.
Syllabus
  • 1. - 5. The full ECDL module M5 (Using databases) - basic database concepts, structure and database management, application for database processing (work with files), data manipulation, design and creation of tables, information retrieval (queries), input and output data (forms and reports, printing) 6. - 7. The full ECDL module M9 (Digital images editing and the basics of computer graphics) - types of computer graphics, image manipulation (including their acquisition), formats, work with colors and their representation, using of the graphical editor, graphics processing (creating , editing, layers, effects), printing 8. - 9. The full ECDL module M6 (Presentation) - basic concepts, application for creating presentations, preparation of presentation (design and templates), creation of presentation (formatting, processing of text, images, tables), graphs and diagrams, preparation and revision of outputs 10. - 13. The reduced ECDL Module AM6 (Advanced presentation) - principles of presentation design (audience, purpose), the choice of appropriate forms and design (color, style), templates, graphic elements and their use, multimedia, links and navigation, use of presentation (control, time management) )
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
Lecture
Seminar
Exercise
Excursion - language
Tutorial
Consultation
Teaching Methods
Frontal Teaching
Group Teaching - Competition
Group Teaching - Cooperation
Group Teaching - Collaboration
Project Teaching
Brainstorming
Partner Teaching
Critical Thinking
Individual Work– Individual or Individualized Activity
Teaching Supported by Multimedia Technologies
E-learning
Computer supported learning
Student Workload
ActivitiesNumber of Hours of Study Workload
Daily StudyCombined Study
Preparation for the Mid-term Test610
Preparation for Seminars, Exercises, Tutorial1022
Preparation for the Final Test1015
Attendance on Seminars/Exercises/Tutorial/Excursion265
Total:5252
Assessment Methods and Assesment Rate
Test – mid-term 30 %
Test – final 70 %
Exam conditions
First Test: maximum 30 %. Final Test: maximum 70 %. First test with range from 0 to 30 points. The content of this test is Using databases (practical test). For the part-time study program students the test will be accessible for solution from home for one weekend specified by teacher. For both full-time and part-time students will be available training version of the first test for better orientation in it and self verifying their knowledge before the first test. The final test (the form of questionaire) in IS in examination period. The maximum score in final test is 70 points. Successful graduates of the course have to get totally at least 70 points. Points from 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.
Language of instruction
Czech
Further comments (probably available only in Czech)
The course is taught annually.
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 2010, Winter 2010, summer 2011, winter 2011, summer 2012, winter 2012, summer 2013, winter 2013, summer 2014, winter 2014, summer 2015, winter 2015, Summer 2016, summer 2017, summer 2018, summer 2019, summer 2020.
  • Enrolment Statistics (recent)
  • Permalink: https://is.vstecb.cz/course/vste/summer2021/INF_2