Course Information

INF_2 Informatics II

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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.

INF_2 Informatics II

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

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_2/S01: Tue 8:00–9:30 D316, K. Antoš
INF_2/S02: Tue 11:25–12:55 D316, K. Antoš
INF_2/S03: Thu 11:25–12:55 D216, K. Antoš
INF_2/S04: Thu 13:05–14:35 D216, K. Antoš

Prerequisites

FORMA ( P )
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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.

INF_2 Informatics II

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

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_2/S01: Tue 14:50–16:20 D316, K. Antoš
INF_2/S02: Tue 16:30–18:00 D316, K. Antoš
INF_2/S03: Wed 14:50–16:20 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 : 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.
• 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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6
Preparation for Seminars, Exercises, Tutorial	10
Preparation for the Final Test	10
Attendance on Seminars/Exercises/Tutorial/Excursion	26
Total:	52	0

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.

INF_2 Informatics II

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

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_2/S01: Tue 11:25–12:55 D216, K. Antoš
INF_2/S02: Wed 13:05–14:35 D215, K. Antoš
INF_2/S03: Tue 9:40–11:10 D216, K. Antoš
INF_2/S05: Wed 11:25–12:55 D315, K. Antoš
INF_2/D1: Sat 17. 3. 9:40–11:10 D216, 11:25–12:55 D216, 13:05–14:35 D216, 14:50–16:20 D216, 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.
The capacity limit for the course is 140 student(s).
Current registration and enrolment status: enrolled: 0/140, only registered: 0/140

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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.

INF_2 Informatics II

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

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_2/X02: Sat 4. 3. 9:40–11:10 D215, 11:25–12:55 D215, 13:05–14:35 D215, Sat 18. 3. 9:40–11:10 D215, 11:25–12:55 D215, K. Antoš
INF_2/S01: Mon 11:25–12:55 D216, K. Antoš
INF_2/S02: Mon 13:05–14:35 D216, K. Antoš
INF_2/S03: Mon 14:50–16:20 D216, K. Antoš
INF_2/S04: Wed 13:05–14:35 D215, K. Antoš
INF_2/TS01: Tue 14:50–16:20 D304, K. Antoš

Prerequisites

MAX_KOMBINOVANYCH ( 28 ) && MAX_PREZENCNICH ( 140 )
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.
The capacity limit for the course is 168 student(s).
Current registration and enrolment status: enrolled: 0/168, only registered: 0/168

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
• 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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.

INF_2 Informatics II

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. Jiří Jelínek, CSc. (seminar tutor)
Mgr. Tomáš Náhlík, 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

Timetable of Seminar Groups

INF_2/A3_D4: Sat 19. 3. 13:50–14:35 E1, 14:50–16:20 E1, V. Dobiáš
INF_2/A3_D4a: Sun 3. 4. 8:00–9:30 D215, V. Dobiáš
INF_2/A3_D4b: Sun 3. 4. 8:00–9:30 D216, K. Antoš
INF_2/A3_D4c: Sun 3. 4. 9:40–11:10 D215, V. Dobiáš
INF_2/A3_D4d: Sun 3. 4. 9:40–11:10 D216, K. Antoš
INF_2/A3_D4f: Sun 3. 4. 14:50–16:20 D216, K. Antoš
INF_2/A3_D4h: Sun 3. 4. 16:30–18:00 D216, K. Antoš
INF_2/S01: Tue 13:05–14:35 D315, J. Jelínek
INF_2/S02: Tue 14:50–16:20 D316, V. Dobiáš
INF_2/S03: Thu 13:05–14:35 D216, V. Dobiáš
INF_2/S04: Thu 8:00–9:30 D315, K. Antoš
INF_2/S05: Wed 11:25–12:55 D316, T. Náhlík
INF_2/S07: Wed 14:50–16:20 D215, T. Náhlík
INF_2/S08: Tue 13:05–14:35 D316, V. Dobiáš
INF_2/S09: Wed 9:40–11:10 D315, T. Náhlík
INF_2/S10: Wed 11:25–12:55 D315, V. Dobiáš
INF_2/S11: Thu 9:40–11:10 D216, V. Dobiáš
INF_2/S12: Thu 9:40–11:10 D315, K. Antoš
INF_2/S13: Thu 11:25–12:55 D216, K. Antoš
INF_2/S14: Fri 9:40–11:10 D216, K. Antoš
INF_2/S15: Fri 11:25–12:55 D216, K. Antoš
INF_2/S16: Wed 9:40–11:10 D316, K. Antoš
INF_2/TS01: Tue 11:25–12:55 A452, T. Náhlík

