Skip to main content
Skip header

ECTS Course Overview



Introduction to Programming

* Exchange students do not have to consider this information when selecting suitable courses for an exchange stay.

Course Unit Code155-0597/03
Number of ECTS Credits Allocated4 ECTS credits
Type of Course Unit *Choice-compulsory
Level of Course Unit *First Cycle
Year of Study *
Semester when the Course Unit is deliveredSummer Semester
Mode of DeliveryFace-to-face
Language of InstructionEnglish
Prerequisites and Co-Requisites Course succeeds to compulsory courses of previous semester
Name of Lecturer(s)Personal IDName
NOV21Ing. Vítězslav Novák, Ph.D.
Summary
The main goals are the programming paradigm and the fundamentals of the Visual Basic for Applications programming language. The aim of this subject is to manage creating a simple program on the spreadsheet environment of Microsoft Excel.
Learning Outcomes of the Course Unit
Obtaining the base knowledge in the areas of the programming and Visual Basic for Application programming language.
Applying and using the knowledge and skills in the area of basic programs creation.
Course Contents
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.
Recommended or Required Reading
Required Reading:
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.
BENÁČANOVÁ, Helena. Tvorba aplikací v MS Office Excel. Praha: Oeconomica, 2012. ISBN 978-80-245-1899-2.

KRÁL, Martin. Excel VBA: výukový kurz. Brno: Computer Press, 2010. ISBN 978-80-251-2358-4.
Recommended Reading:
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.
LAURENČÍK, Marek. Excel - pokročilé nástroje: funkce, marka, databáze, kontingenční tabulky, prezentace, příklady. Praha: Grada, 2016. ISBN 978-80-247-5570-0.

BARILLA, Jiří, Pavel SIMR a Květuše SÝKOROVÁ. Microsoft Excel 2016: podrobná uživatelská příručka. Brno: Computer Press, 2016. ISBN 978-80-251-4838-9.
Planned learning activities and teaching methods
Lectures, Tutorials, Project work, Other activities
Assesment methods and criteria
Tasks are not Defined