BPE_INF Informatika pro ekonomy

Institute of Technology and Business in České Budějovice
summer 2022
Extent and Intensity
2/2/0. 5 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Bc. Karel Antoš, Ph.D. (seminar tutor)
Bc. Mgr. Zuzana Beňová, MSc. (seminar tutor)
Ing. Jiří Jelínek, CSc. (seminar tutor)
doc. Ing. Jarmila Straková, Ph.D., MBA (assistant)
Guaranteed by
Ing. Roman Danel, Ph.D.
Department of Informatics and Natural Sciences – Faculty of Technology – Rector – Institute of Technology and Business in České Budějovice
Supplier department: Institute of Technology and Business in České Budějovice
Timetable of Seminar Groups
BPE_INF/E1: Sat 5. 3. 13:05–14:35 E1, 14:50–16:20 E1, 16:30–18:00 E1, Sat 2. 4. 8:00–9:30 E1, 9:40–11:10 E1, Sat 14. 5. 8:00–9:30 B2, 9:40–11:10 B2, 11:25–12:55 B2, Z. Beňová
BPE_INF/P01: Tue 18:10–19:40 E1, J. Jelínek
BPE_INF/S01: Fri 11:25–12:55 N012, K. Antoš
BPE_INF/S02: Fri 13:05–14:35 N012, K. Antoš
BPE_INF/S03: Fri 14:50–16:20 N012, K. Antoš
BPE_INF/S04: Tue 16:30–18:00 D215, K. Antoš
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 also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
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.
Learning outcomes
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
  • Pecinovský, Josef, 1946-. Excel a Access 2010 : efektivní zpracování dat na počítači. Josef Pecinovský. 2., aktualiz. vyd. Praha : Grada, 2011. 198 s. (Průvodce). V tiráži uvedeno chybně 1. vyd. ISBN 978-80-247-3898-7.
  • Prezentace vyučujícího k předmětu
  • JELÍNEK, Jiří and Jaromír FALADA. Informatika I : studijní opora pro kombinované studium. 1. vyd. České Budějovice: Vysoká škola technická a ekonomická v Českých Budějovicích, 2012, 29 pp. ISBN 978-80-7468-003-8. info
    recommended literature
  • Standard ECDL, http://www.ecdl.cz
  • KUBÁLKOVÁ, Markéta, KUBÁLEK, Tomáš, TOPOLOVÁ, Ivana. Tabulkový program Microsoft Excel 2010. 1. vyd. Brno : Tribun, 2011. 165 s. ISBN 978-80-263-0047-2.
  • TOPOLOVÁ, Ivana, KUBÁLEK, Tomáš, KUBÁLKOVÁ, Markéta. Textový procesor Microsoft Word 2010. 1. vyd. Brno : Tribun, 2012. 117 s. ISBN 978-80-263-0216-2.
  • 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.
  • MESSMER, H. P.: Velká kniha hardware. CP Books, Brno, 2005. ISBN 80-251-0416-8.
    not specified
  • Free MS Office Programs Ebooks from the site http://bookboon.com/en/office-programs-ebooks
  • JELÍNEK, Jiří, FALADA Jaromír.Informatics 1, study support for combined study Bachelors, degree program, VŠTE České Budějovice, 2011.
Forms of Teaching
Lecture
Seminar
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 Test66
Preparation for Lectures26 
Preparation for Seminars, Exercises, Tutorial2682
Preparation for the Final Test206
Attendance on Lectures26 
Attendance on Seminars/Exercises/Tutorial/Excursion2616
Total:130110
Assessment Methods and Assesment Rate
Test – mid-term 30 %
Test – final 70 %
Exam conditions
First test with range from 0 to 30 points. The content of this test is Advanced word processing (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 is 70 points. The content of this test will be Theory of ICT and Advanced work with spreadsheets. 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
Follow-Up Courses
The course is also listed under the following terms summer 2021, winter 2021, winter 2022, SUMMER 2023.
  • Enrolment Statistics (summer 2022, recent)
  • Permalink: https://is.vstecb.cz/course/vste/summer2022/BPE_INF