# Information Technology Grade 12 P1 NSC November 2023 QP

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

- Page: https://www.hlayiso.com/library/information-technology-p1-nov-2023-eng/8ae9d306-1975-4759-ad2b-96483154bd10
- Updated: 2026-09-27
- Subject: Information Technology
- Grade: Grade 12
- Document type: Question paper
- Year: 2023
- Exam period: NSC November Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 29

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Information Technology](https://www.hlayiso.com/library/grade-12/information-technology) › [Information Technology Grade 12 P1 NSC November 2023 QP](https://www.hlayiso.com/library/information-technology-p1-nov-2023-eng/8ae9d306-1975-4759-ad2b-96483154bd10)

## About this document

Information Technology · Grade 12 · NSC November Exam · 2023. Question paper, 29 pages. Read online or download the PDF.

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

## Document text

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

### Page 1

Downloaded from hlayiso.com

                                  NATIONAL
                             SENIOR CERTIFICATE

                                    GRADE 12

                        INFORMATION TECHNOLOGY P1

                                  NOVEMBER 2023

MARKS: 150

TIME: 3 hours

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

Copyright reserved                                                         Please turn over

### Page 2

Downloaded from hlayiso.com
 Information Technology/P1                  2                             DBE/November 2023
                                           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/November 2023
                                            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:
             DataNov2023.exe
            Click on the 'Extract' button.
            Enter the following password: %Learn4Life@

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

        Question 1:                               Question 3:
        Details.txt                               Question3_P.dpr
        Question1_P.dpr                           Question3_P.dproj
        Question1_P.dproj                         Question3_P.res
        Question1_P.res                           Question3_U.dfm
        Question1_U.dfm                           Question3_U.pas
        Question1_U.pas                           School_U.pas

        Question 2:                               Question 4:
        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
        UniversityDB - Copy.mdb
        UniversityDB.mdb

 Copyright reserved                                                              Please turn over

### Page 4

Downloaded from hlayiso.com
    Information Technology/P1                   4                              DBE/November 2023
                                               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 the 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.

1.1          Button [1.1 - Display name and age]

             The user must do the following:

                Enter a name in the edit box edtQ1_1.
                Enter/Select the person's age in the spin edit box spnQ1_1.

             Write code to do the following:

                Extract the name entered from the edit box edtQ1_1 and store the name
                 in the provided sName variable.
                Extract the age entered/selected from the spin edit spnQ1_1 and store
                 the age in the provided iAge variable.
                Display the name and age, one below the other, using an output dialogue
                 box.

    Copyright reserved                                                            Please turn over

### Page 5

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

          Example of input:

          Example of output:

                                                                                          (5)

1.2       Button [1.2 - Hockey teams]

          Learners who are interested in playing hockey are divided into teams of
          11 players. A total of 11 players represents a full team in hockey. The
          remainder of the learners who could not make up a full team will be placed
          onto a reserve list.

          A constant variable which is declared as PLAYERS = 11 has been provided.

          Write code to do the following:

             Extract the total number of learners from the edit box edtQ1_2.
             Use the total number of learners and the constant PLAYERS to calculate
              the following:
              o Number of hockey teams made up of 11 players
              o Number of learners on the reserve list

                                                                                          (9)

 Copyright reserved                                                        Please turn over

### Page 6

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

1.3       Button [1.3 - Calculate]

          The value of       must be calculated using the formula below:

                                              √(        )

          Code has been provided to assign values to the variables rX and rY which
          represent the x and y values in the formula.

          Write code to do the following:

             Use the provided rX and rY variables and appropriate mathematical
              functions to calculate the value of .
             Display the value of       in the edit box edtQ1_3, rounded to THREE
              decimal places.

          Example of output for provided values rX = 12.46 and rY = 8.54:

                                                                                                 (5)

1.4       Button [1.4 - Marathon results]

          Participants who complete a marathon and finish in one of the top 20
          positions will receive a gold, silver or bronze medal, based on their finishing
          position. All other participants who finish after the 20th position will receive a
          participation certificate.

          Code has been provided using an input dialogue box for the user to enter the
          finishing position of a participant. The user input is assigned to the variable
          iPosition.

          Write code that uses a case statement to display an appropriate message in
          the label lblQ1_4 based on the information in the table below.

                         Finishing position      Award
                         1                       Gold medal
                         2 and 3                 Silver medal
                         4 to 20                 Bronze medal
                         After 20                Participation certificate

 Copyright reserved                                                               Please turn over

### Page 7

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

          Example of input and output if a learner achieved the first place:

          Example of input and output if a learner achieved the 20 th place:

          Example of input and output if a learner achieved the 21st place:

                                                                                                  (6)

1.5       Button [1.5 - Average mark]

          A text file called 'Details.txt' contains the names and marks of learners in the
          following format:

                 <Name>#<Mark>

          Example of the first five lines of text in the text file:

                 Erinn Stansell#87
                 Michael Dinjes#90
                 Gabrielle Wadhams#23
                 Mirelda Berendsen#47
                 Elmore Skalls#32

          Write code to do the following:

             Open the text file Details.txt, read through the lines of text in the text file
              and determine the average mark for all the learners.
             Display the average mark on the panel pnlQ1_5, rounded to the nearest
              integer.

          NOTE: Your code must work correctly for any number of lines of text in the
                file.
 Copyright reserved                                                                Please turn over

### Page 8

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

             HINT: Use the position of the hash character (#) to extract the mark for each
                   learner.

             Example of output:

                                                                                                (15)

      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/November 2023
                                          NSC

SECTION B

QUESTION 2: DATABASE PROGRAMMING

Universities rely on effective administration and communication to facilitate the smooth
running of their processes.

A database called UniversityDB.mdb, which contains information on the different
lecturers and the courses they teach, has been developed.

The database contains two tables, tblLecturers and tblCourses.

NOTE:     The data pages attached at the end of the question paper provide information
          on the design of the 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

Downloaded from hlayiso.com
    Information Technology/P1                  10                            DBE/November 2023
                                              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 provided code.
       TWO variables are declared as public variables, as described in the table below.

          Variable              Data type       Description
          tblLecturers          TADOTable       Refers to the table tblLecturers
          tblCourses            TADOTable       Refers to the table tblCourses

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/November 2023
                                             NSC

      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 - Large enrolments]

               Display the details of all the courses in the tblCourses table, that can
               accommodate 100 or more students.

               Example of output of the first five records:

                                                                                                   (3)

      2.1.2    Button [2.1.2 - Lecturer gender]

               Display the LecturerName, LecturerSurname and the first letter of the
               gender of all the lecturers. Display the gender using a column heading
               called Gender (M/F).

               Example of output of the first five records:

                                                                                                   (4)

      2.1.3    Button [2.1.3 - Multilingual lecturers]

               Display the CourseID and CourseName of all courses that have a
               multilingual lecturer. The results must be sorted in alphabetical order
               according to the course name.

Copyright reserved                                                              Please turn over

### Page 12

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

               Example of output of the first five records:

                                                                                                  (6)

      2.1.4    Button [2.1.4 - Lecturer salaries]

               A lecturer's salary is determined by the number of courses facilitated by
               that lecturer. An amount of R10 000 is paid for each course facilitated by
               the lecturer. For example, if a lecturer facilitates three courses, the
               lecturer will get a total salary of R30 000.

               Display the LecturerID and the total salary in a new column with the
               heading Salary, formatted to currency.

               Example of output of the first five records:

                                                                                                  (5)

      2.1.5    Button [2.1.5 - Change online option]

               Write code to change the OnlineOption field to false if the
               CourseName field contains the word 'Programming'.

               Code has been provided to display a message to indicate that the
               content of the database has been changed.

               Example of the first six records of the tblCourses table before the online
               option was changed:

Copyright reserved                                                             Please turn over

### Page 13

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

                Example of the first six records of the tblCourses table after the online
                option was changed to false for the programming courses:

                                                                                                   (4)

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/November 2023
                                              NSC

      2.2.1    Button [2.2.1 - Average duration of courses]

               The workload of all lecturers must be determined in order to issue them
               with a fair number of courses to facilitate.

               Use the redQ2_2_1 component to display the output.

               Code has been provided to clear the redQ2_2_1 component.

               Write code to do the following:

                    Display the LecturerID, LecturerName and LecturerSurname as a
                     heading in the following format:
                     <LecturerID>: <LecturerName> <LecturerSurname>
                    Display a numbered list of course names facilitated by each lecturer.
                    Calculate and display the average duration of the courses facilitated
                     by each lecturer, formatted to TWO decimal places.

               Example of output for the first two lecturers:

                                                                                                    (14)

      2.2.2    Button [2.2.2 - Register new lecturer]

               When a new lecturer is appointed, their details must be added to the
               database.

               Write code to add a new record to the tblLecturers table using the
               following details:

                    LecturerID – ZT032
                    LecturerName – Zander
                    LecturerSurname – Thomas
                    Gender – Male
                    Multilingual – True

Copyright reserved                                                               Please turn over

### Page 15

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

                   Example of records in the tblLecturers table, which indicates that the
                   record has been added to the table successfully:

                                                                                                    (4)

     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/November 2023
                                             NSC

SECTION C

QUESTION 3: OBJECT-ORIENTATED PROGRAMMING

The local schools' district office requires a record of schools in the district and a report
on the results of the schools to determine the amount of funding that each school will
receive.

Do the following:

     Open the incomplete program in the Question 3 folder.
     Open the incomplete object class School_U.pas.
     Enter your examination number as a comment in the first line of both the
      Question3_U.pas file and the School_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.

    Copyright reserved                                                           Please turn over

### Page 17

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

3.1     The provided incomplete object class (TSchool) contains the declaration of four
        attributes which describe a School object.

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

           Attribute            Data type     Description
           fSchoolName          String        The name of the school
           fTotalLearners       Integer       The total number of learners enrolled at the
                                              school
           fPublicSchool        Boolean       True if it is a public school, otherwise false
           fRating              Char          A rating (A, B, C or Z) assigned to each
                                              school based on the percentage pass rate
                                              of the school:

                                                A – 80% or higher
                                                B – From 60% up to 79%
                                                C – Lower than 60%
                                                Z – Rating not assigned

        An incomplete constructor method has been provided.

        NOTE:         You are NOT allowed to add any additional attributes or user-defined
                      methods, unless you are instructed to do so explicitly in one of the
                      questions.

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

        3.1.1         Constructor Create has been provided with three parameters.

                      Write code to complete the constructor method as follows:

                         Assign the values in the parameter list to the corresponding
                          attributes, fSchoolName, fTotalLearners and fPublicSchool.
                         Assign a default rating of 'Z' to the fRating attribute.                   (3)

        3.1.2         Write an accessor method        called   getPublicSchool     for   the
                      fPublicSchool attribute.                                                       (2)

        3.1.3         Every year the rating of the school will be updated based on the
                      percentage pass rate of the school. The percentage pass rate is
                      calculated using the total number of learners who passed and the
                      total number of learners at the school.

                      The information in the table below is used to determine the school's
                      rating:

                                    Rating       Percentage pass rate
                                      A          80% or higher
                                      B          From 60% up to 79%
                                      C          Lower than 60%

 Copyright reserved                                                               Please turn over

### Page 18

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

                      Write code for a method called updateRating to do the following:

                       Receive the total number of learners who passed as a parameter
                        value.
                       Use the parameter value and the fTotalLearners attribute to
                        calculate the percentage pass rate of the school.
                       Use the table provided to determine and set the value of the
                        fRating attribute.                                                            (8)

        3.1.4         An amount of R145,50 is allocated per learner enrolled at the school.

                      Write code for a method called calcFunding to calculate and return
                      the total amount of funding that will be received by the school.

                      The funding is calculated using the following formula:

                          funding = learners enrolled                                                 (4)

        3.1.5         Write code for a toString method to return a string which describes
                      the object. The Boolean attribute fPublicSchool must be used to
                      determine whether the phrase 'Public school' or 'Private school' must
                      be added to the string.

                      The format of the string to be returned is shown below.

                      <fSchoolName>
                      ------------------------
                      Total number of learners: < fTotalLearners >
                      Rating: <fRating>
                      Public school/Private school

                      Example:

                      Alan Turing High School
                      ------------------------
                      Total number of learners: 1250
                      Rating: Z
                      Public school                                                                   (7)

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

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

 Copyright reserved                                                                Please turn over

### Page 19

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

       3.2.1         Button [3.2.1 – Instantiate object]
                     The user must enter the school name in the edit box edtQ3_2_1,
                     select the total number of learners in the spin edit spnQ3_2_1 and
                     tick the check box chbQ3_2_1 if the school is a public school.

                     Write code to do the following:

                        Extract the school name from edit box edtQ3_2_1, the total
                         number of learners in the spin edit spnQ3_2_1 and determine
                         whether the check box chbQ3_2_1 has been checked (ticked) or
                         not.
                        Use the information extracted to instantiate a new School object.
                        Use the toString method to display the information of the School
                         object in the rich edit redQ3.
                     Example of input and output for a public school:

                     Example of input and output for a private school:

                                                                                                (7)

Copyright reserved                                                               Please turn over

### Page 20

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

       3.2.2         Button [3.2.2 – Rating]

                     The rating of a school is determined by the percentage pass rate of
                     the school.

                     The spin edit spnQ3_2_2 must be used to enter the total number of
                     learners who passed.

                     Write code to do the following:
                        Call the updateRating method using the value extracted from the
                         spin edit spnQ3_2_2 as an argument.
                        Call the toString method to display the updated information of the
                         School object in the rich edit redQ3.

                     Example of output if the total number of learners is 1 250 and the total
                     number of learners who passed is 1 183:

                     Example of output if the total number of learners is 1 250 and the total
                     number of learners who passed is 999:

                     Example of output if the total number of learners is 1 250 and the total
                     number of learners who passed is 500:

                                                                                                       (4)

       3.2.3         Button [3.2.3 – Funding]

                     Funding will be available to public schools only. Use the rich edit
                     redQ3 to display the output.

                     Write code to do the following:

                     Use the relevant method to test if the school is a public school.
                        If the school is a public school, call the calcFunding method to
                         display the amount of funding the school will receive, formatted as
                         currency with a message as indicated on the next page.
                        If the school is not a public school, display a suitable message
                         indicating that no funding is available.
Copyright reserved                                                                  Please turn over

### Page 21

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

                         Example of output if the school is a public school and has a total
                         number of 1 250 learners:

                         Example of output if the school is NOT a public school:

                                                                                                         (5)

     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

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

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
      Question4_U.pas file.
     Compile and execute the program. The program has no functionality currently.
     Two tab sheets named tshQ4_1 and tshQ4_2 are provided on the graphical user
      interface (GUI).

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

4.1         Tab sheet [4.1]

            Example of the graphical user interface (GUI) for tab sheet 4.1:

            You have been provided with an array called arrCodes that contains five
            codes. Each code contains letters, digits and special characters.

            arrCodes: array [1 .. 5] of String =

                  ('An7J*Q#D&N','pL78K#$.%BV','89@FGh0&Y56#$Q','Bn4m321&*#T',
                  'P2QwER%$#a');

            A special character refers to a character that is not a letter and not a digit.

    Copyright reserved                                                                Please turn over

### Page 23

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

          Button [4.1 - Codes]

          Write code to do the following:

          Remove all the special characters from each code in the array to create a new
          code. Count how many special characters were removed from each code.

          Add the new code and the number of special characters deleted from it to the
          list box lstQ4_1 in the following format:

                        <New code>(number of special characters deleted)

          NOTE:       Your code must work for any set of data in the array.

          Example of output for the codes currently in the array:

                                                                                                    (12)

4.2      Tab sheet [4.2]

         A school timetable has five days and seven periods per day.

         You have been provided with the following declarations:

         arrDays: array [1 .. 5] of String =
              ('Mon.', 'Tue.', 'Wed.', 'Thu.', 'Fri.');

         arrTimeTable: array [1 .. 5, 1 .. 7] of String;

         arrSubjectCodes: array [1 .. 5] of String =
              ('IT', 'HL', 'ACC', 'PHY', 'MAT');

         NOTE: Code has been provided to do the following:
            Populate the arrTimeTable array by placing the five subject codes IT, HL,
             ACC, PHY and MAT randomly in the array, once per day for the five days.
             There will be two free periods (empty spaces) each day.
            Display the seven periods per day for each of the five days on the
             timetable (Monday to Friday).

 Copyright reserved                                                              Please turn over

### Page 24

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

        Example of the graphical user interface (GUI) for tab sheet 4.2:

         4.2.1       Button [4.2.1 - Extra IT periods]

                     The school principal decided to add four extra periods, once per day
                     (Monday to Thursday), for the subject code 'IT' to the timetable.

                     The extra IT periods must be placed in the arrTimeTable array from
                     Monday to Thursday at the first available period using the code 'IT'.

                     Example of output after the extra IT periods have been placed in the
                     first available periods from Monday to Thursday:

        NOTE:        By default, there will be six free periods available on the timetable
                     after all the subject codes have been placed, including the extra IT
                     periods.

                     Due to the random placement of subject codes, your output may
                     differ from the example above.                                                (6)

Copyright reserved                                                              Please turn over

### Page 25

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

            4.2.2        Button [4.2.2 - Group IT]

                         The IT teacher requested to have both IT periods placed
                         consecutively (one after the other), from Monday to Thursday.

                         Write code to do the following:

                         Rearrange the periods on each day to place the two IT periods one
                         after the other. The first IT period for the day must remain in its place,
                         while the second IT period must be swapped with another period in
                         order to be placed next to the first IT period.

                         Example of output after the IT periods have been grouped together:

                                                                                                        (12)

     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

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

                             INFORMATION TECHNOLOGY P1

 DATABASE INFORMATION FOR QUESTION 2:

The design of the database tables for the database UniversityDB is as follows:

Table: tblLecturers

This table contains the details of the lecturers.

 Field name            Data type       Description
 LecturerID            Text (5)        A unique ID used to identify a lecturer
 LecturerName          Text (25)       The first name of the lecturer
 LecturerSurname       Text (25)       The last name of the lecturer
 Gender                Text (6)        The gender of the lecturer
 Multilingual          Boolean         A field that indicates whether a lecturer can
                                       present a course in more than one language

Example of the records van the tblLecturers table:

Table: tblCourses

This table contains information on the courses offered at the university.

 Field name           Data type       Description
 CourseID             Text (10)       A unique ID used to identify a course
 CourseName           Text (35)       The name of the course
 Duration             Number          The duration of the course (in weeks)
 MaxStudents          Number          The maximum number of students allowed in the
                                      course
 OnlineOption         Boolean         A field that indicates whether an online option is
                                      available to students
 LecturerID           Text (5)        The ID of the lecturer that presents the course

 Copyright reserved                                                            Please turn over

### Page 27

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

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

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

                            PLANNING PAGE 1

Copyright reserved

### Page 29

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

                            PLANNING PAGE 2

Copyright reserved

## Related documents

- [Information Technology P1 Nov 2022 Eng](https://www.hlayiso.com/library/information-technology-p1-nov-2022-eng/d4215e1a-a2c0-4200-94cf-50fa1b11f578) — Information Technology · QP · 2022 · Eng
- [Information Technology P1 Nov 2021 Eng](https://www.hlayiso.com/library/information-technology-p1-nov-2021-eng/17164583-d33b-4fb5-8673-baf85007b1fc) — Information Technology · QP · 2021 · Eng
- [IT P1 Nov 2020 Afr](https://www.hlayiso.com/library/it-p1-nov-2020-afr/379269e7-3731-4176-9d26-e4f9cf72c167) — Information Technology · QP · 2020 · Afr
- [Information Technology P1 Nov 2019 Afr](https://www.hlayiso.com/library/information-technology-p1-nov-2019-afr/0d13fffc-578b-4fce-954d-57bc720bc513) — Information Technology · QP · 2019 · Afr
- [Information Technology P1 Nov 2017 Afr](https://www.hlayiso.com/library/information-technology-p1-nov-2017-afr/d88a56a4-b5e1-412d-9208-031db1d085df) — Information Technology · QP · 2017 · Afr
- [Information Technology P1 Nov 2016 Afr](https://www.hlayiso.com/library/information-technology-p1-nov-2016-afr/320c8009-f78a-4826-8d92-19579f5df5e4) — Information Technology · QP · 2016 · Afr

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

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