S_BR_CA1_k Controlling applications I

STING ACADEMY
summer 2026
Extent and Intensity
0/0. 6 credit(s). Type of Completion: graded credit.
Teacher(s)
Ing. Libor Kegler (seminar tutor)
Guaranteed by
doc. Ing. Ondřej Žižlavský, Ph.D.
Centre for Accounting and Taxation – Academic Department – STING ACADEMY
Timetable of Seminar Groups
S_BR_CA1_k/01: Sun 22. 3. 13:00–17:50 BR Učebna 10, Sat 23. 5. 8:45–11:55 BR Učebna 09, Sun 24. 5. 8:45–11:55 BR Učebna 09, 13:00–14:30 BR Učebna 09, L. Kegler
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
The course is focused on the practical solution of specific economic tasks through the application of MS Excel. In particular, it presents MS Excel tools and functions used in reporting and controlling. Students apply the theoretical knowledge acquired in their previous studies within the chosen specialisation and are able to use computer technology to solve selected controlling tasks, including the interpretation of their informational significance.
Syllabus

Seminars:

  1. Data warehouse and structured data – working with large tables
  2. Data warehouse and structured data – pivot tables and data warehouse
  3. Data warehouse and structured data – reporting of the data model
  4. Automated reporting – MS Excel functions applicable in controlling and analyses
  5. Automated reporting – reporting of the data model
  6. Data models and data interface – creation of simple macros
  7. Data models and data interface – import and methods of structuring data for controlling analyses
  8. Financial data model – source data and their processing
  9. Financial data model – comprehensive example of a managerial income statement as a tool for controlling analyses
  10. Data models and their significance – household accounting data model
  11. Data models and their significance – implementation of the data model
  12. Credit test
Assessment methods

Full-time form of study:

Method of course completion – graded credit. Requirements for obtaining the graded credit: successful completion of the credit test during the semester and active participation in seminars.

Combined form of study:

The test required to obtain the graded credit is written. The test covers the content of all individual lectures within the course.

Language of instruction
Czech
The course is also listed under the following terms winter 2025.
  • Enrolment Statistics (recent)
  • Permalink: https://is.newton.cz/course/sting/summer2026/S_BR_CA1_k