FACULTY OF ENGINEERING
Department of Industrial Engineering
SOCIAL MEDIA
IE 261 | Course Introduction and Application Information
| Course Name |
Industrial Information Systems
|
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
|
IE 261
|
Spring
|
3
|
0
|
3
|
5
|
| Prerequisites |
None
|
|||||
| Course Language |
English
|
|||||
| Course Type |
Required
|
|||||
| Course Level |
First Cycle
|
|||||
| Mode of Delivery | - | |||||
| Teaching Methods and Techniques of the Course | Problem SolvingLecture / Presentation | |||||
| Course Coordinator | ||||||
| Course Lecturer(s) | ||||||
| Assistant(s) | ||||||
| Course Objectives | The purpose of this course is to provide a background of the relevant information on technologies and manufacturing systems applicable to industrial organizations, to provide an understanding about the design and implementation of information systems, and to give students a solid foundation for the analysis, design and implementation of database applications for managing the data needs of an industrial organizations. |
| Learning Outcomes |
The students who succeeded in this course;
|
| Course Description | The topics of this course include the design and implementation of basic decision support systems using MS Excel. The first part of the course introduces the functions of MS Excel, while in the second part, information on how to develop databases and decision support systems via VBA is given. Students are encouraged to apply immediately what is taught during the class. They will handle a group project where they develop a real decision support system. |
|
|
Core Courses | |
| Major Area Courses |
X
|
|
| Supportive Courses | ||
| Media and Management Skills Courses | ||
| Transferable Skill Courses |
WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES
| Week | Subjects | Related Preparation |
| 1 | Spreadsheets, Introduction to cells, formatting, MS Excel Essentials: Referencing and Names, Functions and Formula, Charts | Textbook Chapter 2-3-4-5 |
| 2 | MS Excel Essentials: Referencing and Names, Functions and Formula, Charts | Textbook Chapter 3-4-5 |
| 3 | MS Excel Essentials: Referencing and Names, Functions and Formula, Charts | Textbook Chapter 3-4-5 |
| 4 | Dynamic Chart, Data Table, Goal Seek and Scenario Applications, Conditional Formatting | Lecture Notes |
| 5 | Random Number Generations and Simulation Applications | Lecture Notes |
| 6 | Mathematical Applications using MS Excel | Lecture Notes |
| 7 | MS Excel Essentials: Pivot Tables, Graphs, Statistical Analysis | Textbook Chapters 6-7 |
| 8 | Midterm Exam | All previous chapters, slides |
| 9 | Using Data Analysis Module | Lecture Notes |
| 10 | MS Excel Essentials: Solver and Modeling | Textbook Chapters 8-10 |
| 11 | Optimization and Decision Making | Lecture Notes |
| 12 | Visual Basic for MS Excel: Visual Basic Environment, Recording Macros | Textbook Chapters 11-12 |
| 13 | Visual Basic for MS Excel: More on Objects, Variables | Textbook Chapters 13-14 |
| 14 | Database Applications (DSUM, DAVERAGE, DMAX, DMIN, DPRODUCT) | Lecture Notes |
| 15 | General review and evaluation | |
| 16 | Review of the Semester |
| Course Notes/Textbooks | Developing Spreadsheet-Based Decision Support Systems, Dynamic Ideas LLC; 2nd edition (2011), ISBN:9780975914687 |
| Suggested Readings/Materials | Using MIS, David M. Kroenke, Second Edition, 2009 Prentice Hall, ISBN: 9780138132484. Fundamentals of Database Systems, R. Elmasri, S.K. Navathe, Fifth Edition, 2006 AddisonWesley, ISBN: 9780321369574. |
EVALUATION SYSTEM
| Semester Activities | Number | Weigthing |
| Participation | ||
| Laboratory / Application | ||
| Field Work | ||
| Quizzes / Studio Critiques |
5
|
30
|
| Portfolio | ||
| Homework / Assignments | ||
| Presentation / Jury | ||
| Project | ||
| Seminar / Workshop | ||
| Oral Exams | ||
| Midterm |
1
|
30
|
| Final Exam |
1
|
40
|
| Total |
| Weighting of Semester Activities on the Final Grade |
6
|
60
|
| Weighting of End-of-Semester Activities on the Final Grade |
1
|
40
|
| Total |
ECTS / WORKLOAD TABLE
| Semester Activities | Number | Duration (Hours) | Workload |
|---|---|---|---|
| Theoretical Course Hours (Including exam week: 16 x total hours) |
16
|
3
|
48
|
| Laboratory / Application Hours (Including exam week: '.16.' x total hours) |
16
|
0
|
|
| Study Hours Out of Class |
14
|
2
|
28
|
| Field Work |
0
|
||
| Quizzes / Studio Critiques |
5
|
6
|
30
|
| Portfolio |
0
|
||
| Homework / Assignments |
0
|
||
| Presentation / Jury |
0
|
||
| Project |
0
|
||
| Seminar / Workshop |
0
|
||
| Oral Exam |
0
|
||
| Midterms |
1
|
19
|
19
|
| Final Exam |
1
|
25
|
25
|
| Total |
150
|
COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP
|
#
|
Program Competencies/Outcomes |
* Contribution Level
|
||||
|
1
|
2
|
3
|
4
|
5
|
||
| 1 | To have adequate knowledge in Mathematics, Science and Industrial Engineering; to be able to use theoretical and applied information in these areas to model and solve Industrial Engineering problems. |
X | ||||
| 2 | To be able to identify, formulate and solve complex Industrial Engineering problems by using state-of-the-art methods, techniques and equipment; to be able to select and apply proper analysis and modeling methods for this purpose. |
X | ||||
| 3 | To be able to analyze a complex system, process, device or product, and to design with realistic limitations to meet the requirements using modern design techniques. |
|||||
| 4 | To be able to choose and use the required modern techniques and tools for Industrial Engineering applications; to be able to use information technologies efficiently. |
X | ||||
| 5 | To be able to design and do simulation and/or experiment, collect and analyze data and interpret the results for investigating Industrial Engineering problems and Industrial Engineering related research areas. |
X | ||||
| 6 | To be able to work efficiently in Industrial Engineering disciplinary and multidisciplinary teams; to be able to work individually. |
|||||
| 7 | To be able to communicate effectively in Turkish, both orally and in writing; to be able to author and comprehend written reports, to be able to prepare design and implementation reports, to present effectively; to be able to give and receive clear and comprehensible instructions |
|||||
| 8 | To have knowledge about contemporary issues and the global and societal effects of Industrial Engineering practices on health, environment, and safety; to be aware of the legal consequences of Industrial Engineering solutions. |
|||||
| 9 | To be aware of professional and ethical responsibility; to have knowledge of the standards used in Industrial Engineering practice. |
|||||
| 10 | To have knowledge about business life practices such as project management, risk management, and change management; to be aware of entrepreneurship and innovation; to have knowledge about sustainable development. |
|||||
| 11 | To be able to collect data in the area of Industrial Engineering; to be able to communicate with colleagues in a foreign language. |
|||||
| 12 | To be able to speak a second foreign at a medium level of fluency efficiently. |
|||||
| 13 | To recognize the need for lifelong learning; to be able to access information, to be able to stay current with developments in science and technology; to be able to relate the knowledge accumulated throughout the human history to Industrial Engineering. |
|||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest
SOCIAL MEDIA
NEWS |ALL NEWS
He became the European champion while trying to lose weight
Yağız Hacılar, a student at Izmir University of Economics (IUE) Department of Industrial Engineering, became the European champion twice in taekwondo, which
A 'digital' model for the construction industry
Sadık Onur Özden and Tunç Çokuysal, students of Izmir University of Economics (IUE), turned the demand for digitalization in the construction industry
Faculty 101
Industrial Systems Society organized the Faculty101 seminar in our school for the students who begin to the Industrial Engineering Department to introduce
