Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE12
INFORMATION TECHNOLOGY P1
EXEMPLAR 2018
MARKING GUIDELINES
MARKS: 150
These marking guidelines consist of 25 pages.
Copyright reserved Please turn over
Skip to contentAll 2018 papers 





View all





Information Technology Grade 12 P1 Exemplar 2018 Memo (Eng)
Grade 12 Information Technology Paper 1 memorandum from the Exemplar 2018 (English), 25 pages. Read online or download the free PDF.
Information Technology · Grade 12 · Exemplar · 2018. Memorandum, 25 pages. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2018
- Exam period
- Exemplar
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 25
- File size
- 630.3 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 25
This exam
Exemplar 2018
- Paper 1Question paperMemo
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Information Technology/P1 2 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
GENERAL INFORMATION:
• These marking guidelines are to be used as the basis for the marking session.
They were prepared for use by markers. All markers are required to attend a
rigorous standardisation meeting to ensure that the guidelines are consistently
interpreted and applied in the marking of candidates' work.
• Note that learners who provide an alternate correct solution to that given as
example of a solution in the marking guidelines will be given full credit for the
relevant solution, unless the specific instructions in the paper was not followed or
the requirements of the question was not met
• Annexures A, B, C and D (pages 3 to 10) include the marking grid for each
question.
• Annexures E, F, G and H (pages 11 to 24) contain examples of solutions for
Questions 1 to 4 in programming code.
• Copies of Annexures A, B, C and D (pages 3 to 10) should be made for each
learner and completed during the marking session.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 3 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
ANNEXURE A
QUESTION 1: MARKING GRID – GENERAL PROGRAMMING SKILLS
CENTRE NUMBER: EXAMINATION NUMBER:
MAX. LEARNER'S
QUESTION DESCRIPTION
MARKS MARKS
1.1 Button - [1.1 Register Player]
Test if name edit box > '' ✓and ✓e-mail edit box > ''✓
Display message which includes the name and e-mail
6
address entered ✓
Else ✓
Display a suitable message – data incomplete ✓
1.2 Button - [1.2 Calculate Cost of Meal]
Variable declaration
Integer✓ Real✓ String✓
Test cbMealOptions.ItemIndex for selected meal✓
Use the case/if statements✓ to test for three options ✓
and assign correct price to variable (rMealPrice)✓
Obtain number of meals from spin edit✓
14
Calculate cost of meals (NumOfMeals * rMealPrice)✓
Test if chbVegetarian is checked ✓
Calculate ✓and decrease cost amount by 10% ✓
(rMealsCost := rMealsCost * 0.9)
Also accept any other correct formula
Display final cost in edit box as currency with 2 decimals✓
Change colour of font of cost edit box to clBlue✓
1.3 Button - [1.3 Calculate Tables and Power]
Variable declaration
All integer ✓
Obtain number of players from edit box and convert to int✓
Calculate number of tables required
8
(iNumTables := iNumPlayers DIV TableSize) ✓
if number of players not divisible by TableSize✓
Increase number of tables by 1✓
Calculate power required correctly ✓
Convert power required to String and display ✓
Convert number of tables to String and display ✓
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 4 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
1.4 Button - [1.4 Calculate Days]
Variable declaration
All integer ✓
Clear memo component✓
Obtain number of units from edit box, convert to integer✓
Generate random value✓ in correct range ✓as daily usage 12
Convert daily usage to String and display in edit box✓
Initialise loop counter to 0✓
While units >= daily usage do✓
Increment loop counter by 1✓
Subtract daily usage from units✓
Display loop counter ✓and units left, converted to strings✓
TOTAL SECTION A: 40
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 5 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
ANNEXURE B
QUESTION 2: MARKING GRID – SQL AND DATABASE
CENTRE NUMBER: EXAMINATION NUMBER:
MAX. LEARNER'S
QUESTION DESCRIPTION MARKS MARKS
2.1 SQL statements
2.1.1 [Show All Players]
SELECT * ✓FROM tblPlayers✓ORDER BY Name✓ 3
2.1.2 [Players Born in September]
SELECT Name, DateOfBirth FROM tblPlayers✓WHERE
3
Month(DateOfBirth) ✓= 9✓
2.1.3 [Average Game Times]
SELECT GameDate, ✓Round(Avg(Duration),1) ✓AS
AverageDuration✓FROM tblGames✓ 5
GROUP BY GameDate✓
2.1.4 [Highest Scores]
SELECT Name, Max(Score) ✓AS HighestScore✓FROM
tblPlayers P, tblGames G ✓WHERE P.PlayerID = 5
G.PlayerID✓GROUP BY Name✓
2.1.5 [Add Game]
INSERT INTO tblGamesVALUES ✓
(76,#2017/12/24#,'HM008',250,6655) 4
All data items listed and correct values ✓
In correct order ✓correct format ✓
Subtotal: 20
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 6 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
2.2 DATABASE MANIPULATION
2.2.1 Button – [Domain Users Count]
Obtain domain entered from InputBox✓
Display column headings✓
Initialise counter to 0
Set tblPlayers to start reading first record✓
Loop while NOT tblPlayers.Eof✓
Test if pos(sDomain,tblPlayers['Email']) > 0 ✓
9
Display name and email address from tblPlayers✓
Increment counter by 1✓
Go to next record in tblPlayers✓
End loop
Display message with domain and counter ✓
converted to String
2.2.2 Button – [Change Score]
Set tblGames to edit mode ✓
Add 250 points✓ to the content of selected Score field in 4
tblGames✓
Post the change that was made ✓
2.2.3 Button – [Add Game]
tblGames.Insert✓
tblGames['GameIndx'] :=tblGames.RecordCount + 1✓
tblGames['Gamedate'] := Date ✓
tblGames['PlayerID'] := tblPlayers['PlayerID'] ✓
7
tblGames['Duration'] := inputBox('Game Duration',
'Enter duration of game','') ✓
tblGames['Score'] := inputBox('Game Score',
'Enter score','') ✓
tblGames.Post✓
Subtotal: 20
TOTAL SECTION B: 40
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 7 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
ANNEXURE C
QUESTION 3: MARKING GRID – OBJECT-ORIENTED PROGRAMMING
CENTRE NUMBER: EXAMINATION NUMBER:
MAX. LEARNER'S
QUESTION DESCRIPTION MARKS MARKS
3.1.1 Method heading ✓
result := fEmail ✓ 2
3.1.2 Method heading ✓
fApproved :=✓Boolean parameter value ✓
3
3.1.3 Initialise Boolean variable to true✓
If the first character ✓ not uppercase letter ✓
5
Boolean variable = false ✓
result:= bPass ✓
3.1.4 fName:= name
if testEmail ✓ (email) ✓
fEmail:= email✓
else✓ 5
fEmail:= 'ERROR' ✓
fDateOfBirth:= dateOfBirth
fApproved:= false
3.1.5 Method heading:
Function name with correct data type✓ and parameter ✓
iRealAge:=YearsBetween(date,StrToDate(fDateOfBirth))✓✓
if iRealAge>= age ✓ 7
result := 'APPROVED'✓
else
result := 'REJECTED'✓
Subtotal: 22
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 8 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
3.2.1 Button [Submit Details]
objPlayer ✓:= TPlayer.create✓
(edtName.text,edtEmail.text,edtDateOfBirth.text) ✓✓
7
// Order and number of parameters
redDisplay.Clear✓ edtAgeResult.clear✓
redDisplay.Lines.Add(objPlayer.toString) ✓
3.2.2 Button [Test Age]
edtAgeResult.Text ✓:=objPlayer.testAge✓ 3
(StrToInt(edtAge.Text)✓)
3.2.3 Button – [Approve]
if (edtAgeResult.Text = 'APPROVED') ✓AND ✓
(objPlayer.getEmail<> 'ERROR') ✓
objPlayer.setApproved (true)✓
else
showMessage('The player''s age or e-mail has been 8
rejected.') ✓
objPlayer.setApproved(false) ✓
redDisplay.Clear✓
redDisplay.Lines.Add(objPlayer.toString)✓
Subtotal: 18
TOTAL SECTION C: 40
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 9 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
ANNEXURE D
QUESTION 4: MARKING GRID – PROBLEM-SOLVING PROGRAMMING
CENTRE NUMBER: EXAMINATION NUMBER:
MAX. LEARNER'S
SECTION DESCRIPTION
MARKS MARKS
4.1 Button [Remove Duplicates]
Initialise newCount to 0✓
Loop from 1 to iCount(outer loop) ✓ (i)
Set flag to false✓
Loop from 1 to newCount (inner loop) ✓ (j)
if arrNames[i] = arrTempNames[j] then✓
Set flag to true ✓
if arrScores[i] >arrTempScores[j] then✓
arrTempScores[j] := arrScores[i] ✓
end //inner loop
if NOT found then✓
Increment newCount by 1 ✓ 16
arrTempNames[newCount] := arrNames[i] ✓
arrTempScores[newCount] := arrScores[i] ✓
end //if
end//outer loop
iCount := newCount
Loop from 1 to iCount✓
Begin loop
arrNames[i] := arrTempNames[i]✓
arrScores[i] := arrTempScores[i]✓
end loop
Call display procedure✓
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 10 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
4.2 Button [Display Master Players]
Initialise total as 0 ✓
Loop from 1 to iCount
iTot := iTot + arrScores[i] ✓
Calculate average (iAvg := Round(iTot / iCount)) ✓
Initialise iMastCount as 0✓
Loop from 1 to iCount✓
if arrScores[i] >iAvg then✓
Increment iMastCount by 1✓
arrMasters[iMastCount] :=
arrNames[i] + '#' + IntToStr(arrScores[i]) ✓
end if
end loop
14
Loop from 1 to iMastCount - 1 ✓
Loop from i + 1 to iMastCount✓
if arrMasters[i] >arrMasters[j] then✓
begin
sTemp := arrMasters[i]
arrMasters[i] := arrMasters[j] ✓ (swap)
arrMasters[j] := sTemp
end if
redDisplay.Lines.Add('MASTER PLAYERS');
redDisplay.Lines.Add('Scores above an average of ' +
IntToStr(iAvg)) ✓
Loop from 1 to iMastCount
redDisplay.Lines.Add(arrMasters[i])✓
TOTAL SECTION D: 30
GRAND TOTAL: 150
SUMMARY OF LEARNER'S MARKS:
SECTION A SECTION B SECTION C SECTION D
QUESTION 1 QUESTION 2 QUESTION 3 QUESTION 4 GRAND TOTAL
MAX.
MARKS
40 40 40 30 150
LEARNER'S
MARKS
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 11 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
ANNEXURE E: SOLUTION FOR QUESTION 1
unit Question1_U;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls,
Forms, Dialogs, StdCtrls, ExtCtrls, ComCtrls, Spin;
type
TfrmQuestion1 = class(TForm)
Label7: TLabel;
GroupBox1: TGroupBox;
Label1: TLabel;
edtName: TEdit;
Label2: TLabel;
edtEmail: TEdit;
btnRegister: TButton;
GroupBox2: TGroupBox;
Label3: TLabel;
Label4: TLabel;
Label8: TLabel;
edtCost: TEdit;
sedNumMeals: TSpinEdit;
chbVegetarian: TCheckBox;
btnCalcCost: TButton;
GroupBox3: TGroupBox;
rbgTableSize: TRadioGroup;
btnCalcTables: TButton;
Label5: TLabel;
edtNumPlayers: TEdit;
Label6: TLabel;
Label9: TLabel;
edtNumTables: TEdit;
edtPower: TEdit;
GroupBox4: TGroupBox;
btnCalculate: TButton;
cbMealOptions: TComboBox;
Label12: TLabel;
edtUnits: TEdit;
Label13: TLabel;
edtDailyusage: TEdit;
memDisplay: TMemo;
procedure btnCalcTablesClick(Sender: TObject);
procedure btnRegisterClick(Sender: TObject);
procedure btnCalculateDaysClick(Sender: TObject);
procedure btnCalcCostClick(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
frmQuestion1: TfrmQuestion1;
implementation
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 12 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
{$R *.dfm}
// =====================================================================
// Question 1.1
// =====================================================================
procedure TfrmQuestion1.btnRegisterClick(Sender: TObject);
begin
if (edtName.text > '') AND (edtEmail.Text > '') then
showMessage(edtName.text + ' with e-mail address ' + edtEmail.text +
' has been registered.')
else
showMessage('All the required data was not provided.');
end;
// =====================================================================
// Question 1.2
// =====================================================================
procedure TfrmQuestion1.btnCalcCostClick(Sender: TObject);
var
iNumOfMeals : Integer;
rMealPrice, rMealsCost : Real;
begin
case cbMealOptions.ItemIndex of
0: rMealPrice := 25;
1: rMealPrice := 32.80;
2: rMealPrice := 45.75;
end;
iNumOfMeals := sedNumMeals.Value;
rMealsCost := iNumOfMeals * rMealPrice;
if chbVegetarian.checked then
rMealsCost := rMealsCost * 1.1;
edtCost.Font.Color := clBlue;
edtCost.text := FloatToStrF(rMealsCost,ffCurrency,10,2);
end;
// =====================================================================
// Question 1.3
// =====================================================================
procedure TfrmQuestion1.btnCalcTablesPowerClick(Sender: TObject);
CONST
Tablesize = 6;
var
iNumPlayers, iNumTables, iPower: Integer;
begin
iNumPlayers := StrToInt(edtNumPlayers.text);
iNumTables := iNumPlayers DIV Tablesize;
if iNumPlayers MOD TableSize > 0 then
Inc(iNumTables);
iPower := Round(iNumPlayers * 0.66);
edtPower.text := IntToStr(iPower);
edtNumTables.text := IntToStr(iNumTables);
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 13 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
// =====================================================================
// Question 1.4
// =====================================================================
procedure TfrmQuestion1.btnCalculateDaysClick(Sender: TObject);
var
iUnits, iUsage, iCount: Integer;
begin
memDisplay.clear;
iUnits := StrToInt(edtUnits.text);
iUsage := Random(100) + 50;
edtDailyUsage.text := IntToStr(iusage);
iCount := 0;
while iUnits >= iUsage do
begin
Inc(iCount);
iUnits := iUnits - iUsage;
memDisplay.lines.add('Units after day ' + IntToStr(iCount) + ' : '
+ IntToStr(iUnits));
end;
end;
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 14 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
ANNEXURE F: SOLUTION FOR QUESTION 2
unit question2_U;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls,
Forms, Dialogs, DB, ADODB, StdCtrls, Grids, DBGrids, Mask, DBCtrls,
ComCtrls, DateUtils, dbConnection_U;
type
TfrmQuestion2 = class(TForm)
pgcQst2: TPageControl;
tsQst21: TTabSheet;
tsQst22: TTabSheet;
Label1: TLabel;
Label2: TLabel;
Label4: TLabel;
Label6: TLabel;
dbgPlayers: TDBGrid;
dbgGames: TDBGrid;
redDisplay: TRichEdit;
btnDomainUsersCount: TButton;
btnChangeScore: TButton;
btnAddRiver: TButton;
btnRestore: TButton;
Label3: TLabel;
Label5: TLabel;
dbgSQL: TDBGrid;
procedure connect;
procedure FormShow(Sender: TObject);
procedure btnDomainUsersCountClick(Sender: TObject);
procedure btnChangeScoreClick(Sender: TObject);
procedure btnAddRiverClick(Sender: TObject);
procedure btnRestoreClick(Sender: TObject);
procedure btnSQLqst211Click(Sender: TObject);
procedure btnSQLqst212Click(Sender: TObject);
procedure btnSQLqst213Click(Sender: TObject);
procedure btnSQLqst214Click(Sender: TObject);
procedure btnSQLbtn215Click(Sender: TObject);
end;
var
frmQuestion2: TfrmQuestion2;
// Databse will automatically connect
// These are the two tables that you work with
tblPlayers: TADOtable;
tblGames: TADOtable;
// DB SQL component
qryLanFans: TADOQuery;
sSQL : String;
implementation
{$R *.dfm}
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 15 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
//======================================================================
// Question 2.1.1
//======================================================================
procedure TfrmQuestion2.btnSQLqst211Click(Sender: TObject);
begin
sSQL := 'SELECT * FROM tblPlayers Order by Name';
qryLanFans.SQL.Clear;
qryLanFans.SQL.ADD(sSQL);
qryLanFans.Open;
end;
//======================================================================
// Question 2.1.2
//======================================================================
procedure TfrmQuestion2.btnSQLqst212Click(Sender: TObject);
begin
sSQL := 'SELECT Name, DateOfBirth FROM tblPlayers '+
'WHERE Month(DateOfBirth) = 9';
qryLanFans.SQL.Clear;
qryLanFans.SQL.ADD(sSQL);
qryLanFans.Open;
end;
//======================================================================
// Question 2.1.3
//======================================================================
procedure TfrmQuestion2.btnSQLqst213Click(Sender: TObject);
begin
sSQL :=('SELECT GameDate, Round(Avg(Duration),1) AS AverageDuration' +
' FROM tblGames GROUP BY GameDate');
qryLanFans.SQL.Clear;
qryLanFans.SQL.ADD(sSQL);
qryLanFans.Open;
end;
//======================================================================
// Question 2.1.4
//======================================================================
procedure TfrmQuestion2.btnSQLqst214Click(Sender: TObject);
begin
sSQL := 'SELECT Name, Max(Score) AS HighestScore ' +
'FROM tblPlayers P, tblGames G ' +
'WHERE P.PlayerID = G.PlayerID GROUP BY Name';
qryLanFans.SQL.Clear;
qryLanFans.SQL.ADD(sSQL);
qryLanFans.Open;
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 16 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
//======================================================================
// Question 2.1.5
//======================================================================
procedure TfrmQuestion2.btnSQLbqst215Click(Sender: TObject);
begin
sSQL := 'INSERT INTO tblGames ' +
'VALUES (76,#2017/12/24#,''HM008'',250,6655)';
qryLanFans.SQL.Clear;
qryLanFans.SQL.ADD(sSQL);
qryLanFans.ExecSQL;
showMessage(IntToStr(qryLanFans.RowsAffected) + ' record/s added.');
end;
// =====================================================================
// Question 2.2.1
// =====================================================================
procedure TfrmQuestion2.btnDomainUsersCountClick(Sender: TObject);
var
sDomain: String;
iCount: Integer;
begin
// Provided code
iCount := 0;
redDisplay.Clear;
redDisplay.Paragraph.TabCount := 1;
redDisplay.Paragraph.Tab[0] := 90;
sDomain := Inputbox('Domain Email','Enter the e-mail domain to
search for','gmail.com');
redDisplay.lines.add('PLAYER' + #9 + 'E-MAIL ADDRESS');
tblPlayers.First;
while NOT tblPlayers.Eof do
begin
ifPos(sDomain,tblPlayers['Email']) > 0 then
begin
redDisplay.lines.add(tblPlayers['Name'] + #9 +
tblPlayers['Email']);
Inc(iCount);
end;
tblPlayers.Next;
end;
redDisplay.lines.add(#13 + 'TOTAL for ' + sDomain + ': '
+ IntToStr(iCount));
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 17 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
// =====================================================================
// Question 2.2.2
// =====================================================================
procedure TfrmQuestion2.btnChangeScoreClick(Sender: TObject);
begin
tblGames.Edit;
tblGames['Score'] := tblGames['Score'] + 250;
tblGames.Post;
end;
// =====================================================================
// Question 2.2.3
// =====================================================================
procedure TfrmQuestion2.btnAddRiverClick(Sender: TObject);
begin
tblGames.Insert;
tblGames['GameIndx'] := tblGames.RecordCount + 1;
tblGames['Gamedate'] := Date;
tblGames['PlayerID'] := tblPlayers['PlayerId'];
tblGames['Duration'] := InputBox('Game Duration',
'Enter duration of game','');
tblGames['Score'] := InputBox('Game Score','Enter score','');
tblGames.Post;
end;
{$region Connect}
// Supplied Connection Code - DO NOT CHANGE.
// Database will automatically connect when run
var
dbLanFans: TConnection;
dsrPlayers: TDataSource;
dsrGames: TDataSource;
frmSQL: TfrmQst2SQL;
procedure TfrmQuestion2.FormShow(Sender: TObject);
begin
dbLanFans := TConnection.create;
dbLanFans.dbConnect;
connect;
pgcQst2.ActivePageIndex := 0;
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 18 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
procedure TfrmQuestion2.connect;
begin
tblPlayers := TADOtable.Create(frmQuestion2);
tblPlayers.Connection := dbLanFans.dbConnection;
tblPlayers.TableName := 'tblPlayers';
tblPlayers.Open;
tblGames := TADOtable.Create(frmQuestion2);
tblGames.Connection := dbLanFans.dbConnection;
tblGames.TableName := 'tblGames';
tblGames.Open;
dsrPlayers := TdataSource.Create(frmQuestion2);
dsrPlayers.DataSet := tblPlayers;
dbgPlayers.DataSource := dsrPlayers;
dsrGames := TdataSource.Create(frmQuestion2);
dsrGames.DataSet := tblGames;
dbgGames.DataSource := dsrGames;
end;
// Supplied Connection Code - DO NOT CHANGE.
procedure TfrmQuestion2.btnRestoreClick(Sender: TObject);
var
bFail: boolean;
begin
dbLanFans.dbConnection.close;
tblPlayers.Destroy;
tblGames.Destroy;
DeleteFile('LanFans.mdb');
CopyFile('LanFansBackup.mdb','LanFans.mdb',bFail);
dbLanFans.dbConnect;
connect;
end;
procedure TfrmQuestion2.Button1Click(Sender: TObject);
begin
frmSQL := TfrmQst2SQL.Create(frmQuestion2);
frmSQL.ShowModal;
end;
{$endregion}
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 19 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
ANNEXURE G: SOLUTION FOR QUESTION 3
Object class
unitplayer_U;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls,
Forms,Dialogs, DateUtils;
type
TPlayer = class(TObject)
private
fEmail: String;
fName: String;
fDateOfBirth: String;
fApproved: Boolean;
functiontestEmail(email: String): Boolean;
public
constructor create(name, email, dateOfBirth: String);
functiontoString: String;
functiontestAge(age : Integer): String;
proceduresetApproved(approve :Bboolean);
functiongetEmail: String;
end;
implementation
{ TPlayer }
// =====================================================================
// Question 3.1.1
// =====================================================================
function TPlayer.getEmail: String;
begin
result := fEmail;
end;
// =====================================================================
// Question 3.1.2
// =====================================================================
procedure TPlayer.setApproved(approve: Boolean);
begin
fApproved := approve;
end;
// =====================================================================
// Question 3.1.3
// =====================================================================
function TPlayer.testEmail(email: String): Boolean;
var
iPosAt, iPosDot: Integer;
bPass: Boolean;
begin
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 20 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
bPass := true;
if NOT (Uppercase(email)[1] IN ['A'..'Z']) then
bPass := False;
result := bPass;
end;
// =====================================================================
// Question 3.1.4
// =====================================================================
constructorTPlayer.create(name, email, dateOfBirth: String);
begin
fName := name;
iftestEmail(email) then
fEmail := email
else
fEmail := 'ERROR';
fDateOfBirth := dateOfBirth;
fApproved := false;
end;
// =====================================================================
// Question 3.1.5
// =====================================================================
functionTPlayer.testAge(age: Integer): String;
var
iRealAge : Integer;
begin
iRealAge := YearsBetween(date,StrToDate(fDateOfBirth));
if iRealAge>= age then
result := 'APPROVED'
else
result := 'REJECTED';
end;
// Provided Code - do not change
functionTPlayer.toString: String;
var
sOut, sApp: String;
begin
sOut := 'Name: ' + fName + #13;
sOut := sOut + 'Email: ' + fEmail + #13;
sOut := sOut + 'Date of Birth: ' + fDateOfBirth + #13;
iffApproved then
sApp := 'YES'
elsesApp := 'NO';
sOut := sOut + 'Approved: ' + sApp + #13;
result := sOut;
end;
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 21 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
Main Form Unit
unit question3_U;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls,
Forms,Dialogs, StdCtrls, player_U, ComCtrls;
type
TfrmQuestion3 = class(TForm)
Label1: TLabel;
Label2: TLabel;
Label3: TLabel;
Label4: TLabel;
edtName: TEdit;
edtEmail: TEdit;
edtDateOfBirth: TEdit;
btnSubmitDetails: TButton;
Label6: TLabel;
Label7: TLabel;
btnApprove: TButton;
edtAge: TEdit;
btnAgeTest: TButton;
edtAgeResult: TEdit;
redDisplay: TRichEdit;
btnRegister: TButton;
Label5: TLabel;
edtToday: TEdit;
Label8: TLabel;
procedurebtnSubmitDetailsClick(Sender: TObject);
procedurebtnAgeTestClick(Sender: TObject);
procedurebtnApproveClick(Sender: TObject);
procedureFormShow(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
frmQuestion3: TfrmQuestion3;
objPlayer :TPlayer;
implementation
{$R *.dfm}
// =====================================================================
// Question 3.2.1
// =====================================================================
procedure TfrmQuestion3.btnSubmitDetailsClick(Sender: TObject);
begin
objPlayer :=
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 22 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
TPlayer.create(edtName.text,edtEmail.text,edtDateOfBirth.text);
redDisplay.Clear;
redDisplay.Lines.Add(objPlayer.toString);
edtAgeResult.clear;
end;
// =====================================================================
// Question 3.2.2
// =====================================================================
procedure TfrmQuestion3.btnAgeTestClick(Sender: TObject);
begin
edtAgeResult.Text := objPlayer.testAge(StrToInt(edtAge.Text));
end;
// =====================================================================
// Question 3.2.3
// =====================================================================
procedure TfrmQuestion3.btnApproveClick(Sender: TObject);
begin
if (edtAgeResult.Text = 'APPROVED') AND
(objPlayer.getEmail <> 'ERROR') then
objPlayer.setApproved(true)
else
begin
showMessage('The player''s age or e-mail has been rejected.');
objPlayer.setApproved(false);
end;
redDisplay.Clear;
redDisplay.Lines.Add(objPlayer.toString);
end;
// Provided code
procedure TfrmQuestion3.FormShow(Sender: TObject);
begin
edtToday.text := DateToStr(Date);
end;
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 23 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
ANNEXURE H: SOLUTION FOR QUESTION 4
unit Question4_U;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls,
Forms, Dialogs, StdCtrls, ComCtrls;
type
TfrmQuestion4 = class(TForm)
Label1: TLabel;
redDisplay: TRichEdit;
Label2: TLabel;
btnload: TButton;
btnRemoveDuplicates: TButton;
btnMasterPlayers: TButton;
procedurebtnloadClick(Sender: TObject);
procedure display;
procedurebtnRemoveDuplicatesClick(Sender: TObject);
procedurebtnMasterPlayersClick(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
frmQuestion4: TfrmQuestion4;
arrNames: array [1..50] of String;
arrScores: array [1..50] of Integer;
iCount: Integer = 0;
arrMasters: array[1..30] of String;
iMastCount: Integer;
implementation
{$R *.dfm}
// =====================================================================
// Question 4.1
// =====================================================================
procedure TfrmQuestion4.btnRemoveDuplicatesClick(Sender: TObject);
var
arrTempNames: array [1..50] of String;
arrTempScores: array [1..50] of Integer;
i, j, newCount : Integer;
found : Boolean;
begin
newCount := 0;
for i := 1 to iCount do
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 24 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
begin
found := false;
for j := 1 to newCount do
begin
if arrNames[i] = arrTempNames[j] then
begin
found := true;
if arrScores[i] > arrTempScores[j] then
arrTempScores[j] := arrScores[i];
end;
end;
if NOT found then
begin
Inc(newCount);
arrTempNames[newCount] := arrNames[i];
arrTempScores[newCount] := arrScores[i];
end;
end;
iCount := newCount;
for i := 1 to iCount do
begin
arrNames[i] := arrTempNames[i];
arrScores[i] := arrTempScores[i];
end;
display;
end;
// =====================================================================
// Question 4.2
// =====================================================================
procedure TfrmQuestion4.btnMasterPlayersClick(Sender: TObject);
var
i, j, iTot, iAvg : Integer;
sTemp : String;
begin
iTot := 0;
for i := 1 to iCount do
iTot := iTot + arrScores[i];
iAvg := Round(iTot / iCount);
iMastCount := 0;
for i := 1 to iCount do
ifarrScores[i] >iAvg then
begin
Inc(iMastCount);
arrMasters[iMastCount] := arrNames[i] + '#' +
IntToStr(arrScores[i]);
end;
for i := 1 to iMastCount - 1 do
for j := i + 1 to iMastCount do
if arrMasters[i] > arrMasters[j] then
begin
sTemp := arrMasters[i];
arrMasters[i] := arrMasters[j];
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 25 DBE/2018
CAPS – Grade 12 Exemplar – Marking Guidelines
arrMasters[j] := sTemp;
end;
redDisplay.Clear;
redDisplay.Lines.Add('MASTER PLAYERS');
redDisplay.Lines.Add('Scores above an average of ' + IntToStr(iAvg));
for i := 1 to iMastCount do
redDisplay.Lines.Add(arrMasters[i]);
end;
// Provided Code
procedure TfrmQuestion4.btnloadClick(Sender: TObject);
var
tScoresFile: TextFile;
sLine : String;
p: Integer;
begin
iCount := 0;
AssignFile(tScoresFile, 'Scores.txt');
Reset(tScoresFile);
while NOT EOF(tScoresFile) do
begin
Inc(iCount);
Readln(tScoresFile, sLine);
p := Pos(',',sLine);
arrNames[iCount] := Copy(sLine,1,p-1);
arrScores[iCount] := StrToInt(Copy(sLine,p+1));
end;
CloseFile(tScoresFile);
display;
end;
procedure TfrmQuestion4.display;
var
i : Integer;
begin
redDisplay.clear;
redDisplay.Paragraph.TabCount := 1;
redDisplay.Paragraph.Tab[0] := 120;
redDisplay.Lines.Add('NAME' + #9 + 'SCORE');
for i := 1 to iCount do
begin
redDisplay.Lines.Add(arrNames[i] + #9 + IntToStr(arrScores[i]));
end;
end;
end.
Copyright reserved
Study this subject
Recommended for this subject

Memorandum
Information Technology Grade 12 P1 2018 Memo (Afr)

Memorandum
Information Technology Grade 12 P1 NSC June 2018 Memo (Eng)

Memorandum
Information Technology Grade 12 P1 2018 Memo (Afr)

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

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

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2018 QP
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