FPF:UIIABP0026 Practical Course in CS II - Course Information
UIIABP0026 Practical Course in Computer Science I
Faculty of Philosophy and Science in OpavaWinter 2024
- Extent and Intensity
- 0/2/0. 2 credit(s). Type of Completion: z (credit).
- Teacher(s)
- doc. RNDr. Lucie Ciencialová, Ph.D. (seminar tutor)
Mgr. Kamil Matula, Ph.D. (seminar tutor)
PhDr. Bc. Jindra Planková, Ph.D. (seminar tutor)
RNDr. Šárka Vavrečková, Ph.D. (seminar tutor) - Guaranteed by
- doc. RNDr. Lucie Ciencialová, Ph.D.
Institute of Computer Science – Faculty of Philosophy and Science in Opava - Timetable of Seminar Groups
- UIIABP0026/A: Mon 13:05–14:40 H4, J. Planková
UIIABP0026/B: Mon 14:45–16:20 H4, J. Planková
UIIABP0026/C: Wed 11:25–13:00 H4, J. Planková - 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
- Computer science and English (programme FPF, In-An-bp)
- 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.-4. 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.
- 5.-8. 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.
- 9.-11. 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. 12.-13. 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.
- 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
- Enrolment Statistics (recent)
- Permalink: https://is.slu.cz/course/fpf/winter2024/UIIABP0026