|
Lecturer(s)
|
-
Jonášová Hana, Ing. Ph.D.
-
Šanda Martin, Ing. Ph.D.
-
Brunclík Tomáš, Ing. Ph.D.
|
|
Course content
|
Data and cell navigation Relative vs. absolute references Logical functions and tests Creating graphical outputs (charts) Conditional aggregations Text functions Lookup functions Date and time functions Pivot tables and charts
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Work with text (with textbook, with book), Methods of individual activities, Laboratory work
- Preparation for a credit (assessment)
- 10 hours per semester
- Contact teaching
- 39 hours per semester
- Home preparation for classes
- 56 hours per semester
- Team project
- 30 hours per semester
- Data/material collection
- 15 hours per semester
|
|
Learning outcomes
|
The course aims to consolidate students' secondary school knowledge of MS Excel. The student learns to work efficiently with common datasets, create clear tables, use basic functions, organize data, and prepare simple analyses or visualizations.
A student who has successfully completed the course can: explain the basic principles of working with MS Excel; distinguish the use of different types of formatting and methods of cell addressing in MS Excel; list methods of filtering and sorting data in lists; describe options for editing charts; explain the use of individual types of functions in data processing. A student who has successfully completed the course can: design and edit tables and charts in MS Excel; perform filtering and conditional formatting; create formulas using absolute and relative cell references; justify the use of functions for data processing; independently design a data preparation procedure for further data processing and visualization. The student who has successfully completed the course is able to: applying their knowledge, skills, and competencies in MS Excel to data and document processing; independently deciding on an appropriate data processing approach; communicating clearly and persuasively to both experts and non-experts information about the nature of professional problems and their own views on possible solutions.
|
|
Prerequisites
|
Basic skills in PC, MS Excel utilization. Principle of work in this product menu, configuration and help.
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation, Systematic monitoring
Course credit is awarded on the basis of completing the assigned tasks and meeting the point requirements in all required tests.
|
|
Recommended literature
|
-
HUMPHREY, M. L. Excel 2024 for Beginners. 2025. ISBN 978-1-63744-133-6.
-
KLATOVSKÝ, K. Microsoft Excel 2021/365 nejen pro školy.. Prostějov, 2023. ISBN 978-80-7402-451-1.
-
Lasák, Pavel. Praktické použití funkcí v Excelu. Praha: Grada Publishing, 2021. ISBN 978-80-271-1303-3.
-
Navarrů, Miroslav. Excel 2019 . Praha: Grada, 2019. ISBN 978-80-247-2026-5.
-
PECINOVSKÝ, J. PECINOVSKÝ,R. Office2019, Průvodce pro uživatele. Praha, 2019. ISBN 978-80-247-2303-7.
|