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