Skip to main content
Skip header
Terminated in academic year 2023/2024

Introduction to Programming

Type of study Bachelor
Language of instruction English
Code 155-0597/03
Abbreviation UDP-ENG
Course title Introduction to Programming
Credits 4
Coordinating department Department of Applied Informatics
Course coordinator Ing. Vítězslav Novák, Ph.D.

Subject syllabus

1) Modules, variables, data types, procedures, macros.
2) Controlling of program flow.
3) Arrays
4) Forms and their controls.
5) Error handling.
6) Important VBA functions.
7) Excel and its object model.

Literature

ALEXANDER, Michael a Dick KUSLEIKA. Excel 2016 power programming with VBA. Indianapolis, IN: Wiley, 2016. ISBN 9781119067726 .

WALKENBACH, John. Excel VBA programming for dummies. 4th edition. Hoboken, NJ: Wiley, 2015. ISBN 1119077397 .

Advised literature

HARVEY, Greg. Excel 2016 all-in-one for dummies. Hoboken, NJ: John Wiley & Sons, 2016. ISBN 111907715X .

WALKENBACH, John. Excel 2013 bible. Indianapolis: Wiley, 2013. ISBN 978-1118490365 .