Students will know theoretically and practically the philosophy of creating simple and more complex applications based on knowledge of general and modern programming techniques and algorithms, including knowledge of a specific development tool.

Basic knowledge of MS Excel from secondary school and high school curriculum

The course is taught in the form of lectures, which are in the nature of an explanation of the basic principles and theory of the discipline. The exercises are based on practical practice of the lectures and on voluntary consultations to solve a specific problem on a given project.

In order to obtain a classified credit, it is necessary to obtain at least 50 points out of a total of 100 points for the semester project in VBA MS Excel. The project assignment will be published the second week of the semester.

1. Truth table, ASCII, Number systems, conversion between number systems. Introduction excel, formatting, functions, stacked and combined functions, filtering, sorting data.
2. Creating, modifying and using graphs, contingency tables.
3. Introduction to VBA, forms, sheet and workbook event procedures.
4. ActiveX controls
5. Objects, methods, properties, events, Range, Offset and Cells properties.
6. Variables, constants, working with variant data type, finding the variable data type
7. Structured variables, interfacing with ActiveX controls
8. Conditions, branching
9. Cycles with a constant number of repetitions, with a control condition at the beginning and end of the cycle, cycles of elements of a set or collection (for each in)
10. Procedures, functions, modules, overloading
11. Error handling techniques
12. Working with files, prints
13. Final consultation on projects

The main goal is to learn programming techniques with the support of current development tools in the creation of user programs or more complex projects.

Lectures (even week) are optional, exercises in the even week are compulsory - practicing the material presented in the lecture, exercises in the odd week are optional, so called consultation exercises, designed to solve a specific problem related to the solution of the semester project or practiced material.

• Programme BAK-MIn Bachelor's, 1. year of study, summer semester, compulsory
  

1. Repetition from high school: functions of MS Excel, filtering, sorting, number systems
2. Project assignment, MS Excel charts
3. Introduction to VA, forms, sheet and workbook event procedures, ActiveX controls
4. Consultation exercises
5. Objects, methods, properties, events, Range, Offset and Cells properties, simple data types
6. Consultation exercises
7. Structured variables, interfacing with ActiveX controls, conditions, branching
8. Consultation exercises
9. Loops, conditions, branching, error handling
10. Consultation exercises
11. Procedures, functions, modules, files
12. Consultation exercises
13. Consultation exercises