Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
2MBH108Computer 22+2+03420.01.2026

 
Course Details
Language of Instruction Turkish
Level of Course Unit Associate Degree
Department / Program Court Office Services
Type of Program Formal Education
Type of Course Unit Compulsory
Course Delivery Method Face To Face
Objectives of the Course To provide students with advanced data management skills, proficiency in judicial informatics systems, and awareness of emerging technologies in the legal field.
Course Content Advanced Excel applications, formulas and data analysis; use of UYAP (National Judicial Network Project) systems and UDF document editor; artificial intelligence tools in law, data privacy and information security.
Course Methods and Techniques Lecture and practice
Prerequisites and co-requisities None
Course Coordinator Instructor NURÇİN KÜÇÜKYAZICI
Name of Lecturers Instructor Tuğba KAVAK
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Bilgisayar Laboratuvar Uygulamaları, Yayın Kurulu, Murathan Yay. 2008
Course Notes Academic works and legislation
Documents Sunumlar
Assignments sunum
Exams VİZE FİNAL

Course Category
Field %100

Planned Learning Activities and Teaching Methods
Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"

Assessment Methods and Criteria
In-Term Studies Quantity Percentage
Mid-terms 1 % 40
Final examination 1 % 60
Total
2
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 4 56
Hours for off-the-c.r.stud 14 1 14
Mid-terms 1 1 1
Practice 15 2 30
Final examination 1 1 1
Total Work Load   Number of ECTS Credits 4 102

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 Structures, analyzes, and reports professional data using advanced Excel functions.
2 Executes routine office processes and calculations in digital environments using logical and mathematical tools.
3 Utilizes UYAP platforms and digital document editors in accordance with professional standards.
4 Manages the confidentiality of judicial data within the framework of KVKK and cyber security principles.
5 Integrates current developments in legal technologies and AI tools into professional workflows.

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Intro to Excel: Tables and Data Structure
2 Basic Formulas and Mathematical Operations
3 Logical Functions (IF, AND, OR)
4 Lookup and Data Matching (VLOOKUP)
5 Data Validation and Protection in Excel
6 Pivot Tables and Reporting
7 Creating Statistical Charts in Excel
8 Midterm Exam
9 UYAP Systems and Portal Usage
10 UYAP Editor (UDF) and Official Correspondence
11 E-Signature and E-Notification Processes
12 AI and Digital Transformation in Law
13 KVKK and Judicial Data Security
14 General Review and Practice Activities

 
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4
All 1 1 1 1
C1 1 1 1 1
C2 1 1 1 1
C3 1 1 1 1
C4 1 1 1 1
C5

  bbb

  
  https://obs.gedik.edu.tr/oibs/bologna/progCourseDetails.aspx?curCourse=241997&curProgID=5733&lang=en