Nevşehir Hacı Bektaş Veli University Course Catalogue

Information Of Programmes

VOCATIONAL SCHOOL OF NEVŞEHİR / BİL109 - COMPUTER PROGRAMMING

Code: BİL109 Course Title: OFFICE SOFTWARE Theoretical+Practice: 2+1 ECTS: 5
Year/Semester of Study 1 / Fall Semester
Level of Course Short Cycle Degree Programme
Type of Course Compulsory
Department COMPUTER PROGRAMMING
Pre-requisities and Co-requisites None
Mode of Delivery Face to Face
Teaching Period 14 Weeks
Name of Lecturer FETHULLAH MUSTAFA AKALP (fmakalp@nevsehir.edu.tr)
Name of Lecturer(s) KADİR ABA, MEHMET KIRTAY,
Language of Instruction Turkish
Work Placement(s) None
Objectives of the Course
The aim of this course is to gain the competencies related to the use of office programs in every branch of information technologies.

Learning Outcomes PO MME
The students who succeeded in this course:
LO-1 Can use word processing program. PO-2 Has advanced ability to use office software
PO-10 Designs and manages databases
 		Examination
LO-2 Can use database program. PO-2 Has advanced ability to use office software
PO-10 Designs and manages databases
 		Examination
LO-3 Can use the presentation preparation program. PO-2 Has advanced ability to use office software
PO-10 Designs and manages databases
 		Examination
PO: Programme Outcomes
MME:Method of measurement & Evaluation

Course Contents
1. Use word processing program 2. To use electronic spreadsheet program 3. Presentations to use design tool 4. Internet use and e-mail management programs
Weekly Course Content
Week Subject Learning Activities and Teaching Methods
1 Document Processes, Formatting Processes Lecture Method, Question Answer, Discussion Method, Individual Study Method
2 Document Control, Printing, Table Processes Lecture Method, Question Answer, Discussion Method, Individual Study Method
3 Object Processes, Advanced Features Lecture Method, Question Answer, Discussion Method, Individual Study Method
4 Macros, Customization Lecture Method, Question Answer, Discussion Method, Individual Study Method
5 Study Area, Data Entry, Formatting Processes Lecture Method, Question Answer, Discussion Method, Individual Study Method
6 Formulas, Functions Lecture Method, Question Answer, Discussion Method, Individual Study Method
7 Formulas, Functions Lecture Method, Question Answer, Discussion Method, Individual Study Method
8 mid-term exam
9 Graphics Processes, Data Analysis Lecture Method, Question Answer, Discussion Method, Individual Study Method
10 Data Analysis Lecture Method, Question Answer, Discussion Method, Individual Study Method
11 Print, Macros, Customization Lecture Method, Question Answer, Discussion Method, Individual Study Method
12 Study Area, Slide Processing, Design Lecture Method, Question Answer, Discussion Method, Individual Study Method
13 Slide Processing, Design Lecture Method, Question Answer, Discussion Method, Individual Study Method
14 Slide Objects, Display Settings Lecture Method, Question Answer, Discussion Method, Individual Study Method
15 Slide Objects, Display Settings Lecture Method, Question Answer, Discussion Method, Individual Study Method
16 final exam
Recommend Course Book / Supplementary Book/Reading
1 Joyce, C. (2011). Adım adım Microsoft Office Professional 2010. Arkadaş.
2 Şencan, E. (2011). Bilgisayar ve Ofis Programları Kullanımı. Bursa:Alfa Aktüel
Required Course instruments and materials
Auxiliary textbook, projection, computer

Assessment Methods
Type of Assessment Week Hours Weight(%)
mid-term exam 8 1 40
Other assessment methods
1.Oral Examination
2.Quiz
3.Laboratory exam
4.Presentation
5.Report
6.Workshop
7.Performance Project
8.Term Paper
9.Project
final exam 16 1 60

Student Work Load
Type of Work Weekly Hours Number of Weeks Work Load
Weekly Course Hours (Theoretical+Practice) 3 14 42
Outside Class
       a) Reading 3 10 30
       b) Search in internet/Library 3 10 30
       c) Performance Project 0
       d) Prepare a workshop/Presentation/Report 2 2 4
       e) Term paper/Project 0
Oral Examination 0
Quiz 0
Laboratory exam 0
Own study for mid-term exam 2 7 14
mid-term exam 1 1 1
Own study for final exam 2 14 28
final exam 1 1 1
0
0
Total work load; 150