INDUSTRIAL ENGINEERING
Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

Course Introduction and Application Information

Course Code Course Name Semester Theoretical Practical Credit ECTS
INE4015 Decision Support Systems with Optimization Fall
Spring
3 0 3 6
The course opens with the approval of the Department at the beginning of each semester

Basic information

Language of instruction: En
Type of course: Departmental Elective
Course Level: Bachelor
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.

Learning Outputs

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

Course Content

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.

Weekly Detailed Course Contents

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

Sources

Course Notes: Ders kitabi yok No specific textbook
References: Developing Spreadsheet-Based Decision Support Systems (Serif, Ahuja, Winston); VBA for Modelers (Albright)

Evaluation System

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

ECTS / Workload Table

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

Contribution of Learning Outcomes to Programme Outcomes

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) Build up a body of knowledge in mathematics, science and industrial engineering subjects; use theoretical and applied information in these areas to model and solve complex engineering problems.
2) Identify, formulate, and solve complex engineering problems; select and apply proper analysis and modeling methods for this purpose.
3) Design a complex system, process, device or product under realistic constraints and conditions, in such a way as to meet the desired result; apply modern design methods for this purpose. The ability to apply modern design methods to meet this objective.
4) Devise, select, and use modern techniques and tools needed for solving complex problems in industrial engineering practice; employ information technologies effectively.
5) Design and conduct experiments, collect data, analyze and interpret results for investigating the complex problems specific to industrial engineering.
6) Cooperate efficiently in intra-disciplinary and multi-disciplinary teams; and show self-reliance when working independently.
7) Demonstrate effective communication skills in both oral and written English and Turkish. Writing and understanding reports, preparing design and production reports, making effective presentations, giving and receiving clear and understandable instructions.
8) Recognize the need for lifelong learning; show ability to access information, to follow developments in science and technology, and to continuously educate him/herself.
9) Develop an awareness of professional and ethical responsibility, and behaving accordingly. Information about the standards used in engineering applications.
10) Know business life practices such as project management, risk management, and change management; develop an awareness of entrepreneurship, innovation, and sustainable development.
11) Know contemporary issues and the global and societal effects of modern age engineering practices on health, environment, and safety; recognize the legal consequences of engineering solutions.
12) Develop effective and efficient managerial skills.