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