Course Name Code Semester T+U Hours Credit ECTS
Decision Making With Spread Sheet and Excel ISL 453 7 2 + 0 2 5
 Precondition Courses Recommended Optional Courses Course Language Turkish Course Level Bachelor's Degree Course Type Optional Course Coordinator Doç.Dr. ADEM AKBIYIK Course Lecturers Course Assistants Arş. Gör. Serdar Geçer, Arş. Gör. Güliz Uğur Course Category Course Objective 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 Course Content MS Excel, Solver, Decision theory and decision making, Linear programming, Advance functions in Excel
# Course Learning Outcomes Teaching Methods Assessment Methods
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,
Week Course Topics Preliminary Preparation
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
Resources
Course Notes
Course Resources
Order Program Outcomes Level of Contribution
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
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 50
1. Kısa Sınav 10
1. Ödev 20
2. Kısa Sınav 20
Total 100
1. Yıl İçinin Başarıya 50
1. Final 50
Total 100