NEGOMBO SOUTH INTERNATIONAL SCHOOL NETWORK

PILIYANDALA BRANCH
1st TERM TEST – 2024 MARCH
INFORMATION COMMUNICATION TECHNOLOGY Total
FULL NAME :
AD. NO : NSIS/NI/

CLASS : GRADE 09 – B/C/D Time duration :2 hours

 Special Instructions – Please provide answers using this paper itself.

01) Underline the most suitable answer.

1) The one who uses a computer is generally referred to as a ……………………..
a) Programmer c) User
b) Developer d) Blogger

2) Which of the following user is created and maintain software?

a) Application user c) End user
b) System user d) None of them

3) Which of the following user is using the created software?

a) Application user c) End user
b) System user d) Server user

4) There are ……………. types of computers according to their nature & use.
a) 4 b) 3 c) 2 d) 5

5) Which of the following is an example for input device?

a) Keyboard c) Joystick
b) Scanner d) All of these

6) Which of the following is an example for output device?

a) Printer c) Both a & b
b) Speaker d) Mouse

7) Which of the following is an example for both input & output device?
Printer Keyboard
Mouse Touch screen

8) Identify the following figure.

a) Motherboard
b) Micro chip
c) IC
d) Processor

9) The speed of a computer is determined by the number of instructions execute per second. What is the unit
that used to measure its speed?
a) GHz b) Hz c) MHz d) All of these

1|Page
 10) Which of the following monitor type consume more electricity?
a) LED b) CRT c) LCD d) Both a & b

11) Which of the following is a non-technical feature to be considered when purchasing a computer?
a) Price b) Size of Monitor c) Main memory capacity d) Both b & C

12) Which of the following is an example for free and open source operating system?
a) Linux b) Ubuntu c) Windows d) Both a & b

13) Which of the following is an example for Quad core processor?

a) Pentium D b) Pentium R c) Core i3 d) Dual core

14) Hard disk a main storage device of the computer system. What is the unit of memory used to measure its
capacity?
a) BIT b) Tera Byte c) Giga Byte d) Both b & c

15) An excel worksheet consists number of rows and columns. How many columns are there in a single
worksheet?
a) 65536 b) 16384 c) 255 d)1048576

16) An intersection between column and a row known as,

a) Cell b) Range of cells c) workbook d) worksheet

Answer the questions 17 to 20 using the following part of excel worksheet

17) What is the answer if the formula using single function =COUNT(A2:A7) is
entered in cell A8?
a) 6 b) 271 c) 9 d) 5

18) What is the answer if the formula using single function =MAX(B2:B7) is entered
in cell B8?
a) 95 b) 80 c) 45 d) 50

19) What is the function used to find the average marks of ICT in B8 cell?
a) =average(A2:A7) b) =avg(A2:A7)

c) =average(B2:B7) d) =avg(B2:B7)

20) What is the answer if the formula using single function =COUNT (B2:B7) is entered in cell B8?
a) 4 b) 6 c) 7 d) 5
(1 x 20 = 20 marks)

PART II

01) 1) Write the correct user name for the following tasks.
a) Designs information systems - ………………………………………..
b) Develops and maintains websites - ………………………………………..

2) Write 2 non portable computers.

a) ………………………………………………………. b) ………………………………………………………..

2|Page
 3) Write 2 portable computers.

a) ………………………………………………………. b) ………………………………………………………..

4) Write any 2 peripheral devices.

a) ………………………………………………………. b) ………………………………………………………..

5) When the number of processors in a central processing unit increases its capacity also increases. Write
any 2 types of processors.

a) …………………………………………………….. b) ………………………………………………………….

6) A larger monitor size is useful in viewing a larger picture. What is the method of measuring monitor size?

……………………………………………………………………………………………………………………………………………………….

7) The ports of a sound cards use standard colour scheme for identification purpose. Write the relevant
audio device which connected with below ports.

