ESF:BPM_EMTK Economic modeling - Course Information
BPM_EMTK Economic modeling in spreadsheet
Faculty of Economics and AdministrationAutumn 2010
- Extent and Intensity
- 0/2. 4 credit(s). Type of Completion: graded credit.
- Teacher(s)
- Ing. Arnošt Svoboda (seminar tutor)
- Guaranteed by
- RNDr. Luboš Bauer, CSc.
Department of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Contact Person: Lenka Hráčková - Timetable of Seminar Groups
- BPM_EMTK/01: Mon 9:20–11:00 VT206, A. Svoboda
BPM_EMTK/02: Wed 14:35–16:15 VT105
BPM_EMTK/03: Wed 16:20–17:55 VT206
BPM_EMTK/04: Thu 7:40–9:15 VT206
BPM_EMTK/05: Thu 11:05–12:45 VT105
BPM_EMTK/06: Mon 7:40–9:15 VT206
BPM_EMTK/07: Mon 11:05–12:45 VT206, A. Svoboda
BPM_EMTK/08: Mon 12:50–14:30 VT105
BPM_EMTK/09: Tue 7:40–9:15 VT206
BPM_EMTK/10: Tue 10:15–11:50 VT206, A. Svoboda - Prerequisites
- ! PMEATK Economic modeling
It is assumed the students have basic knowledge of the Microsoft Excel Spreadsheet Program. - Course Enrolment Limitations
- The course is offered to students of any study field.
The capacity limit for the course is 410 student(s).
Current registration and enrolment status: enrolled: 0/410, only registered: 0/410, only registered with preference (fields directly associated with the programme): 0/410 - Course objectives
- At present it is inconceivable for an economic university graduate not to be able to solve basic problems of economical analysis by means of the Spreadsheet Program. Regardless of the study branch, a student must be able to manage the basic forms of formalisation and analysis of economical problems. Students will become acquainted with basic principles and methods in the course Economic Modeling in Spreadsheet Program. Drawing on their knowledge obtained in courses they attended during previous semesters (terms), they will learn to create simple economical models, to interpret their results, and to use them for subsequent analysis.
At the end of the course students should be able to:
- understand basic principles of creating economic models, their meaning and their utilization,
- apply deeper knowledge of Spreadsheet, the benefits of working with it and its further uses,
- create own functions with the simple basics of VBA (Visual Basic for Applications) language. - Syllabus
- 1. Basic terms in MS Excel, harmonization of basic knowledge and notions, fundamental rules for model creating, styles and their utilization.
- 2. A budget – the simplest model. Using of “Search solution” tool.
- 3. Scenarios, dependence of formulas, time and date functions.
- 4. Decision, IF, SUMIF, COUNTIF function. Contingent format, user input check.
- 5. Calculation of future values, investment values and pay interest. Graphs, their types and utilization.
- 6. Matrices and work with them. Calculations of simple trends, their setting.
- 7. Data searching, forms and verifying. Search and aggregate function.
- 8. Summaries. Contingent tables and graphs, their applications and settings.
- 9. Introduction to VBA, macros, macro recording, reason of using.
- 10. Task solving by means of VBA, simple VBA own function creating.
- 11. Summary of advanced task solving in VBA, control programme structure (branches and cycles).
- Literature
- Teaching methods
- The lessons take place in a computer classroom, in the form of seminars.
- Assessment methods
- The course is concluded by graded credit based on creating and defending a seminar work.
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- Study Materials
The course is taught annually.
General note: Nezapisují si studenti, kteří absolvovali předměty PMEATK.Předpokládá se základní znalost práce s tabulkovým kalkulátorem.
- Enrolment Statistics (Autumn 2010, recent)
- Permalink: https://is.muni.cz/course/econ/autumn2010/BPM_EMTK