Types of Keyboard Keys :-
1} Function Keys
2} Shortcut Keys
3} Direction Keys
4} Alphabetical Keys
5} Numerical Keys
Input Device :-
The Device which is used to give instruction into the computer
system is called “Input Device”.
E.g.:- Keyboard, Mouse, Mice, Scanner.
Output Device :-
When we enter the data through Input Device into the computer
system, it process in CPU (Microprocessor) them we get result (Output) by output
devices.
E.g.:- Monitor, Printer, Speaker, etc.
Keyboard :-
Keyboard is the main input device of the computer we can’t
operate other devices without keyboard. In Normal Keyboard 101/104 keys are
present.
Monitor :-
Monitor is an output device. It is given us result [output] in the form
of “Software Copy” With the help of software. Monitor is the most common device
used with a computer to display results.
Monitor are two types:-
CRT (Cathode Ray Tube)
LCD (Liquid Crystal Display)
1
Printer :-
It is an Output device. It gives us result [Output] in the form of “Hard
Copy “[Paper Print Out]. The printer is used to get a hard copy of result, i.e. it
provides permanent output. Printing mechanism refers to the method used by the
printer to produce the image on the output media, such as paper, OHP
transparency (Over Head Projector) etc.
Speaker :-
Speaker an Output device they are in various different types of speaker
available in the market some are simply multimedia speakers some comes along
with woofers system using paper cable speaker output can be connected to an
audio, amplifiers or home stereo system to produce high volume sound output.
----: NOTEPAD : ------
Notepad:-
Notepad is application software. Notepad is a basic text editor you can use for
Type simple documents or for creating web pages.
Extension of Notepad is “*.txt”.
How to start Notepad
There are two ways to start Notepad application.
1) Click on start Menu Button.
2) Select all Programs
3) Accessories
4) Notepad
2
1) Click on start Menu Button
2) Run
3) Type [Notepad] in the open Dialog Box
4) Click on OK
How to Save a File?
1) Click on File Menu.
2) Save or (Ctrl + S)
3) Save as window will open
4) Go to my Computer
5) Open [D: or E: Or any Drive]
6) Create New Folder
7) Gives it your name
8) Gives File Name
9) Click on Save
Word Wrap :-
It is used to wrap the document in the screen area i.e. if word wrap
is ON, Then the next cursor will automatically come to the next Line after the end
of the First line after the end of the First line and when it is OFF the cursor will not
come to the next line until “Enter key” is pressed.
Font :-
Font is used for the increase or decrease the text size & also change
the font face or font style like Bold, Italic, and Regular.
3
Shortcut keys of Notepad:-
Options Shortcut Keys
New Ctrl+ N
Open Ctrl + O
Save Ctrl + S
Save as ALT + F+A
Print Ctrl + P
Undo Ctrl + Z
Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V
Select All Ctrl + A
Delete DELETE
Find Ctrl + F
Replace Ctrl + H
Go to Ctrl + G
Time / Date F5
Minimize ALT + SPACE +N
Maximize ALT + SPACE +X
Restore ALT + SPACE +R
Close ALT + SPACE +C
----: WORDPAD : ------
4
WordPad :-
WordPad is application software is used to create simple documents.
The extension of WordPad is “.RTF”.
How to start WordPad?
1) Click on start Menu Button
2) Select Program
3) Accessories
4) WordPad
1) Click on start Menu Button
2) Run
3) Type (WordPad) in the open Dialog Box
4) Click OK.
Difference Between Notepad & WordPad :
5
Notepad WordPad
1} In Notepad selection is not necessary 1} In WordPad selection is
for Increasing text size. necessary for Increasing text size.
2} To Start Notepad from run option type 2} To Start WordPad from run
Notepad. option type Word.
3} The File Extension of Notepad is 3} The File Extension of WordPad is
“*.TXT”. “*.RTF”.
4} In Notepad formatting bar is Absent. 4} In WordPad formatting bar is
Present.
5} In Notepad we can’t insert the picture. 5} In WordPad we can insert the
picture.
6} In Notepad Ruler is Absent. 6} In WordPad Ruler is Present.
7} In Notepad we can’t give the colour to 7} In WordPad we can give the
the text. colour to the text.
----: PAINT : ------
6
Paint:-
Paint is a drawing tool you can use to create simply drawings. These drawing
can either black – or – White or colour and can be saved as bitmap files. You can print
your drawing, use it for your desktop background or paste it into another document. You
can even use Paint to view and edit scanned photos.
The extension of MS- Paint is “*.BMP”.
How to start MS-Paint?
1} Click on start Menu.
2} Select Program
3} Accessories
4} Paint
1} Click on start Menu
2} Run
3} Type [MS-PAINT] in the open dialog Box
4} click to OK.
Shortcut Keys of Paint
Option Shortcut Keys
New CTRL + N
Open CTRL + O
Save as ALT + F + A
Print CTRL +P
Undo CTRL + Z
Repeat CTRL +Y
Cut CTRL + X
Copy CTRL + C
Paste CTRL + V
Select All CTRL + A
Clear Selection Delete
Tool Box CTRL +T
Colour Box CTRL + L
7
View Full Bitmap CTRL + F
Large Size (Zoom) CTRL + PAGE DOWN
Normal Size CTRL + PAGE UP
Show Grid CTRL + G
Flip / Rotate CTRL + R
Stretch CTRL + W
Invert colour CTRL + I
Attribute CTRL + E
Clear Whole Image CTRL + SHIFT + N
----: MICROSOFT WORD : ------
Microsoft Word:-
Word processing is the most common applications packages to create
edit and print documents using a Computer to perform word processing, called a word
processing you need a computer a special program called a word processor. A word
processor enables you to create a documents store it electrically on an it by entering
commands and characters form the keyboard and print it on a printer.
Word 97-2003 file has “*.Doc” extension and Word 2007-2013 File has” *.Docx”.
Extension.
How to start MS-Word?
1} Click on Start Menu.
2} Select Program
3} Microsoft Office
4} Microsoft Office Word 2013.
Shortcut Keys of MS-WORD:-
8
Option Shortcut Keys
9
Task Pane CTRL + F1
Print Preview CTRL + F2
Insert Page CTRL + ENTER
Hyperlink CTRL + K
Font CTRL + D
Spelling & Grammar F7
Research ALT + CLICK
Track Changes CTRL + SHIFT + E
Help F1
Bold CTRL + B
Italic CTRL + I
Underline CTRL + U
Left Align CTRL + L
Center Align CTRL + E
Right Align CTRL + R
Justify Align CTRL + J
Set cursor Starting of Line HOME
Set cursor Ending of Line END
To Increase Font Size CTRL +SHIFT+ >
To Decrease Font Size CTRL + SHIFT+ <
Scroll page up PAGE UP
Scroll page Down PAGE DOWN
Format Painter (Copy) CTRL + SHIFT+ C
Format Painter (Paste) CTRL + SHIFT+ V
Font CTRL + SHIFT+ F
Show / Hide ¶ CTRL + *
View Macros ALT + F8
10
----: MICROSOFT EXCEL (SPREAD SHEET) : ------
Microsoft Excel:-
Microsoft Excel is powerful Spread sheet software program that
allows you to manipulate data and make quick and accurate numerical calculations.
Excel is takes place of calculator a ruled ledger pad, pencil and pen.
Excel has grid of columns and rows into which you can enter
numerical, text etc. Excel can perform mathematical or logical calculations and show the
result.
Excel 97-2003 file has “*.XLS” extension and Excel 2007-10 file has “*.XLSX” extension.
Columns – 16384
Rows -- 1048576
Cell - 17,17,98,69,184
Shortcut Keys of MS-WORD:-
Option Shortcut Keys
CTRL + N Open New Worksheet
CTRL + O Open existing Workbook
CTRL + W Close active Workbook
CTRL + S Save active Workbook
F12 Save as Different Name, Location, file Type
AIT + F4 Close Excel
F1 Open help Menu
CTRL + Z Undo last Action
CTRL + Y Repeat last action
F4 Restore Undo action
CTRL + 0(ZERO) Hide current columns
CTRL + 9 Hide current Rows
11
CTRL + SHIFT + 9 Unhide current Row
CTRL + SHIFT + ( Unhide current Columns
{BILL}
BILL NO:
DATE:
NAME:
ADD:
TEL NO:
1) SR NO -
2) PRODUCT NAME -
3) QUANTITY (QTY) -
4) RATE -
5) AMOUNT - RATE*QTY
6) DISCOUNT - AMOUNT * %
7) VALUE - AMOUNT - DISCOUNT
8) TOTAL - SUM(SELECT ALL VALUE)
{SALARYSLIP}
1) SR NO: -
2) COMPANY NAME -
3) EMPLOYEE NAME -
12
4) POST -
5) BASIC SALARY -
6) HOUSE RENT (H.R) - BASIC SALARY * % ----------ENTER
7) MEDICAL AALOWANCE - BASIC SALARY * % ----------ENTER
8) TRAVELLING EXPENSES - BASIC SALARY * % ----------ENTER
9) PROVIDENT FUND (P.F) - BASIC SALARY * % ----------ENTER
10) GROSS SALARY - BASIC SALARY +H.R+M.A+T.E+P.F
11) NET SALARY - GROSS SALARY – P.F
{MARKSHEET}
ROLL NO:
STUDENT NAME :
SUBJECT NAME 1 :
SUBJECT NAME 2 :
SUBJECT NAME 3 :
SUBJECT NAME 4 :
SUBJECT NAME 5 :
SUBJECT NAME 6 :
TOTAL : = SUM (SELECT ALL MARKS OF SUBJECT) ----------ENTER
MIN : = MIN (SELECT ALL MARKS OF SUBJECTS) ----------ENTER
MAX : = MAX (SELECT ALL MARKS OF SUBJECTS) ----------ENTER
AVERAGE : = AVERAGE (SELECT ALL MARKS OF SUBJECTS) ----------ENTER
13
COUNT : = COUNT (SELECT ALL MARKS OF SUBJECTS) ----------ENTER
RESULT : =IF (AND (SELECT 1st SUBJECT MARKS>35, SELECT 2nd SUBJECT
MARKS, SELECT 3rd SUBJECT MARKS >35, SELECT 4th SUBJECT
MARKS >35, SELECT 5th SUBJECT MARKS>35, SELECT 6th SUBJECT
MARKS>35),”PASS”,”FAIL”)
GRADE : =IF ( SELECT AVERAGE >80,”A”, IF (SELECT AVERAGE >65,”B”, IF (
SELECT AVERAGE >55,”C”, IF ( SELECT AVERAGE >35,”D”))))
----: MICROSOFT POWERPOINT (PRESENTATION) : ------
Microsoft PowerPoint:-
PowerPoint is application software which is used to create
Presentation slides for advertisement, education, product, modelling etc. PowerPoint is
the largest selling presentation graphics software package that is designed by Microsoft
Corporation of USA.
PowerPoint helps you bringing ideas and information that you want
to convey to your audience with no difficulty with PowerPoint you can.
14
The Extension of PowerPoint 2003 is “*.PPT” & The Extension of PowerPoint is 2007 is
“*.PPTX”.
How to start PowerPoint?
1} Click on Start Menu.
2} Select Program
3} Microsoft Office
4} Microsoft Office PowerPoint 2013.
Shortcut Keys of PowerPoint:-
Option Shortcut Keys
SWITCH TO THE NEXT ALT + TAB
WINDOW
SWITCH TO THE PREVIOUS ALT + SHIFT + TAB
WINDOW
CLOSE THE ACTIVE CTRL + W
WINDOW
RESTORE THE SIZE OF THE CTRL + R
ACTIVE
WINDOW AFTER YOU CTRL +F5
MAXIMIZE IT
START THE
PRESENTATION FROM THE F5
BEGINNING
GO TO SLIDE NUMBER NUMBER + ENTER
DISPLAY A BLANK WHITE
SLIDE OR RETURN TO THE
B OR PERIOD
PRESENTATION FROM A
BLACK WHITE SLIDE
STOP OR RESTART AN
AUTOMATIC S
PRESSENTATION
END PRESENTATION ESC OR HYPHEN
15
ERASE ON SCREEN
E
ANNOTATION
GO TO NEXT SLIDE, IF THE
H
NEXT SLIDE IS HIDDEN
SET NEW TIMMING WHILE
T
REHEARSING
USE ORIGINAL TIMMING
WHILE O
REHEARSING
USE A MOUSE CLICK TO
ADVANCE WHILE M
REHEARSING
MRETURN TO THE FIRST
1 + ENTER
SLIDE
REDISPLAY HIDDEN
POINTER OR CHANGE THE CTRL + P
POINTER TO A PEN
REDISPLAY HIDDEN
POINTER OR CHANGE THE CTRL + A
POINTER TO AN ARROW
HIDE THE POINTTER AND
CTRL + H
NAVIGATION BUTTON
IMMEDIATELY
HIDE THE POINTTER AND
NAVIGATION BUTTON IN CTRL + U
15 SECOND .
DISPLAY THE SHORTCUT
SHIFT + F10
MENU
GO TO THE FIRST OR NEXT
TAB
HYPERLINK ON A SLIDE
GO TO THE FIRST OR NEXT
SHIFT + TAB
HYPERLINK ON A SLIDE
----: INTERNET : ------
16
INTERNET :--
Internet is known as network of networks. The Internet is a
World Wide Web network, which grew out of a 1960 Project by American
Department of Defence This Project was executed by an Advance Research
Project Agency (ARPA) and an Internet like System Developed by them was
called ARPA net.
E-MAIL :--
E-Mail or Electronic Mail is one of the Latest and Fastest and
most convenient mail [Link] can send an e-mail anywhere in the
world, in a Fraction of time and cost, compared to the time and cost of the
ordinary Postal mail.
WWW :-
World Wide Web (WWW) is a Service on the screen Internet that
connects various documents available on the Internet with links to each
other and to various other Documents. From on Documents you can Jump
to another related documents, which in turn may be linked to many other
documents.
What are Domains :-
Domains divide World Wide Web sites into
categories based on the nature of their owner and they form part of a site’s
address or Uniform Resource Locator (URL)
Common Top Level Domains Are :-
1) .com- - Commercial Organisation, business and individuals.
2) .edu - Educational Institute
3) .gov - Non-military government Organisation
4) .mil - Military Institute
5) .org - Other Organisation and Groups
6) .net - Network Service provides
17
7) .arts - Cultural groups
8) .firm - business Firm
9) .info - Information Service
10) .nom - Individuals
11) .rec - Recreation Sites
12) .store - Retailor
13) .web - Web Related Organisations
14) .int - Organisation established by International Treaty
WEB BROUSER :-
The Web Browser Software that comes free with the
operating System easier Get the most out of the World Wide Web, whether you
are searching for Information or just browsing your favourite web sites. Like Internet
Explorer it comes with The windows.
SOME BROWSER SOFTWARE’S ARE AS BELLOW LIST :
1) Netscape Navigator
2) Opera
3) Mozilla Firefox
4) Flock
5) Chrome
6) Net Suf
----: MICROSOFT DOS : ------
18
INTRODUCTION OF DOS:-
DOS is a disk operating system with a set program that act as a
translator between the user and the computer in order to perform the mask of the user.
MS-DOS is a popular operating system on Micro computers.
DOS is an operating system used on PCs (Personal computer). The
Operating System is software which controls the hardware of the machine (the disks,
keyboard, mouse, monitor, etc.) and allows the user’s programs and packages to be run
on the machine. It is the interface between your word processor or spread sheet or
other program and the electrical s
signals which the CPU (Central Processing Unit), the heart of the computer, understands.
It is working on command option. Without command we can’t run the DOS
function, it is produced by Microsoft Company.
How to start Command Prompt?
1} Click on start Menu.
2} Select Program
3} Accessories
4} Command Prompt
1} Click on start Menu.
2} Run
3} Type (Command or CMD)
4} OK
COMMANDS:
19
VER (VERSION) :-
This command is used to see the current operating
system and versions of that operating system.
TIME :-
This command is used to see the current time & change the time.
DATE :-
This command is used to see the current Date & change the Date
C : OR D: OR E:
This command is used to change your current drive.
MD (FOLDER NAME) :-
(Make directory / Make Folder). This command is used to create
a folder in your current location.
RD (FOLDER NAME)
(Remove Directory / Remove Folder). This command is used to
remove /delete any folder.
CD (FOLDER NAME)
(Check Directory). This command is used to go into
directory/folder.
CD...
This command is used to come back one directory / folder.
20
CD\
This command is used to come back one current drive / root
directory. .
DIR :-
This Command is used to see the files and folder in your current
folder / Drive.
CLS :-
This command is used to clear the DOS screen.
CTRL + C :-
This command is used to come out the current action.
ALT + ENTER :-
This command is used to full screen of DOS window.
COPY CON :-
This command is used to create new file.
(Where left side * is known as file name & right * is file Extension.)
CTRL + Z :-
This command is used to save the file.
DEL :-
This command is used to delete all files or particular files from
your folder or drive.
EDIT :-
This command is used to create new files or modifies an existing
File.
21
REN :-
This command is used to create a new file or modifying an
existing file.
COPY (SOURCE LOCATION) (DESTINATION LOCATION) :-
This command is used to copy files or folder one place to another
place.
MOVE (SOURCE LOCATION) (DESTINATION LOCATION) :-
This command is used to Cut / Move files or folder one place to
another place.
EXIT :-
This command is used to close the DOS window.
22
23