FPF:UIINK32 Practical Course in CS I - Course Information
UIINK32 Practical Course in Computer Science I
Faculty of Philosophy and Science in OpavaWinter 2020
- Extent and Intensity
- 0/10/0. 2 credit(s). Type of Completion: z (credit).
- Teacher(s)
- doc. RNDr. Lucie Ciencialová, Ph.D. (seminar tutor)
- Guaranteed by
- doc. RNDr. Lucie Ciencialová, Ph.D.
Institute of Computer Science – Faculty of Philosophy and Science in Opava - Prerequisites (in Czech)
- TYP_STUDIA(B)
- Course Enrolment Limitations
- The course is offered to students of any study field.
- Course objectives
- The aim of the course is to prepare students to create documents with various contents such as texts, tables, and databases.
- Learning outcomes
- Students will be able to:
- create a structured text document with automated text such as a table of content, index, list of tables and figures, references and cross-references;
- Process a spreadsheet document that contains formulas, graphs, and basic functions;
- understand the function and structure of the database and work with the database; - Syllabus
- 1. Text editor: text editor environment, document display settings, principles of text creation on computer, styles, text formatting, style change, typographic and aesthetic rules, inserting objects into text, their properties, text tables, templates, their use and creation, auxiliary functions and tools of text editor, character search and substitution, automatic spell checking, automatic corrections, tracking changes, automatic document content creation, export, data import, PDF format.
- 2. Spreadsheet: function, table structure, formulas and functions, cell addressing, cell editing and filling, table appearance formatting, graph creation, and editing, data filtering and sorting, forms, conditional formatting, data export, and import.
- 3. Relational databases: basic concepts and principles of relational databases, database structure, fields of application of relational databases, inserting and editing data, to import and to export data, work with forms, reports, search queries, filtering. 4. Databases: basics of creating tables and relationships between them, creating and managing tables, forms for easier inserting and displaying data from the database, creating a report to print, compiling simple selection and update queries.
- Literature
- required literature
- PECINOVSKÝ, J. a R. PECINOVSKÝ. Office 2016, průvodce uživatele. Praha: Grada Publishing, a.s., 2016. ISBN 978-80-247-5691-2. info
- recommended literature
- PÍSEK, S. Access 2007 - podrobný průvodce. Praha: Grada. ISBN 978-80-247-1967-2. info
- NAVARRŮ, Miroslav. Excel 2016: podrobný průvodce uživatele. Praha: Grada, 2016. ISBN 978-80-271-0193-1. info
- MARMEL, Elaine J. Teach yourself visually Office 2016. Visual read less, learn more. Indianapolis: a Wiley brand, 2016. ISBN 978-1-119-07477-9. info
- MARMEL, Elaine J. Word 2016. Visual read less, learn more. John Wiley, 2016. ISBN 978-1-119-07466-3. info
- ALEXANDER, Michael and Dick KUSLEIKA. Access 2016 bible. Indianapolis, IN: John Wiley, 2015. ISBN 978-1-119-08654-3. info
- Teaching methods
- Lectures,
tutorial sessions,
regularly assigned and evaluated home tasks. - Assessment methods
- Credit:
Compulsory attendance at seminars min. 75%.
To get the credit it is necessary to get more than 50% points from the tasks assigned during the semester. - Language of instruction
- Czech
- Further comments (probably available only in Czech)
- The course can also be completed outside the examination period.
Information on the extent and intensity of the course: Cvičení 10 HOD/SEM.
- Enrolment Statistics (Winter 2020, recent)
- Permalink: https://is.slu.cz/course/fpf/winter2020/UIINK32