| Course Type | Elective Course |
|---|
| Course Level | Bachelor's Degree |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 5 |
|---|
| Name of Lecturer(s) |
|
| Learning Outcomes |
At the end of this course, the students;
- Have an ability to select and practice the appropriate methods and technologies on decision problems
- Have an ability to design a decision support system and its components to meet the requirements
- Have skill to determine, formulate and solve the semistructured decision problems systematically.
- Capable of exercising qualitative and quantitative methods within decision support systems
- Develope a decision support system based on a teamwork
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | None |
|---|
| Course Description | Decision, 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 |
Decision making process |
|
2nd Week |
Decision support systems (DSS) |
|
3rd Week |
DSS and Excel - Introduction to Excel, functions, graphics, referencing, pivot tables,... |
|
4th Week |
Excel and macros |
|
5th Week |
DSS, Model management - Excel object model and VBE |
|
6th Week |
DSS, Model management - Excel, modelling and solver addin |
|
7th Week |
DSS, Model management - Excel VBA |
|
8th Week |
Midterm |
|
9th Week |
DSS, Data and information management - Excel range objects |
|
10th Week |
DSS, Data and information management - Excel, controls, loops |
|
11th Week |
DSS, Data and information management - Excel, user defined fınctions, relational databases |
|
12th Week |
DSS, Diyalog (user interface) management - Excel, arrays, variables |
|
13th Week |
DSS, Diyalog (user interface) management - Excel, forms |
|
14th Week |
DSS developement and ve application developement with VBA |
|
| 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
|
|---|
| Planned Learning Activities and Teaching Methods |
- Lecture
- Homeworks
- Lab studies
- Project
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
30 |
| Practice |
10 |
20 |
| Project |
1 |
15 |
| Total(%) |
|
65 |
| Contribution of In-term Studies to Overall Grade(%) |
|
65 |
| Contribution of Final Examination to Overall Grade(%) |
|
35 |
| Total(%) |
|
100 |
|
| Language of Instruction | English |
|---|
| Work Placement(s) | No |
|---|
