INF_1 Informatics 1

Institute of Technology and Business in České Budějovice
winter 2012
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)
Ing. Petr Hanzal, Ph.D. (seminar tutor)
Ing. Jiří Jelínek, CSc. (seminar tutor)
Mgr. Petr Pánek (seminar tutor)
Mgr. Václav Šimandl (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
Contact Person: Ing. Jiří Jelínek, CSc.
Timetable of Seminar Groups
INF_1/D1: Sat 24. 11. 10:26–11:10 B1, 12:00–13:30 B1, V. Dobiáš, Společná - Kombinovaná forma
INF_1/D1a: Sun 16. 12. 8:00–9:30 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/D1b: Sun 16. 12. 8:00–9:30 D316, K. Antoš, Kombinovaná forma - pc učebna
INF_1/D1c: Sun 16. 12. 9:40–11:10 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/D1d: Sun 16. 12. 9:40–11:10 D316, K. Antoš, Kombinovaná forma - pc učebna
INF_1/D1e: Sun 16. 12. 12:00–13:30 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/D1f: Sun 16. 12. 12:00–13:30 D316, K. Antoš, Kombinovaná forma - pc učebna
INF_1/E1: Sat 10. 11. 8:45–9:30 E1, 9:40–11:10 E1, V. Dobiáš, Společné - Kombinovaná forma
INF_1/E1a: Sat 8. 12. 8:00–9:30 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/E1b: Sat 8. 12. 8:00–9:30 D316, K. Antoš, Kombinovaná forma - pc učebna
INF_1/E1c: Sat 8. 12. 9:40–11:10 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/E1d: Sat 8. 12. 9:40–11:10 D316, K. Antoš, Kombinovaná forma - pc učebna
INF_1/E1e: Sat 8. 12. 12:00–13:30 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/E1f: Sat 8. 12. 12:00–13:30 D316, K. Antoš, Kombinovaná forma - pc učebna
INF_1/E1g: Sat 8. 12. 13:40–15:10 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/E1h: Sat 8. 12. 13:40–15:10 D316, K. Antoš, Kombinovaná forma - pc učebna
INF_1/E1i: Sat 8. 12. 15:15–16:45 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/E1j: Sat 8. 12. 15:15–16:45 D316, K. Antoš, Kombinovaná forma - pc učebna
INF_1/E1k: Sat 8. 12. 16:50–18:20 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/E1l: Sat 8. 12. 16:50–18:20 D316, K. Antoš, Kombinovaná forma - pc učebna
INF_1/E1m: Sat 8. 12. 18:25–19:55 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/K9: Sat 3. 11. 13:40–15:10 B2, 15:15–16:00 B2, V. Dobiáš, Společné - Kombinovaná forma - pc učebna
INF_1/K9a: Sat 1. 12. 16:50–18:20 D315, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/K9b: Sat 1. 12. 16:50–18:20 D215, K. Antoš, Kombinovaná forma - pc učebna
INF_1/K9c: Sat 1. 12. 18:25–19:55 D216, V. Dobiáš, Kombinovaná forma - pc učebna
INF_1/K9d: Sat 1. 12. 18:25–19:55 D316, K. Antoš, Kombinovaná forma - pc učebna
INF_1/S01: Thu 8:15–9:45 D315, K. Antoš
INF_1/S02: Wed 11:35–13:05 D315, K. Antoš
INF_1/S03: Thu 13:10–14:40 D315, K. Antoš
INF_1/S04: Fri 17:55–19:25 D315, K. Antoš
INF_1/S05: Wed 9:55–11:25 D315, K. Antoš
INF_1/S06: Fri 14:45–16:15 D215, K. Antoš
INF_1/S07: Fri 16:20–17:50 D215, K. Antoš
INF_1/S08: Wed 8:15–9:45 D315, K. Antoš
INF_1/S09: Thu 11:35–13:05 D315, K. Antoš
INF_1/S10: Fri 9:55–11:25 D216, V. Dobiáš
INF_1/S11: Wed 13:10–14:40 D216, V. Dobiáš
INF_1/S12: Thu 11:35–13:05 D215, V. Dobiáš
INF_1/S13: Tue 16:20–17:50 D315, V. Dobiáš
INF_1/S14: Fri 8:15–9:45 D215, V. Dobiáš
INF_1/S15: Tue 14:45–16:15 D315, V. Dobiáš
INF_1/S16: Thu 13:10–14:40 D215, V. Dobiáš
INF_1/S17: Wed 16:20–17:50 D316, V. Dobiáš
INF_1/S18: Thu 9:55–11:25 D215, V. Dobiáš
INF_1/S19: Wed 11:35–13:05 D216, V. Dobiáš
INF_1/S20: Wed 13:10–14:40 D215, T. Dolanský
INF_1/S21: Wed 14:45–16:15 D215, T. Dolanský
INF_1/S22: Wed 16:20–17:50 D215, T. Dolanský
INF_1/S23: Mon 9:55–11:25 D315, P. Hanzal
INF_1/S24: Mon 8:15–9:45 D315, P. Hanzal
INF_1/S25: Wed 11:35–13:05 D316, J. Jelínek
INF_1/S26: Wed 13:10–14:40 D316, J. Jelínek
INF_1/S27: Tue 17:55–19:25 D215, P. Pánek
INF_1/S28: Tue 16:20–17:50 D215, P. Pánek
INF_1/S29: Thu 16:20–17:50 D316, P. Pánek
INF_1/S30: Thu 14:45–16:15 D215, P. Pánek
INF_1/S31: Mon 13:10–14:40 D316, V. Šimandl
INF_1/S32: Mon 11:35–13:05 D316, V. Šimandl
INF_1/S33: Mon 9:55–11:25 D316, V. Šimandl
Prerequisites
The student has the knowledge in the range of the ECDL modules M1, M2, M7 among topics taught in the course and listed below.
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives supported by learning outcomes
The aim of the course is gaining and complementing of the knowledge and practical skills in using personal computers in the range of the ECDL modules M1, M7, M3, M4 and partly AM3 and AM4. After the successful completion of the course, the student will be able to understand the concepts related to ICT, to use the Internet and its main services and work effectively with selected MS Office applications when creating and editing text and spreadsheet documents. These skills can be used for creating seminar and bachelor's works.
Syllabus
  • 1. - 2. Adding of the knowledge to the level of ECDL Module M1 (basic concepts of information and communication technology) - hardware (basic terms and parameters), software (breakdown, licenses), computer networks (types, data transfer), use of ICT (basic concepts, communication, community), security (identity, data security, computer viruses), law (copyright, privacy policy)
  • 3. - 4. Adding of the knowledge to the level of ECDL Module M7 (Internet and Communication) - Internet (basic concepts, security, browser settings), searching, saving and printing files, electronic communication (e-mail and other forms, security)
  • 5. - 6. The full ECDL module M3 (Word Processing) - Work with documents, creating a document, formatting text, working with objects, mail merge, printing
  • 7. - 8. The reduced ECDL Module AM3 (Advanced word processing) - an advanced text formatting, links, indexes, fields, collaboration tools, partitions, security and document settings
  • 9. - 10. The full ECDL module M4 (Spreadsheet) - work with tables (create, edit, manage), cells (insert, select, edit, copy, format), lists, formulas and functions (basic use), graphs (creation and editing ), prints
  • 11. - 13. The reduced ECDL Module AM4 (Advanced work with spreadsheet) - Advanced formatting, advanced formulas and functions, data analysis (pivot tables, sorting, filtering), data checking (validation, monitoring), import and export of data, links, collaboration tools, security
Literature
    required literature
  • KUBÁLEK, T., ŠVECOVÁ, L. Tabulkový program MS Excel. Oeconomica,Praha,2006,ISBN 80-245-0491-X
  • KUBÁLEK, T., TOPOLOVÁ, I. Textový procesor MS Word. Oeconomica, Praha, 2006. ISBN 80-245-1016-2
    recommended literature
  • Standard ECDL, http://www.ecdl.cz
  • S počítačem do Evropy : ECDL. kolektiv autorů. 2., aktualiz. vyd. Brno : Computer Press, 2007. 152 s.Na rubu tit. s. jako autoři uvedeni: Olga Štěpánková ... [et al.]. ISBN 978-80-251-1844-3.
  • Pecinovský, Josef, 1946-. Microsoft Office Word 2007 : hotová řešení. Josef Pecinovský. Vyd. 1. Brno : Computer Press, 2009. 232 s. (K okamžitému použití). Obsahuje rejstřík. ISBN 978-80-251-2718-6.
  • Pecinovský, Josef, 1946-. Microsoft Excel 2007 : hotová řešení. Josef Pecinovský. Vyd. 1. Brno : Computer Press, 2008. 247 s. (K okamžitému použití). Obsahuje rejstřík. ISBN 978-80-251-1966-2.
  • YOUNG, M, J. Mistrovství v Microsoft Office 2003. Computer, Brno, 2004. ISBN 80-251-0222-0.
  • MESSMER, H. P.: Velká kniha hardware. CP Books, Brno, 2005. ISBN 80-251-0416-8.
  • PECINOVSKÝ, J.: OpenOffice.org 2.0: kompletní průvodce. Grada Publishing, Praha, 2006. ISBN 80-247-1016-1.
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
ActivitiesNumber of Hours of Study Workload
Daily StudyCombined Study
Preparation for the Mid-term Test710
Preparation for Seminars, Exercises, Tutorial1227
Preparation for the Final Test710
Attendance on Seminars/Exercises/Tutorial/Excursion265
Total:5252
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
Follow-Up Courses
Further Comments
The course can also be completed outside the examination period.
The course is taught annually.
The course is also listed under the following terms Winter 2009, Summer 2010, Winter 2010, summer 2011, winter 2011, summer 2012, summer 2013, winter 2013, summer 2014, winter 2014, summer 2015, winter 2015, Summer 2016, winter 2016, winter 2017, summer 2018, winter 2018, winter 2019, winter 2020, summer 2021.
  • Enrolment Statistics (winter 2012, recent)
  • Permalink: https://is.vstecb.cz/course/vste/winter2012/INF_1