Spreadsheet Modeling and Decision Analysis in Operations ManagementModule description #70493 / Version 1
- 6 CP
- Oral exam
- Graded
- Summer semester
- English
| Module / Version | #70493 / #1 |
|---|---|
| Validity | Since Summer semester 2026 |
| Available language(s) | English, German |
| Credit points | 6 |
| Person responsible for the module | Volling, Thomas |
| Grading | Graded |
| Exam format | Oral exam |
| Language(s) of instruction | English |
Affiliation
| Faculty | Fakultät VII |
|---|---|
| Institute | Institut für Betriebswirtschaftslehre |
| Academic chair | 37321200 FG Industrielles Produktions- und Dienstleistungsmanagement (POM) |
Contact
| Office | H85 |
|---|---|
| Contact person | Gärtner, Nico |
| E-mail address | service@pom.tu-berlin.de |
| Website | https://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.
• 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:
| Courses | Type | Number | Frequency | Language | Hours per week | Course catalog |
|---|---|---|---|---|---|---|
| Spreadsheet Modeling and Decision Analysis in Operations Management | Integrated course | Summer semester | [en] | 4 | ISIS |
Workload and credit points
Spreadsheet Modeling and Decision Analysis in Operations Management (Integrated course)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Attendance | 15 | 4 h | 60 h |
| Pre/post processing | 15 | 4 h | 60 h |
| 120 h | |||
Course-independent workload
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Preparation of the case study | 1 | 40 h | 40 h |
| Exam preparation | 1 | 20 h | 20 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
| Grading | Graded |
|---|---|
| Exam format | Oral exam |
| Language | English |
| Duration/Extent | 20 - 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 version | Semester(s) | Curriculum component |
|---|---|---|
| Economics and Sustainability StuPO 2024 | SS 2026 | Wahlpflichtbereich „Economics, Sustainability and Technology“ › Sustainability & Technology › Sustainability & Technologie - Seminarmodule |
| WS 2026/27 | Wahlpflichtbereich „Economics, Sustainability and Technology“ › Sustainability & Technology › Sustainability & Technologie - Seminarmodule | |
| Industrial Economics StuPO 2018 | SS 2026 | Compulsory Elective Modules › Markets and Technology |
| WS 2026/27 | Compulsory Elective Modules › Markets and Technology | |
| Industrial Engineering and Management Industrial Engineering and Management (M. Sc.) - StuPO 2015 | WS 2026/27 | Integrationsbereich/Integration › Integrationsbereich/Integration (Wahlpflicht/Compulsory-Elective) › Operations Research & Quantitative Methods |
| Industrial Engineering and Management Industrial Engineering and Management (M. Sc.) - StuPO 2026 | WS 2026/27 | Integration Component › Operations Research & Quantitative Methods |
| Innovation Management, Entrepreneurship, and Sustainability Innovation Management, Entrepreneurship, and Sustainability (M. Sc.) - StuPO 2016 | SS 2026 | Compulsory elective modules › Entrepreneurship |
| WS 2026/27 | Compulsory elective modules › Entrepreneurship | |
| Innovation Management, Entrepreneurship, and Sustainability Innovation Management, Entrepreneurship, and Sustainability (M. Sc.) - StuPO 2025 | SS 2026 | Wahlpflichtbereich › Innovation and Entrepreneurship |
| WS 2026/27 | Wahlpflichtbereich › Innovation and Entrepreneurship |
Miscellaneous
Not specified