Course detail
Programming Techniques
FP-PT1Acad. year: 2017/2018
The course is focused in particular on the development of projects and programmes in the development environment in Visual Studio 2010.
Language of instruction
Czech
Number of ECTS credits
5
Mode of study
Not applicable.
Guarantor
Department
Learning outcomes of the course unit
Students will be familiar with the theoretically and practically philosophy of making simple and complex applications on the basis of knowledge of the General and advanced programming techniques and algorithms, including the knowledge of a specific authoring tool.
Prerequisites
1. basic knowledge of programming-algorithms
2. knowledge of Microsoft Excel
2. knowledge of Microsoft Excel
Co-requisites
Not applicable.
Planned learning activities and teaching methods
The course is taught through lectures explaining the basic principles and theory of the discipline. Exercises are focused on practical topics presented in lectures.
Assesment methods and criteria linked to learning outcomes
Checking the results of independent work on assigned tasks. In case of absence a teacher can set additional assignment. The exam has written form, as the case may be oral form and covers the whole issue of the subject focus.
Course curriculum
Přednášky:
1. Tvorba maker v MS Excel
2. Vývojové prostředí VBA
3. Základní pojmy, proměnné, strukturované proměnné, konstanty, typy
4. Objekty, metody, vlastnosti, události
5. Ovládací prvky formuláře a ActiveX
6. Formuláře, dialogy, regulární výrazy
7. Použití API
8. Podmínky
9. Cykly
10. Procedury, funkce, moduly, přetěžování
11. Práce se soubory, tisky
12. Techniky pro ošetření chyb
13. Ladění, optimalizace a dokumentace programu, tvorba projektu
1. Tvorba maker v MS Excel
2. Vývojové prostředí VBA
3. Základní pojmy, proměnné, strukturované proměnné, konstanty, typy
4. Objekty, metody, vlastnosti, události
5. Ovládací prvky formuláře a ActiveX
6. Formuláře, dialogy, regulární výrazy
7. Použití API
8. Podmínky
9. Cykly
10. Procedury, funkce, moduly, přetěžování
11. Práce se soubory, tisky
12. Techniky pro ošetření chyb
13. Ladění, optimalizace a dokumentace programu, tvorba projektu
Work placements
Not applicable.
Aims
The main objective is the adoption of modern programming techniques, with the support of the current development tools for creating user-mode programs or more complex projects.
Specification of controlled education, way of implementation and compensation for absences
During the study period students elaborate the term project on a selected topics depending on the content of the subject base od on the listed areas, or of their own selected topics. Projects are consulted and controlled.
For the project checking and consultation is also used e-learning, where are electronic materials and tests available.
For the project checking and consultation is also used e-learning, where are electronic materials and tests available.
Recommended optional programme components
Not applicable.
Prerequisites and corequisites
Not applicable.
Basic literature
FORSTOVÁ Lenka, VBA Excel v příkladech + CD, Computer media, 2010, ISBN 978-80-7402-042-1 (CS)
Král Martin, Excel VBA - Výukový kurz, Computer Press, Brno 2010, ISBN: 978-80-251-2358-4 (CS)
Walkenbach John : Microsoft Excel 2000&2002; programování ve VBA, Computer Press, Praha 2001, ISBN: 80-7226-547-4 (CS)
Král Martin, Excel VBA - Výukový kurz, Computer Press, Brno 2010, ISBN: 978-80-251-2358-4 (CS)
Walkenbach John : Microsoft Excel 2000&2002; programování ve VBA, Computer Press, Praha 2001, ISBN: 80-7226-547-4 (CS)
Recommended reading
Breden Melanie, Schwimmer Michael, : Excel 2007 VBA, Velká kniha řešení, Computer Press, Praha 2009, ISBN: 978-80-251-2698-1 (CS)
D.F.Scott Velká kniha programování v Microsoft Office 2000, Computer (CS)
D.F.Scott Velká kniha programování v Microsoft Office 2000, Computer (CS)
Classification of course in study plans