Prerequisites

MAX_KOMBINOVANYCH ( 280 ) && MAX_PREZENCNICH ( 476 )
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.
The capacity limit for the course is 756 student(s).
Current registration and enrolment status: enrolled: 0/756, only registered: 0/756

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
• 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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.

INF_2 Informatics II

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. 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/K11: Sat 21. 11. 8:00–9:30 B2, 9:40–10:25 B2, V. Dobiáš
INF_2/K11b: Sat 21. 11. 11:25–12:55 D316, K. Antoš
INF_2/K11d: Sat 21. 11. 13:05–14:35 D316, K. Antoš
INF_2/S01: Thu 18:10–19:40 D315, P. Pánek
INF_2/S02: Thu 13:05–14:35 D315, J. Jelínek
INF_2/S03: Thu 16:30–18:00 D316, V. Dobiáš

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.

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

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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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 can also be completed outside the examination period.
The course is taught annually.

INF_2 Informatics II

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. Jiří Jelínek, CSc. (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/A2a: Sat 21. 3. 14:50–16:20 D216, V. Dobiáš
INF_2/A2b: Sat 21. 3. 14:50–16:20 D316, K. Antoš
INF_2/A2c: Sat 21. 3. 16:30–18:00 D216, V. Dobiáš
INF_2/A2d: Sat 21. 3. 16:30–18:00 D316, K. Antoš
INF_2/A2_D3: Sat 21. 3. 12:10–12:55 E1, 13:05–14:35 E1, V. Dobiáš
INF_2/A2f: Sat 21. 3. 18:10–19:40 D316, K. Antoš
INF_2/D3a: Sun 29. 3. 11:25–12:10 D215, V. Dobiáš
INF_2/D3b: Sun 29. 3. 11:25–12:10 D216, K. Antoš
INF_2/D3c: Sun 29. 3. 13:50–14:35 D215, V. Dobiáš
INF_2/S01: Thu 8:00–9:30 D216, K. Antoš
INF_2/S02: Thu 9:40–11:10 D216, K. Antoš
INF_2/S03: Thu 13:05–14:35 D216, K. Antoš
INF_2/S04: Thu 14:50–16:20 D216, K. Antoš
INF_2/S05: Wed 8:00–9:30 D216, K. Antoš
INF_2/S06: Wed 9:40–11:10 D216, K. Antoš
INF_2/S07: Wed 11:25–12:55 D216, K. Antoš
INF_2/S08: Wed 14:50–16:20 D216, K. Antoš
INF_2/S09: Tue 8:00–9:30 D216, V. Dobiáš
INF_2/S10: Tue 9:40–11:10 D216, V. Dobiáš
INF_2/S11: Tue 11:25–12:55 D216, V. Dobiáš
INF_2/S12: Tue 13:05–14:35 D216, V. Dobiáš
INF_2/S13: Tue 14:50–16:20 D216, V. Dobiáš
INF_2/S14: Wed 11:25–12:55 D315, V. Dobiáš
INF_2/S15: Wed 13:05–14:35 D216, V. Dobiáš
INF_2/S17: Wed 14:50–16:20 D215, V. Dobiáš
INF_2/S19: Mon 11:25–12:55 D216, J. Jelínek
INF_2/TS01: Mon 12:30–14:00 A453, K. Antoš

Prerequisites

MAX_KOMBINOVANYCH ( 252 ) && MAX_PREZENCNICH ( 552 )
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
• 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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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 can also be completed outside the examination period.
The course is taught annually.

INF_2 Informatics II

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Bc. Karel Antoš, Ph.D. (seminar tutor)
Mgr. Kateřina Bartošová (seminar tutor)
Mgr. Václav Dobiáš (seminar tutor)
Ing. Jiří Jelínek, CSc. (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/K10: Sun 2. 11. 12:10–12:55 A2, 13:05–14:35 A2, V. Dobiáš
INF_2/K10a: Sun 23. 11. 11:25–12:55 D315, V. Dobiáš
INF_2/K10b: Sun 23. 11. 13:05–14:35 D315, V. Dobiáš
INF_2/S02: Fri 8:00–9:30 D315, V. Dobiáš
INF_2/S03: Mon 14:50–16:20 D216, V. Dobiáš
INF_2/S04: Thu 16:30–18:00 D216, K. Antoš
INF_2/S05: Mon 13:05–14:35 D316, J. Jelínek

Prerequisites

MAX_KOMBINOVANYCH ( 100 ) && MAX_PREZENCNICH ( 140 )
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
• 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.
• KRUCZEK, A.: Microsoft Access 2010 - Podrobná uživatelská příručka, Computer Press, 2010, 392 str., ISBN 978-80-251-3289-0
• 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 : 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.

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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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 can also be completed outside the examination period.
The course is taught annually.

INF_2 Informatics II

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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.

INF_2 Informatics II

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

Mgr. Václav Dobiáš (seminar tutor)
Ing. Petr Hanzal, 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

Timetable of Seminar Groups

INF_2/K9: Sat 2. 11. 8:45–9:30 B1, 9:40–11:10 B1, V. Dobiáš
INF_2/K9a: Sun 24. 11. 15:15–16:45 D216, V. Dobiáš, Konzultace v PC učebně
INF_2/K9b: Sun 24. 11. 15:15–16:45 D316, P. Hanzal, Konzultace v PC učebně
INF_2/S01: Wed 13:10–14:40 D316, V. Dobiáš
INF_2/S02: Fri 9:55–11:25 D315, V. Dobiáš
INF_2/S03: Fri 13:10–14:40 D216, V. Dobiáš

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.

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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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. The content of final test will be Digital images editing and the basics of computer graphics and Advanced presentation. The minimum required value for the successful completion is 70% of available points (49 points). Successful graduates of the course have to get totally at least 70 points. Points from both tests are summed. A: 100 – 98, B: 97,99 – 91, C: 90,99 – 80, D: 79,99 – 73, E: 72,99 – 70, F: 69,99 – 0. Range of the final test: passed 70 – 49 points; failed, it is possible to get one new attempt 48,99 – 21 points; failed 20,99 – 0 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.

INF_2 Informatics II

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. Petr Hanzal, Ph.D. (seminar tutor)
Ing. Jiří Jelínek, CSc. (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/D1: Sat 4. 5. 8:45–9:30 B2, 9:40–11:10 B2, P. Hanzal
INF_2/D1a: Sun 5. 5. 18:25–19:55 D316, P. Hanzal
INF_2/D1b: Sun 5. 5. 18:25–19:55 D216, K. Antoš
INF_2/E1: Sun 28. 4. 8:00–9:30 E1, 9:40–10:25 E1, P. Hanzal
INF_2/E1a: Sat 11. 5. 8:00–9:30 D216, P. Hanzal
INF_2/E1b: Sat 11. 5. 8:00–9:30 D316, K. Antoš
INF_2/E1c: Sat 11. 5. 9:40–10:25 D216, P. Hanzal
INF_2/E1d: Sat 11. 5. 9:40–10:25 D316, K. Antoš
INF_2/E1e: Sat 11. 5. 12:00–13:30 D216, P. Hanzal
INF_2/E1f: Sat 11. 5. 12:00–13:30 D316, K. Antoš
INF_2/E1g: Sat 11. 5. 13:40–15:10 D216, P. Hanzal
INF_2/E1h: Sat 11. 5. 13:40–15:10 D316, K. Antoš
INF_2/E1i: Sat 11. 5. 15:15–16:45 D216, P. Hanzal
INF_2/E1j: Sat 11. 5. 15:15–16:45 D316, K. Antoš
INF_2/E1k: Sat 11. 5. 16:50–18:20 D216, P. Hanzal
INF_2/E1l: Sat 11. 5. 16:50–18:20 D316, K. Antoš
INF_2/S01: Mon 8:15–9:45 D316, P. Hanzal
INF_2/S02: Mon 9:55–11:25 D316, V. Dobiáš
INF_2/S03: Tue 9:55–11:25 D316, V. Dobiáš
INF_2/S04: Mon 11:35–13:05 D316, V. Dobiáš
INF_2/S05: Fri 11:35–13:05 D216, V. Dobiáš
INF_2/S06: Mon 11:35–13:05 D216, K. Antoš
INF_2/S07: Tue 13:10–14:40 D216, V. Dobiáš
INF_2/S08: Wed 13:10–14:40 D216, V. Dobiáš
INF_2/S09: Fri 13:10–14:40 D216, V. Dobiáš
INF_2/S10: Mon 13:10–14:40 D216, K. Antoš
INF_2/S11: Wed 13:10–14:40 D315, K. Antoš
INF_2/S12: Fri 13:10–14:40 D316, K. Antoš
INF_2/S13: Fri 14:45–16:15 D216, V. Dobiáš
INF_2/S14: Mon 14:45–16:15 D315, K. Antoš
INF_2/S15: Wed 16:20–17:50 D315, V. Dobiáš
INF_2/S16: Fri 16:20–17:50 D216, V. Dobiáš
INF_2/S17: Thu 16:20–17:50 D216, K. Antoš
INF_2/S18: Mon 17:55–19:25 D216, K. Antoš
INF_2/S19: Thu 9:55–11:25 D315, J. Jelínek

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.

Syllabus

• 1. - 3. 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
• 4. - 5. 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
• 6. - 8. 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)
• 9. - 13. 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)

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, T., KUBÁLKOVÁ, M.: Manažerská informatika. Prezentační program Microsoft PowerPoint verze 2002 CZ. Praha, VŠE 2002. ISBN 80-245-0432-4. 94 strany.
• 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
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	7	10
Preparation for Seminars, Exercises, Tutorial	12	27
Preparation for the Final Test	7	10
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

Assessment Methods and Assesment Rate

Test – mid-term 50 %
Test – final 50 %

Exam conditions

Tests of the knowledge and practical skills on PC during the semester. For the successful completion of this course, you must get at least 50% points from each part (each test) and 60% of the total points (total weights of every test is 0.5).

Language of instruction

Czech

Further Comments

The course can also be completed outside the examination period.
The course is taught annually.

INF_2 Informatics II

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

Mgr. Václav Dobiáš (seminar tutor)
Ing. Petr Hanzal, Ph.D. (seminar tutor)
Ing. Jiří Jelínek, CSc. (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/ccv: Fri 16. 11. 13:00–14:30 D216, Fri 14. 12. 12:20–14:35 D216, Fri 4. 1. 13:00–13:45 D216, Fri 11. 1. 12:20–13:05 D216, V. Dobiáš, J. Jelínek, CCV - výuka v rámci CŽV

Prerequisites

OBOR ( CAP )
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. - 3. 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
• 4. - 5. 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
• 6. - 8. 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)
• 9. - 13. 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)

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, T., KUBÁLKOVÁ, M.: Manažerská informatika. Prezentační program Microsoft PowerPoint verze 2002 CZ. Praha, VŠE 2002. ISBN 80-245-0432-4. 94 strany.
• 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
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	7	10
Preparation for Seminars, Exercises, Tutorial	12	27
Preparation for the Final Test	7	10
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

