Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
0PSIR366Practice Of Digital Diplomacy3+0+03615.04.2026

 
Course Details
Language of Instruction English
Level of Course Unit Bachelor's Degree
Department / Program Political Science and İnternational Relations (English)
Type of Program Formal Education
Type of Course Unit Elective
Course Delivery Method Face To Face
Objectives of the Course This course aims to teach how big data, data analytics, automation technologies are
implemented in international relations and diplomacy to the students.
At the end of course, the students will be able to learn how to use these technologies
in IR and Diplomacy areas.
Course Content • Big Data
• Data Analytics
• Steps in Data Analytics
• Automation and Types of Automation
• Power BI for Diplomatic Analysis
• Working with SQL Server Management Studio for Diplomatic Analysis
• Python for Digital Diplomacy
Course Methods and Techniques Lecture Method (Expository Teaching Method), Project-Based Learning (PBL) Model
Prerequisites and co-requisities None
Course Coordinator None
Name of Lecturers Instructor Dr. Umut Köksal
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Foster Provost and Tow Fawcett(2013): Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking, O'Reilly Media (*Recommended)
Learn Power BI: A Beginner’s Guide to Developing Interactive BI Solutions
Microsoft SQL Server 2019: A Beginner's Guide
Course Notes Powerpoint Slides and Notes on Digital Tools used in this course.

Course Category
Engineering %30
Social Sciences %70

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
Assignment 2 % 10
Final examination 1 % 50
Total
4
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 3 42
Assignments 2 18 36
Mid-terms 1 25 25
Final examination 1 50 50
Total Work Load   Number of ECTS Credits 6 153

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
Bilgi 
1 To learn the foundations of Big Data and Data Analytics
Beceri 
2 To Analyze diplomatic and geopolitical data using Power BI
3 To use Python to collect, clean, and analyze open-source diplomatic data
4 To design Tables and Write down Queries with SQL Server Management Studio for diplomatic and consular processes
Yetkinlik 
5 To integrate data insights into policy briefs and diplomatic strategies

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Data, Types of Data and Analytics
2 Automation: What is Automation, Types of Automation
3 Steps of Data Analytics and Automation
4 Power BI: What is Power BI, Properties of Power BI
5 Power BI:Downloading and Implementing Power BI, Examples
6 Power BI: Summarization
7 Introduction to Databases and SQL Server Management Studio
8 Introduction to Databases and SQL Server Management Studio
9 Table Design and Data Management
10 Data Querying and Filtering
11 Practical Database Operations and Basic Analysis
12 Case-Study
13 Python: What is Python? Dowloading and Implementing Python
14 asic Python Functions and Their Use in IR&Diplomacy

 
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10
All 3
In1 3 3
Sk2 3
Sk3 4 3
Sk4 3 4 4
Co5 3 4

  bbb

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