Course Name Code Semester T+U Hours Credit ECTS
Decision Making and Spread Sheet and Excel ISL 447 7 2 + 0 2 5
 Precondition Courses Recommended Optional Courses Course Language Turkish Course Level Bachelor's Degree Course Type Optional Course Coordinator Course Lecturers Course Assistants Res. Asst. Serdar Geçer, Res. Asst. 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 ExcelInterpreting 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 , , , , ,
2 Using mathematical and statistical techniques to solve problems , , , , ,
3 Critically analyzing the findings, Interpreting the results , , , , ,
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 Gains the required knowledge in production, marketing, management , accounting and finance. X
2 Can work in teams and share information with team members in tasks of production, marketing, management, accounting and finance. X
3 Identifies and analyzes problems also offers solutions in tasks of production, marketing, management, accounting and finance. X
4 Contributes to projects, takes responsibility and conduct researches in tasks of production, marketing, management, accounting and finance. X
5 Can define goals and objectives of organization in tasks of production, marketing, management, accounting and finance. X
6 Questions the acquired knowledge in tasks of production, marketing, management, accounting and finance. X
7 Believes to adapting new situations and meets the requirements of new tasks of production, marketing, management, accounting and finance. X
8 Can transfer knowledge and recommendations in tasks of production, marketing, management, accounting and finance via using necessery communication tools and a foreign language effectively . X
9 Open to occupational cooperation and sharing in tasks of production, marketing, management, accounting and finance. X
10 Can use necessary information systems in tasks of production, marketing, management, accounting and finance. X
11 Behaves in accordance with social and occupational ethic values in tasks of production, marketing, management, accounting and finance. X
12 Analyses and carries out relations with stake holders in tasks of production, marketing, management, accounting and finance. X
13 Follows the innovations and encourages team members in tasks of production, marketing, management, accounting and finance. X
14 Questions the position of the organization and offers suggestions in tasks of production, marketing, management, accounting and finance. X
15 Is conscious about universality of right, social justice, quality, saving cultural and environmental values, occupational health and safety in tasks of production, marketing, management, accounting and finance.
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 50
1. Kısa Sınav 20
1. Ödev 30
Total 100
1. Yıl İçinin Başarıya 50
1. Final 50
Total 100