COURSE UNIT TITLE

: PROFESSIONAL COMPUTER SKILLS II

DEGREE PROGRAMMES

Description of Individual Course Units

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

Offered By

Medical Documentation and Secretariat

Level of Course Unit

Short Cycle Programmes (Associate's Degree)

Course Coordinator

INSTRUCTOR SELÇUK OKTAY

Offered to

Medical Documentation and Secretariat

Course Objective

Spreadsheet or calculation program using the Excel program, also known as effectively, data entered into your account, you can easily sort the information requested, and very quickly the relevant mathematical operations reports, charts, tables, andeffective, detailed informationability to gain, And the underlying database (database), you can easily access the desired information, using effectively the relevant reports, charts, tables, andeffective, detailed informationability to train individuals who are won

Learning Outcomes of the Course Unit

1   Description of the Excel program obtains information about which areas are used.
2   Obtains information about how to use the Excel program
3   Obtains information about making Tables.
4   Table in the program obtains information about how to do macro.
5   Excel program on the ability to do preparation and efficient reports using report and acquires the experience
6   Excel program with tables, charts, making issues more clearly and learn what needs to be done for the understanding.
7   Excel program an effective reporting of work comprehends the importance and influence in their lives

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Course aims and objectives
2 The basics of Excel Excel program structure, program
3 Excel program Specialist markup techniques
4 The Excel worksheet is in Advanced techniques
5 Formulas and functions in Excel
6 Working with Excel program page graphics
7 Databasewhat is it
8 The Structure Of The Database
9 The Presentation Of The Tables In The Database
10 Database Queries
11 Database Forms
12 Database Reports

Recomended or Required Reading

Main source:
Castro, from beginner to advanced level, Academy Publisher, 2005
Jesus AHLUWALIA, Michael BARKER, James BLACK, EXCEL practices, comic publisher, 2012
John Robert BALE, advanced EXCEL applications, Thompson Bookstore, 2011

Planned Learning Activities and Teaching Methods

Lectures, case Presentations, the application

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 AR ArasınavTeo
2 PRC PRACTICE
3 FCGR FINAL COURSE GRADE AR * 0.50 + UYG * 0.50
4 FINT FINAL EXAM (THEORY)
5 FINP FINAL EXAM (PRACTICE)
6 FCGR FINAL COURSE GRADE FNT * 0.50 + FNU * 0.50
7 FCG FINAL COURSE GRADE VOR * 0.50 + FN * 0.50
8 RSTT RESIT (THEORY)
9 RSTP RESIT (PRACTICE)
10 RST RESIT BTT * 0.50 + BTU * 0.50
11 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

None

Assessment Criteria

Lectures, case Presentations, the application

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

e-posta: selcuk.oktay@deu.edu.tr Tel: 0 232 412 4726

Office Hours

Every day at 15.30-16.30

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 12 3 36
Preparations before/after weekly lectures 5 1 5
Preparation for final exam 1 3 3
Preparation for midterm exam 1 3 3
Midterm 2 1 2
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.11
LO.21
LO.31
LO.41
LO.5
LO.6
LO.7

CONTACT INFORMATION
Dokuz Eylül Üniversitesi Cumhuriyet Bulvarı No: 144 35210 Alsancak / İZMİR
Phone: +90(232) 412 12 12 - Fax: +90 (232) 464 81 35

Copyright 2015 DEÜ. BİD

HOME / ABOUT US / DEGREE PROGRAMMES / GENERAL INFORMATION FOR STUDENTS / INTERNATIONAL RELATIONS