2017

10
Information & Communication Technology – I, II

Instructions:

.lk
Answer all the questions

cp
In each of the questions 1 to 40, pick one of the alternatives (1), (2), (3), (4) which you consider as
correct or most appropriate.

dn
Mark a cross () on the number corresponding to your choice in the answer sheet provided.

.e
01. What is the most suitable statement to show that the value of Information is changed over the time?

1. Value of Information decreases over the time. w

w
2. Value of Information increases over the time.
-w

3. There is no effect of time on the value of information.

4. The value of information depends on time only.

02. With the rapid development of computer the…………………and the……………… reduced and the
P

…………………increased. The most suitable word order for the blanks is,
C
N

1. size, speed, efficiency

2. size, power consumption, efficiency
3. power consumption, efficiency, size
n

4. speed , efficiency, size

io

03. Which answer does contain only pointing devices?

at

1. Mouse, Touch Screen, Bar Code Reader

uc

2. LED Screen, Multimedia Projector, Digital Camera

3. Optical Character Reader, Mouse, Light Pen
Ed

4. Touch Screen, Light Pen, Joystick Stick

04. What is not a task performed by control unit (CU) of central processing unit (CPU)?
1. Controlling the printer process.
2. Performing the comparison of numbers.
3. Executing the command given by keyboard.
4. Computer Memory Management.
05. Which port is not compatible with a mouse?

(1) (2) (3) (4)

Page 1 of 10 Grade 10 - Information and Communication Technology

06. Consider the following statements.

(A)Random access memory (RAM) holds data until current stays alive.
(B)Hard disk and Flash Memory are secondary memory devices.
(C)DVD can be considered as a solid primary storage device.

1. Only A and B are true. 2. Only B and C are true.

3. Only A and C are true. 4. Above all are true.

07. What is the device used to connect two or more different networks and to communicate with each other?

1. Hub 2. Switch 3. Router 4.Repeater

.lk
08. Which Unguided media can be used for long distance data transmission?

cp
1. Radio waves 2. Micro waves
3. Fiber optic 4. Infrared waves

dn
09. Following are some statements written by a student. What is the most accurate statement/statements of

.e
given?

w
(A) A computer system outputs only soft copies and hard copies.
w
(B) A blu- ray disk can hold data more than modern hard disk does.
(C) Memory register is a volatile memory.
-w

(D) Printing cost is higher in an impact printer.

1. A and B only 2. B and C only 3. All above 4. C only

P

10. Which statement shows the ascending order related to the speed of data access in a processor?
C
N

1. Memory register, Cache memory, Random Access Memory, Hard disk.

2. Cache memory, Memory register, Random Access Memory, Hard disk.
3. Random Access Memory, Memory register, Cache memory, Hard disk.
n

4. Hard disk, Random Access Memory, Cache memory, Memory register,

io
at

11. What is equivalent to decimal 82?

uc

1. 10101102 2. 1238 3. 5216 4. 828

Ed

12. What can be the number system 352 belongs to?

(a) Binary (b) Octal (c) Decimal (d) Hexa decimal

1. A and B only 2. A, B and C only 3. B, C and D only 4. All above.

13. What is the binary equivalent of B416?

1. 10110111 2. 10110101 3. 10110100 4. 10110100

14. Which answer contains the Ascending order of the numbers?

1. 748, 5910, 1110012, 3E16 2. 1110012, 5910, 748, 3E16

3. 748, 1110012, 3E16, 5910, 4. 5910, 748, 1110012, 3E16

Page 2 of 10 Grade 10 - Information and Communication Technology

15. What is the bit pattern we get when encoding 5910 in to BCD?

1. 111011 2. 00111011 3. 01011001 4. 1011001

16. What is equal nearly to 2GB?

1. 2 X 109 byte 2. 2 X 1010 byte

3. 2 X 109 Kilo byte 4. 2 X 109 bit

17. Which answer contains the LSD and MSD of 0.5321010 in order?

1. 5 and 0 2. 5 and 1 3. 1 and 5 4. 0 and 5

