S_INF_1 Informatics 1

Institute of Technology and Business in České Budějovice
summer 2021
Extent and Intensity
2/2/0. 6 credit(s). Recommended Type of Completion: zk (examination). Other types 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
S_INF_1/S01: Thu 9:40–11:10 D315, K. Antoš
Prerequisites
FORMA ( P )
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.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40
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.
Learning outcomes
Upon completion of the course the student will be able to: - Understand basic terms related to ICT in general. - to use ICT and to know the basic working principles of ICT components. - Effectively work with a text editor such as MS Word and use its advanced features. - Effectively work with a spreadsheet such as MS Excel and use its advanced features. The abilities listed above will be in the range of ECDL modules M1, M7, M3, M4 and partly also AM3 and AM4.
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
  • Lecture slides for this course.
  • 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.
    recommended literature
  • Microsoft support webpage. http://support.microsoft.com/Product/office/
  • Standard ECDL, http://www.ecdl.com
  • Actual books and online internet tutorials and sources for presented themes in English.
  • 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.
  • 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.
  • 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.
Forms of Teaching
Lecture
Seminar
Exercise
Tutorial
Consultation
Teaching Methods
Frontal Teaching
Group Teaching - Competition
Group Teaching - Cooperation
Critical Thinking
Computer supported learning
Student Workload
ActivitiesNumber of Hours of Study Workload
Daily StudyCombined Study
Preparation for the Mid-term Test20 
Preparation for Seminars, Exercises, Tutorial26 
Preparation for the Final Test30 
seminar tasks28 
Attendance on Lectures26 
Attendance on Seminars/Exercises/Tutorial/Excursion26 
Total:1560
Assessment Methods and Assesment Rate
Test – mid-term 30 %
Test – final 70 %
Exam conditions
First Test: 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: A 100 – 90, B 89,99 – 84, C 83,99 – 77, D 76,99 – 73, E 72,99 – 70, FX 69,99 – 30, F 29,99 - 0.
Language of instruction
English
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 subject in a semester. Material and technical support: - Complete installation of MS Office 2010, including MS Access, Czech and English version - Client for cloud storage system ownCloud Equipment and furnishing: - A data projector, screen, speakers, HDMI connectivity for external notebook
The course is also listed under the following terms summer 2015, winter 2015, Summer 2016, winter 2016, summer 2017, winter 2017, summer 2018, winter 2018, summer 2019, winter 2019, summer 2020, winter 2020.
  • Enrolment Statistics (recent)
  • Permalink: https://is.vstecb.cz/course/vste/summer2021/S_INF_1