Computer Programming

Course Code	Course Name	Year	Period	Semester	T+A+L	Credit	ECTS
03810103	Information Technologies	1	Autumn	1	3+1+1	6	6

Course Type	Compulsory
Course Cycle	Associate (Short Cycle) (TQF-HE: Level 5 / QF-EHEA: Short Cycle / EQF-LLL: Level 5)
Course Language	Turkish
Methods and Techniques	-
Mode of Delivery	Face to Face
Prerequisites	-
Coordinator	Lect. Özlem AKARÇAY PERVİN
Instructor(s)	Lect. Özlem AKARÇAY PERVİN
Instructor Assistant(s)	-

Name and Surname	Room	E-Mail Address	Internal	Meeting Hours
Lect. Özlem AKARÇAY PERVİN	TSMYO-T213	[email protected]	7916

Basic Vocational Courses	X
Specialization / Field Courses
Support Courses	X
Transferable Skills Courses	X
Humanities, Communication and Management Skills Courses	X

Relationship Levels
Lowest	Low	Medium	High	Highest
1	2	3	4	5

#	Program Learning Outcomes	Level
P4	Effectively uses information technologies (software, programs, animations, etc.) related to her/his profession.	4
P1	He/she has basic, current and applied information about his/her profession.	5
P3	He/She follows current developments and practices in his profession and uses them effectively.	4
P5	Has the ability to independently evaluate professional problems and issues with an analytical and critical approach and propose solutions.	3
P6	Can present his/her thoughts effectively through written and verbal communication at the level of knowledge and skills and expresses them in an understandable manner.	3

Upon the successful completion of this course, students will be able to:
No	Learning Outcomes	Outcome Relationship	Measurement Method **
O1	Knows the basic elements of a computer.	P.1.1	1
O2	Knows how to use at least one of the MS Office tools.	P.6.2	1
O3	Speaks and presents confidently in front of the public	P.6.4	1
O4	To be able to define the basic concepts of information technologies and computer systems and to explain the relationships between these concepts.	P.20.1	1
O5	Ability to effectively use basic software applications (e.g. presentation software, etc.) and prepare professional documents with these tools.	P.20.2	1
** Written Exam: 1, Oral Exam: 2, Homework: 3, Lab./Exam: 4, Seminar/Presentation: 5, Term Paper: 6, Application: 7

Week	Topics
1	Computer concepts and Basics
2	Microsoft Windows topics: Desktop, taskbar, start menu items, window operations, basic file folder operations, folder options, adding and removing items from the start menu, customizing the desktop, customizing the taskbar, start programs items, all programs, control panel
3	Writing and saving text in MS Word, creating new documents, manipulating texts, switching views, formatting texts
4	MS Word format paragraphs, use bullets, create numbered lists, work with borders and shading, find and replace text, correct spelling mistakes, work with page setup, use print preview and print options.
5	Microsoft Word topics: making additions to documents (page number, header and footer, icons, footnote, etc.), dividing text into columns, working with tables, working with pictures and graphics
6	Microsoft Word Applications
7	Microsoft PowerPoint presentations: Working with slides, adding and formatting text and images, working with slide layouts, adding objects to slides
8	Midterm Exam
9	Microsoft Excel topics: Basic operations with workbooks, entering data in worksheets (selecting cells, rows, columns, ranges, adding or removing columns, etc.), formatting characters, cells and numbers, editing and printing sheets
10	Microsoft Excel topics: Using formulas (addition, functions (sum, average, largest, smallest), if, and, if, free calculations), reference types (relative, absolute and mixed references), working with graphs
11	Microsoft Excel topics: Using conditional formatting, sorting data, filtering data
12	Microsoft Excel applications
13	Create a Microsoft Excel Macro
14	MS Excel Makro Applications
15	Ms excel vba applications

Resources	Temel Bilgi Teknolojisi Kullanımı, Ömer Bağcı- İsmail Sarı, Seçkin Yayıncılık, 2008
	TEMEL BİLGİSAYAR EĞİTİMİ, Tugay ARAT, Nesip ERGÜL, Eğitim Yayınevi

In-Term Studies	Quantity	Percentage
Attendance	-	-
Laboratory	-	-
Practice	-	-
Field Study	-	-
Course Specific Internship (If Any)	-	-
Homework	-	-
Presentation	-	-
Projects	-	-
Seminar	-	-
Quiz	-	-
Listening	-	-
Midterms	1	40 (%)
Final Exam	1	60 (%)
Total		100 (%)

	Quantity	Duration	Total Work Load
Course Week Number and Time	14	5	70
Out-of-Class Study Time (Pre-study, Library, Reinforcement)	14	5	70
Midterms	1	14	14
Quiz	0	0	0
Homework	0	0	0
Practice	0	0	0
Laboratory	14	2	28
Project	0	0	0
Workshop	0	0	0
Presentation/Seminar Preparation	0	0	0
Fieldwork	0	0	0
Final Exam	1	14	14
Other	0	0	0
Total Work Load:			196
Total Work Load / 30			6,53
Course ECTS Credits:			7

Relationship Levels
Lowest	Low	Medium	High	Highest
1	2	3	4	5

#	Learning Outcomes	P1	P6	P20
O1	Knows the basic elements of a computer.	4	-	-
O2	Knows how to use at least one of the MS Office tools.	-	5	-
O3	Speaks and presents confidently in front of the public	-	5	-
O4	To be able to define the basic concepts of information technologies and computer systems and to explain the relationships between these concepts.	-	-	-
O5	Ability to effectively use basic software applications (e.g. presentation software, etc.) and prepare professional documents with these tools.	-	-	4