Iğdır University Lifelong Learning Programme

Description of Individual Course Units

Course Unit Code	Course Unit Title	Type of Course Unit	Year of Study	Semester	Number of ECTS Credits
210300401104	BASIC INFORMATION TECHNOLOGIES-I	Compulsory	1	1	2

Level of Course Unit

First Cycle

Objectives of the Course

The aim of this course; information and communication technologies, components of computer systems (processor, input-output units, auxiliary memory units, microcomputers, operating systems and peripherals), communication and computer networks, Internet, computer literacy, word processing applications (Word), presentation applications (Powerpoint), spreadsheet applications (Excel), cloud computing, personal web page preparation, digital citizenship and safe internet use, to provide participants with knowledge and skills on computer ethics and security.

Name of Lecturer(s)

Dr. Turgay DEMİREL

Learning Outcomes

1	Uses the computer ergonomically
2	Performs basic operations in Windows operating system
3	Explain and apply basic concepts about computer and network security
4	Uses the Internet and Internet tools effectively
5	Explain the basic concepts about informatics ethics
6	Uses an email management system and performs basic email operations
7	Performs basic and advanced operations in a word processing program
8	Performs basic and advanced operations in a presentation preparation program
9	Performs basic and advanced operations in a spreadsheet program

Mode of Delivery

Daytime Class

Prerequisites and co-requisities

Recommended Optional Programme Components

Course Contents

 What is a computer? How does it work?  Computer Basics  Using Windows  Computer and Ergonomics  Internet Usage  Use of e-mail  Security and Ethics in Digital Life,  Working with cloud technologies  MS WORD  MS POWERPOINT  MS Excel

Weekly Detailed Course Contents

Week	Theoretical	Practice	Laboratory
1	 Introduction and Course Introduction o Getting acquainted, working on the curriculum o Recording students' e-mails
2	 BASIC CONCEPTS  What is a computer? How does it work?  Computer Basics o Processor, input-output-storage units o Program and File Shortcut icons, folder icons, desktop, my computer, network neighbors, start, taskbar, desktop toolbars, shortcut menus	Watching videos of the week
3	 Using Windows o Desktop components, file-folder operations (selecting, copying, moving, renaming), Formatting disks o Taskbar and start menu o Windows explorer, Windows shortcuts o Control Panel, Keyboard Usage, Windows accessories (calculator, Notepad, Paint)  Computer and Ergonomics o Healthy and ergonomic computer use	Watching videos of the week
4	 Internet Usage o Browsers, search engines, internet addresses o Browsing the Web, Searching the Internet	watching videos of the week
5	 Use of e-mail o Create, send, receive e-mail o CC-BCC concepts, email ethics	Answering Questions
6	 Security and Ethics in Digital Life, o Viruses, worms, spyware o Identity and password management o Rules about computer and Internet ethics	watching videos of the week Answering the given questions
7	 Working with cloud technologies o What is cloud processing? o Cloud Applications o Create, share, edit, take notes, work offline, track changes in Google Drive	Creating and editing a personal web page
8	Midterm exam
9	 MS WORD-1 o Basic window elements  Ribbon, status bar, title bar o Backstage view  Save as, print, protect document, review document etc. o Working with the Ribbon  Tabbed work, menu expansion, contextual menus, hide ribbon, Quick access toolbar, status bar o Document processing  Create new document (CTRL+N), save, close, change views, navigate document (go, find, replace, home, end, pagedown, pageup) o Text operations  Select, delete, navigate with arrow keys, double click, 3 clicks, mini toolbar, select different words with CTRL  Cut-copy-paste, redo-redo-undo, auto-correction o Format texts  Font-paragraph-styles menus, indents, Working with Tabs, Working with Styles, Format painter, bullet and numbering	Word Applications Making a How-To Video
10	 MS WORD-2 o Page Layout and Design Tab  Create margins, section and page break, add columns, add borders and shading  Print preview, print, save as (pdf etc.) o Add Menu  Add header-footer, add page number, add symbol, add field (date-time), add author, add picture-shape-Word art-text box, text wrapping (for figure and table)  Adding Graphics, Smart art, Hyperlinks and bookmarks  Create and edit tables (merge cells, add row-column, calculate) o Review menu  Spelling and grammar, language settings, track changes, compare, annotate	Word Applications Making a How-To Video
11	 MS EXCEL-1 o Basic window elements  Backstage view, working with the ribbon, quick access toolbar, keyboard shortcuts, status bar o Document processing  Open workbook, save, close, navigate, select cells etc. o Formatting a worksheet  Add row-column-cell, delete, resize, hide, add worksheet, delete, move, copy, customize page tabs, add background o Data entry and editing  Enter, edit, auto-complete, auto-fill, move-copy-delete data, undo and redo text-number-date data o Working with formulas and functions  Create formula, create function, use add function tool, autosum, copy formula	Excel Applications
12	 MS EXCEL-2 o Working with formulas and functions  Financial functions, logical functions, text functions, date-time functions, search and reference functions, etc.  Copying the value in the function result o Formatting data  Number formats, font formats, cell alignment, cell styles, copy-change-clear cell formats o Adding Graphs, Drawings and Equations  Adding charts, changing data, changing chart type, adding data labels, adding shapes, etc. o Viewing and Printing the Workbook  Change display settings, split worksheet, sort-filter data, add header-footer, print preview and print, specify print area o Managing the Workbook  Add hyperlink, annotate, save workbook, send by email	Excel Applications
13	 MS POWERPOINT-1 o Basic window elements  Backstage view, working with the ribbon, quick access toolbar, keyboard shortcuts, status bar o Document processing  Opening, saving, closing a presentation, changing the view, etc. o Adding and Formatting Text  Creating new presentation, adding text to slide, font, format painter, bullets, alignment etc. o Customize presentations  Using themes, customizing themes, adding-deleting slides, adding slide master, adding header-footer, adding speaker notes	Powerpoint Applications
14	 MS POWERPOINT-2 o Working with Shapes and Pictures  Drawing tools, adding shapes, adding text to shapes, formatting shapes, aligning shapes, adding action buttons o Adding Objects and Effects  Add table, graphic, smart art, hyperlink, slide transition, animation, custom animation, sound o Publish the Presentation  Custom slide show, rehearse slide show, send presentation, publish presentation, start slide show, print presentation, save as	Powerpoint Applications