Assessment Methods and Assesment Rate

Test – mid-term 50 %
Test – final 50 %

Exam conditions

Tests of the knowledge and practical skills on PC during the semester. For the successful completion of this course, you must get at least 50% points from each part (each test) and 60% of the total points (total weights of every test is 0.5).

Language of instruction

Czech

Further Comments

The course can also be completed outside the examination period.
The course is taught annually.

INF_2 Informatics II

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

Mgr. Václav Dobiáš (seminar tutor)
Ing. Jaromír Falada (seminar tutor)
Ing. Jiří Jelínek, CSc. (seminar tutor)
Ing. Aleš Márovec (seminar tutor)
Mgr. Václav Šimandl (seminar tutor)
Mgr. Radek Vejmelka (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/L1: Sat 5. 5. 16:00–16:45 B1, 16:50–18:20 B1, 18:25–19:55 B1, J. Jelínek, Kombinovaná forma
INF_2/L2: Sat 12. 5. 18:25–19:10 B1, Sun 27. 5. 12:00–13:30 B1, 13:40–15:10 B1, J. Jelínek, Kombinovaná forma
INF_2/S01: Fri 8:15–9:45 D216, R. Vejmelka
INF_2/S02: Wed 9:55–11:25 D216, R. Vejmelka
INF_2/S03: Wed 8:15–9:45 D216, R. Vejmelka
INF_2/S04: Wed 11:35–13:05 D216, R. Vejmelka
INF_2/S05: Tue 9:55–11:25 D216, R. Vejmelka
INF_2/S06: Tue 8:15–9:45 D216, R. Vejmelka
INF_2/S07: Tue 11:35–13:05 D216, R. Vejmelka
INF_2/S08: Fri 11:35–13:05 D216, R. Vejmelka
INF_2/S09: Fri 9:55–11:25 D216, R. Vejmelka
INF_2/S10: Wed 13:10–14:40 D216, R. Vejmelka
INF_2/S11: Wed 14:45–16:15 D216, R. Vejmelka
INF_2/S12: Mon 9:55–11:25 D216, V. Dobiáš
INF_2/S13: Mon 8:15–9:45 D216, V. Dobiáš
INF_2/S14: Mon 11:35–13:05 D216, V. Dobiáš
INF_2/S15: Thu 9:55–11:25 D215, V. Šimandl
INF_2/S16: Thu 11:35–13:05 D216, V. Šimandl
INF_2/S17: Mon 13:10–14:40 D216, V. Dobiáš
INF_2/S19: Tue 13:10–14:40 D216, J. Jelínek
INF_2/S20: Tue 14:45–16:15 D216, J. Jelínek

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.

Syllabus

• 1. - 3. 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
• 4. - 5. 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
• 6. - 8. 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)
• 9. - 13. 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)

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, T., KUBÁLKOVÁ, M.: Manažerská informatika. Prezentační program Microsoft PowerPoint verze 2002 CZ. Praha, VŠE 2002. ISBN 80-245-0432-4. 94 strany.
• 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
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	7	10
Preparation for Seminars, Exercises, Tutorial	12	27
Preparation for the Final Test	7	10
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

Assessment Methods and Assesment Rate

Test – mid-term 50 %
Test – final 50 %

Exam conditions

Tests of the knowledge and practical skills on PC during the semester. For the successful completion of this course, you must get at least 50% points from each part (each test) and 60% of the total points (total weights of every test is 0.5).

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.
General note: Vypsán pouze pro uznání předmětů.

INF_2 Informatics II

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

Mgr. Radek Vejmelka (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/ccv: Mon 7. 11. 11:00–12:00 D316, Mon 21. 11. 11:00–12:00 D316, R. Vejmelka

Prerequisites

Knowledge is assumed 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

In the course "Informatics I" students will gain and complement knowledge and practical skills in using personal computers in the range of the ECDL modules M9, M5 and M6 and partly AM6. After completing 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 about the principles of 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. Also here they will be familiar with basic concepts and be able to use applications for creating databases and working with them.

Syllabus

• 1. 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
• 2. 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
• 3. 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)
• 4. 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)

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, T., KUBÁLKOVÁ, M.: Manažerská informatika. Prezentační program Microsoft PowerPoint verze 2002 CZ. Praha, VŠE 2002. ISBN 80-245-0432-4. 94 strany.
• 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
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	7	10
Preparation for Seminars, Exercises, Tutorial	12	27
Preparation for the Final Test	7	10
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

Assessment Methods and Assesment Rate

Test – mid-term 50 %
Test – final 50 %

Exam conditions

Tests of the knowledge and practical skills on PC during the semester. For the successful completion of this course, you must get at least 50% points from each part (each test) and 60% of the total points (total weights of every test is 0.5).

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.
General note: Vypsán pouze pro uznání předmětů.

INF_2 Informatics II

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Jaromír Falada (seminar tutor)
Mgr. Radek Vejmelka (seminar tutor)
Ing. Petra Bednářová, Ph.D. (assistant)

Guaranteed by

Ing. Radim Galko, Ph.D.
Department of Civil Engineering – Faculty of Technology – Rector – Institute of Technology and Business in České Budějovice

Timetable of Seminar Groups

INF_2/K1: Mon 11. 4. 15:30–18:40 B4, 18:50–19:35 B4, J. Falada, Kombinovaná forma- PO/UT, automatický zápis skupin
INF_2/K3: Sun 13. 3. 12:10–13:40 A1, Sat 9. 4. 14:35–15:20 A1, 15:30–17:00 A1, J. Falada, Kombinovaná forma- víkend, automatický zápis skupin
INF_2/K4: Sun 13. 3. 15:30–17:00 A4, Sun 22. 5. 12:10–13:40 A1, 13:50–14:35 A1, J. Falada, Kombinovaná forma- víkend, automatický zápis skupin
INF_2/K5: Sun 13. 3. 13:50–15:20 B1, Sat 9. 4. 9:00–9:45 B1, 9:55–11:25 B1, J. Falada, Kombinovaná forma- víkend, automatický zápis skupin
INF_2/01: Fri 12:10–13:40 D216, R. Vejmelka
INF_2/02: Tue 8:15–9:45 D215, R. Vejmelka
INF_2/03: Thu 12:10–13:40 D315, R. Vejmelka
INF_2/04: Thu 8:15–9:45 D315, R. Vejmelka
INF_2/05: Tue 9:55–11:25 D215, R. Vejmelka
INF_2/06: Fri 9:55–11:25 D216, R. Vejmelka
INF_2/07: Fri 13:50–15:20 D216, R. Vejmelka
INF_2/08: Thu 9:55–11:25 D315, R. Vejmelka
INF_2/09: Fri 8:15–9:45 D315, R. Vejmelka

Prerequisites

INF_1 Informatics || IPE_I Informatics for Economists 1
Assumed the good knowledge of word processing and spreadsheet, ways of using the Internet, electronic correspondence and security in IT.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives supported by learning outcomes

In the course Informatics II student acquires the ability for creating electronic presentations, including the right approach at a public presentation, information available in the online environment, an overview of tools for management support and teamwork, and finally experience with a simple graphical editor.

Syllabus

• PowerPoint - pictures, text, scheme, guidelines on the use of colors and fonts
• PowerPoint - backgrounds, templates, object, table, graph
• PowerPoint - animation, timing, multimedia capabilities presentations, presentation and principles of behavior
• Internet - portals of public administration, regional and local management, portals EU, Official Journal of the EU, the CR Gazette, economical servers, business register, ARES, Trade Register, international economic servers - the Securities and Exchange Commission
• Internet - other sources of information on the Internet, libraries, encyclopedias, dictionaries, translation dictionaries on the Internet, agency sources of information,
• Schematics - creation and use of schemas, software tools for creating diagrams and charts
• Management - Systems for time management (eg MS Outlook), including support for PDA devices and other electronic diaries. Using tools for teamwork, versioning and control functions and approval documents.
• Management - Electronic application for the project calls CZ / EU. Basic principles of project management and ICT opportunities.
• Management - computer support for project management. Overview systems. Compilation of real project - individual work.
• Graphics, photos - basic concepts of working with images and photos, pixel, compression, resolution, formats
• Graphics, photos - simple image processing, crop, cut-out, effects, color adjustments, geometric correction
• Graphics, photos - the possibility of a more complex process of paintings and photographs, work with layers, a combination of multiple photos, retouching photos

Literature

• KUBÁLEK, T., KUBÁLKOVÁ, M.: Manažerská informatika. Prezentační program Microsoft PowerPoint verze 2002 CZ. Praha, VŠE 2002. ISBN 80-245-0432-4. 94 strany.
• KUBÁLEK, T., KUBÁLKOVÁ, M.: Microsoft Office Outlook. Elektronický text v e-learningové opoře v ISIS. 24 stran.
• KUBÁLEK, T., KUBÁLKOVÁ, M.: Řízení projektů v Microsoft Office Project. Brno, Computer Press 2007. ISBN 978-80-251-1770-5. 264 stran

Forms of Teaching

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	7	10
Preparation for Seminars, Exercises, Tutorial	12	27
Preparation for the Final Test	7	10
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

Assessment Methods and Assesment Rate

Test – mid-term 50 %
Test – final 50 %

Exam conditions

Tests of the knowledge and practical skills on PC during the semester. For the successful completion of this course, you must get at least 50% points from each part (each test) and 60% of the total points (total weights of every test is 0.5).

Language of instruction

Czech

Further Comments

The course can also be completed outside the examination period.
The course is taught annually.

INF_2 Informatics II

Extent and Intensity

0/2. 2 credit(s). Type of Completion: z (credit).

Teacher(s)

Mgr. Radek Vejmelka (seminar tutor)

Guaranteed by

Ing. Tomáš Dolanský, Ph.D.
Department of Civil Engineering – Faculty of Technology – Rector – Institute of Technology and Business in České Budějovice

Timetable

Sun 17. 10. 12:00–15:00 B4, Sat 8. 1. 12:00–13:30 B4

Prerequisites

INF_1 Informatics
Assumed the good knowledge of word processing and spreadsheet, ways of using the Internet, electronic correspondence and security in IT.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives supported by learning outcomes

In the course Informatics II student acquires the ability for creating electronic presentations, including the right approach at a public presentation, information available in the online environment, an overview of tools for management support and teamwork, and finally experience with a simple graphical editor.

Syllabus

• PowerPoint - pictures, text, scheme, guidelines on the use of colors and fonts
• PowerPoint - backgrounds, templates, object, table, graph
• PowerPoint - animation, timing, multimedia capabilities presentations, presentation and principles of behavior
• Internet - portals of public administration, regional and local management, portals EU, Official Journal of the EU, the CR Gazette, economical servers, business register, ARES, Trade Register, international economic servers - the Securities and Exchange Commission
• Internet - other sources of information on the Internet, libraries, encyclopedias, dictionaries, translation dictionaries on the Internet, agency sources of information,
• Schematics - creation and use of schemas, software tools for creating diagrams and charts
• Management - Systems for time management (eg MS Outlook), including support for PDA devices and other electronic diaries. Using tools for teamwork, versioning and control functions and approval documents.
• Management - Electronic application for the project calls CZ / EU. Basic principles of project management and ICT opportunities.
• Management - computer support for project management. Overview systems. Compilation of real project - individual work.
• Graphics, photos - basic concepts of working with images and photos, pixel, compression, resolution, formats
• Graphics, photos - simple image processing, crop, cut-out, effects, color adjustments, geometric correction
• Graphics, photos - the possibility of a more complex process of paintings and photographs, work with layers, a combination of multiple photos, retouching photos

