Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
SEPTEMBER 2021
INFORMATION TECHNOLOGY P1
MARKING GUIDELINE
MARKS: 150
This marking guideline consists of 16 pages.
Skip to contentAll 2021 papers 





View all





Information Technology Grade 12 P1 2021 Memo (Eng)
Grade 12 Information Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2021 (English), 16 pages. Read online or download the free PDF.
Information Technology · Grade 12 · Eastern Cape Mock Exam · 2021. Memorandum, 16 pages. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2021
- Exam period
- Eastern Cape Mock Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 16
- File size
- 132.0 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 16
This exam
Eastern Cape Mock Exam 2021
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
2 INFORMATION TECHNOLOGY P1 (EC/SEPTEMBER 2021)
NAME OF LEARNER:
TOTAL TOTAL TOTAL TOTAL
QUESTION 1: QUESTION 2: QUESTION 3: QUESTION 4: TOTAL
/40 /40 /38 /32 /150
MAX. MARKS
QUESTION 1: GENERAL PROGRAMMING SKILLS MARKS ACHIEVED
1.1 Button [1.1]
Load image to image file 9
3
Enable pnlBath 9
Colour of pnlRain changed to aqua 9
1.2 Button [1.2 Process]
Get rain input from cmbRain or use the itemindex 9
Extract the amount of millimetres:
Check rain input for ‘/’ 9
If no ‘/’ in input 9 then get the number and convert to real 9
Else 9
Convert the amount of millimetres correctly for 1/10 9and 1/5
9
Alternative solution: 11
Use case with cmbRain itemindex to obtain the mm correctly 9
0 : set mm to 0.1 9
1 : set mm to 0.5 9
All other indexes set to correct mm amounts 99
End of case 9
Get inputs from spinedits 9
Calculate width * height * rain input / 150 9
Display in pnlBaths 9 rounded to 1 decimal place 9
1.3 Button [1.3 Find rainfall type]
Check edtRain for integer input 9
Display a message 9 and exit 9 if not an integer 9
Alternative solution:
Use val 9
If icode <> 0 9 then showmessage 9 and exit 9
13
Get input from edtRain 9
Use case or nested if statements 9
0 : lblraintype.Caption := 'No rain'; 9
1 .. 3 : lblraintype.Caption := 'Moderate rain'; 9
4 .. 7 : lblraintype.Caption := 'Heavy rain'; 9
8 .. 9 : lblraintype.Caption := 'Very heavy rain'; 9
10 .. 50 : lblraintype.Caption := 'Heavy shower'; 9
else 9 lblraintype.caption := 'Flood'; 9
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) INFORMATION TECHNOLOGY P1 3
1.4 Button [1.4 Display Rainfall]
Loop 8 times 9
Use a loop 9 to generate two different 9 random numbers 9
in range from 5 to 10 9
If a random number = 5 9
Then add 1 to LstQuantity index 0 9
If a random number = 10 9
Then add 1 to LstQuantity index 1 9
13
Calculate total quantity using LstQuantity items converted
to integer 9
Display total in LstQuantity index 2 converted to string 9
Add LstQuantity values to heights of the two shapes 9
Correct shapes using correct items converted to integer 9
TOTAL QUESTION 1 40
Copyright reserved Please turn over
Downloaded from hlayiso.com
4 INFORMATION TECHNOLOGY P1 (EC/SEPTEMBER 2021)
MAX. MARKS
QUESTION 2: DATABASE PROGRAMMING
MARKS ACHIEVED
2.1.1 Button: [2.1.1]
SQL: 'select * from Status order by Statusname DESC'
Concepts:
SELECT correct field 9 3
FROM correct table 9
ORDER BY correct field DESC 9
2.1.2 Button: [2.1.2]
SQL: 'Select Birdname from Bird where Sightings < 200'
Concepts:
SELECT correct field 9
3
FROM correct table 9
WHERE Sightings <200 9
2.1.3 Button: [2.1.3]
SQL: 'Select Birdname, Lastsighted from Bird where Birdname
like ' + quotedstr('%' + sline + '%')
Concepts:
SELECT two correct fields 9 4
FROM correct table 9
WHERE Birdname LIKE 9
quotedstr('%' + sline + '%') 9
2.1.4 Button: [2.1.4]
SQL: 'Delete from Bird where (StatusID = 6) OR (StatusID = 5)'
Concepts:
4
DELETE from Bird 9
WHERE StatusID = 6 9 OR 9 StatusID = 5 9
2.1.5 Button: [2.1.5]
SQL: 'select Statusname, Birdname from Bird, Status where
Bird.StatusID = Status.StatusID'
Concepts:
SELECT two correct fields 9 3
FROM two correct tables 9
WHERE clause to join two tables 9
2.1.6 Button: [2.1.6]
'Select StatusID,format(avg(Sightings),"fixed",1) as
AverageSightings from Bird where year(Lastsighted) = 2007
group by StatusID'
SELECT StatusID, 9
format(avg 9 (Sightings),"fixed",2) 9 8
AS AverageSightings 9
FROM Bird 9
WHERE year(Lastsighted) 9 = 2007 9
GROUP by StatusID 9
2.1 Subtotal: SQL 25
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) INFORMATION TECHNOLOGY P1 5
2.2.1 Button: [2.2.1]
tblbird.First; 9
while not tblbird.eof do 9
if pos('EAGLE',uppercase(tblbird['Birdname'])) 9 <> 6
0 then 9
reddisplay.Lines.Add(tblbird['Birdname']); 9
tblbird.Next; 9
2.2.2 Button: [2.2.2]
icount := 0; 9
tblbird.First;
while not tblbird.eof do 9
begin
if tblbird['StatusID'] = 3 then 9
begin
tblbird.Edit; 9
9
tblbird['StatusID'] := 2; 9
tblbird.Post; 9
inc(icount) 9
end;
tblbird.Next; 9
end;
reddisplay.Lines.Add('Number of changes made = ' +
inttostr(icount)); 9
2.2 Subtotal: Code constructs 15
TOTAL QUESTION 2 40
Copyright reserved Please turn over
Downloaded from hlayiso.com
6 INFORMATION TECHNOLOGY P1 (EC/SEPTEMBER 2021)
MAX. MARKS
QUESTION 3: OBJECT-ORIENTATED PROGRAMMING
MARKS ACHIEVED
3.1.1 Constructor Create:
Correct name 9 with four string parameters 9
Set attributes to correct parameter values 9 4
Set fQuantity to 1 9
3.1.2 function getsightings: integer;
Correct method – integer function 9
2
Return correct attribute fQuantity 9
3.1.3 procedure increasequantity(iqty: integer);
Correct method – procedure 9
one integer parameter 9 4
Add parameter 9 to fQuantity 9
3.1.4 function sightinggap: string;
Correct method – string function 9
Get year 9 from todays year 9
Get year from date attribute 9 7
Subtract attribute year from current year 9 as integers 9
Return result with correct words appended 9
3.1.5 function tostring: string;
correct string method 9
result returned with string compiled with correct 5
attributes 9 use #13, 9 correct wording. 9 Use
SightingGap function 9
3.1 Subtotal: Object class 22
3.2.1 Button [Q3.2.2]
Get inputs from two edits 9
Get input from combobox 9 and radiogroupbox 9
Get inputs from spinedits 9
Instantiate the object
11
Object name = 9 tsighting.create 9
with four string parameters 9
In correct order 9
Display empty line in richedit 9
Use method of class 9 and object name to display 9
3.2.2 Button [Q3.2.1]
Use object name 9 and method of the class 9 to increase
quantity using sedSightings 9 5
Display in richedit using object name 9 and correct
method 9
3.2 Subtotal: Form class 16
TOTAL QUESTION 3 38
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) INFORMATION TECHNOLOGY P1 7
MAX. MARKS
QUESTION 4: PROBLEM SOLVING
MARKS ACHIEVED
4.1 icount := 0; isum := 0; 9
assignfile(myfile, 'water.txt'); 9
reset(myfile); 9
while not eof(myfile) do9
readln(myfile, soneline); 9
inc(icount); 9
add type 9 to arrtypes 9
add quantity to arrqty 9
isum := isum + arrqty[icount]; 9
for k := 1 to icount - 1 do 9
for l := k + 1 to icount do 9
if arrqty[k] > arrqty[l] then 9
itemp := arrqty[k]; 19
arrqty[k] := arrqty[l]; 9
arrqty[l] := itemp;
stemp := arrtypes[k];
arrtypes[k] := arrtypes[l]; 9
arrtypes[l] := stemp;
for k := 1 to icount do 9
reddisplay.Lines.Add(arrtypes[k] 9+ #9 +
inttostr(arrqty[k])); 9
reddisplay.Lines.Add('Total number of people = ' +
inttostr(isum)) 9
4.2 for k := 1 to icount do 9
iperc := round 9 (arrqty[k] 9 /isum *100 9);
arrperc[k] := iperc; 9
for k := 1 to icount do 9
sline := arrtypes[k] + #9; 9
case arrperc[k] of 9 (use end of case correctly) 13
1..5 : sline := sline + 'X'; 9
6..10 : sline := sline +#9 + 'X'; 9
11..20 : sline := sline +#9 + #9 + 'X'; 9
21..50 : sline := sline +#9 + #9 + #9 + 'X'; 9
end;
reddisplay.lines.add(sline); inside the loop 9
TOTAL QUESTION 4 32
Copyright reserved Please turn over
Downloaded from hlayiso.com
8 INFORMATION TECHNOLOGY P1 (EC/SEPTEMBER 2021)
SAMPLE SOLUTIONS
QUESTION 1
procedure TfrmQuestion1.btnQ1_1Click(Sender: TObject); // 3 marks
begin
imgrain.picture.LoadFromFile('rain.jpg');
pnlbath.enabled := true;
pnlrain.Color := claqua;
end;
procedure TfrmQuestion1.btnQ1_2Click(Sender: TObject); // 11 marks
var
rrain : real;
srain : string;
begin
srain := cmbrain.Text;
if copy(srain,2,1) <> '/' then
begin
rrain := strtofloat(copy(srain,1, pos(' ',srain) - 1));
end
else
if copy(srain,3,1) = '1' then
rrain := 0.1
else
rrain := 0.5;
pnlbaths.Caption := floattostrf(sedheight.value * sedwidth.value * rrain / 150, fffixed,8,1);
end;
procedure TfrmQuestion1.btnQ1_3Click(Sender: TObject); // 13 marks
var irain, inum, icode : integer;
begin
val(edtrain.Text, inum, icode);
if icode <> 0 then
begin
showmessage('Enter only an integer');
exit;
end;
irain := strtoint(edtrain.Text);
case irain of
0 : lblraintype.Caption := 'No rain';
1 .. 3 : lblraintype.Caption := 'Moderate rain';
4 .. 7 : lblraintype.Caption := 'Heavy rain';
8 .. 9 : lblraintype.Caption := 'Very heavy rain';
10 .. 50 : lblraintype.Caption := 'Heavy shower';
else
lblraintype.caption := 'Flood';
end;
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) INFORMATION TECHNOLOGY P1 9
procedure TfrmQuestion1.btnQ1_4Click(Sender: TObject); // 13 marks
var iran1, iran2, k, itotal: integer;
begin
for k := 1 to 8 do
begin
repeat
iran1 := randomrange(5,11);
iran2 := randomrange(5,11);
until (iran1 <> iran2);
if iran1 = 5 then
lstQuantity.Items[0] := inttostr(strtoint(lstQuantity.Items[0])+1);
if iran2 = 10 then
lstQuantity.Items[1] := inttostr(strtoint(lstQuantity.Items[1])+1);
end;
itotal := strtoint(lstQuantity.Items[0]) + strtoint(lstQuantity.Items[1]);
lstQuantity.Items[2] := inttostr(itotal);
shp5mm.Height := shp5mm.Height + strtoint(lstQuantity.Items[0]);
shp10mm.Height := shp10mm.Height+ strtoint(lstQuantity.Items[1]);
end;
//provided code do not delete///////////
procedure TfrmQuestion1.FormActivate(Sender: TObject);
begin
lstQuantity.Items[0] := inttostr(0);
lstQuantity.Items[1] := inttostr(0);
lstQuantity.Items[2] := inttostr(0);
end;
//////////////////////////////////////////
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
10 INFORMATION TECHNOLOGY P1 (EC/SEPTEMBER 2021)
QUESTION 2
/====================================================================
// Question 2.1.1 3 marks
//===================================================================
==
procedure TQuestion_2.btnQuestion2_1_1Click(Sender: TObject);
var
sSQL1: String;
begin
sSQL1 := 'select * from Status order by Statusname DESC';
// Provided code - do not change
dbCONN.runSQL(sSQL1);
end;
//===================================================================
==
// Question 2.1.2 3 marks
//===================================================================
==
procedure TQuestion_2.btnQuestion2_1_2Click(Sender: TObject);
// Provided code - do not change/
var
sSQL2: String;
begin
// Provided code - do not change//////////////////////
sSQL2 := 'Select Birdname from Bird where Sightings < 200';
// Provided code - do not change
dbCONN.runSQL(sSQL2);
end;
//===================================================================
==
// Question 2.1.3 4 marks
//===================================================================
==
procedure TQuestion_2.btnQuestion2_1_3Click(Sender: TObject);
// Provided code - do not change
var
sline : string;
sSQL3: String;
begin
sline := inputbox('Enter a bird name','','vulture');
sSQL3 := 'Select Birdname, Lastsighted from Bird where Birdname like ' + quotedstr('%'
+ sline + '%');
// Provided code - do not change
dbCONN.runSQL(sSQL3);
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) INFORMATION TECHNOLOGY P1 11
//===================================================================
==
// Question 2.1.4 4 marks
//===================================================================
==
procedure TQuestion_2.btnQuestion2_1_4Click(Sender: TObject);
// Provided code - do not change
var
sSQL4: String;
begin
sSQL4 := 'Delete from Bird where (StatusID = 6) OR (StatusID = 5)';
// Provided code - do not change
dbCONN.executeSQL(sSQL4,dbgstatus,dbgbird,dbgqrybird);
end;
//===================================================================
==
// Question 2.1.5 3 marks
//===================================================================
==
procedure TQuestion_2.btnQuestion2_1_5Click(Sender: TObject);
// Provided code - do not change
var
sSQL5: String;
begin
sSQL5 := 'select Statusname, Birdname from Bird, Status where Bird.StatusID =
Status.StatusID' ;
// Provided code - do not change
dbCONN.runSQL(sSQL5);
end;
//===================================================================
==
// Question 2.1.6 8 marks
//===================================================================
==
procedure TQuestion_2.btnQuestion2_1_6Click(Sender: TObject);
// Provided code - do not change
var
sSQL6: String;
begin
sSQL6 := 'Select StatusID,format(avg(Sightings),"fixed",1) as AverageSightings from Bird
where year(Lastsighted) = 2007 group by StatusID';
// Provided code - do not change
dbCONN.runSQL(sSQL6);
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
12 INFORMATION TECHNOLOGY P1 (EC/SEPTEMBER 2021)
//===================================================================
==
// Question 2.2.1 6 marks
//===================================================================
==
procedure TQuestion_2.btnQuestion2_2_1Click(Sender: TObject);
begin
reddisplay.Clear;
/// enter your code below//
tblbird.First;
while not tblbird.eof do
begin
if pos('EAGLE',uppercase(tblbird['Birdname'])) <> 0 then
reddisplay.Lines.Add(tblbird['Birdname']);
tblbird.Next;
end;
end;
//===================================================================
==
// Question 2.2.2 9 marks
//===================================================================
==
procedure TQuestion_2.btnQuestion2_2_2Click(Sender: TObject);
var icount : integer;
begin
reddisplay.Clear;
/// enter your code below//
icount := 0;
tblbird.First;
while not tblbird.eof do
begin
if tblbird['StatusID'] = 3 then
begin
tblbird.Edit;
tblbird['StatusID'] := 2;
tblbird.Post;
inc(icount)
end;
tblbird.Next;
end;
reddisplay.Lines.Add('Number of changes made = ' + inttostr(icount));
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) INFORMATION TECHNOLOGY P1 13
QUESTION 3
Class Unit:
unit Question3ClassDefinition;
interface
uses sysutils, dialogs, math;
type
tsighting = class (tobject)
private
fname : string;
farea : string;
fbird : string;
fdate : string;
fquantity : integer;
public
constructor create(sbirder,sarea,sbirdname,sdateviewed : string);
procedure increasequantity(iqty : integer);
function sightinggap : string;
function tostring : string;
function getsightings : integer;
end;
implementation
{ tsighting }
// 4 marks
constructor tsighting.create(sbirder, sarea, sbirdname, sdateviewed: string);
begin
fname := sbirder;
farea := sarea;
fbird := sbirdname;
fdate := sdateviewed;
fquantity := 1;
end;
//2 marks
function tsighting.getsightings: integer;
begin
result := fquantity;
end;
// 4 marks
procedure tsighting.increasequantity(iqty: integer);
begin
fquantity := fquantity + iqty;
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
14 INFORMATION TECHNOLOGY P1 (EC/SEPTEMBER 2021)
// 7 marks
function tsighting. sightinggap: string;
var stoday, syear: string;
begin
stoday := datetostr(date);
stoday := copy(stoday,1,4);
syear := fdate;
delete(syear,1,pos('/',syear));
delete(syear,1,pos('/',syear));
result := inttostr(strtoint(stoday) - strtoint(syear)) + ' years since first sighting';
end;
// 5 marks
function tsighting.tostring: string;
begin
result :=
fname + ' first viewed a ' + fbird + #13
+ sightinggap + ' at ' + farea + ' on ' + fdate;
end;
end.
Main Unit:
/// provided code do not delete ///
var
frmQuestion3: TfrmQuestion3;
objbirder: tsighting;
implementation
{$R *.dfm}
procedure TfrmQuestion3.btnQ3_2_1Click(Sender: TObject); // 11 marks
var sname, sarea, sbird , sdate: string;
iday, imth, iyr : integer;
begin
sname := edtbirdername.text;
sarea := cmbarea.Text;
sbird := rdgbirds.Items[rdgbirds.ItemIndex];
sdate := inttostr(sedday.Value) + '/' + inttostr(sedMonth.Value) + '/' +
inttostr(sedyear.Value);
objbirder := tsighting.create(sname, sarea, sbird, sdate);
reddisplay.lines.add('');
reddisplay.lines.add(objbirder.tostring);
end;
procedure TfrmQuestion3.btnQ3_2_2Click(Sender: TObject); // 5 marks
begin
objbirder.increasequantity(sedsighting.value);
reddisplay.Lines.Add('Total sightings so far: ' + inttostr(objbirder.getsightings));
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2021) INFORMATION TECHNOLOGY P1 15
QUESTION 4
var
frmQuestion4: TfrmQuestion4;
arrtypes : array[1..100] of string;
arrqty : array[1..100] of integer;
icount, isum : integer;
implementation
// Question 4 .1 19 marks
procedure TfrmQuestion4.btnQ4_1Click(Sender: TObject);
var
myfile : textfile;
soneline : string;
k,l : integer;
stemp : string;
itemp : integer;
begin
// provided code do not delete///
reddisplay.Clear;
reddisplay.Paragraph.TabCount := 1;
reddisplay.Paragraph.Tab[0] := 100;
////////////////////////////////////////////////
icount := 0;
isum := 0;
assignfile(myfile, 'water.txt');
reset(myfile);
while not eof(myfile) do
begin
readln(myfile, soneline);
inc(icount);
arrtypes[icount] := copy(soneline,1, pos(',', soneline) - 1);
delete(soneline,1, pos(',', soneline));
arrqty[icount] := strtoint(soneline);
isum := isum + arrqty[icount];
end;
for k := 1 to icount - 1 do
for l := k + 1 to icount do
if arrqty[k] > arrqty[l] then
begin
itemp := arrqty[k];
arrqty[k] := arrqty[l];
arrqty[l] := itemp;
stemp := arrtypes[k];
arrtypes[k] := arrtypes[l];
arrtypes[l] := stemp;
end;
for k := 1 to icount do
reddisplay.Lines.Add(arrtypes[k] + #9 + inttostr(arrqty[k]));
reddisplay.Lines.Add('');
reddisplay.Lines.Add('Total number of people = ' + inttostr(isum))
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
16 INFORMATION TECHNOLOGY P1 (EC/SEPTEMBER 2021)
// Question 4 .2 13 marks
procedure TfrmQuestion4.btnQ4_2Click(Sender: TObject);
var iperc : integer;
arrperc : array[1..100] of integer;
k : integer;
sline : string;
begin
// provided code do not delete //////////////////////
reddisplay.Clear;
reddisplay.Paragraph.TabCount := 4;
reddisplay.Paragraph.Tab[0] := 100;
reddisplay.Paragraph.Tab[1] := 140;
reddisplay.Paragraph.Tab[2] := 180;
reddisplay.Paragraph.Tab[3] := 220;
reddisplay.Lines.Add(#9 +'Percentage ranges');
reddisplay.lines.add('Type' + #9 + '1-5' + #9 + '6-10' + #9 + '11-20' + #9 + '21-50');
reddisplay.Lines.Add('---------------------------------------------------------------------------------');
////////////////////////////////////////////////////////////////////////
for k := 1 to icount do
begin
iperc := round(arrqty[k]/isum *100);
arrperc[k] := iperc;
end;
for k := 1 to icount do
begin
sline := arrtypes[k] + #9;
case arrperc[k] of
1..5 : sline := sline + 'X';
6..10 : sline := sline +#9 + 'X';
11..20 : sline := sline +#9 + #9 + 'X';
21..50 : sline := sline +#9 + #9 + #9 + 'X';
end;
reddisplay.lines.add(sline);
end;
end;
Copyright reserved Please turn over
Study this subject
Recommended for this subject

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2021 QP

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2021 QP

Memorandum
Information Technology Grade 12 P2 2021 Memo (Eng)

Memorandum
Information Technology Grade 12 P1 2022 Memo (Afr)

Memorandum
Information Technology Grade 12 P1 2022 Memo (Eng)

Memorandum
Information Technology Grade 12 P1 2019 Memo (Eng)
More from Grade 12 Information Technology

Question paper
Information Technology Grade 12 P2 Eastern Cape Mock 2025 QP

Question paper
Information Technology Grade 12 P2 2024 QP (Afr)

Question paper
Information Technology Grade 12 P2 2024 QP (Eng)

Question paper
Information Technology Grade 12 P1 November 2024 NSC QP

Question paper
Information Technology Grade 12 P2 November 2024 NSC QP

Memorandum