TÜRKÇE
ENGLISH
Information
| Code | BYA155 |
| Name | Computerized Office Programs |
| Term | 2023-2024 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 | ||