Skip to content
Technische Universität Berlin Deutsch
Course catalog and module transfer system

Spreadsheet Modeling and Decision Analysis in Operations ManagementModule description #70493 / Version 1

← Module page Deutsche Fassung
Module / Version#70493 / #1
ValiditySince Summer semester 2026
Available language(s)English, German
Credit points6
Person responsible for the moduleVolling, Thomas
GradingGraded
Exam formatOral exam
Language(s) of instructionEnglish

Affiliation

FacultyFakultät VII
InstituteInstitut für Betriebswirtschaftslehre
Academic chair37321200 FG Industrielles Produktions- und Dienstleistungsmanagement (POM)

Contact

OfficeH85
Contact personGärtner, Nico
E-mail addressservice@pom.tu-berlin.de
Websitehttps://www.tu.berlin/en/pom/study/courses/Spreadsheet_Modeling_and_Decision_Analysis_in_Operations_Management

Learning outcomes

After the successful completion of this module, students are capable of using spreadsheet programs for leveraging the power of data in operations management. They gain practical skills in three key analytics domains: descriptive analytics, predictive analytics, and prescriptive analytics. Beyond traditional methods, the module also delves into how emerging AI technologies can enhance each phase of the analytical process - from automated data preparation to intelligent insight generation. Using the industry-standard tool MS Excel and a comprehensive business case from energy-aware operations management, students learn to translate complex operational data into actionable strategies that create measurable competitive advantage. The module emphasizes both technical proficiency and critical thinking skills needed to implement effective analytics solutions across multiple organizational levels.

Content

The module is organized in four parts:

• From raw data to actionable insights (descriptive analytics): understanding what happened through data acquisition, data preprocessing & cleaning, exploratory data analysis, and advanced visualization based on interactive dashboards.
• Future-oriented analysis (predictive analytics): forecasting what might happen through the categorization of data, the exploration of relationships, and the testing of assumptions & quantification of uncertainty based on simulations and sensitivity analysis.
• Making good decisions (prescriptive analytics): managing trade-offs and identifying optimal courses of action for complex problems through mixed-integer linear programming and multi-criteria decision making.
• Enhancing analytics with AI: leveraging generative AI in the process of decision analysis including natural language interfaces, automated insight generation, and synthetic data creation.

Theoretical input sessions are combined with tutorials and implementation sessions based on a complex business case from operations management.

Module components

Compulsory area

The following courses are mandatory for this module:

CoursesTypeNumberFrequencyLanguageHours per weekCourse catalog
Spreadsheet Modeling and Decision Analysis in Operations ManagementIntegrated course Summer semester[en]4 ISIS

Workload and credit points

Spreadsheet Modeling and Decision Analysis in Operations Management (Integrated course)

Workload descriptionMultiplierHoursTotal
Attendance154 h60 h
Pre/post processing154 h60 h
120 h

Course-independent workload

Workload descriptionMultiplierHoursTotal
Preparation of the case study140 h40 h
Exam preparation120 h20 h
60 h

The workload of the module adds up to 180 hours. The module therefore comprises 6 credit points.

Description of teaching and learning methods

The module is structured as an integrated course, blending theoretical input sessions with practical exercises in MS Excel. In a comprehensive case study, students collaboratively address complex data analytics challenges from operations management, synthesizing various analytical methods. The results of the case work will be presented and discussed as part of an oral examination.

Requirements for participation and examination

Desirable prerequisites for participation in the courses:

Basic knowledge in production management, statistics, and operations research.

Mandatory requirements for the module examination registration:

This module has no examination requirements.

Completion of the module

GradingGraded
Exam formatOral exam
LanguageEnglish
Duration/Extent20 - 30 Min.

Duration of the module

The following number of semesters is estimated for taking and completing the module: 1 semester(s).

This module can be started in the following semesters: Summer semester.

Maximum number of participants

The maximum capacity of participants is 40.

Registration procedures

ISIS is used for module registration, with detailed instructions provided at the beginning of each semester.

Recommended reading, lecture notes

Lecture notes

unavailable

Electronic lecture notes

unavailable

Recommended literature

No recommended literature given

Assigned programs

This module version is used in the following programs:

Program / program versionSemester(s)Curriculum component
Economics and Sustainability
StuPO 2024
SS 2026Wahlpflichtbereich „Economics, Sustainability and Technology“ › Sustainability & Technology › Sustainability & Technologie - Seminarmodule
WS 2026/27Wahlpflichtbereich „Economics, Sustainability and Technology“ › Sustainability & Technology › Sustainability & Technologie - Seminarmodule
Industrial Economics
StuPO 2018
SS 2026Compulsory Elective Modules › Markets and Technology
WS 2026/27Compulsory Elective Modules › Markets and Technology
Industrial Engineering and Management
Industrial Engineering and Management (M. Sc.) - StuPO 2015
WS 2026/27Integrationsbereich/Integration › Integrationsbereich/Integration (Wahlpflicht/Compulsory-Elective) › Operations Research & Quantitative Methods
Industrial Engineering and Management
Industrial Engineering and Management (M. Sc.) - StuPO 2026
WS 2026/27Integration Component › Operations Research & Quantitative Methods
Innovation Management, Entrepreneurship, and Sustainability
Innovation Management, Entrepreneurship, and Sustainability (M. Sc.) - StuPO 2016
SS 2026Compulsory elective modules › Entrepreneurship
WS 2026/27Compulsory elective modules › Entrepreneurship
Innovation Management, Entrepreneurship, and Sustainability
Innovation Management, Entrepreneurship, and Sustainability (M. Sc.) - StuPO 2025
SS 2026Wahlpflichtbereich › Innovation and Entrepreneurship
WS 2026/27Wahlpflichtbereich › Innovation and Entrepreneurship

Miscellaneous

Not specified