TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| OFFICE TECHNOLOGIES AND DATA MANAGEMENT PR. | |
| Code | OVS213 |
| Name | Advanced Office Automation Systems |
| Term | 2026-2027 Academic Year |
| Semester | 3. Semester |
| Duration (T+A) | 1-1 (T-A) (17 Week) |
| ECTS | 2 ECTS |
| National Credit | 1.5 National Credit |
| Teaching Language | Türkçe |
| Level | Belirsiz |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör. Ahmet BOZ |
| Course Instructor |
The current term course schedule has not been prepared yet.
|
Course Goal / Objective
The aim of this course is to equip students with the ability to effectively and efficiently use advanced office software. Students develop professional skills in word processing, spreadsheets, presentations, data analysis, and office automation tools to manage business processes in a digital environment. They also gain practical knowledge of productivity tools and integration techniques.
Course Content
This course covers the effective use of advanced office software. Students learn to create professional documents using word processing, spreadsheets, presentation tools, and data analysis applications. They also gain skills in managing business processes more efficiently in a digital environment using office automation systems.
Course Precondition
none
Resources
Works such as "Office Automation: An Essential Management Strategy" (Curran & Mitchell) are included. There are also practical books that comprehensively explain Microsoft Office applications (Word, Excel, PowerPoint).
Notes
Microsoft Learn, YouTube training channels, and interactive e-learning for office software.
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Explains the fundamental concepts of office automation systems. |
| LO02 | Prepares professional documents using word processing software. |
| LO03 | Performs data analysis using spreadsheet software (e.g., Excel). |
| LO04 | Creates effective and visual presentations using presentation software. |
| LO05 | Prepares charts and reports using data visualization tools. |
| LO06 | Applies template and formatting techniques in office software. |
| LO07 | Integrates data between different office applications. |
| LO08 | Improves business processes using digital office tools efficiently. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Have basic knowledge and concepts about Office Technologies and Data Management. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Knows problem solving methods and techniques related to Office Technologies and Data Management. | 5 |
| PLO03 | Beceriler - Bilişsel, Uygulamalı | Performs applications with basic knowledge and concepts in the field of Office Technologies and Data Management. | |
| PLO04 | Beceriler - Bilişsel, Uygulamalı | Has the ability to use the theoretical and practical knowledge acquired in the field of Office Technologies and Data Management. | |
| PLO05 | Beceriler - Bilişsel, Uygulamalı | Explains and evaluates the basic knowledge and concepts on Office Technologies and Data Management. | |
| PLO06 | Yetkinlikler - Öğrenme Yetkinliği | Identifies problems by using basic knowledge and skills in their field. | |
| PLO07 | Yetkinlikler - Alana Özgü Yetkinlik | Analyze problems and develop solutions in the area. | |
| PLO08 | Bilgi - Kuramsal, Olgusal | Explains designs and applications related to Office Technologies and Data Management to subordinates and superiors as necessary. | 5 |
| PLO09 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | In the framework given at the basic level, you can function and take responsibility independently of the issues related to the field given to you. | |
| PLO10 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Basic skills and knowledge of the area should be able to transfer effectively through written and oral communication. | |
| PLO11 | Yetkinlikler - Öğrenme Yetkinliği | Knowledge and skills to critically evaluate own learning and identify needs. | 4 |
| PLO12 | Yetkinlikler - Alana Özgü Yetkinlik | By following the developments on the field of the profession,may point to a more advanced level. | |
| PLO13 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | A1-A2-level Foreign Language(English) knows,can communicate in the foreign language relevant to the profession | |
| PLO14 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Basic computer operating systems,Office applications, and knows how to use the keyboard. | |
| PLO15 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | In accordance with the rules of Turkish language,written and oral communication effectively may establish. | |
| PLO16 | Bilgi - Kuramsal, Olgusal | Have sufficient awareness about Ataturk´s principles and revolutions. | 5 |
| PLO17 | Beceriler - Bilişsel, Uygulamalı | Professional, ethical, scientific and social values | |
| PLO18 | Yetkinlikler - Alana Özgü Yetkinlik | Global and social values within the framework of occupational health,safety and environmental is aware of the value. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Course introduction and basics of office automation | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 2 | General structure of office software | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 3 | Introduction to word processing | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 4 | Creating and editing documents in Word | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 5 | Introduction to Excel and basic operations | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 6 | Excel formulas and functions | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 7 | Data analysis and chart creation | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 8 | Mid-Term Exam | Repetition of topics from sources and lecture notes | Ölçme Yöntemleri: Yazılı Sınav |
| 9 | Practice work (Word + Excel) | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Grup Çalışması, Örnek Olay |
| 10 | Introduction to PowerPoint | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 11 | Presentation design and visual elements | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 12 | Data visualization techniques | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 13 | Data transfer between office programs | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Soru-Cevap, Gösteri |
| 14 | Applied project work | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama, Grup Çalışması |
| 15 | Final project presentation and review | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 16 | Term Exams | Repetition of topics from sources and lecture notes | Ölçme Yöntemleri: Yazılı Sınav |
| 17 | Term Exams | Repetition of topics from sources and lecture notes | Ölçme Yöntemleri: Yazılı Sınav |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 2 | 28 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 2 | 28 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 0 | 0 | 0 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 1 | 1 |
| Final Exam | 1 | 1 | 1 |
| Total Workload (Hour) | 58 | ||
| Total Workload / 25 (h) | 2,32 | ||
| ECTS | 2 ECTS | ||