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

flag

Business Informatics I

Module name (EN):
Name of module in study programme. It should be precise and clear.
Business Informatics I
Degree programme:
Study Programme with validity of corresponding study regulations containing this module.
International Business, Bachelor, ASPO 01.10.2008
Module code: BAIBA-330
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.
P420-0499
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.
6V (6 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.
6
Semester: 3
Mandatory course: yes
Language of instruction:
German
Assessment:
Written exam at PC

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

BAIBA-330 (P420-0499) International Business, Bachelor, ASPO 01.10.2008 , semester 3, 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).
90 class hours (= 67.5 clock hours) over a 15-week period.
The total student study time is 180 hours (equivalent to 6 ECTS credits).
There are therefore 112.5 hours available for class preparation and follow-up work and exam preparation.
Recommended prerequisites (modules):
None.
Recommended knowledge:
None. BAIBA-330 is a basic IT course.

[updated 20.03.2010]
Recommended as prerequisite for:
BAIBA-430 Business Informatics II


[updated 20.05.2010]
Module coordinator:
Prof. Dr. Stefan Selle
Lecturer:
Prof. Dr. Thomas Bousonville
Prof. Dr. Stefan Selle
Lehrbeauftragte
Prof. Dr. Enrico Lieblang


[updated 20.05.2010]
Learning outcomes:
After successfully completing this course, students will:
- be able to use the most important techniques in spreadsheet calculation,
- be familiar with programming macros,
- be able to create and use databases,
- be able to query databases using SQL,
- be able to normalize databases,
- be able to create entity relationship models and relational database models.

[updated 10.12.2020]
Module content:
1. •Spreadsheets and automation
(a) Spreadsheets: The basics, formulas, functions, date and time, diagrams, processing techniques, consolidation, pivot analysis.
(b) Automation: Macros: Recorder, editor, dialogs
  
2. Data management
(a) Theory: Three-level framework, tables and relations, relational algebra, binary search, keys, integrity, database management system, database models, security and administration, SQL, normalization, entity relationship model, relational model
(b) Practice: Tables, searching, sorting, filtering, queries, forms, reports, SQL queries, database design (ER diagram, relational model, normalization).

[updated 10.12.2020]
Teaching methods/Media:
Lecture integrated with independent work on the PC, i. e. the direct solution of concrete, business management tasks using the Office products Excel resp. Access.
 


[updated 10.12.2020]
Recommended or required reading:
- Münster, C., Wies, P.: Microsoft Office Excel 2007 für Windows – Grundlagen, 3. Auflage, Herdt-Verlag, Bodenheim, 2008.
- Münster, C.: Microsoft Office Excel 2007 für Windows – Fortgeschrittene Techniken, 2. Auflage, Herdt-Verlag, Bodenheim, 2007.
 
- Bossert, T., Schwarz, A.: Microsoft Office Access 2007 für Windows – Grundlagen für Datenbank-Entwickler, 1. Auflage, Herdt-Verlag, Bodenheim, 2007.
- Meier, A.: Relationale und postrelationale Datenbanken, 6. Auflage, Springer Verlag, Berlin, 2007.
- Schicker, E.: Datenbanken und SQL, 3. Auflage, Teubner Verlag, Wiesbaden, 2000.
- Schubert, M.: Datenbanken – Theorie, Entwurf und Programmierung relationaler Datenbanken, 2. Auflage, Teubner+Vieweg, Wiesbaden, 2007.
- Steiner, R.: Grundkurs Relationale Datenbanken, 7. Auflage, Teubner+Vieweg, Wiesbaden, 2009.

[updated 10.12.2020]
 
[Fri Apr 19 12:41:16 CEST 2024, CKEY=iwa, BKEY=ibw, CID=BAIBA-330, LANGUAGE=en, DATE=19.04.2024]