TÜRKÇE
ENGLISH
Information
| Unit | CEYHAN VOCATIONAL SCHOOL |
| Code | PZR160 |
| Name | Office Softwares- II |
| Term | 2020-2021 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 | Uzaktan Öğ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 | To be able to process data using computer applications |
| LO02 | To be able to fomulate data using computer applications |
| LO03 | To be able to preapre report with data using computer applications |
| LO04 | To be able to graphics using data |
| LO05 | To be able to present report using computer applications |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|
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 | Mid-Term 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 | Term Exams | ||
| 17 | Term Exams |
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 | ||