Ders Bilgileri

#### Ders Tanımı

Ders Kodu Yarıyıl T+U Saat Kredi AKTS
DECISION MAKING AND SPREAD SHEET AND EXCEL ISL 447 7 2 + 0 2 5
 Dersin Dili Türkçe Dersin Seviyesi Lisans Dersin Türü SECMELI Dersin Koordinatörü Dersi Verenler Dersin Yardımcıları Res. Asst. Serdar Geçer, Res. Asst. Güliz Uğur Dersin Kategorisi 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
 Dersin Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri 1 - Modelling real life problems 1 - 4 - 15 - A - C - 2 - Using mathematical and statistical techniques to solve problems 1 - 4 - 15 - A - C - 3 - Critically analyzing the findings, Interpreting the results 1 - 4 - 15 - A - C -
 Öğretim Yöntemleri: 1:Lecture 4:Drilland Practice 15:Problem Solving Ölçme Yöntemleri: A:Testing C:Homework

#### Ders Akışı

Hafta Konular ÖnHazı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

Ders Notu
Ders Kaynakları

#### Dersin Program Çıktılarına Katkısı

No Program Öğrenme Çıktıları KatkıDüzeyi
1 2 3 4 5
1 Gains the required knowledge in production, marketing, management , accounting and finance. X
2 Can work in teams and share information with team members in tasks of production, marketing, management, accounting and finance. X
3 Identifies and analyzes problems also offers solutions in tasks of production, marketing, management, accounting and finance. X
4 Contributes to projects, takes responsibility and conduct researches in tasks of production, marketing, management, accounting and finance. X
5 Can define goals and objectives of organization in tasks of production, marketing, management, accounting and finance. X
6 Questions the acquired knowledge in tasks of production, marketing, management, accounting and finance. X
7 Believes to adapting new situations and meets the requirements of new tasks of production, marketing, management, accounting and finance. X
8 Can transfer knowledge and recommendations in tasks of production, marketing, management, accounting and finance via using necessery communication tools and a foreign language effectively . X
9 Open to occupational cooperation and sharing in tasks of production, marketing, management, accounting and finance. X
10 Can use necessary information systems in tasks of production, marketing, management, accounting and finance. X
11 Behaves in accordance with social and occupational ethic values in tasks of production, marketing, management, accounting and finance. X
12 Analyses and carries out relations with stake holders in tasks of production, marketing, management, accounting and finance. X
13 Follows the innovations and encourages team members in tasks of production, marketing, management, accounting and finance. X
14 Questions the position of the organization and offers suggestions in tasks of production, marketing, management, accounting and finance. X
15 Is conscious about universality of right, social justice, quality, saving cultural and environmental values, occupational health and safety in tasks of production, marketing, management, accounting and finance.

#### Değerlendirme Sistemi

YARIYIL İÇİ ÇALIŞMALARI SIRA KATKI YÜZDESİ
AraSinav 1 50
KisaSinav 1 20
Odev 1 30
Toplam 100
Yıliçinin Başarıya Oranı 50
Finalin Başarıya Oranı 50
Toplam 100

#### AKTS - İş Yükü

Etkinlik Sayısı Süresi(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(s) 5.2
Dersin AKTS Kredisi 5.2
; ;