# 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.

- Page: https://www.hlayiso.com/library/information-technology-p1-nov-2018-final-memo-eng/3db424e2-6688-4d45-bf0d-382677192fb2
- Updated: 2026-09-27
- Subject: Information Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2018
- Exam period: NSC November Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 23

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 2018 Memo](https://www.hlayiso.com/library/information-technology-p1-nov-2018-final-memo-eng/3db424e2-6688-4d45-bf0d-382677192fb2)

## About this document

Information Technology · Grade 12 · NSC November Exam · 2018. Memorandum, 23 pages. 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

                                      GRADE12

                          INFORMATION TECHNOLOGY P1

                                   NOVEMBER 2018

                               MARKING GUIDELINES

MARKS: 150

                      These marking guidelines consist of 23 pages.

Copyright reserved                                                    Please turn over

### Page 2

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

### Page 3

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

### Page 4

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

### Page 5

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

### Page 6

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

### Page 7

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

### Page 8

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

### Page 9

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

### Page 10

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

### Page 11

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

### Page 12

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

### Page 13

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

### Page 14

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

### Page 15

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

### Page 16

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

### Page 17

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

### Page 18

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

### Page 19

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

### Page 20

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

### Page 21

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

### Page 22

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

### Page 23

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

## Related documents

- [Information Technology P2 Nov 2018 FINAL Memo Afr](https://www.hlayiso.com/library/information-technology-p2-nov-2018-final-memo-afr/e606bf7e-39ef-42a7-908b-0193e164cc67) — Information Technology · Memo · 2018 · Afr
- [IT P1 GR12 MEMO SEPT2018 Afrikaans](https://www.hlayiso.com/library/it-p1-gr12-memo-sept2018-afrikaans/55409ee4-7e45-46a3-88eb-9dbd26e43037) — Information Technology · Memo · 2018 · Afr
- [Information Technology P1 Exemplar GR 12 2018 Memo Eng](https://www.hlayiso.com/library/information-technology-p1-exemplar-gr-12-2018-memo-eng/18dfa6ac-b146-4500-8dba-5b427b84c102) — Information Technology · Memo · 2018 · Eng
- [Information Technology P1 May June 2018 Memo Eng](https://www.hlayiso.com/library/information-technology-p1-may-june-2018-memo-eng/b14c831b-ce05-4e30-81c6-0fca0f7f50f7) — Information Technology · Memo · 2018 · Eng
- [Information Technology P1 Feb March 2018 Memo Afr](https://www.hlayiso.com/library/information-technology-p1-feb-march-2018-memo-afr/4ac823a7-4f50-452b-b77c-ffecca7e0203) — Information Technology · Memo · 2018 · Afr
- [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

## 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.
