|
|
Module code: BAIBA-330 |
|
6V (6 hours per week) |
6 |
Semester: 3 |
Mandatory course: yes |
Language of instruction:
German |
Assessment:
Written exam at PC
[updated 10.12.2020]
|
BAIBA-330 (P420-0499) International Business, Bachelor, ASPO 01.10.2008
, semester 3, mandatory course
|
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]
|