BYA155 Computerized Office Programs

5 ECTS - 2-1 Duration (T+A)- 1. Semester- 2.5 National Credit

Information

Code BYA155
Name Computerized Office Programs
Term 2024-2025 Academic Year
Semester 1. Semester
Duration (T+A) 2-1 (T-A) (17 Week)
ECTS 5 ECTS
National Credit 2.5 National Credit
Teaching Language Türkçe
Level Ön Lisans Dersi
Type Normal
Mode of study Yüz Yüze Öğretim
Catalog Information Coordinator Öğr. Gör.Dr. ÜNAL BALCI
Course Instructor Öğr. Gör.Dr. ÜNAL BALCI (A Group) (Ins. in Charge)


Course Goal / Objective

Aim of this course to introduce the concepts of computer hardware and operating system and MS Office applications to provide a basic level of knowledge and skills to use.

Course Content

This course includes following subjects. Introduction Basic Concepts and Operating Systems, Computer peripherals, Word Processors (Word), Spreadsheet program (Excel), Presentation (Power Point).

Course Precondition

There are no prerequisites.

Resources

1. Cukurova University Department of Informatics Computer Lecture Notes 2. Ömer BAĞCI, Computer B for Beginners, Seçkin Publishing House, 2010.

Notes

Lecturer presentation and lecture notes


Course Learning Outcomes

Order Course Learning Outcomes
LO01 To arrange the documents and writings, which are used in daily life, in the word activity programme and make the editing and corrections
LO02 To make arrangement and printing activities of the tables and business which are used in the work life
LO03 To be able to use logical and mathematical functions in MS Excel program
LO04 To add figure, shape, object and grafic the documents and save them in the magnetic media


Relation with Program Learning Outcome

Order Type Program Learning Outcomes Level
PLO01 Bilgi - Kuramsal, Olgusal Defines the basic concepts and principles of Office Management and Executive Assistantship.
PLO02 Bilgi - Kuramsal, Olgusal Collects, analyzes and evaluates the data necessary for the solution of the problems encountered in the Office Management and Executive Assistant profession.
PLO03 Bilgi - Kuramsal, Olgusal Follows and evaluates the developments in the field of Office Management and Executive Assistant by using scientific methods and techniques.
PLO04 Bilgi - Kuramsal, Olgusal Have basic knowledge of social, economic, cultural and legal issues.
PLO05 Bilgi - Kuramsal, Olgusal Gains information about the supervision and evaluation of the employees working under her in the offices.
PLO06 Bilgi - Kuramsal, Olgusal Explains the information about the use of technology in offices. 4
PLO07 Bilgi - Kuramsal, Olgusal Explains the services that can be carried out in the offices related to the field of Office Management and Executive Assistant and the related procedures.
PLO08 Bilgi - Kuramsal, Olgusal Develops solution suggestions by using theoretical knowledge and skills, and general problems encountered in the field of Office Management and Executive Assistantship.
PLO09 Bilgi - Kuramsal, Olgusal It can collect the necessary information with the organization foreseen by the manager and present it in the form of a report. 5
PLO10 Bilgi - Kuramsal, Olgusal He/She can use office technologies effectively. 5
PLO11 Bilgi - Kuramsal, Olgusal He/She can make time and protocol arrangements for the organizations stipulated by the manager.
PLO12 Bilgi - Kuramsal, Olgusal He/She can create appropriate environments by taking into account the social and cultural differences of individuals and their special needs related to their fields.
PLO13 Bilgi - Kuramsal, Olgusal He/She can apply methods and techniques that can keep the documents and recording processes under control for the manager.
PLO14 Bilgi - Kuramsal, Olgusal He/She can take responsibility individually and as a group in solving the problems encountered.
PLO15 Beceriler - Bilişsel, Uygulamalı By gaining self-learning ability, he/she can evaluate the information he/she has learned with a critical approach.
PLO16 Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği He/She can communicate effectively and healthily with the manager and the internal and external environment of the organization.
PLO17 Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği He/She can use the software and hardware required by his/her profession together with basic computer usage knowledge. 5
PLO18 Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği Have sufficient foreign language knowledge in the field of Office Management and Executive Assistant.
PLO19 Yetkinlikler - Öğrenme Yetkinliği Have the necessary knowledge and awareness of social responsibility, ethical values, social security rights, occupational safety, worker health and environmental protection related to the field.


Week Plan

Week Topic Preparation Methods
1 Recognition of the basic concepts about computer Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
2 Recognition interface of the Windows operating system, using desktop environment, to adjust the description and characteristics objects in the desktop and task bar Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
3 Using the Start menu options, To make transactions select the folders and files associated with creating, moving, copying, etc. Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
4 Word introduction, recognize the Word screen, File operations: opening, closing, saving, save as, page structure. Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
5 Edit menu operations, View menu operations, Format menu operations Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
6 Tools menu operations, Table menu operations Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
7 Excel introduction, recognize the Excel screen, File operations: opening, closing, saving, save as. Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
8 Mid-Term Exam Ölçme Yöntemleri:
Yazılı Sınav
9 Data entering, Data entry techniques, Formula creation, operators, Cell applications Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
10 Functions I Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
11 Functions II Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
12 Managing workbooks, Data Management: List creation, ranking, filtering, graphic creation Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
13 Recognize the PowerPoint screen, menu operations, creating a new presentation, to work on the master slides in the PowerPoint program Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
14 Working with different views on slides, slide adding, replication, file taking the slide, select and delete operations Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
15 Adding pictures, audio and video clips, custom animation addition, the slide show to be displayed Lecture notes Öğretim Yöntemleri:
Anlatım, Gösteri
16 Term Exams Ölçme Yöntemleri:
Yazılı Sınav
17 Term Exams Ölçme Yöntemleri:
Yazılı Sınav


Student Workload - ECTS

Works Number Time (Hour) Workload (Hour)
Course Related Works
Class Time (Exam weeks are excluded) 14 3 42
Out of Class Study (Preliminary Work, Practice) 14 3 42
Assesment Related Works
Homeworks, Projects, Others 1 2 2
Mid-term Exams (Written, Oral, etc.) 1 12 12
Final Exam 1 18 18
Total Workload (Hour) 116
Total Workload / 25 (h) 4,64
ECTS 5 ECTS

Update Time: 13.05.2024 09:22