|
Lecturer(s)
|
-
Urbánek Tomáš, Ing. Ph.D.
-
Kunčar Aleš, Ing.
|
|
Course content
|
The basic rules and principles of working with data: key concepts, design and creation of data structures, relationships, acquisition, editing and storage of data, data security, etc. Obtaining information and data analysis: calculations and functions, sorting, simple and advanced filtering, subtotals, pivot tables, etc. Evaluation and presentation of outcomes: forms, reports, charts, pivot charts, exports, etc. Effective evaluation and increasing of productivity: the choice of optimal instruments for the task, automation of evaluation, control objects, definition of terms, etc.
|
|
Learning activities and teaching methods
|
Lecturing, Monologic (Exposition, lecture, briefing), Exercises on PC, Practice exercises
- Preparation for course credit
- 49 hours per semester
- Home preparation for classes
- 16 hours per semester
- Participation in classes
- 10 hours per semester
|
| learning outcomes |
|---|
| Knowledge |
|---|
| Defines key concepts of data analysis |
| Defines key concepts of data analysis |
| Explains the concept of data processing |
| Explains the concept of data processing |
| Clarifies the difference between distinct types of database systems |
| Clarifies the difference between distinct types of database systems |
| Describes the principle of creation a relational database |
| Describes the principle of creation a relational database |
| Clarifies the difference between spreadsheets and database systems |
| Clarifies the difference between spreadsheets and database systems |
| Skills |
|---|
| Imports data from an external source |
| Imports data from an external source |
| Creates a chart in the MS Excel |
| Creates a chart in the MS Excel |
| Summarizes data using a pivot table or graph |
| Summarizes data using a pivot table or graph |
| Creates a relational database |
| Creates a relational database |
| Decides which type of query to use for data analysis |
| Decides which type of query to use for data analysis |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecturing |
| Monologic (Exposition, lecture, briefing) |
| Monologic (Exposition, lecture, briefing) |
| Lecturing |
| Exercises on PC |
| Exercises on PC |
| Practice exercises |
| Practice exercises |
| assessment methods |
|---|
| Analysis of the student's performance |
| Grade (Using a grade system) |
| Grade (Using a grade system) |
| Analysis of the student's performance |
|
Recommended literature
|
-
Barilla. J., Simr, P., Sýkorová, K. Microsoft Excel 2016: podrobná uživatelská příručka. Brno: Computer Press, 2016. ISBN 978-80-251-4838-9.
-
Belko, P. Microsoft Access 2013: podrobná uživatelská příručka. Brno: Computer Press, 2014. ISBN 978-80-251-4125-0.
-
Laurenčík, M. Excel - pokročilé nástroje: funkce, makra, databáze, kontingenční tabulky, prezentace, příklady. Praha: Grada, 2016. ISBN 978-80-247-5570-0.
-
Laurenčík, M. Excel 2016: práce s databázemi a kontingenčními tabulkami. Praha: Grada, 2017. ISBN 978-80-271-0477-2.
-
MacDonald, Matthew. Access 2007 [elektronický zdroj]. Farnham : O´Reilly,, 2007. ISBN 978-0-596-52760-0.
-
MacDonald, Matthew. Excel 2007 [elektronický zdroj] : the missing manual. Sebastopol, CA : Pogue Press/O´Reilly, 2007. ISBN 978-0-596-52759-4.
-
NAVARRŮ, Miroslav. Excel 2019: podrobný průvodce uživatele. http://www.grada.cz/excel2019. Praha: Grada Publishing, 2019. ISBN 978-80-247-2026-5.
-
Pecinovský, J. 333 tipů a triků pro Microsoft Excel 2013: [sbírka nejužitečnějších postupů a řešení]. Brno: Computer Press, 2014. ISBN 978-80-251-4130-4.
|