Course detail

Application Software

FP-APVAcad. year: 2023/2024

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 Informatics (ÚI)

Entry knowledge

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

Rules for evaluation and completion of the course

In order to obtain a classified credit, it is necessary to obtain at least 50 points out of a total of 100 points for the semester project in VBA MS Excel. The project assignment will be published the second week of the semester.

 

Lectures (even week) are optional, exercises in the odd week are compulsory - practicing the material presented in the lecture, exercises in the even week are optional, so called consultation exercises, designed to solve a specific problem related to the solution of the semester project or practiced material.

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

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

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.
FORSTOVÁ Lenka, VBA Excel v příkladech + CD, Computer media, 2010, ISBN 978-80-7402-042-1.
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.

Recommended reading

Not applicable.

eLearning

eLearning: currently opened course

Classification of course in study plans

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

Type of course unit

 

Lecture

13 hours, optionally

Teacher / Lecturer

doc. Ing. Vít Novotný, Ph.D.

Exercise

26 hours, compulsory

Teacher / Lecturer

Ing. Petr Dydowicz, Ph.D.
doc. Ing. Vít Novotný, Ph.D.

eLearning

eLearning: currently opened course