Information Package

Program of Artificial Intelligence Engineering (English)

AI433

DECISION SUPPORT SYSTEMS

Course Code
AI433
Semester
-
Theory+Practice
3 + 0
ECTS
5
Course TypeElective Course
Course LevelBachelor's Degree
Year of Study-
Semester-
ECTS5
Name of Lecturer(s) -
Learning Outcomes

At the end of this course, the students;

  1. Gain an ability to select and practice the appropriate methods and technologies on decision problems.
  2. Gain an ability to design a decision support system and its components professionally to meet the requirements.
  3. Determine, formulate and solve the semi structured decision problems systematically..
  4. Use the qualitative and quantitative methods within decision support systems.
  5. Gain an ability to transform technologies into engineering solutions.
Mode of DeliveryFace to face
PrerequisitesNo
Recommended Optional Programme Components
Course DescriptionDecision, data and information in multi-media. Information and knowledge. Structured and semi-structured decisions. Decision making process and cognitive styles of decision makers. Types of DSS. Model management and Solver-based model management in Excel. Data and information management and development of information management in Excel. Diyalog management and user interface implementations in Excel. Data export and import between Access and Excel. Implementation issues.
Course Contents
WEEK TOPICS
1st Week Introduction to DSS and business intelligence
2nd Week Intro to DSS development in Excel and VBA
3rd Week Excel object model and VBE
4th Week Macros and VBA
5th Week Range objects
6th Week Control logic and loops
7th Week Other Excel objects
8th Week Midterm
9th Week Arrays, variables and subroutines
10th Week User forms and error handling
11th Week Working with Files and folders
12th Week Importing data into Excel
13th Week Working with pivot tables
14th Week Menus and toolbars,Data mining in Excel
Recommended or Required Reading* Turban, Sharda, Delen, Decision Support Systems and Business Intelligence Systems, 9th edition, Pearson Pub., 2011
* Korkmaz, T., Excel 2000 ile Programlama ve Makrolar, ExcelTim, 2003
* Shapiro, L.G. & Stockman, G.C., "Computer Vision", Prentice Hall, (2001).
Planned Learning Activities and Teaching Methods
  • Practice
  • Lecture
  • Questions/Answers
  • Problem Solving
Assessment Methods and Criteria
Quantity Percentage (%)
Mid-term 1 30
Project 1 30
Total(%) 60
Contribution of In-term Studies to Overall Grade(%) 60
Contribution of Final Examination to Overall Grade(%) 40
Total(%) 100
Language of Instruction-
Work Placement(s)No
LO1 LO2 LO3 LO4 LO5
K1
K2
K3
K4
K5
K6
K7
K8
K9
K10
K11
K12