<?xml version="1.0" encoding="ISO-8859-1" standalone="yes" ?>
<document>
<title>Programming Techniques</title>
<cid>FT33</cid>
<sapsubmodule>P242-0084, P242-0085</sapsubmodule>
<bkey>fz2</bkey>
<ctypes>
<hours>3</hours>
<type>V</type>
<hours>1</hours>
<type>U</type>
</ctypes>
<cp>5</cp>
<semester>3</semester>
<mandatory>yes</mandatory>
<language>German</language>
<exam>Written exam 120 min.</exam>
<curriculum>
<curriculum_entry>
<cid>FT33</cid>
<branch>Automotive Engineering</branch>
<semester>3</semester>
<mandatory_tag>mandatory course</mandatory_tag>
</curriculum_entry>
<curriculum_entry>
<cid>FT33</cid>
<branch>Automotive Engineering</branch>
<semester>3</semester>
<mandatory_tag>mandatory course</mandatory_tag>
</curriculum_entry>
<curriculum_entry>
<cid>FT33</cid>
<branch>Automotive Engineering</branch>
<semester>3</semester>
<mandatory_tag>mandatory course</mandatory_tag>
</curriculum_entry>
<curriculum_entry>
<cid>FT33</cid>
<branch>Automotive Engineering</branch>
<semester>3</semester>
<mandatory_tag>mandatory course</mandatory_tag>
</curriculum_entry>
</curriculum>
<workload>
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.</workload>
<prerequisites>
</prerequisites>
<prerequisitesfor>
<prerequisitefor>
<pfcid>FT28</pfcid>
<pftitle>Vehicle Simulation</pftitle>
</prerequisitefor>
</prerequisitesfor>
<convenor>Prof. Dr. Hans-Werner Groh</convenor>
<convenor-person-key>hwg</convenor-person-key>
<lecturers>
<lecturer>Prof. Dr. Hans-Werner Groh</lecturer>
<lecturer-person-key>hwg</lecturer-person-key>
</lecturers>
<objectives>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.
</objectives>
<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
</content>
<media>Lecture notes, exercises</media>
<literature>Microsoft Office Excel 2007 für Windows-Automatisierung, Programmierung; Kofler M.: Excel-VBA programmieren
</literature>
<offered>
</offered>
<moduldb-query>Sun Mar  8 11:03:35 CET 2026, CKEY=mtdp, BKEY=fz2, CID=[?], LANGUAGE=en, DATE=08.03.2026</moduldb-query>
</document>
