Computer Module JKSSB
Computer Module JKSSB
COMPUTERS
USEFUL FOR
ALL EXAMS OF JKSSB ; JKPSC- Assistant Registrar
Cooperative Societies.
© Vidhya Tutorials
“The right signal is that
technology is going to boost
(economic) development of our
nation”
Dr. APJ Abdul Kalam
© Vidhya Tutorials
© Vidhya Tutorials
Knowledge of Computers
Basic Applications of
TABLE OF CONTENTS
Computer and its component.
Fundamentals of computer
sciences.
Hardware & Software.
Input & output Devices.
CPU (Central processing unit )
Memory Units.
Operating System.
Open Source Technology.
Computer Virus and Anti-
Virus.
Firmware and Human-ware.
Knowledge of MS Word, MS
Excel, MS Access, MS
Powerpoint, PDF
Internet.
E-mail.
E-Governance (Role of
Information Technology in
Governance) in India.
© Vidhya Tutorials
VIDHYA TUTORIALS
“EDUCATION YOU CAN BELIEVE IN”
[Link]
9419595009 ; 6006367330.
9419595009 ; 6006367330.
@ vidhyatutorialsjkssb
[Link]@[Link]
Vidhya Tutorials
Coming Soon
HTTPS://[Link]/VIDHYA_TUTORIALSJKSSB
VIDHYA TUTORIALS
“EDUCATION YOU CAN BELIEVE IN”
SYLLABUS…
ASSISTANT REGISTRAR
COOPERATIVE SOCIETIES
HTTPS://[Link]/VIDHYA_TUTORIALSJKSSB
Basic Applications of Computer and its
component.
Fundamentals of computer sciences.
What is a computer?
The term computer was taken from the
Greek word compute means calculation
and the computer was a person or device
that did computation. A computer is a
machine used to manipulate data or
information and perform mathematical and
logical operations. Modern computers
perform a wide range of tasks, store
retrieve, and process information. Using a
computer we can create/modify
documents, send/receive emails, browse
information on the internet, and play video
games. After the invention of computer
science and technology became too
advanced. Today we can not imagine
growing our technology without computers.
COMPUTER stands for Common Operating Machine Purposely Used
for Technological and Educational Research. It is only a myth
because first this definition does not make any sense and second
when the computer were invented they were just calculating
machines which needs a lot of space for establishment.
Functions of Computers
A computer performs the following functions −
Receiving Input
Data is fed into computer through various input devices like keyboard, mouse, digital pens, etc.
Input can also be fed through devices like CD-ROM, pen drive, scanner, etc.
Processing the information
Operations on the input data are carried out based on the instructions provided in the programs.
Storing the information
After processing, the information gets stored in the primary or secondary storage area.
Producing output
The processed information and other details are communicated to the outside world through
output devices like monitor, printer, etc.
© VIDHYA TUTORIALS | 20
© Vidhya Tutorials | 06
Knowledge of Computers Basic Applications of Computer and its component.
Fundamentals of computer sciences.
COMPONENTS OF
THE COMPUTER
SYSTEM
The various components of the computer system are classified into two groups.
Hardware
Software
1. Hardware:
Hardware is the physical tangible component of the computer system. This type of component is
touchable. CPU, Mouse, Keyboard are examples of hardware components. So, the hardware of
the computer system are:
Input Device:
Input devices allow the user to enter data/information in the CPU (Central Processing Unit).
Mouse, Keyboard, scanner, barcode reader are general examples of input devices.
Output Device:
Output devices input the processed data/information into human-readable form. Monitor,
speaker, projector, printer are general examples of output devices.
Central Processing Unit (CPU):
The CPU is referred to as the brain of a computer system. It is used to processed
data/information and provides output to output devices. The CU (control unit), ALU (arithmetic
and logical unit), and registers are components of the CPU.
Storage:
In a computer, storage devices are used to store the data or information that entered into the
computer system and the output comes from processing the information or data.
Computer memory refers to storage area where data is stored. It is of two types Primary Memory
& Secondary Memory.
2. Software:
Software is a collection of programs (set of instructions), data, and protocols. It is not in
material form so we can not touch such types of components. The execution of software
programs is performed by hardware. Firmware, operating systems, applications are examples of
software.
© Vidhya Tutorials | 07
Basic Applications of Computer and its component. Knowledge of Computers
Fundamentals of computer sciences.
FEATURES OF
COMPUTER
Memory: A computer can store billions of records as per requirement and these
records can easily accessible with full accuracy. The storing capacity of computer
memory is measured in terms of Bytes, Kilobytes (KB), Megabytes (MB), Gigabyte(GB),
and Terabyte(TB).
Versatility: A computer can perform more than one task at the same time, this feature
is called versatility. For example, we can create our project using PowerPoint and
Wordpad while listening to music or we can design a website while listening to music.
Reliability: A computer is a reliable device. The output results never differ until the
input is different. If an input is the same then output won’t be different.
Diligence: A human can not work for several hours without taking a rest whereas a
computer device never gets tired. A computer can perform millions of calculations
constantly with full accuracy without taking a rest.
© Vidhya Tutorials | 08
Knowledge of Computers Basic Applications of Computer and its component.
Fundamentals of computer sciences.
HISTORY OF
COMPUTER
© Vidhya Tutorials | 09
Basic Applications of Computer and its component.
Knowledge of Computers
Fundamentals of computer sciences.
COMPUTER
GENERATIONS
Classification of generations of computers
The evolution of computer technology is often divided into five generations.
© Vidhya Tutorials | 10
Knowledge of Computers Basic Applications of Computer and its component.
Fundamentals of computer sciences.
COMPUTER
GENERATIONS
Third Generation of Computers
© Vidhya Tutorials | 11
Basic Applications of Computer and its component. Knowledge of Computers
Fundamentals of computer sciences.
COMPUTER
GENERATIONS
Fifth Generation of Computers
The main characteristics of fifth generation of computers (the present and the
future)
Main electronic component: based on artificial intelligence, uses the Ultra
Large-Scale Integration (ULSI) technology and parallel processing method.
ULSI – millions of transistors on a single microchip
Parallel processing method– use two or more microprocessors to run tasks
simultaneously.
Language – understand natural language (human language).
Power – consume less power and generate less heat.
Speed – remarkable improvement of speed, accuracy and reliability (in
comparison with the fourth generation computers).
Size – portable and small in size, and have a huge storage capacity.
Input / output device – keyboard, monitor, mouse, trackpad (or touchpad),
touchscreen, pen, speech input (recognise voice / speech), light scanner, printer,
etc.
Example – desktops, laptops, tablets, smartphones, etc.
© Vidhya Tutorials | 12
Knowledge of Computers Basic Applications of Computer and its component.
Fundamentals of computer sciences.
CLASSIFICATION
OF COMPUTER
BASED ON SIZE
On the basis of size, computers are categorised as follows
Micro Computer
Microcomputers are small computer which are specifically designed for personal and office use. They
are usually inexpensive and have minimum storing and processing speed. Some common examples are
laptop or desktop, Hanheld/ Palmtop, Tablet Computer, Working Station Computer, etc.
Mini Computer
Minicomputers are more powerful than a microcomputer. They have faster memory with better-operating
speeds and large storage capacities than microcomputers. They are generally used as a server and are
capable of supporting up to 200 users. Minicomputers are IBM-17, DEC PDP-11, HP-9000, etc.
Mainframe Computer
Mainframe computers are those types of computers which have very high memory and processing
speed. Hence Mainframe computers are used as a server since they can support thousands of users.
Mainframe computers are IBM-370, IBM-S/390, UNIVAC-1110, etc.
Super computer
Supercomputers are the most powerful computers which are used mainly for the purpose of difficult
problem-solving requirements. Hence Supercomputers are used in times of research, weather
forecasting and Weapon designing and much more.
The first successful supercomputer: CDC 6600
The fastest supercomputer in the world: Sunway TaihuLight of China
India’s first Super Computer: PARAM-8000 which was developed by CDAC Pune in 1998.
India’s fastest super computer: Shasra T which was manufactured by IIS (Indian Institute of
Science).
© Vidhya Tutorials | 13
Basic Applications of Computer and its component. Knowledge of Computers
Fundamentals of computer sciences.
CLASSIFICATION
OF COMPUTER
BASED ON WORK
On the basis of work, computers are categorised as follows
Analog Computer
It was Lord Kelvin who first introduced the Analog computer. In such a computer numerical data are
represented by physical variables which can be measured, for example, electrical voltage. A
thermometer is a very good example analog computer.
Digital Computer
A certain type of computer that accepts data and processes it in the form of numbers is popularly known
as a Digital Computer. In such a computer all the characters are converted into binary code.
Hybrid Computer
A computer which has the features of analogue, as well as the digital machine, is known as a
Hybrid Computer. The hybrid computer is generally noticed in the geological departments.
BASED ON PURPOSE
On the basis of purpose, computers are categorised as follows
© Vidhya Tutorials | 14
Knowledge of Computers Basic Applications of Computer and its component.
Fundamentals of computer sciences.
APPLICATIONS
OF COMPUTER
Some of the areas where computers are being used are as follows
Banking :- Computers are used in bank for electronic money transfer, making deposits,
voucher, bank sheet, etc.
Home :- Computers are used at homes for several purposes like online bill payment, watching
movies or shows at home, home tutoring, social media access, playing games, internet
access, etc. They provide communication through electronic mail. They help to avail work from
home facility for corporate employees. Computers help the student community to avail online
educational support.
Medical Field :- Computers are used in hospitals to maintain a database of patients’ history,
diagnosis, X-rays, live monitoring of patients, etc. Surgeons nowadays use robotic surgical
devices to perform delicate operations, and conduct surgeries remotely. Virtual reality
technologies are also used for training purposes. It also helps to monitor the fetus inside the
mother’s womb.
Government :- In government sectors, computers are used in data processing, maintaining a
database of citizens and supporting a paperless environment. The country’s defense
organizations have greatly benefitted from computers in their use for missile development,
satellites, rocket launches, etc.
Training :- Many organizations use computer-based training to train their employees, to save
money and improve performance. Video conferencing through computers allows saving of
time and travelling costs by being able to connect people in various locations.
Arts :- Computers are extensively used in dance, photography, arts and culture. The fluid
movement of dance can be shown live via animation. Photos can be digitized using computers.
Science and Engineering :- Computers with high performance are used to stimulate dynamic
process in Science and Engineering. Supercomputers have numerous applications in area of
Research and Development (R&D). Topographic images can be created through computers.
Scientists use computers to plot and analyze data to have a better understanding of
earthquakes.
Education :- Computer is a very effective tool which can be used for teaching and learning,
result processing, student data processing, notes preparation, etc.
Entertainment :- Different types of entertainment fields such as multimedia, film making with
animation, graphics, audio and visual design are done with the help of computer.
Offices :- Computers are used for preparing reports, storing/deleting reports, updating
reports, etc. in office.
Advertisement :- Computers are used in the different fields of advertisement such as business
advertisement, film advertisement, education advertisement, etc.
Business :- Computers are used in business for accounting, keeping all records up-to date,
etc.
© Vidhya Tutorials | 15
HARDWARE & SOFTWARE.
HARDWARE
HARDWARE REPRESENTS THE PHYSICAL AND TANGIBLE COMPONENTS OF A COMPUTER, I.E. THE
COMPONENTS THAT CAN BE SEEN AND TOUCHED.
EXAMPLES OF HARDWARE ARE THE FOLLOWING −
INPUT DEVICES − KEYBOARD, MOUSE, ETC.
OUTPUT DEVICES − PRINTER, MONITOR, ETC.
SECONDARY STORAGE DEVICES − HARD DISK, CD, DVD, ETC.
INTERNAL COMPONENTS − CPU, MOTHERBOARD, RAM, ETC.
© Vidhya Tutorials | 16
Knowledge of Computers HARDWARE & SOFTWARE.
SOFTWARE
SOFTWARE IS A SET OF PROGRAMS, WHICH IS DESIGNED TO PERFORM A WELL-DEFINED FUNCTION. A
PROGRAM IS A SEQUENCE OF INSTRUCTIONS WRITTEN TO SOLVE A PARTICULAR PROBLEM.
THERE ARE TWO TYPES OF SOFTWARE −
SYSTEM SOFTWARE
APPLICATION SOFTWARE
SYSTEM SOFTWARE
The system software is a collection of programs designed to operate, control, and extend the processing
capabilities of the computer itself. System software is generally prepared by the computer
manufacturers. These software products comprise of programs written in low-level languages, which
interact with the hardware at a very basic level. System software serves as the interface between the
hardware and the end users.
Some examples of system software are Operating System, Compilers, Interpreter, Assemblers, etc.
© Vidhya Tutorials | 17
Hardware & Software.
Knowledge of Computers
APPLICATION
SOFTWARE
Application software products are designed to satisfy a particular need of a particular environment.
All software applications prepared in the computer lab can come under the category of Application
software.
Application software may consist of a single program, such as Microsoft's notepad for writing and
editing a simple text. It may also consist of a collection of programs, often called a software
package, which work together to accomplish a task, such as a spreadsheet package.
© Vidhya Tutorials | 18
Knowledge of Computers Hardware & Software.
RELATIONSHIP BETWEEN
HARDWARE AND SOFTWARE
Hardware and software are mutually dependent on each other. Both of them must work together to
make a computer produce a useful output.
Software cannot be utilized without supporting hardware.
Hardware without a set of programs to operate upon cannot be utilized and is useless.
To get a particular job done on the computer, relevant software should be loaded into the hardware.
Hardware is a one-time expense.
Software development is very expensive and is a continuing expense.
Different software applications can be loaded on a hardware to run different jobs.
A software acts as an interface between the user and the hardware.
If the hardware is the 'heart' of a computer system, then the software is its 'soul'. Both are
complementary to each other.
© Vidhya Tutorials | 19
Knowledge of Computers
Elements of Computers Processing System Hardware
COMPUTER
ARCHITECTURE
Computer architecture deals with the functional behaviour of a computer system as viewed by a
programmer. It can also be described as the logical structure of the system unit that housed
electronic components. The computer architecture forms the backbone for building successful
computer systems. The first computer architecture was introduced in 1970.
COMPONENTS OF COMPUTER
A COMPUTER CONSISTS OF FOLLOWING THREE MAIN COMPONENTS
COMPUTER ARCHITECTURE
1. INPUT/OUTPUT (I/O) UNIT
2. CENTRAL PROCESSING UNIT
3. MEMORY UNIT
Data: Data that the computer takes in and processes data can be of various types such as numbers,
texts, images etc.
Users: Human or other devices or programs that operates the computer with instructions.
Procedures: Computer processes data to generate information or data for another another process.
© Vidhya Tutorials | 20
INPUT & OUTPUT DEVICES.
Input and output devices act as an interface between the user and the computer. A device sends
information to a computer system for processing, such device is called as an input device and a
device that receives and then reproduces or displays the results of that processing is called an
output device.
Most devices are either input devices or output devices because they can only accept data input
from a user and forward the same to the computer system or receive the output data from the
computer. There are some devices which are capable of both accepting input and handling
output, these types of devices are called I/O devices (input/output devices). Input-output devices
are also called as peripherals.
© Vidhya Tutorials | 21
Knowledge of Computers
Input & output Devices.
WHAT
ARE INPUT DEVICES
Input devices can send data or information to a computer or another
device. Input devices cannot receive data or signal from some other
devices. Various input devices are as listed below:
Keyboard: It is an input device which sends data into the computer.
The data send depends on the key pressed by the user.
Scanner: Scanner optically reads and document, file or image and then
changes it into a digital signal and sends to the computer.
© Vidhya Tutorials | 22
Knowledge of Computers
Input & output Devices.
WHAT ARE
OUTPUT DEVICES
A device that can receive data from a computer or another device and create output with that
data is called an output device. Examples of various output devices are as :
Monitor: A monitor is an output device that is responsible for receiving data from a computer
and displaying that information as text or images for users to see.
Printer: A printer is an output device that generates a hard copy of the electronic data stored
on a computer or any other device.
Projector: Gets data from a computer and displays or projects the same information onto a
screen or a wall. A ,projector cannot directly accept data from a user and send that data to
another device.
Speakers: Receives sound signal from a computer and then plays that sound signal and thus
we hear songs or music or any other audio.
© Vidhya Tutorials | 23
Knowledge of Computers
Input & output Devices.
PERIPHERALS [INPUT /
OUTPUT (I/O)] DEVICES
An input/output device is capable of receiving data from users or
another device and also sending data to other devices or
computers. That means devices which can be used as both input
device and output device are called Input / Output (I/O) devices.
Some examples of input/output devices are:
USB drive: Also known as a pen drive or flash stick works as
both an input device to the computer and as an output device.
USB drives receive or save data from a computer as an input
and it can also send data to a computer or another device.
© Vidhya Tutorials | 24
Central Processing Unit
(CPU)
It consists a set of registers, arithmetic logic unit and control unit, which together interpret and
execute instructions in assembly language.
The primary functions of the CPU are as follows :-
(i) The CPU transfers instructions and input data from main memory to registers, i.e. internal
memory.
(ii) The CPU executes the instructions in the stored sequence.
(iii) When necessary, CPU transfers output data from registers to main memory.
(iii) Bit-shifting operations (shifting or rotating a word by a instructions that are being used
specified number of bit to the left or right with or without sign immediately by the CPU. These
registers are the top of the memory
extension). hierarchy and are the fastest way for
the system to manipulate data. The
(iv) Comparison operations (=, <, < =, >, > =). number and size of registers vary
from processor to processor.
© Vidhya Tutorials | 25
Knowledge of Computers
Central Processing Unit (CPU)
© Vidhya Tutorials | 26
MEMORY
A memory is just like a human brain. It is used to store data and instructions. Computer memory
is the storage space in the computer, where data is to be processed and instructions required
for processing are stored. The memory is divided into large number of small parts called cells.
Each location or cell has a unique address, which varies from zero to memory size minus one. For
example, if the computer has 64k words, then this memory unit has 64 * 1024 = 65536 memory
locations. The address of these locations varies from 0 to 65535.
1. Cache Memory
Cache memory is a very high speed semiconductor memory which can speed up the CPU. It acts
as a buffer between the CPU and the main memory. It is used to hold those parts of data and
program which are most frequently used by the CPU. The parts of data and programs are
transferred from the disk to cache memory by the operating system, from where the CPU can
access them.
Advantages
The advantages of cache memory are as
follows −
Cache memory is faster than main
memory.
It consumes less access time as
compared to main memory.
It stores the program that can be
executed within a short period of
time.
It stores data for temporary use.
Disadvantages
The disadvantages of cache memory are
as follows −
Cache memory has limited capacity.
It is very expensive.
© Vidhya Tutorials | 27
Knowledge of Computers
Memory Unit
RAM ROM
Types of ROMs
1. MROM (Masked ROM)
2. PROM (Programmable Read Only Memory)
Only Memory)
4. EEPROM (Electrically Erasable and
© Vidhya Tutorials | 28
Knowledge of Computers
Memory Unit
Features of Motherboard
A motherboard comes with following features −
Motherboard varies greatly in supporting various types of components.
Motherboard supports a single type of CPU and few types of memories.
Video cards, hard disks, sound cards have to be compatible with the motherboard to function
properly.
Motherboards, cases, and power supplies must be compatible to work properly together.
Components on Motherboard
Various components on motherboard are as
follows
1. CMOS Battery
2. Fan
3. SMPS
4. Processor Chip
5. BIOS Chip
6. Expansion Slot
7. PCI Slot
8. Buses
Memory Units
© Vidhya Tutorials | 29
Knowledge of Computers
Memory Unit
Motherboard
© Vidhya Tutorials | 30
OPERATING SYSTEM
Memory management refers to management of Primary Memory or Main Memory. Main memory
is a large array of words or bytes where each word or byte has its own address.
Main memory provides a fast storage that can be accessed directly by the CPU. For a program to
be executed, it must in the main memory. An Operating System does the following activities for
memory management −
Keeps tracks of primary memory, i.e., what part of it are in use by whom, what part are not in
use.
In multiprogramming, the OS decides which process will get memory when and how much.
Allocates the memory when a process requests it to do so.
De-allocates the memory when a process no longer needs it or has been terminated.
© Vidhya Tutorials | 31
Knowledge of Computers
Operating System
2. PROCESSOR MANAGEMENT
In multiprogramming environment, the OS decides which process gets the processor when and
for how much time. This function is called process scheduling. An Operating System does the
following activities for processor management −
Keeps tracks of processor and status of process. The program responsible for this task is
known as traffic controller.
Allocates the processor (CPU) to a process.
De-allocates processor when a process is no longer required.
3. DEVICE MANAGEMENT
An Operating System manages device communication via their respective drivers. It does the
following activities for device management −
Keeps tracks of all devices. Program responsible for this task is known as the I/O controller.
Decides which process gets the device when and for how much time.
Allocates the device in the efficient way.
De-allocates devices.
4. FILE MANAGEMENT
A file system is normally organized into directories for easy navigation and usage. These
directories may contain files and other directions.
An Operating System does the following activities for file management −
Keeps track of information, location, uses, status etc. The collective facilities are often
known as file system.
Decides who gets the resources.
Allocates the resources.
De-allocates the resources.
5. SECURITY
Recording delays between request for a service and response from the system.
7. JOB ACCOUNTING
Keeping track of time and resources used by various jobs and users.
Production of dumps, traces, error messages, and other debugging and error detecting aids.
© Vidhya Tutorials | 32
Knowledge of Computers
Operating System
© Vidhya Tutorials | 33
Knowledge of Computers
Operating System
Internal Commands :- These commands are automatically loaded into main memory when the
booting process gets completed. e.g. DATE, TIME, VER, VOL, DIR, COPY, CLS, etc.
External Commands :- These commands require external files to be loaded in the computer to
run. e.g. Checking disk, comparing disk, formatting, etc.
© Vidhya Tutorials | 34
OPEN SOURCE TECHNOLOGIES
The term open source refers to something people can Open source software refers to a
computer program or an application
modify and share because its design is publicly in which the source code is open and
accessible. available to the public:
for use, modification or
redistribution
under an open source licence
usually free of charge
In simple terms open-source software is software whose source code is published and
made available to the public, enabling anyone to copy, modify and redistribute the source
code without paying royalties or fees. Open-source code can evolve through community
cooperation. These communities are composed of individual programmers as well as large
companies.
Linux, Apache, MYSQL & PHP are the some of the open soucre software services Benefitz
use for the delevlopment and hosting of our popular BWEB Content Management Software.
ADVANTAGES DISADVANTAGES
Open source software is free. Open source can be harder to use and
Open source is flexible; developers adopt due to difficulty setting it up and
can examine how the code works and the lack of friendly user interfaces.
freely make changes to dysfunctional Open source can pose compatibility
or problematic aspects of the issues. When attempting to program
application to better fit their unique proprietary hardware with OSS, there is
needs. often a need for specialized drivers that
Open source is stable; the source are typically only available from the
code is publicly distributed, so users hardware manufacturer.
can depend on it for their long-term Open source software can pose liability
projects since they know that the issues. Unlike commercial software,
code’s creators cannot simply which is fully controlled by the vendor,
discontinue the project or let it fall open source rarely contains any
into disrepair. warranty, liability, or infringement
Open source fosters ingenuity; indemnity protection. This leaves the
programmers can use pre-existing consumer of the OSS responsible for
code to improve the software and even maintaining compliance with legal
come up with their own innovations. obligations.
Open source comes with a built-in Open source can incur unexpected
community that continuously modifies costs in training users, importing data,
and improves the source code. and setting up required hardware.
Open source provides great learning
opportunities for new programmers.
© Vidhya Tutorials | 35
Knowledge of Computers
Open Source Technologies
© Vidhya Tutorials | 36
Knowledge of Computers
Open Source Technologies
Images/multi-media
GIMP - image processing/graphics editing
VLC - multimedia file playback
Ogg - open video and audio codecs
Blender - animation and video editor
© Vidhya Tutorials | 37
Open Source Technologies
Knowledge of Computers
© Vidhya Tutorials | 38
COMPUTER VIRUS & ANTI-VIRUS
Since the computer virus only hits the programming of the device, it is not visible. But there are
certain indications which can help you analyse that a device is virus-hit. Given below are such
signs which may help you identify computer viruses:
Speed of the System – In case a virus is completely executed into your device, the time taken
to open applications may become longer and the entire system processing may start
working slowly
Pop-up Windows – One may start getting too many pop up windows on their screen which
may be virus affected and harm the device even more
Self Execution of Programs – Files or applications may start opening in the background of
the system by themselves and you may not even know about them
Log out from Accounts – In case of a virus attack, the probability of accounts getting hacked
increase and password protected sites may also get hacked and you might get logged out
from all of them
Crashing of the Device – In most cases, if the virus spreads in maximum files and programs,
there are chances that the entire device may crash and stop working
Boot Sector Virus – It is a type of virus that infects the boot sector of floppy disks or the
Master Boot Record (MBR) of hard disks. The Boot sector comprises all the files which are
required to start the Operating system of the computer. The virus either overwrites the
existing program or copies itself to another part of the disk.
Direct Action Virus – When a virus attaches itself directly to a .exe or .com file and enters
the device while its execution is called a Direct Action Virus. If it gets installed in the
memory, it keeps itself hidden. It is also known as Non-Resident Virus.
Resident Virus – A virus which saves itself in the memory of the computer and then infects
other files and programs when its originating program is no longer working. This virus can
easily infect other files because it is hidden in the memory and is hard to be removed from
the system.
© Vidhya Tutorials | 39
Knowledge of Computers
Computer Virus & Anti-Virus
Multipartite Virus – A virus which can attack both, the boot sector and the executable files
of an already infected computer is called a multipartite virus. If a multipartite virus
attacks your system, you are at risk of cyber threat.
Overwrite Virus – One of the most harmful viruses, the overwrite virus can completely
remove the existing program and replace it with the malicious code by overwriting it.
Gradually it can completely replace the host’s programming code with the harmful code.
Polymorphic Virus –Spread through spam and infected websites, the polymorphic virus are
file infectors which are complex and are tough to detect. They create a modified or
morphed version of the existing program and infect the system and retain the original
code.
File Infector Virus – As the name suggests, it first infects a single file and then later
spreads itself to other executable files and programs. The main source of this virus are
games and word processors.
Spacefiller Virus – It is a rare type of virus which fills in the empty spaces of a file with
viruses. It is known as cavity virus. It will neither affect the size of the file nor can be
detected easily.
Macro Virus – A virus written in the same macro language as used in the software program
and infects the computer if a word processor file is opened. Mainly the source of such
viruses is via emails.
What is an Anti-Virus?
An anti-virus is a software which comprises programs or set of programs which can detect
and remove all the harmful and malicious software from your device. This anti-virus software
is designed in a manner that they can search through the files in a computer and determine
the files which are heavy or mildly infected by a virus.
Given below is a list of few of the major antivirus software which is most commonly used:
Norton Antivirus
F-Secure Antivirus
Kaspersky Antivirus
AVAST Antivirus
Comodo Antivirus
McAfee Antivirus
These are few of the many anti-virus software widely used to remove viruses from a device.
© Vidhya Tutorials | 40
FIRMWARE AND HUMAN-WARE.
What is a Firmware ?
Firmware is a software program or set of instructions programmed on a hardware device. It
provides the necessary instructions for how the device communicates with the other computer
hardware. Firmware is typically stored in the flash ROM of a hardware device. While ROM is
“read-only memory,” flash ROM can be erased and rewritten because it is actually a type of
flash memory.
© Vidhya Tutorials | 41
Knowledge of Computers
Firmware and Human-ware.
What is an Humanware ?
Humanware is hardware and software that emphasizes user capability and empowerment
and the design of the user interface. The process of building humanware generally consists of
these steps:
1. Define users (age, mindset, environmental context, previous product experience and
3. Specify usability objectives (if possible, these should be measurable, such as how long to
do something or how many mouse clicks to get to a specified task point) for each task or
capability.
4. Build a prototype of the user interface (it can be a paper or simulated prototype if time is
short).
5. Test and verify or correct the prototype.
6. Provide the prototype and usability objectives to the program designers and coders.
7. Test the code against the prototype and objectives and, if necessary, redesign or recode
the software.
8. Test the product with users or valid test subjects and revise as necessary.
© Vidhya Tutorials | 42
KNOWLEDGE OF MS WORD, MS EXCEL,
MS ACCESS, MS POWERPOINT.
What is a Microsoft
Office ?
Microsoft Office, or simply Office, is a family of client software, server software, and services
developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in
Las Vegas. Initially a marketing term for an office suite (bundled set of productivity
applications), the first version of Office contained Microsoft Word, Microsoft Excel, and
Microsoft PowerPoint.
© Vidhya Tutorials | 43
Knowledge of MS Word, MS Excel, Knowledge of Computers
MS Access, MS Powerpoint.
What is MS Word?
Used to make professional-quality documents, letters, reports,
etc., MS Word is a word processor developed by Microsoft. It
has advanced features which allow you to format and edit
your files and documents in the best possible way.
Components of MS Word.
(i) Title Bar :- It shows the name of the application and name of the file. It consists of three control
buttons, i.e.
Minimize (reduces the window but Word still active)
Restore (brings Word window to the maximum original size)
Close (Close the word window)
(ii) Standard Tool Bar :- It displays the symbol for the common operation like Open, Print, Save, etc.
(iii) Ribbon :- It is a set of tools and commands across the top of the screen. It consists of a panel
of commands which are organised into a set of tabs.
© Vidhya Tutorials | 44
Knowledge of Computers Knowledge of MS Word, MS
Excel, MS Access, MS Powerpoint.
(iv) Tab On the ribbon, it contains the buttons needed to edit characters, text and layout.
Home tab Consists of Clipboard (Cut, Copy, Paste), Font (Size, Color, Bold, Italic, Underline),
Paragraph (Bullets/ Numbering, Indent), Styles, Editing (Find and Replace).
Insert tab Consists of Pages (Cover Page, Blank Page, Page Break), Tables (Table), Illustrations
(Picture, ClipArt, Shapes, SmartArt, Chart), Links (Hyperlink, Book mark, cross-referenec),
Header & Footer, Text (TextBox, Date & Time, Object), Symbols (Equation, Symbol).
Page Layout tab Consists of Themes, Page Setup, Page Background, Paragraph, Arrange.
References tab Consists of Table of Contents, Footnotes, Citations & Bibliography, Captions,
Index, Table of Authorities.
Mailings tab Consists of Create, Start Mail Mrge, Write and Insert Fields, Preview Results and
Finish.
Review tab Consists of Proofing (Spelling & Grammar, Thesaurus, Translate), Comments,
Tracking, Changes, Compare, Protect.
View tab Consists of Document Views (Print Layout, Full Screen Reading), Show/Hide, Zoom,
Window, Macros, etc.
(v) Ruler :- It appears on the top of the document window. It allows to format the horizontal or
vertical alignment of text in a document.
(vi) Status Bar :- It displays the information such as page number, current page, current template,
column number and line number, etc.
(vii) Work Area :- It is the rectangular area of the document window that can be use to type the
text. It is also called as workplace.
(viii) Cursor :- It is also called insertion pointer. It denotes the place where text, graphics or any
other item would be placed when you type, overwrite or insert them.
© Vidhya Tutorials | 45
Knowledge of MS Word, MS Excel, MS Knowledge of Computers
Access, MS Powerpoint.
other place.
2. Format Text :- It offers to modify the text in any of the available hundreds of text designs. It
formats text in various styles such as bold, italic, underline, etc.
3. Indentation :- It denotes the distance text boundaries and page margins. It offers three types
vertical view on a specified size of the page. Word offers Portrait–vertically oriented and
Landscape–horizontally oriented.
5. Find and Replace :- This feature allows flexibility and comfort to the user to replace a text
and tables of content. Bullets are arranged in unordered lists and numbering are arranged in
ordered lists.
9. Graphics :- It provides the facility of incorporating drawings in the documents which
share information between programs through objects. Objects save entities like charts,
equations, video clips, audio clips, pictures, etc.
11. Horizontal and Vertical Scroll Bars :- They enable one to move up and down or left and right
across the window. The horizontal scroll bar is located above the status bar. The vertical
scroll bar is located along the right side of the screen to move up and down the document.
12. Save a Document :- When we create a new document, it will be saved into the hard drive. To
© Vidhya Tutorials | 46
Knowledge of Computers Knowledge of MS Word, MS
Excel, MS Access, MS Powerpoint.
© Vidhya Tutorials | 47
Knowledge of MS Word, MS Excel, MS Knowledge of Computers
Access, MS Powerpoint.
© Vidhya Tutorials | 48
Knowledge of Computers Knowledge of MS Word, MS Excel, MS
Access, MS Powerpoint.
address will be shown in the address bar. You can activate a cell by clicking on it or by using your
Columns : A column is a vertical set of cells. A single worksheet contains 16384 total columns. Every
column has its own alphabet for identity, from A to XFD. You can select a column clicking on its
header.
Rows : A row is a horizontal set of cells. A single worksheet contains 1048576total rows. Every row has
its own number for identity, starting from 1 to 1048576. You can select a row clicking on the row
Fill Handle : It’s a small dot present on the lower right corner of the active cell. It helps you to fill
numeric values, text series, insert ranges, insert serial numbers, etc.
Address Bar : It shows the address of the active cell. If you have selected more than one cell, then it
© Vidhya Tutorials | 49
Knowledge of MS Word, MS Knowledge of Computers
Excel, MS Access, MS Powerpoint.
Formula Bar : The formula bar is an input bar, below the ribbon. It shows the content of the active cell
Title Bar : The title bar will show the name of your workbook, followed by the application name
(“Microsoft Excel”).
File Menu: The file menu is a simple menu like all other applications. It contains options like (Save,
Quick Access Toolbar : A toolbar to quickly access the options which you frequently use. You can add
Ribbon Tab : Starting from the Microsoft Excel 2007, all the options menus are replaced with the
ribbons. Ribbon tabs are the bunch of specific option group which further contains the option.
Worksheet Tab : This tab shows all the worksheets which are present in the workbook. By default you
will see, three worksheets in your new workbook with the name of Sheet1, Sheet2, Sheet3 respectively.
Status Bar : It is a thin bar at the bottom of the Excel window. It will give you an instant help once you
3. Password Protection
It allows the user to protect their workbooks by using a password from unauthorized access to their
information.
4. Data Filtering
Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range displays
only the rows that meet the criteria you specify for a column. MS Excel provides two commands for filtering
ranges:
5. Data Sorting
Data sorting is the process of arranging data in some logical order. MS Excel allows us to sort data either in
© Vidhya Tutorials | 50
Knowledge of Computers Knowledge of MS Word, MS Excel, MS
Access, MS Powerpoint.
6. Built-in formulae
MS Excel has got many built-in formulae for sum, average, minimum, etc. We can use those formulae as per our
needs.
9. Formula Auditing
Using formula auditing we can graphically display or trace the relationships between cells and formulas with
blue arrows. We can trace the precedents (the cells that provide data to a specific cell) or the dependents
© Vidhya Tutorials | 51
Knowledge of MS Word, MS Excel, Knowledge of Computers
MS Access, MS Powerpoint.
© Vidhya Tutorials | 52
Knowledge of Computers Knowledge of MS Word, MS Excel, MS
Access, MS Powerpoint.
What is MS Access?
Microsoft Access is a database
management system (DBMS) that combines
the relational Microsoft Jet Database
Engine with a graphical user interface and
software-development tools.
Components of MS Access
Tables
A table in Access is an object comparable to any other tabulated data; which stores data in the
When a new table is created, Access asks to define fields that are also identified as column
headings. Each field should possess a unique name and data type.
A Table can be considered similar to other tables in the database file. The appearance of the
table may seem similar to the one created in Excel with column heading and titles.
Tables include fields/columns to store various kinds of data, such as name or address,
furthermore, records or rows collect all the information about a particular instance of the subject,
One can also define Primary Key in a table. This helps retrieve data more quickly.
Queries
Queries are an approach for searching and compiling data from one or more tables. Once a table
is designed and the user or programmer is scanning for a calculated output, then it is called
queries.
Running a query means requesting a detailed question of your database. This may include filtering,
When you construct a query in Access, you are defining special search provisions(limitations) to
find exactly the data you want. Queries can pick from one or more relevant Tables and other
Queries.
Types of Query that can be used are; SELECT, INSERT, UPDATE, DELETE.
© Vidhya Tutorials | 53
Knowledge of MS Word, MS Excel, Knowledge of Computers
MS Access, MS Powerpoint.
Forms
A user interface for a database application can be performed using forms. This implies forms assist the
user to display live data from the table, which is mainly used to ease the process of data entry, editing,
Report
A report is an object in the desktop database. Once all the information is inserted into the database,
Users can customize or modify the report look as per the requirement.
A report allows formatting, printing, calculating, and summarizing the chosen data. Users can also
As forms are employed for input purposes, the same way reports are used for output.
Macros
Macros are mini computer programming constructs using predefined actions which can automate
Multiple tasks like moving to another record, searching, or running a formula can be assigned and
An Access Macro is a script for creating some jobs. For instance, to create a button that initiates a
report, one can apply a macro that will fire OpenReport action.
Users can use macros to open tables, initiate and administer queries, print or observe reports and can
also involve simple conditions in macros to specify when one or more actions in the macro should be
executed or skipped.
Data( editing existing records, inserting new records, or deleting records) macros can be attached
Module
Modules are a set of pre-defined instructions created by a programmer in the database employing
Visual Basic for Applications (VBA). They can be applied throughout the database.
Modules give a more discrete flow of operations and allow the users to trap errors.
Everything that can be performed in a macro can also be executed in a module, but in a module, the
Modules are considerably more powerful and are essential than macros if the user plans to write code
© Vidhya Tutorials | 54
Knowledge of Computers Knowledge of MS Word, MS Excel,
MS Access, MS Powerpoint.
What is MS PowerPoint?
2. Graphs
3. Tables
4. Photographs
5. Charts
6. Media Clips
7. Videos
© Vidhya Tutorials | 55
Knowledge of MS Word, MS Excel, Knowledge of Computers
MS Access, MS Powerpoint.
Features of
MS PowerPoint
There are multiple features that are available in MS PowerPoint which can customise and
optimise a presentation. The same have been discussed below.
Slide Layout
Multiple options and layouts are available based on which a presentation can be created. This option
is available under the “Home” section and one can select from the multiple layout options provided.
want to insert in their presentation. This may include images, audio, video, header, footer, symbols,
shapes, etc.
Slide Design
MS PowerPoint has various themes using which background colour and designs or textures can be
added to a slide. This makes the presentation more colourful and attracts the attention of the people
looking at it.
This feature can be added using the “Design” category mentioned on the homepage of MS
PowerPoint. Although there are existing design templates available, in case someone wants to add
some new texture or colour, the option to customise the design is also available. Apart from this, slide
Animations
During the slide show, the slides appear on the screen one after the other. In case, one wants to add
some animations to the way in which a slide presents itself, they can refer to the “Animations”
category.
Apart from all these options; font size, font style, font colour, word art, date and time, etc. can also
be added to a PPT.
© Vidhya Tutorials | 56
Knowledge of Computers Knowledge of MS Word, MS
Excel, MS Access, MS Powerpoint.
© Vidhya Tutorials | 57
INTERNET
Uses of internet
© Vidhya Tutorials | 58
Knowledge of Computers
INTERNET
SOME TERMS
RELATED WITH INTERNET ARE:
1) Browser:-
A browser is internet based application software used to access a webpage. It sends request to
the web server and displays the received HTML files in proper format user interact with the
internet by using browser.
e.g. Google Chrome, Internet Explorer, Mozilla Firefox, Opera, Netscape, Safari, etc.
2) Search Engine:-
It is also internet based application software. It can be used to access the required information
or webpage address from the internet. A search engine maintains the record of all the websites
and their contents. When the user requests by providing the keywords, it provides a list of
websites and their links from its database. [Link] is the most common search engine at
present. Other search engine includes [Link], [Link], [Link], [Link],
etc.
3) Messenger Service:-
A messenger is also internet based application software. It is used for communication. Such as
text chat, audio-video chat, conference call, transmitting data and files, offline messages, etc.
Some of the common messengers used are MSM messenger, Yahoo messenger, Google talk,
AOL, Skype, etc.
4) Webpage:-
It is the fundamental unit of web. It is used to provide text emails, audio, video to the users.
Webpage is developed by using scripting and web based programming language. Webpage are
of two types:
a) Static
b) Dynamic
A static webpage is developed by using HTML.
Dynamic webpage is developed by using programming language like PHP, ASP, C#, etc along
with HTML.
5) Website:-
A website is a location used for storing webpage. User access the webpage by using the
website address. For e.g. [Link], [Link], etc.
6) Web server:-
Web server is a program required to host webpage so that it can be accessed through the
internet. To host webpage, the computer should have web server running, dedicated internet
connection and the computer should be running all the time. The common web servers used are
IIS (Internet Information Service) and Apache (for Linux based system).
© Vidhya Tutorials | 59
Knowledge of Computers
INTERNET
9) Protocol:-
A protocol is a rule or standard defined to be used by all the components. Network protocol can be
defined as the rules used for communication between two or more devices.
• IP (Internet Protocol)
© Vidhya Tutorials | 60
Knowledge of Computers
INTERNET
• HTTP:
It is used for the communication of hypertext document. WebPages are the example of
hypertext document. It is developed by using HTML and contains hyperlink.
• FTP:
o It is used for the transmission of files like document image, audio, video, software,
games, etc.
• HTTPS:
o It is used for the transmission of hypertext document by providing higher security. It is
mainly used by banking sector, e-commerce, and other electronic payment system where
higher security is required. It uses encryption and decryption technique to provide security.
• IP:
o It is the most common protocol used in internet to identify a particular system. It is used
along with TCP in internet (TCP/IP).
• TCP:
o It is connection oriented protocol i.e. connection is maintained throughout
communication. It provides reliable transmission so it is slower than UDP. It is the common
protocol used in internet for transmission of hypertext documents, files and email
message.
• UDP:
o It is connectionless protocol. It doesn’t provide reliable transmission but it is faster than
TCP. So, UDP is preferred for transmitting real time, multimedia data.
• VOIP:
o It is used for transmission of voice signal through internet. It is the cheaper and faster
medium of communication mainly for a long distance.
© Vidhya Tutorials | 61
E - MAIL
Features of e-mail:
i. It is faster and cheaper medium of communication.
ii. It is reliable.
iii. It is secured communication.
iv. It can be used for transmitting text, image, audio, video.
v. Same message can be sent to multiple users at the same time by using CC (Carbon
Copy) and BCC (Blind Carbon Copy).
vi. It may or may not use internet directly.
© Vidhya Tutorials | 62
Knowledge of Computers
E - MAIL…
Types:
Types:
1. Web based email
2. POP email service
receive the message. Email providers like [Link], [Link], [Link], etc. provide internet
i) Outlook express
ii) Thunderbird
iii) Eudora
It can be used from the system with email client software and proper setting to connect email
providers.
© Vidhya Tutorials | 63
E-GOVERNANCE
(ROLE OF INFORMATION TECHNOLOGY IN GOVERNANCE)
IN INDIA
What is e-Governance?
Electronic governance or e-governance is adopted by countries across the world. In a fast-
growing and demanding economy like India, e-governance has become essential. The rapid
growth of digitalisation has led to many governments across the globe to introduce and
incorporate technology into governmental processes. Electronic governance or e-
governance can be defined as the usage of Information and Communication Technology
(ICT) by the government to provide and facilitate government services, exchange of
information, communication transactions and integration of various standalone systems
and services.
In other words, it is the use of technology to perform government activities and achieve the
objectives of governance. Through e-governance, government services are made available
to citizens and businesses in a convenient, efficient and transparent manner. Examples of
e-governance include Digital India initiative, National Portal of India, Prime Minister of
India portal, Aadhaar, filing and payment of taxes online, digital land management
systems, Common Entrance Test etc.
© Vidhya Tutorials | 64
Knowledge of Computers E-GOVERNANCE
(ROLE OF INFORMATION TECHNOLOGY IN GOVERNANCE)
IN INDIA
TYPES OF INTERACTIONS IN
E-GOVERNANCE
e-Governance can take place in four major types of interactions, apart from the processes and
interactions in the back-office, within the government framework:
Government to Employees(G2E)
The interaction between the government and its employees occurs in an efficient and speedy
manner.
© Vidhya Tutorials | 65
E-GOVERNANCE Knowledge of Computers
(ROLE OF INFORMATION TECHNOLOGY IN GOVERNANCE)
IN INDIA
OBJECTIVES OF E-GOVERNANCE
The objectives of e-governance can be listed down as given below:
To support and simplify governance for government, citizens, and businesses.
To make government administration more transparent and accountable while addressing
the society’s needs and expectations through efficient public services and effective
interaction between the people, businesses, and government.
To reduce corruption in the government.
To ensure speedy administration of services and information.
To reduce difficulties for business, provide immediate information and enable digital
communication by e-business.
© Vidhya Tutorials | 66
Knowledge of Computers E-GOVERNANCE
(ROLE OF INFORMATION TECHNOLOGY IN GOVERNANCE)
IN INDIA
E-GOVERNANCE IN
THE INDIAN CONTEXT
e-Governance in India is a recently developed concept. The launch of National Satellite-Based
Computer Network (NICENET) in 1987 and subsequent launch of the District Information System
of the National Informatics Centre (DISNIC) programme to computerise all district offices in the
country for which free hardware and software was offered to the State Governments provided
the requisite impetus for e-governance.
e-Governance thereafter developed with the growth of technology. Today, there are a large
number of e-Governance initiatives, both at the Union and State levels. In 2006, the National e-
Governance Plan(NeGP) was formulated by the Department of Electronics and Information
Technology and Department of Administrative Reforms and Public Grievances that aims at
making all government services accessible to the common man, ensure efficiency,
transparency and reliability of such services at affordable costs to realise the basic needs of
the common man.
© Vidhya Tutorials | 67
E-GOVERNANCE Knowledge of Computers
(ROLE OF INFORMATION TECHNOLOGY IN GOVERNANCE)
IN INDIA
© Vidhya Tutorials | 68
Knowledge of Computers E-GOVERNANCE
(ROLE OF INFORMATION TECHNOLOGY IN GOVERNANCE)
IN INDIA
© Vidhya Tutorials | 69
E-GOVERNANCE Knowledge of Computers
(ROLE OF INFORMATION TECHNOLOGY IN GOVERNANCE)
IN INDIA
e-Governance
Portal of India
The Indian e-governance portal is [Link] On this portal, one can get
comprehensive information regarding the National Conference on e-Governance and reports
on earlier conferences.
Additionally, the portal provides links to the following important pages:
Digital India
National Portal of India: It is developed to provide access to information and services being
provided by the government
PM India Website: provides information relating to the Prime Minister’s Office.
United Nations e-governance website
© Vidhya Tutorials | 70
VIDHYA TUTORIALS
“EDUCATION YOU CAN BELIEVE IN”
NOTE:- _____________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
© Vidhya Tutorials
VIDHYA TUTORIALS
“EDUCATION YOU CAN BELIEVE IN”
NOTE:- _____________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
© Vidhya Tutorials
VIDHYA TUTORIALS
“EDUCATION YOU CAN BELIEVE IN”
NOTE:- _____________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
____________________________________
© Vidhya Tutorials