|
Lecturer(s)
|
-
Petr Pavel, doc. Ing. Ph.D.
-
Kašparová Miloslava, Ing. Ph.D.
|
|
Course content
|
Basic concepts and principles of working with data files. Basic data processing in spreadsheet MS Excel (eg use of functions, data filtering, creation of pivot tables, data visualization). Classification of data. Data analysis in corresponding software (eg IBM SPSS Statistics, MS Excel). Evaluation of analysis results and their graphical representation (visualization of results).
|
|
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
- Writing a seminar paper
- 60 hours per semester
- Home preparation for classes
- 48 hours per semester
- Contact teaching
- 14 hours per semester
- Independent critical reading
- 10 hours per semester
- Preparation for a credit (assessment)
- 18 hours per semester
|
|
Learning outcomes
|
The aim of the course is to consolidate the knowledge and extend the skills of data collection, analysis and processing, design models and their verification by using the tools of Data Mining and Business Intelligence.
Students will consolidate their knowledge and extend practical skills in the field of data collection, their analysis and processing, model design and verification and interpretation of conclusions. They will learn how to effectively use Data Mining tools in this area.
|
|
Prerequisites
|
Basic knowledge of systems theory II, Data Mining II and Business Intelligence.
|
|
Assessment methods and criteria
|
Home assignment evaluation, Self project defence
Assignment: successful elaboration of given tasks and project.
|
|
Recommended literature
|
-
Brož, M. Microsoft Excel pro manažery a ekonomy. Computer Press. ISBN 80-251-1307-8.
-
Hendl, Jan. 2004. Přehled statistických metod zpracování dat. Analýza a metaanalýza dat. Praha: Portál.
-
Jonášová, Hana. Zpracování dat v Excelu. Pardubice: Univerzita Pardubice, 2009. ISBN 978-80-7395-192-4.
-
Petr, P. Data Mining. Pardubice, 2006.
-
Petr, P. Metody Data Miningu: část II. Pardubice, 2014.
-
Petr, P. Metody Data Miningu: část I. Pardubice, 2014.
-
Řehák, J., Brom, O. SPSS: praktická analýza dat. Brno, 2015.
|