Course Details

Information Technology

Academic Year 2025/26

BUA005 course is part of 1 study plan

​ BPC-MI Summer Semester 1st year

Course Guarantor

Ing. Miroslav Menšík, Ph.D.

Institute

Institute of Computer Aided Engineering and Computer Science

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

https://www.vut.cz/en/students/courses/detail/289933

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.