Information Package / Course Catalogue
Office Programs II
Course Code: KPO152
Course Type: Area Elective
Couse Group: Short Cycle (Associate's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 1
Prt.: 1
Credit: 2
Lab: 0
ECTS: 3
Objectives of the Course

To create and develop the ability to use office programs in the student

Course Content

Ability to create tables, to make mathematical calculations on tables, to create and manage databases, to create multiple reports, to make text files and table files harmonize

Name of Lecturer(s)
Learning Outcomes
1.Prepare presentation
2.Can build a database
3.Can make spreadsheet
4.Can make calculation
5.Use basic formulas
Recommended or Required Reading
2.BAYRAM, Yıldız (2010) "Office 2010", Kodlab Yayın
Weekly Detailed Course Contents
Week 1 - Theoretical
Getting to know presentation devices and software
Week 1 - Practice
Getting to know presentation devices and software
Week 1 - Preparation Work
Related chapters in the course book
Week 2 - Theoretical
Prepare a presentations
Week 2 - Practice
Prepare a presentations
Week 2 - Preparation Work
Related chapters in the course book
Week 3 - Theoretical
Presentation structure Page settings Insert page number Insert top / bottom information
Week 3 - Practice
Presentation structure Page settings Insert page number Insert top / bottom information
Week 3 - Preparation Work
Related chapters in the course book
Week 4 - Theoretical
Add a presentation structure Top Page settings page numbers / insert footer
Week 4 - Practice
Add a presentation structure Top Page settings page numbers / insert footer
Week 4 - Preparation Work
Related chapters in the course book
Week 5 - Theoretical
Image Graphic Table Object operations Audio Video
Week 5 - Practice
Image Graphic Table Object operations Audio Video
Week 5 - Preparation Work
Related chapters in the course book
Week 6 - Theoretical
Animation layouts, Presentation demonstration settings, Print preview
Week 6 - Practice
Animation layouts, Presentation demonstration settings, Print preview
Week 6 - Preparation Work
Related chapters in the course book
Week 7 - Theoretical
Electronic Spreadsheet
Week 7 - Practice
Electronic spreadsheet
Week 7 - Preparation Work
Related chapters in the course book
Week 8 - Theoretical
Provide fast access to data
Week 8 - Practice
Provide fast access to data
Week 8 - Preparation Work
Related chapters in the course book
Week 9 - Preparation Work
Related chapters in the course book
Week 9 - Theoretical & Practice
Row / column width settings Border Color / Fill Text formatting options (Midterm)
Week 10 - Theoretical
Row / column width settings Border Color / Fill Text formatting options
Week 10 - Practice
Row / column width settings Border Color / Fill Text formatting options
Week 10 - Preparation Work
Related chapters in the course book
Week 11 - Theoretical
Data Filtering, Conditional Formatting, Charting
Week 11 - Practice
Data Filtering, Conditional Formatting, Charting
Week 11 - Preparation Work
Related chapters in the course book
Week 12 - Theoretical
Formulas and Functions
Week 12 - Practice
Formulas and Functions
Week 12 - Preparation Work
Related chapters in the course book
Week 13 - Theoretical
Formulas and Functions
Week 13 - Practice
Formulas and Functions
Week 13 - Preparation Work
Related chapters in the course book
Week 14 - Theoretical
Graphics
Week 14 - Practice
Graphics
Week 14 - Preparation Work
Related chapters in the course book
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory141128
Lecture - Practice141128
Midterm Examination110010
Final Examination110010
TOTAL WORKLOAD (hours)76
Contribution of Learning Outcomes to Programme Outcomes
PÇ-1
PÇ-2
PÇ-3
PÇ-4
PÇ-5
PÇ-6
PÇ-7
OÇ-1
2
2
1
4
2
2
5
OÇ-2
2
2
1
4
2
1
4
OÇ-3
2
2
1
3
2
1
4
OÇ-4
5
4
5
3
3
3
2
OÇ-5
5
4
4
4
3
3
3
Adnan Menderes University - Information Package / Course Catalogue
2026