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

> Grade 12 Information Technology Paper 1 question paper from the NSC June Exam 2023 (English), 28 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/information-technology-p1-may-june-2023-eng/896eee2c-884c-4527-97e2-ed0759edd97d
- Updated: 2026-09-27
- Subject: Information Technology
- Grade: Grade 12
- Document type: Question paper
- Year: 2023
- Exam period: NSC June Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 28

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 June 2023 QP (Eng)](https://www.hlayiso.com/library/information-technology-p1-may-june-2023-eng/896eee2c-884c-4527-97e2-ed0759edd97d)

## About this document

Information Technology · Grade 12 · NSC June Exam · 2023. Question paper, 28 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

             SENIOR CERTIFICATE EXAMINATIONS/
         NATIONAL SENIOR CERTIFICATE EXAMINATIONS

                       INFORMATION TECHNOLOGY P1

                                        2023

                                                                       MARKS: 150

                                                                     TIME: 3 hours

              This question paper consists of 24 pages, 2 data pages and
                              2 blank pages for planning.

Copyright reserved                                                         Please turn over

### Page 2

Downloaded from hlayiso.com
 Information Technology/P1                  2                                      DBE/2023
                                         SC/NSC

INSTRUCTIONS AND INFORMATION

1.      This question paper is divided into FOUR sections. Candidates must answer
        ALL the questions from 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 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, 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 the 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

Downloaded from hlayiso.com
 Information Technology/P1                    3                                       DBE/2023
                                           SC/NSC

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.

        Do the following:

            Double click on the following password-protected executable file:
             DataJun2023.exe.
            Click on the 'Extract' button.
            Enter the following password: E#Homes%2023

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

        Question1:                               Question3:
        Question1_P.dpr                          log.txt
        Question1_P.dproj                        Question3_P.dpr
        Question1_P.res                          Question3_P.dproj
        Question1_U.dfm                          Question3_P.res
        Question1_U.pas                          Question3_U.dfm
        Words.txt                                Question3_U.pas
                                                 SmartSwitch_U.pas

        Question2:                               Question4:
        ConnectDB_U.pas                          Question4_P.dpr
        Question2_P.dpr                          Question4_P.dproj
        Question2_P.dproj                        Question4_P.res
        Question2_P.res                          Question4_U.dfm
        Question2_U.dfm                          Question4_U.pas
        Question2_U.pas
        SmartDevicesDB - Copy.mdb
        SmartDevicesDB.mdb

 Copyright reserved                                                              Please turn over

### Page 4

Downloaded from hlayiso.com
Information Technology/P1                  4                               DBE/2023
                                        SC/NSC

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 no functionality currently.

Example of graphical user interface (GUI):

   Complete the code for each section of QUESTION 1, as described in
    QUESTION 1.1 to QUESTION 1.5 that follow.

Copyright reserved                                                    Please turn over

### Page 5

Downloaded from hlayiso.com
Information Technology/P1                      5                                     DBE/2023
                                            SC/NSC

1.1       Button [1.1 - Formatting]

          Write code to change the content and appearance of the edit box edtQ1_1 as
          follows when the btnQ1_1 button is clicked:

             The font size of the text must be 14 pt.
             The words 'Hello world' must appear as text in the edtQ1_1 edit box.
             The text must be underlined.
             The background colour of the edtQ1_1 component must be green.

          Example of output:

                                                                                                 (4)

1.2       Button [1.2 - Random number]

          Write code to do the following:

             Generate a random integer between 1 and 99 (inclusive of these values).
             Determine whether the number that has been generated is a single digit or
              a two-digit number.
             Display the number and result in the panel pnlQ1_2 as shown in the
              examples below.

          Example of output if the number 4 was generated:

          Example of output if the number 46 was generated:

                                                                                                 (8)

Copyright reserved                                                            Please turn over

### Page 6

Downloaded from hlayiso.com
Information Technology/P1                      6                                   DBE/2023
                                            SC/NSC

1.3       Button [1.3 - Area]

          Shown below is a diagram of a nut, made up of a hexagon and a circle. The
          diameter (d) of the circle has the same length as the side of the hexagon.

          The shaded area in the diagram is calculated using the following formula:

                                                 3 √3           𝑑 2
                                Shaded area = (
                                                     2
                                                       ) 𝑑2 − 𝜋 (2)

          where d is the length of one side of the hexagon and d is also the diameter
          of the circle.

          The user is required to enter the value of d in the edit box edtQ1_3.

          Write code to do the following:

             Extract the value of d from the edit box edtQ1_3.
             Use the given formula to calculate the area of the shaded part of the
              diagram provided above.
             Display the area of the shaded part, rounded to ONE decimal place, on
              the panel pnlQ1_3.

          Example of input and output:

                                                                                                 (8)

Copyright reserved                                                            Please turn over

### Page 7

Downloaded from hlayiso.com
Information Technology/P1                      7                                      DBE/2023
                                            SC/NSC

1.4       Button [1.4 - Find]

          A text file Words.txt containing a list of words has been supplied. The
          program must count the number of times a word entered by the user occurs
          in the text file.

          Example of the first five lines of the text file Words.txt:
                 accessory
                 archive
                 bandwidth
                 capacity
                 bus

          The user must enter the word to be counted in the edit box edtQ1_4.

          Code has been provided to open the text file Words.txt for reading.

          Write code to do the following:
             Extract the word that was entered in the edit box edtQ1_4.
             Count the number of times the word entered occurs in the file, regardless
              of whether the word was entered in small letters or capital letters.
             If the word occurs in the text file, display the number of occurrences in the
              redQ1_4 rich edit component.
             If the word does NOT occur in the text file, display the message 'Word not
              found' in the redQ1_4 rich edit component.

          Two examples of input and output:

                                                                                                   (11)

1.5       Button [1.5 - Booster rocket]

          A booster rocket uses 7,5% of its fuel per second from lift-off. The rocket
          shuts down when the fuel capacity is below 200 litres.

          Do the following:

          Convert the algorithm on the next page into programming code to calculate
          and display the seconds travelled, the fuel used and the fuel left per second
          until the rocket shuts down.

Copyright reserved                                                              Please turn over

### Page 8

Downloaded from hlayiso.com
Information Technology/P1                     8                                          DBE/2023
                                           SC/NSC

            Algorithm
            1.  Enter the total litres of fuel before lift-off (use an input box for input)
            2.  Assign the value of total litres of fuel to a variable for fuel left
            3.  Initialise a counter for number of seconds
            4.  While fuel left is more than or equal to 200
            5.      Increment counter by one
            6.      Calculate fuel used (7,5% of fuel left)
            7.      Subtract fuel used from fuel left
            8.      Display counter, fuel used and fuel left
            9.  End while loop

          NOTE:
           Code is provided to display the headings in the rich edit redQ1_5.
           The amount of fuel used per second and the amount of fuel left must be
            formatted to TWO decimal places, as shown in the example of output.

          Example of the input of 550 litres of fuel and the 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

Downloaded from hlayiso.com
Information Technology/P1                 9                                     DBE/2023
                                       SC/NSC

SECTION B

QUESTION 2: DATABASE PROGRAMMING

Smart home devices are becoming more popular among people that have access to
fast reliable internet connections.

A database called SmartDevicesDB.mdb has been developed and contains
information about the different manufacturers of smart devices and the stock available
of the different devices.

The SmartDevicesDB.mdb database contains two tables called tblManufacturers
and tblDevices.

The data pages attached at the end of the question paper provide information on the
design and contents of the database.

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

Downloaded from hlayiso.com
Information Technology/P1                   10                                      DBE/2023
                                          SC/NSC

     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
      direct 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
      tblManufacturers           TADOTable      Refers to the table tblManufacturers
      tblDevices                 TADOTable      Refers to the table tblDevices

2.1      Tab sheet [2.1 - SQL]

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

Copyright reserved                                                            Please turn over

### Page 11

Downloaded from hlayiso.com
Information Technology/P1                       11                                            DBE/2023
                                              SC/NSC

       NOTE: 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 - iOS devices]

                     Display the DeviceID and DeviceName of all devices in the
                     tblDevices table, that use the iOS operating system.

                     Example of output of the first five records:

                                                                                                     (3)

       2.1.2         Button [2.1.2 - Category selected]

                     The user must select a device type from the combo box
                     cmbQ2_1_2. Code has been provided to extract and store the
                     device type selected in a variable sDeviceType.

                     Display the DeviceName, Category and NumInStock of all devices
                     where the Category field contains the device type selected from the
                     combo box.

                     Example of output if TV was selected as a device type:

                                                                                                     (3)

       2.1.3         Button [2.1.3 - Online support]

                     Display the DeviceName, Category and OperatingSystem of all
                     devices that receive online support from the manufacturer. The
                     results must be sorted in alphabetical order according to the
                     DeviceName. See the next page.

