# Information Technology Grade 12 P1 NSC November 2022 Memo

> Grade 12 Information Technology Paper 1 memorandum from the NSC November Exam 2022 (English), 29 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/information-technology-p1-nov-2022-mg-eng/0ea425b8-0093-4221-a861-8f0138553e76
- Updated: 2026-10-29
- Subject: Information Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2022
- Exam period: NSC November Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 29

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Information Technology](https://www.hlayiso.com/library/grade-12/information-technology) › [Information Technology Grade 12 P1 NSC November 2022 Memo](https://www.hlayiso.com/library/information-technology-p1-nov-2022-mg-eng/0ea425b8-0093-4221-a861-8f0138553e76)

## About this document

Information Technology · Grade 12 · NSC November Exam · 2022. Memorandum. Read online or download the PDF.

Read it free online on the page above; download the PDF from there.

## Document text

Text extracted from the PDF. Layout, diagrams and tables may not survive extraction.

### Page 1

Downloaded from hlayiso.com

                                   NATIONAL
                              SENIOR CERTIFICATE

                             SENIOR CERTIFICATE
                                      GRADE 12

                          INFORMATION TECHNOLOGY P1

                                   NOVEMBER 2022

                                MARKING GUIDELINES

MARKS: 150

                      These marking guidelines consist of 29 pages.

Copyright reserved                                                    Please turn over

### Page 2

Downloaded from hlayiso.com
Information Technology/P1                    2                           DBE/November 2022
                                  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 11) include the marking grid for each
    question.

   Annexures E, F, G and H (pages 12 to 29) 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 11) should be made for each learner and completed during the
    marking session.

Copyright reserved                                                          Please turn over

### Page 3

Downloaded from hlayiso.com
Information Technology/P1                     3                           DBE/November 2022
                                   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 – Properties]

             Set the panel colour to yellow 
                                                                               3
             Set the font style to italic 
             Change caption to ”I love programming!” 

1.2          Button - [1.2 – Leave month]

             Extract month name / month index from cmbQ1_2 
             Check IF (sMonth = 'June')  OR (sMonth = 'July') OR
                       (sMonth = 'August')  then
                 Display message 'Company closed, select another
                                  month.' 
                 Deselect month from cmbQ1_2 (Index -1) 
              Else 
                 Display message 'Your leave in ' + sMonth + ' has
                                                                               7
                                                    been granted.' 

             ALTERNATIVE IF conditions:
              IF iMonth IN [5,6,7] then
              IF (iMonth >= 5) AND (iMonth <= 7) then

             NOTES:
             If candidates adjust the index according to month numbers,
             the range must be from 6 to 8

Copyright reserved                                                          Please turn over

### Page 4

Downloaded from hlayiso.com
Information Technology/P1                      4                             DBE/November 2022
                                    NSC – Marking Guidelines

1.3          Button - [1.3 - Calculate]

             Extract A and B from edit boxes converted to real 

             C := sqrt(power(A,5) +             pi * sqr(B));

               Alternative to functions:
                 Sqrt or Power(Value, 0.5)
                 Power (do not accept hard-coding)
                                                                                  8
                 Pi or 22/7 or 3.14
                 Sqr or Power(B, 2) or (B * B)

             Display Truncated (Floor or Trunc)  value of C
               converted to String 

             NOTE:
             Penalise once only for a logical mistake

1.4          Button - [1.4 – Marks]

             Initialise counter and total 
             Input mark 
             Start conditional loop to test mark <> -1 
                   Increase counter variable 
                   Add mark to total mark 
                   Display the subject number  and mark 
                   Input next mark 
                                                                                 11
             Calculate average mark 
             Display average mark in output area converted to String
                      formatted to TWO decimal places 

             NOTES:
             If repeat until used the condition will be: until mark = -1
             If a single input is used inside the loop, an IF must be used
             inside the loop to prevent -1 to be accepted as a mark

Copyright reserved                                                             Please turn over

### Page 5

Downloaded from hlayiso.com
Information Technology/P1                       5                         DBE/November 2022
                                     NSC – Marking Guidelines

1.5          Button - [1.5 – Anagram]

             If length of two word strings are equal 
                  Loop  from 1 to length of word 1 string 
                    Use character at index 
                    Find position  of character in word 2 
                    Delete character at position  from word 2 

             If length of word 2 is null 
                  Display the message “The words form an anagram.” 
             Else
                  Display a message “The words do not form an
                                         anagram.” 

             Concepts:

             Loop through length of first word //2
             Extract character at index //1
             Find position of character in second word //2

             Mechanism to match words: //3
              Overwrite char at index word1 and char position in word2
               with space
                                                                              11
              Test and change flag if Not found (flag set before loop)
              Delete character from second word (if length tested same
               before the loop)

             Test anagram passed and display messages: //3
              IF words are equal / word 2 = '' // flag still true
                 ShowMessage IS anagram
                 ShowMessage NOT anagram

             Sorting as an alternative:

             Sort characters in first word:
             Double looping //2
             Comparing characters within the word //2
              Swopping characters //3

             Sorting characters in second word //1

             Test and display messages: //3
              IF words are equal
                 ShowMessage IS anagram
                 ShowMessage NOT anagram

                                                        TOTAL SECTION A:      40

Copyright reserved                                                          Please turn over

### Page 6

Downloaded from hlayiso.com
Information Technology/P1                    6                           DBE/November 2022
                                  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 – Bloemfontein clients]
             SELECT * 
             FROM tblClients 
                                                                             4
             WHERE City = "Bloemfontein" 
             ORDER BY ClientSurname 

2.1.2        Button [2.1.2 – First month]
             SELECT CollectionID, CollectionDate,
             NumberOfCans FROM tblCanCollection 
             WHERE Month  (CollectionDate) = 1                             3
             Alternative:
             Extracting month using String operators

