Information Package / Course Catalogue
Using Office Programs
Course Code: BYA141
Course Type: Required
Couse Group: Short Cycle (Associate's Degree)
Education Language: Turkish
Work Placement: N/Averi girişi yapılacaktır
Theory: 1
Prt.: 1
Credit: 2
Lab: 0
ECTS: 2
Objectives of the Course

To equip students with the skills to effectively use basic office software; to enable them to develop proficiency in document preparation, spreadsheet creation, presentation design, and basic data management.

Course Content

These courses aim to develop proficiency in the effective use of essential office software commonly used in office environments. The curriculum covers file and folder management; document creation and formatting using word processing software; data entry, basic formulas, functions, and chart creation in spreadsheet programs; presentation techniques; email and calendar management; and cloud-based file sharing and collaboration tools. Through hands-on exercises, the courses focus on building fundamental digital skills relevant to workplace needs.

Name of Lecturer(s)
Learning Outcomes
1.Uses office software effectively at a basic level.
2.Prepares documents in accordance with official correspondence rules.
3.Performs basic spreadsheet operations.
4.Creates charts and tables
5.Manages email and calendars.
6.It uses cloud-based collaboration tools.
Recommended or Required Reading
1.Hızlı Office Kodlab Yayın Dağıtım Mehmet Gülmez
2.Herkes için Excel Yazar: Cenk İltir
Weekly Detailed Course Contents
Week 1 - Theoretical & Practice
Introduction to office automation, overview of office software, cloud-based work environments, file and folder management
Week 2 - Theoretical & Practice
Introduction to word processing software, document creation, text editing, spell and grammar checking
Week 3 - Practice
Page layout, margins, heading styles, numbering, tables, and tabs
Week 4 - Theoretical & Practice
Creating visual objects, SmartArt, shapes, tables, headers and footers, footnotes, and bibliographies
Week 5 - Theoretical & Practice
Official correspondence rules; practices for preparing petitions, cover letters, meeting minutes, and reports.
Week 6 - Theoretical & Practice
Introduction to spreadsheet software, data entry, cell formatting, basic formulas
Week 7 - Theoretical & Practice
Basic functions (SUM, AVERAGE, MIN, MAX, IF, etc.), data sorting and filtering
Week 8 - Theoretical & Practice
Graph creation, page layout, print settings, and basic data analysis – Midterm Exam
Week 9 - Theoretical & Practice
Creating charts, page layout, print settings, and basic data analysis; introduction to presentation software, effective presentation design, and the use of themes and templates.
Week 10 - Theoretical & Practice
Adding images, tables, charts, and videos; animation and transition effects
Week 11 - Theoretical & Practice
Email management, calendar creation, meeting scheduling, and contact management
Week 12 - Theoretical & Practice
Cloud storage systems, online document sharing, collaboration applications
Week 13 - Theoretical & Practice
Use of office programs together (Word-Excel-PowerPoint integration), document sharing and printing.
Week 14 - Theoretical & Practice
Genel tekrar, uygulamalı proje sunumları ve dönem değerlendirmesi
Assessment Methods and Criteria
Type of AssessmentCountPercent
Quiz1%10
Practice Examination1%10
Midterm Examination1%20
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory20714
Lecture - Practice20714
Practice Examination1415
Quiz1415
Midterm Examination1516
Final Examination1516
TOTAL WORKLOAD (hours)50
Contribution of Learning Outcomes to Programme Outcomes
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
4
5
5
OÇ-2
2
4
5
5
OÇ-3
4
4
5
5
OÇ-4
4
2
1
5
5
OÇ-5
4
1
5
5
OÇ-6
5
5
5
Adnan Menderes University - Information Package / Course Catalogue
2026