TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| OFFICE TECHNOLOGIES AND DATA MANAGEMENT PR. | |
| Code | OVS101 |
| Name | Office Applications I |
| Term | 2025-2026 Academic Year |
| Semester | 1. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 4 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
This course aims to enable students to effectively use the most commonly used basic office software in business life.
Course Content
It includes basic and intermediate features of Microsoft Word, Microsoft Excel and Microsoft PowerPoint programs, as well as applications such as preparing text documents, creating tables and graphics, performing data analysis, designing presentations and integrating data between these programs.
Course Precondition
There are no prerequisites.
Resources
https://support.microsoft.com/tr-tr/word https://support.microsoft.com/tr-tr/excel https://support.microsoft.com/tr-tr/powerpoint
Notes
Lecture notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Can create basic and intermediate level documents using Microsoft Word |
| LO02 | In Word, you can enrich documents by adding tables, pictures, shapes, and other objects. |
| LO03 | Can use cell formatting and basic functions (Sum, Average, etc.) in Microsoft Excel. |
| LO04 | Can express data visually by creating charts in Excel. |
| LO05 | With Microsoft PowerPoint, you can design presentations by adding text, images, and shapes. |
| LO06 | By using theme, design and animation features in PowerPoint, you can make your presentations aesthetic and effective. |
| LO07 | Can organize and share the documents, tables and presentations he/she has prepared in a way that is suitable for business life. |
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. | |
| 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. | |
| 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. | |
| 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. | |
| 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 Introduction to Office Programs | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösteri |
| 2 | Word – Basic Document Operations | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 3 | Word – Page Layout and Formatting | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 4 | Word – Inserting Tables and Images | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 5 | Excel – Basic Data Operations | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 6 | Excel – Formulas and Basic Functions | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 7 | Excel – Charting and Visualization | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma, 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 | Excel – Intermediate Functions | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 10 | PowerPoint – Basic Presentation Preparation | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 11 | PowerPoint – Design and Layout | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Soru-Cevap, Anlatım, Gösterip Yaptırma |
| 12 | PowerPoint – Animations and Transitions | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 13 | Word – Excel – PowerPoint Integration | Preparation for the subject from the specified sources | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Alıştırma ve Uygulama |
| 14 | Term Project | Repetition of course contents | Öğretim Yöntemleri: Anlatım, Soru-Cevap |
| 15 | Term Project Presentation | Repetition of course contents | Öğretim Yöntemleri: Soru-Cevap, Tartışma |
| 16 | Term Exams | Repetition of topics from sources and lecture notes | |
| 17 | Term Exams | Repetition of topics from sources and lecture notes |