Course detail

Application Software

FP-APVAcad. year: 2026/2027

The course focuses mainly on creating projects and programs in the Visual Basic for Application development environment of MS Excel. The content of the course is teaching the VBA programming language in the MS EXCEL environment in order to acquire basic knowledge and principles of programming and skills in creating simple form programs or custom functions.

Language of instruction

Czech

Number of ECTS credits

4

Mode of study

Not applicable.

Guarantor

Ing. Bernard Neuwirth, Ph.D., MSc

Department

Institute of Quantitative Engineering (ÚKI)

Entry knowledge

Basic knowledge of MS Excel from secondary school and high school curriculum

Rules for evaluation and completion of the course

To obtain a graded credit, it is necessary to obtain at least 50 points out of a total of 100 points for the credit test on VBA MS Excel.

Participation in lectures (odd week) is facultative, exercises in odd weeks are mandatory - practicing the material presented in the lectures, presence on exercises in even weeks is optional, these are so-called consultation exercises, intended for solving questions or problems with homeworks and specific issues on the topics of the material being practiced.

Aims

The main goal is to learn programming techniques with the support of current development tools in the creation of user programs or more complex projects.


Students will know theoretically and practically the philosophy of creating simple and more complex applications based on knowledge of general and modern programming techniques and algorithms, including knowledge of a specific development tool.

Study aids

see recommended study literature and e-learning portal 

Prerequisites and corequisites

Not applicable.

Basic literature

BARILLA, J. Microsoft Excel 2013: Podrobná uživatelská příručka. 1. vyd. Brno: Computer Press, 2013. 496 s. ISBN 978-80-251-4114-4.
FORSTOVÁ Lenka, VBA Excel v příkladech + CD, Computer media, 2010, ISBN 978-80-7402-042-1.
Lambert, Joan. MOS 2016 Study Guide for Microsoft Excel. 1st ed. Redmond: Microsoft Press, 2016. 192 p. ISBN 978-0735699434
MYŠÁK, M. Kontingenční tabulky a grafy: Výukový průvodce. 1. vyd. Brno: Computer Press, 2013. 224 s. 978-80-251-4113-7.

Recommended reading

Not applicable.

Classification of course in study plans

  • Programme BAK-MIn-D Bachelor's 1 year of study, summer semester, compulsory

Type of course unit

 

Lecture

13 hours, optionally

Teacher / Lecturer

Ing. Bernard Neuwirth, Ph.D., MSc

Exercise

26 hours, compulsory

Teacher / Lecturer

Ing. Bernard Neuwirth, Ph.D., MSc

Self-study

45 hours, optionally

Teacher / Lecturer

Ing. Bernard Neuwirth, Ph.D., MSc

Syllabus

Vypracování samostatných úkolů

Individual preparation for an ending of the course

20 hours, optionally

Teacher / Lecturer

Ing. Bernard Neuwirth, Ph.D., MSc

Syllabus

Preparing for the credit from study materials - e-learning and literature