Can you tell me about the courses offered by National Institute of Electronics & Information Technology (NIELIT)? Can you give me its question paper of IT Tools and Business Systems of O Level?

National Institute of Electronics & Information Technology (NIELIT),(previous ly known as DOEACC Society), an Autonomous Scientific Society under Government of India was set up to carry out Human Resource Development and related activities in the area of Information, Electronics & Communications Technology (IECT).

Courses Offered
Computer Course
Basic Computer Course (BCC)
Course on Computer Concepts (CCC)
O Level
A Level
B Level
C Level

Computer Hardware Course
Computer Hardware Courses in Maintenance and Networking
Diploma in Computer Hardware Maintenance (CHM O level)
Advanced Diploma in Computer Hardware Maintenance and Networking
(CHM A level)

PG Diploma Courses
Embedded Systems / VLSI Design / Electronic Design and Automation
PG Diploma Courses (ASIC Design & Verification, Embedded System & Design, VLSI & Embedded Hardware)

Question Paper of IT Tools and Business Systems of O Level

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Which of the following file extensions does not indicate graphic files?
A) BMP
B) JPEG
C) DOC
D) GIF

1.2 In MS-Power Point which layout can be used to display hierarchies of employees in a
Company?
A) Dialog Box
B) Table
C) Pie Chart
D) Organization Chart

1.3 The value of Primary key
A) cannot be null
B) can be null
C) can be duplicate
D) none of these

1.4 What does an electronic spread sheet consists of?
A) Rows
B) Columns
C) Cells
D) All of the above

1.5 The formula in cell A2 is =B2+C3 on copying this formula in cell C2 the formula will be
A) =D3+E4
B) =D2+E3
C) =D2+E4
D) =D3+E3
M1-R4 Page 2 of 4 January, 2014

1.6 Non-impact based printing device is
A) Dot-Matric Printer
B) Scanner
C) Laser Printer
D) None of the above

1.7 Which of the following shortcut is used to open a new file?
A) CTRL+S
B) CTRL+N
C) ALT+N
D) CTRL+V

1.8 MIS stands for
A) Maintenance Information System
B) Model Information System
C) Management Information System
D) Media Information Source

1.9 The Internet is owned by
A) IAB
B) IETF
C) Inter NIC
D) All of the above

1.10 While sending a file or message on the net, it is divided into very small parts known as
A) Point
B) Particle
C) Pin
D) Packet


2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and
ENTER in the “OMR” answer sheet supplied with the question paper, following
instructions therein. (1x10)

2.1 A set of instruction which perform a task is called program.
2.2 A byte is the smallest unit of storage.
2.3 Analog computer is a mixture of hybrid and digital computer.
2.4 Margins are the distance between the text and the edges of the paper.
2.5 By default, the numbers are left aligned and text is right aligned in a spreadsheet.
2.6 If you enter 127A in a cell it will be treated as number in the electronic spreadsheet as it starts
with digit.
2.7 In Access deleted record can be undone.
2.8 Access sorts data only in ascending order.
2.9 Internet is network of networks.
2.10 Paperless office & Virtual office are same.
M1-R4 Page 3 of 4 January, 2014

3. Match words and phrases in column X with the closest related meaning/
word(s)/phrase(s) in column Y. Enter your selection in the “OMR” answer sheet supplied
with the question paper, following instructions therein. (1x10)

X Y
3.1 Information A. The base of Octal number system
3.2 DSS B. Highest transmission text program
3.3 LINUX C. Returns highest value from cell A1 to A9
3.4 http D. Software to translate HLL to Machine Code
3.5 Interpreter E. Person to Person Protocols
3.6 PPP F. Hypertext transfer protocol
3.7 ls – l G. Mixed cell reference in electronic spreadsheet
3.8 $A44 H. Processed Data
3.9 8 I. Command to get lost list of files in LINUX
3.10 =max(a1:a9) J. Operating System
K. Point to Point Protocols
L. Command to get long list of files in LINUX
M. Decision Support System

4. Each statement below has a blank space to fit one of the word(s) or phrase(s) in the list
below. Enter your choice in the “OMR” answer sheet supplied with the question paper,
following instructions therein. (1x10)

A. LINK B. 1000 C. MODEM
D. PASTE E. AUTOSUM F. CUT/COPIED
G. 1024 H. CAT I. COMPILER
J. DATABASE
MANAGEMENT
SYSTEM
K. CUT L. DATABASE MODEL
SYSTEM
M. HARDDISK

4.1 The 1KB equals ________ bytes.
4.2 ________ is used in electronic spreadsheet to total rows and/or columns.
4.3 The ________ is the example of Secondary memory.
4.4 Short-cut CTRL+X is used to ________.
4.5 DBMS stands for ________.
4.6 The command to view the contents of a file in LINUX is ________.
4.7 ________ translates a program written in high-level language into machine code.
4.8 Foreign Key is used to ________ the given table with other table.
4.9 A Clipboard is used for keeping the ________ text.
4.10 ________ is a device to convert digital signal to analog & vice versa.
M1-R4 Page 4 of 4 January, 2014

PART TWO
(Answer any FOUR questions)

5.
a) Draw a block diagram of basic units of the Computer System. List various sub units of the CPU
and give the function of each of the units.
b) Convert:
i) (7706)8 to Hexadecimal
ii) (7305)10 to Octal.
c) List different types of Memory in Computer System. Explain there uses.
(6+4+5)

6.
a) How do we increase or decrease size of a Row & Column in a spreadsheet.
b) Explain with example cell referencing. What are the different types of referencing?
c) Explain the need of Operating System in a computer. What is the role of Kernel and Shell in
LINUX Operating System?
(3+7+5)

7.
a) Explain the terms Header, Footer, Footnotes and Endnotes. What is the difference between
Footnotes & Endnotes?
b) Explain utility of Mail-Merge feature in a Word Processing Software?
c) What features of a presentation software make it useful for preparing an office presentation?
(5+5+5)

8.
a) What is a Relational Database Management System? Differentiate between Create Table &
View Table commands in SQL?
b) How is validation done in a spreadsheet? What are the types of validation possible?
c) Explain the effect of Referential Integrity in related tables? Explain cascading update and
cascading delete with an example.
(4+6+5)

9.
a) Explain the use of Payroll system in an organization. Name different columns that you would
include in a payroll statement?
b) What is Personal Information System (PIS) and what are its functions.
c) Explain the application of Multimedia in E-learning.

Contact Detail:

National Institute of Electronics and Information Technology
Electronics Niketan, 6 CGO Complex, Jawaharlal Nehru Stadium Marg, CGO Complex, Pragati Vihar, New Delhi, DL 110003

Map: