Course Name | Industrial Information Systems |
Code | Semester | Theory (hour/week) | Application/Lab (hour/week) | Local Credits | ECTS |
---|---|---|---|---|---|
IE 261 | Fall | 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 aim of this course is to inform students about the fundamentals and designs of information systems, and to provide the necessary infrastructure for the analysis and design of database applications that can manage the data needs of businesses. |
Learning Outcomes | The students who succeeded in this course;
|
Course Description | This course teaches the design and development of decision support systems using MS Excel. The course starts with MS Excel functions and then focuses on the development of databases and decision support systems using MS Excel and VBA. Through this course, students gain practical skills that they can use in decision-making processes. |
Related Sustainable Development Goals | |
| Core Courses | |
Major Area Courses | X | |
Supportive Courses | ||
Media and Managment Skills Courses | ||
Transferable Skill Courses |
Week | Subjects | Required Materials |
1 | Introduction, MS Excel Essentials: Referencing and names | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 1,2,3 |
2 | MS Excel Essentials: Functions and Formulas | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 1,2,3 |
3 | MS Excel Essentials: Functions and Formulas | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 1,2,3 |
4 | MS Excel Essentials: Charts, Conditional Formatting and Pivot Tables | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 4,5,6 |
5 | Statistical Analysis | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 7 |
6 | Simulation | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 9 |
7 | Working with Large Data and Database Applications | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 10 |
8 | Midterm Exam | |
9 | MS Excel Essentials: Solver and Modeling | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 8 |
10 | MS Excel Essentials: Solver and Modeling | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 8 |
11 | VBA for Excel 1-Introduction to the Visual Basic Environment | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 11 |
12 | VBA for Excel 2-Recording Macros | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 12 |
13 | VBA for Excel 3-More on Objects | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 13 |
14 | More VBA Examples | |
15 | Semester Review | |
16 | Final Exam |
Course Notes/Textbooks | Seref, M. M., Ahuja, R. K., & Winston, W. L. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas. ISBN: 978-0975914656 |
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. |
Semester Activities | Number | Weighting |
Participation | ||
Laboratory / Application | ||
Field Work | ||
Quizzes / Studio Critiques | 4 | 30 |
Portfolio | ||
Homework / Assignments | ||
Presentation / Jury | ||
Project | ||
Seminar / Workshop | ||
Oral Exam | ||
Midterm | 1 | 30 |
Final Exam | 1 | 40 |
Total |
Weighting of Semester Activities on the Final Grade | 5 | 60 |
Weighting of End-of-Semester Activities on the Final Grade | 1 | 40 |
Total |
Semester Activities | Number | Duration (Hours) | Workload |
---|---|---|---|
Course Hours (Including exam week: 16 x total hours) | 16 | 3 | 48 |
Laboratory / Application Hours (Including exam week: 16 x total hours) | 16 | ||
Study Hours Out of Class | 14 | 2 | 28 |
Field Work | |||
Quizzes / Studio Critiques | 4 | 6 | |
Portfolio | |||
Homework / Assignments | |||
Presentation / Jury | |||
Project | |||
Seminar / Workshop | |||
Oral Exam | |||
Midterms | 1 | 19 | |
Final Exams | 1 | 25 | |
Total | 144 |
# | 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. | |||||
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