18. The correct order of inputs for the given circuit to get 0 as output is,

.lk
cp
dn
1. 0 and 0 2. 0 and 1 3. 1 and 0 4. 1 and 1

19. 1(One) is the input for A, B and C in the given circuit. If the output to be 1(one), what is the logic gate you

.e
should use in the blank square of the circuit?

w
w
-w

1. 2. 3. 4.
P
C
N

20. Which is the correct Boolean expression for the following truth table?
A B F
n

0 0 1
io

0 1 1
at

1. A + ̅ 2. ̅ . B
1 0 1
uc

1 1 0 3.̅̅̅̅̅̅̅̅ 4. ̅̅̅̅̅̅
Ed

21. A student purchases a book (W), foot ruler (X) and a pencil (Y) or a pen (Y). Which Boolean expression
clearly explains the above situation?

1. W AND X OR(Y OR Z) 2. W AND X AND (Y OR Z)

3. W OR X OR(Y OR Z) 2. W AND X AND (Y AND Z)

22. The task performed by POST when a computer boot is,

1. Copy the operating system files in secondary memory to random access memory (RAM).
2. Access the main input output system through Central Processing Unit (CPU).
3. Check whether the hardware works properly.
4. Reads the instructions of first identified input method.

Page 3 of 10 Grade 10 - Information and Communication Technology

23. What is not an example for language translation software?
1. Assembler 2. Compiler
3. Thesaurus 4. Interpreter

24. The facility in operating system to share hardware like printer, scanner is provided by,
1. File management. 2. Network management.
3. Device management. 3. Process management.
25. What is not included in the tool of “Change Case” in a word processing software?
1. Sentence Case 2. UPPER CASE 3. little case 4.tOGGLE cASE

26. When Subscript the second number of adjunct two numbers in Word Processing Software it would be
displayed as,

.lk
1. 27 2. 27 3. 27 4. 27

cp
27. Which statement only contains Word Processing file formats?

dn
1. docx , doc, odt 2. docx, xlsx, odt
3. odt, pptx, doc 4. doc, jpg, docx

.e
28. What is the wrong cell reference address of electronic spread sheet?
1. CD$1 2. $XY6 3.C$A15
w 4. ABZ$100
w
-w
29. The percentage of marks obtained by four students is entered
in a spread sheet software. What is not the formula to be used to
find the highest percentage of all percentages?
P

1. +max (B2:C5) 2. = max (B2:C5)

C

3. = max (B2:B5, C2:C5) 4. = max (B2:B5; C2:C5)

N

30. What is the correct formula of a spread sheet software to find the total of given numbers?
n

A. =sum (A1:F1) B. =sum (A1+B1+C1, D1:F1) C. =sum (A1:C1, D1:F1)

io

1. A and B only 2. A only

at

3. A and C only 4. All above.

uc

31. The percentage given in D1 cell has to be added to the calculated average percentage of total marks
Janaka scored for two months. Same formula should be copied through cell D3 to cell D5 to get other
Ed

students’ averages. What is the correct formula to be used to get it done?

1. =(B2 +C2/2) +$D1 2. = B2 +C2)2+D$1)
3. =B2 +(C2/2) +D$1 4. = (B2 +C2)/2+D$1

32. What is not to be considered specification when buying a new computer?

1. Capacity of the hard disk. 2. Speed of the processor
3. Goodwill of the Company. 4. Capacity of Cache memory.

33. What is the facility to move slides sequentially in a presentation?

1. Slide transition. 2. Animation
3. Slide Show. 4. Slide Layout

Page 4 of 10 Grade 10 - Information and Communication Technology

34. What is the keyboard short cut key combination to use to change from current slide to slide show?

1. F5 2. Alt + F5 3. Ctrl + F5 4. Shift + F5

35. The facility to insert a selected area of the computer screen in to a document is called,

1. Copy + Paste 2. Print Screen 3. Screen Clipping 4. Insert -> Picture

● Use the following tables to answer question 36 and 37.

