Czech

4

Not applicable.

Institute of Computer Aided Engineering and Computer Science (AIU)

Graduates will acquire skills in structured design of algorithms and their implementation in programming language Visual Basic. They will gain competence in the use of object libraries of language and compatible applications. The course is designed for students to gain the confidence for solving of engineering problems and issues, and not have to rely on the services and products of third parties. Advanced VBA application interface allows students to use their algorithms in other products, especially spreadsheets and CAD. The knowledge and skills in algorithms and programming will enable graduates to the creative use of computer technology in all technical fields.

Basics of algorithm design and programming

Not applicable.

The course is taught through lectures, practical classes and self-study assignments. Attendance at lectures is optional, but attendance at classes is compulsory.

Active participation in seminars - 20%, testing of skills of program design and and debugging - 80%.

1. Development environment for Visual Basic, working with project.
2. Variables, data types, constants. Assignment statement.
3. Functions and procedures (global and local variables, methods of parameter passing).
4. Built-in functions and commands, inputs and outputs, mathematical and string functions, advanced library objects.
5. Commands for flow control (structured conditional statement, type of cycle, switches).
6. Objects, their methods and attributes. Event handling.
7. The structure of the text processor's application objects. Using the objects to automate changes in large documents.
8. Application objects of spreadsheet. Automation of engineering tasks in a spreadsheet user interface.
9. Structured variables and using them. Matrix computations.
10. Engineering algorithms: formulation and solution of Initial Problem, graph of trajectory.
11. Engineering Algorithms: Numerical integration, convergence testing.
12. Engineering Algorithms: Automation of data conversion from the internal format of the measuring device, measurement processing.
13. Working with files and forms.

Not applicable.

The course focuses on the structured design of programs dealing with object-oriented and event-driven programming in Visual Basic environment. The course is designed to acquaint students with advanced features and programming language constructs and their use to extend the functionality of current software products. Students will design and debug programs in Visual Basic using the components of modern applications.

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

Not applicable.

Not applicable.

Not applicable.

WIRTH, Nicolas: Algoritmy a štruktúry údajov. Alfa Bratislava, 1988. (CS)
Knuth, D. E.: Fundamental Algorithms. Third Edition.. Addison-Wesley, 1997. (EN)
KRÁL, Martin: Excel VBA. Computer Press, 2010. EAN 9788025123584. (CS)
HALVORSON, Michael: Microsoft Visual Basic. Computer Press, 2010. EAN 9788025131466. (CS)

26 hours, compulsory

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.