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


Office Management

Module name (EN):
Name of module in study programme. It should be precise and clear.
Office Management
Degree programme:
Study Programme with validity of corresponding study regulations containing this module.
International Business, Bachelor, ASPO 01.10.2017
Module code: BIBW-252
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.
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.
2VU (2 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.
Semester: 2
Mandatory course: yes
Language of instruction:

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

BIBW-252 (P420-0207) International Business, Bachelor, ASPO 01.10.2017 , semester 2, mandatory course
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).
30 class hours (= 22.5 clock hours) over a 15-week period.
The total student study time is 75 hours (equivalent to 2.5 ECTS credits).
There are therefore 52.5 hours available for class preparation and follow-up work and exam preparation.
Recommended prerequisites (modules):
Recommended as prerequisite for:
Module coordinator:
Prof. Dr. Christian Liebig
Prof. Dr. Christian Liebig

[updated 21.02.2018]
Learning outcomes:
After successfully completing this module, students will be able to:
- use the most important techniques in spreadsheet calculation,
- program simple macros in Excel,
- differentiate between when to use spreadsheet calculations and when
  to use other applications (e.g. databases),
- use a word processor efficiently
- use a presentation program to create a presentation.

[updated 14.03.2018]
Module content:
I. Spreadsheets
- Introduction and overview
- Formulas, functions, date and time
- Diagrams, processing techniques
- Consolidation and pivot analysis
- Automating with macros: recorder, editor, dialogs
II. Word processing
- Business letters
- Structuring and formatting large documents
- Tables and graphics
- Quotes and footnotes
- Indices
III. Presentation Program
- Creating and giving a presentation
- Formatting and layout
- Graphics and other objects
- Creating and reusing templates

[updated 14.03.2018]
Teaching methods/Media:
Lecture integrated with independent work on the PC, i. e. the direct solution of concrete, business management tasks using MS Excel, Word and PowerPoint.

[updated 14.03.2018]
Recommended or required reading:
Bossert, T.: PowerPoint für Windows _ Grundlagen, Herdt-Verlag, Bodenheim, latest edition.
Von Braunschweig, C., Spieߟ, S., Stulle, K.: Word für Windows _ Grundlagen, Herdt-Verlag, Bodenheim, latest edition.
Wies, P.: Excel für Windows _ Grundlagen, Herdt-Verlag, Bodenheim, latest edition.
Wies, P.: Excel für Windows _ Fortgeschrittene Techniken, Herdt-Verlag, latest edition.

[updated 14.03.2018]
[Tue Jun 18 21:25:08 CEST 2024, CKEY=iom, BKEY=ibw3, CID=BIBW-252, LANGUAGE=en, DATE=18.06.2024]