UIAI204 Application software I

Faculty of Philosophy and Science in Opava
Winter 2022
Extent and Intensity
6/0/0. 4 credit(s). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Lucie Ciencialová, Ph.D. (lecturer)
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
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. 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)
Study Materials
The course can also be completed outside the examination period.
Information on the extent and intensity of the course: Přednáška 6 HOD/SEM.
The course is also listed under the following terms Winter 2012, Winter 2013, Winter 2014, Winter 2015, Winter 2016, Winter 2017, Winter 2018, Winter 2019, Winter 2020, Winter 2021.
  • Enrolment Statistics (recent)
  • Permalink: https://is.slu.cz/course/fpf/winter2022/UIAI204