TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| OFFICE TECHNOLOGIES AND DATA MANAGEMENT PR. | |
| Code | OVS102 |
| Name | Office Applications II |
| Term | 2025-2026 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 2.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 course aims to develop data analysis, document management, and professional presentation skills using advanced features in Excel, Word, and PowerPoint. Additionally, participants are expected to gain competence in automation, data visualization, and office application integration.
Course Content
This course aims to develop data analysis, automation, and professional document and presentation skills using advanced features in Excel, Word, and PowerPoint. Throughout the program, participants will practice complex functions, macros, data visualization, and corporate presentation techniques.
Course Precondition
None
Resources
2018, Hasan Cebi Bal, Computer and Internet Usage, Ekin Bookstore Publications, ISBN: 9786053277354
Notes
Presentations and notes prepared in computer environment
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Uses advanced formulas, functions, PivotTables, Power Query and VBA in Excel. |
| LO02 | It cleans, transforms and visualizes large data sets. |
| LO03 | In Word, it uses styles, table of contents, field code, and mail merge. |
| LO04 | Implement template, form field, bibliography, and document comparison in Word. |
| LO05 | In PowerPoint, a slide master adds animation, multimedia, and interactive content. |
| LO06 | Establishes data connections between Excel, Word and PowerPoint. |
| LO07 | Automates business processes with office applications. |
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. | 5 |
| PLO02 | Bilgi - Kuramsal, Olgusal | Knows problem solving methods and techniques related to Office Technologies and Data Management. | 4 |
| 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. | 3 |
| 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. | |
| 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. | |
| PLO12 | Yetkinlikler - Alana Özgü Yetkinlik | By following the developments on the field of the profession,may point to a more advanced level. | 3 |
| 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 | Excel Advanced Fundamentals | Having the course workbook | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 2 | Advanced Formulas and Functions I | The course workbook related topics | Öğretim Yöntemleri: Anlatım, Gösteri |
| 3 | Advanced Formulas and Functions II | The course workbook related topics | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 4 | PivotTable and PivotChart | The course workbook related topics | Öğretim Yöntemleri: Alıştırma ve Uygulama, Gösterip Yaptırma |
| 5 | Data Analysis and Power Query | The course workbook related topics | Öğretim Yöntemleri: Gösterip Yaptırma, Alıştırma ve Uygulama |
| 6 | Introduction to Excel Macros and VBA | The course workbook related topics | Öğretim Yöntemleri: Alıştırma ve Uygulama, Gösterip Yaptırma |
| 7 | Excel Advanced Project Examples | The course workbook related topics | Öğretim Yöntemleri: Alıştırma ve Uygulama, Gösterip Yaptırma |
| 8 | Mid-Term Exam | Studying for exam | Ölçme Yöntemleri: Yazılı Sınav |
| 9 | Word Advanced Fundamentals | The course workbook related topics | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 10 | Word Advanced Tools | The course workbook related topics | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 11 | Word Automation | The course workbook related topics | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 12 | PowerPoint Advanced Fundamentals | The course workbook related topics | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 13 | PowerPoint Advanced Design | The course workbook related topics | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 14 | PowerPoint Presentation Strategies | The course workbook related topics | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 15 | Final Project Presentation | The course workbook related topics | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 16 | Term Exams | Preparing for the exam from lecture notes and related resources | Ölçme Yöntemleri: Yazılı Sınav |
| 17 | Term Exams | Preparing for the exam from lecture notes and related resources | Ö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 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 2 | 28 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 1 | 3 | 3 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 1 | 1 |
| Final Exam | 1 | 1 | 1 |
| Total Workload (Hour) | 75 | ||
| Total Workload / 25 (h) | 3,00 | ||
| ECTS | 3 ECTS | ||