Lesson plan /

Lesson Information

Course Credit
Course ECTS Credit
Teaching Language of Instruction İngilizce
Level of Course Bachelor's Degree, TYYÇ: Level 6, EQF-LLL: Level 6, QF-EHEA: First Cycle
Type of Course
Mode of Delivery Face-to-face
Does the course require compulsory or optional work experience?
Course Coordinator Assoc. Prof. (Ph.D.) ILHAM HUSEYINOV
Instructor (s)
Course Assistant

Purpose and Content

The aim of the course After completing this course, student will know basic comcepts of optimization problems, get practical skills to solve optimization problems with Excel Solver and Simplex methods. Apply this theoretical knowledge and practical skills to solving software optimization problems.
Course Content linear and none-linear programming, integer programming, Excel Solver program usage, Simplex method, visualization techniques, sensivity analysis, Simplex method, decision trees, networks

Weekly Course Subjects

1Introduction
2Formulations of linear and non-linear programs
3Geometry and visualizations of linear programs
4Excel Solver add-in
5The simplex method
6Sensitivity analysis and shadow prices
7Game theory 1: 2-person 0-sum, or constant sum
8Midterm
9Practical examples with Solver program
10Introduction to integer programming
11Integer programming techniques 1: branch and bound
12Integer programming techniques 2: cutting planes
13Networks
14Decision trees

Resources

1-Bradley, S. P., A. C. Hax, and T. L. Magnanti. Applied Mathematical Programming. Addison-Wesley, 1977. ISBN: 9780201004649.
2. Microsoft® Excel “Solver” Add-in: Solver.com