|
|
Root number
|
491739 |
|
Semester
|
HS2025 |
|
Type of course
|
Lecture |
|
Allocation to subject
|
Business Administration |
|
Type of exam
|
Oral exam |
| Title |
Business Analytics using Excel |
| Description |
This course covers the design, development, and implementation of Excel-based decision support systems using various techniques from business analytics. The first part of the course consists of lectures and exercises, including an introduction to programming in Visual Basic for Applications, and a project; the latter consists of the development and implementation of a decision support system for a given planning situation.
Prerequisites are the knowledge of linear optimization and mixed-integer linear optimization discussed in the undergraduate course "Quantitative Methods in Business Administration". In particular, students should be able to implement a given optimization model in Microsoft Excel, use the solver add-in to find an optimal solution, and interpret the results.
Registration via e-mail to bae.pqm@unibe.ch; please include an up-to-date sheet of grades. |
|
ILIAS-Link (Learning resource for course)
|
Registrations are transmitted from CTS to ILIAS (no admission in ILIAS possible).
ILIAS
|
|
Link to another web site
|
|
| Lecturers |
Prof. Dr.
Norbert Trautmann, Chair of Quantitative Methods in Business Administration ✉
|
|
ECTS
|
4.5 |
|
Recognition as optional course possible
|
No |
|
Grading
|
1 to 6 |
| |
| Dates |
Tuesday 16/9/2025 13:15-14:00
|
|
Monday 22/9/2025 14:15-17:00
|
|
Tuesday 30/9/2025 13:15-15:00
|
|
Monday 6/10/2025 14:15-17:00
|
|
Tuesday 14/10/2025 13:15-15:00
|
|
Tuesday 18/11/2025 13:15-15:00
|
|
Tuesday 2/12/2025 13:15-15:00
|
| |
| Rooms |
Seminarraum 104, Hauptgebäude H4
|
|
Seminarraum 117, Hauptgebäude H4
|
| |
| Students please consult the detailed view for complete information on dates, rooms and planned podcasts. |
User:
Öffentlicher Bereich
Support