| Ders Adı | Kodu | Yarıyıl | T+U Saat | Kredi | AKTS |
|---|---|---|---|---|---|
| Macro Programmıng In Excel | SAU 567 | 0 | 1 + 0 | 2 | 2 |
| Ön Koşul Dersleri | |
| Önerilen Seçmeli Dersler | |
| Dersin Dili | Türkçe |
| Dersin Seviyesi | Lisans |
| Dersin Türü | Seçmeli |
| Dersin Koordinatörü | Dr.Öğr.Üyesi ÖMER FARUK SEYMEN |
| Dersi Verenler | |
| Dersin Yardımcıları | |
| Dersin Kategorisi | Genel Eğitim |
| Dersin Amacı | Excel is widely used by businesses for analyzing numerical data and presenting these analyses visually through graphs. Using Excel, many mathematical and logical operations, such as maintaining archive records, performing accounting calculations, and preparing payrolls, can be carried out without requiring specialized expertise. To ensure these processes are fast, model-based, and controlled, the Visual Basic for Applications (VBA) programming language was developed for Excel and other Microsoft Office Applications. This programming language makes it possible to prepare applications by learning only basic control codes. The “Macro Programming in Excel” course will provide you with the necessary foundation to develop your own applications. |
| Dersin İçeriği | This course will cover the concept of functions in Excel and the most commonly used functions, the macro recording process, recognizing objects offered in VBA, learning basic algorithms and program codes, creating user forms in Excel, and developing sample applications. |
| Kalkınma Amaçları |
|---|
|
| # | Ders Öğrenme Çıktıları | Öğretim Yöntemleri | Ölçme Yöntemleri |
|---|---|---|---|
| 1 | Knowledge of Visual Basic Applications within Excel | Observation, Problem Solving, | Written Exams (Short and Long Answer), |
| 2 | Appliying application examples of applications that can be developed in businesses | Discussion, Question-Answer, Role Playing, | |
| 3 | Recognize objects in user interface design | Discussion, Question-Answer, |
| Hafta | Ders Konuları | Ön Hazırlık |
|---|---|---|
| 1 | Reasons for using macros, creating, viewing, and updating macros | |
| 2 | Reference modes and security in macros | |
| 3 | Understanding the Visual Basic for Applications (VBA) Window, | |
| 4 | Getting started with VBA Programming | |
| 5 | VBA variables | |
| 6 | VBA selections | |
| 7 | VBA loops | |
| 8 | VBA arrays | |
| 9 | Creating interface designs with user forms | |
| 10 | Creating interface designs with user forms | |
| 11 | Recognizing different objects in interfaces | |
| 12 | Recognizing object-based events | |
| 13 | Working with images and graphics in interfaces | |
| 14 | Creating animated presentations using timers |
| Kaynaklar | |
|---|---|
| Ders Notu | |
| Ders Kaynakları | |
| # | Ders Öğrenme Çıktılarının Program Çıktılarına Katkısı |
|---|---|
| 1 | Knowledge of Visual Basic Applications within Excel |
| 2 | Appliying application examples of applications that can be developed in businesses |
| 3 | Recognize objects in user interface design |
| Değerlendirme Sistemi | |
|---|---|
| Yarıyıl Çalışmaları | Katkı Oranı |
| 1. Ara Sınav | 70 |
| 1. Kısa Sınav | 10 |
| 2. Kısa Sınav | 10 |
| 3. Kısa Sınav | 10 |
| Toplam | 100 |
| 1. Final | 50 |
| 1. Yıl İçinin Başarıya | 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 | 1 | 16 |
| Hours for off-the-classroom study (Pre-study, practice) | 16 | 1 | 16 |
| Mid-terms | 1 | 2 | 2 |
| Quiz | 1 | 1 | 1 |
| Final examination | 1 | 1 | 1 |
| Performance Task (Laboratory) | 4 | 4 | 16 |
| Toplam İş Yükü | 52 | ||
| Toplam İş Yükü / 25 (Saat) | 2,08 | ||
| dersAKTSKredisi | 2 | ||