End-User Development with Office Applications

Faculty

Faculty of Business Management and Social Sciences

Version

Version 1 of 30.05.2024.

Module identifier

22M0876

Module level

Master

Language of instruction

German

ECTS credit points and grading

5.0

Module frequency

only winterterm

Duration

1 semester

 

 

Brief description

Office applications such as spreadsheet programs and content management systems are now so widespread in specialist departments that many companies would grind to a halt without them. To ensure that office applications can continue to support business processes in the company effectively and efficiently even in the face of frequent changes in requirements, they must increasingly be suitably supplemented, adapted and also further developed by their specialist users. This trend is further reinforced by the increasing digitalization of society and companies. In this module, students are taught the necessary skills and abilities to independently supplement, adapt and further develop Office applications (e.g. MS Excel) to support and automate business management tasks.

Teaching and learning outcomes

1. Conceptual basics of end user development

2. Presentation of selected office products for the support of business information processing

3. Introduction to the development of office applications

4. Management and governance of office applications

Overall workload

The total workload for the module is 150 hours (see also "ECTS credit points and grading").

Teaching and learning methods
Lecturer based learning
Hours of workloadType of teachingMedia implementationConcretization
45LecturePresence-
Lecturer independent learning
Hours of workloadType of teachingMedia implementationConcretization
80Preparation/follow-up for course work-
25Exam preparation-
Graded examination
  • Homework / Assignment or
  • Written examination or
  • Portfolio exam
Recommended prior knowledge

Knowledge of the operation and control of a PC as well as knowledge of the handling of office software (e.g. according to ECDL).

Knowledge Broadening

Students possess knowledge of the state of the art in business information processing based on established office solutions.

Knowledge deepening

Students will be able to identify the application areas of end-user development to support operational organizational design.

Knowledge Understanding

Students will be able to integrate Office applications into existing business processes, organizational structures, and application landscapes.

Application and Transfer

Students are able to support and automate basic business tasks by designing office applications. They master the use of an end-user oriented programming language and a modern development environment.

Academic Innovation

Students are able to handle software development problems within the framework of a design-oriented research approach (Design Science Research, DSR) and to systematically develop implementation-relevant sources of information.

Communication and Cooperation

Students have the ability to actively accompany development processes for end user development and to critically evaluate and communicate the benefits of office applications.

Academic Self-Conception / Professionalism

Students will be able to evaluate the economic consequences of using office applications.

Literature

Alpar P, Alt R, Bensberg F, Weimann P (2019) Anwendungs­orientierte Wirtschaftsinformatik – Strategische Planung, Entwicklung und Nutzung von Informationssystemen, 9. Aufl., Wiesbaden.

Kämper S (2009) Grundkurs Programmieren mit Visual Basic - Die Grundlagen der Programmierung, 3. Aufl., Wiesbaden.

Kozlova E (2013) Governance der individuellen Datenverarbeitung - Wertorientierte und risikobewusste Steuerung der IDV-Anwendungen in Kreditinstituten, Wiesbaden.

Lieberman H, Paternò F, Wulf V (Hrsg.)(2006) End User Development, Dordrecht.

Matthäus W-G (2005) Programmierung für Wirtschaftsinformatiker – Vorlesungen über Visual Basic und VBA, Wiesbaden.

Microsoft Corporation (Hrsg.)(2021): VBA Language Specification, Release: February 16, 2021, im Internet: https://interoperability.blob.core.windows.net/files/MS-VBAL/%5bMS-VBAL%5d.pdf

Nahrstedt H (2016) Die Welt der VBA-Objekte - Was integrierte Anwendungen leisten können, Wiesbaden.

Linkage to other modules

The competencies are relevant for the execution of practice-oriented master theses in which the design of office applications for handling business problems is addressed.

Applicability in study programs

  • Management for Health Services, M.A.
    • Management for Health Services, M.A.

  • International Business and Management (Master)
    • International Business and Management, M.A. (01.09.2024)

  • Business Management
    • Business Management, M.A.

    Person responsible for the module
    • Bensberg, Frank
    Teachers
    • Bensberg, Frank