Course detail
Information Technology II
FAST-CU01Acad. year: 2012/2013
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
Number of ECTS credits
Mode of study
Guarantor
Department
Learning outcomes of the course unit
Prerequisites
Co-requisites
Planned learning activities and teaching methods
Assesment methods and criteria linked to learning outcomes
Course curriculum
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 DOM. Using the DOM objects to automate changes in large documents.
8. DOM structure 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.
Work placements
Aims
Specification of controlled education, way of implementation and compensation for absences
Recommended optional programme components
Prerequisites and corequisites
Basic literature
Recommended literature
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)
Classification of course in study plans
Type of course unit
Lecture
Teacher / Lecturer
Syllabus
2. Variables, data types, constants, assignment statement.
3. Functions and procedures (calling of procedures and functions, parameters and arguments, public and private scopes).
4. Built-in language elements, inputs and outputs.
5.-6. Commands for flow control, conditional statements and loops.
7. Working with structured variables.
8. Structured and object-oriented programming.
9.-10. Application object libraries.
11. Fundamentals of using of numerical methods.
12. Examples of solving of engineering problems. Statistical and optimization problems.
13. Examples of solving of engineering problems. Solution of mechanical task.
Exercise
Teacher / Lecturer
Syllabus
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.