TR EN

INTEGRATED OFFICE APPLICATIONS PROGRAMME COURSE DESCRIPTION

Code Name of the Course Unit Semester In-Class Hours (T+P) Credit ECTS Credit
BGT153 INTEGRATED OFFICE APPLICATIONS 1 2 2 3

GENERAL INFORMATION

Language of Instruction : Turkish
Level of the Course Unit : ASSOCIATE DEGREE, TYY: + 5.Level, EQF-LLL: 5.Level, QF-EHEA: Short Cycle
Type of the Course : Compulsory
Mode of Delivery of the Course Unit -
Coordinator of the Course Unit Lecturer ÇİSEM YAŞAR
Instructor(s) of the Course Unit
Course Prerequisite No

OBJECTIVES AND CONTENTS

Objectives of the Course Unit: This course aims to develop the skills of students with useful tools that they can use in daily life, office life, and software teams.
Contents of the Course Unit: In this course, various applications that can be used in daily life such as e-mail, calendar, meeting, document editing, table preparation, and presentation preparation will be facilitated in a computer environment by using Microsoft Office and Google tools.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)

Can send individual or multiple e-mails
Can create scheduled or instant online meetings.
Can store using cloud systems.
Can prepare online or offline electronic documents.
Can prepare online or offline spreadsheets.
Can prepare online or offline electronic presentations.

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY

Week Preparatory Topics(Subjects) Method
1 - Introduction, internet services, internet browsers and settings. Explanation
2 Research Google Forms, calendar Explanation, application
3 Research Drive, spreadsheets, documents, slides Explanation, application
4 Research MS Word MS Word screen, Toolbars and features, Save, Security options Explanation, application
5 Research MS WORD Page Structure, Writing in Word, Font Properties, Format Painter, Paragraph Properties, Tabs, Borders and Shading, Columns, Bullets and Numbering Explanation, application
6 Research MS Word Inserting a table and table toolbar, Inserting a drawing object, Templates, Automatic correction options, Paste special, Find-Change-Go, Inserting clip art and pictures, using the picture toolbar Explanation, application
7 Research MS Excel - Introduction to Excel, Page and Cell Concept, Cursor Types, Page Tabs, Cut-Copy-Paste, Row and Column Operations, Formatting Explanation, application
8 - MID-TERM EXAM -
9 Research MS Excel - Getting to Know the Toolbars, Working with Files, Navigating the Worksheet, MS Excel - Operators, Creating Formulas, Formatting Cells Explanation, application
10 Research Creating Drawing Objects, Graphics Explanation, application
11 Research MS Powerpoint - Creating slides, Slide layout, Slide Design Explanation, application
12 Research Adding custom animations, sounds and starting slides Explanation, application
13 Research Master slide editing, slide view tools Explanation, application
14 Research New presentation preparation tools Explanation, application
15 Research Office application Explanation, application
16 - FINAL EXAM -
17 - FINAL EXAM -

SOURCE MATERIALS & RECOMMENDED READING

Şen Bilişim. (2024). Microsoft Office 365 Professional 2024.
Yandım, H. (2024). Applied Microsoft Office Programs Training from A to Z.
Teknoteleskop Publications. (2024). Excellence in Excel, Word, and Official Correspondence.
Microsoft Office Official Guides: ◦ Official documentation and user guides for Microsoft Word, Excel, and PowerPoint. Microsoft Office Guides
Google Workspace Training Resources: ◦ Official training content for Google Drive, Docs, Sheets, Slides, and Forms. Google Workspace Learning Center
Mastering Microsoft Office - Gini Courter
Google Workspace for Beginners - Paul McFedries

ASSESSMENT

Assessment & Grading of In-Term Activities Number of Activities Degree of Contribution (%) Description Examination Method
Mid-Term Exam 1 50
Final Exam 1 50
TOTAL 2 100
Level of Contribution
0 1 2 3 4 5

CONTRIBUTION OF THE COURSE UNIT TO THE PROGRAMME LEARNING OUTCOMES

WORKLOAD & ECTS CREDITS OF THE COURSE UNIT

Workload for Learning & Teaching Activities

Type of the Learning Activites Learning Activities (# of week) Duration (hours, h) Workload (h)
Lecture & In-Class Activities 14 2 28
Preliminary & Further Study 14 2 28
Land Surveying 0 0 0
Group Work 0 0 0
Laboratory 0 0 0
Reading 0 0 0
Assignment (Homework) 0 0 0
Project Work 0 0 0
Seminar 0 0 0
Internship 0 0 0
Technical Visit 0 0 0
Web Based Learning 0 0 0
Implementation/Application/Practice 0 0 0
Practice at a workplace 0 0 0
Occupational Activity 0 0 0
Social Activity 0 0 0
Thesis Work 0 0 0
Field Study 0 0 0
Report Writing 0 0 0
Final Exam 1 1 1
Preparation for the Final Exam 14 1 14
Mid-Term Exam 1 1 1
Preparation for the Mid-Term Exam 7 1 7
Short Exam 0 0 0
Preparation for the Short Exam 0 0 0
TOTAL 51 0 79
Total Workload of the Course Unit 79
Workload (h) / 25.5 3,1
ECTS Credits allocated for the Course Unit 3,0