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 Excel
Interpreting 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
1 Our students will have fundamental knowledge in business administration. X
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
4 Our students will participate in projects about business administration process and tasks. X
5 Our students will accept responsibility in order to conclude 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
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
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
Total Workload 130
Total Workload / 25 (Hours) 5.2
dersAKTSKredisi 5