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




_hlayiso.com_--50e776f8-b245-4554-9243-5cf350cf10d2/v1-50c5c39841428639bad4/card.webp)
View all





Information Technology Grade 12 P1 NSC November 2018 Memo
Grade 12 Information Technology Paper 1 memorandum from the NSC November Exam 2018 (English), 23 pages. Read online or download the free PDF.
Information Technology · Grade 12 · NSC November Exam · 2018. Memorandum, 23 pages. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2018
- Exam period
- NSC November Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 23
- File size
- 522.3 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 23
This exam
NSC November Exam 2018
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Information Technology/P1 2 DBE/November 2018
NSC – Marking Guidelines
GENERAL INFORMATION:
• These marking guidelines must 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 question paper were not
followed or the requirements of the question were not met.
• Annexures A, B, C and D (pages 3–9) include the marking grid for each
question and a table for a summary of the learner's marks.
• Annexures E, F, G and H (pages 10–23) contain examples of a programming
solution for QUESTION 1 to QUESTION 4 in programming code.
• Copies of Annexures A, B, C, D and the summary of learner's marks (pages
3–9) 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/November 2018
NSC – Marking Guidelines
ANNEXURE A
SECTION A
QUESTION 1: MARKING GRID – GENERAL PROGRAMMING SKILLS
CENTRE NUMBER: EXAMINATION NUMBER:
MAX. LEARNER'S
QUESTION DESCRIPTION
MARKS MARKS
A learner must be penalised only once if the same error is repeated.
1.1 Panel [1.1 – Display heading]
Set the panel colour to lime
Set the font colour to red 4
Set the font size to 20 pt
Set the panel caption to 'Information Technology Paper 1'
1.2 Button [1.2 – Volume]
Declaration of radius and height variables
Extract the height and radius from the edit
Convert both to real values
9
Calculate volume pi * sqr(rRadius) * (rHeight -1)
Display message and value formatted to one decimal
NOTE: sqr(rRadius); rRadius*rRadius; Power(rRadius,2)
1.3 Button [1.3 – Display factors]
Declaration of suitable variables for this solution
Clear the rich edit output area
Initialise factor counter
Randomly generate number between 5 and 50
Loop from 1 to random number (Accept variations)
13
Test if number modulus loop variable is 0
Display the value of the loop variable
Increment factor counter
Test if number of factors = 2
Display the random number and a message to indicate
value is prime number
1.4 Button [1.4 – Enter line and display commands]
Display line of instructions and a blank line
Initialise steps counter to 0
While/For loop from 1 to length of line
Extract character from line at loop-index position
Use CASE or multiple IF's to test 3 characters
IF 'S'
Test if number of steps = 10
14
set message to "Number of forward steps more than 10"
break (alternative with a while loop: AND Number of steps <=
10)
else
Increment number of steps forward by 1
Set/display message "Step forward"
IF 'R' set/display message to "Turn right"
IF 'L' set/display message to "Turn left"
TOTAL SECTION A 40
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 4 DBE/November 2018
NSC – Marking Guidelines
ANNEXURE B
SECTION B
QUESTION 2: MARKING GRID - DATABASE PROGRAMMING
CENTRE NUMBER: EXAMINATION NUMBER:
MAX. LEARNER'S
QUESTION DESCRIPTION
MARKS MARKS
2.1.1 Button [2.1.1 – Alphabetical list]
SQL:
SELECT * FROM tblEmployees ORDER BY Surname ASC
Concepts: 3
SELECT all fields
FROM Correct table
ORDER BY correct field (ASC not required)
2.1.2 Button [2.1.2 – Number of children of permanent employees]
SQL:
SELECT Surname, FirstName, Children
FROM tblEmployees
WHERE Children > 3 AND Permanent = TRUE
5
Concepts:
SELECT all the correct fields
FROM correct table
WHERE
Conditions: Children > 3 AND Permanent = TRUE
2.1.3 Button [2.1.3 – Employees paid on selected date]
SELECT PaymentNumber,IDNumber
FROM tblEmployees, tblPayments
WHERE tblEmployees.EmployeeNumber =
tblPayments.EmployeeNumber AND PaymentDate =
#2017/01/17#
Concepts:
SELECT correct fields 6
FROM tblEmployees , tblPayments
WHERE clause to link tables
AND correct condition
NOTE:
PaymentDate between # #
PaymentDate Like “2017/01/17”
Also accept: INNERJOIN, LEFTJOIN, aliases
2.1.4 Button [2.1.4 – Delete payment]
DELETE FROM tblPayments
WHERE PaymentNumber = 110
Concepts:
DELETE 3
FROM correct table
WHERE correct condition
NOTE:
Accept: *, all fields names, one field name
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 5 DBE/November 2018
NSC – Marking Guidelines
QUESTION 2: MARKING GRID – CONTINUE
2.1.5 Button [2.1.5 – Total net salaries per month]
SQL:
SELECT Month(PaymentDate) AS MonthNum,
FORMAT(SUM(GrossSalary-Deductions), "Currency")
AS TotalAmountPaid
FROM tblPayments
GROUP BY Month(PaymentDate)
8
Concepts:
SELECT correct field, MONTH-function
AS specified fieldname (for any one of the 2 calculated fields)
SUM calculation currency format
FROM correct table
GROUP BY Month(PaymentDate)
Subtotal: SQL [25]
2.2.1 Button [2.2.1 – Temporary employees]
Move to first record of tblEmployees table
Loop while not end of table
IF Permanent = false
Display the surname, first name, children with tabs in 6
richedit
Move to next record
NOTE:
Also accept: IF Permanent = ‘false’
2.2.2 Button [2.2.2 – Add an employee]
Place table in INSERT mode
Assign correct String values to the various data fields
Assign correct boolean value to the correct data field
Assign correct integer value to the correct data field 5
POST the updated field values
NOTE:
Also accept: APPEND in place of INSERT
Also accept: .UPDATERECORD or any other navigation
2.2.3 Button [2.2.3 – Update deductions]
Place table in EDIT mode
Update the deductions field with 1% of gross salary
POST the updated field value 4
NOTE:
Also accept: .UPDATERECORD or any other navigation
Subtotal: Code constructs [15]
TOTAL SECTION B 40
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 6 DBE/November 2018
NSC – Marking Guidelines
ANNEXURE C
SECTION C
QUESTION 3: MARKING GRID – OBJECT-ORIENTATED PROGRAMMING
CENTRE NUMBER: EXAMINATION NUMBER:
MAX. LEARNER'
QUESTION DESCRIPTION
MARKS S MARKS
3.1.1 Constructor:
Declaration/Heading with three parameters
5
two String parameters, one integer
Assign parameter values to attributes
3.1.2 getNumEmployees METHOD:
Function heading with correct data type 2
Result statement (result := fNumEmployees)
3.1.3 increaseNumEmployees METHOD:
3
Procedure name and parameter
fNumEmployees:= fNumEmployees+ parameter value
3.1.4 compileCode METHOD:
Function heading with String data type
Correct data type for parameter
Code first letter of name of restaurant + last two letters of
owner name + year opened
Result statement
7
NOTE:
Also accept:
Procedure heading with correct parameters
Return variable with correct data type
Code first letter of name of restaurant + last two letters of
owner name + year opened
Subtotal: Object class [17]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 7 DBE/November 2018
NSC – Marking Guidelines
QUESTION 3: MARKING GRID – CONTINUE
MAX. LEARNER'
QUESTION DESCRIPTION
MARKS S MARKS
3.2.1 Button [3.2.1 – Instantiate and display object]
Instantiate object
Object name = classname.create with arguments name of
restaurant, year opened,
and number of employees
8
Display the object
RichEdit component for display Object name toString
NOTE:
Check order and type of arguments
Check constructor name
3.2.2 Button [3.2.2 – Identification code]
Call compile code method with correct object name
3
Owner name as parameter
Display the code in the edit box
3.2.3 Button [3.2.3 – Add employees]
Extract the number of employees to add
Test if the current number of employees (value from
getMethod) + employees to add <= max number of
employees
Call the increaseNumEmployees method with 10
correct parameter value
Display the updated value for the number of
employees in the edit box
Else
Display a suitable message in the edit box
Subtotal: Form class [21]
TOTAL SECTION C 38
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 8 DBE/November 2018
NSC – Marking Guidelines
ANNEXURE D
SECTION D
QUESTION 4: MARKING GRID – PROBLEM-SOLVING
CENTRE NUMBER: EXAMINATION NUMBER:
MAX LEARNER'S
Question DESCRIPTION
MARKS MARKS
4.1 Button [4.1 – Populate Customer array]
Read the month from combo box
Initialise counter for days in month
Assign and reset file
Loop through file
Read line
Test if the line has the selected month
Increment counter
Find the position of # Copy number of customers
14
(retrieving number of customers (2 marks))
Convert to integer and store number of customes in arrCustomers
using the days in month variable(counter) as index
Display message to indicate array were successfully populated
NOTE:
The counter (initialising,incrementing) can be replaced by using character
manipulation to extract the index from the line of text
4.2 Button [4.2 – Display]
Concepts:
Extract day of week/column (1)
• Read index from combo box (add 1)
Filling up spaces/incomplete first week (5)
• Initialize output string
• Loop from 1 to dayOfWeek index -1
• Add to output string tab (#9)
Looping through array (2)
• Loop from 1 to
number of days of selected month
Counting the days (1)
• Increase the number of days in the week using a
nested loop or a separate counter 18
Constructing line to be displayed (4)
• Add to output string
• The day of the month and
• The number of customers in brackets and
• A tab (#9)
Test if line is full and display/end of week (4)
• Test if last day of week reached /or after nested
loop
o Display the compiled output line
o Clear the output line
o Reset day of week
Display remaining week(1)
• Display the compiled output line
TOTAL SECTION D 32
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 9 DBE/November 2018
NSC – Marking Guidelines
SUMMARY OF LEARNER'S MARKS:
CENTRE NUMBER: EXAMINATION NUMBER:
SECTION A SECTION B SECTION C SECTION D
QUESTION 1 QUESTION 2 QUESTION 3 QUESTION 4 GRAND TOTAL
MAX. MARKS 40 40 38 32 150
LEARNER'S
MARKS
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 10 DBE/November 2018
NSC – Marking Guidelines
ANNEXURE E: SOLUTION FOR QUESTION 1
unit Question1_U;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, ComCtrls, ExtCtrls, StdCtrls, Math, Buttons;
type
TfrmQ1 = class(TForm)
pgcQ1: TPageControl;
tbsQuestion1_1: TTabSheet;
tbsQuestion1_2: TTabSheet;
tbsQuestion1_3: TTabSheet;
pnlQ1_1: TPanel;
btnQ1_3: TButton;
tbsQuestion1_4: TTabSheet;
btnQ1_4: TButton;
redQ1_3: TRichEdit;
pnlBtns: TPanel;
bmbClose: TBitBtn;
Label1: TLabel;
redQ1_4: TRichEdit;
Label3: TLabel;
Label4: TLabel;
edtHeight: TEdit;
edtRadius: TEdit;
btnQ1_2: TButton;
Label5: TLabel;
Label6: TLabel;
procedure pnlQ1_1Click(Sender: TObject);
procedure btnQ1_2Click(Sender: TObject);
procedure btnQ1_3Click(Sender: TObject);
procedure btnQ1_4Click(Sender: TObject);
procedure FormCreate(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
frmQ1: TfrmQ1;
implementation
{$R *.dfm}
// ======================================================================
// Question 1.1 (4 marks)
// ======================================================================
procedure TfrmQ1.pnlQ1_1Click(Sender: TObject);
begin
pnlQ1_1.Color := clLime;
pnlQ1_1.Font.Color := clRed;
pnlQ1_1.Font.Size := 20;
pnlQ1_1.caption := 'Information Technology Paper 1';
end;
// ======================================================================
// Question 1.2 (9 marks)
// ======================================================================
procedure TfrmQ1.btnQ1_2Click(Sender: TObject);
var
rRadius, rHeight: real;
rLiquidVol: real;
begin
rRadius := StrToFloat(edtRadius.Text);
rHeight := StrToFloat(edtHeight.Text);
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 11 DBE/November 2018
NSC – Marking Guidelines
rLiquidVol := pi * sqr(rRadius) * (rHeight - 1);
ShowMessage('The volume is ' + FloatToStrF(rLiquidVol, ffFixed, 5, 1));
end;
// ======================================================================
// Question 1.3 (13 marks)
// ======================================================================
procedure TfrmQ1.btnQ1_3Click(Sender: TObject);
var
iNumber, I, iNumFactors: integer;
begin
redQ1_3.Clear;
iNumFactors := 0;
iNumber := Random(50 - 5 + 1) + 5;
for I := 1 to iNumber do
begin
if iNumber mod I = 0 then
begin
redQ1_3.Lines.Add(IntToStr(I));
Inc(iNumFactors);
end;
end;
if iNumFactors = 2 then
redQ1_3.Lines.Add(#13 + IntToStr(iNumber) + ' is a prime number');
end;
// ======================================================================
// Question 1.4 (14 marks)
// ======================================================================
procedure TfrmQ1.btnQ1_4Click(Sender: TObject);
var
sCommandLine, sCommand: String;
sChar: char;
i, iNumSteps: integer;
begin
// Provided code
sCommandLine := upperCase(InputBox('Robot instructions',
'Enter a line of instructions', 'SSSRSLSLLSSR'));
redQ1_4.Lines.Clear;
//=======================================================================
redQ1_4.Lines.Add(sCommandLine);
redQ1_4.Lines.Add('');
iNumsteps := 0;
i := 1;
while (i <= length(sCommandLine)) AND (iNumSteps <= 10) do
begin
sChar := sCommandLine[i];
case sChar of
'S': begin
if iNumsteps = 10 then
begin
sCommand := 'Number of forward steps more than 10';
Break;
end
else
begin
Inc(iNumsteps);
sCommand := 'Step forward';
end;
end;
'L': sCommand := 'Turn left';
'R': sCommand := 'Turn right';
end;
redQ1_4.Lines.Add(sCommand);
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 12 DBE/November 2018
NSC – Marking Guidelines
Inc(i);
end;
// Alternative solution
{ for i := 1 to length(sCommandLine) do
begin
sChar := sCommandLine[i];
case sChar of
'S': begin
Inc(iNumsteps);
sCommand := 'Step forward';
if iNumsteps > 10 then
sCommand := 'Number of forward steps exceeds 10';
end;
'L': sCommand := 'Turn left';
'R': sCommand := 'Turn right';
end;
redQ1_4.Lines.Add(sCommand);
if iNumSteps > 10 then
break;
end;
}
end;
// -----------------------------------------------------------------------
{$REGION 'Provided code - Do not modify'}
procedure TfrmQ1.FormCreate(Sender: TObject);
begin
pgcQ1.ActivePageIndex := 0;
CurrencyString := 'R';
end;
{$ENDREGION}
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 13 DBE/November 2018
NSC – Marking Guidelines
ANNEXURE F: SOLUTION FOR QUESTION 2
unit Question2_U;
// --- Delphi and Database programming -------------------------------
//
// Possible solution for Question 2.
// ---------------------------------------------------------------------
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, Buttons, ExtCtrls, ConnectDB_U, DB, ADODB, Grids,
DBGrids, ComCtrls, DateUtils, DBCtrls;
type
TfrmDBQuestion2 = class(TForm)
pnlBtns: TPanel;
bmbClose: TBitBtn;
bmbRestoreDB: TBitBtn;
grpTblPayments: TGroupBox;
grpTblEmployees: TGroupBox;
dbgEmployees: TDBGrid;
dbgPayments: TDBGrid;
tabsQ2_2ADO: TTabSheet;
tabsQ2_1SQL: TTabSheet;
btnQ2_2_1: TButton;
redQ2: TRichEdit;
grpresults: TGroupBox;
dbgrdSQL: TDBGrid;
grpOutput: TGroupBox;
pgcTabs: TPageControl;
pnlTables: TPanel;
btnQ2_1_1: TButton;
btnQ213: TButton;
btnQ212: TButton;
btnQ2_1_4: TButton;
btnQ2_1_5: TButton;
btnQ2_2_2: TButton;
btnQ2_2_3: TButton;
procedure bmbRestoreDBClick(Sender: TObject);
procedure FormCreate(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure btnQ2_1_1Click(Sender: TObject);
procedure btnQ213Click(Sender: TObject);
procedure btnQ212Click(Sender: TObject);
procedure btnQ2_1_4Click(Sender: TObject);
procedure btnQ2_1_5Click(Sender: TObject);
procedure btnQ2_2_1Click(Sender: TObject);
procedure btnQ2_2_2Click(Sender: TObject);
procedure btnQ2_2_3Click(Sender: TObject);
private
public
end;
var
frmDBQuestion2: TfrmDBQuestion2;
dbCONN: TConnection;
// Provided global variables
tblEmployees, tblPayments : TADOTable;
implementation
{$R *.dfm}
{$R+}
{$Region 'Question 2.1 - SQL SECTION'}
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 14 DBE/November 2018
NSC – Marking Guidelines
// ====================================================================
// Question 2.1.1 (3 marks)
// ====================================================================
procedure TfrmDBQuestion2.btnQ2_1_1Click(Sender: TObject);
var
sSQL1: String;
begin
sSQL1 := 'SELECT * FROM tblEmployees ORDER BY Surname ASC';
// Provided code - do not change
dbCONN.runSQL(sSQL1);
end;
// ===================================================================
// Question 2.1.2 (5 marks)
// ===================================================================
procedure TfrmDBQuestion2.btnQ212Click(Sender: TObject);
var
sSQL2: String;
begin
sSQL2 := 'SELECT Surname, FirstName, Children '+
'FROM tblEmployees WHERE Children > 3 AND Permanent = TRUE';
// Provided code - do not change
dbCONN.runSQL(sSQL2);
end;
// ==================================================================
// Question 2.1.3 (6 marks)
// ==================================================================
procedure TfrmDBQuestion2.btnQ213Click(Sender: TObject);
var
sSQL3: String;
begin
sSQL3 := 'SELECT PaymentNumber,IDNumber FROM tblEmployees E, tblPayments P
'+ 'WHERE E.EmployeeNumber = P.EmployeeNumber AND PaymentDate =
#2017/01/17#';
// Provided code - do not change
dbCONN.runSQL(sSQL3);
end;
// =================================================================
// Question 2.1.4 (3 marks)
// =================================================================
procedure TfrmDBQuestion2.btnQ2_1_4Click(Sender: TObject);
var
sSQL4: String;
begin
sSQL4 := 'DELETE * FROM tblPayments WHERE PaymentNumber = 110';
// Provided code - do not change
dbCONN.executeSQL(sSQL4, dbgPayments);
end;
// =================================================================
// Question 2.1.5 (8 marks)
// =================================================================
procedure TfrmDBQuestion2.btnQ2_1_5Click(Sender: TObject);
var
sSQL5: String;
begin
sSQL5 := 'SELECT Month(PaymentDate) as MonthNum, '+
'FORMAT(SUM(GrossSalary-Deductions), "Currency") AS TotalAmountPaid '
+ ' FROM tblPayments GROUP BY Month(PaymentDate)';
// Provided code - do not change
dbCONN.runSQL(sSQL5);
end;
{$EndRegion}
{$Region 'Question 2.2 – Delphi section'}
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 15 DBE/November 2018
NSC – Marking Guidelines
// =====================================================================
// Question 2.2.1 (6 marks)
// =====================================================================
procedure TfrmDBQuestion2.btnQ2_2_1Click(Sender: TObject);
begin
// Provided code
redQ2.Clear;
redQ2.Paragraph.TabCount := 2;
redQ2.Paragraph.Tab[0] := 80;
redQ2.Paragraph.Tab[1] := 150;
redQ2.Lines.Add('Temporary employees');
redQ2.SelAttributes.Style := [fsBold, fsUnderline];
redQ2.Lines.Add('Surname' + #9 + 'Firstname' + #9 + 'Children');
// Add your code here
tblEmployees.First;
while not tblEmployees.Eof do
begin
if (tblEmployees['Permanent'] = False) then
begin
redDisplay.Lines.Add(tblEmployees['Surname'] + #9 +
tblEmployees['FirstName'] + #9 + IntToStr(tblEmployees['Children']));
end;
tblEmployees.Next;
end;
// Alternative solution
// tblEmployees.First;
// while not tblEmployees.Eof do
// begin
// if (tblEmployees.FieldByName('Permanent').AsBoolean = False) then
// begin
// redDisplay.Lines.Add(tblEmployees.FieldByName('Surname').AsString
// + #9 + tblEmployees.FieldByName('FirstName').AsString
// + #9 + tblEmployees.FieldByName('Children').AsString);
// end;
// tblEmployees.Next;
// end;
end;
// ====================================================================
// Question 2.2.2 (5 marks)
// ====================================================================
procedure TfrmDBQuestion2.btnQ2_2_2Click(Sender: TObject);
begin
tblEmployees.Insert;
tblEmployees['Surname'] := 'Zwelini';
tblEmployees['Firstname'] := 'Lungile';
tblEmployees['IDNumber'] := '7601050179081';
tblEmployees['Permanent'] := True;
tblEmployees['Children'] := 3;
tblEmployees.Post;
// Alternative solution
// tblEmployees.Insert;
// tblEmployees.FieldByName('Surname').AsString := 'Zwelini';
// tblEmployees.FieldByName('Firstname').AsString := 'Lungile';
// tblEmployees.FieldByName('IDNumber').AsString := '7601050179081';
// tblEmployees.FieldByName('Permanent').AsBoolean := True;
// tblEmployees.FieldByName('Children').AsInteger := 3;
// tblEmployees.Post;
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 16 DBE/November 2018
NSC – Marking Guidelines
// ===================================================================
// Question 2.2.3 (4 marks)
// ===================================================================
procedure TfrmDBQuestion2.btnQ2_2_3Click(Sender: TObject);
begin
tblPayments.Edit;
tblPayments['Deductions'] := tblPayments['Deductions'] + tblPayments
['GrossSalary'] * 0.01;
tblPayments.Post;
// Alternative solution
// tblPayments.Edit;
// tblPayments.FieldByName('Deductions').AsFloat :=
// tblPayments.FieldByName'Deductions').AsFloat +
// (tblPayments.FieldByName('GrossSalary').AsFloat * 0.01);
// tblPayments.Post;
end;
//===================================================================
{$EndRegion}
{$REGION 'Setup DB connections - DO NOT CHANGE!'}
// ==================================================================
procedure TfrmDBQuestion2.bmbRestoreDBClick(Sender: TObject);
begin
dbCONN.RestoreDatabase(dbgEmployees, dbgPayments, dbgrdSQL);
redQ2.Clear;
tblEmployees := dbCONN.tblOne;
tblPayments := dbCONN.tblMany;
end;
procedure TfrmDBQuestion2.FormClose(Sender: TObject; var Action: TCloseAction);
begin
dbCONN.dbDisconnect;
end;
procedure TfrmDBQuestion2.FormCreate(Sender: TObject);
begin
CurrencyString := 'R';
dbCONN := TConnection.Create;
dbCONN.dbConnect;
tblEmployees := dbCONN.tblOne;
tblPayments := dbCONN.tblMany;
dbCONN.setupGrids(dbgEmployees, dbgPayments, dbgrdSQL);
pgcTabs.ActivePageIndex := 0;
end;
// =================================================================
{$ENDREGION}
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 17 DBE/November 2018
NSC – Marking Guidelines
ANNEXURE G: SOLUTION FOR QUESTION 3
OBJECT CLASS:
// Possible solution for Question 3.1
unit Restaurant_U;
interface
uses
SysUtils, DateUtils;
type
TRestaurant = class(TObject)
private
{ Private declarations }
fName: String;
fYearOpened: String;
fNumEmployees: integer;
public
{ Public declarations }
constructor Create(sName, sYearOpened: String; iNumEmployees: integer);
function toString: String;
function getNumEmployees: integer;
function compileCode(sOwner: String): String;
procedure increaseNumEmployees(iValue:integer);
end;
implementation
{ TRestaurant }
//======================================================================
// Question 3.1.1 (5 marks)
//======================================================================
constructor TRestaurant.Create(sName, sYearOpened: String;
iNumEmployees: integer);
begin
fName := sName;
fYearOpened := sYearOpened;
fNumEmployees := iNumEmployees;
end;
//======================================================================
// Question 3.1.2 (2 marks)
//======================================================================
function TRestaurant.getNumEmployees: integer;
begin
Result := fNumEmployees;
end;
//======================================================================
// Question 3.1.3 (3 marks)
//======================================================================
procedure TRestaurant.increaseNumEmployees(iValue: integer);
begin
fNumEmployees := fNumEmployees + iValue;
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 18 DBE/November 2018
NSC – Marking Guidelines
//======================================================================
// Question 3.1.4 (7 marks)
//======================================================================
function TRestaurant.compileCode(sOwner: String): String;
Var
sCode: String;
begin
sCode := fName[1] + Copy(sOwner,length(sOwner)-1) + fYearOpened;
Result := sCode;
end;
//======================================================================
// Provided code - toString
//======================================================================
function TRestaurant.toString: String;
var
sResult: String;
begin
sResult := 'Restaurant name: ' + fName + #13 + 'Year opened: ' +
fYearOpened + #13 + 'Number of employees: ' + intToStr(fNumEmployees)
+ #13;
Result := sResult;
end;
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 19 DBE/November 2018
NSC – Marking Guidelines
MAIN (APPLICATION) CLASS:
// Possible solution for Question 3.2
unit Question3_U;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics,
Controls, Forms, Dialogs, StdCtrls, Restaurant_U,
ComCtrls, ExtCtrls, jpeg, Spin;
type
TfrmQ3 = class(TForm)
GroupBox1: TGroupBox;
Label1: TLabel;
Label3: TLabel;
edtCompanyName: TEdit;
btnQ3_2_1: TButton;
GroupBox2: TGroupBox;
btnQ3_2_2: TButton;
Label5: TLabel;
edtOwnerName: TEdit;
edtIDCode: TEdit;
edtYearOpened: TEdit;
Label2: TLabel;
spnNumEmployees: TSpinEdit;
GroupBox4: TGroupBox;
edtAdd: TEdit;
Label6: TLabel;
btnQ3_2_3: TButton;
Label7: TLabel;
edtUpdated: TEdit;
redQ3: TRichEdit;
procedure btnQ3_2_1Click(Sender: TObject);
procedure btnQ3_2_2Click(Sender: TObject);
procedure FormShow(Sender: TObject);
procedure btnQ3_2_3Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
frmQ3: TfrmQ3;
// Provided code
objRestaurant: TRestaurant;
implementation
{$R *.dfm}
//======================================================================
// Question 3.2.1 (8 marks)
// ======================================================================
procedure TfrmQ3.btnQ3_2_1Click(Sender: TObject);
begin
redQ3.Clear;//Provided code
objRestaurant := TRestaurant.Create(edtCompanyName.Text,
trim(edtYearOpened.Text), spnNumEmployees.value);
redQ3.Lines.Add(objRestaurant.ToString);
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 20 DBE/November 2018
NSC – Marking Guidelines
// ======================================================================
// Question 3.2.2 (3 marks)
// ======================================================================
procedure TfrmQ3.btnQ3_2_2Click(Sender: TObject);
begin
edtIdCode.Text := objRestaurant.compileCode(edtOwnerName.Text);
end;
// ======================================================================
// Question 3.2.3 (10 marks)
// ======================================================================
procedure TfrmQ3.btnQ3_2_3Click(Sender: TObject);
//Provided declaration
const
iMaxEmployees = 40;
Var
iNumEmplToAdd:integer;
begin
iNumEmplToAdd := StrToInt(edtAddEmployees.Text);
if objRestaurant.getNumEmployees + iNumEmplToAdd <= iMaxEmployees then
begin
objRestaurant.increaseNumEmployees(iNumEmplToAdd);
edtUpdatedEmployees.Text := IntToStr(objRestaurant.getNumEmployees);
end
else
begin
edtUpdatedEmployees.Text :='Exceeds max';
end;
end;
//Provided code
procedure TfrmQ3.FormShow(Sender: TObject);
begin
btnQ3_2_1.SetFocus;
end;
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 21 DBE/November 2018
NSC – Marking Guidelines
ANNEXURE H: SOLUTION FOR QUESTION 4
// A possible solution for Question 4
unit Question4_U;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, ComCtrls, ExtCtrls, Math, Buttons;
type
TfrmQ4 = class(TForm)
btnQ4_1: TButton;
cmbDays: TComboBox;
cmbMonths: TComboBox;
btnQ4_2: TButton;
Panel1: TPanel;
Label1: TLabel;
Panel2: TPanel;
redQ4: TRichEdit;
Label2: TLabel;
bmbClose: TBitBtn;
procedure btnQ4_1Click(Sender: TObject);
procedure btnQ4_2Click(Sender: TObject);
procedure FormCreate(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
// Provided code - declarations
const
arrDays: array [1 .. 7] of String = ('Sun', 'Mon', 'Tue', 'Wed', 'Thu',
'Fri', 'Sat');
arrTempCustomers: array [1 .. 31] of integer = (248, 81, 189, 141, 163, 163,
233, 64, 145, 188, 108, 124, 120, 130, 57, 64, 131, 54, 138, 71, 75, 152,
126, 170, 56, 157, 230, 82, 199, 119, 136);
var
frmQ4: TfrmQ4;
arrCustomers: array [1 .. 31] of integer;
// User declarations
iDaysInMonth: integer = 0;
implementation
{$R *.dfm}
{$R+}
// ======================================================================
// Question 4.1 (14 marks)
// ======================================================================
procedure TfrmQ4.btnQ4_1Click(Sender: TObject);
var
tFile: TextFile;
sLine, sMonth: String;
iPos : integer;
begin
iDaysInMonth := 0;
sMonth := cmbMonths.Text;
AssignFile(tFile, 'Visitors.txt');
Reset(tFile);
while NOT EOF(tFile) do
begin
Readln(tFile, sLine);
if Pos(sMonth, sLine) > 0 then
begin
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 22 DBE/November 2018
NSC – Marking Guidelines
inc(iDaysInMonth, 1);
iPos := pos('#',sLine);
arrCustomers[iDaysInMonth] := StrToInt(copy(sLine, iPos+1,
length(sLine)));
end;
end;
ShowMessage('Array successfully populated.');
end;
// =====================================================================
// Question 4.2 (18 marks)
// =====================================================================
procedure TfrmQ4.btnQ4_2Click(Sender: TObject);
var
iCnt, iDate: integer;
sOutput: String;
iRow, iDayOfWeek, iCol, iWeekLoop: integer;
sLine: String;
iNumRows: integer;
begin
// Provided code
redQ4.Clear;
redQ4.SelAttributes.Style := [fsBold];
redQ4.Lines.Add('Calendar for ' + cmbMonths.Text + #13);
sOutput := '';
for iCnt := 1 to 7 do
begin
sOutput := sOutput + arrDays[iCnt] + #9;
end;
redQ4.SelAttributes.Style := [fsBold];
redQ4.Lines.Add(sOutput);
// Question 4.2 - Type your code here
iDayOfWeek := cmbDays.ItemIndex;
iDate := 1;
for iCol := 1 to iDayOfWeek do
begin
sLine := sLine + '' + #9;
end;
while (iDate <= iDaysInMonth) do
begin
if (iDate + 7) <= iDaysInMonth then
iWeekLoop := 7 - iDayOfWeek
else // 1
iWeekLoop := iDaysInMonth - iDate + 1;
for iCnt := 1 to iWeekLoop do
begin
sLine := sLine + IntToStr(iDate) + ' (' + IntToStr(arrCustomers[iDate])
+ ')' + #9;
inc(iDate);
end;
redQ4.Lines.Add(sLine);
sLine := '';
iDayOfWeek := 0;
end;
//=======================================================================
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 23 DBE/November 2018
NSC – Marking Guidelines
// Question 4.2 - Alternative 1
iDayOfWeek := cmbDays.ItemIndex + 1;
sLine:=’’;
for iCol := 1 to iDayOfWeek - 1 do
sLine := sLine + '' + #9;
for iDate := 1 to iDaysInMonth do
// begin
// sLine := sLine + Copy(arrDates[iDayOfWeek],1,2) + '('
// + IntToStr(arrCustomers[iDate]) + ')' + #9;
// inc(iDayOfWeek) ;
// if iDayOfWeek = 8 then
// begin
// redQ4.Lines.Add(sLine) ;
// sLine := '';
// iDayOfWeek := 1;
// end;
// end;
// redQ4.Lines.Add(sLine) ;
//========================================================================
// Question 4.2 - Alternative 2
// iDayOfWeek := cmbDays.ItemIndex + 1;
// iDate := 1;
// iNumRows := Ceil((iDaysInMonth + iDayOfWeek) / 7);
// for iRow := 1 to iNumRows do
// begin
// sLine := '';
// for iCol := 1 to 7 do
// begin
// if (iRow = 1) AND (iCol < iDayOfWeek) then
// begin
// sLine := sLine + '' + #9;
// end
// else
// if iDate <= iDaysInMonth then
// begin
// sLine := sLine + IntToStr(iDate) + ' (' +
// IntToStr(arrCustomers[iDate]) + ')' + #9;
// iDate := iDate + 1;
// end;
// end;
// redQ4.Lines.Add(sLine);
// end;
end;
// -----------------------------------------------------------------------
{$REGION 'PROVIDED CODE - DO NOT MODIFY!'}
procedure TfrmQ4.FormCreate(Sender: TObject);
begin
redQ4.Paragraph.TabCount := 7;
redQ4.Paragraph.Tab[1] := 50;
redQ4.Paragraph.Tab[2] := 100;
redQ4.Paragraph.Tab[3] := 150;
redQ4.Paragraph.Tab[4] := 200;
redQ4.Paragraph.Tab[5] := 250;
redQ4.Paragraph.Tab[6] := 300;
redQ4.Paragraph.Tab[7] := 350;
end;
{$ENDREGION}
end.
Copyright reserved
Study this subject
Recommended for this subject

Memorandum
Information Technology Grade 12 P2 NSC November 2018 Memo

Memorandum
Information Technology Grade 12 P1 2018 Memo (Afr)

Memorandum
Information Technology Grade 12 P1 Exemplar 2018 Memo (Eng)

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

Memorandum
Information Technology Grade 12 P1 2018 Memo (Afr)
_hlayiso.com_--50e776f8-b245-4554-9243-5cf350cf10d2/v1-50c5c39841428639bad4/card.webp)
Memorandum
Information Technology Grade 12 P1 NSC November 2020 Memo
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