PMEATK Economic modeling in spreadsheet

Faculty of Economics and Administration
Autumn 2008
Extent and Intensity
0/2. 3 credit(s). Type of Completion: graded credit.
Teacher(s)
Ing. Arnošt Svoboda (seminar tutor)
Ing. Jiří Uličný, CSc. (seminar tutor)
Guaranteed by
prof. Ing. Osvald Vašíček, CSc.
Department of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Contact Person: Lenka Hráčková
Timetable of Seminar Groups
PMEATK/1: Mon 9:20–11:00 VT206, A. Svoboda
PMEATK/10: Wed 14:35–16:15 VT105, J. Uličný
PMEATK/11: Wed 16:20–17:55 VT105, J. Uličný
PMEATK/12: Thu 7:40–9:15 VT203, J. Uličný
PMEATK/13: Fri 12:50–14:30 VT105, J. Uličný
PMEATK/14: Thu 11:05–12:45 VT105, J. Uličný
PMEATK/15: Thu 12:50–14:30 VT203, A. Svoboda
PMEATK/16: Mon 7:40–9:15 VT105, A. Svoboda
PMEATK/17: Fri 9:20–11:00 VT105, J. Uličný
PMEATK/2: Mon 11:05–12:45 VT206, A. Svoboda
PMEATK/3: Mon 12:50–14:30 VT105, A. Svoboda
PMEATK/4: Mon 9:20–11:00 VT105, J. Uličný
PMEATK/5: Mon 11:05–12:45 VT105, J. Uličný
PMEATK/6: Tue 7:40–9:15 VT206, A. Svoboda
PMEATK/7: Tue 10:15–11:50 VT206, A. Svoboda
PMEATK/8: Tue 9:20–11:00 VT105, J. Uličný
PMEATK/9: Fri 11:05–12:45 VT105, J. Uličný
Prerequisites
The course is primarily intented for students of second year of full time studies, for which it is a compulsory course. 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. The aim is to present basic principles of creating economic models to the students and to teach them to understand their meaning and their utilization. The students' knowledge of Spreadsheet Program will be deepened, they will appreciate the benefits of working with it and its further uses. Students will become acquainted with the simple basics of VBA (Visual Basic for Applications) language. This knowledge is necessary for taking part in courses that follow, above all Economic-Mathematical Methods I, and it will also present an indisputable competitive advantage for our graduates in the labour market.
Syllabus
  • Seminar:
  • 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).
  • 12. Setting of seminar work, giving tutorials for seminar work.
  • 13. Seminar work check.
Literature
  • BROŽ, M. Excel pro manažery a ekonomy. 1998. Computer Press. ISBN 80-7226-074-X. info
  • URBÁNEK, Tomáš and Jaroslav ŠKÁRKA. Microsoft Excel 97 pro vědce a inženýry. Vyd. 1. Praha: Computer Press, 1998, xiv, 434. ISBN 8072260995. info
Assessment methods
The lessons take place in a computer classroom, in the form of seminars.
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: Netýká se studentů, kteří absolvovali předmět Informatika pro ekonomy I,II.
The course is also listed under the following terms Autumn 2007.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/econ/autumn2008/PMEATK