Ders Adı Kodu Yarıyıl T+U Saat Kredi AKTS
Macro Programmıng ENM 413 7 3 + 0 3 5
Ön Koşul Dersleri
Önerilen Seçmeli Dersler
Dersin Dili Türkçe
Dersin Seviyesi Lisans
Dersin Türü Seçmeli
Dersin Koordinatörü Doç.Dr. GÜLTEKİN ÇAĞIL
Dersi Verenler Doç.Dr. GÜLTEKİN ÇAĞIL,
Dersin Yardımcıları
Dersin Kategorisi Diğer
Dersin Amacı

Providing spreadsheet softwares and ability to write a programme with Microsoft Excel

Dersin İçeriği

Describing Microsoft Excel software that one of the spreadsheet softwares and able to write macro programme with Microsoft Excel

# Ders Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
1 Comprehending main specifications of spreadsheet softwares Lecture, Case Study, Lab / Workshop, Drilland Practice, Self Study, Problem Solving, Question-Answer, Discussion, Testing, Homework,
2 Comprehending what we obtain and what we can do with spreadsheet softwares Discussion, Drilland Practice, Problem Solving, Question-Answer, Lab / Workshop, Self Study, Lecture, Case Study, Testing, Homework,
Hafta Ders Konuları Ön Hazırlık
1 General informations about Microsoft Excel, cell concept, copy-paste and special paste in excel
2 Absolute and relative references and range concept in excel
3 Function concept in excel
4 Conditional formatting
5 Data validation
6 Relations between Excel and Visual Basic
7 General informations about Visual Basic
8 User Defined Functions in excel
9 Range concept in User Defined Functions
10 Basic operations in Excel Visual Basic Editor
11 Working with macro recording
12 Function and graphics operatins with macro programming
13 Sample applications
14 Industrial aplications with macro programming
Kaynaklar
Ders Notu

I http://www.gultekincagil.co

lecture notes published on this link

Ders Kaynakları

1. The VBA Macros, M. Kemal Korkmaz,
2. "Step by Step" Microsoft Excel XP 2002, Curtis Frye, Arkadaş Publications

Sıra Program Çıktıları Katkı Düzeyi
1 2 3 4 5
1 Engineering graduates with sufficient knowledge background on science and engineering subjects of their related area, and who are skillful in implementing theoretical and practical knowledge for modelling and solving engineering problems. X
2 Engineering graduates with skills in identifying, describing, formulating and solving complex engineering problems, and thus,deciding and implementing appropriate methods for analyzing and modelling. X
3 Engineering graduates with skills in designing a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; for this purpose, skills in implementing modern design methods. X
4 Engineering graduates with skills in developing, selecting and implementing modern techniques and tools required for engineering applications as well as with skills in using information technologies effectively. X
5 Engineering graduates with skills in designing and conducting experiments, collecting data, analyzing and interpreting the results in order to evaluate engineering problems. X
6 Engineering graduates who are able to work within a one discipline or multi-discipline team,as well as who are able to work individually X
7 Engineering graduates who are able to effectively communicate orally and officially in Turkish Language as well as who knows at least one foreign language
8 Engineering graduates with motivation to life-long learning and having known significance of continuous education beyond undergraduate studies for science and technology X
9 Engineering graduates with well-structured responsibilities in profession and ethics
10 Engineering graduates having knowledge about practices in professional life such as project management, risk management and change management, and who are aware of innovation and sustainable development. X
11 Engineering graduates having knowledge about universal and social effects of engineering applications on health, environment and safety, as well as having awareness for juridical consequences of engineering solutions.
Değerlendirme Sistemi
Yarıyıl Çalışmaları Katkı Oranı
1. Ara Sınav 50
1. Kısa Sınav 10
1. Ödev 30
2. Kısa Sınav 10
Toplam 100
1. Yıl İçinin Başarıya 50
1. Final 50
Toplam 100
AKTS - İş Yükü Etkinlik Sayı Süre (Saat) Toplam İş Yükü (Saat)
Course Duration (Including the exam week: 16x Total course hours) 16 3 48
Hours for off-the-classroom study (Pre-study, practice) 16 2 32
Mid-terms 1 8 8
Assignment 1 10 10
Performance Task (Laboratory) 1 16 16
Toplam İş Yükü 114
Toplam İş Yükü / 25 (Saat) 4,56
Dersin AKTS Kredisi 5