UIIABP0026 Practical Course in Computer Science I

Faculty of Philosophy and Science in Opava
Winter 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
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
The course is also listed under the following terms Winter 2020, Winter 2021, Winter 2022, Winter 2023.
  • Enrolment Statistics (recent)
  • Permalink: https://is.slu.cz/course/fpf/winter2024/UIIABP0026