htw saar Piktogramm QR-encoded URL
Back to Main Page Choose Module Version:
emphasize objectives XML-Code


Programming Techniques

Module name (EN):
Name of module in study programme. It should be precise and clear.
Programming Techniques
Degree programme:
Study Programme with validity of corresponding study regulations containing this module.
Automotive Engineering, Bachelor, ASPO 01.10.2011
Module code: FT33
The exam administration creates a SAP-Submodule-No for every exam type in every module. The SAP-Submodule-No is equal for the same module in different study programs.
P242-0084, P242-0085
Hours per semester week / Teaching method:
The count of hours per week is a combination of lecture (V for German Vorlesung), exercise (U for Übung), practice (P) oder project (PA). For example a course of the form 2V+2U has 2 hours of lecture and 2 hours of exercise per week.
3V+1U (4 hours per week)
ECTS credits:
European Credit Transfer System. Points for successful completion of a course. Each ECTS point represents a workload of 30 hours.
Semester: 3
Mandatory course: yes
Language of instruction:
Written exam 120 min.

[updated 30.09.2020]
Applicability / Curricular relevance:
All study programs (with year of the version of study regulations) containing the course.

FT33 (P242-0084, P242-0085) Automotive Engineering, Bachelor, ASPO 01.10.2011 , semester 3, mandatory course
FT33 (P242-0084, P242-0085) Automotive Engineering, Bachelor, ASPO 01.10.2015 , semester 3, mandatory course
FT33 (P242-0084, P242-0085) Automotive Engineering, Bachelor, ASPO 01.04.2016 , semester 3, mandatory course
FT33 (P242-0084, P242-0085) Automotive Engineering, Bachelor, ASPO 01.10.2019 , semester 3, mandatory course
Workload of student for successfully completing the course. Each ECTS credit represents 30 working hours. These are the combined effort of face-to-face time, post-processing the subject of the lecture, exercises and preparation for the exam.

The total workload is distributed on the semester (01.04.-30.09. during the summer term, 01.10.-31.03. during the winter term).
60 class hours (= 45 clock hours) over a 15-week period.
The total student study time is 150 hours (equivalent to 5 ECTS credits).
There are therefore 105 hours available for class preparation and follow-up work and exam preparation.
Recommended prerequisites (modules):
Recommended as prerequisite for:
FT27 Vehicle Testing
FT28 Vehicle Simulation

[updated 18.12.2013]
Module coordinator:
Prof. Dr. Hans-Werner Groh
M.Eng. Markus Schmitt
Prof. Dr.-Ing. Helge Frick

[updated 16.12.2013]
Learning outcomes:
After successfully completing this course, students will be able to:
- apply their knowledge about program flow and structuring to concrete tasks in a problem-oriented manner.
- implement their knowledge on the basis of Visual Basic for Applications (VBA) in connection with Excel (alternatively: the programming language C) practically and on the computer.
- convert textual tasks into small calculation programs and display the results graphically.
- make input and output user-friendly by means of appropriate graphic interfaces.

[updated 30.09.2020]
Module content:
- Introduction: Principles of programming, VBA in connection with Excel, creating and editing macros (IDE development environment)
- Basic program elements: Working with variables, working with constants, assignments, mathematical and derived mathematical functions
- Simple input and output dialogs
- Control structures: Loops, branches, nesting, structure diagrams and structure charts
- Fields (arrays): One-dimensional fields, multidimensional fields, dynamic fields
- Procedures and functions: Sub-procedures, function procedures, argument and parameter lists
- Introduction to object-oriented programming: Classes, properties, methods
User-defined dialogs: Forms and control elements, designing dialogs (UserForm), application examples from the field of mechanical engineering
- Access to the Access database

[updated 30.09.2020]
Teaching methods/Media:
Lecture notes, exercises

[updated 30.09.2020]
Recommended or required reading:
Microsoft Office Excel 2007 für Windows-Automatisierung, Programmierung; Kofler M.: Excel-VBA programmieren

[updated 30.09.2020]
[Fri Jun 21 10:26:54 CEST 2024, CKEY=mtdp, BKEY=fz, CID=FT33, LANGUAGE=en, DATE=21.06.2024]