FACULTY OF ENGINEERING

Department of Industrial Engineering

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 Solving
Lecture / 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;
  • Will be able to explain basic benefits of information systems' usage.
  • Will be able to determine data requirements of industrial organizations
  • Will be able to develop simple decision support systems
  • Will be able to use the functions of MS Excel and Visual Basic for MS Excel
  • Will be able to design and implement basic databases.
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.

 



Course Category

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

Izmir University of Economics
is an establishment of
izto logo
Izmir Chamber of Commerce Health and Education Foundation.
ieu logo

Sakarya Street No:156
35330 Balçova - İzmir / Turkey

kampus izmir

Follow Us

İEU © All rights reserved.