TÜRKÇE
ENGLISH
Information
| Code | BLP155 |
| Name | OFFICE SOFTWARE |
| Term | 2022-2023 Academic Year |
| Semester | 1. Semester |
| Duration (T+A) | 3-1 (T-A) (17 Week) |
| ECTS | 7 ECTS |
| National Credit | 3.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. CELALETTIN AYDIN |
| Course Instructor |
Öğr. Gör. CELALETTIN AYDIN
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
This course aims to provide the students with competencies related to the use of office programs needed in every branch of information technology.
Course Content
Word, Excel, and PowerPoint applications from Microsoft Office software
Course Precondition
Knowledge of office software.
Resources
Information Technologies, Word Processor (482BK0012) Information Technologies, Spreadsheet (482BK0013) Information Technologies, Presentation Preparation (482BK0014) Information Technologies, Internet and E-Mail Management (482BK0015)
Notes
Microsoft Office: Word Excel Powerpoint Outlook Access (Publisher: Compass Publishing)
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Being able to set up and adjust the necessary programs for office applications; |
| LO02 | Using word processing programs; |
| LO03 | To be able to prepare necessary documents; |
| LO04 | Be able to create tables and charts; |
| LO05 | Perform data analysis; |
| LO06 | Use graphic drawings. To be able to prepare more effective documents; |
| LO07 | Use prefabricated functions. Automatic calculations; |
| LO08 | Prepare presentations with text, picture, audio and video content; |
| LO09 | To learn effective presentation preparation techniques; |
| LO10 | To be able to prepare more effective documents through Macros; |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Takes part in planning related to computer software and hardware | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Students will be able to define, collect and use the data necessary for the solution of well-defined problems in Computer Technologies and Programming. demonstrate that he / she can use the theoretical knowledge, knowledge and skills required in practical applications | 3 |
| PLO03 | Bilgi - Kuramsal, Olgusal | Word processor, spreadsheet, presentation, database and installs and uses various software | 5 |
| PLO04 | Bilgi - Kuramsal, Olgusal | Makes coding, internet and network makes the installation of devices | |
| PLO05 | Bilgi - Kuramsal, Olgusal | Have sufficient knowledge of Turkish and foreign languages. | 3 |
| PLO06 | Bilgi - Kuramsal, Olgusal | Evaluates and supervises the performances of the employees under their responsibility | 3 |
| PLO07 | Bilgi - Kuramsal, Olgusal | Detects software and simple hardware failures in the computer and solves problems that do not require expertise | 2 |
| PLO08 | Bilgi - Kuramsal, Olgusal | Use appropriate techniques with verbal, numerical and graphical expression | 4 |
| PLO09 | Bilgi - Kuramsal, Olgusal | Creates computer technology related design and applications with team work and presents to related people and institutions | 3 |
| PLO10 | Bilgi - Kuramsal, Olgusal | Gain analytical and numerical thinking skills and contribute to national economy by using knowledge and skills related to the field in accordance with regulations | 3 |
| PLO11 | Bilgi - Kuramsal, Olgusal | Provides professional connections in the public and private sector business areas and uses appropriate tools in the social and professional field in the decision-making process | 3 |
| PLO12 | Beceriler - Bilişsel, Uygulamalı | Conduct research using the Internet and various communication technologies | 3 |
| PLO13 | Beceriler - Bilişsel, Uygulamalı | Demonstrate the ability to learn and learn independently in the field of Computer Technologies and Programming | 4 |
| PLO14 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Conducts teamwork in accordance with the basic concepts of human relations and entrepreneurship | 3 |
| PLO15 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Have knowledge about Atatürk's Principles and Revolution History | 1 |
| PLO16 | Yetkinlikler - Öğrenme Yetkinliği | Demonstrate the ability to identify problems and find solutions to unforeseen situations in work in the field of Computer Technologies | 3 |
| PLO17 | Yetkinlikler - Öğrenme Yetkinliği | Takes part in software, hardware and network discoveries | 3 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Document Operations, Formatting Operations | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 2 | Document Control, Printing, Table Operations | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 3 | Object Operations, Advanced Features | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 4 | Macros, Customization | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 5 | Workspace, Data Entry, Formatting Operations | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 6 | Formulas, Functions | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 7 | Graph Processing, Data Analysis | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 8 | Mid-Term Exam | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 9 | Printing, Macros, Customization | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 10 | Midterm | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 11 | Workspace, Slide Processing, Design | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 12 | Slide Objects, Show Settings, | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 13 | Printing, Customizing | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 14 | Internet Concepts | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 15 | Lecture, Laboratory | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
|
| 16 | Term Exams | Lecture, Laboratory | Ölçme Yöntemleri: Yazılı Sınav |
| 17 | Term Exams | Lecture, Laboratory | Ö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 | 4 | 56 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 6 | 84 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 1 | 6 | 6 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 8 | 8 |
| Final Exam | 1 | 16 | 16 |
| Total Workload (Hour) | 170 | ||
| Total Workload / 25 (h) | 6,80 | ||
| ECTS | 7 ECTS | ||