Computer Office Programs II
Office Management and Executive Assistantship
Vocational School of Gazanfer Bilge
Short Cycle (Associate's Degree)
| Course Unit Title | Course Unit Code | Type of Course Unit | Level of Course Unit | Year of Study | Semester | ECTS Credits |
|---|---|---|---|---|---|---|
| Computer Office Programs II | BYP201 | Compulsory | Associate degree | 2 | Fall | 3 |
Name of Lecturer(s)
Prof. Dr. Kerem KÜÇÜK
Associate Prof. Dr. Aysen ŞİMŞEK KANDEMİR
Assistant Prof. Dr. Cengiz GÜNEY
Assistant Prof. Dr. Filiz SANAL ÇEVİK
Lecturer Ümmühan AKHİSAR
Lecturer Ümmühan MUTLU
Lecturer Tolga Anıl TOPDEMİR
Lecturer Aydoğan TÜRKBAL
Lecturer Kenan TÜRKERİ
Lecturer Esra YALÇIN
Lecturer Öznur AKTAŞ
Learning Outcomes of the Course Unit
1) Make spreadsheet and spreadsheet summarizing
1) Make spreadsheet and spreadsheet summarizing
2) Recognize the principles of the Excel.
2) Recognize the principles of the Excel.
3) Use the logical and mathematical functions.
3) Use the logical and mathematical functions.
4) Relate tables.
4) Relate tables.
5) Use the macro features.
5) Use the macro features.
6) Apply advanced mathematical formulas.
6) Apply advanced mathematical formulas.
7) Make tappropriate templates.
7) Make tappropriate templates.
Program Competencies-Learning Outcomes Relation
| Program Competencies | ||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | ||
| Learning Outcomes | ||||||||||||
| 1 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 1 | High | High | High | High | High | High | High | High | High | High | High | |
| 2 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 2 | High | High | High | High | High | High | High | High | High | High | High | |
| 3 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 3 | High | High | High | High | High | High | High | High | High | High | High | |
| 4 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 4 | High | High | High | High | No relation | No relation | No relation | No relation | No relation | No relation | High | |
| 5 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 5 | High | High | High | High | High | High | High | High | High | High | High | |
| 6 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 6 | No relation | No relation | No relation | High | High | High | High | High | High | High | High | |
| 7 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 7 | No relation | High | High | High | High | High | High | High | High | High | High | |
Mode of Delivery
Face to Face
Prerequisites and Co-Requisites
None
Recommended Optional Programme Components
Computer Office Programs I
Course Contents
This course provides students with the knowledge of electronic spreadsheet programs. Introduction to Excel application areas, cell, column and line concepts, addressing the identification and Paratii data entry methods, the practical use of automated total and basic math operations, sub-totals, row, column, paging works, works written form, filtering, grouping and leveling , formula entries, entries that formula, formulas, applications, scripts, graphics, and error checking.
Recommended or Required Reading
Planned Learning Activities and Teaching Methods
Assessment Methods and Criteria
Contribution of Midterm Examination to Course Grade |
40% |
|---|---|
Contribution of Final Examination to Course Grade |
60% |
Total |
100% |
Language of Instruction
Turkish
Work Placement(s)
Not Required