Economic Analyses in Spreadsheets Programs Environment
Code | Completion | Credits | Range | Language |
---|---|---|---|---|
14EAT | KZ | 2 | 0+2 | Czech |
- Lecturer:
- Martin Brumovský
- Tutor:
- Martin Brumovský
- Supervisor:
- Department of Informatics and Telecommunications
- Synopsis:
-
Work with spreadsheet programs with the respect to economic problems, use of nested functions and conditional formatting, statistic and mathematic functions. Creation of graphs and other graphic outputs. Data analysis, lists and contingent tables.
- Requirements:
-
tasks algorithmizing, fundamentals of programming, spreadsheet programs fundamentals
- Syllabus of lectures:
- Syllabus of tutorials:
- Study Objective:
-
Acquisition of knowledge in the following fields: effective use of spreadsheet programs - data procession, interpretation, and presentation with the respect to their use in economic practice. Creation of advanced economic analyses.
- Study materials:
-
Jurák Z. a koletiv: Excel pro managment, ekonomy a podnikatele, Computer Media, 2006
Bříza V.: Excel 2007 - podrobný průvodce, Grada, 2007
- Note:
- Time-table for winter semester 2011/2012:
- Time-table is not available yet
- Time-table for summer semester 2011/2012:
- Time-table is not available yet
- The course is a part of the following study plans:
-
- MED bak.komb.10/11 (compulsory course in the program)
- MED bak.prez.11/12 (compulsory course in the program)