| Course Unit Code | 155-0597/03 |
|---|
| Number of ECTS Credits Allocated | 4 ECTS credits |
|---|
| Type of Course Unit * | Choice-compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | English |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| NOV21 | Ing. 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 |