# Information Technology Grade 12 P1 November 2024 NSC QP

> Grade 12 Information Technology Paper 1 question paper from the November 2024 NSC (English), 30 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/information-technology-p1-nov-2024-eng/cadb9183-d069-48df-aaa3-854d239b8f51
- Updated: 2026-09-27
- Subject: Information Technology
- Grade: Grade 12
- Document type: Question paper
- Year: 2024
- Exam period: November 2024 NSC
- Paper: 1
- Curriculum: CAPS
- Pages: 30

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 November 2024 NSC QP](https://www.hlayiso.com/library/information-technology-p1-nov-2024-eng/cadb9183-d069-48df-aaa3-854d239b8f51)

## About this document

Information Technology · Grade 12 · November 2024 NSC · 2024. Question paper, 30 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

Confidential

                                   NATIONAL
                              SENIOR CERTIFICATE

                                      GRADE 12

                         INFORMATION TECHNOLOGY P1

                                   NOVEMBER 2024

MARKS: 150

TIME: 3 hours

                 This question paper consists of 25 pages, 2 data pages,
                 2 pages for planning and a separate information sheet.

Copyright reserved                                                         Please turn over

### Page 2

Information Technology/P1                    2                          DBE/November 2024
                                      NSC Confidential

INSTRUCTIONS AND INFORMATION

1.      This question paper is divided into FOUR sections. Candidates must answer
        ALL the questions in ALL FOUR sections.

2.      Two blank pages have been provided at the end of the question paper, which
        may be used for planning purposes.

3.      The duration of this examination is three hours. Because of the nature of this
        examination, it is important to note that you will not be permitted to leave the
        examination room before the end of the examination session.

4.      This question paper is set with programming terms that are specific to the Delphi
        programming language. The Delphi programming language must be used to
        answer the questions.

5.      Make sure that you answer the questions according to the specifications that are
        given in each question. Marks will be awarded according to the set
        requirements.

6.      Answer only what is asked in each question. For example, if the question does
        not ask for data validation, then no marks will be awarded for data validation.

7.      Your programs must be coded in such a way that they will work with any data
        and not just the sample data supplied or any data extracts that appear in the
        question paper.

8.      Routines, such as search, sort and selection, must be developed from first
        principles. You may NOT use the built-in features of the Delphi programming
        language for any of these routines.

9.      All data structures must be defined by you, the programmer, unless the data
        structures are supplied.

10.     You must save your work regularly on the disk/CD/DVD/flash disk you have
        been given, or on the disk space allocated to you for this examination session.

11.     Make sure that your examination number appears as a comment in every
        program that you code, as well as on every event indicated.

12.     If required, print the programming code of all the programs/classes that you
        completed. Your examination number must appear on all printouts. You will be
        given half an hour printing time after the examination session.

13.     At the end of this examination session, you must hand in a disk/CD/DVD/
        flash disk with all your work saved on it OR you must make sure that all your
        work has been saved on the disk space allocated to you for this examination
        session. Ensure that all files can be read.

 Copyright reserved                                                          Please turn over

### Page 3

Information Technology/P1                     3                          DBE/November 2024
                                       NSC Confidential

14.     The files that you need to complete this question paper have been provided to
        you on the disk/CD/DVD/flash disk or on the disk space allocated to you. The
        files are provided in the form of password-protected executable files.   Nov

        Do the following:

            Double click on the following password-protected executable file:
             DataNOV2024.exe
            Click on the 'Extract' button.
            Enter the following password: #RUN4@New

        Once extracted, the following list of files will be available in the folder
        DataNOV2024:

        Question 1:                               Question 3:
        Houses.txt                                MRecord_U.pas
        Question1_P.dpr                           Question3_P.dpr
        Question1_P.dproj                         Question3_P.dproj
        Question1_P.res                           Question3_P.res
        Question1_U.dfm                           Question3_U.dfm
        Question1_U.pas                           Question3_U.pas

        Question 2:                               Question 4:
        ConnectDB_U.pas                           Question4_P.dpr
        MarathonsDB - Copy.mdb                    Question4_P.dproj
        MarathonsDB.mdb                           Question4_P.res
        Question2_P.dpr                           Question4_U.dfm
        Question2_P.dproj                         Question4_U.pas
        Question2_P.res
        Question2_U.dfm
        Question2_U.pas

 Copyright reserved                                                              Please turn over

### Page 4

Information Technology/P1                   4                         DBE/November 2024
                                        NSC Confidential

SECTION A

QUESTION 1: GENERAL PROGRAMMING SKILLS

Do the following:

      Open the incomplete program in the Question 1 folder.
      Enter your examination number as a comment in the first line of the
       Question1_U.pas file.
      Compile and execute the program. The program has limited functionality currently.

       Example of the graphical user interface (GUI):

      Complete the code for each section of QUESTION 1, as described in
       QUESTION 1.1 to QUESTION 1.5 on the next page.

    Copyright reserved                                                        Please turn over

### Page 5

Information Technology/P1                         5                       DBE/November 2024
                                           NSC Confidential

1.1       Write code for buttons btnQ1_1_1 and btnQ1_1_2 as specified below.

          1.1.1       Button [1.1.1 - Random]

                      Write code to do the following:

                         Generate a random number from 5 to 10, both numbers included.
                         Display the random number in the edit box edtQ1_1_1.

                      Example of output if the random number 5 was generated:

                      NOTE: The output may differ due to the nature of random numbers.             (4)

          1.1.2       Button [1.1.2 - Round up]

                      You have been provided with a constant NUMBER = 5.23247.

                      Write code that uses a mathematical function to display the value of
                      the constant, rounded up to the next whole number in the spin edit
                      spnQ1_1_2.

                      Example of output:

                                                                                                   (3)

1.2       Button [1.2 - Surface area]

          A right-angled solid cone is depicted in the image below.

          The surface area of the cone is calculated using the following formula:

                                       𝐴 = 𝜋𝑟(𝑟 + √ℎ2 + 𝑟 2 )
          Write code to do the following:

             Extract the values of r and h from the provided edit boxes edtQ1_2_r and
              edtQ1_2_h respectively.
             Use the values of r and h and appropriate mathematical functions to
              calculate the surface area of the cone represented by A.
             Display the value of A in the label lblQ1_2, rounded to TWO decimal
              places.
 Copyright reserved                                                             Please turn over

### Page 6

Information Technology/P1                       6                              DBE/November 2024
                                         NSC Confidential

          Example of input and output where r = 5 and h = 10:

          Example of input and output where r = 7.9 and h = 22.4:

                                                                                                       (8)

1.3       Button [1.3 - Read file]

          A text file called Houses.txt contains the street address and the number of
          bedrooms for each house in a suburban area.

          The format of the content of the text file is as follows:

                 <street address>
                 <number of bedrooms>

          Example of the first four lines from the Houses.txt text file:

                 61 Loop street
                 4
                 83 Church street
                 2

          Code has been provided for the declaration of the text file variable tFile.

          Write code to do the following:

             Assign the text file Houses.txt to the variable tFile.
             Ensure that reading from the text file starts from the first line in the text file.
             Read through the text file using a loop and save the street address and
              number of bedrooms into separate variables.
             Display the street address and the number of bedrooms in the rich edit
              redQ1_3 in the format below.

                 <street address> - <number of bedrooms> -bedroom house

 Copyright reserved                                                                 Please turn over

### Page 7

Information Technology/P1                     7                       DBE/November 2024
                                       NSC Confidential

          Example of output:

                                                                                              (9)

1.4       Button [1.4 - Add name]

          Learners at a school are going on an excursion. Two rich edit components
          redQ1_4_P and redQ1_4_NP have been provided to display the names of the
          learners who have paid their fees and the learners who have not paid their
          fees respectively.

          The combo box cmbQ1_4 contains the names of all the learners going on the
          excursion.

          Write code to do the following:

             Extract the name selected from the combo box cmbQ1_4.
             If the 'Paid' check box chbQ1_4 is checked, the name of the learner must
              be added to the redQ1_4_P component, otherwise the name must be
              added to the redQ1_4_NP component.
             Remove the selected name from the combo box cmbQ1_4.

          Example of input and output if Bianca was selected and her excursion fees
          were already paid:

          Example of input and output if Godfrey was selected and his excursion fees
          were not paid:

 Copyright reserved                                                        Please turn over

### Page 8

Information Technology/P1                       8                       DBE/November 2024
                                            NSC Confidential

             Example of the content of cmbQ1_4 after Bianca and Godfrey were selected
             and their names have been removed from the combo box:

                                                                                                   (7)

1.5          Button [1.5 - Replace]

             A password must be compiled for each learner attending the excursion.

             The user must enter the name and surname of the learner in the edit box
             edtQ1_5.

             The following code has been provided:
                The content of the edit box edtQ1_5 has been saved in the variable
                 sNameSurname.
                A string sCharacters that contains six special characters

                         sCharacters := '@#$%^&';

             Write code to do the following to create the password:

                Reverse the characters and remove all the spaces in the
                 sNameSurname string.
                Display the reversed string, without spaces, in the memQ1_5 output area.
                Replace every third character in the reversed string with a special
                 character randomly selected from the provided sCharacter string.
                Display the password in the memQ1_5 output area.

             Example of input and output:

                                                                                                   (9)

      Enter your examination number as a comment in the first line of the program file.
      Save your program.
      Print the code if required.

                                                                      TOTAL SECTION A:             40
    Copyright reserved                                                          Please turn over

### Page 9

Information Technology/P1                   9                          DBE/November 2024
                                    NSC Confidential

SECTION B

QUESTION 2: DATABASE PROGRAMMING

The organisers of athletic events require an application for running enthusiasts to
provide them with information about marathons and the locations.

A database called MarathonsDB.mdb, which contains information about marathon
names and the cities where they are held, has been developed. It allows users to find
marathons in their preferred cities.

The database contains two tables called tblLocations and tblMarathons.

NOTE:       The data pages attached at the end of the question paper provide
            information on the design of the MarathonsDB.mdb database and its
            contents.
Do the following:
   Open the incomplete project file called Question2_P.dpr in the Question 2 folder.
   Enter your examination number as a comment in the first line of the
    Question2_U.pas unit file.
   Compile and execute the program. The program has no functionality currently. The
    contents of the tables are displayed, as shown below on the selection of tab sheet
    2.2 - Delphi code.

Copyright reserved                                                        Please turn over

### Page 10

Information Technology/P1                    10                         DBE/November 2024
                                      NSC Confidential

     Follow the instructions below to complete the code for each section, as described
      in QUESTION 2.1 and QUESTION 2.2.
     Use SQL statements to answer QUESTION 2.1 and Delphi code to answer
      QUESTION 2.2.

NOTE:

     The ꞌRestore databaseꞌ button is provided to restore the data contained in the
      database to the original content.
     The content of the database is password-protected, i.e. you will NOT be able to
      gain access to the content of the database using Microsoft Access.
     Code is provided to link the GUI components to the database. Do NOT change any
      of the code provided.
     TWO variables are declared as public variables, as described in the table below.

    Variable                Data type           Description
    tblLocations            TADOTable           Refers to the table tblLocations
    tblMarathons            TADOTable           Refers to the table tblMarathons

2.1        Tab sheet [2.1 - SQL]

           Example of the graphical user interface (GUI) for QUESTION 2.1:

Copyright reserved                                                           Please turn over

### Page 11

Information Technology/P1                        11                            DBE/November 2024
                                          NSC Confidential

          NOTE:

             Use ONLY SQL statements to answer QUESTION 2.1.1 to
              QUESTION 2.1.5.
             Code to execute the SQL statements and display the results of the queries
              is provided. The SQL statements assigned to the variables sSQL1,
              sSQL2, sSQL3, sSQL4 and sSQL5 are incomplete.

          Complete the SQL statements to perform the tasks described in
          QUESTION 2.1.1 to QUESTION 2.1.5 below.

          2.1.1      Button [2.1.1 - Low population]

                     Display all fields of the records in the tblLocations table with a
                     population of less than 200 000 people.

                     Example of output:

                                                                                                      (3)

          2.1.2      Button [2.1.2 - Runners United September runs]

                     Display the MarathonID, MarathonDate and Distance of all the
                     marathons organised by Runners United taking place during
                     September.

                     Example of output:

                                                                                                      (4)

          2.1.3      Button [2.1.3 - Marathon locations]

                     The location of each marathon is required by the organisers.

                     Concatenate the City field and the first three letters of the Province
                     field of all the locations in the tblLocations table, in a new field called
                     Location.

                     The content of the new Location field must be in the following format:

                     <City> - <First three letters of province>

Copyright reserved                                                                 Please turn over

### Page 12

Information Technology/P1                        12                         DBE/November 2024
                                          NSC Confidential

                     Example of output of the first five records:

                                                                                                   (4)

          2.1.4      Button [2.1.4 - Add city]

                     A city must be added to the tblLocations table. The details are
                     provided in the table below.

                                     Field               Value
                                     LocationID          19
                                     City                Welkom
                                     Province            Free State
                                     Altitude            1198
                                     Population          423016

                     Example of output of the last five records after the city has been
                     added:

                                                                                                   (4)

          2.1.5      Button [2.1.5 - High prize money]

                     Display the city, the number of marathons and the total prize money
                     of all the marathons held in the city, only if the total prize money is
                     more than R50 000.

                     The new field for the number of marathons is NumMarathons and
                     the new field for the total prize money is Total Prize Money.

                     Example of output:

                                                                                                   (7)

Copyright reserved                                                              Please turn over

### Page 13

Information Technology/P1                     13                         DBE/November 2024
                                       NSC Confidential

2.2       Tab sheet [2.2 - Delphi code]

          NOTE:

             Use ONLY Delphi programming code to answer QUESTION 2.2.1 and
              QUESTION 2.2.2.
             NO marks will be awarded for SQL statements in QUESTION 2.2.

          Example of the graphical user interface (GUI) for QUESTION 2.2:

          2.2.1      Button [2.2.1 - Remove marathons]

                     Some organisers withdrew from the marathons and these marathonsꞌ
                     records must be removed as they will no longer take place.

                     The organiser's name must be entered by the user.

                     Code has been provided to extract and store the name of the
                     organiser, using an input dialog box. The name of the organiser is
                     stored in the variable sOrganiser.

                     Write code to remove the records from the tblMarathons table,
                     where the name of the organiser is the same as the name of the
                     organiser entered.

Copyright reserved                                                          Please turn over

### Page 14

Information Technology/P1                       14                          DBE/November 2024
                                         NSC Confidential

                     Example of the first four records in the tblMarathons table before
                     the organiser, Active Events, is deleted:

                     Example of the first four records in the tblMarathons table after the
                     organiser, Active Events, is deleted:

                                                                                                   (5)

          2.2.2      Button [2.2.2 - Qualifying marathons]

                     The runners training for long-distance marathons must compete in
                     qualifying marathons to be eligible for entry. A qualifying marathon
                     is any marathon that is run over a distance of 40 km or more.

                     A city name must be entered using an input dialog box and then all
                     the qualifying marathons in that city must be displayed.

                     Code has been provided to:

                           Clear the content of the redQ2_2_2 component
                           Extract and store the city name that was entered in the variable
                            sCity

                     Use the redQ2_2_2 component to display the output.

                     Write code to do the following:

                           Display the marathon name and distance of all the qualifying
                            marathons from the tblMarathons table, for the city name that
                            was entered, using the input box provided.
                           Display a suitable message if the city name entered cannot be
                            found in the tblLocations table.

Copyright reserved                                                              Please turn over

### Page 15

Information Technology/P1                       15                         DBE/November 2024
                                         NSC Confidential

                     Example of output if Paarl is entered as input:

                     Example of output if Sasolburg is entered as input:

                                                                                                 (13)

   Enter your examination number as a comment in the first line of the program file.
   Save your program.
   Print the code if required.

                                                                       TOTAL SECTION B:          40

Copyright reserved                                                            Please turn over

### Page 16

Information Technology/P1                  16                         DBE/November 2024
                                    NSC Confidential

SECTION C

QUESTION 3: OBJECT-ORIENTATED PROGRAMMING

You have been tasked by the World Marathon Association to assist with managing the
information of record holders in marathons.

Do the following:

   Open the incomplete program in the Question 3 folder.
   Open the incomplete object class MRecord_U.pas.
   Enter your examination number as a comment in the first line of both the
    Question3_U.pas file and the MRecord_U.pas file.
   Compile and execute the program. The program has limited functionality currently.

Example of the graphical user interface (GUI):

   Complete the code as specified in QUESTION 3.1 and QUESTION 3.2 that follow.

NOTE: You are NOT allowed to add any additional attributes or user-defined
      methods, unless explicitly stated in the question.

Copyright reserved                                                        Please turn over

### Page 17

Information Technology/P1                        17                        DBE/November 2024
                                          NSC Confidential

3.1       The provided incomplete object class (MRecord) contains the declaration of
          five attributes, which describe a Marathon Record object.

          The attributes for a Marathon Record object have been declared as follows:

              Attribute          Type            Description
              fMarathonName      String          The name of the marathon
              fRecordHolder      String          The name of the person that currently
                                                 holds the record
              fRecordDate        String          The record date in the format yyyy/MM/dd
              fRecordTime        String          The record time in the format hh:mm:ss
              fDistance          Real            The distance of the marathon

          The following methods have also been provided:

               A partially completed constructor method
               The mutator methods setRecordHolder, setRecordDate and
                setRecordTime
               An auxiliary method toMinutes that receives a runnerʹs time as a string
                parameter, in the format hh:mm:ss, and returns the record time in minutes
                as a real data type

          Complete the code in the object class as described in QUESTION 3.1.1 to
          QUESTION 3.1.5 below.

          3.1.1       The incomplete constructor method receives five parameters.

                      Write code to assign the parameters to the fMarathonName,
                      fRecordHolder, fRecordDate, fRecordTime and fDistance
                      attributes respectively.                                                    (3)

          3.1.2       Write code for an accessor method called getRecordTime to
                      return the fRecordTime attribute.                                           (2)

          3.1.3       Write code for a method called checkRecord that receives a
                      runnerʹs time as a string parameter and returns a Boolean value.

                      The method should compare the current record time stored in the
                      fRecordTime attribute, with the time received as a parameter.
                      Return 'True' if the runner's time received as a parameter is less
                      than the fRecordTime attribute value and 'False' if not.                    (5)

Copyright reserved                                                             Please turn over

### Page 18

Information Technology/P1                    18                             DBE/November 2024
                                      NSC Confidential

          3.1.4      The runnerʹs pace is the speed at which a runner completes a
                     marathon, measured in minutes per kilometre.

                     The following formula can be used to calculate a runnerʹs pace:

                                                         𝑚𝑖𝑛𝑢𝑡𝑒𝑠
                                              𝑝𝑎𝑐𝑒 =
                                                         𝑑𝑖𝑠𝑡𝑎𝑛𝑐𝑒

                     Write code for a method called calcPace that uses the provided
                     toMinutes method and the provided formula to calculate and
                     return the runnerʹs pace as a real value.                                    (4)

          3.1.5      Write code for a method called toString to return a string in the
                     following format:

                     <fMarathonName> - <fDistance> km: <fRecordHolder>
                     (<fRecordTime> on <fRecordDate>)

                     Example:

                     Karoo Marathon     -   42.2   km:     Sam   Peterson   (02:08:38    on
                     2024/06/13)                                                                  (5)

3.2       An incomplete program has been supplied in the Question 3 folder. The
          program contains code for the object class to be accessible and declares an
          object variable called objMRecord.

          Code has been provided in btnQ3_2_1, btnQ3_2_2 and btnQ3_3_3 to clear
          the output area.

          Write code to perform the tasks described in QUESTION 3.2.1 to
          QUESTION 3.2.3 that follow.

          3.2.1      Button [3.2.1 - Instantiate object]

                     Sam Peterson is the current record holder of the Karoo Marathon.
                     The current record information for the Karoo Marathon is recorded
                     as follows:

                             Marathon name                  Karoo Marathon
                             Record holder                  Sam Peterson
                             Date record was set            2024/06/13
                             Marathon record time           02:08:38
                             Distance of marathon           42.2 km

                     Code has been provided to extract the name of the marathon, the
                     name of the record holder, the date that the record was set and the
                     record time that was recorded from the relevant edit boxes.

Copyright reserved                                                             Please turn over

### Page 19

Information Technology/P1                       19                           DBE/November 2024
                                         NSC Confidential

                     Write code to do the following:

                           Extract the marathon distance from the radio group rgpQ3_2_1
                            as a real value. The unit 'km' must not be saved as part of the
                            distance value.
                           Use the information extracted to instantiate the objMRecord
                            object.
                           Display the details of the object in the output area redQ3, using
                            the toString method.

                     Example of input and output:

                                                                                                    (8)

          3.2.2      Button [3.2.2 - Pace]

                     The pace of the record holder needs to be calculated.

                     Write code to call the calcPace method and display the result,
                     rounded to THREE decimal places, in the redQ3 component in the
                     following format:

                     Record holder’s pace: <Pace of record holder> min/km

Copyright reserved                                                               Please turn over

### Page 20

Information Technology/P1                       20                         DBE/November 2024
                                         NSC Confidential

                     Example of input and output:

                                                                                                  (4)

          3.2.3      Button [3.2.3 - Check record]

                     The details of the current record holder object must be replaced if
                     another runner completes the marathon in a shorter time.

                     The user must enter the name and the time it took the new runner
                     to complete the marathon in the edit boxes edtQ3_2_3_Name and
                     edtQ3_2_3_Time respectively.

                     Write code to do the following:

                           Call the checkRecord method with the new runner's time as an
                            argument to determine if the new runner's time entered is less
                            than the current record time of the object.

                           If the new runner's time is less than the current record time:

                            o Update the current record object by using the following
                              methods and arguments:

                                Methods                       Arguments
                                setRecordHolder               New runner's name
                                setRecordTime                 New runner's time
                                setRecordDate                 System date

                            o Display the updated object information in the output area
                              redQ3 using the toString method.

Copyright reserved                                                             Please turn over

### Page 21

Information Technology/P1                       21                           DBE/November 2024
                                         NSC Confidential

                           If the new runner's time is more than the object's current record
                            time, display the current record time in the redQ3 component in
                            the following format:

                     The current record time remains: <Current record time>

                     Example of input and output if the new runner's time is more than
                     the current record time:

                     Example of input and output if the new runner's time is less than
                     the current record time:

                                                                                                    (9)

   Enter your examination number as a comment in the first line of the object class
    and the form class.
   Save your program.
   Print the code in the object class and the form class if required.

                                                                       TOTAL SECTION C:             40

Copyright reserved                                                               Please turn over

### Page 22

Information Technology/P1                   22                          DBE/November 2024
                                     NSC Confidential

SECTION D

QUESTION 4: PROBLEM-SOLVING PROGRAMMING

Do the following:
   Open the incomplete program in the Question 4 folder.
   Enter your examination number as a comment in the first line of the Quest4_U.pas
    file.
   Compile and execute the program. The program has limited functionality currently.

Example of the graphical user interface (GUI):

The following arrays have been provided in the program:

   An array, arrMarathons, which contains the names of ten marathons that have
    been completed by a participant in the past. It must be noted that a participant may
    have participated in a marathon more than once.

         arrMarathons: array [1 .. 10] of String = ('Wally Hayward',
         'Sasol','Soweto','Jacaranda City','Sasol','Durban City','Soweto',
         'Soweto','Wally Hayward','Soweto');

Copyright reserved                                                          Please turn over

### Page 23

Information Technology/P1                     23                          DBE/November 2024
                                       NSC Confidential

     A two-dimensional array, arrChar, that stores alphabetical characters. The names
      of nine different marathons are hidden in the rows of this array, amongst the other
      characters.

      arrChar: array [1 .. 14, 1 .. 14] of char = (
      ('u', 'x', 'v', 'm', 's', 'a', 's', 'o', 'l', 'f', 'k', 'j', 't', 'r'),
      ('u', 'm', 'g', 'e', 'n', 'i', 'w', 'a', 't', 'e', 'r', 'd', 's', 'e'),
      ('g', 'v', 'o', 'e', 't', 'v', 'a', 'n', 'a', 'f', 'r', 'i', 'k', 'a'),
      ('e', 'p', 'o', 'y', 'i', 'l', 'c', 'k', 'h', 'j', 's', 'd', 'f', 'd'),
      ('n', 'k', 'n', 'y', 's', 'n', 'a', 'f', 'o', 'r', 'e', 's', 't', 'u'),
      ('i', 's', 'y', 'd', 'b', 'c', 'r', 'g', 'h', 'k', 'c', 's', 'a', 'r'),
      ('w', 'a', 'l', 'l', 'y', 'h', 'a', 'y', 'w', 'a', 'r', 'd', 's', 'b'),
      ('a', 's', 'q', 'r', 't', 'n', 'n', 'j', 'h', 'e', 'r', 't', 'h', 'a'),
      ('t', 'o', 'e', 'r', 'y', 'b', 'd', 'r', 'h', 'k', 'l', 'g', 'd', 'n'),
      ('e', 'j', 'a', 'c', 'a', 'r', 'a', 'n', 'd', 'a', 'c', 'i', 't', 'y'),
      ('r', 'y', 'j', 'f', 'g', 'f', 'c', 'f', 'g', 'u', 'h', 'v', 'c', 'i'),
      ('k', 'h', 'h', 'l', 'p', 'h', 'i', 'l', 'l', 'c', 'r', 'e', 's', 't'),
      ('a', 'd', 'e', 'v', 'd', 's', 'o', 'w', 'e', 't', 'o', 'm', 'k', 'y'),
      ('p', 'd', 'u', 'r', 'b', 'a', 'n', 'c', 'i', 't', 'y', 'z', 'c', 'l'));

Complete the code for each section of QUESTION 4, as described in QUESTION 4.1
and QUESTION 4.2 below.

4.1        Button [4.1 - Count marathons]

           Use the provided array called arrMarathons that contains the names of ten
           marathons, which a runner has participated in over the past five years. The
           runner took part in some of the marathons more than once, hence the
           repetition of marathon names in the array.

           Code has been provided for the alignment and to display the headings in the
           redQ4_1 rich edit.

           Write code to do the following:

           Display the marathon name and the number of times the runner participated
           in each marathon in the redQ4_1 component, as shown in the output below.

           Example of output for the content in the array arrMarathons:

                                                                                                (11)

Copyright reserved                                                           Please turn over

### Page 24

Information Technology/P1                    24                     DBE/November 2024
                                      NSC Confidential

4.2       A mystery word puzzle game was developed to create awareness of the
          different marathons.

          Example of the graphical user interface (GUI):

          NOTE: Code has been provided for a method called display2D that displays
                the array arrChar in the rich edit redQ4_2.

          Combo box [cmbQ4_2]

          The mystery word puzzle game uses characters placed in the provided
          two-dimensional array called arrChar, containing 14 rows and 14 columns.
          Nine marathon names are provided in the combo box cmbQ4_2 and these
          names are also hidden among the characters in the rows of the array
          arrChar. The hidden marathon names are placed horizontally in the rows of
          the array arrChar from left to right.

          Write code to do the following:

             Extract the selected marathon name from the combo box cmbQ4_2.
             Find the marathon name selected that is hidden in array arrChar.
             Use the memQ4_2 to display the row and column values of the selected
              word in the following format:

              Row <Row index> @ column <Start col index> to <End col index>

Copyright reserved                                                      Please turn over

### Page 25

Information Technology/P1                   25                           DBE/November 2024
                                     NSC Confidential

             Change the characters of the selected marathon name in the array
              arrChar to upper case.
             Call the method display2D to display the array arrChar to show the
              selected word in upper case.

          Example of input and output if the marathon name 'knysnaforest' was
          selected from the combo box cmbQ4_2:

                                                                                             (19)

           NOTE:     A Reset button was provided to reset the characters in the
                     two-dimensional array back to lower case.

   Enter your examination number as a comment in the first line of the program file.
   Save your program.
   Print the code if required.

                                                                   TOTAL SECTION D:          30
                                                                      GRAND TOTAL:           150

Copyright reserved

### Page 26

Information Technology/P1                     1                         DBE/November 2024
                                      NSC Confidential

                            INFORMATION TECHNOLOGY P1

DATABASE INFORMATION FOR QUESTION 2:

The design of the database tables is as follows:

Table: tblLocations

This table contains the details of each location.

 Field name            Data type      Description
 LocationID (PK)       Number         A unique ID that identifies a location
 City                  Text (20)      The name of the city where the location is
 Province              Text (15)      The name of the province where the city is
                                      located
 Altitude              Number         The altitude of the location
 Population            Number         The population of the city

Example of the first ten records of the tblLocations table:

Table: tblMarathons

This table contains information on the marathons available in each location.

 Field name            Data type      Description
 MarathonID (PK)       Number         A unique ID that identifies the marathon
 MarathonName          Text (30)      The name of the marathon
 MarathonDate          Date/Time      The date on which the marathon takes place
 Distance              Number         The distance of each marathon
 PrizeMoney            Currency       The prize money awarded to the winner of the
                                      marathon
 Organiser             Text (25)      The name of the organiser of the marathon
 LocationID (FK)       Number         The ID of the location where the marathon takes
                                      place

Copyright reserved                                                             Please turn over

### Page 27

Information Technology/P1                    2                          DBE/November 2024
                                     NSC Confidential

Example of the first ten records of the tblMarathons table:

NOTE:

   Connection code has been provided.
   The database is password-protected; therefore, you will not be able to access the
    database directly.

The following one-to-many relationship with referential integrity exists between the two
tables in the database:

Copyright reserved

### Page 28

Information Technology/P1                        DBE/November 2024
                              NSC Confidential

                            PLANNING PAGE 1

Copyright reserved

### Page 29

Information Technology/P1                        DBE/November 2024
                              NSC Confidential

                            PLANNING PAGE 2

Copyright reserved

### Page 30

Information Technology/P1                                                DBE/November 2024
                                         NSC Confidential

                                    Examination sticker

                                                                                   _______
                                                                                     150

            INFORMATION TECHNOLOGY P1 – NOVEMBER 2024
INFORMATION SHEET (to be completed by the candidate AFTER the 3-hour exam session)

CENTRE NUMBER ______________________________________________________

EXAMINATION NUMBER _________________________________________________

WORK STATION NUMBER ________________________________________________

Version of Delphi used during the INFORMATION TECHNOLOGY NSC NOV 2024 Examination:
Mark appropriate                                                                            Other:
box with a cross      Delphi    Delphi      Delphi       Delphi      Delphi     Delphi
                                                                                           (Specify)
(X )                   10        XE          10.3      Community      11         12
                                                                                           ________

FOLDER NAME _________________________________________________________

Candidate must enter the file name(s) used for each answer. Tick if saved and/or attempted.
                                                                                        Marker
Question     File name           Saved       Attempted Maximum              Mark        Initial/
 number                           ()            ()         Mark        Achieved        Code

              Question1_P.
     1        dproj                                            40

              Question2_P.
     2        dproj                                            40

              MRecord_U.                                       19
              pas
     3
              Question3_P.                                     21
              dproj
              Question4_P.
     4        dproj                                            30

                            TOTAL                              150

Comment: (for office/marker use only)
 __________________________________________________________________________
 __________________________________________________________________________

Copyright reserved

## Related documents

- [IT P1 MEMO GR12 SEPT 2024 English](https://www.hlayiso.com/library/it-p1-memo-gr12-sept-2024-english/8994aed2-83ec-413e-b7dc-b0d0b93b82f4) — Information Technology · Memo · 2024 · Eng
- [Information Technology P1 Nov 2023 Eng](https://www.hlayiso.com/library/information-technology-p1-nov-2023-eng/8ae9d306-1975-4759-ad2b-96483154bd10) — Information Technology · QP · 2023 · Eng
- [IT P1 GR12 QP SEPT 2022 Afrikaans](https://www.hlayiso.com/library/it-p1-gr12-qp-sept-2022-afrikaans/f864e03f-add3-41d0-9b55-3110e7180172) — Information Technology · QP · 2022 · Afr
- [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 QP SEPT 2021 AFR](https://www.hlayiso.com/library/it-p1-gr12-qp-sept-2021-afr/b59411e5-b38d-41a9-90dd-1921c620ec7d) — Information Technology · QP · 2021 · Afr
- [IT P1 GR12 QP SEPT 2021 Eng](https://www.hlayiso.com/library/it-p1-gr12-qp-sept-2021-eng/6e66bdc6-8141-4ae4-b644-0341865f3911) — Information Technology · QP · 2021 · Eng

## More from Grade 12 Information Technology

- [Information Technology P1 May-June 2025 MG Eng](https://www.hlayiso.com/library/information-technology-p1-may-june-2025-mg-eng/109c2e1d-bc20-46d3-ac02-c08c05ad9c78) — Memo · 2025 · Eng
- [IT P2 MEMO GR12 SEPT 2024 English](https://www.hlayiso.com/library/it-p2-memo-gr12-sept-2024-english/4d74acb4-cb8b-4fd3-874f-4801fbcb8f44) — Memo · 2024 · Eng
- [IT P1 MEMO GR12 SEPT2023 Afrikaans](https://www.hlayiso.com/library/it-p1-memo-gr12-sept2023-afrikaans/7ffdb7c3-1881-43da-8d8a-96ea3ff87451) — Memo · 2023 · Afr
- [IT P2 GR12 MEMO SEPT2023 Afrikaans](https://www.hlayiso.com/library/it-p2-gr12-memo-sept2023-afrikaans/88ad2758-42f6-43df-a80a-288b5f4cff9f) — Memo · 2023 · Afr
- [IT P2 GR12 MEMO SEPT2023 English](https://www.hlayiso.com/library/it-p2-gr12-memo-sept2023-english/41fa8299-d258-40e9-8c8b-a3ce984eef54) — Memo · 2023 · 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.
