defter*
defter / katalog / IE 469
IE 469

Industrial Applications of Operations Research

IE 469 is about turning operations research models you've seen in theory into working decision tools inside the software practitioners actually use — Excel, Solver, and VBA. You'll move through six case studies and a build-your-own project, starting with spreadsheet fundamentals and pivot tables before layering on LP/IP via Solver, Monte Carlo and discrete-event simulation, and finally VBA macros, UserForms, and heuristics like nearest-neighbor for TSP. It sits downstream of the core OR sequence (IE 202/302) and serves as the bridge between formulating a model on paper and shipping something a non-technical manager can click through, which is most of what entry-level IE work actually looks like.

Credit3ECTS5FacultyFaculty of EngineeringBölümIndustrial EngineeringPreIE 303 and MATH 260 and (CS 115 or CS 101)

Değerlendirme 100% — 4 adım

15%
30%
25%
30%
Case study Case Study 15%
Midterm:Essay/written Midterm Exam 30%
Project Course Project 25%
Final:Essay/written Final Exam 30%

Önerilen kaynaklar 3 kitap

📖
Önerilen
VBA for Modelers: Developing Decision Support Systems
S. Christian Albright
4th Edition
📖
Önerilen
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Cliff Ragsdale
7th Edition
📖
Önerilen
Developing Spreadsheet-Based Decision Support Systems
Sandra D. Eksioglu, Michelle M.H. Seref
Ravindra K. Ahuja · Wayne L. Winston

Haftalık müfredat 14 hafta

Hafta 1
Introduction, Spreadsheet (SS) Basics, Basic Operators, Functions
Hafta 2
SS Essentials - Functions, Formulas, Filtering, Charts, Case Study 1
Hafta 3
SS Essentials - Pivot Tables, Case Study 2
Hafta 4
SS Essentials, Midterm
Hafta 5
Advanced SS Tools - Linear and Integer Programming: Introduction to Excel Solver, Handling Basic Stochastic Models in Excel, Case Study 3
Hafta 6
Advanced SS Tools - Discrete Event System Simulation with Excel: Data Tables, Goal Seek, Statistical Distributions, Engineering Economy in Excel, Case Study 4
Hafta 7
Introduction to Spreadsheet Programming - Macro and VBA, Recording Macros, Macro Lab Excercises
Hafta 8
VBA Essentials - Variables, Control Statements, Loops, VBA Lab Exercises, Project Assigned
Hafta 9
VBA Essentials, Midterm
Hafta 10
User Interface Design with VBA - UserForms, Error Handling, Debugging, Lab Exercises
Hafta 11
Excel Solver via VBA, Case Study 5
Hafta 12
Heuristic Algorithms with VBA - Basic constructive and improvement heuristics, TSP Nearest Neighbor Algorithm. Case Study 6
Hafta 13
Project Demos
Hafta 14
Project Demos

Ders notları — henüz yok

IE 469 için defter ekibi henüz not yazmadı.

İlk dosyayı sen atarsan — not, slayt, geçmiş sınav, çözüm, cheat-sheet, ne varsa — defter ekibi öğrenci paylaşımlarından bu dersin notlarını yazar. Drive linki / PDF / ZIP, hepsi olur.

← katalog

Geçmiş GPA dağılımı 18 dönem · ort. 2.89

DönemCourse CPA
2025-2026 Fall 2.92 1 sec · 52 öğr
2024-2025 Spring 2.81 1 sec · 53 öğr
2023-2024 Fall 2.51 1 sec · 52 öğr
2023-2024 Spring 2.87 1 sec · 54 öğr
2022-2023 Fall 2.92 1 sec · 54 öğr
2022-2023 Spring 2.64 1 sec · 54 öğr
2021-2022 Fall 3.06 1 sec · 54 öğr
2020-2021 Fall 3.22 1 sec · 59 öğr
2019-2020 Fall 2.98 1 sec · 54 öğr
2019-2020 Spring 3.22 1 sec · 54 öğr

Aggregate course GPA — Bilkent STARS'tan public data. Hoca-bazlı per-section detayı için STARS evaluation report →. Öğrenci anket cevapları KVKK kapsamında defter'de tutulmaz.

⚠️ FZ engelleyen şartlar

Failing to submit the course project will result in an FZ grade.

Hocalar 0 bu dönem · 3 geçmiş

Geçmişte ders veren (3 kişi)
Emre Uzun, Okan Arslan, Claudio Arbib