Literature

• KUBÁLEK, T., KUBÁLKOVÁ, M.: Řízení projektů v Microsoft Office Project. Brno, Computer Press 2007. ISBN 978-80-251-1770-5. 264 stran
• KUBÁLEK, T., KUBÁLKOVÁ, M.: Microsoft Office Outlook. Elektronický text v e-learningové opoře v ISIS. 24 stran.
• KUBÁLEK, T., KUBÁLKOVÁ, M.: Manažerská informatika. Prezentační program Microsoft PowerPoint verze 2002 CZ. Praha, VŠE 2002. ISBN 80-245-0432-4. 94 strany.

Forms of Teaching

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	7	10
Preparation for Seminars, Exercises, Tutorial	12	27
Preparation for the Final Test	7	10
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

Assessment Methods and Assesment Rate

Test – mid-term 50 %
Test – final 50 %

Exam conditions

Tests of the knowledge and practical skills on PC during the semester. For the successful completion of this course, you must get at least 50% points from each part (each test) and 60% of the total points (total weights of every test is 0.5).

Language of instruction

Czech

Further Comments

The course can also be completed outside the examination period.
The course is taught annually.

INF_2 Informatics II

Extent and Intensity

0/2. 2 credit(s). Recommended Type of Completion: z (credit). Other types of completion: zk (examination).

Teacher(s)

Ing. Tomáš Dolanský, Ph.D. (seminar tutor)
Mgr. Lucie Kubů (seminar tutor)
Mgr. Alexander Sandany (seminar tutor)

Guaranteed by

Ing. Tomáš Dolanský, Ph.D.
Department of Civil Engineering – Faculty of Technology – Rector – Institute of Technology and Business in České Budějovice
Contact Person: Ing. Tomáš Dolanský, Ph.D.

Timetable of Seminar Groups

INF_2/01: Tue 8:00–9:30 D315, T. Dolanský
INF_2/02: Tue 9:35–11:05 D315, T. Dolanský
INF_2/03: Tue 14:50–16:20 D315, L. Kubů
INF_2/04: Tue 16:25–17:55 D315, L. Kubů
INF_2/05: Thu 11:25–12:55 D315, L. Kubů
INF_2/06: Wed 8:00–9:30 D315, L. Kubů
INF_2/07: Wed 9:35–11:05 D315, L. Kubů
INF_2/08: Wed 11:25–12:55 D315, L. Kubů
INF_2/09: Wed 13:15–14:45 D315, L. Kubů
INF_2/10: Thu 8:00–9:30 D315, L. Kubů
INF_2/11: Thu 9:35–11:05 D315, L. Kubů
INF_2/12: Wed 8:00–9:30 D215, A. Sandany
INF_2/13: Wed 9:35–11:05 D215, A. Sandany
INF_2/14: Wed 11:25–12:55 D215, A. Sandany
INF_2/15: Wed 13:15–14:45 D215, A. Sandany
INF_2/16: Wed 14:50–16:20 D215, A. Sandany

Prerequisites

INF_1 Informatics
Assumed the good knowledge of word processing and spreadsheet, ways of using the Internet, electronic correspondence and security in IT.

Course Enrolment Limitations

The course is offered to students of any study field.
The capacity limit for the course is 400 student(s).
Current registration and enrolment status: enrolled: 0/400, only registered: 0/400

Course objectives supported by learning outcomes

In the course Informatics II student acquires the ability for creating electronic presentations, including the right approach at a public presentation, information available in the online environment, an overview of tools for management support and teamwork, and finally experience with a simple graphical editor.

Syllabus

• PowerPoint - pictures, text, scheme, guidelines on the use of colors and fonts
• PowerPoint - backgrounds, templates, object, table, graph
• PowerPoint - animation, timing, multimedia capabilities presentations, presentation and principles of behavior
• Internet - portals of public administration, regional and local management, portals EU, Official Journal of the EU, the CR Gazette, economical servers, business register, ARES, Trade Register, international economic servers - the Securities and Exchange Commission
• Internet - other sources of information on the Internet, libraries, encyclopedias, dictionaries, translation dictionaries on the Internet, agency sources of information,
• Schematics - creation and use of schemas, software tools for creating diagrams and charts
• Management - Systems for time management (eg MS Outlook), including support for PDA devices and other electronic diaries. Using tools for teamwork, versioning and control functions and approval documents.
• Management - Electronic application for the project calls CZ / EU. Basic principles of project management and ICT opportunities.
• Management - computer support for project management. Overview systems. Compilation of real project - individual work.
• Graphics, photos - basic concepts of working with images and photos, pixel, compression, resolution, formats
• Graphics, photos - simple image processing, crop, cut-out, effects, color adjustments, geometric correction
• Graphics, photos - the possibility of a more complex process of paintings and photographs, work with layers, a combination of multiple photos, retouching photos

