IE304 PRODUCTION AND SERVICE INFORMATION SYSTEMS
| Course Code: | 5680304 |
| METU Credit (Theoretical-Laboratory hours/week): | 3 (3.00 - 0.00) |
| ECTS Credit: | 5.0 |
| Department: | Industrial Engineering |
| Language of Instruction: | English |
| Level of Study: | Undergraduate |
| Course Coordinator: | Prof.Dr. SİNAN GÜREL |
| Offered Semester: | Spring Semesters. |
Course Objectives
At the end of the course, the students will be able to
1. comprehend basics of information technology and the issues related with it.
2. design databases, extract required data from databases to analyze the performance of the systems.
3. use tools to gather data required for mathematical models, solve industrial engineering problems and create supportive reports / dashboards for decision makers.
Course Content
Analysis and design of information systems with special emphasis given to production sub-systems. Basic information concepts, data processing technology and its applications. Information systems development methodology in terms of systems analysis, design and implementation. The information requirements of production systems in modular form.
Course Learning Outcomes
At the end of the course, the students will be able to
1.1. have awareness about the concepts of information technology.
1.2. understand functional and user requirements in information systems.
1.3. get familiar with decision support systems in industry.
2.1. learn the basics of relational databases.
2.2. design relational databases and be able to normalize database designs.
2.3. learn Standard Query Language (SQL) to gather required information from databases.
3.1. learn the basics of widely used tools to store data and provide decision support via reports / dashboards (MS Excel, MySQL).
3.2. learn how to automate the processes: data manipulation (MS Excel, VBA for Excel) and reporting (MS Excel).
3.3. practice data gathering on widely used databases such as MySQL, design and create automated decision-support facilities.
Program Outcomes Matrix
| Contribution | |||||
| # | Program Outcomes | No | Yes | ||
| 1 | An ability to identify, formulate, and solve complex engineering problems by applying principles of engineering, science, and mathematics | ✔ | |||
| 2 | An ability to apply engineering design to produce solutions that meet specified needs with consideration of public health, safety, and welfare, as well as global, cultural, social, environmental, and economic factors | ✔ | |||
| 3 | An ability to communicate effectively with a range of audiences | ✔ | |||
| 4 | An ability to recognize ethical and professional responsibilities in engineering situations and make informed judgments, which must consider the impact of engineering solutions in global, economic, environmental, and societal contexts | ✔ | |||
| 5 | An ability to function effectively on a team whose members together provide leadership, create a collaborative and inclusive environment, establish goals, plan tasks, and meet objectives | ✔ | |||
| 6 | An ability to develop and conduct appropriate experimentation, analyze and interpret data, and use engineering judgment to draw conclusions | ✔ | |||
| 7 | An ability to acquire and apply new knowledge as needed, using appropriate learning strategies | ✔ | |||
| 8 | An ability to design, analyze, operate, and improve integrated systems that produce and/or supply products and/or services in an effective, efficient, sustainable, and socially responsible manner | ✔ | |||
| 9 | An ability to apply critical reason and systems thinking in problem solving and systems design | ✔ | |||
| 10 | An ability to use scientific methods and tools (such as mathematical models, statistical methods and techniques) necessary for industrial engineering practice | ✔ | |||