Faculty of Business and Management Sciences · Business Administration (English 30%) · Undergraduate
ECTS: 5 T+P+L: 0+3+0 Departmental Elective
Coordinator: Dr. Öğr. Üyesi Ömer GİZLİER
Course Objective
The course aims at providing a thorough introduction to the use of programming in Excel through macros. Students will be able to automate and streamline workflow using VBA procedures and modules.
Course Content
The course teaches how to build effective spreasheets using Excel VBA functions and formulas.
Required Resources
İleri Düzey Excel 2016, Ömer Bağcı, Seçkin-Bilgisayar, 8. Basım
Recommended Resources
İleri Seviye Excel 2019 Serdar Özbay SIFIRBİR YAYINLARI
Course Learning Outcomes
- Produce and enhance analytical spreadsheets.
- Build the models extensively using Excel built-in functions.
- Manage and summarize complex data.
Core Area Distribution
(34) Business and Administration%40 (48) Computing%60
Teaching Methods
ExpressionQuestion-AnswerExercise and PracticeExperiment - Test / Lab/ Workshop / Field Practice
Assessment & Evaluation
Testing (Essay / Tests: True-Falls, multiple-choice, short answer, matching)
ECTS / Workload
| Activity | Quantity | Duration (h) | Total Workload |
|---|---|---|---|
| Course Duration (Including Exam Week) | 16 | 3 | 48 |
| Out of Class Study Period | 16 | 4 | 64 |
| Midterm | 1 | 1 | 1 |
| Quiz | 0 | 0 | 0 |
| Assignment | 0 | 0 | 0 |
| Practice | 1 | 10 | 10 |
| Final | 1 | 1 | 1 |
Course Schedule
| Week | Subject | Preparation |
|---|---|---|
| 1 | Introduction to course | reading |
| 2 | VBA macros | reading |
| 3 | Excel Object Model | reading |
| 4 | VBA variables, data types | reading |
| 5 | VBA variables, data types | reading |
| 6 | VBA subprocedures | reading |
| 7 | Range objects | reading |
| 8 | Midterm | reading |
| 9 | Worksheet objects | reading |
| 10 | Excel events | reading |
| 11 | Interaction with Workbooks, Files | reading |
| 12 | Interactions with External Programs | reading |
| 13 | Interaction with User | reading |
| 14 | User Forms | reading |
| 15 | Web applications | reading |
| 16 | Final Sınavı | Final Sınavı |