Skip to content

Information Technology Grade 12 P1 2021 Memo (Eng)

MemorandumInformation TechnologyGrade 12202116 pages

Grade 12 Information Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2021 (English), 16 pages. Read online or download the free PDF.

Free to read online, no sign-up needed

Answer online

Loading document…

Loading document…

Questions in this paper

Document textSearch extracted text and jump to a page.
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.
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

More from Grade 12 Information Technology

View all