EMPLOYEE TABLE NIC DETAILS TABLE

.lk
36.

cp
dn
The EMPLOYEE table contains the employee details and NIC DETAILS table contains the details of the
employees Identity Card (ID). A relationship between the fields EMP_NO of 2 tables should be created
and the kind of relationship to make is,

.e
1. One to many. 2. One to one.
3. Many to many. 3. None above.
w
w
-w
37. The fields NIC_NO and EMP_NO of NIC DETAILS table are respectively suitable for,

1. Primary key and foreign key.

2. Primary key and composite key.
P

3. Foreign key and primary key.

C

4. Composite key and primary key.

N

38. As there are less than 200 employees in this organization the max number field property of EMP_NO field
of EMPLOYEE table has been set to 200. What quality of data is protected by this?
n
io

1. Consistency. 2. Effectiveness.
2. Protection. 4. Validity.
at
uc

39. Consider the following statements regarding the table of data base.

(A) There are 4 records and 3 fields in above NIC DETAILS table.
Ed

(B) Data forms are used to enter data in to tables.

(C) Selected information can be derived from two tables using a Query.
What is true of above?

1. A and C only 2. B and C only

3. A and B only 4. None of the above.

40. What is not a measure of protecting the computer against malicious software?

1. Using a suitable anti-virus software.

2. Carefulness of using external storages.
3. Using licensed software.
4. Refrain from downloading files from internet.

Page 5 of 10 Grade 10 - Information and Communication Technology

Grade 10 Information and Communication Technology - II

Instructions
I. Answer five questions only, selecting the first question and four others.
II. First question carries 20 marks and each of the other questions carries 10 marks.

(1)
I. The improvement of information and Communication Technology has paved the way for present
student generation to perform their education activities more attractively. Mention two such ways
where it would help students for better and attractive education.

.lk
II. Copy the A column of the following table in to your answer sheet and write the matching phrases in

cp
front of it selecting from column B.

(A) (B)

dn
A Belongs to the computer classification 1 Arithmetic and Logic Unit,
according to the size.

.e
B Element of E-state concept (G 2 B) 2 Nenasela
C
D
Can be found in Central Processing Unit.
Computer based learning concept.
3
4 w
Micro computers.
Registering a business organization.
w
-w

iii. Ruwan went to his uncle’s place to spend few days there. On the way there was heavy traffic block due
to the maintenance of the road. He saw the workers who were using walkie – talkie to control the
trafic and Ruwan informed his Uncle using his mobile phone about his delay.
P
C

a. Write the two transmission modes of the above mentioned devices.

N

b. Mention two types of unguided media used in data transmission.

n

iv. Name two memory types which have direct access to Central Processing Unit (CPU).
io

v. Write two advantage of Laser printer over dot matrix printer.

at

vi. Convert the number 110110012 in to a hexadecimal and octal number. Clearly mention the steps of
uc

calculation.
vii. Write two advantages of e-business.
Ed

viii. Match the tasks of the tools given in column B with the tools in column A and write.

A B
1 Getting the sum of a selected cell rage automatically.

2 Merge and center a cell range.

3 Separate a paragraph in to column.
4 Perform line spacing.

Page 6 of 10 Grade 10 - Information and Communication Technology

 ix. Select the most suitable words from brackets given below and fill blanks labeled a-e in the following
statements.

a. Dividing a hard disk in to required portions is called……………………. .

b. Preparing the hard disk to enable data storing using a file structure in an operating system is
called…………………….. .
c. It is better to……………………. a computer if the efficiency of the computer slows down.
d. Keeping a…………………. before formatting a computer ensures the protection of information.

( defragmentation / partitioning / backup / format )

.lk
cp
X. Answer the following question using
the given part of the spread sheet.

dn
.e
w
w
-w

Build a formula to find the sum of the cell range A1 to C1 and cell C3 using functions.
P

(2).
C

I. Write an example each for System software and Application software.

N

II. Name a utility software to protect computer against harmful software.

III. Write two tasks performed by an operating system.
n
io

IV. Write the names of the organization which introduced the following operating systems.
at

( Select the suitable word from the bracket given below )

A Windows ………………………………
uc

B Solaris ………………………………
C Android ………………………………
Ed

D. Mac OS ………………………………

( Google / Apple / Sun Microsystems / Microsoft )

V. Identify the file extension from column B for the type in column A and draw lines to match
them.
A B
File Type File Extention
Word .pptx
Excel .docx
PowerPoint .exe
Executable .xlsx

Page 7 of 10 Grade 10 - Information and Communication Technology

 3. A student intend to enter information of some goods purchased in spread sheet and to prepare a bill.
Answer the following questions given below with the help of given part of spread sheet related to
student requirement.

.lk
cp
dn
.e
I. What is the formula to be written in E3 cell to calculate the total value of CR BOOKS?
(Total value = quantity x unit price)
w
w
II. Write the steps require to find the total value of other goods by coping the above formula.(E2 to E12)
-w

III. The discount given in E1 is given based on the total value. Write the formula to use in F3 cell to
calculate total discount of CR BOOKS. (The discount of other goods should be able to get by
coping the same formula downwards the same column. All the discounts should get changed
P

automatically if the value of E1 is changed).

C
N

IV. Write the formula you should use to calculate Net value to be paid for each good in G3 cell.
( Net Value = total value – discount)
n
io

V. Write the formula to use in G13 cell to calculate total net value price to be paid for all goods.
at

(4). Students’ usage of computers in a school computer lab is given in the following data base tables.
uc

A student is allowed to use a computer once in a day. Answer the following questions related to
given tables.
Ed

Computer Table Students table Usage of computers table

type

i. Which field in Student table is suitable for primary Key?

ii. What is the most suitable field for Usage of computers table if you intend to use a composite
key?
iii. What sort of relationship type can be used if you intend to create a relationship between Students
table and Usage of computers Table?

Page 8 of 10 Grade 10 - Information and Communication Technology

 iv. Saroja has used a Dell computer in a certain day of the last month.
a) In which table/tables you would enter that data.
b) Write the updated records in table/tables for that data.

v. A new comer to the school, Nuwanthi in Grade 7B, registered in the school computer lab.
a) In which table/tables you would enter it?
a) Write the updated records in table/tables.

(5)

.lk
cp
(a)

dn
I. Draw and name the composite logic gate and the primary logic gate of the above circuit.
II. Write the Boolean expression of the above logic circuit.

.e
III. Create the truth table according to above Boolean expression.

(b) w
w
I. Name two coding systems used in a computer.
-w

II. Write 1 KB (byte) in Binary.

P

(6)
C

(a) At present using of Information and Communication Technology has made government service more
N

effective.

I) Write two ways of providing services using the e-government concept by a government.
n
io

II) Write two benefits/services we get of it.

at
uc

b) At present the Agriculture which used to be done using traditional methods for a long time has
become more productive with modern Information Communication Technology.
Ed

I) Name two automated machines with modern technology which have been using in agricultural
activities.

II) Write two ways of using Information and Communication Technology in Fisheries industry.

iii) Write two ways of using Information and Communication Technology in teaching learning process
in the class room.

Page 9 of 10 Grade 10 - Information and Communication Technology

(7)
(a) Secondary memory or secondary storage is used to permanently save data and information.
Hard disk is used to save high volume of data and information in a computer with more protection.
Following is a diagram of a hard disk with its parts.

.lk
cp
dn
I. Name two parts of above hard disk.

.e
II. Mention two optical media for data and information storing.

w
w
(b) Branches of a private bank called “Alfa” are located in cities like Mihinthale, Anuradhapura and
-w

Thambuththegama. All the branches are equipped with a network and they are connected with each
other for exchanging information.
P
C

I. What is the type of area network used to connect above branches of “Alfa” Bank?
N

II. Name two network topologies you would suggest for the network in Anuradhapura branch?
III. Write two advantages of computer networking.
n
io
at
uc
Ed

Page 10 of 10 Grade 10 - Information and Communication Technology