SECTION I: GENERAL INFORMATION ABOUT THE COURSE

Course Code	Course Name	Year	Semester	Theoretical	Practical	Credit	ECTS
60611YETOS-BIT2022	Information and Communication Technologies	3	Spring	2	0	2	3

Course Type :	University Elective
Cycle:	Bachelor      TQF-HE:6. Master`s Degree      QF-EHEA:First Cycle      EQF-LLL:6. Master`s Degree
Language of Instruction:	Turkish
Prerequisities and Co-requisities:	N/A
Mode of Delivery:	E-Learning
Name of Coordinator:	Instructor AYŞE BERİKA VAROL MALKOÇOĞLU
Dersin Öğretim Eleman(lar)ı:	Dr. Öğr. Üyesi CANSU ŞAHİN KÖLEMEN
Dersin Kategorisi:	Competency Development (University Elective)

SECTION II: INTRODUCTION TO THE COURSE

Course Objectives & Content

Course Objectives:

At the end of this course, students; 1. Knows the basic structures and functions of the computer. 2. Recognizes the basic hardware that makes up the computer. It monitors developments related to these. 3. Know operating systems and basic tasks and work on current versions of Windows operating system. 4. Prepares a document containing text, pictures and tables in the word processing program (Microsoft Word) and organizes this document according to its needs. 5. Prepares documents in spreadsheet (Microsoft Excel) program, can use functions in EXCEL program, makes graphical representation and data analysis. 6. Makes a visual presentation with the presentation program (Microsoft Powerpoint) using animation and sound options.

Course Content:

Introduction to computing; introduction to computer hardware and software; word processing, spreadsheet, presentation; web software tools.

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.)

Skills (Describe as Cognitive and/or Practical Skills.)

1) Prepares a document containing text, pictures and tables in the word processing program (Microsoft Word) and organizes this document according to its needs.

2) Applies effective presentation techniques through Microsoft Powerpoint program.

3) Prepares documents in spreadsheet (Microsoft Excel) program, can use functions in EXCEL program, makes graphical representation and data analysis.

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 the course and information about the processing Explanation of lesson plan and grade evaluation (Orientation) Basic concepts of Information Technologies Microsoft Office - Introduction to Word • Introducing the Word Interface • Using the Quick Access Toolbar Working with Document View Modes • Opening a New Document
2)	Microsoft Office Word– Text Formatting Operations • Editing Paragraph Settings • Editing Borders and Shading Options • Adding Bullets and Numbering
3)	Microsoft Office Word– Text Formatting Operations • Dividing the Text into Columns • Enlarging the Beginning Change Capital / Lower Case • Finding and Replacing Text • Adding Date and Time • Adding Page Number
4)	Microsoft Office Word - Working with Tables - Using Advanced Word Tools • Creating Tables • Adding and Deleting Rows, Columns • Applying Style to the Table • Convert Table to Text • Adding Page Break • Adding End of Section • Adding Hyperlink to Text
5)	Microsoft Office Excel- Data Entry / Cell and Table Formatting • Introduction of the Interface • Data input • Moving and Copying • Adding Comments • Cell Forming
6)	Microsoft Office Excel- Functions and Calculations • Conditional formatting • Formula Entry • Mathematical Functions
7)	Microsoft Office Excel- Functions and Calculations • Statistical Functions • Textual Functions • Sorting, Filtering
8)	MIDTERM EXAM WEEK
9)	Microsoft Office Excel- Data Processing • Pivot Table - Pivot Chart (Pivot Chart) • Data Validation • Removing Duplicate Data
10)	Microsoft Office Excel- Page Layout and Print Settings / Appearance Properties • Paper Size Selection • Setting Margins • Vertical / Horizontal Page Usage • Header / Footer Settings • Page Break Operations • Print Options • Appearance Settings
11)	Microsoft Office - Introduction to Powerpoint / Creating a New Presentation • Introduction of the Interface • Presentation and Slide Concepts Document View Modes • Creating a Presentation Using a Template • Adding and Editing Text • Saving Options Microsoft Office Powerpoint- Working with Slide Structure and Text Based Components • Choosing a Design Theme • Selecting Slide Layout • Working with Text Boxes • Formatting Text • Using Bullets and Numbering
12)	Microsoft Office Powerpoint- Slide Arrangements • Changing Slide Layouts • Copying and Deleting Slides • Hiding and Viewing Slides • Adding Slide Transition Effects • Adding Slides from Other Presentations Using the Find and Replace Tool
13)	Microsoft Office Powerpoint- Working with Pictures, Tables, Graphics • Adding Pictures to Slides • Grouping Objects • Adding Tables • Editing the Table Design • Adding and Deleting Cells, Rows, Columns • Aligning Text in Tables • Adding Graphics Formatting and Resizing the Chart
14)	Microsoft Office Powerpoint- Animations • Using the Animation Tab • Adding Input and Output Animations • Adding Emphasis • Using Motion Paths • Editing Animation Effects • Using Saved Templates
15)	Working with Microsoft Office Outlook Messages • Introduction of the Interface • Creating an Email Message • Reading and Deleting Emails • Replying, Forwarding and Printing Emails • Filtering Emails • Creating Signatures and Adding Signatures to Emails Microsoft Office Calendar and Contacts • Making an Appointment to the Calendar • Managing and Organizing Appointments • Planning and Managing Meetings • Sharing the Calendar • Customizing the Calendar • Adding and Updating People • Using the To Do Bar
16)	Final exam

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

Recommended or Required Reading & Other Learning Resources/Tools

