Course detail

Modern Programming Techniques

FAST-NUB020Acad. year: 2023/2024

Design of programs and applications in Microsoft Visual Basic and VBA.
Basic algorithms, structured programming, object-oriented programming, application object libraries and their use, solving engineering problems.

Language of instruction

Czech

Number of ECTS credits

4

Mode of study

Not applicable.

Guarantor

doc. RNDr. Jiří Macur, CSc.

Department

Institute of Computer Aided Engineering and Computer Science (AIU)

Entry knowledge

algorithm design and programming in VBA

Rules for evaluation and completion of the course

Extent and forms are specified by guarantor’s regulation updated for every academic year.

Aims

Topics include structured program design, event-drive programming, and Visual Basic program components. This is a course designed to introduce students to more advanced elements Visual Basic programming language. Students will design and write Windows applications in Visual Basic.


Programming in Visual Basic using modern techniques of events driven programming, component technology and object-oriented programming

Study aids

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Král, M. 2012. Excel VBA - Výukový kurz, Computer Press, Brno, ISBN 978-80-251-2358-4 (CS)
Macur, J., Menšík, M., Apeltauer, T.  Algoritmizace a programování v inženýrských úlohách. Elektronické učební texty FAST VUT, 2017, Brno. (CS)
Macur, J., Menšík, M. Objektově orientované programování a aplikační modely. Elektronické učební texty FAST VUT, 2017, Brno (CS)
Macur, J. Řešené inženýrské úlohy v prostředí VBA. Elektronické učební texty FAST VUT, 2017, Brno (CS)

Recommended reading

Not applicable.

Classification of course in study plans

  • Programme NPC-GK Master's, 1. year of study, winter semester, compulsory-optional

Type of course unit

 

Lecture

13 hours, optionally

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.

Syllabus

  1. Computer model from the perspective of a programmer. Language development environment.
  2. Variables, data types, constants, assignment statement.
  3. Commands for flow control, conditional statements and loops.
  4. Functions and procedures (calling of procedures and functions, parameters and arguments, public and private scopes).
  5. Local and global variables, processes and their co-operation.
  6. Built-in language elements fo inputs and outputs. Output formatting.
  7. Working with structured variables.
  8. Structured and object-oriented programming.
  9. Application object libraries.
  10. Fundamentals of using of numerical methods.
  11. Examples of solving of engineering problems. Statistical and optimization problems.
  12. Examples of solving of engineering problems. Solution of mechanical task.

Exercise

26 hours, compulsory

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.

Syllabus

1. Development environment, the first program, program compilation and running. 2. Input and output in the program, using simple functions, program for solution of algebraic equations. 3. Decision-making runtime structures, simple cycle, program for the sum of infinite series. 4. User-defined functions and procedures, program for calculating of transcendental functions. 5. Spreadsheet environment for formatted input and output data. Programs for generating worksheets data. 6. Structured variables, programs for matrix operations and statistical calculations. 7. Use of object library for charting, program for solving initial value problems. 8. Algorithms for simulation and animation, program for simulation and visualization of dynamic nonlinear system. 9. Important objects in MS Excel library, program for automated solution of complex engineering problem. 10. Object Library of MS Word, programs for automated document processing. 11. Library for working with files, programs for automated processing and data conversion. 12. Programs for solving large deformation of the nonlinear continuum mechanics. 13. Testing of skills – program development and debugging.