COURSE UNIT TITLE

: PROFESSIONAL COMPUTER SKILLS II

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
TDS 1186 PROFESSIONAL COMPUTER SKILLS II COMPULSORY 1 1 0 2

Offered By

Medical Documentation and Secretariat

Level of Course Unit

Short Cycle Programmes (Associate's Degree)

Course Coordinator

HATICETÜL KÜBRA YENI

Offered to

Course Objective

The aim of the lesson is to gain well educated students about calculations of given datas, easily ordering of requested informations, speadily doing mathematical calculations, preparing reports, graphics, tables and effective information supply by using EXCEL which is described as electronical table and calculation software.

Learning Outcomes of the Course Unit

1   They will learn using of internet and finding of necessary information.
2   They will obtain information about using ares of excel software.
3   They will obtain information about how to use excel software.
4   They will obtain information about how to make table.
5   They will obtain information about how to make macro in table software.
6   They will gain experience about preparing effective report by using excel software
7   They will obtain information about what must be done for understanding tables and graphics in excel software easily

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Description and using of internet
2 Searching programmes in internet and reaching requested information
3 Aim and goals of excel
4 Structure of excel software
5 Fundamentals of excel software
6 Techniques of development of working pages in excel
7 Expert formulate techniques of excel software
8 midterm
9 effective working methods by boks about excel
10 Specialization of excel software
11 Formules and functionalities of excel software
12 graphics of working pages in excel software
13 Strong data techniques in excel software
14 An overview

Recomended or Required Reading

Textbook(s):
Ali vefa serçe, Ileri EXCEL, Pusula, yayıncılık ve iletişim ltd,2008
Joyce COX, Curtis FRYE, Bilgisayar kurs kitabı, Arkadaş yayınevi, 2008
Murat CAN, Başlangıçtan ileri seviyeye bilgisayar, Akademi yayınevi, 2005
Hasan Çebi BAL, Bilgisayar ve Internet Kullanımı, abp yayınevi, 2007

Supplementary Book(s):
Orhan ALTINBAŞAK, Bilgisayara Giriş, Altaş Basım Yayım Dağıtım, 2000
Yayın kurulu,Bilgisayar Laboratuvar Uygulamaları, Murathan Yayınevi ve dağıtım,2008

Planned Learning Activities and Teaching Methods

Demonstrate, implementation, presentation.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 AR ArasınavTeo
2 ASG ASSIGNMENT
3 FCGR FINAL COURSE GRADE AR * 0.60 + ODV * 0.40
4 FCGR FINAL COURSE GRADE
5 FCG FINAL COURSE GRADE VOR * 0.50 + FN * 0.50
6 RST RESIT
7 FCGR FINAL COURSE GRADE (RESIT) VOR * 0.50 + BUT * 0.50


*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

The mid-term exam will be theoretic and the final exam will be practical

Assessment Criteria

To understanding, teaching, examining and associating skills evaluating by the mid-term exam and implementing skills evaluating by the final exam

Language of Instruction

Turkish

Course Policies and Rules

Course, Fundamentals of Application is made within the framework of the VSHS and examinations and evaluated

Contact Details for the Lecturer(s)

Öğr.Gör.Haticetül Kübra YENI
haticetulkubra.yeni@deu.edu.tr

Office Hours

The day(s) of the lesson

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 1 13
Tutorials 13 1 13
Preparations before/after weekly lectures 7 1 7
Preparation for midterm exam 1 5 5
Preparation for final exam 1 10 10
Midterm 1 1 1
Final 1 1 1
TOTAL WORKLOAD (hours) 50

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13PO.14PO.15PO.16
LO.1
LO.2
LO.345
LO.4
LO.5245
LO.65
LO.72