Copyright reserved                                                                    Please turn over

### Page 12

Downloaded from hlayiso.com
Information Technology/P1                       12                                     DBE/2023
                                              SC/NSC

                     Example of output of the first five records:

                                                                                                 (6)

       2.1.4         Button [2.1.4 - Profit per manufacturer]

                     All the products in stock are available to be purchased at a clearance
                     sale. The price shown in the tblDevices table refers to the selling
                     price of the product. The profit after selling the stock is 60% of the
                     selling price. The total profit made by each manufacturer must be
                     calculated assuming that all products will be sold at the sale.

                     Write code to display the ManufacturerID and the total profit in a
                     new field called Profit, formatted to currency.

                     Example of output:

                                                                                                 (6)

       2.1.5         Button [2.1.5 - Remove devices]

                     The entire range of smart speakers, manufactured by Mobile Comp
                     with ManufacturerID M104, have been recalled due to a fault during
                     the manufacturing process.

                     Remove all records of smart speakers that were manufactured by
                     ManufacturerID M104, from the tblDevices table.

                     NOTE: Code has been provided to display a message to indicate
                     the
                           number of records that have been deleted.

                     Example of output:

                                                                                                 (4)

Copyright reserved                                                                Please turn over

### Page 13

Downloaded from hlayiso.com
Information Technology/P1                  13                               DBE/2023
                                         SC/NSC

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 graphical user interface (GUI) for QUESTION 2.2:

Copyright reserved                                                     Please turn over

### Page 14

Downloaded from hlayiso.com
Information Technology/P1                    14                                       DBE/2023
                                           SC/NSC

          2.2.1      Button [2.2.1 - Display products]

                     Retailers want to see which products are made by each
                     manufacturer.

                     Code has been provided to clear the content in the redQ2_2_1
                     component.

                     Write code to do the following:

                        Display the manufacturer name and contact number in the
                         following format:
                                    <Manufacturer Name>: <Contact Number>
                        Display the following headings for each manufacturer:
                                    'Device name'      'In stock'    'Price'
                        Display all the devices made by each manufacturer using the
                         appropriate headings.

                     Example of output for the first two manufacturers (Berry Tech and
                     Gem Smart):

                                                                                                    (12)

          2.2.2      Button [2.2.2 -Update stock]

                     When devices are sold, the number in stock must be decreased in
                     the table tblDevices.

                     The user must select the record of the device to be sold from the
                     tblDevices table in the DBGrid component dbgDevices.

                     Write code to do the following:

                        Provide an input dialog box for the user to enter the number of
                         devices to be sold for the record selected.
                        If stock is sufficient, decrease the number in stock for the
                         selected item with the number that was entered. If stock is
                         insufficient, display a suitable message.

Copyright reserved                                                               Please turn over

### Page 15

Downloaded from hlayiso.com
Information Technology/P1                    15                                     DBE/2023
                                           SC/NSC

                     Example of output if the 'Bulb 6' item had been selected before any
                     items were sold:

                     Example of output if the value of 15 was entered and 15 units of the
                     selected item were sold:

                     Example of output if the 'Bulb 6' item had been selected before any
                     items were sold:

                     Example of output if the value of 101 was entered for units to be
                     sold:

                                                                                                  (6)

   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

Downloaded from hlayiso.com
    Information Technology/P1                 16                                         DBE/2023
                                            SC/NSC

SECTION C

QUESTION 3: OBJECT-ORIENTATED PROGRAMMING

Smart switches have been installed to monitor and automate home devices. The
program to be developed will determine the device power usage of the switch and the
user will have the option of switching the device ON or OFF.

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

Example of graphical user interface (GUI):

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

