TÜRKÇE
ENGLISH
Information
| Unit | CEYHAN VOCATIONAL SCHOOL |
| Code | PZR160 |
| Name | Office Softwares- II |
| Term | 2017-2018 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 2-0 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 2 National Credit |
| Teaching Language | Türkçe |
| Level | Ön Lisans Dersi |
| Type | Normal |
| Label | E Elective |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör. SADIK EREN |
| Course Instructor |
Öğr. Gör. SADIK EREN
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
In this course, it is aimed for learning of the students about spreadsheet program, formulas, creating graphics and presentation program.
Course Content
1 Review of Word 2 Presentation techniques 3 Introduction to Power Point 4 To presentation on Power Point 5 Introduction to Excel 6 Recognition of items in the Excel window 7 ing formulas in Excel 8 ing formulas in Excel 9 ing formulas in Excel 10 ing formulas in Excel 11 Data formatting operations in Excel 12 Table and design operations in Excel 13 Table and design operations in Excel 14 ing graphics in Excel
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Uses MS Excel ofice program on issues related to the profession. |
| LO02 | Creates documents about his/her field using MS Excel programme formulas. |
| LO03 | Format MS Excel pages as desired. |
| LO04 | Creates and formats tables with MS Excel programme. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | It refers to basic theoretical knowledge supported by current information in the field of marketing. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | It refers to the basic level theoretical and practical knowledge acquired in the field of marketing. | |
| PLO03 | Bilgi - Kuramsal, Olgusal | Discusses any marketing problem at a basic level, using the knowledge and skills acquired in the field of marketing. | |
| PLO04 | Bilgi - Kuramsal, Olgusal | Compares basic level studies on marketing in terms of their similarities and differences. | |
| PLO05 | Bilgi - Kuramsal, Olgusal | Explains the cause/effect of problems encountered in marketing-related applications. | |
| PLO06 | Beceriler - Bilişsel, Uygulamalı | They can criticize the basic knowledge and skills acquired in marketing, have the ability to identify their deficiencies and meet these deficiencies. | |
| PLO07 | Beceriler - Bilişsel, Uygulamalı | Gains lifelong learning awareness. | |
| PLO08 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | He/she can carry out activities for the development of the personnel he/she is responsible for. | |
| PLO09 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | He/she can convey his/her thoughts through written, verbal and visual communication at the level of basic knowledge and skills on marketing-related issues. | 3 |
| PLO10 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | He/she can share his/her thoughts on marketing-related issues and solutions to problems with experts and non-experts. | |
| PLO11 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Obtains a basic level of foreign language knowledge to monitor information in the field of marketing and communicate with colleagues and non-nationals. | |
| PLO12 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | With the basic computer use required by the marketing field, internet technologies can use office software at a basic level. | 4 |
| PLO13 | Yetkinlikler - Öğrenme Yetkinliği | Have social, scientific, cultural and ethical values in the stages of collecting any data in the field of marketing, applying it and announcing the results. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Review of Word | Lecture notes | |
| 2 | Presentation techniques | Lecture notes | |
| 3 | Introduction to Power Point | Lecture notes | |
| 4 | To presentation on Power Point | Lecture notes | |
| 5 | Introduction to Excel | Lecture notes | |
| 6 | Recognition of items in the Excel window | Lecture notes | |
| 7 | ing formulas in Excel | Lecture notes | |
| 8 | Midterm Exam | ||
| 9 | ing formulas in Excel | Lecture notes | |
| 10 | ing formulas in Excel | Lecture notes | |
| 11 | ing formulas in Excel | Lecture notes | |
| 12 | Data formatting operations in Excel | Lecture notes | |
| 13 | Table and design operations in Excel | Lecture notes | |
| 14 | Table and design operations in Excel | Lecture notes | |
| 15 | ing graphics in Excel | Lecture notes | |
| 16 | Final Exam | ||
| 17 | Final Exam |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 2 | 28 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 2 | 28 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 0 | 0 | 0 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 6 | 6 |
| Final Exam | 1 | 16 | 16 |
| Total Workload (Hour) | 78 | ||
| Total Workload / 25 (h) | 3,12 | ||
| ECTS | 3 ECTS | ||