End-User Development with Office Applications
- Faculty
Faculty of Business Management and Social Sciences
- Version
Version 2 of 12.12.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 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 programmed, supplemented, adapted and also further developed by their specialist users. This trend is further reinforced by the increasing digitalization. In this module, students are taught the necessary skills and abilities to independently supplement, adapt and further develop Office applications (e.g. MS Excel). The focus is on the programming language Visual Basic for Applications (VBA), which is particularly suitable for end-user orientated programming and has great potential for automating work processes.
- 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 with MS Excel and Visual Basic for Applications (VBA)
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 workload Type of teaching Media implementation Concretization 45 Lecture Presence - Lecturer independent learning Hours of workload Type of teaching Media implementation Concretization 80 Preparation/follow-up for course work - 25 Exam 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, Czarnecki C (2023) Anwendungsorientierte Wirtschaftsinformatik – Strategische Planung, Entwicklung und Nutzung von Informationssystemen, 10. Aufl., Springer Vieweg,
Wiesbaden, https://link.springer.com/book/10.1007/978-3-658-40352-2K?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.
Microsoft Corporation (Hrsg.)(2024): [VBAL] VBA Language Specification Release: November 12 2024, im Internet: https://msopenspecs.azureedge.net/files/MS-VBAL/%5bMS-VBAL%5d.pdf
Nahrstedt H (2022) Die Welt der VBA-Objekte - Was integrierte Anwendungen leisten, 2. Aufl., Wiesbaden.
Theis T (2020) Einstieg in VBA mit Excel, 5. Aufl., Bonn.
Weber I (2024) VBA für Office-Automatisierung und Digitalisierung, 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