Course Name Code Semester T+U Hours Credit ECTS
Macro Programming In Excel SAU 567 0 1 + 0 2 2
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type OPTIONAL
Course Coordinator Dr.Öğr.Üyesi ÖMER FARUK SEYMEN
Course Lecturers
Course Assistants
Course Category General Education
Course Objective

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.

Course Content

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.

Development Goals
# Course Learning Outcomes Teaching Methods Assessment Methods
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,
Week Course Topics Preliminary Preparation
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
Resources
Course Notes
Course Resources
# Contribution of Course Learning Outcomes to Program Outcomes
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
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 70
1. Kısa Sınav 10
2. Kısa Sınav 10
3. Kısa Sınav 10
Total 100
1. Final 50
1. Yıl İçinin Başarıya 50
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
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
Total Workload 52
Total Workload / 25 (Hours) 2.08
dersAKTSKredisi 2