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

flag

Digital Skills for Engineers

Module name (EN):
Name of module in study programme. It should be precise and clear.
Digital Skills for Engineers
Degree programme:
Study Programme with validity of corresponding study regulations containing this module.
Mechanical and Process Engineering, Bachelor, ASPO 01.10.2019
Module code: MAB_19_4.2.1.35
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.
P213-0187
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.
2V+2P (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.
5
Semester: 5
Mandatory course: no
Language of instruction:
German
Assessment:
Oral examination

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

BMT2552.DSI (P213-0187) Biomedical Engineering, Bachelor, ASPO 01.10.2018 , semester 5, optional course
EE1536 (P213-0187) Energy system technology / Renewable energies, Bachelor, ASPO 01.10.2022 , semester 5, optional course
E2586 (P213-0187) Electrical Engineering and Information Technology, Bachelor, ASPO 01.10.2018 , semester 5, optional course
MAB_19_4.2.1.35 (P213-0187) Mechanical and Process Engineering, Bachelor, ASPO 01.10.2019 , semester 5, optional 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).
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):
None.
Recommended as prerequisite for:
Module coordinator:
Andreas Schaffhauser, M.Sc.
Lecturer: Andreas Schaffhauser, M.Sc.

[updated 12.10.2022]
Learning outcomes:
After successfully completing this module, students will be able to apply the basic digital skills they need as an engineer in their job. They will have developed their problem-solving skills by analyzing and developing solutions for subject-related problems in exercises. They will have developed their communication skills by presenting and discussing their individual solutions in plenary.
 
They will be able to consider the concepts, as well as the advantages and disadvantages of simple and complex data management mechanisms when applied to unfamiliar case studies.
 
Students will be able to transfer data sets into the respective data formats after having practiced this within the framework of practical exercises. They will be able to transform datasets into the appropriate forms using normalization rules. They will be able to store and manage transformed datasets in a database management system.
 
They will be able to apply the concepts of automation in common office applications to independently learn how to automate spreadsheets and text documents and solve simple problems on their own.
 
They will be able to identify the different advantages and disadvantages of local, centralized and decentralized versioning systems. They will be able to apply concepts for effective source code management and versioning. They will be able to practice the process of versioning with source code that they have implemented themselves.
 
Students will be able to identify theoretical points of attack of an IT system. They will be able to describe possible measures to protect IT systems from these points of attack by practicing this on two topics.

[updated 04.09.2023]
Module content:
1 Introduction to “Digital Skills für Ingenieure”
 1.1 Presentation of “Future & Digital Skills” competencies (technical, non-technical,...)
 1.2 Raising awareness for non-technical competencies
 
2 Data formats
 2.1 CSV
 2.2 JSON
 2.3 XML
 
3 (Relational) databases
 3.1 CSV/Excel vs. databases
 3.2 Structure of a DBMS (database system)
  3.2.1 Data dictionary
  3.2.2 Databases/Tables
  3.2.3 DBMS (Database Management System)
  3.2.4 Referential integrity
  3.2.5 ACID
 3.3 Database languages/SQL
  3.3.1 Select statement
  3.3.2 Joins
 3.4 Development of a database schema
  3.4.1 Specialist concept
  3.4.2 Data processing concept
  3.4.3 Implementation level
 3.5 Specialist concept
 3.6 Data processing concept
  3.6.1 Model development
  3.6.2 Chen Notation/ER model
  3.6.3 Operations, relational algebra (projection, selection, ...)
  3.6.4 Term relations
  3.6.5 Normalization
 
4 Programming macros
 4.1 Introduction to IDE
 4.2 Variable types and declarations
 4.3 Hungarian notation
 4.4 Notation used in the lecture (UpperCamelCase)
 4.5 Subroutines
 4.6 Functions
 4.7 Parameter transfer (Call by Reference/Call by Value)
 4.8 Operators
 4.9 Sequence control
 4.10 Error handling with GoTo
 4.11 Access to text documents
 4.12 Access to tables
 
5 Version control
 5.1 History versioning
 5.2 Local/centralized/distributed version control
 5.3 Git
  5.3.1 The three states of Git
  5.3.2 Initializing a repository
  5.3.3 .gitignore (Using templates for ignoring files)
  5.3.4 README.md (Header, applications etc.)
  5.3.5 Basic commands
  5.3.6 Branches
 
6 Current IT security topics
 6.1 Information security
 6.2 CIA triad
 6.3 Safety
 6.4 Threats
  6.4.1 Malware
  6.4.2 Ransomware
  6.4.3 Social engineering
  6.4.4 Advance persistent threat
  6.4.5 Denial of service
 


[updated 04.09.2023]
Teaching methods/Media:
- Interfaces for programming applications for the respective tools
- Openly accessible teaching materials for the respective subject areas
 
All teaching materials and exercises are available from the instructor.

[updated 09.11.2022]
Recommended or required reading:
- Future Skills 2021 - 21 Kompetenzen für eine Welt im Wandel (https://www.stifterverband.org/download/file/fid/10547)
- Common Format and MIME Type for Comma-Separated Values (CSV) Files (https://datatracker.ietf.org/doc/html/rfc4180)
- The JavaScript Object Notation (JSON) Data Interchange Format (https://datatracker.ietf.org/doc/html/rfc8259)
- Extensible Markup Language (XML) 1.0 (Fifth Edition) (https://www.w3.org/TR/REC-xml/)
- Database system basics: Bachelor
- XAMPP (https://www.apachefriends.org/de/index.html)
- BASIC-Makros für OpenOffice und LibreOffice (https://www.uni-due.de/~abi070/files/OOo/OOME/OOME_3_0_deutsch.pdf)
- Pro Git (https://github.com/progit/progit2-de/releases/download/2.1.215/progit.pdf)


[updated 09.11.2022]
 
[Thu Nov 21 12:16:28 CET 2024, CKEY=bdsfi, BKEY=m2, CID=MAB_19_4.2.1.35, LANGUAGE=en, DATE=21.11.2024]