2.1.3        Button [2.1.3 – Search]
             SELECT * FROM tblClients 
             WHERE ClientID LIKE  "'+ sLetter  +'%" 
                                                                             4
             Alternative:
              WHERE left(ClientID, 1) = quotedStr(sLetter)

2.1.4        Button [2.1.4 – Clients’ earnings]
            SELECT ClientName,
                   FORMAT(SUM  (NumberOfCans /76 * 8) ,
                                  "Currency") 
                                  AS  [Total Amount]                       8
            FROM tblCanCollection A, tblClients B 
            WHERE A.ClientID = B.ClientID 
            GROUP BY ClientName 

2.1.5        Button [2.1.5 – Update]
             UPDATE tblCanCollection 
             SET NumberOfCans = 250 , Paid = False                         4
             WHERE CollectionID = "C003" 

                                                             Subtotal:      23

Copyright reserved                                                         Please turn over

### Page 7

Downloaded from hlayiso.com
Information Technology/P1                      7                                DBE/November 2022
                                    NSC – Marking Guidelines

QUESTION 2: MARKING GRID (CONT.)

2.2          DATABASE MANIPULATION using Delphi code
2.2.1        Button [2.2.1 – Insert]

             Insert/append mode 
             Assign to correct field names 
             Using the correct values for each field 
             Post 

             tblClients.Insert;                                                    4
             tblClients['ClientID'] := 'CHA01';
             tblClients['ClientName'] := 'Charles';
             tblClients['ClientSurname'] := 'du Boit';
             tblClients['Address'] := '24 Van Wouw Street';
             tblClients['City'] := 'Cape Town';
             tblClients.Post;

2.2.2        Button [2.2.2 – Percentage]

             Display the name and surname of the client selected 
             Initialise variables 

             Go to the first record in the tblCanCollection table 
             Use a loop to step through the tblCanCollection table 
              Test year = year selected 
                 Increment company total of collections for the year 
                 if (ClientID in tblCanCollection = ClientID in tblClients) 
                   Increment client total of collections for the year             13
               Move to the next record in tblCanCollection 
             End loop (tblCanCollection)

             Calculate percentage of client collection as part of the total
             collection of company 
                   (rPercentage := rTotalClient / rTotalCompany * 100)
             Display total client collection value formatted to String 
             Display company collection value formatted to String 
             Display percentage of client collection formatted to two
             decimals with % symbol added to result 
                                                                  Subtotal:        17

                                                      TOTAL SECTION B:             40

Copyright reserved                                                                Please turn over

### Page 8

Downloaded from hlayiso.com
Information Technology/P1                      8                            DBE/November 2022
                                    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        3Constructor Create
             .
             1Constructor heading with three correct parameters and
             . correct data types for parameters 
             2                                                                  5
               Assign parameter values to the three attributes 
               (fPlantCode, fNumberOfPanels, fPowerPerPanel) 
               Set season attribute to "Summer" 

3.1.2        procedure incNumOfPanels

             Procedure heading  with integer parameter                        4
             fNumberOfPanels := fNumberOfPanels  + parameter 

3.1.3        3procedure setSeason
             .
             1procedure heading  with string type parameter                  3
             . fSeason = parameter 
             3
3.1.4          function calculateCapacity

             function heading with real data type 
             Test if fSeason = 'Summer' 
                hours = 10 
             else
                                                                                8
                if fSeason = 'Winter' 
                     hours = 6 
                else
                     hours = 8 
             Result = fNumberOfPanels * fPowerPerPanel * hours 

3.1.5        3function toString
             .
             1Function declared with string as return data type 
                                                                                3
             .All attributes part of string to return 
             5In correct format with text and with #13 

                                                   Subtotal: Object class      23

Copyright reserved                                                            Please turn over

### Page 9

Downloaded from hlayiso.com
Information Technology/P1                     9                              DBE/November 2022
                                   NSC – Marking Guidelines

QUESTION 3: MARKING GRID (CONT.)

                                                                               MAX.      LEARNER'S
QUESTION                           DESCRIPTION                                MARKS        MARKS
3.2.1        3Button [3.2.1 – Instantiate object]
             .
             2Extract the data from the components  converted to
             .correct data types 
             1objPlant := TSolarPowerPlant.create 
                                                                                 6
                                                 Use three arguments 
              (PlantCode,NumberOfPanels,PowerPerPanel)
                
              Display information in the rich edit using toString method 

3.2.2        Button [3.2.2 – Increase panels]

             Call incNumOfPanels method  using value from the spin
             edit as an argument 
                                                                                 4
             Display plant code using getPlantCode method  and
             number of panels using getNumOfPanels method, converted
             to string 

3.2.3        Button [3.2.3 – Update season]

             Call setSeason method  using the season selected from
                                                                                 3
             the combo box as an argument 
             Display information in the rich edit using toString method 

3.2.4        Button [3.2.4 – Calculate]

             Display a suitable description  including the season, using
                                                                                 4
             the getSeason method 
             Display the result of the calculateCapacity method ,
             converted to string with "kW" added as unit 
                                                    Subtotal Form class:         17

                                                     TOTAL SECTION C:            40

Copyright reserved                                                             Please turn over

### Page 10

