Nevşehir Hacı Bektaş Veli University Course Catalogue

Information Of Programmes

FACULTY OF ECONOMICS & ADMINISTRATIVE SCIENCES / UTL232 - ULUSLARARASI TİCARET VE LOJİSTİK

Code: UTL232 Course Title: COMPUTER APPLICATIONS II Theoretical+Practice: 2+2 ECTS: 4
Year/Semester of Study 2 / Spring Semester
Level of Course 1st Cycle Degree Programme
Type of Course Optional
Department ULUSLARARASI TİCARET VE LOJİSTİK
Pre-requisities and Co-requisites None
Mode of Delivery Face to Face
Teaching Period 14 Weeks
Name of Lecturer KÜRŞAT İLHAN (kursat@nevsehir.edu.tr)
Name of Lecturer(s)
Language of Instruction Turkish
Work Placement(s) None
Objectives of the Course
To give basic information about computer systems, computer systems, Internet and commonly used services, and to improve the usage skills of operating system (Windows 10) and office application programs (MS Word, Excel, PowerPoint, Access).

Learning Outcomes PO MME
The students who succeeded in this course:
LO-1 Knows the basic concepts of computer system. PO-3 Mastering of basic statistics and modeling methods applied in decision-making
Examination
PO: Programme Outcomes
MME:Method of measurement & Evaluation

Course Contents
Computer Basic Concepts, Internet and Services, Windows 10, MS Word, MS Excel, MS Powerpoint, MS Access, advanced excel applications
Weekly Course Content
Week Subject Learning Activities and Teaching Methods
1 Introducing the workbook and sheet - Entering and editing data in cells - Method of Narration Case Study Method
2 Editing Worksheet: - Operations on the cell Method of Narration Case Study Method
3 Using Formulas: Method of Narration Case Study Method
4 Using Formulas: Method of Narration Case Study Method
5 Using logical functions Example applications Method of Narration Case Study Method
6 Using logical functions Example applications Method of Narration Case Study Method
7 Operations on data: - Sorting data - Filtering data - Subtotal subtotal - Creating pivot table Method of Narration Case Study Method
8 mid-term exam
9 Database: Basic Concepts Method of Narration Case Study Method
10 Database Design: Relational Database Design, Data Normalization Method of Narration Case Study Method
11 Database Design: Relational Database Design, Data Normalization Method of Narration Case Study Method
12 Sample Application: Order Tracking Database Method of Narration Case Study Method
13 Sample Application: Order Tracking Database Method of Narration Case Study Method
14 Term Project Presentations Method of Narration Case Study Method
15 Term Project Presentations Method of Narration Case Study Method
16 final exam
Recommend Course Book / Supplementary Book/Reading
Required Course instruments and materials

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 2 8 16
       b) Search in internet/Library 2 8 16
       c) Performance Project 0
       d) Prepare a workshop/Presentation/Report 0
       e) Term paper/Project 0
Oral Examination 0
Quiz 0
Laboratory exam 0
Own study for mid-term exam 4 7 28
mid-term exam 1 1 1
Own study for final exam 4 7 28
final exam 1 1 1
0
0
Total work load; 132