Course Information Semester Course Code Course Title T+P+L Credit ECTS 1 03810103 Information Technologies 4+1+1 7 7 Course Details Language : Turkish Level : Associate Degree Department / Program : Computer Programming Mode of Delivery : Face to Face Type : Compulsory Objectives : It is to enable students to use the computer more effectively by providing basic computer knowledge and making applications. Content : Basic computer knowledge, MS Word, MS Excel, MS Powerpoint Methods & Techniques : Prerequisites and co-requisities : None Course Coordinator : None Name of Lecturers : Instructor Özlem AKARÇAY Assistants : None Work Placement(s) : No Recommended or Required Reading Resources : TEMEL BİLGİSAYAR EĞİTİMİ, Tugay ARAT, Nesip ERGÜL, Eğitim YayıneviTemel Bilgi Teknolojisi Kullanımı, Ömer Bağcı- İsmail Sarı, Seçkin Yayıncılık, 2008 Course Category Mathematics and Basic Sciences 10% Engineering 10% Engineering Design 10% Field 70% In-Term Study Informations In-Term Studies Quantity Percentage Mid-terms 1 30% Final examination 1 70% Total 2 100% Activity Informations Activities Quantity Duration Total Work Load Course Duration 14 3 42 Hours for off-the-c.r.stud 14 2 28 Assignments 1 6 6 Mid-terms 1 10 10 Practice 14 1 14 Final examination 1 10 10 Total Work Load ECTS: 7 110 Course Learning Outcomes Upon the successful completion of this course, students will be able to: No Learning Outcomes 1 Provide information about the basic concepts of the computer 2 Must be able to use MS Office programs at an advanced level Weekly Detailed Course Contents 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 Contribution of Learning Outcomes to Programme Outcomes P1P2P3P4P5P6P7P8P9P10P11P12P13P14P15P16P17P18 All 533355225222225255 C1 533355225222225255 C2 533355225222225255 bbb