|
|
| TDOK2079 | Advanced Office Applications | 2+0+0 | ECTS:3 | | Year / Semester | Fall Semester | | Level of Course | Short Cycle | | Status | Elective | | Department | DEPARTMENT of MEDICAL SERVICES and TECHNIQUES | | Prerequisites and co-requisites | None | | Mode of Delivery | | | Contact Hours | 14 weeks - 2 hours of lectures per week | | Lecturer | Öğretim Görevlisi Nihat Burak ZİHNİ | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | To enable students to use the professional features of office software at a high level and to provide them with the knowledge and skills to use functions that will serve various purposes in the spreadsheet program. |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | With documents, text, paragraph tabs and columns
will be able to work. | 5 | 1,4, | | LO - 2 : | Know page formatting, working with styles, working with tables, and mail merge. | 5 | 1,4, | | LO - 3 : | Create tables based on single and two variables and convert text into columns. | 5 | 1,4, | | LO - 4 : | Understands creating a summary table report, creating a scenario, changing and deleting operations, and creating a scenario summary. | 5 | 1,4, | | CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome | | |
| Working with Advanced Documents, Working with Advanced Texts, Working with Advanced Tables, Mail Merge, Working with Database, Creating a Data Table, PivotTable Part 1, Pivottable Part 2, Importing External Data, Advanced Working with Level Functions |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Working with Advanced Documents | | | Week 2 | Working with Advanced Texts | | | Week 3 | Working with Advanced Tables | | | Week 4 | Mail Merge | | | Week 5 | Working with Database | | | Week 6 | Creating a Data Table | | | Week 7 | Pivottable Part 1 | | | Week 8 | Pivottable Part 2 | | | Week 9 | Midterm Exam | | | Week 10 | External Data Retrieval | | | Week 11 | Working with Advanced Functions | | | Week 12 | Working with Advanced Functions | | | Week 13 | Preliminary Preparation for the Practice Exam | | | Week 14 | Practice Exam | | | Week 15 | Practice Exam Evaluation | | | Week 16 | Final Exam | | | |
| 1 | Demirhan, Y., Çabukel, M., Yıldız Ö., Yıldız, U. 2020; İleri Ofis Uygulamaları, MEB Yayınları. | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | 29/11/2023 | 1 | 50 | | Practice | 14 | 04/12/2023 | 1 | 25 | | End-of-term exam | 16 | 25/01/2024 | 1 | 25 | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | Yüz yüze eğitim | 2 | 14 | 28 | | Sınıf dışı çalışma | 2 | 14 | 28 | | Arasınav için hazırlık | 2 | 1 | 2 | | Arasınav | 1 | 1 | 1 | | Uygulama | 1 | 14 | 14 | | Dönem sonu sınavı için hazırlık | 2 | 1 | 2 | | Dönem sonu sınavı | 1 | 1 | 1 | | Total work load | | | 76 |
|