TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| Code | YLY132 |
| Name | Office Applications - II |
| Term | 2017-2018 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 1-2 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 2 National Credit |
| Teaching Language | Türkçe |
| Level | Ön Lisans Dersi |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör. Dr. ADNAN GÖKTEN |
| Course Instructor |
Öğr. Gör. ERKUT TEKELİ
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
To be able to comprehend the usage of office application programs (MS Excel, Access) at the basic level and the basic elements to meet the needs of the department.
Course Content
MS Excel - Access
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Uses MS Excel program |
| LO02 | Creates different types of graphics |
| LO03 | Generates spreadsheet solutions |
| LO04 | Designs a database in Access |
| LO05 | Creates different forms |
| LO06 | Uses the package programs of the department at a basic level |
| LO07 | Gain the ability to use the acquired knowledge and skills in business life |
| LO08 | Gains the ability to analyze data and interpret results |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Learns theoretical and applied information about local governments. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Knows problem solving methods and techniques related to the field | |
| PLO03 | Bilgi - Kuramsal, Olgusal | Board and management concepts and functions of the job, knows issues such properties | |
| PLO04 | Beceriler - Bilişsel, Uygulamalı | Evaluates the accuracy and up-to-dateness of the information related to the field. | |
| PLO05 | Beceriler - Bilişsel, Uygulamalı | Gains the ability to identify, define and solve problems related to the field | 3 |
| PLO06 | Yetkinlikler - Öğrenme Yetkinliği | Examines the events and facts related to the field with scientific methods and techniques by using the theoretical and applied knowledge gained. | 3 |
| PLO07 | Yetkinlikler - Alana Özgü Yetkinlik | Interprets the data obtained about the field. | 4 |
| PLO08 | Yetkinlikler - Öğrenme Yetkinliği | Diagnoses the problems she encounters in her field and offers solutions. | |
| PLO09 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Gains the ability to work individually and in groups related to his/her field. | |
| PLO10 | Bilgi - Kuramsal, Olgusal | Have information about Atatürk's Principles and History of Revolution. | |
| PLO11 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | inquisitive and would investigator. | |
| PLO12 | Yetkinlikler - Öğrenme Yetkinliği | Life-long learning will win | |
| PLO13 | Beceriler - Bilişsel, Uygulamalı | Have a good command of Turkish | |
| PLO14 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Expresses his/her thoughts in writing and orally in line with the basic knowledge he/she has on issues related to local governments. | 3 |
| PLO15 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Have sufficient foreign language knowledge in the field | |
| PLO16 | Beceriler - Bilişsel, Uygulamalı | Uses the software and hardware required by the field. | 5 |
| PLO17 | Yetkinlikler - Öğrenme Yetkinliği | Under the authority of elected political representatives, retains the overall benefit of society. | |
| PLO18 | Yetkinlikler - Öğrenme Yetkinliği | The universality of social rights, social justice, quality and environmental protection have sufficient awareness of ethical issues and cultural values. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | MS Excel - Introduction to Excel, Page and Cell Concept, Types of Cursors | Study from textbook | |
| 2 | Page Tabs, Cut-Copy-Paste, Row and Column Operations | Study from textbook | |
| 3 | MS Excel - Meet the Toolbars, Work with Files, Worksheet | Study from textbook | |
| 4 | MS Excel - Formula Creation | Study from textbook | |
| 5 | Excel practice | Study from textbook | |
| 6 | MS Excel - Working with menus | Study from textbook | |
| 7 | Excel practice | Study from textbook | |
| 8 | MIDTERM EXAM | Study from textbook | |
| 9 | Designing and creating an Access database | Study from textbook | |
| 10 | Working with Access forms | Study from textbook | |
| 11 | Working with Access queries | Study from textbook | |
| 12 | Access Practice | Study from textbook | |
| 13 | Deparment special package programs and applications | Study from textbook | |
| 14 | Deparment special package programs and applications | Study from textbook | |
| 15 | Deparment special package programs and applications | Study from textbook | |
| 16 | FINAL EXAM | Study from textbook | |
| 17 | FINAL EXAM | Study from textbook |
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 | 3 | 42 |
| 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 | 10 | 10 |
| Total Workload (Hour) | 86 | ||
| Total Workload / 25 (h) | 3,44 | ||
| ECTS | 3 ECTS | ||