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

flag

IT in the Civil Engineering Sector

Module name (EN):
Name of module in study programme. It should be precise and clear.
IT in the Civil Engineering Sector
Degree programme:
Study Programme with validity of corresponding study regulations containing this module.
Civil and structural engineering, Bachelor, ASPO 01.10.2011
Module code: BIBA110
SAP-Submodule-No.:
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.
P110-0012, P110-0013
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.
3VU (3 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.
4
Semester: 1
Mandatory course: yes
Language of instruction:
German
Assessment:
Written exam (40%,), term paper (60%)

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

BIBA110 (P110-0012, P110-0013) Civil and structural engineering, Bachelor, ASPO 01.04.2009 , semester 1, mandatory course
BIBA110 (P110-0012, P110-0013) Civil and structural engineering, Bachelor, ASPO 01.10.2011 , semester 1, mandatory course
BIBA110 (P110-0012, P110-0013) Civil and structural engineering, Bachelor, ASPO 01.10.2017 , semester 1, mandatory course
Workload:
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).
45 class hours (= 33.75 clock hours) over a 15-week period.
The total student study time is 120 hours (equivalent to 4 ECTS credits).
There are therefore 86.25 hours available for class preparation and follow-up work and exam preparation.
Recommended prerequisites (modules):
None.
Recommended as prerequisite for:
Module coordinator:
Prof. Dr.-Ing. Peter Böttcher
Lecturer:
Prof. Dr.-Ing. Peter Böttcher (lecture/exercise)


[updated 20.11.2013]
Learning outcomes:
After successfully completing this module, students will be familiar with the basic concepts of programming using the language Visual Basic for Application (VBA) in combination with Excel. They will be able to solve tasks in civil engineering with the help of simple program structures, analyze and structure problems and transfer them to an EDP program.


[updated 05.02.2020]
Module content:
Stucture of programming languages:
Commands, variables, methods, operators, simple objects
 
GUIs:
Windows, GUI objects, data management
 
Tools:
VBA tools, debugging, design methods, documentation
 
Object-oriented methods:
Classes, objects, properties, methods


[updated 05.02.2020]
Recommended or required reading:
Held, Bernd: VBA mit Excel; Markt+Technik Verlag 2007
Baloui, Said: Jetzt lerne ich VBA mit Excel, Markt+Technik Verlag 2007

[updated 05.02.2020]
[Sat Jul 20 20:53:11 CEST 2024, CKEY=bbf, BKEY=bi2, CID=BIBA110, LANGUAGE=en, DATE=20.07.2024]