| 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 | ||