Course detail

Programming Techniques

FP-Mpt1KAcad. 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

Ing. Petr Dydowicz, Ph.D.

Department

Institute of Informatics (ÚI)

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

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

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.

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
Král Martin, Excel VBA - Výukový kurz, Computer Press, Brno 2010, ISBN: 978-80-251-2358-4
Walkenbach John : Microsoft Excel 2000&2002; programování ve VBA, Computer Press, Praha 2001, ISBN: 80-7226-547-4

Recommended reading

Breden Melanie, Schwimmer Michael, : Excel 2007 VBA, Velká kniha řešení, Computer Press, Praha 2009, ISBN: 978-80-251-2698-1
D.F.Scott Velká kniha programování v Microsoft Office 2000, Computer

Classification of course in study plans

Type of course unit

 

Guided consultation in combined form of studies

20 hod., optionally

Teacher / Lecturer

Ing. Petr Dydowicz, Ph.D.