BSA_INF_2 Informatics II

Institute of Technology and Business in České Budějovice
summer 2024
Extent and Intensity
2/2/0. 5 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Bc. Karel Antoš, Ph.D. (seminar tutor)
Ing. Jiří Jelínek, CSc. (seminar tutor)
Guaranteed by
Ing. Karel Zeman, Ph.D., MBA
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
BSA_INF_2/A3: Sat 16. 3. 11:25–12:55 E1, 13:05–14:35 E1, Sun 17. 3. 9:40–11:10 D315, 11:25–12:55 D315, 13:05–14:35 D315, Sat 13. 4. 9:40–11:10 D315, 11:25–12:55 D315, 13:05–14:35 D315, K. Antoš, J. Jelínek
BSA_INF_2/P01: Wed 14:50–16:20 E1, J. Jelínek
BSA_INF_2/S01: Tue 14:50–16:20 N012, K. Antoš
Prerequisites
BSA_INF_1 Informatics I
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
  • 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.
  • VYBÍRAL, J.: GIMP - Praktická uživatelská příručka, Computer Press, 2008, 224 str., ISBN 978-80-251-1945-7.
  • 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
Tutorial
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 Test66
Preparation for Lectures26 
Preparation for Seminars, Exercises, Tutorial2688
Preparation for the Final Test2020
Attendance on Lectures26 
Attendance on Seminars/Exercises/Tutorial/Excursion2616
Total:130130
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. Points from both tests are summed. Successful graduates of the course have to get totally at least 70 points: 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 2022, SUMMER 2023.
  • Enrolment Statistics (recent)
  • Permalink: https://is.vstecb.cz/course/vste/summer2024/BSA_INF_2