a) Light green - ………………………………………….. b) Light Pink - ………………………………………………….

8) Write 2 Non-technical specifications to be considered when purchasing a computer.

a) …………………………………………………….. b) …………………………………………………………….

9) Identify the following diagrams and label them.

a) b)

…………………………………………………………….. …………………………………………………………

10) Write the cell range represented by R1.

…………………………………………………….

(2 x 10 = 20 Marks)

02) An operating system provides the interface between the user and the hardware. The operating system is
essential to run application software. Once the
operating system is installed in a computer, the A)
necessary application software can be installed.
1) Name the components of the given diagram.
A) …………………………………………………..
B)
B) …………………………………………………..
C) ………………………………………………….. C)

D) …………………………………………………..
D)
2) Write 2 example devices for the label B,C & D
B) ………………………………….. ………………………………………………………………
C) ………………………………….. ………………………………………………………………
D) ………………………………….. ………………………………………………………………
3|Page
 3) Write long terms of the followings.
A) VGA - ………………………………………………………………………………………………………………
B) HDMI - …………………………………………………………………………………………………………….
C) DVI - …………………………………………………………………………………………………………….
D) USB - ……………………………………………………………………………………………………………....
E) Wi-Fi - ……………………………………………………………………………………………………………..
( 15 marks)
03) Write answers using the given diagram.

1) What is the name of the operating system used in this PC.? ………………..………………………………………….
2) What is the capacity of RAM used in this PC? …………………………………………………………………………………..
3) Write the type of the processor, processor manufacturer and its speed.
…………………………………….. …………………………………………………… ………………………………………………..
4) Write the method of obtain the above mentioned details in a PC.
…………………………………………………………………………………………………………………………………………………………..
5) How many hard disk drives are there in the given diagram?
………………………………………………………………………….
a) Name them along with its capacities.
………………………………………………........
………………………………………………........
………………………………………………........
………………………………………………........
6) Write any 2 processor manufacturing companies.
……………………………………………………………………..
………………………………………………………………………
7) There are 2 types of VGA’s name them.
……………………………………………… ……………………………………………………..

(15 marks)

4|Page
 04) Write answers using the given Excel worksheet.

1) Write the formula to find the Total marks of John.

……………………………………………………………………………………………………………………………………..

2) Write the formula using single function to obtain the average marks of Jessica.

……………………………………………………………………………………………………………………………………..

3) Write the formula using single function to obtain the Total marks of Rick.

……………………………………………………………………………………………………………………………………..

4) Write the formula to obtain the average marks of Lisa.

……………………………………………………………………………………………………………………………………..

5) Write the formula using single function to obtain the maximum marks for Science.

……………………………………………………………………………………………………………………………………..

6) Write the formula using single function to obtain the minimum marks for English.

……………………………………………………………………………………………………………………………………..

7) Write the formula using single function to obtain the number of participants for the subject Math.

……………………………………………………………………………………………………………………………………..

8) Write a suitable chart type can be used to represent the above data.

………………………………………………………………………………………………………………………………………

(15 marks)

5|Page
 05) Computer port is a virtual point where network connections start and end. Ports are software-based and
managed by a computer's operating system.
1) Identify the labeled ports in the diagram. D
A
A - ……………………………………………….
B - ……………………………………………….
C - ……………………………………………….
B
D - ………………………………………………
2) Write one device which can be connected to
C
above mentioned ports.
A - ……………………………………………….
B - ……………………………………………….
C - ……………………………………………….
D - ………………………………………………
3) Name the following wireless network connections.
a) …………………………………………… b) …………………………………

4) Classify the peripherals that can be connected to the USB port as input, output and storage.

Input Output Storage

Monitor , Printer , DVD , Pen drive , Mouse , Plotter , Joystick , Hard disk

5) Write 2 differences between CRT and LCD Monitors.

CRT LCD

(15 marks)
6|Page