| MATHEMATICS (TURKISH, PHD) | |||||
| PhD | TR-NQF-HE: Level 8 | QF-EHEA: Third Cycle | EQF-LLL: Level 8 | ||
| Course Code | Course Name | Semester | Theoretical | Practical | Credit | ECTS |
| INE4015 | Decision Support Systems with Optimization | Fall | 3 | 0 | 3 | 6 |
| The course opens with the approval of the Department at the beginning of each semester |
| Language of instruction: | En |
| Type of course: | Departmental Elective |
| Course Level: | |
| Mode of Delivery: | Face to face |
| Course Coordinator : | Assoc. Prof. SABRİ TANKUT ATAN |
| Course Objectives: | Applications of decision support systems in industrial engineering. Developing and implementing decision support systems arising in industrial engineering using popular database management and spreadsheet software; Microsoft Excel; Visual Basic for Applications; Optimization software. Mathematical modelling. Project. |
|
The students who have succeeded in this course; 1) Be able to develop a DSS that can solve an IE-related problem using MS Excel, VBA and optimization software 2) Learn about some real-world DSS examples in the IE domain 3) Improve MS Excel skills 4) Improve technical report writing skills |
| What is a DSS? DSS examples in the IE domain. Software architecture of a DSS with optimization. Mathematical modelling. VBA. Advanced MS Excel functions. Optimization software. Smartclass ve coding activities. Project. |
| Week | Subject | Related Preparation | |
| 1) | What is a DSS? Examples of DSS (2 articles), Intro to VBA | ||
| 2) | TSP – Nearest neighbour heuristic using VBA | ||
| 3) | Mini Project: GAMS model | ||
| 4) | Mini project: Running GAMS from Excel | ||
| 5) | Userforms, basic user interface controls | ||
| 6) | Userforms, basic user interface controls | ||
| 7) | Pivottables, creating pivottables via VBA | ||
| 8) | Simulations with VBA | ||
| 9) | Simulations with VBA | ||
| 10) | MT exam | ||
| 11) | MT solutions, pseudocode implementation | ||
| 12) | Pseudocode implementation | ||
| 13) | Excel functions and formulas | ||
| 14) | Project presentations | ||
| Course Notes: | Ders kitabi yok No specific textbook |
| References: | Developing Spreadsheet-Based Decision Support Systems (Serif, Ahuja, Winston); VBA for Modelers (Albright) |
| Semester Requirements | Number of Activities | Level of Contribution |
| Attendance | % 0 | |
| Laboratory | % 0 | |
| Application | % 0 | |
| Field Work | % 0 | |
| Special Course Internship (Work Placement) | % 0 | |
| Quizzes | % 0 | |
| Homework Assignments | 11 | % 10 |
| Presentation | % 0 | |
| Project | 1 | % 35 |
| Seminar | % 0 | |
| Midterms | 1 | % 15 |
| Preliminary Jury | % 0 | |
| Final | 1 | % 40 |
| Paper Submission | % 0 | |
| Jury | % 0 | |
| Bütünleme | % 0 | |
| Total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 25 | |
| PERCENTAGE OF FINAL WORK | % 75 | |
| Total | % 100 | |
| Activities | Number of Activities | Duration (Hours) | Workload |
| Course Hours | 14 | 3 | 42 |
| Laboratory | 0 | 0 | 0 |
| Application | 0 | 0 | 0 |
| Special Course Internship (Work Placement) | 0 | 0 | 0 |
| Field Work | 0 | 0 | 0 |
| Study Hours Out of Class | 0 | 0 | 0 |
| Presentations / Seminar | 0 | 0 | 0 |
| Project | 1 | 90 | 90 |
| Homework Assignments | 11 | 1 | 11 |
| Quizzes | 0 | 0 | 0 |
| Preliminary Jury | 0 | 0 | 0 |
| Midterms | 1 | 3 | 3 |
| Paper Submission | 0 | 0 | 0 |
| Jury | 0 | 0 | 0 |
| Final | 1 | 3 | 3 |
| Total Workload | 149 | ||
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution |