USEFUL INFORMATION, RESOURCES & SERVICES FOR STUDENTSUSEFUL LINKS AND DOCUMENTS ADITIONAL & SUPPORTING INFORMATION

SECTION I: GENERAL INFORMATION ABOUT THE COURSE

Course Code	Course Name	Year	Semester	Theoretical	Practical	Credit	ECTS
50612METOZ-BLP0081	Basic Information Technologies	2	Spring	1	1	2	4

Course Type :	Compulsory
Cycle:	Associate TQF-HE:5. Master`s Degree QF-EHEA:Short Cycle EQF-LLL:5. Master`s Degree
Language of Instruction:	Turkish
Prerequisities and Co-requisities:	N/A
Mode of Delivery:	E-Learning
Name of Coordinator:	Instructor FATİH ZAHİD GENÇ
Dersin Öğretim Eleman(lar)ı:
Dersin Kategorisi:

SECTION II: INTRODUCTION TO THE COURSE

Course Objectives & Content

Course Objectives:

The aim of this course is to equip students with basic information technology skills, enabling them to effectively use Microsoft Excel, Word, and PowerPoint.

Course Content:

Throughout the course, students will explore the fundamental functions of Excel, such as data organization, creating tables, and charts; the essential features of Word, including text formatting, editing, and document preparation; and the core areas of PowerPoint usage, such as creating presentations and editing slides. Through these programs, students will enhance their ability to work efficiently in digital environments and acquire problem-solving skills for various digital challenges they may encounter in daily life.

Course Specific Rules

Having basic computer literacy.

Course Learning Outcomes (CLOs)

Course Learning Outcomes (CLOs) are those describing the knowledge, skills and competencies that students are expected to achieve upon successful completion of the course. In this context, Course Learning Outcomes defined for this course unit are as follows:



Knowledge *(Described as Theoritical and/or Factual Knowledge.)*
1) Students will be able to organize data and create tables using Microsoft Excel.
2) Students will acquire the skills to identify and troubleshoot basic computer issues.
3) Students will develop essential information technology skills required for efficient work in digital environments.
Skills *(Describe as Cognitive and/or Practical Skills.)*
1) Students will gain the ability to format text and prepare professional documents using Microsoft Word.
2) Students will be able to create effective presentations and improve their slide editing skills with Microsoft PowerPoint.
Competences *(Described as "Ability of the learner to apply knowledge and skills autonomously with responsibility", "Learning to learn"," Communication and social" and "Field specific" competences.)*

Weekly Course Schedule

Week	Subject	Materials Sharing *
		Related Preparation	Further Study
1)	Introduction to Information Technologies and Basic Computer Concepts	None	None
2)	Introduction to Microsoft Excel: Basic Features and Interface	None.	None.
3)	Formulas and Functions in Excel.	None.	None.
4)	Data Visualization in Excel: Charts and Graphs.	None.	None.
5)	Data Analysis and Pivot Tables in Excel.	None.	None.
6)	Advanced Excel Functions and Data Management.	None.	None.
7)	Midterm Exam	None.	None.
8)	Introduction to Microsoft Word: Basic Features and Interface	None.	None
9)	Text Formatting and Editing in Word	None.	None.
10)	Creating Professional Documents in Word	None.	None.
11)	Introduction to Microsoft PowerPoint: Basic Features and Interface	None.	None.
12)	Creating Effective Presentations	None.	None.
13)	Advanced PowerPoint Features	None.	None.
14)	Integrating Excel, Word, and PowerPoint for Professional Use. How to integrate the three programs, such as importing data from Excel into a Word document or incorporating a Word document into a PowerPoint presentation. Additionally, practical exercises will be conducted for creating professional reports and presentations.	None.	None.

*These fields provides students with course materials for their pre- and further study before and after the course delivered.

Level of Contribution of the Course to PLOs

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

	Programme Learning Outcomes	Contribution Level (from 1 to 5)
1)	To demonstrate the ability to analyze and explain the fundamental concepts, theoretical frameworks, and legal regulations pertaining to the field of e-commerce and marketing.
2)	To possess up-to-date knowledge of the digital commerce ecosystem, consumer behavior, and marketing strategies.
3)	To demonstrate the ability to identify challenges within digital marketing, logistics, and foreign trade processes, and to propose fundamental solutions accordingly.
4)	To demonstrate the ability to formulate marketing strategies through the application of data analysis, search engine optimization (SEO), search engine marketing (SEM), and e-commerce software platforms.
5)	To demonstrate the ability to integrate business management, accounting, and foreign trade knowledge into digital trade operations and processes.
6)	To be able to effectively manage operations such as product, customer, and order management on e-commerce platforms.
7)	To be able to follow digital transformation and technology trends with an awareness of lifelong learning.
8)	To demonstrate the ability to critically assess advancements in the field and effectively integrate acquired knowledge into organizational and business processes.
9)	To be able to work effectively within a team and take responsibility.
10)	To be able to effectively use written and verbal communication skills in the workplace and prepare professional presentations for senior management.
11)	To be able to create content targeted at the audience on social media and digital platforms, and manage digital brand communication at a basic level.

SECTION IV: TEACHING-LEARNING & ASSESMENT-EVALUATION METHODS OF THE COURSE

Teaching & Learning Methods of the Course

(All teaching and learning methods used at the university are managed systematically. Upon proposals of the programme units, they are assessed by the relevant academic boards and, if found appropriate, they are included among the university list. Programmes, then, choose the appropriate methods in line with their programme design from this list. Likewise, appropriate methods to be used for the course units can be chosen among those defined for the programme.)

Teaching and Learning Methods defined at the Programme Level	Teaching and Learning Methods Defined for the Course
Lectures
Problem Solving

Assessment & Evaluation Methods of the Course

(All assessment and evaluation methods used at the university are managed systematically. Upon proposals of the programme units, they are assessed by the relevant academic boards and, if found appropriate, they are included among the university list. Programmes, then, choose the appropriate methods in line with their programme design from this list. Likewise, appropriate methods to be used for the course units can be chosen among those defined for the programme.)

Aassessment and evaluation Methods defined at the Programme Level	Assessment and Evaluation Methods defined for the Course
Midterm
Final Exam

Contribution of Assesment & Evalution Activities to Final Grade of the Course

Measurement and Evaluation Methods	# of practice per semester	Level of Contribution
Quizzes	2	% 20.00
Midterms	1	% 30.00
Semester Final Exam	1	% 50.00
Total		% 100
PERCENTAGE OF SEMESTER WORK		% 50
PERCENTAGE OF FINAL WORK		% 50
Total		% 100

SECTION V: WORKLOAD & ECTS CREDITS ALLOCATED FOR THE COURSE

WORKLOAD OF TEACHING & LEARNING ACTIVITIES
Teaching & Learning Activities	# of Activities per semester	Duration (hour)	Total Workload
Course	14	2	28
Laboratory	0	0	0
Application	3	7	21
Special Course Internship (Work Placement)	0	0	0
Field Work	0	0	0
Study Hours Out of Class	0	0	0
Presentations / Seminar	0	0	0
Project	0	0	0
Homework Assignments	0	0	0
Total Workload of Teaching & Learning Activities	-	-	49
WORKLOAD OF ASSESMENT & EVALUATION ACTIVITIES
Assesment & Evaluation Activities	# of Activities per semester	Duration (hour)	Total Workload
Quizzes	2	10	20
Midterms	1	15	15
Semester Final Exam	1	18	18
Total Workload of Assesment & Evaluation Activities	-	-	53
TOTAL WORKLOAD (Teaching & Learning + Assesment & Evaluation Activities)			102
ECTS CREDITS OF THE COURSE (Total Workload/25.5 h)			4