A/L ICT 2024
Marking Scheme
Model Paper
Moratuwa
This document /scheme has been prepared for the use of marking examination paper.
Some changes and alternative anaswers would be made by the teachers.
Amendments to be included.
1
Part – I – Suggested Answers
(1) 3 (11) 2 (21) 4 (31) 2 (41) 1
(2) 5 (12) 1 (22) 4 (32) 5 (42) 5
(3) 4 (13) 3 (23) 5 (33) 2 (43) 5
(4) 4 (14) 3 (24) 2 (34) 4 (44) 4
(5) 3 (15) 2 (25) 2 (35) 2 (45) 1
(6) 1 (16) 5 (26) 1 (36) 4 (46) 3
(7) 4 (17) 3 (27) 3 (37) 3 (47) 2
(8) 5 (18) 5 (28) 4 (38) 3 (48) 3
(9) 2 (19) 2 (29) 5 (39) 2 (49) ALL
(10) 5 (20) ALL (30) 2 (40) 2 (50) 3
2 x 50 = 100 marks
Part – II A – Suggested Answers
Question Marks
No.
(1)(a)(i) 2 marks
0.5 marks
for each
row
1st row –
bolded
and
centered
(1)(a)(ii) <html> 4 marks
<head>
<title> Application </title> fieldset
both – 0.5
</head>
<body> legend
<form method="post" action=""> both -0.5
<fieldset>
<legend> Enter details: </legend> text both –
1
<label for="fname">First name:</label><br> radio
<input type="text" id="fname" name="fname"><br> both– 1
<label for="lname">Last name:</label><br> checked –
<input type="text" id="lname" name="lname"><br><br> 0.5
Choose gender:<br> submit –
0.5
2
<input type="radio" id="male" name="gender" value="male"
checked>
<label for="male"> Male </label><br>
<input type="radio" id="female" name="gender" value="female">
<label for="female"> Female </label><br><br>
<input type="submit" name="sbt" value="Submit">
</fieldset>
</form>
</body>
(1)(b)(i)
<h1 style="color:red;text-align:center;"></h1> 1 marks
OR
<h1 style="color:red;"></h1>
<h1 style="text-align:center;"></h1>
(1)(b)(ii) p 1 marks
{ [0.5+0.5]
font-family: verdana; partial
font-size: 20px; marks can
} be given
(1)(c) - $conn
2 marks
- connect_error
- query [0.5 x 4]
- $conn -> close();
(2)(a)
① - Input / Enter / Get / Read Radius, Height 2 marks
Miu> cauk; Mfpatw;iw cs;sPL nra;f
[4 x 0.5]
② - Is Radius > 0 and Height > 0?
Is Miu > 0 kw;Wk; cauk; > 0?
③ - Volume = 3.14 x Radius x Radius x Height
fdtsT = 3.14 x Miu x Miu x cauk;
④ - Display Volume
fdtstpidf; fhl;rpg;gLj;jy;
(2)(b)
6791 2 marks
3
(2)(c) Line 5 → count = count + 1 2 marks
[1+1]
Line 6 → print(count) should be aligned with while.
(i) ④
(2)(d) 2 marks
(ii) ①
(iii) ③ [4 x 0.5]
(iv) ②
(2)(e)
• Syntax that is difficult to understand for humans. 2 marks
[1+1]
• Fast execution in comparison with high level programming langauges
• Machine/ assembly languages are considered as low level programming Any other
langauges. relevant
• No need to translate the source code for execution. answers
accepted
• FwpaPLfs; kdpju;fshy; Gupe;J nfhs;s fbdkhf ,Uf;Fk;.
• cau; epiy nra;epuyhf;f nkhopfSld; xg;gpLifapy; Ntfkhf
epiwNtw;wg;gLjy;.
• ,ae;jpuk; / xUq;FNru; nkhopfs; fPo; kl;l nra;epuyhf;f
nkhopfshff; fUjg;gLfpd;wd.
• nray;gLj;Jtjw;fhd %yf; FwpaPl;il nkhopngau;f;f Ntz;ba
mtrpakpy;iy.
(3)(a)
A. Virus 3 marks
[6 x 0.5]
B. Worm
C. Trojan horse
D. Spyware
E. Ransomware
F. Adware
(3)(b)
(i) Spiral model – RUsp khjpupak; 5 marks
[1 x 5]
(ii) Waterfall model – ePu;tPo;r;rp khjpupak;
(iii) Prototyping model – %ytif khjpupak;
(iv) RAD model – RAD khjpupak;
(v) Agile model – RWRWg;ghd khjpupak;
4
(3)(c)
2 marks
- Memory – epidtfk;
[4 x 0.5]
- Program counter – nra;epuy; vz;zp
- Control unit – fl;Lg;ghl;L myF
- Arithmetic logic unit – vz;fzpj jUf;f myF
(4) (a)
Customer – thbf;ifahsu; 5 marks
Payment gateway – gzk; nrYj;Jk; Eiothapy;
[10 x 0.5]
Warehouse – fsQ;rpak;
Customer details / login details – thbf;ifahsu; / gadu; fzf;F - Verb
tptuq;fs; form.
Customer – thbf;ifahsu; ,, -
Processing payment – fl;lzr; nrad;Kiwg;gLj;jy; singular
noun.
Payment confirmation / confirmation – fl;lz cWjpg;gLj;Jif /
cWjpg;gLj;Jif
Order / shipping details – fl;lis / tpepNahf tptuq;fs; Others –
noun.
Book inventory – Gj;jf ,Ug;G
Order details / order – fl;lis tptuq;fs; / fl;lis
(4)(b) 2 marks
Should be
the same
as table
given.
No partial
marks.
(4)(c) A - SYN 3 marks
B - SYN-ACK [1 x 3]
C - ACK
5
Part – II B – Suggested Answers
Question
No.
(5)(a)(i)
4 marks
𝑨 𝑩 𝑪 Z
0 0 0 1 0.5 marks
for each
0 0 1 1
row
0 1 0 0
0 1 1 0
1 0 0 1
1 0 1 1
1 1 0 1
1 1 1 0
(5)(a)(ii)
2 marks
K map – 1
marks
Grouping –
1 marks
(5)(a)(iii)
𝐴𝐶̅ + 𝐵̅ 2 marks
(5)(a)(iv) 2 marks
(𝐴 + 𝐵̅ )(𝐵̅ + 𝐶̅ )
(5)(b)(i)
𝐴𝐵̅ + 𝐴(𝐵
̅̅̅̅̅̅̅̅ ̅̅̅̅̅̅̅̅
+ 𝐶 ) + 𝐵(𝐵 + 𝐶) 2 marks
= 𝐴𝐵̅ + 𝐴. 𝐵̅. 𝐶̅ + 𝐵. 𝐵̅. 𝐶̅
= 𝐴𝐵̅ + 𝐴𝐵̅𝐶̅ Partial
= 𝐴𝐵̅(1 + 𝐶̅ ) marks can
= 𝐴𝐵̅.1 be given
= 𝐴𝐵̅
(5)(b)(ii)
̅̅̅̅̅̅̅̅
(𝐴 ̅ 𝐵̅
+ 𝐵 ) = 𝐴. 1 marks
̅̅̅̅̅
(𝐴. 𝐵) = 𝐴̅ + 𝐵̅ [0.5+0.5]
(5)(c)(i) 1 1 marks
(5)(c)(ii) S=0, R=0 1 marks
[0.5+0.5]
6
(6)(a)(i) 2 marks
• Routing – topg;gLjJif
Any other
• Logical Addressing / IP addressing – jUf;f / IP Kftupaply;
suitable
• Packet Forwarding – nghl;lyq;fis Kd;Ndhf;fp efu;j;Jjy; answers
• Packet fragmentation – nghl;lyq;fis Jz;lhf;Fjy; accepted
• Congestion Control – neUf;fb fl;Lg;ghL
(6)(a)(ii) LLC and MAC 2 marks
Logical Link Control / Media Access Control [1+1]
(6)(a)(iii)
1 1 0 1 0 0 0 1
3 marks
0r 0 marks
(6)(b)
Department Network Broadcast Subnet mask Usable ID 8 marks
s address address address
[2 marks
range
for each
Accounting 192.147.1.0 192.147.1.63 255.255.255.19 192.147.1.1 - row]
information 2 192.147.1.62
system
Marketing 192.147.1.64 192.147.1.12 255.255.255.19 192.147.1.65
7 2 -
192.147.1.12
6
Sales 192.147.1.12 192.147.1.19 255.255.255.19 192.147.1.12
8 1 2 9-
192.147.1.19
0
Production 192.147.1.19 192.147.1.25 255.255.255.19 192.147.1.19
2 5 2 3-
192.147.1.25
4
7
(7)(a)
StudentID Name 6 marks
CourseName
CourseID
[three
Email entities – 3
Credits
marks, two
M N relationshi
Student enrolls Course
ps - 1
M marks,
Date
cardinalitie
DateOfBirth teaches s - 1 marks,
Grade
attributes
and primry
1 keys – 1
Professor marks]
Department
ProfessorID Name
Tamil medium students must use the terms in Tamil for ER diagram.
Translation should not be used.
(7)(b)
If atable is in 3NF: 2 marks
[1+1]
It should be in 2NF and
There should be no transitive dependencies.
OR
A non-key attribute should not depend on another non-key attribute.
OR
All the deteraminants are keys.
xU ml;ltiz 3NF ,y; ,Ue;jhy;:
,J 2NF ,y; ,Uf;f Ntz;Lk; kw;Wk;
epiykhWifj; jq;fpapUj;jy;fs; ,Uj;jy;$lhJ.
my;yJ
xU rhtp my;yhj gz;G kw;nwhU rhtp my;yhj gz;Gfisr; rhu;e;J
,Uf;ff;$lhJ.
my;yJ
All the deteraminants are keys.
8
(7)(c)(i)
Update anomally will occur. 2 marks
[1+1]
Because InstructorPhone is changed in only one place for the Instructor
Dr.Smith.
,w;iwg;gLj;jy; Kuz; Vw;gLk;.
gapw;Wtpg;ghsu; Dr.Smith vd;gtupd; xNu xU ,lj;jpy; khj;jpuk;
InstructorPhone khw;wg;gLfpd;wJ.
(7)(c)(ii)
Student (StudentID, Name, Email, DateOfBirth) 2 marks
Course (CourseID, CourseName, Credits)
Professor (ProfessorID, Name, Department)
Enrollment (StudentID, CourseID, Grade, Date)
(7)(d)(i)
CREATE TABLE Customer (CustomerID VARCHAR(5) PRIMARY 1 marks
KEY, FirstName VARCHAR(25), LastName VARCHAR(25), Email Give marks
VARCHAR(25), PhoneNumber VARCHAR(10), City VARCHAR(50), even if
Country VARCHAR(50)); primary is
not.
(7)(d)(ii)
SELECT * FROM Customer WHERE City=’London’; 1 marks
(7)(d)(iii)
SELECT Country, COUNT(*) FROM Customers GROUP BY Country; 1 marks
1 marks
(8)(a)(i) 103
2 marks
(8)(a)(ii) 16 KB
(8)(a)(iii) • Slow Random Access 2 marks
9
• Extra Space for Pointers
• Reliability Issues
• Overhead in Managing Links
• Not Suitable for Indexed Files
• nkJthf vOkhw;W mZfy;
• Rl;bfSf;fhd Nkyjpf Nrkpg;G ntsp
• ek;gfj;jd;ik gpur;rpidfs;
• ,izg;Gf;fis epu;tfpg;gjpy; cs;s Nkd;jiy
• Rl;blg;gl;l Nfhg;Gf;fSf;F Vw;wJ my;y
(8)(b)(i) 216 bytes = 64 KB 2 marks
(8)(b)(ii)
16 2 marks
(8)(b)(iii)
4 bits 1 marks
(8)(c)(i)
Parallel deplyment 1 marks
rkhe;ju mKyhf;fk;
(8)(c)(ii)
As stated in the scenario, the new Hotel Management Software will 1 marks
run alongside the existing system for a trial period of 3 months.
NkNy ge;jpapy; jug;gl;lthW> Gjpa N`hl;ly; Kfhik nkd;nghUs;;
jw;NghJs;s KiwikAld; ,ize;J 3 khj Nrhjidf; fhyj;Jld;
,aq;Fk;.
(8)(c)(iii)
Integration testing 1 marks
xUq;fpiz Nrhjid
(8)(c)(iv) 2 marks
White Box Testing Black Box Testing
Tester requires knowledge of the Tester does not need any
internal code, design, and knowledge of the internal code
structure. or structure.
10
Focuses on internal workings, Focuses on the functionality and
code logic, and paths (e.g., output based on inputs, without
branches, loops). looking at the code.
Typically performed by Typically performed by testers or
developers or testers with end-users without needing
programming knowledge. programming knowledge.
(9)(a)(i)
LDR sensor is used to detect changes in ambient light levels. The LDR's 1 marks
resistance changes based on the amount of light falling on it.
LDR czupahdJ Rw;Wg;Gw xsp msTfspy; Vw;gLk; khw;wq;fisf;
fz;lwpag; gad;gLfpd;wJ. LDR ,d; jilahdJ mjd; kPJ tpOk;
xspapd; msitg; nghWj;J khWfpd;wJ.
(9)(a)(ii)
In this Arduino project, LDR in combination with an LED is used to create
1 marks
a basic night light. The Arduino reads the input from the LDR, and when
the ambient light falls below a certain threshold, it turns on the LED.
,e;j Arduino nraw;jpl;lj;jpy;> LDR MdJ LED cld; ,ize;J
,uT xspia cUthf;fg; gad;gLfpd;wJ. Arduino LDR ,ypUe;J
cs;sPl;ilg; ngWfpd;wJ> NkYk; Rw;Wg;Gw xsp xU Fwpg;gpl;l
tiuaiwf;Ff; Fiwthfr; nrd;why;> mJ LED I ,af;Ffpd;wJ.
(9)(a)(iii)
3 marks
- 2 or ledPin [1 x 3]
- A0 or ldrPin
- ldrStatus
(9)(b)(i)
B2C or Busines to Customer or Business to Consumer 1 marks
tpahghuj;jpypUe;J thbf;ifahsUf;F / tpahghuj;jpypUe;J
Efu;NthDf;F
(9)(b)(ii)
• Social Media 1 marks
Any two
• Email Marketing
• Search Engine Optimization (SEO)
11
• Influencer Partnerships (Bloggers / Youtubers)
• SMS
• r%f Clfq;fs;
• kpd;dQ;ry; re;ijg;gLj;jy;
• NjLnghwp cfg;ghf;fk; (SEO)
• Influencer Partnerships (Bloggers / Youtubers)
• SMS
(9)(b)(iii) 1 marks
Online sales revenue model
Any two
Online advertising model
Affiliate Revenue Model
Transaction Fee Revenue Model
njhluwh tpw;gid tUthd khjpupak;
njhluwh tpsk;gu khjpupak;
,ize;j tUthd khjpupak;
gupkhw;w fl;lz tUtha; khjpupak;
(9)(b)(iv)
Customer support directly impacts customer satisfaction and loyalty. 1 marks
TechMart implements a robust 24/7 customer support system. Any
suitable
thbf;ifahsu; MjuT Neubahf thbf;ifahsu; jpUg;jp kw;Wk; short
tpRthrj;jpy; jhf;fk; nrYj;jfpd;wJ. TechMart xU tYthd 24/7 answers
accepted.
thbf;ifahsu; MjuT Kiwikapidr; nraw;gLj;Jfpd;wJ.
No need to
• Resolve queries from customers explain.
• Handle returns and refunds
• Post-purchase customer support
• thbf;ifahsuplkpUe;jhd tpdty;fisj; jPu;j;jy;;
• nghUl;fisj; jpUk;gg; ngWjy;> gzk; kPsr; nrYj;Jjy;
Mfpatw;iwf; ifahSjy;
• nfhs;tdtpw;Fg; gpd;duhd thbf;ifahsu; MjuT
12
(9)(c)(i)
3 marks
Inventory
management agent 0.5 for
each
entities and
customer
Product
Customer recommendation
ChatBot Give
support agent agent
partial
Customer
marks
Order processing
agent
(9)(c)(ii) An autonomous customer support agent can handle basic queries and
processes without human intervention. This reduces the need for 1 marks
human customer support staff and allows the business to offer 24/7
customer service, improving response times and customer satisfaction. Any
auitable
xU jd;dhl;rp thbf;ifahsu; MjuT Kftu; mbg;gil tpdty;fs; answers
accepted.
kw;Wk; nrad;Kiwfis kdpjj; jiyaPL ,y;yhky; ifahs
KbAk;. ,J kdpj thbf;ifahsu; MjuT Copau;fspd; Njitia Short
Fiwf;fpd;wJ kw;Wk; tpahguhkhdJ 24/7 thbf;ifahsu; Nritia answers
toq;f mDkjpf;fpd;wJ> gjpyspg;G Neuk; kw;Wk; thbf;ifahsu; OK.
jpUg;jpia Nkk;gLj;Jfpd;wJ.
(9)(c)(iii) Customer support, product recommendations, inventory management, and 2 marks
order processing agents. 0.5 for
each
,Ug;G Kfhik Kftu;> thbf;ifahsu; MjuT Kftu;>
cw;gj;jp gupe;Jiu Kftu;> fl;lis nrad;Kiw Kftu;
13
(10)(a)
Start 5 marks
[0.5 for
i=0 every
Sum = 0 sysmbol
and
meaning
Enter a number, max and
remainings
for proper
flowlines]
Is No
i < 10 ?
Yes
Enter a number, X Display Max
End
Is No
X > max ?
Yes
Max = X
i=i+1
(10)(b) 2 marks
A – False B – target C – True D – i=i+1 0.5 for
each
(10)(c)(i) 2 marks
720
(10)(c)(ii) 2 marks
Displaying multiplied value of 10 positive numbers entered by user. Give
partial
gaduhy; cs;sPL nra;ag;gl;l 10 Neu; vz;fspd; ngUf;fy; marks
ngWkjpapidf; fhl;rpg;gLj;Jfpd;wJ.
(10)(c)(iii)
r=1 4 marks
i=1
while i<=10:
14
n=int(input("Enter a number:")) [0.5 marks
if n>=0: for each
r= r*n line]
i=i+1 Equivalent
print(r) logic
accepted
Final Marks Distribution
Part –I 2 x 50 = 100 marks, Part – II A 10 x 4 = 40 marks, Part – II B 15 x 4 = 60 marks
Total: 200 / 2 = 100 marks
****
15
