Introduction to common IT Office Applications

Type and Deduction

• B.A. BSc.: obligatory module within the 1st or 2nd semester
• HDL BSc.: obligatory module for B.A. as main focus for study commencements from 2014 on
  

Scope of Deduction

6 CP
4 SWS (lectures incl. tutorials)

Course Language

German

Lecturers

Dr. Birgit Schwartz-Reinken*, Dr. Frank Schwartz

*For questions please contact Dr. Schwartz-Reinken

Course Dates 

• Z 1-1: Mo, 2:00-6:00 pm, WiWi 1004: Dr. Birgit Schwartz-Reinken
• Z 1-2: Thur, 8:00 - 12:00 am, WiWi 1004: Dr. Frank Schwartz
• Z 2-1: Thur, 12:00 am - 4:00 pm, WiWi 1005: Dr. Frank Schwartz
• Z 2-1: Thur, 12:00 am - 4:00 pm, WiWi 1004: Dr. Birgit Schwartz-Reinken

Courses during the semester break:

• 1: Wed, Feb 19 - Wed, Mar, 5, 10 am - 2 pm, WiWi 1005: Dr. Birgit Schwartz-Reinken
• 2: Wed, Feb 19 - Wed, Mar, 5, 2 - 6 pm, WiWi 1005: Dr. Birgit Schwartz-Reinken

More details available in OpenOLAT.

Registration

In order to participate in this course it is obligatory to register in STiNE during the STiNE registration periods.

Course Evaluation
   

Evaluation Type: exam
As soon as they are known the exact examination dates will be announced in STiNE.

Requirements for attending the Exams

• The exercises have to be correct and handed in to a total of at least 50%. (Repeaters: The ones who have fulfilled this requirement in a previous semester do not need to hand in excercises again.)
• Registration for the exam (for repeaters) within the registration periods in STiNE

Registration for the exams (including repeaters):

• BSc. students: within the registration periods in STiNE

Word processing (using Microsoft Word as an example):

Formatting and structuring documents with style sheets
Automatisms (e.g. footnote management, captions, directory creation, cross-references)
Additional functions such as formula creation, table creation, etc.

Spreadsheet calculation (using Microsoft Excel as an example)

Functions, esp. for decision problems, mathematical/financial problems, statistics
Diagrams/visualization of information
Data management, data selection, data analysis

Database management (using Microsoft Access or LibreOffice Base as an example)

Data organization in relational databases
Creating a database (including field data types, validity rules, keys, etc.)
Database queries
Form and report creation

Programming (using Python as an example)

Basics of programming language syntax, esp. variables, operators, loops and branching
Use of control structures to develop methods in this programming language
Calling methods to solve (business) problems

All documents belonging to the module are provided via the E-learning-platform OpenOLAT.