M_ZPD Data Processing

Institute of Technology and Business in České Budějovice
winter 2020
Extent and Intensity
2/4/0. 8 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Karel Zeman, Ph.D., MBA (lecturer)
Guaranteed by
Ing. Lukáš Polanecký
Lifelong learning Centre – Directorate of Study Administration and Lifelong Learning – Vice-Rector for Study Affairs – Rector – Institute of Technology and Business in České Budějovice
Supplier department: School of Expertness and Valuation – Rector – Institute of Technology and Business in České Budějovice
Timetable of Seminar Groups
M_ZPD/CCV: Sun 17. 1. 14:00–17:00 D004, Sun 31. 1. 14:00–17:00 D004, Sun 14. 2. 14:00–17:00 D004, K. Zeman
Prerequisites (in Czech)
OBOR(CAP)
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives supported by learning outcomes
The course deals with the processing of data that are indispensable for managing the company. The aim is to get an overview of various methods, how data can be processed and analyzed to be a valuable asset in business management.
Learning outcomes
Is able to obtain data both from free and paid data sources; Can use Excel in terms of economics use (basic processes, data transformation and preparation for analysis and analytical procedures, application of statistical methods in Excel); Knows and is able to work with statistical methods in economy; Knows database and CRM systems; Is able to apply procedures associated with decision-making processes and game theory.
Syllabus
  • Data acquisition - Public Resources
  • Data acquisition - paid and special sources (Google Analytics)
  • How to use Excel in economics I - basic procedures
  • How to use Excel in economics II - data transformation and preparation for analysis
  • Statistical Methods in economics I - explanation of basic concepts
  • Statistical Methods in economics II - continued
  • How to use Excel in economics III - analytical procedures and using statistical methods in Excel
  • CRM systems
  • Database systems
  • Data mining
  • Big data
  • Decision-making and game theory I
  • Decision-making and game theory II
Literature
    required literature
  • DLOUHÝ, Martin a Petr FIALA. Úvod do teorie her. Vyd. 1. Praha: Oeconomica, 2007, 114 s. ISBN 978-80-245-1273-0.
  • HINDLS, Richard. Statistika pro ekonomy. 8. vyd. Praha: Professional Publishing, 2007, 415 s. ISBN 978-80-86946-43-6.
  • LEHTINEN, Jarmo. Aktivní CRM: řízení vztahů se zákazníky. 1. vyd. Praha: Grada, 2007, 158 s. Expert (Grada). ISBN 978-80-247-1814-9.
  • SKALSKÁ, Hana. Data mining a klasifikační modely. Vyd. 1. Hradec Králové: Gaudeamus, 2010, 154 s. Recenzované monografie. ISBN 978-80-7435-088-7.
  • VOGLOVÁ, Blanka. Excel a Access: efektivní zpracování dat na počítači. 1. vyd. Praha: Grada, 2004, 252 s. Průvodce (Grada). ISBN 80-247-0703-9
  • MAYER-SCHÖNBERGER, Viktor a Kenneth CUKIER. Big Data. 1. vyd. Brno: Computer Press, 2014, 256 s. ISBN 978-80-251-4119-9.
    recommended literature
  • KISLINGEROVÁ, Eva. Manažerské finance. 3. vyd. V Praze: C.H. Beck, 2010, xxxviii, 811 s. Beckova edice ekonomie. ISBN 978-80-7400-194-9.
  • LAURENČÍK, Marek a Michal BUREŠ. Excel 2013: práce s databázemi a kontingenčními tabulkami. 1. vyd. Praha: Grada, 2014, 176 s. Snadno a rychle (Grada). ISBN 978-80-247-5003-3.
Forms of Teaching
Lecture
Seminar
Tutorial
Consultation
Teaching Methods
Frontal Teaching
Student Workload
ActivitiesNumber of Hours of Study Workload
Daily StudyCombined Study
Preparation for Seminars/Exercises/Tutorial79100
Preparation for the Final test/Final test7087
Attendance on Lectures20 
Attendance on Seminars/Exercises/Tutorial/Excursion3921
Total:208208
Assessment Methods and Assesment Rate
Exam – oral 100 %
Exam conditions
Evaluation: oral exam (100 – 0): A 100 – 90, B 89,99 – 84, C 83,99 – 77, D 76,99 – 73, E 72,99 – 70, FX 69,99 – 30, F 29,99 – 0
Language of instruction
Czech
Further Comments
The course is taught only once.
The course is also listed under the following terms Summer 2016, winter 2016, winter 2018, summer 2021, summer 2022.
  • Enrolment Statistics (winter 2020, recent)
  • Permalink: https://is.vstecb.cz/course/vste/winter2020/M_ZPD