Programming and Databases

Using advanced features of MS-Excel: Pivot-Tables, Scenario-Analysis, Conditional formatting, Advanced diagrams; General Programming structures: Declaration - Input - Processing - Output, Branches, Loops, Data types; Visual Basic for Application in MS-Excel: Objects, Sheets, Cells; Basics of Databases, Queries and Basics of SQL: Relational databases: Primary/foreign key; Queries: Criteria, Operators, Aggregate Functions; Introduction to MS-Access; Basic Skills in statistical software (e.g. R, SPSS, SAS or Minitab)

Art der Vermittlung

Präsenzveranstaltung

Art der Veranstaltung

Pflichtfach

Empfohlene Fachliteratur

Jackson, M., Staunton, M., 2001, Advanced Modelling in Finance using Excel and VBA, John Wiley & Sons; Ulrich, L., Cook, K., 2018, Access 2018 for Dummies, Wiley Publishing; Alexander, M., 2018, Excel VBA Programming for Dummies, 5th edition, Wiley Publishing

Lern- und Lehrmethode

Interactive work in computer labs, discussion of exercises and examples.

Prüfungsmethode

This course is based on continuous assessment (30%) and a final project to be uploaded on the Moodle platform (70%). The continuous assessment consists of active participation in class (15%) and three home assignments to be uploaded on the Moodle platform before the respective deadlines (15%).

Voraussetzungen laut Lehrplan

Meet the admission requirements for this master’s programme

Schnellinfos

Studiengang

Quantitative Asset and Risk Management (Master)

Akademischer Grad

Master

ECTS Credits

4.00

Unterrichtssprache

Englisch

Studienplan

Berufsbegleitend

Studienjahr, in dem die Lerneinheit angeboten wird

2023

Semester in dem die Lehrveranstaltung angeboten wird

1 WS

Incoming

Lernergebnisse der Lehrveranstaltung

After the successful completion of the course students are able to apply advanced features of Microsoft-Excel to analyse data efficiently. In addition, they demonstrate basic programming knowledge (definition of variables, assignment of values to variables, if-statements, for- and while-loops, logical operators, functions, variable scope, arrays, objects, collections, error handling and documentation techniques) in Visual Basic for Applications (VBA) which enables them to develop their own computer functions and programs. Furthermore, they are able to use Structure Query Language (SQL) elements for storing, manipulating and retrieving data in databases. Additionally, the students are able to operate statistical software other than MS-Excel (e.g. R, SPSS, SAS or Minitab) which is advantageous when dealing with large data-sets or complex algorithms.

Kennzahl der Lehrveranstaltung

0613-09-07-BB-EN-04