| 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 (Core Course) | |||||
| Course Level | First Cycle | |||||
| Mode of Delivery | Face to face | |||||
| Teaching Methods and Techniques of the Course |
Problem Solving Lecture / presentation |
|||||
| National Occupational Classification Code | - | |||||
| 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 | Learning Outcome |
| 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 | LO1 |
| 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 | LO1 |
| 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 | LO1 |
| 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 | LO2 |
| 5 | 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 | LO2 |
| 6 | Simulation | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 9 | LO4 |
| 7 | Simulation | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 9 | LO4 |
| 8 | Midterm Exam | - | |
| 9 | 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 | LO3 |
| 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 | LO4 |
| 11 | 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 | LO4 |
| 12 | 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 | LO5 |
| 13 | 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 | LO5 |
| 14 | VBA for Excel 3-More on Objects and Examples for VBA | Seref, M. M. et al. (2007). Developing spreadsheet-based decision support systems. Charlestown, MA, USA: Dynamic Ideas, Chapter 13 | LO5 |
| 15 | Semester Review | - | |
| 16 | Final Exam | - |
| Course Notes/Textbooks | - |
| Suggested Readings/Materials | - |
| Semester Activities | Number | Weighting | LO1 | LO2 | LO3 | LO4 | LO5 |
| Quizzes / Studio Critiques | 4 | 30 | X | X | X | X | X |
| Midterm | 1 | 30 | X | X | X | ||
| Final Exam | 1 | 40 | X | X | X | ||
| Total | 6 | 100 |
| Semester Activities | Number | Duration (Hours) | Workload |
|---|---|---|---|
| Participation | - | - | - |
| Theoretical Course Hours | 16 | 3 | 48 |
| Laboratory / Application Hours | - | - | - |
| Study Hours Out of Class | 14 | 2 | 28 |
| Field Work | - | - | - |
| Quizzes / Studio Critiques | 4 | 6 | 24 |
| Portfolio | - | - | - |
| Homework / Assignments | - | - | - |
| Presentation / Jury | - | - | - |
| Project | - | - | - |
| Seminar / Workshop | - | - | - |
| Oral Exams | - | - | - |
| Midterms | 1 | 25 | 25 |
| Final Exam | 1 | 25 | 25 |
| Total | 150 |
| # | PC Sub | Program Competencies/Outcomes | * Contribution Level | ||||
| 1 | 2 | 3 | 4 | 5 | |||
| No program competency data found. | |||||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest
As Izmir University of Economics transforms into a world-class university, it also raises successful young people with global competence.
More..Izmir University of Economics produces qualified knowledge and competent technologies.
More..Izmir University of Economics sees producing social benefit as its reason for existence.
More..