0% found this document useful (0 votes)
28 views5 pagesICT Paper I
The document outlines the General Certificate of Education (Ord. Level) Examination for Information & Communication Technology, including instructions for answering multiple-choice questions. It contains various questions related to computer hardware, software, programming, and database management, along with specific scenarios and coding challenges. The document serves as an examination paper for students to assess their knowledge in ICT for the academic year 2023-2024.
Uploaded by
Morgan HaleCopyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
0% found this document useful (0 votes)
28 views5 pagesICT Paper I
The document outlines the General Certificate of Education (Ord. Level) Examination for Information & Communication Technology, including instructions for answering multiple-choice questions. It contains various questions related to computer hardware, software, programming, and database management, along with specific scenarios and coding challenges. The document serves as an examination paper for students to assess their knowledge in ICT for the academic year 2023-2024.
Uploaded by
Morgan HaleCopyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
/ 5
(01/2023(2024)/80/E-1, IL 24733
ing © BEDS HEEB! apa yphinsfoiruen.gs/Al Rights Reserved]
ESTO
eOBeD Cor HAD 6 (GOD GoE) Smoaa, 2023(2024) |
aodoli OUT soraT USHT (TsTTEm By) ufone, 2023(2024)
General Certificate of Education (Ord. Level) Examination, 2023(2024) |
[emigd a aiGelen maeca L at ers 28
pean, Opnjuno CsnPerguciucd 1, 1 pays worhsBumaoid
UUnformation & Communication Technology 1, 1 Three hour
1S BaB® emcee = SAxtzy 10S Use additional reading time to go through the question paper,
Grooves aunty Cope - 10 ghuBiLtuassit select the questions and decide on the questions that you give
Additional Reading Time - 10 minutes Priority in answering,
Information & Communication Technology 1
Instruction
% Answer all questions.
% In each of the questions 1 to 40, pick one of the alternatives (1), (2), (3), (4) which is
correct or most appropriate.
% Mark a cross (X) on the number corresponding to your choice in the answer sheet provided.
% Further instructions are given on the back of the answer sheet. Follow them carefully.
1, Following four computers of the same brand are available at four different shops for the same
price. Each of them has a 1 TB hard disk, 1 VGA port and consumes the same amount of|
electricity. Which one is most suitable to buy?
(1) Processor: 2.9 GHz, Cache: 6MB, RAM: 4GB, 4 USB ports
(2) Processor: 3.1 GHz, Cache: 6MB, RAM: 4GB, 4 USB ports
(3) Processor: 3.6 GHz, Cache: 12MB, RAM: 8GB, 8 USB ports
(4) Processor: 3.6 GHz, Cache: 16MB, RAM: 8GB, 8 USB ports
2. Which of the following devices could be used to capture English text from printed documents?
(1) Bar Code Reader (2) Magnetic Ink Character Reader (MICR)
(3) Optical Character Recognition (OCR) device (4) Optical Mark Recognition (OMR) device
3. Which of the following is a solid state device?
(1) Compact Disk (2) Hard Disk Drive (3) Magnetic Tape Drive (4) USB Flash Drive
4. Which of the following executes the instructions of computer programs?
(1) Cache (2) Central Processing Unit (CPU)
(3) Hard Disk (4) Random Access Memory (RAM)
5. Which of the following is required to network four computers in a star topology?
(1) a firewall 2) a modem (3) a server (4) a switeh
6. Which of the following is the octal equivalent of decimal 216,,?
a) 40, 2) 43, @) 73, (4) 330,
7. Which of the following is the decimal equivalent of binary 1000 1000,?
() 24, (2) 136, (3) 272, (4) 1024,
8. Which of the following is the hexadecimal equivalent of octal 1572,?
(1) DES, Q) 37A,, (3) 3710, (4) 12562,,
9. One Terabyte (1 TB) is equal to
(1) 1024 KB. (2) 1024 x 1024 KB.
(3) 1024 x 1024 x 1024 KB. (4)_ 1024 x 1024 x 1024 x 1024 KB.
Thee page nwo (01/2023(2024)/80/E-1, IL
H10. Which of the following statements are true regarding the ASCII coding system?
A - Characters E and e are represented using the same code.
B - # and $ symbols have different codes.
Sinhala characters do not have ASCII codes.
() B only 2) Aand C only (3) Band C only (4) ANA, B and C
111. According to the adjacent logic circuit, what will be the 41
respective outputs at P and Q when A, B and C inputs are > _| P
B
respectively 1, 1 and 0?
c
() 0,0 @) 0,1 GB) 1,0 @) 1
12. What is the shortcut key combination in a word processing software to select the entire document?
() Cri +A Q) Cul +B (3) Cul + C @) Ctl + Vv
13. Which of the following icons in a word processing software can be used to align the left and
right sides of a text parallel to each other?
a @
Which of the following statements are correct regarding a word processing software?
‘A- It lets the user to add tables and images to a document.
= “=
14,
B- Format Painter tool (i) lets a user to copy formatting like font style and apply it to
other pieces of text.
C - Landscape and Portrait are the two page orientations available.
(1) A and B only (2) Aand C only) Band C only (4) AIA, B and C
15. Which of the following icons could be used to format a character as a subscript in a Word
Processing Software?
ak Q # @) fe oy
© To answer questions 16 and 17, consider the following spreadsheet segment which contains the
ICT marks obtained by students for three term tests
16, What is the formula to be entered into cell D9, =
to find the number of students who appeared
for the 3rd term test? 2 |shanaya s7 70 absent
(1) =COUNT(B2:D8) = sath os 5 6
(2) =COUNT(D2:D8) 4 Asjath 73 68 sbsent
UM(B2:D8) 5 [Bimsara oe 7 7
uM(D2:D8) 6 |vasukt 6 7 7
7 Malay 6 8 8S
117. What is the correct formula to be entered | 4 Vasanthar -40—=~*«DSSS
into cell E2 to calculate the average mark of |g
Shanaya for the three term tests? scr
(1) =(57470+absent)/3
Q) =(824C24D2)3
WERAGE(B2:D2)
18. Which of the following formulas (I, Hl, IH) contain valid cell addresses?
I: X$I$+YSI Tk: PS14$Q82 WI: M2*NS2
(1) Fand only) Tand TH only) Hand Mt only (4) All I, II and IIE
Isee page three 24733
(01/2023(2024)/80/E-1, IL
© Questions 19 to 22 are based on the following four partially shown database tables that are
designed for a bus seat reservation system,
Name
Colombo
Galle
Jaffna
ROUTE
Note: Routes are identified by the Route_code, Many routes can start from the same bus station
and many routes can end at the same bus station
Route_code "| From_bus station_code | To_bus_station_code
11 WI Ni
24 __W1 SI }
ROUTE_INSTANCE
Note: Assume there is only one trip per route per day.
Route_code Date Available_seats
Ll 01-07-2024 23
11 02-07-2024 35
| 21 (01-07-2024 34
21 (02-07-2024 35
SEAT_RESERVATION
Note: Seat_number uniquely identifies a seat
Route_code Date Seat_number | Passenger_name_| Passenger_phone
i 01-07-2024 | 1 ABCFemando | OWN
11 01-07-2024 2 DEF Sivarajah_| 0333333333
21 | 01-07-2024 1 _[-UIK Meerasahib [0222222292 |
19. What is most suitable to be the primary key of the ROUTE table?
(1) From_bus_station_code (2) Route_code
(3) To_bus_station_code (4) Route code + From_bus_station_code
120. What is most suitable to be the primary key of the SEAT_RESERVATION table?
(2) Route_code (2) Route_code + Date
(3) Route_code + Seat_number (4) Route_code + Date + Seat_number
|21. What is a foreign key in this database?
(1) Bus_station_code in the BUS_STATION table
(2) Date in the ROUTE_INSTANCE table
(3) Seat_number in the SEAT_RESERVATION table
(4) To_bus_station_code in the ROUTE table
122. If it is decided to add a description to each route (e.g., Kurunegala-Anuradhapura-Vavuniya to
Route 1_1), to which table should that field be added?
(2) BUS_STATION (2) ROUTE
(3) ROUTE_INSTANCE (4) SEAT_RESERVATION
23. The roots of a quadratic equation ax + bx +e=0 are found by the equation =belp dae
If a program is to be written to use this equation to find roots, what would be the inputs to this|
program?
(D a, be Q) ab, Poe GB) xa be (4) x, a,b, Boe
Tsee page four (012023(2024)/80/E-1, 11
'24, Suppose you are designing an algorithm to input an employee’s age, check if that employee is
eligible for retirement and output the result. The age of retirement is 60 years. Which of the
following control structures would be most appropriate to use in this algorithm?
(1) Selection only (2) Sequence only
(3) Iteration and selection only (4) Sequence and selection only
25. Consider the following P, Q and R logical expressions:
P: (A>= 10) AND NOT (B > 30)
Q: (A < 10) OR (B < 30)
(A <> 10) OR (B = 30)
If above A and B contain the values 10 and 10 respectively, which of the following represents
the correct outcomes of P, Q and R respectively?
(1) false, false, tate) false, true, true (3) true, true, false 4) true, true, true
26. Suppose you want to store the full name of a person i
suitable data type for that variable?
a variable. What would be the most!
(1) Boolean @) Char (3) Integer @) String
127. When operator precedence in Pascal is considered, what will be the result of 4—1*3+5?
(a) -4 2 6 @) 14 (4) 24
128. In which of the following instances would you use an if-then-else selection structure in
structured programming?
(1) to assign a value to the variable age and print the value stored in age
2) to validate a password entered by a user
(3) to calculate the sum of first 100 integers
(4) to repeat a task for 15 times
© Questions 29 and 30 are based on the Pascal codes shown in figures 1 and 2 respectively.
prema snnarents rogran Looptes
ae var 4, : integers
Untegers begin
begin for t t= 1 to 2 do
Sum is 0; 8 ie 4; begin
while 8<'5 do for j i 1 to 2 do
este wrtte(t.)s
sum i= sun + ends
a et ends
writeln(sun); Figure 2
ends
Figure 1
29. What would be the output if the code shown in Figure 1 is executed?
ao Q) 10 @) (4) 15
|30. Which nested control structure is visible in the Pascal code of Figure 2?
(1) iteration (2) iteration @) selection (4) selection
inside inside inside inside
iteration selection iteration selection
|31. A program written in which of the following programming languages can be executed directly
by the CPU of a computer?
() Assembly ac (3) machine language (4) Pascal
32. Which of the following statements are true?
A-- It is important to do ‘Identification of requirements’ correctly in both waterfall and iterative
incremental models
B - It is suitable if ‘integration testing’ is done only when the ‘unit tests’ are successful.
C - ‘System testing’ should be done only after ‘acceptance testing’.
() A and Bonly 2) Aand C only (3) Band C only (4) AMA, B and C
Thee page five 01./2023(2024)/80/E-T, T 5 24733
33. Which of the following will best help the users of a proposed system to get an idea of its
features and how it will appear?
(1) Interviews with system developers
(2) Questionnaires from system developers
(3) Sample reports / files given to system developers
(4) The prototypes of the proposed system shown by system developers
|34. Consider the following steps to send an email using a service like Gmail:
A Login to the email account B - Click ‘Send”
C - Click ‘Compose’ or ‘New’ D - Type the subject and the message
E - Type the “To” address
Which of the following gives the correct order of the above steps?
MA>B>TC>DSE QASC+E>D>B
QC>+B>E+D+A @MC+D+E>SA>B
38. Which of the following are true regarding the use of a particular software through Saa$ of cloud
computing?
‘A~ The client needs an Internet connection to use the software.
B - The client needs to design and code the software
C~- An agreement with the cloud service provider is required to use the software.
(2) A and B only (2) A and C only (3) B and C only (4) All A, B and C
36. Which of the following is essential to connect a computer to the Internet?
(1) a fiber optic connection (2) an uninterruptible power supply
(3) a web browser (4) a service from an Internet Service Provider
137. Which of the following statements are true regarding raster images?
A If an image uses n bits to keep information about each pixel, then that image is capable|
of displaying 2° colours.
B - Image resolution refers to the number of pixels that exist within an image.
CA graphic with a large number of bits per pixel and a high resolution has a small file
() A only 2) B only (3) A and B only 4) A and C only
38. Which of the following statements are true?
A= accdb is an example for a video file type.
B - MP3 is an example for an audio file type
C- The frames between two key frames in an animation are called tween frames.
(1) A and B only (2) A and C only (3) B and C only) All A, B and C
|39. You have been assigned to design a web page to be used by the out-patients to reserve times|
to meet doctors at a clinic of a government hospital. Which of the following is not essential to
be included on that page?
() A video showing the doctors treating the patients in the clinic
(2) Facility to view times available for reservation on a sclected date
(3) Facility to enter patient's name, NIC number and phone number to complete a reservation
(4) Information on dates and times the clinic is open and location of the clinic
40. Consider the following statement taken from an HTML file:
-![Dunhinda* width=]()