3.1         The given incomplete object class (TSmartSwitch) contains:

               The declaration of four attributes which describe a SmartSwitch object
               Code for a method called determineSwitchStatus

    Copyright reserved                                                           Please turn over

### Page 17

Downloaded from hlayiso.com
Information Technology/P1                     17                                      DBE/2023
                                            SC/NSC

        The attributes for a SmartSwitch object have been declared as follows:

          Attribute          Type       Description
          fSwitchID          String     The identifying code of the switch, e.g. S01
          fDevice            String     The name of the device that will be used on the
                                        switch
          fPowerUsage        Integer    The amount of energy/power in watts used by the
                                        device
          fSwitchStatus      Boolean    The current status of the switch, either True for
                                        ON or False for OFF

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

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

        3.1.1        Write code for a constructor method that will receive the switch ID,
                     the name of the device and the power usage of the switch as
                     parameters. Assign the parameter values to the respective attributes.
                     Allocate the value 'false' to the fSwitchStatus attribute.                     (5)

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

        3.1.3        Write code for a method called energyUsed to receive the number of
                     hours (as an integer) that the device was switched on, as a parameter.
                     Use the formula below to calculate and return the amount of energy
                     (kilowatt-hour (kWh)) used by the device.

                             Energy used = PowerUsage * Hours
                                                1000                                                (4)

        3.1.4        Write code for a mutator method called setSwitchStatus which can
                     be used to switch the device ON or OFF. The method must receive a
                     Boolean value as a parameter and set the fSwitchStatus attribute to
                     the value received.                                                            (3)

        3.1.5        Write code for a toString method to return a string with all the
                     attributes of the object in the following format:
                     Switch ID: <SwitchID>
                     Device: <Device>
                     Power usage: <PowerUsage> W
                     Switch status: <ON> or <OFF>

                     Call the provided method determineSwitchStatus to determine if the
                     switch is ON or OFF.                                                           (4)

Copyright reserved                                                               Please turn over

### Page 18

Downloaded from hlayiso.com
 Information Technology/P1                       18                                   DBE/2023
                                               SC/NSC

3.2      An incomplete program, Question3_P, 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 objSmartSwitch.

         Write code to perform the tasks described in QUESTION 3.2.1 to
         QUESTION 3.2.4 below.

         Code has been provided in each of the buttons to clear the redQ3 rich edit
         component.

         3.2.1        Button [3.2.1 - Instantiate object]

                      A list box lstQ3_2_1 contains devices and their power usage in the
                      following format:

                                      <Device>#<Power usage in watts>

                      The user needs to select a switch ID from the combo box cmbQ3_2_1
                      and any device from the list box lstQ3_2_1.

                      Write code to do the following:

                         Extract the switch ID from the combo box cmbQ3_2_1.
                         Extract the name of the device and the power usage in watts from
                          the list box lstQ3_2_1. Separate the device from the power usage.
                         Use the switch ID, name of the device and power usage to
                          instantiate a new SmartSwitch object.
                         Call the toString method to display the information of the
                          SmartSwitch object in the rich edit redQ3.

                      Example of input:

                      Example of output after instantiation of the object:

                                                                                                    (8)

 Copyright reserved                                                              Please turn over

### Page 19

Downloaded from hlayiso.com
Information Technology/P1                       19                                       DBE/2023
                                              SC/NSC

        3.2.2        Button [3.2.2 - Change switch status]

                     Use the radio group rgpQ3_2_2 to select the switch to be ON or OFF.

                     Write code to do the following:

                        Call the setSwitchStatus method using the value selected from
                         the radio group as an argument. The value ON represents True
                         and the value OFF represents False.
                        Display the ID and the status of the objSmartSwitch object in the
                         rich edit redQ3.

                     Example of input if the 'ON' option has been selected for the fan
                     device:

                     Example of output if the 'ON' option has been selected for the fan
                     device:

                                                                                                       (5)

       3.2.3         Button [3.2.3 - Write to file]

                     A text file called log.txt keeps a record of the date, time, switch ID and
                     the status of the switch.

                     Code has been provided in the FormCreate event to show the current
                     time in the lable lblTime.

                     Write code to do the following:
                        Open the text file log.txt to add a line of text.
                        Add a line of text to the file which contains the current system date,
                         current system time, the switch ID and the switch status in the
                         following format:
                            Current date,Current time,Switch ID#Switch status

                     Example of output to the file if the current system date and time is
                     23 May 2023, 9:18:06 AM:

                                   23/05/2023,9:18:06 AM,S03#ON

