FUNDAMENTAL INFORMATİON TECHNOLOGİES PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
SDP151	Fundamental Information Technologies	1	4	2	6

GENERAL INFORMATION
Language of Instruction :	Turkish
Level of the Course Unit :	ASSOCIATE DEGREE, TYY: + 5.Level, EQF-LLL: 5.Level, QF-EHEA: Short Cycle
Type of the Course :	Compulsory
Mode of Delivery of the Course Unit	-
Coordinator of the Course Unit	Lecturer SİBEL SEKMAN
Instructor(s) of the Course Unit	Lecturer SENA NUR BENLİ
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	The aim of this course is to enable students to acquire fundamental and advanced knowledge and skills related to digital tools that they can effectively use in daily life, office environments, and software development teams; and to develop their awareness and competencies in integrating these tools into planning, communication, collaboration, documentation, and productivity processes.
Contents of the Course Unit:	The content of this course covers the practical use of Microsoft Office and Google workspace tools in computer-based environments, including email management, calendar and meeting scheduling, online collaboration, document creation and editing, data preparation and analysis using spreadsheets, and effective presentation design processes.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
Can effectively use office software and cloud-based tools.
Learns Google Workspace and Microsoft Office tools through hands-on practice.
Can manage data sharing and integration processes between different software applications.
Understands the fundamental features of software operating across different operating systems.
Can prepare documents, spreadsheets, and presentations used in business processes.
Can propose solutions to conversion and compatibility issues between different file formats.

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	-	Introduction, internet services, web browsers and browser settings	Theoretical Instruction and Practical Application
2	Research	Use of Google Forms, Calendar, and related tools	Theoretical Instruction and Practical Application
3	Research	Google Drive, spreadsheets, documents, and presentations	Theoretical Instruction and Practical Application
4	Research	MS Word: interface, toolbars and features, saving files, security options	Theoretical Instruction and Practical Application
5	Research	MS Word: page layout, text editing, font features, format painter, paragraph settings, tabs, borders and shading, columns, bullet points and numbering	Theoretical Instruction and Practical Application
6	Research	MS Word: creating tables and using table tools, inserting drawing objects, templates, auto-correction options, paste special, find–replace–go, inserting images and using picture tools	Theoretical Instruction and Practical Application
7	Research	MS Excel: introduction to Excel, worksheet and cell concepts, cursor types, sheet tabs, cut–copy–paste, row and column operations, formatting	Theoretical Instruction and Practical Application
8	Research	MS Excel: introduction to toolbars, working with files, navigating within worksheets	Theoretical Instruction and Practical Application
9	Research	S Excel: operators, creating formulas, cell formatting, creating drawing objects, charts	Theoretical Instruction and Practical Application
10	-	MID-TERM EXAM	-
11	Research	MS PowerPoint: creating slides, slide layouts, slide design Method: Lecture and Practice	Theoretical Instruction and Practical Application
12	Research	Custom animations, adding audio, starting slide shows	Theoretical Instruction and Practical Application
13	Research	Master slide editing, slide view tools	Theoretical Instruction and Practical Application
14	Research	New presentation creation tools	Theoretical Instruction and Practical Application
15	Research	Office application practices and delivering professional presentations	Theoretical Instruction and Practical Application
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

SOURCE MATERIALS & RECOMMENDED READING
McFedries, P. (2023). Google Workspace for beginners. Independently published.
Courter, G. (2016). Mastering Microsoft Office 2016. Pearson Education.
Google Workspace Eğitim Kaynakları: ◦ Google Drive, Docs, Sheets, Slides ve Formlar için resmi eğitim içerikleri. Google Workspace Learning Center

ASSESSMENT
Assessment & Grading of In-Term Activities	Number of Activities	Degree of Contribution (%)	Description	Examination Method
Final Exam	1	100		Optical (Test) Exam
Final Exam	1	100		Computer-Lab-Practice Exam
TOTAL	2	200

Level of Contribution
0	1	2	3	4	5

WORKLOAD & ECTS CREDITS OF THE COURSE UNIT
Workload for Learning & Teaching Activities
Type of the Learning Activites	Learning Activities (# of week)	Duration (hours, h)	Workload (h)
Lecture & In-Class Activities	0	0	0
Preliminary & Further Study	0	0	0
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	0	0	0
Project Work	0	0	0
Seminar	0	0	0
Internship	0	0	0
Technical Visit	0	0	0
Web Based Learning	0	0	0
Implementation/Application/Practice	0	0	0
Practice at a workplace	0	0	0
Occupational Activity	0	0	0
Social Activity	0	0	0
Thesis Work	0	0	0
Field Study	0	0	0
Report Writing	0	0	0
Final Exam	0	0	0
Preparation for the Final Exam	0	0	0
Mid-Term Exam	0	0	0
Preparation for the Mid-Term Exam	0	0	0
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	0	0	0