htw saar Piktogramm
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 understand and apply basic digital skills that engineers often come into contact with in their day-to-day work. They will be familiar with the advantages and disadvantages of simple and complex data storage mechanisms in the form of various data formats and relational database management systems. Based on practical exercises, students will be able to convert data sets into the respective data formats. In addition, they will be able to transform data sets using normalization rules in order to store them in a database management system in a suitable format and thus, manage them.
 
Furthermore, they will be familiar with basic concepts of automation in common office applications. This knowledge will enable them to delve deeper into the automation of spreadsheets and text documents and to independently develop solutions for specific requirements.
 
Students will be familiar with concepts for effective source code management and versioning on the basis of the source code that was implemented. They will be familiar with the various advantages and disadvantages of local, centralized and decentralized versioning systems. Finally, students will be able to use the basic functions of a decentralized state-of-the-art versioning tool to version their source code.  
 
In addition, students will be able to recognize and avert current security threats in practice by studying two current IT security-related topics in the course of the module.

[updated 09.11.2022]
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 Macro programming
 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 09.11.2022]
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]
[Tue Mar 21 02:15:16 CET 2023, CKEY=bdsfi, BKEY=m2, CID=MAB_19_4.2.1.35, LANGUAGE=en, DATE=21.03.2023]