CS001 Official Handouts

Table of Contents

Module 01 Introduction ........................................................................................................................................ 4 Hardware ............................................................................................................................................................. 10

Software .............................................................................................................................................................. 17 Pointing Devices .................................................................................................................................................. 19 Storage ................................................................................................................................................................. 21 Security ................................................................................................................................................................ 25 Output ................................................................................................................................................................. 27 Internet ................................................................................................................................................................ 30 Module 02 Introduction ...................................................................................................................................... 33 Introduction to Desktop Environment ................................................................................................................. 40 Organizing Files .................................................................................................................................................... 43 Print Management ............................................................................................................................................... 46

Using Application ................................................................................................................................................. 54 Formatting ........................................................................................................................................................... 58 Tables ................................................................................................................................................................... 62 Preparing Outputs ............................................................................................................................................... 64 Mail Merge .......................................................................................................................................................... 67 Module 04 Introduction ...................................................................................................................................... 70 Saving an Excel File .............................................................................................................................................. 77 Creating Complex Formula .................................................................................................................................. 83 Sorting Data ......................................................................................................................................................... 86 Module 05 Introduction ...................................................................................................................................... 90 Move, Copy or Delete the text ............................................................................................................................ 96 Change Preset Animation Effect ........................................................................................................................ 101 Module 06 Introduction .................................................................................................................................... 107 Web Navigation ................................................................................................................................................. 114 Search Engines ................................................................................................................................................... 118 Email Application ............................................................................................................................................... 120 Electronic Mail ................................................................................................................................................... 127 Mail Management ............................................................................................................................................. 130

Module 01

Introduction to Training Environment & Computer Basics

CPL stands for Computer Proficiency License, also known as VU-CPL. It is a computer based training course offered to all who are interested in learning of the usage of computer applications, after going through this course you will become comfortable and confident about computer usage.

You can become proficient in the knowledge of computer utilization by learning through that is developed specifically for this course. It has six modules.

Module 1 – Introduction to Computers Module 2 – Using the computer and managing files

Module 4 – Spreadsheets Module 5 – Presentation Module 6 – Internet and communication

Objectives

The objective of the above mentioned six modules is to provide sufficient knowledge about the computer and its utilization for you to perform your daily computer related tasks with ease and confidence.

Training Environment of CPL

The website has been developed for this course and it has its own training environment. Homepage has six module wise hyperlinks. You can browse these modules and sub-topics using a mouse click.

What is a computer?

Computer is an electronic device that takes data, instructions and information as input and produce output (information) after processing it.

It is a machine that processes thousands of instructions in less than a second and produces outputs as instructed or programmed.

Advantages of computers

1- Efficiency

Machines are more efficient than humans. They can perform millions of calculations with less effort in no time.

2- Reliability

Work done by computer is more reliable than one done by humans. Computers perform according to the instructions given to it that makes output or results produced by these more accurate and reliable. For example, a computer can do millions of error free calculation in less than a second.

3- Storage

Computers give you an advantage of storing large amount of data in one place. For example, you can store the data of whole library in one computer.

4- Fast results

Computers are capable of doing many difficult tasks in very short time. Every day the processing speed of computers is increasing to make them work faster. Latest computers are capable of performing thousands of instructions and calculation in less than a minute which used to take hours with old PCs.

Basic terms for computer

Input

Whatever goes into the computer is called input. For example, text, graphic sounds, etc. In everyday life the example for input is a voting slip in a ballot.

An input device is any peripheral (piece of computer hardware equipment) used to provide data and instruction to a computer, for example keyboard and microphone. Everyday life example is a hand that is used to put the voting slip in a ballot box. Thus hand is input device for ballot box.

Output

Anything that comes out of a computer is called output. For example sound of a playing video in computer is the output.