Module (Course Syllabus) Catalogue 2019-2020 Essentials.pdf · Module 6: Information and...

Directorate of Quality Assurance and Accreditation خشین‌بو‌تی‌دڵنیایی‌جۆری‌و‌متمانو‌رایو‌بو‌ڕێوه‌بو

Module (Course Syllabus) Catalogue

2019-2020

College/ Institute Erbil Technical Institute

Department Electricity

Module Name Computer Essentials

Module Code COS103 Semester one

Credits

Module type Prerequisite Core Assist.

Weekly hours 3 hours

Weekly hours (Theory) ( 0 )hr Class ( )hr Workload

Weekly hours (Practical) ( 3 )hr Class ( 100 )hr Workload

Lecturer (Theory)

E-Mail & Mobile NO.

Lecturer (Practical) Diman Rahman Muhamad

E-Mail & Mobile NO. [email protected] 07507483752

Y

mailto:[email protected]


Course Book

Course Description

International Computer Driving License (ICDL) is a recognised global standard in end-user computer skills certification. This course provides an introduction to the topics covered in the ICDL Base Profile. Module 1: Basic Concepts of IT: IT Components of a computer, definitions, common computer terms, computer use in everyday life... Module 2: Using the Computer and Managing Files: files Working on a desktop, organising files, simple editing, print features... Module 3:Word Processing: (Microsoft Word) Opening a document, basic operations, styling and editing a document, printing a document... Module 4: Spreadsheets: (Microsoft Excel) Opening a spreadsheet, inputting data, working with formulas/functions, graphs and charts, printing... Module 5: Presentations: (Microsoft PowerPoint) Creating a presentation, formatting text, inserting graphics and images, printing, added effects... Module 6: Information and Communication: (Microsoft Internet Explorer) Getting started on the Internet, Web browsing, E-mail, managing messages...

Course objectives

To cover some of the essential knowledge and skills that makes up the internationally-recognised ICDL Base module. To enable students to gain knowledge of the use of computer the creation of files and management, how they are organised in windows 7. Knowing about RAM &ROM, Classifying Input and Output devices

Creating new document & manipulating them (Open, Close,

Save, insert, delete ...)

Formatting text by using Microsoft Word which is powerful tool to enable students to create any text document which


include special formatting, pictures, tables and more

By using spelling and grammar will allow the user to spot

any spelling errors or potential grammatical errors and style

in their work or the entire document.

Setting up the Excel Environment, modify Columns, Rows

and Cells ,formatting table & text

To enable student to do simple, as well as complex

calculations in Excel.

Enabling student to make presentations by using

PowerPoint.

Student will use outlook as a resource for email

Student's obligation

The students will be asked to work on exercises as class work, homework submissions and quizzes. The practical part will be of main importance to teach the students how to use the computer and know about computer parts, and be able to use Microsoft office packages like Word, Excel, PowerPoint and Outlook.

Required Learning Materials

Software & Hardware Objectives Identify:

A. Software \ ICDL 1. Seven (7) modules of ICDL base will be applied

practically by using Windows 7 & Microsoft Office 2010

2. PowerPoint slides and Word documents for lectures.

B. Hardware 1. Laptop and Computers (lab.). 2. Projector (Data Show). 3. White board.

Assessment scheme

16% Mid Term (Theory and practical) 4% Quiz 14% Home Work 24% Seminar & Project 2% Class activity 25% final practical 15% final theory


Specific learning outcome:

The students will gain some knowledge of the use of Microsoft

Windows 7 Operating System and they will learn the creation

of files and management with Microsoft office packages like

Word, Excel, Power Point, access and outlook.

Classifying Input and Output devices.

Making differences between RAM &ROM.

Installing and uninstalling Application

In Microsoft office Word they will learn to:

Create and Save a document.

Close the document.

Open another existing Word document.

Using copy & paste and drag and drop a word or sentence

Changing the font style, size and color.

Use the Spelling and Grammar command.

Using a text box or shapes.

Inserting clip art or pictures.

Inserting tables

Using numbering and bullets

Using Mail Merge.

In Microsoft office Excel

Anything repeated from word in additions to.

Creating formula using addition, subtraction, multiplication and division operations

Using SUM function, AVG function…..

Formatting tables

Using worksheet data to create chart.

Apply conditional formatting. In Microsoft office PowerPoint

Creating PowerPoint presentation

Inserting text in a slide.

Inserting a picture.

Inserting charts.


Applying an animation effect to text and slides. In Internet or Microsoft office Outlook

How to use Internet Explorer, Web Browsing Web-based

Information (Search)

