OVS102 Office Applications II

3 ECTS - 2-1 Duration (T+A)- 2. Semester- 2.5 National Credit

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

Update Time: 13.08.2025 01:25