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 SENA NUR BENLİ
Instructor(s) of the Course Unit	Lecturer GÜL GÜLER BİNKANAT
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	Research	MS Excel - Getting to Know the Toolbars, Working with Files, Navigating the Worksheet, MS Excel - Operators, Creating Formulas, Formatting Cells	Explanation, application
9	Research	Creating Drawing Objects, Graphics	Explanation, application
10	-	MID-TERM EXAM	-
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		Classical Exam
Final Exam	1	50		Classical Exam
TOTAL	2	100

Level of Contribution
0	1	2	3	4	5

KNOWLEDGE
Theoretical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Required in the field of computer and information knows the term.						5
2	The basic vocational English terms on the computer knows.					4
3	Knowledge about the concept of information security.				3

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Concepts in the field of computer learning skills necessary to win.						5

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Know the functions of basic electrical and electronic components.					4

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	The ability to use different operating systems.				3
2	Self-installation performs the required software.						5

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Find simple software and hardware failures and fixes.					4
2	Digital information on a regular basis to maintain existing backup function performs.				3

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Independently in their field, learn and apply that learning.					4

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Human relations and communications know about and apply to be done.					4

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Self desired operating system builds and manages.						5

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