Information Package / Course Catalogue
| Course Code | : BYA188 |
| Course Type | : Area Elective |
| Couse Group | : Short Cycle (Associate's Degree) |
| Education Language | : Turkish |
| Work Placement | : N/A |
| Theory | : 1 |
| Prt. | : 1 |
| Credit | : 2 |
| Lab | : 0 |
| ECTS | : 3 |
To equip students with skills in advanced office applications, data analysis, automation, professional document design, and the management of administrative office processes in a digital environment.
This course aims to enhance students' foundational knowledge of office software, enabling them to use these tools at a professional level. The curriculum covers advanced document design, template creation, mail merge operations, advanced spreadsheet functions, data analysis, pivot tables, conditional formatting, basic macro applications, professional presentation preparation, corporate reporting, email and task management, and cloud-based collaboration tools. Through hands-on activities, the course seeks to equip students with the skills to manage digital office processes effectively, efficiently, and professionally.
| 1. | Designs professional documents |
| 2. | Uses advanced spreadsheet functions. |
| 3. | Performs data analysis using pivot tables and charts. |
| 4. | Prepares corporate reports and management presentations. |
| 5. | Plans and manages digital office processes. |
| 6. | Automates office tasks using macros at a basic level. |
| 7. | Adapting to the digital transformation in today's business world, they utilize AI-powered office tools (such as Copilot and ChatGPT) as assistants for data analysis, formula writing, and content creation. |
| 1. | Hızlı Office Kodlab Yayın Dağıtım Mehmet Gülmez |
| 2. | Öğretim Elemanı Tarafından Hazırlanan Not ve Dökümanlar |
| Type of Assessment | Count | Percent |
|---|---|---|
| Practice | 1 | %10 |
| Quiz | 1 | %10 |
| Midterm Examination | 1 | %20 |
| Final Examination | 1 | %60 |
| Activities | Count | Preparation | Time | Total Work Load (hours) |
|---|---|---|---|---|
| Lecture - Theory | 14 | 0 | 1 | 14 |
| Lecture - Practice | 14 | 0 | 1 | 14 |
| Individual Work | 5 | 0 | 5 | 25 |
| Practice Examination | 1 | 4 | 1 | 5 |
| Quiz | 1 | 4 | 1 | 5 |
| Midterm Examination | 1 | 5 | 1 | 6 |
| Final Examination | 1 | 5 | 1 | 6 |
| TOTAL WORKLOAD (hours) | 75 | |||
PÇ-1 | PÇ-2 | PÇ-3 | PÇ-4 | PÇ-5 | PÇ-6 | PÇ-7 | PÇ-8 | PÇ-9 | PÇ-10 | PÇ-11 | PÇ-12 | PÇ-13 | PÇ-14 | PÇ-15 | PÇ-16 | PÇ-17 | PÇ-18 | PÇ-19 | |
OÇ-1 | 5 | 3 | 5 | 5 | 5 | ||||||||||||||
OÇ-2 | 5 | 2 | 5 | 5 | |||||||||||||||
OÇ-3 | 5 | 3 | 5 | 5 | 4 | ||||||||||||||
OÇ-4 | 5 | 3 | 3 | 5 | 5 | 4 | |||||||||||||
OÇ-5 | 5 | 3 | 3 | 5 | 5 | ||||||||||||||
OÇ-6 | 5 | 5 | 5 | ||||||||||||||||
OÇ-7 | 5 | 4 | 3 | 4 | 5 | 5 | 3 | ||||||||||||