(i) Input Devices:
(a) Keyboard
(b) Optical scanner
(c) Mouse
(d) Joystick
(ii) Output Devices:
(a) Monitor
(b) Printer

Following are the three methods of codification.
(a) Sequential Codes:
(i) In sequential code, numbers and/or letters are assigned in consecutive order.
(ii) These codes are applied primarily to source documents such as cheques, invoices, etc.
(iii) A sequential code can facilitate document search. For example:
CODE ACCOUNTS:
CL001 ABC LTD
CL002 XYZ LTD
CL003 SCERT
(b) Block Codes:
(i) In a block code, a range of numbers is partitioned into a desired number of sub-ranges and each sub-range is allotted to a specific group;
(ii) Inmost of the cases of block codes, numbers within a sub-range follow sequential coding scheme, i.e. the numbers increase consecutively. For example:
CODE DEALER- TYPE :
100 - 199 Small pumps
200 - 299 Medium pumps
300 - 399 Pipes
400 - 499 Motors
(c) Mnemonic Codes:
A mnemonic code consists of alphabets or abbreviations as symbols to codify a piece of information.
For example:
CODE:
SJ Sales Journals
HQ Head Quarters

There are three types of softwares namely:
(i) Ready-made software,
(ii) Customised software and
(iii) Tailor-Made software

Procedure
i) Open a new spreadsheet in MS-Excel
ii) Enter values in the cells as given below

iii) Compute PMT in the cell B6 by the formula
= PMT(B1/12,B2,B3,B4,B5)
= Rs.7,608.78

Procedure
1. Open new excel sheet.
2. Input the table as given in the question.
3. Enter the data “Achieved” in Cell D1.
4. Type the following in Cell D2:
= OR (B2 > = 500,C2 > = 500)
5. Copy the formula from D2 into D3 and D4
Output