TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| Code | YLY132 |
| Name | Office Applications - II |
| Term | 2018-2019 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. MEHMET YILMAZ
(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 - HTML
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | can create a formula using MS Excel program. |
| LO02 | charts can list and draw. |
| LO03 | Produce spreadsheet solutions. |
| LO04 | Know, design and create database concept in Access. |
| LO05 | Can create forms and queries. |
| LO06 | Department-specific packet programs can be used at the basic level. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Have theoretical and practical knowledge about the local government area. | 0 |
| PLO02 | - | Strategies related to the field, have knowledge of methods and techniques of measurement and evaluation. | 0 |
| PLO03 | - | Evaluate the accuracy and timeliness of information about the site. | 0 |
| PLO04 | - | Identifying information about the area, it is able to identify and solve this purpose and apply appropriate methods and techniques | 1 |
| PLO05 | - | Events and facts about the area can be examined using the theoretical and practical knowledge gained by scientific methods and techniques. | 0 |
| PLO06 | - | Evaluate and interpret the data it has obtained. | 1 |
| PLO07 | - | Problems can recognize, analyze and develop solutions based on edebilir.kanıt. | 0 |
| PLO08 | - | Activities related to the field can execute independently. It should take responsibility for solving the problems encountered as an individual and a team member. | 0 |
| PLO09 | - | Evaluate the basic level of knowledge and skills gained in the field. | 0 |
| PLO10 | - | inquisitive and would investigator. | 0 |
| PLO11 | - | Life-long learning will win | 0 |
| PLO12 | - | With the degree of using Turkish language skills | 0 |
| PLO13 | - | Thought it was in line with the basic information on issues related to local government can express written and oral. | 0 |
| PLO14 | - | Al the field will be level enough to have knowledge of a foreign language. | 0 |
| PLO15 | - | To have knowledge and consciousness about Atatürk Principles and History of Turkish Revolution | 0 |
| PLO16 | - | Software and hardware required to use Al MySpace. | 5 |
| PLO17 | - | Board and management concepts and functions of the job, knows issues such properties | 0 |
| PLO18 | - | Under the authority of elected political representatives, retains the overall benefit of society. | 0 |
| PLO19 | - | The universality of social rights, social justice , quality and environmental protection have sufficient awareness of ethical issues and cultural values. | 0 |
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-1 | Study from textbook | |
| 6 | MS Excel - Working with menus | Study from textbook | |
| 7 | Excel practice-2 | Study from textbook | |
| 8 | Mid-Term 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 | HTML basic commands | Study from textbook | |
| 14 | HTML table creation | Study from textbook | |
| 15 | HTML form creation | Study from textbook | |
| 16 | Term Exams | Study from textbook | |
| 17 | Term Exams | 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 | ||