Copyright reserved                                                                  Please turn over

### Page 20

Downloaded from hlayiso.com
    Information Technology/P1                       20                                     DBE/2023
                                                  SC/NSC

                         NOTE: A date function must be used to extract the current system
                               date. The format of the date and time are dependent on the
                               regional settings of your computer, which may differ from the
                               example output provided.                                                  (6)

           3.2.4         Button [3.2.4 - Power usage]

                         The switch will be left on for a specific number of hours.

                         The user must enter the number of hours in the edit box edtQ3_2_4.

                         Write code to do the following:
                            Obtain the number of hours that was entered from the edit box
                             edtQ3_2_4.
                            Call the energyUsed method using the number of hours that was
                             entered as an argument.
                            Display a suitable message in the rich edit redQ3 to indicate the
                             amount of energy used in kWh.

                         Example of input and output if the device selected is a fan 100 W and
                         the number of hours is 4:

                         Example of input and output if the device selected is a pool pump of
                         850 W and the number of hours is 6:

                                                                                                         (3)

     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 21

Downloaded from hlayiso.com
    Information Technology/P1                 21                               DBE/2023
                                            SC/NSC

SECTION D

QUESTION 4: PROBLEM-SOLVING PROGRAMMING

You are developing a program to test the wireless network for a college campus. The
area of the campus has been broken up into a grid where access points can be added
and Wi-Fi coverage will be determined.

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
      Question4_U.pas file.
     Compile and execute the program. The program has no functionality currently.

    Example of graphical user interface (GUI):

The following two-dimensional array arrNetwork has been provided. The array
represents the wireless network of the college campus broken up into a grid with 5
rows and 6 columns.

arrNetwork: array [1 .. 5, 1 .. 6] of char =
                         (('_','A','_','_','_','_'),
                          ('_','_','_','_','_','_'),
                          ('_','_','_','_','A','_'),
                          ('_','_','_','_','_','_'),
                          ('_','A','_','_','_','_'));

    Copyright reserved                                                    Please turn over

### Page 22

Downloaded from hlayiso.com
 Information Technology/P1                        22                                   DBE/2023
                                                SC/NSC

The following table contains the descriptions of the symbols used in the array:

                             Symbol             Description
                             Letter ('A')       Access point
                             Underscore ('_')   Empty space

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

4.1      Button [4.1 - Display]

         Write code to display the provided array arrNetwork in the rich edit redQ4.
         The row and column headings representing the wireless network of the
         college campus must be displayed as shown in the example of output.

         Example of output:

                                                                                                     (7)

4.2      Button [4.2 - Add access point]

         The program must be able to capture the addition of an access point to the
         campus network at an available space in the grid. A maximum of three access
         points in a row is allowed.

         The user must select the row and column values from the spin edits
         sedQ4_2_Row and sedQ4_2_Col where the access point is to be added.

         Write code to do the following:

            Extract the row and column values selected for the location of the access
             point.
            Add an access point to the location in arrNetwork if there is no access
             point at that location and the total number of access points in that row does
             not exceed two.

             Display an appropriate message if:

             o   There is already an access point at the specific location
             o   The row already contains more than two access points

 Copyright reserved                                                               Please turn over

### Page 23

Downloaded from hlayiso.com
 Information Technology/P1                   23                                     DBE/2023
                                           SC/NSC

         Example of output if the selected row is 3 and the selected column is 1:

         Example of output if the selected row is 3 and the selected column is 5 and
         there is already an access point at this location:

         Example of output if the user attempts to add an access point in a row that
         already has 3 access points:

                                                                                                  (10)

4.3      Button [4.3 - Coverage ]

         A grid is used to determine the blocks/locations at the campus that will have
         coverage and those that will not have coverage. Each access point (A) has
         the capacity to provide a signal to all the blocks/locations around the access
         point. The blocks/locations covered per access point will be marked with the
         asterisk ('*') character.

         Example:

         Write code to do the following:

            Add coverage symbols (*) around all the access points in the campus
             network saved in array arrNetwork.
            Display array arrNetwork after the coverage symbols have been added.

 Copyright reserved                                                            Please turn over

