Endüstri Mühendisliği

IE 261 | Ders Tanıtım Bilgileri

Dersin Adı

Industrial Information Systems

Kodu	Yarıyıl	Teori (saat/hafta)	Uygulama/Lab (saat/hafta)	Yerel Kredi	AKTS
IE 261	FALL	3	0	3	5

Ön-Koşul(lar)	Yok
Dersin Dili	English
Dersin Türü	Zorunlu
Dersin Düzeyi	Lisans
Dersin Veriliş Şekli	Face to face
Dersin Öğretim Yöntem ve Teknikleri	Problem Solving Lecture / presentation
Ulusal Meslek Sınıflandırma Kodu	-
Dersin Koordinatörü	Dr. Öğr. Üyesi Arya Misiç
Öğretim Eleman(lar)ı	Dr. Öğr. Üyesi Arya Misiç
Yardımcı(ları)	Araş. Gör. Onat Düzgün

Dersin Amacı

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.

Öğrenme Çıktıları

Bu dersi başarıyla tamamlayabilen öğrenciler;

Ad	Açıklama	PC Alt	* Katkı Düzeyi
Ad	Açıklama	PC Alt	1	2	3	4	5
LO1	Use functions and formulas of MS Excel.	1.4			X
LO2	Create graphs and tables in MS Excel.	1.4			X
LO3	Analyze simple databases.	1.6		X
LO4	Solve problems used in decision-making processes using MS Excel.	1.5		X
LO5	use Excel effectively with Visual Basic for Applications (VBA).	1.6			X

Ders Tanımı

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.

Dersin İlişkili Olduğu Sürdürülebilir Kalkınma Amaçları

Dersin Kategorisi	Temel Ders
	Uzmanlık/Alan Dersleri	X
	Destek Dersleri
	İletişim ve Yönetim Becerileri Dersleri
	Aktarılabilir Beceri Dersleri

HAFTALIK KONULAR VE İLGİLİ ÖN HAZIRLIK ÇALIŞMALARI

Hafta	Konular	Ön Hazırlık	Öğrenme Çıktısı
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		-

Ders Kitabı	-
Önerilen Okumalar/Materyaller	-

DEĞERLENDİRME ÖLÇÜTLERİ

Yarıyıl Aktiviteleri	Sayı	Katkı Payı %	LO1	LO2	LO3	LO4	LO5
Küçük Sınav / Stüdyo Kritiği	4	30	X	X	X	X	X
Ara Sınav	1	30	X	X		X
Final Sınavı	1	40			X	X	X
Toplam	6	100

AKTS / İŞ YÜKÜ TABLOSU

Yarıyıl Aktiviteleri	Sayı	Süre (Saat)	İş Yükü
Katılım	-	-	-
Teorik Ders Saati	16	3	48
Laboratuvar / Uygulama Ders Saati	-	-	-
Sınıf Dışı Ders Çalışması	14	2	28
Arazi Çalışması	-	-	-
Küçük Sınav / Stüdyo Kritiği	4	6	24
Portfolyo	-	-	-
Ödev	-	-	-
Sunum / Jüri Önünde Sunum	-	-	-
Proje	-	-	-
Seminer/Çalıştay	-	-	-
Sözlü Sınav	-	-	-
Ara Sınavlar	1	25	25
Final Sınavı	1	25	25
		Toplam	150

DERSİN ÖĞRENME ÇIKTILARININ PROGRAM YETERLİLİKLERİ İLE İLİŞKİSİ

#	PC Alt	Program Yeterlilikleri / Çıktıları	* Katkı Düzeyi
#	PC Alt	Program Yeterlilikleri / Çıktıları	1	2	3	4	5
1	Engineering Knowledge: Knowledge of mathematics, science, basic engineering, computation, and related engineering discipline-specific topics; the ability to apply this knowledge to solve complex engineering problems.
	1	Mathematics
	2	Science
	3	Basic Engineering
	4	Computation			LO1 LO2
	5	Related engineering discipline-specific topics		LO4
	6	The ability to apply this knowledge to solve complex engineering problems		LO3	LO5
2	Problem Analysis: Ability to identify, formulate and analyze complex engineering problems using basic knowledge of science, mathematics and engineering, and considering the UN Sustainable Development Goals relevant to the problem being addressed.
3	Engineering Design: The ability to devise creative solutions to complex engineering problems; the ability to design complex systems, processes, devices or products to meet current and future needs, considering realistic constraints and conditions.
	1	Ability to design creative solutions to complex engineering problems
	2	Ability to design complex systems, processes, devices or products to meet current and future needs, considering realistic constraints and conditions
4	Use of Techniques and Tools: Ability to select and use appropriate techniques, resources, and modern engineering and computing tools, including estimation and modeling, for the analysis and solution of complex engineering problems, while recognizing their limitations.
5	Research and Investigation: Ability to use research methods to investigate complex engineering problems, including literature research, designing and conducting experiments, collecting data, and analyzing and interpreting results.
	1	Literature research for the study of complex engineering problems
	2	Designing experiments
	3	Ability to use research methods, including conducting experiments, collecting data. analyzing and interpreting results
6	Global Impact of Engineering Practices: Knowledge of the impacts of engineering practices on society, health and safety, economy, sustainability, and the environment, within the context of the UN Sustainable Development Goals; awareness of the legal implications of engineering solutions.
	1	Knowledge of the impacts of engineering practices on society, health and safety, economy, sustainability, and the environment, within the context of the UN Sustainable Development Goals
	2	Awareness of the legal implications of engineering solutions
7	Ethical Behavior: Acting in accordance with the principles of the engineering profession, knowledge about ethical responsibility; awareness of being impartial, without discrimination, and being inclusive of diversity.
	1	Acting in accordance with the principles of the engineering profession, knowledge about ethical responsibility ethical responsibility
	2	Awareness of being impartial and inclusive of diversity, without discriminating on any subject
8	Individual and Teamwork: Ability to work effectively, individually and as a team member or leader on interdisciplinary and multidisciplinary teams (face-to-face, remote or hybrid).
	1	Ability to work individually and within the discipline
	2	Ability to work effectively as a team member or leader in multidisciplinary teams (face-to-face, remote or hybrid)
9	Verbal and Written Communication: Taking into account the various differences of the target audience (such as education, language, profession) on technical issues.
	1	Ability to communicate verbally
	2	Ability to communicate effectively in writing
10	Project Management: Knowledge of business practices such as project management and economic feasibility analysis; awareness of entrepreneurship and innovation.
	1	Knowledge of business practices such as project management and economic feasibility analysis
	2	Awareness of entrepreneurship and innovation
11	Lifelong Learning: Lifelong learning skills that include being able to learn independently and continuously, adapting to new and developing technologies, and thinking questioningly about technological changes.