Course Details

Information Technology

Academic Year 2024/25

BUA005 course is part of 1 study plan

BPC-MI Summer Semester 1st year

Course Guarantor

Institute

Language of instruction

Czech

Credits

6 credits

Semester

summer

Forms and criteria of assessment

course-unit credit and examination

Offered to foreign students

Not to offer

Course on BUT site

Lecture

13 weeks, 2 hours/week, elective

Syllabus

1. The environment for developing VBA applications – more than the editor. 2. Basic data types. How to work with them. Variable vs. Excel cell. 3. How affect the processing of orders. Solution conditions and repeated execution of orders. 4. Since scalar variables to fields. Indices, vectors, matrices. 5. What is a macro? Generator of macros in MS Office. 6. Build custom formulas or custom functions. 7. Visual design of the user interface. 8. Proposal forms and event handling. 9. Why were created classes and objects. Definition of simple classes and objects in VBA. 10. How to work with MS Office documents. 11. What is the object model. 12. Example solving optimization and mechanical problems.

Exercise

13 weeks, 2 hours/week, compulsory

Syllabus

1. We use a macro to simplify the work in a spreadsheet 2. Variable vs. constant, assign values to memory. 3. Methods vs. attributes. We learn first automatic steps. 4. Retrieving values from a table and writes the results table. 5. Checking our running macros using conditions. 6. Unlocking our computer through the cycle. 7. Cycles continued. 8. Debugging of our macros. 9. Scripting the numerical series and its suma. 10. Scripting text based data processing and analysis. 11. Scripting numerical solutions of equations. 12. Scripting statistical and optimization tasks. Scripting solution of mechanical tasks.