### Page 24

Downloaded from hlayiso.com
    Information Technology/P1                 24                                      DBE/2023
                                            SC/NSC

            Example of output:

                                                                                                 (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 D:        30
                                                                        GRAND TOTAL:         150

    Copyright reserved

### Page 25

Downloaded from hlayiso.com
Information Technology/P1                   1                                         DBE/2023
                                         SC/NSC

                            INFORMATION TECHNOLOGY P1

DATABASE INFORMATION FOR QUESTION 2:

The design of the database tables is as follows:

Table: tblManufacturers

This table contains the details of the manufacturers.

Field name             Data type      Description
ManufacturerID         Text (5)       Unique ID of each manufacturer
ManufacturerName       Text (25)      Name of each manufacturer
ContactNumber          Text (10)      The contact number of each manufacturer
OnlineSupport          Yes/No         The value 'true' to indicate that online support will
                                      be provided; 'false' if not

Example of the first seven records of the tblManufacturers table:

Table: tblDevices

This table contains information on the devices made by each manufacturer.

Field name            Data type     Description
DeviceID              Text (10)     Unique ID for each device
DeviceName            Text (20)     Unique name for each device
Category              Text (20)     Category of each device: smart watch, smart
                                    lighting, smart TV, smart speaker, smart refrigerator,
                                    smart door lock, smart heating
OperatingSystem       Text(15)      The operating system used to run and connect the
                                    manufacturer devices
Price                 Currency      The selling price of each device
NumInStock            Number        The amount of stock available for each device
ManufacturerID        Text (5)      ID of the manufacturer of each device

Copyright reserved                                                              Please turn over

### Page 26

Downloaded from hlayiso.com
Information Technology/P1                   2                                    DBE/2023
                                         SC/NSC

Example of the first ten records of the tblDevices 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 27

Downloaded from hlayiso.com
Information Technology/P1                          DBE/2023
                                 SC/NSC

                            PLANNING PAGE 1

Copyright reserved

### Page 28

Downloaded from hlayiso.com
Information Technology/P1                          DBE/2023
                                 SC/NSC

                            PLANNING PAGE 2

Copyright reserved

## Related documents

- [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) — Information Technology · Memo · 2023 · Eng
- [Information Technology P1 May June 2019 Afr](https://www.hlayiso.com/library/information-technology-p1-may-june-2019-afr/6881c007-0025-4f7b-b5e7-02d3eb15ab1a) — Information Technology · QP · 2019 · Afr
- [Information Technology P1 May June 2018 Eng](https://www.hlayiso.com/library/information-technology-p1-may-june-2018-eng/f20968e6-cad1-4344-a27e-a4710f8d6ccc) — Information Technology · QP · 2018 · Eng
- [Information Technology P1 June July 2015 Afr](https://www.hlayiso.com/library/information-technology-p1-june-july-2015-afr-2/99bccf2f-17ab-41f3-b2cd-41e24e170d07) — Information Technology · QP · 2015 · Afr
- [IT P1 MEMO GR12 SEPT2023 Afrikaans](https://www.hlayiso.com/library/it-p1-memo-gr12-sept2023-afrikaans/7ffdb7c3-1881-43da-8d8a-96ea3ff87451) — Information Technology · Memo · 2023 · Afr
- [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) — Information Technology · Memo · 2025 · Eng

## More from Grade 12 Information Technology

- [IT P1 MEMO GR12 SEPT 2024 English](https://www.hlayiso.com/library/it-p1-memo-gr12-sept-2024-english/8994aed2-83ec-413e-b7dc-b0d0b93b82f4) — Memo · 2024 · 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 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
- [IT P1 GR12 MEMO SEPT 2022 Afrikaans](https://www.hlayiso.com/library/it-p1-gr12-memo-sept-2022-afrikaans/43cd69be-f0ac-46f4-9d4c-b2503fe09125) — Memo · 2022 · Afr
- [IT P1 GR12 MEMO SEPT 2022 English](https://www.hlayiso.com/library/it-p1-gr12-memo-sept-2022-english/6e7cbe6a-69aa-4c7d-bcd4-dcfeaf4c8272) — Memo · 2022 · 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.
