INF_2 Informatics II

Institute of Technology and Business in České Budějovice
summer 2014
Extent and Intensity
0/2. 2 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Bc. Karel Antoš, Ph.D. (seminar tutor)
Mgr. Václav Dobiáš (seminar tutor)
Ing. Tomáš Dolanský, Ph.D. (seminar tutor)
Mgr. Ing. Petra Fiřtová (seminar tutor)
Ing. Jiří Jelínek, CSc. (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
Timetable of Seminar Groups
INF_2/A1: Sat 8. 3. 13:50–14:35 E1, 14:50–16:20 E1, K. Antoš
INF_2/A1a: Sun 6. 4. 8:00–9:30 D316, P. Fiřtová
INF_2/A1b: Sun 6. 4. 9:40–11:10 D316, P. Fiřtová
INF_2/A1c: Sun 27. 4. 8:00–9:30 D216, K. Antoš
INF_2/A1d: Sun 27. 4. 8:00–9:30 D316, P. Fiřtová
INF_2/A1e: Sun 27. 4. 9:40–11:10 D216, K. Antoš
INF_2/A1g: Sun 6. 4. 14:50–16:20 D216, K. Antoš
INF_2/D2: Sat 8. 3. 13:50–14:35 E1, 14:50–16:20 E1, K. Antoš
INF_2/D2a: Sun 6. 4. 8:00–9:30 D216, K. Antoš
INF_2/D2b: Sun 6. 4. 9:40–11:10 D216, K. Antoš
INF_2/S01: Mon 8:00–9:30 D316, V. Dobiáš
INF_2/S03: Tue 8:00–9:30 D316, V. Dobiáš
INF_2/S04: Fri 14:50–16:20 D316, K. Antoš
INF_2/S05: Wed 9:40–11:10 D216, V. Dobiáš
INF_2/S06: Mon 9:40–11:10 D316, V. Dobiáš
INF_2/S07: Tue 18:10–19:40 D216, K. Antoš
INF_2/S09: Mon 16:30–18:00 D316, T. Dolanský
INF_2/S10: Thu 18:10–19:40 D216, P. Pánek
INF_2/S11: Mon 11:25–12:55 D216, V. Dobiáš
INF_2/S13: Mon 14:50–16:20 D316, J. Jelínek
INF_2/S14: Tue 9:40–11:10 D316, V. Dobiáš
INF_2/S15: Tue 11:25–12:55 D316, V. Dobiáš
INF_2/S16: Tue 13:05–14:35 D316, K. Antoš
INF_2/S17: Tue 14:50–16:20 D216, V. Dobiáš
INF_2/S18: Fri 9:40–11:10 D316, K. Antoš
INF_2/S19: Tue 16:30–18:00 D216, K. Antoš
INF_2/S20: Thu 14:50–16:20 D316, P. Pánek
INF_2/S21: Fri 13:05–14:35 D316, K. Antoš
INF_2/S22: Wed 11:25–12:55 D216, K. Antoš
INF_2/S23: Wed 13:05–14:35 D216, K. Antoš
INF_2/S24: Wed 14:50–16:20 D216, V. Dobiáš
INF_2/S25: Wed 16:30–18:00 D216, V. Dobiáš
INF_2/S26: Wed 18:10–19:40 D316, K. Antoš
INF_2/S27: Thu 9:40–11:10 D216, K. Antoš
Prerequisites
MAX_KOMBINOVANYCH ( 308 ) && MAX_PREZENCNICH ( 756 )
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.
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
  • VYBÍRAL, J.: GIMP - Praktická uživatelská příručka, Computer Press, 2008, 224 str., ISBN 978-80-251-1945-7
  • KRÁL, M.; MAGERA, Ivo, Microsoft Office PowerPoint 2007 - Podrobná uživatelská příručka, Computer Press, 2007, 360 str., ISBN 978-80-251-1619-7
  • KRUCZEK, A.: Microsoft Access 2010 - Podrobná uživatelská příručka, Computer Press, 2010, 392 str., ISBN 978-80-251-3289-0
    recommended literature
  • 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 : Prezentační program Microsoft PowerPoint verze 2007 CZ. 1. vyd. Praha : Oeconomica, 2009. 82 s. ISBN 978-80-245-1523-6.
  • 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.
  • 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
Forms of Teaching
Seminar
Exercise
Tutorial
Consultation
Teaching Methods
Frontal Teaching
Group Teaching - Competition
Group Teaching - Cooperation
Project Teaching
Critical Thinking
Individual Work– Individual or Individualized Activity
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). 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 can also be completed outside the examination period.
The course is taught annually.
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, winter 2014, summer 2015, winter 2015, Summer 2016, summer 2017, summer 2018, summer 2019, summer 2020, summer 2021.
  • Enrolment Statistics (summer 2014, recent)
  • Permalink: https://is.vstecb.cz/course/vste/summer2014/INF_2