Ders Bilgileri

#### Ders Tanımı

Ders Kodu Yarıyıl T+U Saat Kredi AKTS
MACRO PROGRAMMING ENM 413 7 3 + 0 3 5
 Dersin Dili Türkçe Dersin Seviyesi Lisans Dersin Türü SECMELI Dersin Koordinatörü Dr.Öğr.Üyesi GÜLTEKİN ÇAĞIL Dersi Verenler Dr.Öğr.Üyesi GÜLTEKİN ÇAĞIL Dersin Yardımcıları Dersin Kategorisi 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
 Dersin Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri 1 - Comprehending main specifications of spreadsheet softwares 1 - 2 - 3 - 4 - 12 - 13 - 14 - 15 - A - C - 2 - Comprehending what we obtain and what we can do with spreadsheet softwares 1 - 2 - 3 - 4 - 12 - 13 - 14 - 15 - A - C -
 Öğretim Yöntemleri: 1:Lecture 2:Question-Answer 3:Discussion 4:Drilland Practice 12:Case Study 13:Lab / Workshop 14:Self Study 15:Problem Solving Ölçme Yöntemleri: A:Testing C:Homework

#### Ders Akışı

Hafta Konular ÖnHazı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

#### Dersin Program Çıktılarına Katkısı

No Program Öğrenme Çı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

YARIYIL İÇİ ÇALIŞMALARI SIRA KATKI YÜZDESİ
AraSinav 1 50
KisaSinav 1 10
Odev 1 30
KisaSinav 2 10
Toplam 100
Yıliçinin Başarıya Oranı 50
Finalin Başarıya Oranı 50
Toplam 100

#### AKTS - İş Yükü

Etkinlik Sayısı Süresi(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(s) 4.56
Dersin AKTS Kredisi 4.56
; ;