| Ders Adı | Kodu | Yarıyıl | T+U Saat | Kredi | AKTS |
|---|---|---|---|---|---|
| Electronıc Table Applıcatıons In Engıneerıng | MYT 509 | 0 | 3 + 0 | 3 | 6 |
| Ön Koşul Dersleri | |
| Önerilen Seçmeli Dersler | |
| Dersin Dili | Türkçe |
| Dersin Seviyesi | YUKSEK_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ı | Res.Asst. Begüm Çimen |
| Dersin Kategorisi | Alanına Uygun Öğretim |
| Dersin Amacı | A lot of studies show that the engineers in working environments mostly use spreadsheet programs. Therefore, the scope of this course to explain the features of a spreadsheet software used in engineering. |
| Dersin İçeriği | Introduction of Spreadsheet softwares and MS-Excel, sharing Excel datas with others software, writing simple codes with Excel Macro programming language. |
| # | Ders Öğrenme Çıktıları | Öğretim Yöntemleri | Ölçme Yöntemleri |
|---|---|---|---|
| 1 | can use MS-Excel | Lecture, Question-Answer, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 2 | can use conditional formatting technique | Lecture, Question-Answer, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 3 | can use data verification technique | Lecture, Question-Answer, Drilland Practice, Motivations to Show, | Testing, Homework, Project / Design, |
| 4 | can use and search MS-Excel functions | Lecture, Question-Answer, Drilland Practice, Self Study, | Testing, Homework, Project / Design, |
| 5 | can write user defined functions | Lecture, Drilland Practice, Case Study, | Testing, Homework, Project / Design, |
| 6 | can write macro code in MS-Excel | Lecture, Drilland Practice, Motivations to Show, Group Study, Case Study, Project Based Learning, | Testing, Homework, Project / Design, |
| 7 | can intervene to a macro code that written in MS-Excel | Lecture, Discussion, Case Study, Lab / Workshop, Problem Solving, Project Based Learning, | Testing, Homework, Project / Design, |
| Hafta | Ders Konuları | Ön Hazırlık |
|---|---|---|
| 1 | Genaral information about Spreadsheet software | |
| 2 | Genaral information about Ms-Excel | |
| 3 | Fonctions in MS-Excel | |
| 4 | Conditional formatting, Naive Bayes technique | |
| 5 | Data Verification | |
| 6 | Visual Basic/Programming in MS-Excel | |
| 7 | Fundamentals of programming with Visual Basic - 1 | |
| 8 | Fundamentals of programming with Visual Basic - 2 | |
| 9 | User Defined Functions | |
| 10 | Fundamentals of Macro programming in MS-Excel | |
| 11 | Running of executable software with Macro codes | |
| 12 | Using of MS-Excel Functions with Macro codes | |
| 13 | Special procedures for Workbook and Worksheet | |
| 14 | Special macros for Workbook and Worksheet |
| Kaynaklar | |
|---|---|
| Ders Notu | www.gultekincagil.com |
| Ders Kaynakları | 1. VBA Makrolar, M. Kemal Korkmaz, |
| Değerlendirme Sistemi | |
|---|---|
| Yarıyıl Çalışmaları | Katkı Oranı |
| 1. Ödev | 100 |
| Toplam | 100 |
| 1. Final | 60 |
| 1. Yıl İçinin Başarıya | 40 |
| 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 | 3 | 48 |
| Mid-terms | 1 | 10 | 10 |
| Quiz | 1 | 10 | 10 |
| Assignment | 1 | 20 | 20 |
| Performance Task (Laboratory) | 1 | 15 | 15 |
| Toplam İş Yükü | 151 | ||
| Toplam İş Yükü / 25 (Saat) | 6,04 | ||
| Dersin AKTS Kredisi | 6 | ||