Search for information on the web, create and edit bookmarks.

Understand Computer Networks, The Internet, and communications.

Identify security concerns when using computers.

E-mail

Course References‌:

الحاسوب و البرمجيات الجاهزة .1

د.ايمن جميل النسور

د.محمد على هاشم

ICDL 4.0دليل التدريب على شهادة .2

اعداد: الجمعية البريطانية للكمبيوتر

http://www.gcflearnfree.org/

http://www.icdlasia.org

http://www.ecdl.org

Course topics (Theory) Week Learning

Outcome

I don’t have theory

Practical Topics Week Learning

Outcome

Hardware definition. The main parts of a computer.

Input/output ports. Computer memory. Types of

Memory. Differences between RAM &ROM.

Storage media. Input devices. Output devices.

Operating System. Application Software. Interface.

1 Increased knowledge in Hardware & Software

http://www.gcflearnfree.org/

http://www.icdlasia.org/

http://www.ecdl.org/


Accessibility Options.

Switching on computer. Understanding Turn Off

dialogue box. Clarifying mouse movement.

Identifying icon types. System information,

changing the appearance of the Desktop, changing

the desktop background, Setting the Screen Saver,

screen resolution and colour quality.

Understanding Control Panels. Changing Date and

Time, volume and Keyboard Layout. Installing and

uninstalling Application. Efficiently Managing files

and folders.

Using help, working with icon, understanding files and folders management, types of files, files compression, file printing.

2 to 3 Good understanding in Windows 7

Word processing. Creating a new document. Inserting text creating and Appling Style. Page setup page, Indentions line & Paragraph, page break, Header and Footer. Creating a number creating bulleted adding border around text adding shading around. Inserting and deleting table (row and column) with all properties. Position an image formatting an image switching between files comparing document Mailing Merge.

4 to 5 Understanding Microsoft Office Word 2010

Create and Save a document.

Close the document.

Open another existing Word document.

Using copy & paste and drag and drop a word or sentence

Changing the font style, size and color.

Use the Spelling and Grammar command.

Using a text box or shapes.


Inserting clip art or pictures.

Inserting tables

Using numbering and bullets

Using Mail Merge.

Starting Microsoft Excel windows of excel work entering in a worksheet. Book getting help selecting cells inserting Row & Column into worksheet. Deleting and adjusting row and columns. Move, deleting, editing cell contents with data undo and redo moving. Sorting data searching and replacing data. Adding border in cells, formatting the background aligning cell contents. Basic functions, formulas and filtering of data. Worksheet margins worksheet header and footer scaling worksheet. How to create a chart with examples.

6 to 8 Good use of Microsoft Office Excel 2010

Creating formula using addition, subtraction, multiplication and division operations

Using SUM function, AVG function…..

Formatting tables

Using worksheet data to create chart.

Apply conditional formatting.

Presentation Power Point Windows. Zoom help system navigation between slides. Inserting new slide undo & redo bulleted slide creating blink slide. Chang the layout of a slide. Themes changes the font type and size color shadow effect. Creating a table, table style and effects, inserting a clip Art. Insert shapes SmartArt, Chart, free rotation flipping a draw object. Align draw object slider footer animation effects custom transition effects. Moving, coping, deleting, hiding and showing slides, slides setup, printing slides and templates.

9 to 10 Using Microsoft Office PowerPoint 2010

Creating PowerPoint presentation

Inserting text in a slide.

Inserting a picture.

Inserting charts.

Applying an animation effect to text


and slides.

Introduction internet. Introduction to emailing system. Searching via internet. Internet application (Google products) Introduction to network security. Protection and security.

11 to 12 Good knowledge in Internet & Network security

How to use

Internet

Explorer, Web

Browsing Web-

based

Information

(Search)

Search for information on the web, create and edit bookmarks.

Understand Computer Networks, The Internet, and communications.

Identify security concerns when using computers.

E-mail

Questions Example Design


Answer


Extra notes: Even though the main course is practical, I feel we need to spend more time explaining the theoretical portions of the subject, especially to focus on Windows. Because the first year students start late, we will not have enough time to go through the topics in detail.

External Evaluator I have been reviewed this course book. It’s perfect and feet for this subject in the level of institute student. Salar Ismael Ahmad (Assistant Lecturer) MSC. Of Electrical and Electronic Engineering. 13/11/2019

Module (Course Syllabus) Catalogue 2019-2020 Essentials.pdf · Module 6: Information and...

Documents

Transcript of Module (Course Syllabus) Catalogue 2019-2020 Essentials.pdf · Module 6: Information and...