Course Notes / Textbooks:
References:	Hızlı Ve Kolay Office Kodlab Yayınları Mehmet Gülmez Office 2016 Abaküs Yayıncılık Mehmet Gülmez Bilgisayar Ve Ofis Programları Kullanımı Alfa Aktüel Yayınları Office 2016 Abaküs Kitap Cenk İltir

SECTION III: RELATIONSHIP BETWEEN COURSE UNIT AND COURSE LEARNING OUTCOMES (CLOs)

(The matrix below shows how the course learning outcomes (CLOs) associates with programme learning outcomes (both KPLOs & SPLOs) and, if exist, the level of quantitative contribution to them.)

Relationship Between CLOs & PLOs

(KPLOs and SPLOs are the abbreviations for Key & Sub- Programme Learning Outcomes, respectively. )

CLOs/PLOs	KPLO 1					KPLO 2						KPLO 3			KPLO 4					KPLO 5
	1	2	3	4	5	1	2	3	4	5	6	1	2	3	1	2	3	4	5	1	2	3	4	5	6	7	8	9	10	11	12
CLO1
CLO2
CLO3

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)	Explains the basic, theoretical and practical knowledge about Interior Architecture and Environmental Design.
	1.1 To have knowledge about national and international laws, regulations and universal design principles.
	1.2 Explain the historical development of architecture.
	1.3 Summarizes all development processes of design.
	1.4 Summarizes all the development processes of furniture history.
	1.5 Defines the historical development process of art.
2)	Can reveal original and innovative designs.
	2.1 Transfers the bill or idea in her/his mind to paper
	2.2 Defines and applies design principles and elements.
	2.3 Manages the space planning process in the light of technical knowledge in the field of design.
	2.4 Apply the acquired theoretical knowledge in design techniques.
	2.5 Designs the furniture and its combination details and manages the furniture production process.
	2.6 Designs by considering the anatomical, anthropometric features, psychological, physical capacity and tolerances of the user.
3)	Use the drawing programs required by the profession.
	3.1 Be able to use Autocad program effectively in technical drawing language.
	3.2 He/she capable of using 3Ds Max program as presentation technique in modeling.
	3.3 Can use the necessary presentation programs actively when transferring information to the relevant people.
4)	Apply the theoretical knowledge learned in business life for one semester
	4.1 To be able to organize and implement projects and activities for the social environment in which they live with a sense of social responsibility.
	4.2 Transfers the professional knowledge to individuals and institutions orally and in writing.
	4.3 To be able to manage activities for the development of employees working under their responsibility.
	4.4 Explain problems using professional data.
	4.5 Solves the complex problems encountered and unforeseen in applications.
5)	S/he acquires the competencies that develop by the expectations of business world and the society defined as the institutional outcomes of our university on the advanced level in relation with his/her field.
	5.1 Acquires the analyzing solving the problems and managing the conflicts.
	5.2 Participates as a team member and takes responsibility in the environments that require the solving of the conflicts and acts as a leader when necessary.
	5.3 Has awareness for ethical and social responsivity.
	5.4 By supporting the learnt courses with quantitative and qualitative data; and by using verbal and visual communication means, s/he transfers them to the groups within and outside his/her group in a systematical and effective way.
	5.5 Evaluates the norms and standards present in the works in which s/he takes responsibility in a critical point of view.
	5.6 Develops strategical, innovative and entrepreneurial ideas.
	5.7 Acquires competence of managing the change.
	5.8 Shows development personally and socially with and awareness for lifelong learning.
	5.9 Follows advanced technologies and developments about digital transformation.
	5.10 Has cultural awareness and s/he transfers this to the groups within and outside his/her field.
	5.11 Has awareness about citizenship competency.
	5.12 Acquires communication in a Foreign Language (English) competence defined on the level of at least B1 in European Language Portfolio. (In programs whose medium of instruction is English, on the level of B2/B2+).

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
Discussion
Case Study
Problem Solving
Demonstration
Views
Laboratory
Reading
Homework
Project Preparation
Thesis Preparation
Peer Education
Seminar
Technical Visit
Course Conference
Brain Storming
Questions Answers
Individual and Group Work
Role Playing-Animation-Improvisation
Active Participation in Class

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
Presentation
Final Exam
Quiz
Report Evaluation
Homework Evaluation
Oral Exam
Thesis Defense
Jury Evaluation
Practice Exam
Evaluation of Implementation Training in the Workplace
Active Participation in Class
Participation in Discussions

Relationship Between CLOs & Teaching-Learning, Assesment-Evaluation Methods of the Course

(The matrix below shows the teaching-learning and assessment-evaluation methods designated for the course unit in relation to the course learning outcomes.)

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

Measurement and Evaluation Methods	# of practice per semester	Level of Contribution
Total		%
PERCENTAGE OF SEMESTER WORK		% 0
PERCENTAGE OF FINAL WORK		%
Total		%

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	3	42
Laboratory	0	0	0
Application	0	0	0
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	1	5	5
Total Workload of Teaching & Learning Activities	-	-	47
WORKLOAD OF ASSESMENT & EVALUATION ACTIVITIES
Assesment & Evaluation Activities	# of Activities per semester	Duration (hour)	Total Workload
Quizzes	2	10	20
Midterms	1	5	5
Semester Final Exam	1	10	10
Total Workload of Assesment & Evaluation Activities	-	-	35
TOTAL WORKLOAD (Teaching & Learning + Assesment & Evaluation Activities)			82
ECTS CREDITS OF THE COURSE (Total Workload/25.5 h)			3