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





View all





Information Technology Grade 12 P1 NSC June 2023 Memo (Eng)
Grade 12 Information Technology Paper 1 memorandum from the NSC June Exam 2023 (English), 25 pages. Read online or download the free PDF.
Information Technology · Grade 12 · NSC June Exam · 2023. Memorandum. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2023
- Exam period
- NSC June Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 25
- File size
- 743.1 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 25
This exam
NSC June Exam 2023
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Information Technology P1 2 DBE/2023
SC/NSC – 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
Question 1 to Question 4 in programming code.
Copies of Annexures A, B, C, D and the summary for the marks of the learner
(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/2023
SC/NSC – 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 – Formatting]
Any ONE of font size or style:
Set font size of edtQ1_1 to 14
edtQ1_1.Font.Size (1) := 14 (1)
OR
Set font style of edtQ1_1 to underline 4
edtQ1_1.Font.Style (1) := [fsUnderline] (1)
Set text of edtQ1_1 to 'Hello world'
Set colour of edtQ1_1 to green
1.2 Button [1.2 – Random number]
Generate a random number in the correct range (1 to 99)
Check if random number is a single digit (<=9)
Display the number converted to string and a message
indicating a single digit in pnlQ1_2
Else
Display the number converted to string and a message
indicating a two digit in pnlQ1_2
8
Concepts:
Generate a random number (1) in the correct range (1)
Testing if random number is (1):
o A single digit (1), display number converted to string
(1) with applicable message (1)
o A two digit (1), display number converted to string with
applicable message (1)
1.3 Button [1.3 – Area]
Extract d from edtQ1_3 converted to integer/float
8
area = 3 * sqrt(3) / 2 * sqr(d) - pi * sqr(d/2)
Display the value of area in pnlQ1_3 to one decimal
Copyright reserved
Downloaded from hlayiso.com
Information Technology P1 4 DBE/2023
SC/NSC – Marking Guidelines
1.4 Button - [1.4 – Find]
Extract sWord from edtQ1_4.text
Create and initialise counter
While NOT EOF(text file) do
Read word from the file
Change words to uppercase/lowercase
11
If word from file = sWord (or edtQ1_4.text)
Increment counter
If counter > 0 (or applicable flag)
Display occurrences in redQ1_4
Else (OR if counter = 0)
Display “Word not found” in redQ1_4
1.5 Button [1.5 – Booster rocket]
Create and initialise counter
Get total fuel from input box converted to integer/real
Loop while total fuel >= 200
9
Increment counter
fuel used = total fuel * 7.5 / 100
total fuel = total fuel – fuel used
Display counter, fuel used and total fuel left
in neat columns formatted to two decimal places
TOTAL SECTION A: 40
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 5 DBE/2023
SC/NSC – Marking Guidelines
ANNEXURE B
QUESTION 2: MARKING GRID – SQL AND DATABASE PROGRAMMING
CENTRE NUMBER: EXAMINATION NUMBER:
MAX. LEARNER'S
QUESTION DESCRIPTION
MARKS MARKS
2.1 SQL statements
2.1.1 Button [2.1.1 – iOS products]
SELECT DeviceID, DeviceName
FROM tblDevices
WHERE OperatingSystem = "iOS" 3
Alternative:
WHERE OperatingSystem LIKE "iOS"
2.1.2 Button [2.1.2 – Category selected]
SELECT DeviceName, Category, NumInStock
FROM tblDevices
WHERE Category LIKE "%' + sDeviceType + '"'
Alternatives: 3
WHERE Category LIKE "Smart ' + sDeviceType + '"'
WHERE Category = "Smart ' + sDeviceType + '"'
NOTE: Also accept QuotedStr
2.1.3 Button [2.1.3 – Online support]
SELECT DeviceName, Category, OperatingSystem
FROM tblDevices D, tblManufacturers M
WHERE D.ManufacturerID = M.ManufacturerID 6
AND OnlineSupport = True
ORDER BY DeviceName
2.1.4 Button [2.1.4 – Profit per manufacturer]
SELECT ManufacturerID,
FORMAT(SUM (NumInStock * Price * 0.6) ,
"CURRENCY")
6
AS Profit
FROM tblDevices
GROUP BY ManufacturerID
2.1.5 Button [2.1.5 – Remove devices]
Delete FROM tblDevices 4
WHERE Category = "Smart speaker"
AND ManufacturerID = "M104"
Subtotal: 22
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 6 DBE/2023
SC/NSC – Marking Guidelines
QUESTION 2: MARKING GRID (CONT.)
2.2 Database Manipulation
2.2.1 Button [2.2.1 – Display products]
Go to the first record in the tblManufacturers
Use a loop to step through tblManufacturers
Display the ManufacturerName and ContactNumber
Display the DeviceName, Instock and Price as headings
Go to the fist record in the tblDevices tabel
Use a loop to step through tblDevices
Test if (tblManufacturers ['ManufacturerID'] =
12
tblDevices['ManufacturerID'])
Display DeviceName, NumInStock, converted to
a string, and Price converted to string ,
in redQ2_2_1
tblDevices.Next
End loop (tblDevices)
tblManufacturers.Next
End loop (tblManufacturers)
2.2.2 Button [2.2.2 – Update stock]
Extract iNumSold from input dialog box converted to integer
Test if tblDevices['NumInStock'] >= iNumSold
tblDevices.Edit
tblDevices['NumInStock'] =
tblDevices['NumInStock'] - iNumSold
tblDevices.Post
6
else
ShowMessage "Not enough items in stock."
NOTES:
Edit and Post does not need to be inside the if statement.
Any other form of navigation between records can also be
used instead of Post.
Subtotal: 18
TOTAL SECTION B: 40
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 7 DBE/2023
SC/NSC – 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 Constructor Create:
Header with 3 parameter values and correct data types
Assign correct parameters to fSwitchID , fDevice and 5
fPowerUsage
Assign False to fSwitchStatus
3.1.2 Function getSwitchID with the string return type
2
Result := fSwitchID
3.1.3 Function energyUsed with real return type
Function with correct return type and correct parameter 4
Result = fPowerUsage * parameter value / 1000
3.1.4 Procedure setSwitchStatus
Correct heading with Boolean parameter 3
Set the fSwitchStatus attribute to the parameter value
3.1.5 Function toString with string return type
Result with correct labels and correct attribute names
4
Call the determineSwitchStatus method
Correct formatting
Subtotal: Object class 18
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 8 DBE/2023
SC/NSC – Marking Guidelines
QUESTION 3: MARKING GRID (CONT.)
MAX. LEARNER'S
QUESTION DESCRIPTION
MARKS MARKS
3.2.1 Button [3.2.1 – Instantiate object]
Extract the switchID from the combobox
Extract the selected device from the listbox:
sLine := lstQ3_2_1.Items[lstQ3_2_1.ItemIndex]
Extract the device and power usage from sLine:
sDevice := Copy(sLine, 1, pos('#', sLine) – 1) 8
iWatt := strToInt(Copy(sLine,pos('#', sLine) + 1))
Instantiate the object with the provided values:
objSmartSwitch := TSmartSwitch.create
(sSwitchID, sDevice, iWatt)
Call objSmartSwitch.toString to display in the rich edit
3.2.2 Button [3.2.2 – Change switch status]
Use ItemIndex from the radio group with if or case
to call the objSmartSwitch.setSwitchStatus method
with correct True or False argument 5
Display using the methods objSmartSwitch.getSwitchID
and objSmartSwitch.determineSwitchStatus in the rich
edit
3.2.3 Button [3.2.3 – Write to file]
AssignFile(tFile, 'log.txt') and Append(tFile)
Writeln(tFile,
DateToStr(Date) + ',' + lblTime.Caption + ','
6
+ objSmartSwitch.getSwitchID + '#'
+ objSmartSwitch.determineSwitchStatus)
Close file
NOTE: Also accept TimeToStr(Time) instead of lblTime
3.2.4 Button [3.2.4 – Power usage]
Extract hours from edtQ3_2_4 and convert to an integer
Use the objSmartSwitch.energyUsed method with hours 3
as an argument
Display the energy used in the rich edit with correct text
Subtotal Form class: 22
TOTAL SECTION C: 40
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 9 DBE/2023
SC/NSC – Marking Guidelines
ANNEXURE D
QUESTION 4: MARKING GRID – PROBLEM SOLVING
CENTRE NUMBER: EXAMINATION NUMBER:
MAX LEARNER'S
QUESTION DESCRIPTION
MARKS MARKS
4.1 Button [4.1 – Display]
Clear redQ4
Add heading and column numbers
Loop iRow from 1 to 5
Initialise output string with iRow 7
Correctly nested loop:
Loop iCol from 1 to 6
Add item at array[iRow, iCol] to output string
Display output string in rich edit
4.2 Button [4.2 – Add access point]
Extract the iRow and iCol from the spin edits
Initialise counter
Loop iC from 1 to 6
Check if array at index [iRow, iC] = 'A'
Increment counter
10
Check if counter is 2 or less
Check if character at index of the array is NOT an 'A'
Add an 'A' to the correct index of the array
Else
Display message that there is an access point
Else
Display message that there are already 3 access
points
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 10 DBE/2023
SC/NSC – Marking Guidelines
4.3 Button [4.3 – Coverage]
Loop through rows iRow from 1 to 5
Loop through columns iCol from 1 to 6
If access point is at the current index
Loop from iRow – 1 to iRow + 1
Loop from iCol – 1 to iCol + 1
Check if (row IN [1..5]) and (column IN [1..6])
If array[row, column] = '_' (or Not 'A')
Set array[row, column] = '*'
Display array after signals have been added
Concepts:
Finding the access points: (3)
Determine the position (row and column) of an access
point
13
Making provision for all surrounding elements:
Loop (1) from row index – 1 (1) to row index + 1 (1)
Nested loop (1) from Col index – 1 (1) to Col index + 1 (1)
Alternative:
For individually coded index combinations, subtract 1 mark
for each missing combination with a maximum of 6 marks.
Test and allocate:
Check that indexes does not exceed array size (1)
Check if character at indexes is '_' (1)
Change character at indexes to '*' (1)
NOTE: Testing and allocation needs to be done
correctly at least once.
Display array after signals have been added (1)
TOTAL SECTION D: 30
GRAND TOTAL: 150
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 11 DBE/2023
SC/NSC – Marking Guidelines
SUMMARY OF LEARNER'S MARKS:
CENTRE NUMBER: LEARNER'S EXAMINATION NUMBER:
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 12 DBE/2023
SC/NSC – 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, pngimage;
type
TfrmQuestion1 = class(TForm)
grpQ1_1: TGroupBox;
edtQ1_1: TEdit;
btnQ1_1: TButton;
grpQ1_2: TGroupBox;
btnQ1_2: TButton;
pnlQ1_2: TPanel;
grpQ1_5: TGroupBox;
edtQ1_5: TEdit;
redQ1_5: TRichEdit;
Label1: TLabel;
btn1_5: TButton;
grpQ1_3: TGroupBox;
grpQ1_4: TGroupBox;
Image1: TImage;
Label2: TLabel;
edtQ1_3: TEdit;
Label3: TLabel;
btnQ1_3: TButton;
pnlQ1_3: TPanel;
btnQ1_4: TButton;
redQ1_4: TRichEdit;
procedure btnQ1_1Click(Sender: TObject);
procedure btnQ1_2Click(Sender: TObject);
procedure btn1_5Click(Sender: TObject);
procedure btnQ1_3Click(Sender: TObject);
procedure btnQ1_4Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
frmQuestion1: TfrmQuestion1;
implementation
{$R *.dfm}
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 13 DBE/2023
SC/NSC – Marking Guidelines
// =============================================================
// 1.1 Formatting 4 marks
// =============================================================
procedure TfrmQuestion1.btnQ1_1Click(Sender: TObject);
begin
edtQ1_1.Font.Size := 14;
edtQ1_1.Text := 'Hello world';
edtQ1_1.Font.Style := [fsUnderline];
edtQ1_1.Color := clGreen;
end;
// =============================================================
// 1.2 Random number 8 marks
// =============================================================
procedure TfrmQuestion1.btnQ1_2Click(Sender: TObject);
var
iRandom: integer;
begin
iRandom := Random(99) + 1;
if iRandom <= 9 then
pnlQ1_2.Caption := IntToStr(iRandom) + ' is a single digit value'
else
pnlQ1_2.Caption := IntToStr(iRandom) + ' is a two digit value';
end;
// =============================================================
// 1.3 Area 8 marks
// =============================================================
procedure TfrmQuestion1.btnQ1_3Click(Sender: TObject);
var
d, rArea: real;
const
pi: real = 22 / 7;
begin
d := StrToFloat(edtQ1_3.Text);
rArea := (3 * sqrt(3) / 2) * sqr(d) - pi * sqr(d / 2);
pnlQ1_3.Caption := FloatToStrF(rArea, ffFixed, 7, 1) + ' cm squared';
end;
// =============================================================
// 1.4 Find 11 marks
// =============================================================
procedure TfrmQuestion1.btn1_4Click(Sender: TObject);
var
tFile: textfile;
sLine, sWord: String;
iCount: integer;
begin
redQ1_4.Clear;
AssignFile(tFile, 'Words.txt');
Reset(tFile);
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 14 DBE/2023
SC/NSC – Marking Guidelines
sWord := (edtQ1_4.Text);
iCount := 0;
while NOT EOF(tFile) do
begin
Readln(tFile, sLine);
if UpperCase(sWord) = UpperCase(sLine) then
begin
inc(iCount);
end;
end;
if iCount > 0 then
begin
redQ1_4.Lines.Add('Occurrences: ' + IntToStr(iCount));
end
else
begin
redQ1_4.Lines.Add('Word not found');
end;
CloseFile(tFile);
end;
// =============================================================
// 1.5 Booster rocket 9 marks
// =============================================================
procedure TfrmQuestion1.btnQ1_5Click(Sender: TObject);
var
rTotalFuel, rFuel: real;
iCounter: integer;
begin
// Provided code
redQ1_5.Paragraph.TabCount := 3;
redQ1_5.Paragraph.tab[0] := 1;
redQ1_5.Paragraph.tab[1] := 50;
redQ1_5.Paragraph.tab[2] := 150;
redQ1_5.Lines.Add('Second' + #9 + 'Fuel used' + #9 +'Fuel left ' );
//1.5 Booster rocket
rTotalFuel := StrToFloat(inputbox('Fuel', 'Total litres of fuel: ',
'550'));
iCounter := 0;
while rTotalFuel >= 200 do
begin
inc(iCounter);
rFuel := rTotalFuel * 7.5 / 100;
rTotalFuel := rTotalFuel - rFuel;
redQ1_5.Lines.Add(IntToStr(iCounter)+ #9+
FloatToStrF(rFuel,FFFixed,5,2)+#9+
FloatToStrF(rTotalFuel,FFFixed,5,2));
end;
end;
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 15 DBE/2023
SC/NSC – Marking Guidelines
ANNEXURE F: SOLUTION FOR QUESTION 2
//======================================================================
// 2.1 – Section: SQL statements
//======================================================================
//======================================================================
// 2.1.1 iOS devices 3 marks
//======================================================================
sSQL1 := 'SELECT DeviceID, DeviceName FROM tblDevices ' +
'WHERE OperatingSystem = "iOS"';
//======================================================================
// 2.1.2 Category selected 3 marks
//======================================================================
sSQL2 := 'SELECT DeviceName, Category, NumInStock ' +
'FROM tblDevices ' +
'WHERE Category LIKE "%' + sDeviceType + '"';
//======================================================================
// 2.1.3 Online support 6 marks
//======================================================================
sSQL3 := 'SELECT DeviceName, Category, OperatingSystem ' +
'FROM tblDevices D, tblManufacturers M ' +
'WHERE D.ManufacturerID = M.ManufacturerID ' +
'AND OnlineSupport = True ' +
'ORDER BY DeviceName';
//======================================================================
// 2.1.4 Profit per manufacturer 6 marks
//======================================================================
sSQL4 := 'SELECT ManufacturerID, ' +
'FORMAT(SUM(NumInStock * (Price * 0.6)), "CURRENCY") ' +
'AS Profit ' +
'FROM tblDevices GROUP BY ManufacturerID';
// ========================================================================
// 2.1.5 Remove devices 4 marks
//=======================================================================
sSQL5 := 'Delete FROM tblDevices ' +
'WHERE Category = "Smart speaker" ' +
'AND ManufacturerID = "M104"';
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 16 DBE/2023
SC/NSC – Marking Guidelines
//======================================================================
// 2.2 – Section: Delphi code
//======================================================================
//======================================================================
// 2.2.1 Display products 12 marks
// =====================================================================
procedure TfrmQuestion2.btnQ2_2_1Click(Sender: TObject);
begin
// Provided code
redQ2_2_1.Clear;
// Question 2.2.1
tblManufacturers.First;
while NOT tblManufacturers.Eof do
begin
redQ2_2_1.Lines.Add(tblManufacturers['ManufacturerName'] + ': ' +
tblManufacturers['ContactNumber']);
redQ2_2_1.Lines.Add(#9 + 'Device name' + #9 + 'In stock' + #9 +
'Price');
tblDevices.First;
while NOT tblDevices.Eof do
begin
if (tblDevices['ManufacturerID'] =
tblManufacturers['ManufacturerID']) then
begin
redQ2_2_1.Lines.Add(#9 + tblDevices['DeviceName'] + #9
+ IntToStr(tblDevices['NumInStock']) +
#9 +
FloatToStrF(tblDevices['Price'],
ffCurrency, 8, 2));
end;
tblDevices.Next;
end;
redQ2_2_1.Lines.Add('');
tblManufacturers.Next;
end;
end;
// =====================================================================
// 2.2.2 Update stock 6 marks
// =====================================================================
procedure TfrmQuestion2.btnQ2_2_2Click(Sender: TObject);
var
iNumSold: integer;
begin
// Question 2.2.2
iNumSold := StrToInt(InputBox('Products sold', 'Amount:', '50'));
if tblDevices['NumInStock'] - iNumSold >= 0 then
begin
tblDevices.Edit;
tblDevices['NumInStock'] := tblDevices['NumInStock'] - iNumSold;
tblDevices.Post;
end
else
ShowMessage('Not enough items in stock.');
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 17 DBE/2023
SC/NSC – Marking Guidelines
// =====================================================
// {$ENDREGION}
// =====================================================
// {$REGION 'Provided code: Setup DB connections - DO NOT CHANGE!'}
// =====================================================
procedure TfrmQuestion2.FormClose(Sender: TObject; var Action:
TCloseAction);
begin
// Disconnects from database and closes all open connections
dbCONN.dbDisconnect;
end;
procedure TfrmQuestion2.FormCreate(Sender: TObject);
begin
// Provided code
redQ2_2_1.Paragraph.TabCount := 2;
redQ2_2_1.Paragraph.Tab[0] := 100;
redQ2_2_1.Paragraph.Tab[1] := 150;
redQ2_2_1.Paragraph.Tab[2] := 200;
end;
procedure TfrmQuestion2.FormShow(Sender: TObject);
begin
// Sets up the connection to database and opens the tables.
dbCONN := TConnection.Create;
dbCONN.dbConnect;
tblManufacturers := dbCONN.tblOne;
tblProducts := dbCONN.tblMany;
dbCONN.setupGrids(dbgManufacturers, dbgProducts, dbgrdSQL);
pgcDBAdmin.ActivePageIndex := 0;
end;
// =====================================================
// {$ENDREGION}
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 18 DBE/2023
SC/NSC – Marking Guidelines
ANNEXURE F: SOLUTION FOR QUESTION 3
Object class
// =====================================================================
// 3.1.1 Constructor 5 marks
// =====================================================================
constructor TSmartSwitch.create(sSwitchID: String; sDevice: String;
iPowerUsage: Integer);
begin
fSwitchID := sSwitchID;
fDevice:=sDevice;
fPowerUsage := iPowerUsage;
fSwitchStatus := False;
end;
// =====================================================================
// 3.1.2 getSwitchID 2 marks
// =====================================================================
function TSmartSwitch.getSwitchID: String;
begin
Result := fSwitchID;
end;
// =====================================================================
// 3.1.3 energyUsed 4 marks
// =====================================================================
function TSmartSwitch.energyUsed(iHours: Integer): Real;
begin
Result := fPowerUsage * iHours / 1000;
end;
// =====================================================================
// 3.1.4 setSwitchStatus 3 marks
// =====================================================================
procedure TSmartSwitch.setSwitchStatus(bStatus: Boolean);
begin
fSwitchStatus := bStatus;
end;
// =====================================================================
// 3.1.5 toString 4 marks
// =====================================================================
function TSmartSwitch.toString: String;
begin
Result := 'Switch ID: ' + fSwitchID + #13 +
'Device: ' + fDevice + #13 +
'Power usage: ' + intToStr(fPowerUsage) + 'W' + #13 +
'Switch status:' + determineSwitchStatus;
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 19 DBE/2023
SC/NSC – Marking Guidelines
// =====================================================================
// Provided Code
// =====================================================================
function TSwitch.determineSwitchStatus: String;
var
sStatus: String;
begin
case fSwitchStatus of
True:sStatus := 'ON';
False: sStatus := 'OFF';
end;
Result := sStatus;
end;
//======================================================================
// End of provided Code
// =====================================================================
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 20 DBE/2023
SC/NSC – Marking Guidelines
Main form unit
unit Question3_u;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls,
Forms,
Dialogs,SmartSwitch_u, StdCtrls, ComCtrls, Spin, ExtCtrls;
type
TfrmQuestion3 = class(TForm)
redQ3: TRichEdit;
btnQ3_2_1: TButton;
Panel1: TPanel;
btnQ3_2_2: TButton;
GroupBox3: TGroupBox;
Label3: TLabel;
GroupBox2: TGroupBox;
rgpQ3_2_2: TRadioGroup;
Panel2: TPanel;
GroupBox1: TGroupBox;
lstQ3_2_1: TListBox;
btnQ3_2_4: TButton;
cmbQ3_2_1: TComboBox;
Label1: TLabel;
edtQ3_2_4: TEdit;
Label2: TLabel;
GroupBox4: TGroupBox;
btnQ3_2_3: TButton;
lblTime: TLabel;
procedure btnQ3_2_1Click(Sender: TObject);
procedure btnQ3_2_2Click(Sender: TObject);
procedure btnQ3_2_4Click(Sender: TObject);
procedure FormCreate(Sender: TObject);
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
frmQuestion3: TfrmQuestion3;
objSmartSwitch:TSmartSwitch;
implementation
{$R *.dfm}
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 21 DBE/2023
SC/NSC – Marking Guidelines
// =====================================================================
// 3.2.1 Instantiate object 8 marks
// =====================================================================
procedure TfrmQuestion3.btnQ3_2_1Click(Sender: TObject);
Var
sLine, sDevice:String;
iWatt:Integer;
begin
redQ3.Clear;
sLine := lstQ3_2_1.Items[lstQ3_2_1.ItemIndex];
sDevice := Copy(sLine, 1, pos('#',sLine) - 1);
iWatt := strToInt(Copy(sLine,pos('#',sLine)+1
objSmartSwitch:=TSmartSwitch.create(cmbQ3_2_1.Text,sDevice,iWatt);
redQ3.Lines.Add(objSmartSwitch.toString);
end;
// =====================================================================
// 3.2.2 Change switch status 5 marks
// =====================================================================
procedure TfrmQuestion3.btnQ3_2_2Click(Sender: TObject);
begin
redQ3.Lines.Clear;
case rgpQ3_2_2.ItemIndex of
0: objSmartSwitch.setSwitchStatus(True);
1: objSmartSwitch.setSwitchStatus(False);
end;
redQ3.Lines.Add(objSmartSwitch.getSwitchID + ': ' +
objSmartSwitch.determineSwitchStatus);
end;
// =====================================================================
// 3.2.3 Write to file 6 marks
// =====================================================================
procedure TfrmQuestion3.Button1Click(Sender: TObject);
var
tFile : textFile;
begin
AssignFile(tFile, 'log.txt');
Append(tFile);
writeln(tFile,DateToStr(now)+','+lblTime.Caption+','
+objSmartSwitch.getSwitchID+'#'+ objSmartSwitch.determineSwitchStatus);
CloseFile(tFile);
end;
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 22 DBE/2023
SC/NSC – Marking Guidelines
// =====================================================================
// 3.2.4 Power usage 3 marks
// =====================================================================
procedure TfrmQuestion3.btnQ3_2_4Click(Sender: TObject);
var
iHours : Integer;
rEnergy:Real;
begin
redQ3.Lines.Clear;
iHours := StrToInt(edtQ3_2_4.Text);
rEnergy := objSmartSwitch.energyUsed(iHours);
redQ3.Lines.Add('Energy used is: '+ FloatToStr(rEnergy) +' kWh');
end;
end.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 23 DBE/2023
SC/NSC – Marking Guidelines
ANNEXURE H: SOLUTION FOR QUESTION 4
unit Question4_u;
interface
uses
Windows, Messages, SysUtils, Variants,
Classes, Graphics,
Controls, Forms, Dialogs, StdCtrls, ComCtrls,
ExtCtrls, Buttons, Spin, pngimage;
type
TfrmQuestion4 = class(TForm)
Panel1: TPanel;
Panel2: TPanel;
btnQ4_1: TButton;
redQ4: TRichEdit;
btnQ4_2: TButton;
btnQ4_3: TButton;
gbxQ4_3: TGroupBox;
sedQ4_2_Row: TSpinEdit;
sedQ4_3_Col: TSpinEdit;
Label1: TLabel;
Label2: TLabel;
gbxQ4_1: TGroupBox;
gbxQ4_2: TGroupBox;
Image1: TImage;
procedure btnQ4_1Click(Sender: TObject);
procedure btnQ4_2Click(Sender: TObject);
procedure btnQ4_3Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form1: TfrmQuestion4;
arrNetwork: array [1 .. 5, 1 .. 6] of char =
(('_', 'A', '_', '_', '_', '_'), ('_', '_', '_', '_', '_', '_'),
('_', '_', '_', '_', 'A', '_'), ('_', '_', '_', '_', '_', '_'),
('_', 'A', '_', '_', '_', '_'));
implementation
{$R *.dfm}
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 24 DBE/2023
SC/NSC – Marking Guidelines
// =====================================================================
// 4.1 Display 7 marks
// =====================================================================
procedure TfrmQuestion4.btnQ4_1Click(Sender: TObject);
var
I: Integer;
J: Integer;
sLine: String;
begin
redQ4.Clear;
redQ4.Lines.Add('Access points');
sLine := ' 1 2 3 4 5 6' + #13;
for I := 1 to Length(arrNetwork) do
begin
sLine := sLine + intToStr(I) + ' ';
for J := 1 to Length(arrNetwork[I]) do
begin
sLine := sLine + arrNetwork[I, J] + ' ';
end;
sLine := sLine + #13;
end;
redQ4.Lines.Add(sLine);
end;
// =====================================================================
// 4.2 Add access point 10 marks
// =====================================================================
procedure TfrmQuestion4.btnQ4_2Click(Sender: TObject);
var
I, iCounter, iRow, iCol: Integer;
begin
redQ4.Clear;
iRow := sedQ4_2_Row.Value;
iCol := sedQ4_3_Col.Value;
iCounter := 0;
for I := 1 to Length(arrNetwork[iRow]) do
begin
if arrNetwork[iRow, I] = 'A' then
inc(iCounter);
end;
if iCounter < 3 then
begin
if arrNetwork[iRow, iCol] <> 'A' then
begin
arrNetwork[iRow, iCol] := 'A';
end
else
begin
ShowMessage('Access point already on this location.');
end;
end
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology P1 25 DBE/2023
SC/NSC – Marking Guidelines
else
begin
ShowMessage('There are already 3 access points in the row.');
end;
btnQ4_1.Click;
end;
// =====================================================================
// 4.3 Coverage 13 marks
// =====================================================================
procedure TfrmQuestion4.btnQ4_3Click(Sender: TObject);
var
I: Integer;
J: Integer;
K: Integer;
L: Integer;
begin
for I := 1 to Length(arrNetwork) do
begin
for J := 1 to Length(arrNetwork[I]) do
begin
if arrNetwork[I, J] = 'A' then
begin
for K := J - 1 to J + 1 do
begin
for L := I - 1 to I + 1 do
begin
if (K IN [1..5]) AND (L IN [1..6]) then
begin
if arrNetwork[L, K] = '_' then
begin
arrNetwork[L, K] := '*';
end;
end;
end;
end;
end;
end;
end;
btnQ4_1.Click;
end;
end.
Copyright reserved
Study this subject
Recommended for this subject

Question paper
Information Technology Grade 12 P1 NSC June 2023 QP (Eng)

Memorandum
Information Technology Grade 12 P1 NSC June 2019 Memo (Afr)

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

Question paper
Information Technology Grade 12 P1 NSC November 2023 QP

Question paper
Information Technology Grade 12 P1 NSC June 2019 QP (Afr)

Question paper
Information Technology Grade 12 P1 NSC June 2018 QP (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