FPF:UIAI004 Application software I

UIAI004 Application software I

Faculty of Philosophy and Science in Opava
Winter 2017

Extent and Intensity

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

Teacher(s)

doc. RNDr. Lucie Ciencialová, Ph.D. (seminar tutor)

Guaranteed by

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)

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.