TÜRKÇE
ENGLISH
Information
| Unit | CEYHAN VOCATIONAL SCHOOL |
| Code | BYA155 |
| Name | Computerized Office Programs |
| Term | 2020-2021 Academic Year |
| Semester | 1. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 5 ECTS |
| National Credit | 2.5 National Credit |
| Teaching Language | Türkçe |
| Level | Ön Lisans Dersi |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Uzaktan Öğretim |
| Catalog Information Coordinator | Öğr. Gör. Dr. ÜNAL BALCI |
| Course Instructor |
Öğr. Gör. Dr. ÜNAL BALCI
(Güz)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
Aim of this course to introduce the concepts of computer hardware and operating system and MS Office applications to provide a basic level of knowledge and skills to use.
Course Content
This course includes following subjects. Introduction Basic Concepts and Operating Systems, Computer peripherals, Word Processors (Word), Spreadsheet program (Excel), Presentation (Power Point).
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | To arrange the documents and writings, which are used in daily life, in the word activity programme and make the editing and corrections |
| LO02 | To make arrangement and printing activities of the tables and business which are used in the work life |
| LO03 | To add figure, shape, object and grafic the documents and save them in the magnetic media |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Recognition of the basic concepts about computer | Lecture notes | |
| 2 | Recognition interface of the Windows operating system, using desktop environment, to adjust the description and characteristics objects in the desktop and task bar | Lecture notes | |
| 3 | Using the Start menu options, To make transactions select the folders and files associated with creating, moving, copying, etc. | Lecture notes | |
| 4 | Word introduction, recognize the Word screen, File operations: opening, closing, saving, save as, page structure. | Lecture notes | |
| 5 | Edit menu operations, View menu operations, Format menu operations | Lecture notes | |
| 6 | Tools menu operations, Table menu operations | Lecture notes | |
| 7 | Excel introduction, recognize the Excel screen, File operations: opening, closing, saving, save as. | Lecture notes | |
| 8 | Mid-Term Exam | ||
| 9 | Data entering, Data entry techniques, Formula creation, operators, Cell applications | Lecture notes | |
| 10 | Functions | Lecture notes | |
| 11 | Functions | Lecture notes | |
| 12 | Managing workbooks, Data Management: List creation, ranking, filtering, graphic creation | Lecture notes | |
| 13 | Recognize the PowerPoint screen, menu operations, creating a new presentation, to work on the master slides in the PowerPoint program | Lecture notes | |
| 14 | Working with different views on slides, slide adding, replication, file taking the slide, select and delete operations | Lecture notes | |
| 15 | Adding pictures, audio and video clips, custom animation addition, the slide show to be displayed | 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 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 3 | 42 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 1 | 2 | 2 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 12 | 12 |
| Final Exam | 1 | 18 | 18 |
| Total Workload (Hour) | 116 | ||
| Total Workload / 25 (h) | 4,64 | ||
| ECTS | 5 ECTS | ||