|
Lecturer(s)
|
-
Petr Pavel, doc. Ing. Ph.D.
-
Kašparová Miloslava, Ing. Ph.D.
-
Křupka Jiří, doc. Ing. PhD.
|
|
Course content
|
Key concepts and working with the table processor. Basic information on formulas, functions, working with names. Working with graphs. Handling text and data. Summary calculations, working with pivot tables. Information mining, databases and lists. Introduction to working with conditional functions.
|
|
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
|
|
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 be introduced to main examples of all function types and will be able to decide on the suitable use of these functions in specific situations. They will be capable of working with large-scale documents, to edit data as they wish, to prepare graphs for visual presentation and to analyse data.
|
|
Prerequisites
|
Basic skills in PC and MS Excel utilization.
|
|
Assessment methods and criteria
|
Written examination, Systematic monitoring
Assignment: successful elaboration of given tasks (provided in Stag). Examination: written - elaboration of practical tasks on PC. Detailed information will be provided during the first lecture and in Stag.
|
|
Recommended literature
|
-
Brož, M. Microsoft Excel pro manažery a ekonomy. Computer Press. ISBN 80-251-1307-8.
-
Brož, M. Microsoft Office Excel 2007, Podrobná uživatelská příručka, Computer Press, 408 stran.. Computer Press, 2007. ISBN 9788025118221.
-
Jonášová, Hana. Zpracování dat v Excelu. Pardubice: Univerzita Pardubice, 2009. ISBN 978-80-7395-192-4.
-
Laurenčík, M. EXCEL pro management, ekonomy a podnikatele.. Computer Media, 2012. ISBN 978-80-7402-096-4.
-
Šťastný Z. Matematické a statistické výpočty v Microsoft Excelu. Praha: Computer Press, 1999. ISBN 80-7226-14149-X.
|