BPM_EMTK Economic modeling in spreadsheet

Faculty of Economics and Administration
Spring 2024
Extent and Intensity
0/2/0. 4 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Pavel Lasák (seminar tutor)
Guaranteed by
Ing. Pavel Lasák
Division of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Contact Person: Lenka Hráčková
Supplier department: Division of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Timetable of Seminar Groups
BPM_EMTK/01: Mon 16:00–17:50 VT204, P. Lasák
BPM_EMTK/02: Mon 8:00–9:50 VT204, P. Lasák
Prerequisites
It is assumed the students have basic knowledge of the Microsoft Excel Spreadsheet Program and MS Windows.
Course Enrolment Limitations
The course is offered to students of any study field.
The capacity limit for the course is 80 student(s).
Current registration and enrolment status: enrolled: 50/80, only registered: 1/80, only registered with preference (fields directly associated with the programme): 0/80
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.
Learning outcomes
After graduation, the student is able to work in Excel: - read, edit, and visualize data - working whith pivot tables - Power Query
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. Power Query a Power Pivot.
Literature
    recommended literature
  • LASÁK, Pavel. Praktické použití funkcí v Excelu. první. Grada, 2021, 360 pp. ISBN 978-80-271-1303-3. info
  • NAVARRŮ, Miroslav. Excel 2019 : podrobný průvodce uživatele. První vydání. Praha: Grada Publishing, 2019, 256 stran. ISBN 9788024720265. URL info
    not specified
  • BROŽ, Milan. Microsoft Excel pro manažery a ekonomy pro verze 2000, 2002 a 2003. Vyd. 1. Brno: CP Books, 2005, 424 s. ISBN 8025104990. info
  • BROŽ, Milan. Microsoft Excel pro manažery a ekonomy pro verze 2000, 2002 a 2003. Vyd. 1. Brno: CP Books, 2005, 424 s. ISBN 8025104990. info
Teaching methods
The lessons take place in a computer classroom, in the form of seminars.
Assessment methods
The course is completed by an examination based on the creation and defense of a seminar paper.
Language of instruction
Czech
Further comments (probably available only in Czech)
Study Materials
The course is taught annually.
General note: Předpokládá se základní znalost práce s tabulkovým kalkulátorem.
Teacher's information
Any copying, recording or leaking tests, use of unauthorized tools, aids and communication devices, or other disruptions of objectivity of exams (credit tests) will be considered non-compliance with the conditions for course completion as well as a severe violation of the study rules. Consequently, the teacher will finish the exam (credit test) by awarding grade "F" in the Information System, and the Dean will initiate disciplinary proceedings that may result in study termination.
The course is also listed under the following terms Autumn 2009, Spring 2010, Autumn 2010, Spring 2011, Autumn 2011, Spring 2012, Autumn 2012, Spring 2013, Autumn 2013, Spring 2014, Autumn 2014, Spring 2015, Autumn 2015, Spring 2016, Autumn 2016, Spring 2017, Autumn 2017, Spring 2018, Autumn 2018, Spring 2019, Autumn 2019, Spring 2020, Autumn 2020, Spring 2021, Autumn 2021, Spring 2022, Autumn 2022, Spring 2023, Autumn 2023, Autumn 2024, Spring 2025.
  • Enrolment Statistics (Spring 2024, recent)
  • Permalink: https://is.muni.cz/course/econ/spring2024/BPM_EMTK