Literature

• KUBÁLEK, T., KUBÁLKOVÁ, M.: Microsoft Office Outlook. Elektronický text v e-learningové opoře v ISIS. 24 stran.
• KUBÁLEK, T., KUBÁLKOVÁ, M.: Řízení projektů v Microsoft Office Project. Brno, Computer Press 2007. ISBN 978-80-251-1770-5. 264 stran
• KUBÁLEK, T., KUBÁLKOVÁ, M.: Manažerská informatika. Prezentační program Microsoft PowerPoint verze 2002 CZ. Praha, VŠE 2002. ISBN 80-245-0432-4. 94 strany.

Forms of Teaching

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	7	10
Preparation for Seminars, Exercises, Tutorial	12	27
Preparation for the Final Test	7	10
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

Assessment Methods and Assesment Rate

Test – mid-term 50 %
Test – final 50 %

Exam conditions

Tests of the knowledge and practical skills on PC during the semester. For the successful completion of this course, you must get at least 50% points from each part (each test) and 60% of the total points (total weights of every test is 0.5).

Language of instruction

Czech

Further Comments

The course can also be completed outside the examination period.
The course is taught annually.

INF_2 Informatics II

The course is not taught in winter 2022

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

Guaranteed by

Ing. Lukáš Polanecký
Lifelong learning Centre – Directorate of Study Administration and Lifelong Learning – Vice-Rector for Study Affairs – 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

Prerequisites

OBOR ( CAP )
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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.
The course is taught: every week.

INF_2 Informatics II

The course is not taught in winter 2021

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

Guaranteed by

Ing. Lukáš Polanecký
Lifelong learning Centre – Directorate of Study Administration and Lifelong Learning – Vice-Rector for Study Affairs – 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

Prerequisites

OBOR ( CAP )
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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.
The course is taught: every week.

INF_2 Informatics II

The course is not taught in winter 2020

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

Guaranteed by

Ing. Lukáš Polanecký
Lifelong learning Centre – Directorate of Study Administration and Lifelong Learning – Vice-Rector for Study Affairs – 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

Prerequisites

OBOR ( CAP )
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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.
The course is taught: every week.

INF_2 Informatics II

The course is not taught in winter 2019

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

Guaranteed by

Ing. Lukáš Polanecký
Lifelong learning Centre – Directorate of Study Administration and Lifelong Learning – Vice-Rector for Study Affairs – 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

Prerequisites

OBOR ( CAP )
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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.
The course is taught: every week.

INF_2 Informatics II

The course is not taught in winter 2018

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

Guaranteed by

Ing. Jaroslav Staněk, DiS.
Lifelong learning Centre – Directorate of Study Administration and Lifelong Learning – Vice-Rector for Study Affairs – 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

Prerequisites

OBOR ( CAP )
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.
The capacity limit for the course is 140 student(s).
Current registration and enrolment status: enrolled: 0/140, only registered: 0/140

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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.
The course is taught: every week.

INF_2 Informatics II

The course is not taught in winter 2017

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

Guaranteed by

doc. Ing. Zuzana Rowland, MBA, PhD.
Lifelong learning Centre – Directorate of Study Administration and Lifelong Learning – Vice-Rector for Study Affairs – 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

Prerequisites

OBOR ( CAP )
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
• 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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.
The course is taught: every week.

INF_2 Informatics II

The course is not taught in winter 2016

Extent and Intensity

0/2/0. 2 credit(s). Type of Completion: z (credit).

Guaranteed by

doc. Ing. Zuzana Rowland, MBA, PhD.
Department of Informatics and Natural Sciences – Faculty of Technology – Rector – Institute of Technology and Business in České Budějovice
Supplier department: Lifelong learning Centre – Directorate of Study Administration and Lifelong Learning – Vice-Rector for Study Affairs – Rector – Institute of Technology and Business in České Budějovice

Prerequisites

OBOR ( CAP )
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
• 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 : 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.
• 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
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

Activities	Number of Hours of Study Workload
	Daily Study	Combined Study
Preparation for the Mid-term Test	6	10
Preparation for Seminars, Exercises, Tutorial	10	22
Preparation for the Final Test	10	15
Attendance on Seminars/Exercises/Tutorial/Excursion	26	5
Total:	52	52

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.
The course is taught: every week.

• Enrolment Statistics (recent)