COURSE INTRODUCTION AND APPLICATION INFORMATION


Course Name
Industrial Information Systems I-Databases and Analysis
Code
Semester
Theory
(hour/week)
Application/Lab
(hour/week)
Local Credits
ECTS
ISE 211
Fall
2
2
3
5
Prerequisites
None
Course Language
English
Course Type
Required
Course Level
First Cycle
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 understand 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 Content 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 Managment Skills Courses
Transferable Skill Courses

 

WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES

Week Subjects Related Preparation
1 Introduction, defining decision support systems (DSS’s) Chapter 1
2 Data, information, database, ER diagram Chapter 2
3 Spreadsheets, Introduction to cells, formatting Chapter 2
4 Spreadsheets, Introduction to cells, formatting Chapters 3-4-5
5 MS Excel Essentials: Referencing and Names, Functions and Formula, Charts Chapters 3-4-5
6 MS Excel Essentials: Pivot Tables, Statistical Analysis Chapters 6-7
7 MS Excel Essentials: Solver and Modeling, Working with Large Data Chapters 8-10
8 Midterm Exam All previous chapters, slides
9 Visual Basic for MS Excel: Visual Basic Environment, Recording Macros Chapters 11-12
10 Visual Basic for MS Excel: More on Objects, Variables Chapters 13-14
11 Visual Basic for MS Excel: Procedures, Programming Structures Chapters 15-16
12 Visual Basic for MS Excel: Arrays, User Interface Chapters 17-18
13 Visual Basic for MS Excel: Solver ReVisited Chapter 19
14 Case Studies: DSS Development Process, GUI Design and Programming Principles Chapters 22-23
15 General review and evaluation
16 Review of the Semester  
Course Textbooks Power point slides
References 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 Requirements Number Percentage
Participation
Laboratory / Application
Field Work
Quizzes / Studio Critiques
6
30
Homework / Assignments
Presentation / Jury
Project
1
40
Seminar / Workshop
Midterms / Oral Exams
1
30
Final / Oral Exam
Total

Contribution of Semester Work to Final Grade
100
Contribution of Final Work to Final Grade
Total

ECTS / WORKLOAD TABLE

Activities Number Duration (Hours) Workload
Course Hours
Including exam week: 16 x total hours
16
2
32
Laboratory / Application Hours
Including exam week: 16 x total hours
16
2
Study Hours Out of Class
Field Work
Quizzes / Studio Critiques
6
6
Homework / Assignments
Presentation / Jury
Project
1
30
Seminar / Workshop
Midterms / Oral Exams
1
12
Final / Oral Exam
    Total
142

 

COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP

#
Program Qualifications / Outcomes
* Level of Contribution
1
2
3
4
5
1 Have the ability to optimize the managerial decisionmaking processes with the assessment of quality in production and service systems using Industrial Engineering tools and techniques such as simulation, optimization, probability and statistics, and analyze, interpret and assess data obtained. X
2 Be able to design integrated business systems with a systems approach based on the business requirements by generating and developing multiple alternatives X
3 Can identify, analyze and develop solutions based on scientific evidence to Industrial Engineering problems encountered in practice X
4 Have the ability to identify the problems in Industrial Engineering issues such as resource allocation, production planning and scheduling, quality control and assurance, financial analysis, and risk analysis, etc. and find the optimal solution by developing multiple solutions for these problems using quantitative analysis and critical thinking techniques with systems approach X
5 Be able to take responsibility for him/herself and for colleagues and employees to solve unpredicted complex problems encountered in practice individually or as a group member X
6 Have the ability to evaluate the knowledge and skills obtained in Industrial Engineering, be able to identify the topics which require improvement, and direct learning efforts to improve these points X
7 Can present and share knowledge, thoughts, and suggestions for solutions to problems related to the Industrial Engineering with colleagues using written and oral communication tools to both specialist and nonspecialist audiences supported by quantitative and qualitative data X
8 Ability to follow the developments in the field of Industrial Engineering and ability to communicate with colleagues using a foreign language. ("European Language Portfolio Global Scale", Level B1) X
9 Ability to use software programs related to Industrial Engineering and to have the knowledge and skills to learn and use software programs, information and communication technologies faced in practice. (“European Computer Driving License", Advanced Level) X
10 Understanding of social consciousness and to value social rights and justice. To value quality management and quality processes related to environment and job safety X
11 Ability to consider social, scientific, and ethical values in data collection, interpretation, and implementation stages of the Industrial Engineering problems and projects X

*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest

 

İzmir Ekonomi Üniversitesi | Sakarya Caddesi No:156, 35330 Balçova - İZMİR Tel: +90 232 279 25 25 | webmaster@ieu.edu.tr | YBS 2010