| Academic Unit: |
Industrial Engineering |
| Mode of Delivery: |
Face to face |
| Prerequisites: |
None |
| Language of Instruction: |
English |
| Level of Course Unit: |
Undergraduate |
| Course Coordinator: |
- - |
| Course Objectives: |
To be able to effectively use industrial engineering skills, one needs to have a strong background on problem solving process which includes understanding the engineering concepts, developing a solution method to the problem, implementing the method in an engineering tool and analyze the solution. The course gives an opportunity to the students to develop their skills in decision making by letting them to work on industrial engineering problems. Additionally, the usage of essential components of industrial engineering such as optimization, simulation, statistical decision making, programming and data analysis are covered along with its applications in advanced Excel and VBA. At the end of the class, students are expected to implement an engineering problem in a spreadsheet, develop a solution technique, find an appropriate solution, analyze the solution and make a decision. |
| Course Contents: |
Introduction to Decision Support Systems , Functions and Formulations in Excel, Statistical Analysis,Simulation and Large Data Analysis, Optimization, Data manipulation, Using Macros, Subs, Variables, and Objects Etc. in VBA, Using VBA to Develop a Spreadsheet Based Project. |
| Learning Outcomes of the Course Unit (LO): |
- 1- To be able to apply mathematical modeling and operations research to the managerial problems
- 2- Ability to work on large data and do statistical analysis
- 3- Ability to understand system mechanism, simulate a system and analyze a system using simulation
- 4- Ability to develop a model that is required to opmize an industrial problem and ability tol solve the problem
- 5- Ability to develop a solution project using information technology resources
|
| Planned Learning Activities and Teaching Methods: |
- |
| Week | Subjects | Related Preperation |
| 1 |
Introduction to decision support systems |
|
| 2 |
Functions and Formulations in Excel |
|
| 3 |
Functions and Formulations in Excel |
|
| 4 |
Statistical Analysis |
|
| 5 |
Statistical Analysis |
|
| 6 |
Simulation and Large Data Analysis |
|
| 7 |
Simulation and Large Data Analysis |
|
| 8 |
Optimization |
|
| 9 |
Midterm |
|
| 10 |
Optimization |
|
| 11 |
Data manipulation |
|
| 12 |
Using Macros, Subs, Variables, and Objects Etc. in VBA |
|
| 13 |
Using Macros, Subs, Variables, and Objects Etc. in VBA |
|
| 14 |
Using VBA to Develop a Spreadsheet Based Project |
|
At Kadir Has University, a Semester is 14 weeks; The weeks 15 and 16 are reserved for final exams.
THE RELATIONSHIP BETWEEN COURSE LEARNING OUTCOMES (LO) AND PROGRAM QUALIFICATIONS (PQ)
| # |
PQ1 |
PQ2 |
PQ3 |
PQ4 |
PQ5 |
PQ6 |
PQ7 |
PQ8 |
PQ9 |
PQ10 |
PQ11 |
| LO1 |
1 |
2 |
|
|
|
|
|
|
|
|
|
| LO2 |
|
|
|
|
1 |
2 |
|
|
|
|
|
| LO3 |
|
|
1 |
1 |
|
|
|
|
|
|
|
| LO4 |
|
3 |
|
2 |
3 |
|
|
|
|
|
|
| LO5 |
|
|
|
2 |
|
|
|
|
|
|
|
Contribution: 1 Low, 2 Average, 3 High
