OFFICE AUTOMATION SOFTWARE PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
BTP220	OFFICE AUTOMATION SOFTWARE	3	3	3	5

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 :	Elective
Mode of Delivery of the Course Unit	-
Coordinator of the Course Unit	Lecturer SENA NUR BENLİ
Instructor(s) of the Course Unit
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	It is aimed to gain competencies related to the use of office programs needed in every branch of information technologies.
Contents of the Course Unit:	The use of file, entry, insert, design, page layout, references, mailings, review and view menus in Ms Word program and the ribbons in each of these menus Use of files, entries, inserts, page layout, formulas, appearance and macros in Ms Excel program It covers the subjects of creating slides, slide layout, slide design, adding effects, slide transition, time adjustment, animation usage, video usage in Ms Powerpoint program.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
Recognizes the menus of Ms Office 2016 programs.
Uses Ms Word program effectively.
Uses Ms Excel program effectively.
Uses Ms Powerpoint program effectively.

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	-	MS Office 2016 general concepts	Lecture, Demonstration and Making
2	Doing research on the subject	Ms Word screen, toolbars and features, document open saving, text selection methods	Lecture, Demonstration and Making
3	Doing research on the subject	Ms Word tables, drawings, document formatting, page structure	Lecture, Demonstration and Making
4	Doing research on the subject	Ms Word table of contents, footnotes, quotations, bibliography, spelling, explanation,	Lecture, Demonstration and Making
5	Doing research on the subject	Ms Word autocorrect options, paste special, find-replace-go, view, window	Lecture, Demonstration and Making
6	Doing research on the subject	Ms Excel screen, functions and structure, selection method, cell addressing	Lecture, Demonstration and Making
7	Doing research on the subject	Ms Excel formula creation, data copy, formula menu	Lecture, Demonstration and Making
8	-	MID-TERM EXAM	-
9	Doing research on the subject	Ms Excel formula creation, data copy, formula menu	Lecture, Demonstration and Making
10	Doing research on the subject	Ms Excel creating spreadsheets, drawings, charts	Lecture, Demonstration and Making
11	Doing research on the subject	Ms Excel macro operations	Lecture, Demonstration and Making
12	Doing research on the subject	Ms Powerpoint screen, slide creation, slide layout, slide design	Lecture, Demonstration and Making
13	Doing research on the subject	Ms Powerpoint adding effects, slide transition, time adjustment	Lecture, Demonstration and Making
14	Doing research on the subject	Ms Powerpoint animation usage, video usage	Lecture, Demonstration and Making
15	Doing research on the subject	Ms Powerpoint presentation preparation	Lecture, Demonstration and Making
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

SOURCE MATERIALS & RECOMMENDED READING
OFFICE 2016, Bayram Yıldız, KODLAB Publications

ASSESSMENT
Assessment & Grading of In-Term Activities	Number of Activities	Degree of Contribution (%)	Description

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.					4
2	The basic vocational English terms on the computer knows.				3
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.				3

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

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

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.					4

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.						5

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.						5

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.					4

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)	14	2	28
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	14	2	28
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	1	8	8
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	1	6	6
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	60	0	128