COURSE INFORMATON
Course Title Code Semester L+P Hour Credits ECTS
Use of Basic Information Technology * AYH   103 1 1 2 3

Prerequisites and co-requisites
Recommended Optional Programme Components None

Language of Instruction Turkish
Course Level Short Cycle Programmes (Associate's Degree)
Course Type
Course Coordinator Lec. Cemaliye ŞEFLEK
Instructors
Öğr. Gör.HANDAN ŞAPCI1. Öğretim Grup:A
 
Assistants
Goals
The aim of the course is to teach students computer hardware units, basic internet terminology, and Windows operating system as well as providing them necessary skills to use Office softwares.
Content
Introduction to basic information Technologies, What's a computer History of computer, its classifications, types, basic functions, operation logic, system, hardware and software, Microsoft Windows topics: Desktop, task bar, start menu elements, window procedures, basic file/folder operations, folder options, adding and removing items in start menu, desktop customisation, taskbar customisation, start menu programs, all programs, control panel, Microsoft Word topics: writing and saving texts, creating new document, copy/paste/cut/move/highlight functions in text, transition between visuals, formatting text, Microsoft Word topics: paragraph formatting, use of bullet points, creating numeric lists, borders and shades, finding and changing texts, correction of typing errors, working with page layout, print preview and print options, Microsoft Word topics: additions to page (inserting page number, header and footer, symbols, footnote etc.), writing text in columns, working with tables, pictures and graphs. Microsoft Power Point topics: Slides, inserting text and picture, formatting slides, inserting other objects to slides. Microsoft Excel topics: Basic operations with workbooks, data input on spreadsheet (cell, row, column, adding and removing column, row interval etc.), formatting characters, numbers and cells, organising workbook. Microsoft Excel topics: Using formulas, (addition, functions(sum, average, max, min), count, countif, free computations, application types ( relative, absolute and mixed applications), working with graphs. Microsoft Excel topics: Conditional formatting, data sorting, data filtering. Microsoft Excel applications. Internet topics: Basic elements of Internet (Internet protocols, web page, URL, ISP, IP address, Internet address, etc.), usage of Internet Explorer, usage of electronic mail.

Learning Outcomes
-


Course's Contribution To Program
NoProgram Learning OutcomesContribution
12345

Course Content
WeekTopicsStudy Materials _ocw_rs_drs_yontem
1 Introduction to basic information technologies Reading the lecture notes and related resources
2 What's a computer History of computer, its classifications, types, basic functions, operation logic, system, hardware and software Reading the lecture notes and related resources
3 Microsoft Windows topics: Desktop, task bar, start menu elements, window procedures, basic file/folder operations, folder options, adding and removing items in start menu, desktop customisation, taskbar customisation, start menu programs, all programs, control panel. Reading the lecture notes and related resources
4 Microsoft Word topics: paragraph formatting, use of bullet points, creating numeric lists, borders and shades, finding and changing texts, correction of typing errors, working with page layout, print preview and print options. Reading the lecture notes and related resources
5 Microsoft Word topics: paragraph formatting, use of bullet points, creating numeric lists, borders and shades, finding and changing texts, correction of typing errors, working with page layout, print preview and print options. Reading the lecture notes and related resources
6 Microsoft Word topics: additions to page (inserting page number, header and footer, symbols, footnote etc.), writing text in columns, working with tables, pictures and graphs. Reading the lecture notes and related resources
7 Microsoft Power Point topics: Slides, inserting text and picture, formatting slides, inserting other objects to slides. Reading the lecture notes and related resources
8 Mid-Term Exam Yazılı sınav
9 Microsoft Excel topics: Basic operations with workbooks, data input on spreadsheet (cell, row, column, adding and removing column, row interval etc.), formatting characters, numbers and cells, organising workbook. Reading the lecture notes and related resources
10 Microsoft Excel topics: Using formulas, (addition, functions(sum, average, max, min), count, countif, free computations, application types ( relative, absolute and mixed applications), working with graphs. Reading the lecture notes and related resources
11 Microsoft Excel topics: Conditional formatting, data sorting, data filtering. Reading the lecture notes and related resources
12 Microsoft Excel applications Reading the lecture notes and related resources
13 Microsoft Excel applications Reading the lecture notes and related resources
14 Internet topics: Basic elements of Internet (Internet protocols, web page, URL, ISP, IP address, Internet address, etc.), usage of Internet Explorer, Reading the lecture notes and related resources
15 usage of electronic mail (E-mail: MS outlook ve Hotmail) Reading the lecture notes and related resources
16-17 Term Exams

Recommended or Required Reading
Textbook
Additional Resources