Course detail
Algorithms and Programming
FAST-CU51Acad. year: 2014/2015
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, simulation and animation techniques.
Language of instruction
Czech
Number of ECTS credits
5
Mode of study
Not applicable.
Guarantor
Department
Institute of Computer Aided Engineering and Computer Science (AIU)
Learning outcomes of the course unit
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.
Prerequisites
Fundamentals of algorithms and programming, basic knowledge of technical English
Co-requisites
Not applicable.
Planned learning activities and teaching methods
The course is taught through lectures, practical classes and self-study assignments. Attendance at lectures is optional, but attendance at classes is compulsory.
Assesment methods and criteria linked to learning outcomes
Active participation in seminars - 20%, testing of skills of program design and and debugging - 80%.
Course curriculum
1. Computer model from the perspective of a programmer. Language development environment.
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. Commands for flow control, conditional statements and loops.
6. Working with structured variables.
7. Structured and object-oriented programming, event-driven programming.
8. Application object libraries.
9. Fundamentals of simulation using numerical methods.
10. Animation techniques, program project.
11. Working with the file system, data conversion algorithms.
12. Examples of solving of engineering problems. Statistical and optimization problems, the initial task.
13. Examples of solving of engineering problems. Advanced solutions and animation of large deformations.
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. Commands for flow control, conditional statements and loops.
6. Working with structured variables.
7. Structured and object-oriented programming, event-driven programming.
8. Application object libraries.
9. Fundamentals of simulation using numerical methods.
10. Animation techniques, program project.
11. Working with the file system, data conversion algorithms.
12. Examples of solving of engineering problems. Statistical and optimization problems, the initial task.
13. Examples of solving of engineering problems. Advanced solutions and animation of large deformations.
Work placements
Not applicable.
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.
Specification of controlled education, way of implementation and compensation for absences
Extent and forms are specified by guarantor’s regulation updated for every academic year.
Recommended optional programme components
Not applicable.
Prerequisites and corequisites
Not applicable.
Basic literature
WIRTH, Nicolas: Algoritmy a štruktúry údajov. Alfa Bratislava, 1988. (CS)
Recommended reading
HALVORSON, Michael: Microsoft Visual Basic. Computer Press, 2010. EAN 9788025131466. (CS)
KNUTH, D. E.: Fundamental Algorithms. Third Edition.. Addison-Wesley, 1997. (EN)
KRÁL, Martin: Excel VBA. Computer Press, 2010. EAN 9788025123584. (CS)
KNUTH, D. E.: Fundamental Algorithms. Third Edition.. Addison-Wesley, 1997. (EN)
KRÁL, Martin: Excel VBA. Computer Press, 2010. EAN 9788025123584. (CS)
Classification of course in study plans
Type of course unit
Lecture
26 hod., optionally
Teacher / Lecturer
Syllabus
1. Computer model from the perspective of a programmer. Language development environment.
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. Commands for flow control, conditional statements and loops.
6. Working with structured variables.
7. Structured and object-oriented programming, event-driven programming.
8. Application object libraries.
9. Fundamentals of simulation using numerical methods.
10. Animation techniques, program project.
11. Working with the file system, data conversion algorithms.
12. Examples of solving of engineering problems. Statistical and optimization problems, the initial task.
13. Examples of solving of engineering problems. Advanced solutions and animation of large deformations.
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. Commands for flow control, conditional statements and loops.
6. Working with structured variables.
7. Structured and object-oriented programming, event-driven programming.
8. Application object libraries.
9. Fundamentals of simulation using numerical methods.
10. Animation techniques, program project.
11. Working with the file system, data conversion algorithms.
12. Examples of solving of engineering problems. Statistical and optimization problems, the initial task.
13. Examples of solving of engineering problems. Advanced solutions and animation of large deformations.
Exercise
26 hod., compulsory
Teacher / Lecturer
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.
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.