COURSE UNIT TITLE

: ADVANCED OFFICE APLICATIONS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
MSH 0180 ADVANCED OFFICE APLICATIONS ELECTIVE 2 2 0 4

Offered By

Efes Vocational School

Level of Course Unit

Short Cycle Programmes (Associate's Degree)

Course Coordinator

DOCTOR HAKAN SÖNMEZ

Offered to

Cultural Heritage and Tourism
Tourism and Hotel Management
Civil Aviation and Cabin Services
Civil Aviation Transportation Management
Food Technology

Course Objective

The aim of this lesson is to provide students with the necessary high level competencies to use office programs effectively and to develop their solution generating skills.

Learning Outcomes of the Course Unit

1   Learn to use the features of word processor, spreadsheet and presentation preparation software at a professional level.
2   Gains the ability to create understandable and secure tables with advanced formulas and data analysis tools.
3   Learns powerful and impressive presentation preparation techniques.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Microsoft Word: Advanced text and paragraph editing, document control, formatting, version management and text operations, ensuring document accuracy, working with objects and tables, adding graphical objects.
2 Microsoft Word: Advanced text and paragraph editing, document control, formatting, version management and text operations, ensuring document accuracy, working with objects and tables, adding graphical objects.
3 Microsoft Word: Advanced text and paragraph editing, document control, formatting, version management and text operations, ensuring document accuracy, working with objects and tables, adding graphical objects.
4 Microsoft Excel: Moving fast on the document and excel shortcuts, time-saving excel techniques in data entry, innovations in excel and general evaluation, controlling worksheets, organizing, protecting and analyzing data, conditional formatting, sorting and filtering data.
5 Microsoft Excel: Moving fast on the document and excel shortcuts, time-saving excel techniques in data entry, innovations in excel and general evaluation, controlling worksheets, organizing, protecting and analyzing data, conditional formatting, sorting and filtering data.
6 Microsoft Excel: Moving fast on the document and excel shortcuts, time-saving excel techniques in data entry, innovations in excel and general evaluation, controlling worksheets, organizing, protecting and analyzing data, conditional formatting, sorting and filtering data.
7 Microsoft Excel: Combining data tables, validating data input, using advanced functions and functions, advanced graphic options, formatting graphic objects, evaluating with multiple pages, evaluating the situation with target searches and scenarios, reference usage.
8 Mid-Term Exam
9 Microsoft Excel: Combining data tables, validating data input, using advanced functions and functions, advanced graphic options, formatting graphic objects, evaluating with multiple pages, evaluating the situation with target searches and scenarios, reference usage.
10 Microsoft Excel: Working with Solver, designing customizable user forms, developing applications with user forms, debugging methods, data grouping, integration and pivot table, pivot chart creation, macro usage, use of visual basic form controls.
11 Microsoft Excel: Working with Solver, designing customizable user forms, developing applications with user forms, debugging methods, data grouping, integration and pivot table, pivot chart creation, macro usage, use of visual basic form controls.
12 Microsoft Excel: Working with Solver, designing customizable user forms, developing applications with user forms, debugging methods, data grouping, integration and pivot table, pivot chart creation, macro usage, use of visual basic form controls.
13 Microsoft Powerpoint: Fast and effective presentation preparation techniques, preparation and planning of the presentation, slide design, animations and transitions, strengthening the narration, reproducing and editing presentations, managing.
14 Microsoft Powerpoint: Editing outlines, working with graphics, adding wordart-smartart, preparing templates, editing with master slides, customizing powerpoint program, learning shortcuts.
15 Microsoft Powerpoint: Editing outlines, working with graphics, adding wordart-smartart, preparing templates, editing with master slides, customizing powerpoint program, learning shortcuts.
16 Final Exam

Recomended or Required Reading

Textbook:
1) Microsoft Office 2016, (2016), Cenk Iltir, Abaküs Kitapevi.

Supplementary Book(s):
1)Ileri Düzey Excel 2019 Veri Analizi Formüller ve Işlevler Dashboard Raporlama, Ömer Bağcı,Seçkin Yayıncılık.
2)Excel Fonksiyonları ve Iş Dünyası Uygulamaları, (2016), Doç. Dr. Seyhan Nişel, Çağlayan Kitabevi.
3)Excel'de Program Yazma, (2017), Ramazan Baykal,Ekin Basım Yayınevi.
4)Word ve Excel için Otomasyon Çözümleri, Dr. Hürol Aslan,(2018), Kodlab Yayın Dağıtım.
5)Excel'de Makrolar: VBA Excel 2019, (2019), Cenk Iltir, Seçkin Yayıncılık.
6)Herkes Için 101 Excel Makro, (2016), Okan Emir, Pusula Yayıncılık

Planned Learning Activities and Teaching Methods

Face to face expression technique in the classroom, discussion and problem solving, reading research, classroom applications.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 FIN FINAL EXAM
3 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.50 + FIN * 0.50
4 RST RESIT
5 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.50 + RST * 0.50


Further Notes About Assessment Methods

None

Assessment Criteria

There will be held on two in class exams; midterm exam and final exam during the semester.
Grades: 50 % Midterm Exam, 50 % Final Exam, 50 % Make-up Exam.

Language of Instruction

Turkish

Course Policies and Rules

1) Attending at least 70 percent of lectures and fulfill the requirements of the course are mandatory.
2) Plagiarism of any type will result in disciplinary action.

Contact Details for the Lecturer(s)

hakan.sonmez@deu.edu.tr

Office Hours

Monday, 13:00 - 16:30, Ground Floor, No: Z-08, Efes Vocational School, Selçuk / IZMIR.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 12 3 36
Preparation about subject 12 1 12
Preparation for midterm exam 1 12 12
Preparation for final exam 1 12 12
Preparations before/after weekly lectures 10 1 10
Reading 2 1 2
In-class practices 12 2 24
Midterm 1 2 2
Final 1 2 2
TOTAL WORKLOAD (hours) 112

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13PO.14PO.15PO.16PO.17PO.18PO.19PO.20
LO.11
LO.211
LO.311