Course detail

Informatics

FP-KinfPAcad. year: 2023/2024

The course focuses on the following topics: user competence in Windows operating systém, application software for personal computers (within Windows, work with MS Word text editor, MS Excel chart processor, fundamentals of databases).

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Entry knowledge

1. Basic competence in PC (theoretical and practical)
2. Basic competence in MS Windows operating system.

Rules for evaluation and completion of the course

Conditions for awarding the course-unit credit:
1. Delivery of semester project marked at least with "E".
2. Completion of a written test in the course of semestr marked at least with "E".
3. Active participation in seminars

Form of examination: Combined, composed of two parts:
1. Written part – case study from the field of fundamentals of databases
2. Practical part – solution of a task on PC regarding the practical knowledge of acquired topics.

The grade of the examination is determined by the average of the marks from the two sub-sections. If at least one part of the exam is graded "F", the entire exam is graded "F".

The conditions are the same for students with an individual study plan.

Control of results of independent work on specified tasks. In case of absence from seminars, teacher can set elaboration of additional task.

Aims

The main objective of the course is to provide students with the knowledge and skills necessary for solution of tasks in the field of computer technology focused on software: operating systems (MS Windows), application software (MS Office). The course is also focused on fundamentals of data modeling.
Students will be made familiar with new trends in IT development in the area of PC architecture. They will acquire skills necessary for using MS Windows operating system and MS Office application instrument. These skills and experience may be used by them as an tool for elaborating projects and tasks in other courses.

Study aids

All available study materials are available on elearning.

Recommended literature:

KLATOVSKÝ, Karel. Excel 2021 / 365: nejen pro školy. Prostějov: Computer Media, 2023. 1. vyd. 128 s. ISBN 978-80-7402-451-1.

KLATOVSKÝ, Karel. Word 2021 / 365: nejen pro školy. Prostějov: Computer Media, 2023. 1. vyd. 120 s. ISBN 978-80-7402-450-4.

KOCH, M.; NEUWIRTH, B. Datové a funkční modelování. Datové a funkční modelování. Brno, Cerm. 2010. 139 s. ISBN 978-80-214-4125-5.

Prerequisites and corequisites

Not applicable.

Basic literature

KLATOVSKÝ, Karel. Excel 2021 / 365: nejen pro školy. Prostějov: Computer Media, 2023. 1. vyd. 128 s. ISBN 978-80-7402-451-1.
KLATOVSKÝ, Karel. Word 2021 / 365: nejen pro školy. Prostějov: Computer Media, 2023. 1. vyd. 120 s. ISBN 978-80-7402-450-4.
KOCH, M.; NEUWIRTH, B. Datové a funkční modelování. Datové a funkční modelování. Brno: Cerm, 2010. ISBN: 978-80-214-4125- 5.

Recommended reading

WILSON, K. Essential Office 365 Second Edition: The Illustrated Guide to Using Microsoft Office. 2nd ed. Widnes: Elluminet Press, 2017. 457 p. ISBN 978-1-911174-36-3.
WILSON, K. Essential Office 365 Second Edition: The Illustrated Guide to Using Microsoft Office. 2nd ed. Widnes: Elluminet Press, 2017. 457 p. ISBN 978-1-911174-36-3.

Elearning

Classification of course in study plans

  • Programme BAK-EP Bachelor's 1 year of study, summer semester, compulsory

Type of course unit

 

Lecture

13 hod., optionally

Teacher / Lecturer

Computer-assisted exercise

26 hod., compulsory

Teacher / Lecturer

Syllabus

Topics of seminars are as follows:
- Introduction to Informatics
- Application software (MS Excel, MS Word, MS PowerPoint)
- Data Modeling (Relational Data Model)

Elearning