FPF:UBKKBPNP32 Practical Course in CS I - Course Information

UBKKBPNP32 Practical Course in Computer Science I

Extent and Intensity

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

Teacher(s)

doc. RNDr. Lucie Ciencialová, Ph.D. (seminar tutor)
RNDr. Šárka Vavrečková, Ph.D. (seminar tutor)

Guaranteed by

doc. RNDr. Lucie Ciencialová, Ph.D.
Institute of The Czech Language and Library Science – Faculty of Philosophy and Science in Opava

Timetable of Seminar Groups

UBKKBPNP32/A: Tue 21. 9. to Tue 30. 11. Tue 8:05–9:40 B3a, L. Ciencialová, Š. Vavrečková
UBKKBPNP32/B: Tue 21. 9. to Tue 30. 11. Tue 13:05–14:40 B3b, Tue 13:05–14:40 B3a, L. Ciencialová, Š. Vavrečková
UBKKBPNP32/C: Tue 21. 9. to Tue 30. 11. Tue 18:05–19:40 B3a, L. Ciencialová, Š. Vavrečková

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

• Library Science (programme FPF, KNIH-bc)

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

Study Materials
The course can also be completed outside the examination period.

• Enrolment Statistics (Winter 2021, recent)
  
• Permalink: https://is.slu.cz/course/fpf/winter2021/UBKKBPNP32