Sylabus predmetu PZE115E - Advanced data processing in Excel (VŠPP - WS 2019/2020)

     Čeština          Angličtina          

Course code: PZE115E
Course title in Czech: Advanced data processing in Excel
Course title in English: Advanced data processing in Excel
Mode of completion and number of credits: Fulfillment of requirements (5 credits)
Mode of delivery: part-time, 8/0 (lectures per period / seminars per period)
Language of instruction: Czech
Course supervisor: RNDr. Michal Bejček, Ph.D.
Name of lecturer: Ing. Ivo Bartoněk (examiner, lecturer)
RNDr. Michal Bejček, Ph.D. (supervisor)
Mgr. Martin Trčka (examiner, lecturer)
Prerequisites: none
Annotation:
-- item not defined --
 
Course contents:
The content of the course has not been saved in this language version.
 
Learning outcomes:
-- item not defined --
 
Input knowledge:
-- item not defined --
 
Learning activities and teaching methods:
-- item not defined --
 
Rámcové podmínky zápočtu:
-- item not defined --
 
Rámcové podmínky zkoušky:
-- item not defined --
 
Study load:
Type of teaching methodCombined form
Lecture/tutorial attendance8 h
Seminar attendance0 h
Preparation for lectures/tutorials20 h
Preparation for seminars0 h
Study of e-learning materials30 h
Homework (self-study batches)40 h
Preparation for the end-of-term credit test32 h
Total130 h
 
Recommended reading:
Basic:
BEZVODA, V. -- BROŽ, M. Microsoft Excel 2007 pro manažery a ekonomy. Praha: Computer Press, 2011. 440 p. ISBN 978-80-251-2116-0.
BEZVODA, V. -- BROŽ, M. Microsoft Excel 2007/2010 Vzorce, funkce, výpočty. Praha: Computer Press, 2011. 616 p. ISBN 978-80-251-3267-8.
DODGE, M. -- DOUGLAS, C S. Mistrovství v Microsoft Excel 2010. Praha: Computer Press, 2011. 936 p. ISBN 978-80-251-3354-5.

Recommended:
MATÚŠ, Z. Excel v příkladech 2010 + CD. Praha: Computer Press, 2011. 325 p. ISBN 978-80-7402-073-5.
LAURENČÍK, M. Praktické příklady v Excelu 2007. Praha: Computer Press, 2008. 216 p. ISBN 978-80-86686-97-4.
ČÍHAŘ, J. 1001 tipů a triků pro Microsoft Excel 2007/2010. Praha: Computer Press, 2011. 488 p. ISBN 978-80-2512-587-8.
CHAJDIAK, J. Štatistické úlohy a ich riešenie v exceli. 2nd ed. Bratislava: Statis, 2013. 344 p. ISBN 978-80-856-5974-0.


Last modification made by Mgr. Nikola Najzarová on 08/16/2019.

Typ výstupu: