UIAI004 Application software I

Faculty of Philosophy and Science in Opava
Winter 2021
Extent and Intensity
0/2/0. 3 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 Computer Science – Faculty of Philosophy and Science in Opava
Timetable of Seminar Groups
UIAI004/A: Tue 21. 9. to Tue 30. 11. Tue 8:05–9:40 B3a, L. Ciencialová, Š. Vavrečková
UIAI004/B: Tue 21. 9. to Tue 30. 11. Tue 13:05–14:40 B3b, Tue 13:05–14:40 B3a, L. Ciencialová, Š. Vavrečková
UIAI004/C: Tue 21. 9. to Tue 30. 11. Tue 18:05–19:40 B3a, L. Ciencialová, Š. Vavrečková
Prerequisites
The basic principles of working with a PC.
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 different contents such as text, tables and databases.
Syllabus
  • Text editor: the environment of text editor, display settings, the principles of text creating, styles, formatting, typographical and aesthetic rules, inserting objects into the text, their properties, tables, templates, their use and creation, search and replace features, automatic spell checking, automatic creation of document content, export, import data, PDF format.
    Spreadsheet: function, structure of tables, formulas and functions, addressing of cells, editing and filling cells, creating and editing graphs, filtering and sorting data, forms, conditional formatting, export and import data.
    Relational databases: basic concepts and principles of relational databases, database structure, areas of application of relational databases, entering and editing data, import, export data, forms, reports, queries, filtering.
    Database: Fundamentals of tables and the relationships between them, creating and maintaining tables, forms for easier loading and displaying data from a database, creating reports for printing, assembling simple selection and update queries.
Literature
    recommended literature
  • PÍSEK, S. Access 2007 - podrobný průvodce. Praha: Grada. ISBN 978-80-247-1967-2. info
  • Frye, C.,D. Microsoft Access? 2007 Plain and Simple, Redmond. Computer Press, 2007. ISBN 9780735622920. info
  • BROŽ, M. Microsoft Office Excel 2007. Praha: Computer Press, 2007. ISBN 978-80-251-1822-1. info
  • Grover, Ch. Word 2007 for Starters: The Missing Manual, Sebastopol. O'Reilly Media, 2007. ISBN 0-5965-2380-2. info
  • Pírková, K. Word 2007 Podrobná uživatelská příručka. Brno, 2007. ISBN 978-80-2511-571-8. info
  • PECINOVSKÝ, J. WORD 2007. Podrobný průvodce. Praha: Grada Publishing, 2007. ISBN 978-80-247-1959-. info
  • MacDonald, Matthew. Excel 2007: The missing manual. O'Reilly Media, 2006. ISBN 9780596527594. info
Teaching methods
Interactive lecture
Lecture with a video analysis
Lectures, tutorial sessions, regularly assigned and evaluated home tasks.
Assessment methods
Credit
Language of instruction
Czech
Further comments (probably available only in Czech)
Study Materials
The course can also be completed outside the examination period.
Teacher's information
For successful graduation it is necessary to obtain more than 50% of the points from elaborated tasks that are assigned during the semester.
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 2022.
  • Enrolment Statistics (Winter 2021, recent)
  • Permalink: https://is.slu.cz/course/fpf/winter2021/UIAI004