Ders Adı Kodu Yarıyıl T+U Saat Kredi AKTS
Decısıon Makıng Wıth Spread Sheet and Excel ISL 453 7 2 + 0 2 5
 Ön Koşul Dersleri Önerilen Seçmeli Dersler Dersin Dili Türkçe Dersin Seviyesi Lisans Dersin Türü Seçmeli Dersin Koordinatörü Doç.Dr. ADEM AKBIYIK Dersi Verenler Dersin Yardımcıları Arş. Gör. Serdar Geçer, Arş. Gör. Güliz Uğur Dersin Kategorisi Diğer Dersin Amacı Critical thinking and analzying the problems in detail, Modelling of business problems in a spreadsheet, Solving problems by using ExcelInterpreting results to support decision making Dersin İçeriği MS Excel, Solver, Decision theory and decision making, Linear programming, Advance functions in Excel
# Ders Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
1 Modelling real life problems Lecture, Drilland Practice, Problem Solving, Testing, Homework,
2 Using mathematical and statistical techniques to solve problems Lecture, Drilland Practice, Problem Solving, Testing, Homework,
3 Critically analyzing the findings, Interpreting the results Lecture, Drilland Practice, Problem Solving, Testing, Homework,
Hafta Ders Konuları Ön Hazırlık
1 Decision Theory and Techniques
2 Spreadsheets, Microsoft Excel and Solver
3 Linear Programming
4 Production, Transportation and Manufacturing Problems with Excel
5 Finance, Accounting, and Marketing Problems with Excel
6 Duality and Sensitivity Analysis
7 Applications of Duality and Sensitivity Analysis
8 Midterm exam
9 Network Problems
10 Assignment Problems
11 Integer Programming
12 Goal Programming
13 Probability
14 Forecasting and Simulation
Kaynaklar
Ders Notu
Ders Kaynakları
Sıra Program Çıktıları Katkı Düzeyi
1 2 3 4 5
2 Our students will be able to work in teams, and share information with team members in tasks of business administration X
3 Our students will identify and analyse problems to offer solutions in tasks of business administration. X
6 Our students will define ethical problems in work environment and generate solutions. X
7 Our students can transfer their knowledge and suggestions with technology supported tools and written communication skills. X
8 Our students can transfer their knowledge and suggestions by written and verbal communication skills. X
Değerlendirme Sistemi
Yarıyıl Çalışmaları Katkı Oranı
1. Ara Sınav 50
1. Kısa Sınav 10
1. Ödev 20
2. Kısa Sınav 20
Toplam 100
1. Yıl İçinin Başarıya 50
1. Final 50
Toplam 100
AKTS - İş Yükü Etkinlik Sayı Süre (Saat) Toplam İş Yükü (Saat)
Course Duration (Including the exam week: 16x Total course hours) 16 3 48
Hours for off-the-classroom study (Pre-study, practice) 16 2 32
Mid-terms 1 10 10
Quiz 1 10 10
Assignment 1 10 10
Final examination 1 20 20
Toplam İş Yükü 130
Toplam İş Yükü / 25 (Saat) 5,2
Dersin AKTS Kredisi 5