|
Lecturer(s)
|
-
Jonášová Hana, Ing. Ph.D.
-
Brunclík Tomáš, Ing. Ph.D.
-
Šanda Martin, Ing. Ph.D.
|
|
Course content
|
Data and cell navigation Relative vs. absolute references Logical functions and tests Creating chart outputs Conditional aggregations Text functions Conversion 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 understands Excel as an analytical tool and is able to use both basic and advanced functions.
A student who has successfully completed the course can: explain the principles of MS Excel as a spreadsheet and analytical tool for data processing; distinguish between and justify the use of individual data types, formatting options, and cell addressing methods when designing computational models; characterize the logic and structure of built-in MS Excel functions; describe methods of filtering, sorting, and conditional data processing in data lists; explain the principles of creating chart and pivot outputs as tools for data analysis and interpretation. A student who has successfully completed the course can: design, structure, and edit data tables with regard to their subsequent analytical use; create and combine formulas and functions using appropriate cell addressing and logical relationships; apply filtering, sorting, conditional formatting, and conditional aggregations to identify relationships and patterns in data; prepare, transform, and clean data using text, conversion, and date functions; create, modify, and optimize charts and pivot tables according to the analytical objective and the target user audience. The student who has successfully completed the course is able to: independently selecting and justifying an appropriate data analysis approach using MS Excel tools; integrating acquired knowledge and skills when solving practical tasks based on real-world data; interpreting the results of data analysis and formulating relevant conclusions corresponding to the assigned problem; communicating clearly and persuasively to both experts and non-experts information about the nature of professional problems and their own perspective on possible solutions.
|
|
Prerequisites
|
Basic PC skills and fundamental knowledge of MS Excel.
|
|
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 Useful Functions. 2024. ISBN 978-1-63744-137-4.
-
HUMPHREY, M. L. Intermediate Excel 2024. 2024.
-
Lasák, Pavel. Praktické použití funkcí v Excelu. Praha: Grada Publishing, 2021. ISBN 978-80-271-1303-3.
-
LAURENČÍK, M. Excel 2021 - pokročilé nástroje: funkce, databáze, kontingenční tabulky, prezentace, příklady. Praha, 2025. ISBN 978-80-247-4924-2.
-
LAURENČÍK, M. Excel 2021: Práce s databázemi a kontingenčními tabulkami. Praha, 2024. ISBN 978-80-271-3937-8.
-
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.
|