Downloaded from hlayiso.com
Information Technology/P1                    10                         DBE/November 2022
                                   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]

             Outer loop I from 1 to length of array  Or 10
               Start output string with name[I]  and add tab (#9) to
               output string                                               5
               Inner loop J from 1 to length of arrVending[J]  OR 15
                   Join characters from arrVending to output string 
               Display output string on rich edit 

   4.2       Button [4.2 – Calculate]

             Initialise Max variable to 0 
             Outer loop I from 1 to length of arrNames (10) 
                Initialise amount paid to 0 
                Inner loop J from 1 to length of arrVending[I] (15) 
                   Test if item recycled is a bottle 
                        Increment amount paid with 2.15 
                   Test if item is a can
                        Increment amount paid with 0.75 
                 End inner loop

                 Display name and amount paid, converted to currency
             

             Alternative 1:

               Test if Amount >= Max 
                  if Amount > Max                                         14
                     Set Max to amount and clear output 
                  Add name and amount to Max output string 
             End outer loop

              Display Max output string in redQ4 

             Alternative 2 (using parallel array):

               Test if Amount > Max //1
                  Set Max to amount //1
               Save learner amount in parallel array //1
             End outer loop

             Loop from 1 to 10 //1
                If Amount = Max //1
                   Display name and amount //1

Copyright reserved                                                        Please turn over

### Page 11

Downloaded from hlayiso.com
Information Technology/P1                   11                        DBE/November 2022
                                  NSC – Marking Guidelines

   4.3       Button [4.3 – Add item]

             Test if name OR item are NOT selected 
                Display message if name or item not selected 

             Extract item from component 
             Extract OR determine row(index) of name 

             PLACING ITEM:
             Loop index from 1 to 15 
               Test if arrVending empty at index                         11
                   Place item in arrVending 
                    Flag / Break 

             Display updated array 

             NO SPACE MESSAGE:
             Check flag OR use another mechanism to determine
             availability of space 
                Display message for no space available

                                                  TOTAL SECTION D:        30
                                                     GRAND TOTAL:         150

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.
                      40           40                40          30                  150
  MARKS

LEARNER'S
  MARKS

Copyright reserved                                                        Please turn over

### Page 12

Downloaded from hlayiso.com
Information Technology/P1              12                 DBE/November 2022
                             NSC – Marking Guidelines

ANNEXURE E: SOLUTION FOR QUESTION 1

// =================================================================
// Question 1.1               3 marks
// =================================================================
procedure TfrmQuestion1.btnQ1_1Click(Sender: TObject);
begin
  // Question 1.1

   pnlQ1_1.Color := clYellow;
   pnlQ1_1.Font.Style := [fsItalic];
   pnlQ1_1.Caption := 'I love programming!';
end;
//==================================================================
// Question 1.2                7 marks
// =================================================================
procedure TfrmQuestion1.btnQ1_2Click(Sender: TObject);
begin
  // Question 1.2
  if (cmbQ1_2.ItemIndex > 4) AND (cmbQ1_2.ItemIndex < 8) then
     begin
       lblQ1_2.Caption :='Company closed, select another
                          month.';
       cmbQ1_2.ItemIndex := -1;
     end
  else
     lblQ1_2.Caption :='Your leave in ' + cmbQ1_2.text +
                                  ' has been granted.';
end;

// ================================================================
// Question 1.3                8 marks
// =================================================================
procedure TfrmQuestion1.btnQ1_3Click(Sender: TObject);
var
  rA,rB,rC : Real;
begin
  // Question 1.3
  rA := StrToFloat(edtQ1_3_1.Text);
  rB := StrToFloat(edtQ1_3_2.Text);
  rC := Sqrt(Power(rA,5)+ pi * Sqr(rB));

  edtQ1_3_3.Text := IntToStr(Trunc(rC));
end;

// =================================================================
// Question 1.4             11 marks
// =================================================================
procedure TfrmQuestion1.btnQ1_4Click(Sender: TObject);
var
    iMark, i, iTotal : Integer;
    rAverage : Real;
begin
  // Provided code
  redQ1_4.Clear;

Copyright reserved                                          Please turn over

### Page 13

Downloaded from hlayiso.com
Information Technology/P1              13                  DBE/November 2022
                             NSC – Marking Guidelines

  // Question 1.4
  iMark := StrToInt(InputBox('Learner marks','Enter mark for
                               subject : 1',''));
  i := 0;
  iTotal := 0;
  while iMark > -1 do
     begin
       Inc(i);
       iTotal := iTotal + iMark;
       redQ1_4.Lines.Add('Subject ' + IntToStr(i) + ' : ' +
                          IntToStr(iMark));
       iMark := StrToInt(InputBox('Learner marks','Enter mark for
                         subject : ' + IntToStr(i+1), ''));
     end;
  rAverage:= iTotal / i;
  redQ1_4.Lines.Add('Average mark:' +
                       FloatToStrF(rAverage,ffFixed,5,2));
end;

// =================================================================
// Question 1.5            11 marks
// =================================================================
procedure TfrmQuestion1.btnQ1_5Click(Sender: TObject);
var
  sWord1,sWord2 : String;
  I : integer;
begin
  //Provided code
  redQ1_5.Clear;
  sWord1 := Lowercase(edtQ1_5_1.Text);
  sWord2 := Lowercase(edtQ1_5_2.Text);

  // Question 1.5

  if length(sWord1) = length(sWord2) then
  begin
     for i := 1 to length(sWord1) do
       delete(sWord2,(pos(sWord1[i],sWord2)),1);
     if sWord2 = '' then
       memQ1_5.Lines.add( 'The words form an anagram.')
     else
       memQ1_5.Lines.add('The words do not form an anagram.');
  end
  else
     memQ1_5.Lines.add('The words do not form an anagram.');
end;

end.

Copyright reserved                                           Please turn over

### Page 14

Downloaded from hlayiso.com
Information Technology/P1              14                  DBE/November 2022
                             NSC – Marking Guidelines

ANNEXURE F: SOLUTION FOR QUESTION 2
unit Question2_U;

interface
uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics,
  Controls, Forms, Dialogs, DB, ExtCtrls, StdCtrls,
  ComCtrls, Grids, DBGrids, Buttons, ADODB, Math, DateUtils,
  ConnectDB_U;

type
  TfrmQuestion2 = class(TForm)
     pgcDBAdmin: TPageControl;
     tabsQ2SQL: TTabSheet;
     btnQ2_1_5: TBitBtn;
     grpresults: TGroupBox;
     btnQ2_1_1: TBitBtn;
     btnQ2_1_2: TBitBtn;
     b: TTabSheet;
     grpQ2_2_1: TGroupBox;
     redQ2_2_2: TRichEdit;
     btnQ2_2_2: TButton;
     dbgClients: TDBGrid;
     dbgCollections: TDBGrid;
     grpQ2_2_2: TGroupBox;
     btnQ2_2_1: TButton;
     btnQ2_1_4: TBitBtn;
     pnlBtns: TPanel;
     bmbClose: TBitBtn;
     bmbRestoreDB: TBitBtn;
     dbgrdSQL: TDBGrid;
     btnQ2_1_3: TButton;
     rgpQ2_2_2: TRadioGroup;
     cmbQ2_2_2: TComboBox;
     lblQ2_2_2: TLabel;
     procedure btnQ2_1_1Click(Sender: TObject);
     procedure btnQ2_1_2Click(Sender: TObject);
     procedure btnQ2_1_4Click(Sender: TObject);
     procedure btnQ2_1_3Click(Sender: TObject);
     procedure btnQ2_1_5Click(Sender: TObject);
     procedure btnQ2_2_2Click(Sender: TObject);
     procedure btnQ2_2_1Click(Sender: TObject);
     procedure FormShow(Sender: TObject);
     procedure FormClose(Sender: TObject; var Action: TCloseAction);
     procedure bmbRestoreDBClick(Sender: TObject);
     procedure FormCreate(Sender: TObject);
  private
     { Private declarations }
  public
     { Public declarations }
  end;

var
  frmQuestion2: TfrmQuestion2;
  dbCONN : TConnection;

Copyright reserved                                             Please turn over

### Page 15

Downloaded from hlayiso.com
Information Technology/P1              15                  DBE/November 2022
                             NSC – Marking Guidelines

// --- Global variables provided ---
  tblClients, tblCanCollection : TADOTable;

implementation

{$R *.dfm}

procedure TfrmQuestion2.bmbRestoreDBClick(Sender: TObject);
begin
// Restores the Database
  dbCONN.RestoreDatabase;
  redQ2_2_2.Clear;
  dbCONN.SetupGrids(dbgClients, dbgCollections, dbgrdSQL);
end;

//==================================================================
// Question 2.1.1         4 marks
//==================================================================

procedure TfrmQuestion2.btnQ2_1_1Click(Sender: TObject);
var
  sSQL1: String;
begin
// Question 2.1.1

  sSQL1 := 'SELECT * FROM tblClients ' +
           'WHERE City = "Bloemfontein"' +
           'ORDER BY ClientSurname';

// Provided code - do not change
  dbCONN.runSQL(sSQL1);
end;

//==================================================================
//Question 2.1.2         3 marks
//==================================================================

procedure TfrmQuestion2.btnQ2_1_2Click(Sender: TObject);
var
  sSQL2: String;
begin
// Question 2.1.2

  sSQL2 := 'SELECT CollectionID, CollectionDate, NumberOfCans ' +
           'FROM tblCanCollection ' +
           'WHERE Month(CollectionDate) = 1';

// Provided code - do not change
  dbCONN.runSQL(sSQL2);
end;

Copyright reserved                                            Please turn over

### Page 16

Downloaded from hlayiso.com
Information Technology/P1              16                  DBE/November 2022
                             NSC – Marking Guidelines

//==================================================================
// Question 2.1.3         4 marks
//==================================================================

procedure TfrmQuestion2.btnQ2_1_3Click(Sender: TObject);
var
  sSQL3, sLetter : String;
begin
// Question 2.1.3
// Provided code
  sLetter := InputBox('','Enter first letter of ClientID','');

     sSQL3 := 'SELECT * FROM tblClients ' + 
              'WHERE ClientID LIKE  "'+ sLetter  +'%"'; 

     // Alternative:
       // WHERE left(clientID, 1) = quotedStr(sLetter)

// Provided code - do not change
  dbCONN.runSQL(sSQL3);
end;

//==================================================================
// Question 2.1.4         8 marks
//==================================================================

procedure TfrmQuestion2.btnQ2_1_4Click(Sender: TObject);
var
  sSQL4: String;
begin
// Question 2.1.4

  sSql4 := 'SELECT ClientName, ' +
           'FORMAT(SUM(NumberOfCans / 76 * 8),"Currency") ' +
           'AS [Total Amount] ' +
           'FROM tblCanCollection A, tblClients B ' +
           'WHERE A.ClientID = B.ClientID ' +
           'GROUP BY ClientName';

// Provided code - do not change
  dbCONN.runSQL(sSQL4);
end;

//==================================================================
// Question 2.1.5         4 marks
//==================================================================

procedure TfrmQuestion2.btnQ2_1_5Click(Sender: TObject);
var
  sSql5 : String;
  bChange : boolean;
begin
// Question 2.1.5

Copyright reserved                                            Please turn over

### Page 17

Downloaded from hlayiso.com
Information Technology/P1              17                  DBE/November 2022
                             NSC – Marking Guidelines

  sSql5 := 'UPDATE tblCanCollection ' +
           'SET NumberOfCans = 250, Paid = False ' +
           'WHERE CollectionID = "C003"';

// Provided code - do not change
dbCONN.ExecuteSQL(sSQL5, bChange);

if bChange then
 begin
   MessageDlg('Database has been updated.', mtInformation, [mbOK], 0);
 end;
end;

//==================================================================
// Question 2.2.1         4 marks
//==================================================================

procedure TfrmQuestion2.btnQ2_2_1Click(Sender: TObject);
begin
// Question 2.2.1

tblClients.Insert;
tblClients['ClientID'] := 'CHA01';
tblClients['ClientName'] := 'Charles';
tblClients['ClientSurname'] := 'du Boit';
tblClients['Address'] := '24 Van Wouw Street';
tblClients['City'] := 'Cape Town';
tblClients.Post;
end;

//==================================================================
// Question 2.2.2         13 marks
//==================================================================

procedure TfrmQuestion2.btnQ2_2_2Click(Sender: TObject);
var
  iCompanyTotal, iClientTotal : Integer;
  sYear : String;
  rPercentage : Real;
begin
// Provided code - do not change
  redQ2_2_2.Clear;
  sYear := rgpQ2_2_2.Items[rgpQ2_2_2.ItemIndex];
// ============================================
// Question 2.2.2

  redQ2_2_2.Lines.Add(tblClients['ClientName']+'
                   '+tblClients['ClientSurname']+#13);
  iCompanyTotal := 0;
  iClientTotal := 0;
  tblCanCollection.First;
  while NOT (tblCanCollection.Eof) do
    begin
      if sYear = IntToStr(YearOf(tblCanCollection['CollectionDate'])) then
        begin

Copyright reserved                                           Please turn over

### Page 18

Downloaded from hlayiso.com
Information Technology/P1                18                   DBE/November 2022
                               NSC – Marking Guidelines

              iCompanyTotal := iCompanyTotal +
                               tblCanCollection['NumberOfCans'];

        if (tblCanCollection['ClientID'] = tblClients['ClientID']) then
             iClientTotal := iClientTotal +
                              tblCanCollection['NumberOfCans'];
         end;
       tblCanCollection.Next;
     end;
  rPercentage := iClientTotal / iCompanyTotal * 100;
  redQ2_2_2.Lines.Add('Client collection for ' + sYear + ': ' + #9 +
                        IntToStr(iClientTotal));
  redQ2_2_2.Lines.Add('Company collection for ' + sYear + ': ' + #9 +
                        IntToStr(iCompanyTotal));
  redQ2_2_2.Lines.Add('Percentage collected by client: ' + #9 +
                 FloatToStrF(rPercentage, ffFixed, 3, 2) + '%');
end;

procedure TfrmQuestion2.FormCreate(Sender: TObject);
begin
  redQ2_2_2.Paragraph.TabCount := 2;
  redQ2_2_2.Paragraph.Tab[0] := 180;
  redQ2_2_2.Paragraph.Tab[1] := 150;
end;

procedure TfrmQuestion2.FormShow(Sender: TObject);
begin
  // Sets up the connection to database and opens the tables.
  dbCONN := TConnection.Create;
  dbCONN.dbConnect;
  tblClients := dbCONN.tblOne;
  tblCanCollection := dbCONN.tblMany;
  dbCONN.setupGrids(dbgClients, dbgCollections, dbgrdSQL);
  pgcDBAdmin.ActivePageIndex := 0;
end;

end.

Copyright reserved                                                 Please turn over

### Page 19

Downloaded from hlayiso.com
Information Technology/P1              19                   DBE/November 2022
                             NSC – Marking Guidelines

ANNEXURE F: SOLUTION FOR QUESTION 3

Object class:

unit SolarPowerPlant_U;

interface

type
  TSolarPowerPlant = class(TObject)
  private
  var
     fPlantCode: String;
     fNumberOfPanels: Integer;
     fPowerPerPanel: Real;
     fSeason: String;
  public
     // Provide code
     function getPlantCode : String;
     function getNumOfPanels : Integer;
     function getSeason : String;
     // Code here

    constructor create(sPlantCode: String; iNumOfPanels: Integer;
                       rPowerPerPanel:Real);
    procedure incNumOfPanels(iNumber : Integer);
    procedure setSeason(sNewSeason : String);
    function calculateCapacity : Real;
    function toString: String;
  end;

implementation

{ TStorage }

uses
  SysUtils, Math;

{ TSolarPowerPlant }

// ======================================================
// Question 3.1.1          5 marks
// ======================================================

constructor TSolarPowerPlant.create(sPlantCode: String;
  iNumOfPanels: Integer; rPowerPerPanel: Real);
begin
  fPlantCode := sPlantCode;
  fNumberOfPanels := iNumOfPanels;
  fPowerPerPanel := rPowerPerPanel;
  fSeason := 'Summer';
end;

Copyright reserved                                            Please turn over

### Page 20

Downloaded from hlayiso.com
Information Technology/P1              20                   DBE/November 2022
                             NSC – Marking Guidelines

// ======================================================
// Question 3.1.2           4 marks
// ======================================================

procedure TSolarPowerPlant.incNumOfPanels(iNumber: integer);
begin
  fNumberOfPanels := fNumberOfPanels + iNumber;
end;

// ======================================================
// Question 3.1.3           3 marks
// ======================================================

procedure TSolarPowerPlant.setSeason(sNewSeason: String);
begin
  fSeason := sNewSeason;
end;

// ======================================================
// Question 3.1.4           8 marks
// ======================================================

function TSolarPowerPlant.calculateCapacity: Real;
var
  iHours : Integer;
begin

  if fSeason = 'Summer' then
  begin
    iHours := 10;
  end
  else if fSeason = 'Winter' then
  begin
    iHours := 6;
  end
  else
  begin
    iHours := 8;
  end;

  result := (fNumberOfPanels * fPowerPerPanel) * iHours;

end;

Copyright reserved                                             Please turn over

### Page 21

Downloaded from hlayiso.com
Information Technology/P1              21                   DBE/November 2022
                             NSC – Marking Guidelines

// ======================================================
// Question 3.1.5           3 marks
// ======================================================

function TSolarPowerPlant.toString: String;
var
  sString : String;
begin
  sString := 'Plant code: ' + fPlantCode + #13;
  sString := sString + 'Number of panels: ' + intToStr(fNumberOfPanels) +
#13;
  sString := sString + 'Power per panel: ' + floatToStr(fPowerPerPanel) +
#13;
  sString := sString + 'Season: ' + fSeason + #13;
  result := sString;
end;
// ======================================================
// Provided code
// ======================================================

function TSolarPowerPlant.getPlantCode: String;
begin
  result := fPlantCode;
end;

function TSolarPowerPlant.getNumOfPanels: Integer;
begin
  result := fNumberOfPanels;
end;

function TSolarPowerPlant.getSeason: String;
begin
  result := fSeason;
end;

end.

Copyright reserved                                            Please turn over

### Page 22

Downloaded from hlayiso.com
Information Technology/P1              22                 DBE/November 2022
                             NSC – Marking Guidelines

Main form unit:

unit Question3_U;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls,
Forms, Dialogs, StdCtrls, CheckLst, ExtCtrls, Buttons, Spin, ComCtrls,
jpeg;

type
  TfrmQuestion3 = class(TForm)
     gbxQ3_2_1: TGroupBox;
     gbxQ3_2_3: TGroupBox;
     btnQ3_2_1: TButton;
     btnReset: TButton;
     gbxQ3_2_2: TGroupBox;
     btnQ3_2_2: TButton;
     edtQ3_2_1_Power: TEdit;
     Label2: TLabel;
     Label3: TLabel;
     sedQ3_2_2: TSpinEdit;
     Panel1: TPanel;
     Panel2: TPanel;
     btnQ3_2_3: TButton;
     Image1: TImage;
     Label6: TLabel;
     edtQ3_2_1_Code: TEdit;
     sedQ3_2_1: TSpinEdit;
     Label4: TLabel;
     cmbQ3_2_3: TComboBox;
     Label5: TLabel;
     gbxQ3_2_4: TGroupBox;
     btnQ3_2_4: TButton;
     redQ3: TRichEdit;
     procedure btnQ3_2_1Click(Sender: TObject);
     procedure btnResetClick(Sender: TObject);
     procedure btnQ3_2_2Click(Sender: TObject);
     procedure btnQ3_2_3Click(Sender: TObject);
     procedure btnQ3_2_4Click(Sender: TObject);
  private
  public
  end;
var
  frmQuestion3: TfrmQuestion3;

implementation
{$R *.dfm}

uses
  SolarPowerPlant_U;

var
  objPlant: TSolarPowerPlant;

Copyright reserved                                          Please turn over

### Page 23

Downloaded from hlayiso.com
Information Technology/P1              23                    DBE/November 2022
                             NSC – Marking Guidelines

// ======================================================
// Question 3.2.1           6 marks
// ======================================================

procedure TfrmQuestion3.btnQ3_2_1Click(Sender: TObject);
begin
  // Provided code
  redQ3.Clear;
  // Question 3.2.1

  objPlant:= tSolarPowerPlant.create(edtQ3_2_1_Code.Text,
     sedQ3_2_1.Value, strToFloat(edtQ3_2_1_Power.Text));
  redQ3.Lines.Add(objPlant.toString);
end;

// ======================================================
// Question 3.2.2           4 marks
// ======================================================

procedure TfrmQuestion3.btnQ3_2_2Click(Sender: TObject);
var
  rUpdatedPower: Real;
begin
  // Provided code
  redQ3.Clear;
  // Question 3.2.2

  objPlant.incNumOfPanels(sedQ3_2_2.Value);
  redQ3.Lines.Add('Plant code: ' + objPlant.getPlantCode);
  redQ3.Lines.Add('Number of panels: ' +
                IntToStr(objPlant.getNumOfPanels));

end;
// ======================================================
// Question 3.2.3           3 marks
// ======================================================

procedure TfrmQuestion3.btnQ3_2_3Click(Sender: TObject);
begin
  // Provided code
  redQ3.Clear;
  // Question 3.2.3

  objPlant.setSeason(cmbQ3_2_3.Text);
  redQ3.Lines.Add(objPlant.toString)

end;

Copyright reserved                                             Please turn over

### Page 24

Downloaded from hlayiso.com
Information Technology/P1              24                   DBE/November 2022
                             NSC – Marking Guidelines

// ======================================================
// Question 3.2.4           4 marks
// ======================================================

procedure TfrmQuestion3.btnQ3_2_4Click(Sender: TObject);
begin
  // Provided code
  redQ3.Clear;
  // Question 3.2.4

  redQ3.Lines.Add('The maximum generation capacity per day in ' +
                objPlant.getSeason + ': ');
  redQ3.Lines.Add(floatToStr(objPlant.calculateCapacity) + ' kW');

end;

// ======================================================
// Provided code
// ======================================================

procedure TfrmQuestion3.btnResetClick(Sender: TObject);
begin
  objPlant.Free;
  edtQ3_2_1_Power.Clear;
  edtQ3_2_1_Code.Clear;
  sedQ3_2_1.Value := 15;
  sedQ3_2_2.Value := 50;
  redQ3.Clear;
end;

end.

Copyright reserved                                            Please turn over

### Page 25

Downloaded from hlayiso.com
Information Technology/P1               25                DBE/November 2022
                              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, jpeg;

type
  TfrmQuestion4 = class(TForm)
     Panel1: TPanel;
     Panel2: TPanel;
     btnQ4_3: TButton;
     redQ4: TRichEdit;
     btnQ4_1: TButton;
     GroupBox1: TGroupBox;
     rgpQ4: TRadioGroup;
     btnQ4_2: TButton;
     Image1: TImage;
     lstQ4: TListBox;
     GroupBox2: TGroupBox;
     GroupBox3: TGroupBox;
     procedure btnQ4_3Click(Sender: TObject);
     procedure btnQ4_1Click(Sender: TObject);
     procedure btnQ4_2Click(Sender: TObject);
     procedure FormShow(Sender: TObject);
  private
     { Private declarations }

  public
    { Public declarations }
  end;

var
  frmQuestion4: TfrmQuestion4;

  arrNames: array [1 .. 10] of String = (
    'Ruth',
    'Nicole',
    'Loyiso',
    'Chris',
    'William',
    'Thabo',
    'Vusi',
    'Peter',
    'Jenny',
    'Tommy'
  );

Copyright reserved                                          Please turn over

### Page 26

Downloaded from hlayiso.com
Information Technology/P1              26                  DBE/November 2022
                             NSC – Marking Guidelines

  arrVending: array [1 .. 10, 1 .. 15] of String =
 (('C', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
     ('B', 'B', 'B', 'C', 'C', 'C', 'B', 'B', 'B', 'C', 'C', 'C', 'C', 'C',
''),
     ('', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
     ('C', 'C', '', '', '', '', '', '', '', '', '', '', '', '', ''),
     ('B', 'B', 'C', 'C', 'B', 'B', 'C', 'C', 'C', 'C', 'B', 'C', 'C', 'B',
''),
     ('C', 'C', 'B', '', '', '', '', '', '', '', '', '', '', '', ''),
     ('C', 'B', '', '', '', '', '', '', '', '', '', '', '', '', ''),
     ('B', 'B', '', '', '', '', '', '', '', '', '', '', '', '', ''),
     ('C', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
     ('B', 'C', '', '', '', '', '', '', '', '', '', '', '', '', ''));
implementation

{$R *.dfm}

// ========================================================
// Question 4.1             5 marks
// ========================================================

procedure TfrmQuestion4.btnQ4_1Click(Sender: TObject);
var
  I, J: Integer;
  sLine: String;
begin
  // Provided code
  redQ4.Clear;
  redQ4.Lines.Add('----------------------------');
  redQ4.Lines.Add('Names'+#9+'Items recycled');
  redQ4.Lines.Add('----------------------------');

  // Question 4.1

  for I := 1 to length(arrNames) do
  begin
    sLine := arrNames[I] + #9;
    for J := 1 to length(arrVending[J]) do
    begin
      sLine := sLine + arrVending[I, J];
    end;
    redQ4.Lines.Add(sLine);
  end;

end;

// ========================================================
// Question 4.2              14 marks
// ========================================================

procedure TfrmQuestion4.btnQ4_2Click(Sender: TObject);
var
  I, J: Integer;
  rAmount, rMax: Real;
  iMax: Integer;
  arrTotal: Array [1 .. 10] of Real;
  sMaxs: String;
Copyright reserved                                            Please turn over

### Page 27

Downloaded from hlayiso.com
Information Technology/P1               27                 DBE/November 2022
                              NSC – Marking Guidelines

begin
  // Provided code
  redQ4.Clear;
  redQ4.Lines.Add('----------------------------');
  redQ4.Lines.Add('Names'+#9+'Total amount paid');
  redQ4.Lines.Add('----------------------------');

   // Question 4.2
   // Alternative
  {rMax := -1;
  for I := 1 to length(arrNames) do
  begin
    rAmount := 0;
    for J := 1 to length(arrVending[I]) do
      if arrVending[I, J] = 'B' then
       rAmount := rAmount + 2.15
       else   if arrVending[I, J] = 'C' then
       rAmount := rAmount + 0.75;

     if rAmount > rMax then
       rMax := rAmount;

   arrTotal[I] := rAmount;
   redQ4.Lines.Add(arrNames[I] + #9 + format('%8.2m', [rAmount]));
  end;//I

  //Provided code
  redQ4.Lines.Add('----------------------------');
  redQ4.Lines.Add('Highest payout(s):');
  redQ4.Lines.Add('----------------------------');

  //Code here

  for I := 1 to length(arrTotal) do
  begin
  redQ4.SelAttributes.Style:= [fsBold];
  redQ4.SelAttributes.Color:= clRed;
    if arrTotal[I] = rMax then
    begin
      redQ4.Lines.Add(arrNames[I] + #9 + format('%8.2m', [rMax]));
    end;

  end;}

rMax := -1;
for I := 1 to length(arrNames) do
  begin
    rAmount := 0;
    for J := 1 to length(arrVending[I]) do
      if arrVending[I, J] = 'B' then
         rAmount := rAmount + 2.15
        else if arrVending[I, J] = 'C' then
                    rAmount := rAmount + 0.75;

     redQ4.Lines.Add(arrNames[I] + #9 + format('%8.2m', [rAmount]));

Copyright reserved                                           Please turn over

### Page 28

Downloaded from hlayiso.com
Information Technology/P1              28                 DBE/November 2022
                             NSC – Marking Guidelines

    if rAmount >= rMax then
      begin
        if rAmount > rMax then
          begin
            rMax := rAmount;
            sMaxs := '';
          end;
        sMaxs := sMaxs + arrNames[I] + #9 + format('%8.2m',
                                                 [rAmount]) + #13;
      end;
  end;//I

  //Provided code
  redQ4.Lines.Add('----------------------------');
  redQ4.Lines.Add('Highest payout(s):');
  redQ4.Lines.Add('----------------------------');
  redQ4.Lines.Add(sMaxs);
end;

// Provided code
procedure TfrmQuestion4.FormShow(Sender: TObject);
begin
  redQ4.Paragraph.TabCount := 1;
  redQ4.Paragraph.Tab[0] := 70;
end;

// ========================================================
// Question 4.3              11 marks
// ========================================================

procedure TfrmQuestion4.btnQ4_3Click(Sender: TObject);
var
  iRow, iCol: Integer;
  sItem: String;
  bAdded: Boolean;
begin
  // Question 4.3
  // Alternative
 {bAdded := False;
  if lstQ4.ItemIndex = -1 then
  begin
     showMessage('Please select a name');
     exit;
  end
  else
  begin
       case rgpQ4.ItemIndex of
     -1:
       showMessage('Please select an item');
     else
      sItem := rgpQ4.Items[rgpQ4.ItemIndex][1];
    end;

Copyright reserved                                            Please turn over

### Page 29

Downloaded from hlayiso.com
Information Technology/P1              29                    DBE/November 2022
                             NSC – Marking Guidelines

       iRow := lstQ4.ItemIndex+1;
       iCol:=0;
       while (bAdded=false) AND ( iCol<15) do
       begin
        Inc(iCol);
            if arrVending[iRow,iCol] ='' then
            begin
              arrVending[iRow,iCol] := sItem;
              bAdded := True;
            end;
       end;
       if bAdded = false then
       begin
         showMessage('Machine is full.');
       end;

  end; }

  bAdded := False;
  if (lstQ4.ItemIndex > -1) AND (rgpQ4.ItemIndex > -1) then
  begin
    sItem := rgpQ4.Items[rgpQ4.ItemIndex][1];
    iRow := lstQ4.ItemIndex+1;
    iCol:=0;
    while (bAdded=false) AND ( iCol<15) do
     begin
       Inc(iCol);
       if arrVending[iRow,iCol] = '' then
          begin
            arrVending[iRow,iCol] := sItem;
            bAdded := True;
          end;
     btnQ4_1.Click;
     end;

       if bAdded = false then
       begin
         showMessage('Machine is full.');
       end;

  end
  else
    ShowMessage('Please select both a name and an item.');

  //Provided code
  rgpQ4.ItemIndex := -1;
  lstQ4.ItemIndex := -1;

end;

end.

Copyright reserved

## Related documents

- [Information Technology P1 Nov 2022 Eng](https://www.hlayiso.com/library/information-technology-p1-nov-2022-eng/d4215e1a-a2c0-4200-94cf-50fa1b11f578) — Information Technology · QP · 2022 · Eng
- [IT P1 GR12 MEMO SEPT 2022 Afrikaans](https://www.hlayiso.com/library/it-p1-gr12-memo-sept-2022-afrikaans/43cd69be-f0ac-46f4-9d4c-b2503fe09125) — Information Technology · Memo · 2022 · Afr
- [IT P1 GR12 MEMO SEPT 2022 English](https://www.hlayiso.com/library/it-p1-gr12-memo-sept-2022-english/6e7cbe6a-69aa-4c7d-bcd4-dcfeaf4c8272) — Information Technology · Memo · 2022 · Eng
- [IT P1 Nov 2020 Afr REWRITE (NO MEMO)](https://www.hlayiso.com/library/it-p1-nov-2020-afr-rewrite-no-memo/50e776f8-b245-4554-9243-5cf350cf10d2) — Information Technology · Memo · 2020 · Afr
- [IT P1 Nov 2020 Memo Afr](https://www.hlayiso.com/library/it-p1-nov-2020-memo-afr/85279e2b-2e1a-44a8-a2ac-7db9df151ff7) — Information Technology · Memo · 2020 · Afr
- [Information Technology P1 Nov 2017 Memo Eng](https://www.hlayiso.com/library/information-technology-p1-nov-2017-memo-eng/5a6ed3b8-fff3-4502-bac4-5e1e988da4fc) — Information Technology · Memo · 2017 · Eng

## More from Grade 12 Information Technology

- [IT-P2-GR12 QP-Afr-SEP-2025 watermark](https://www.hlayiso.com/library/it-p2-gr12-qp-afr-sep-2025-watermark/569cc299-ae7c-4635-9514-cf03f9242ebc) — QP · 2025 · Afr
- [IT P2 QP GR12 SEPT 2024 AFR](https://www.hlayiso.com/library/it-p2-qp-gr12-sept-2024-afr/9016098b-e233-49f4-b1dc-f0838363c6af) — QP · 2024 · Afr
- [IT P2 QP GR12 SEPT 2024 English](https://www.hlayiso.com/library/it-p2-qp-gr12-sept-2024-english/83309154-2856-47f1-82cc-cc04c8ab38b1) — QP · 2024 · Eng
- [Information Technology P1 Nov 2024 Afr](https://www.hlayiso.com/library/information-technology-p1-nov-2024-afr/f4b19c44-77ce-482a-9f85-438813c25f87) — QP · 2024 · Afr
- [Information Technology P2 Nov 2024 Eng](https://www.hlayiso.com/library/information-technology-p2-nov-2024-eng/3afa20d1-1c0f-4969-8a56-d690e9b24d70) — QP · 2024 · Eng
- [Information Technology P1 May-June 2023 MG Eng](https://www.hlayiso.com/library/information-technology-p1-may-june-2023-mg-eng/f868554b-8f4f-4370-aa4e-cfa745fc806d) — Memo · 2023 · Eng

## Collection

- [Grade 12 past papers](https://www.hlayiso.com/grade-12/past-papers)

---

Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.
