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, |
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 |