# Information Technology Grade 12 P1 2024 QP (Eng)

> Grade 12 Information Technology Paper 1 question paper from the Eastern Cape Prelim Exam 2024 (English), 25 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/it-p1-gr12-qp-sept-2024-english/ff8a458b-9f31-4234-8c81-2bce6eba0241
- Updated: 2026-09-27
- Subject: Information Technology
- Grade: Grade 12
- Language: English
- Document type: Question paper
- Year: 2024
- Exam period: Eastern Cape Prelim Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 25

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 2024 QP (Eng)](https://www.hlayiso.com/library/it-p1-gr12-qp-sept-2024-english/ff8a458b-9f31-4234-8c81-2bce6eba0241)

## About this document

Information Technology · Grade 12 · Eastern Cape Prelim Exam · 2024 · English. Question paper, 25 pages. Read online or download the PDF.

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

## Matching paper and memo

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

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

                     SEPTEMBER 2024

               INFORMATION TECHNOLOGY P1

MARKS:   150

TIME:    3 hours

                     This question paper consists of 25 pages.

                    Hosted by www.ecexams.co.za.

### Page 2

Downloaded from hlayiso.com
2                             INFORMATION TECHNOLOGY P1                     (EC/SEPTEMBER 2024)

INSTRUCTIONS AND INFORMATION

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

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

3.     This question paper is set with programming terms that are specific to Delphi
       programming language.

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

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

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

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

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

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

10.    Make sure that your name appears as a comment in every program that you
       code, as well as on every event indicated.

11.    If required, print the programming code of all the programs/classes that you
       completed. You will be given half an hour printing time after the examination
       session.

12.    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.
       Make sure that all files can be read.

13.    Save your work regularly.

Copyright reserved                                                             Please turn over

                           Hosted by www.ecexams.co.za.

### Page 3

Downloaded from hlayiso.com
(EC/SEPTEMBER 2024)                INFORMATION TECHNOLOGY P1                                        3

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 password-protected executable file:
        •   DataENGAug2024.exe
        •   Click on the ‘Extract’ button.
        •   Enter the following password: #Crypto@Aug2024

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

        Question 1:                             Question 3:
        Question1_P.dpr                         Crypto_U.pas
        Question1_P.dproj                       Question3_P.dpr
        Question1_P_Icon.ico                    Question3_P.dproj
        Question1_U.dfm                         Question3_P_Icon.ico
        Question1_U.pas                         Question3_U.dfm
                                                Question3_U.pas

        Question 2:                             Question 4:

        CryptoExchange.mdb                      Crypto.txt
        CryptoExchangeBackUp.mdb                Question4_P.dpr
        dbConnection_u.pas                      Question4_P.dproj
        Question2_P.dpr                         Question4_P_Icon.ico
        Question2_P.dproj                       Question4_U.dfm
        Question2_P_Icon.ico                    Question4_U.pas
        Question2_U.dfm
        Question2_U.pas

Copyright reserved                                                                    Please turn over

                            Hosted by www.ecexams.co.za.

### Page 4

Downloaded from hlayiso.com
4                              INFORMATION TECHNOLOGY P1                      (EC/SEPTEMBER 2024)

QUESTION 1: GENERAL PROGRAMMING SKILLS

SCENARIO

Cryptocurrencies have once again surged in popularity. Given the rapid advancement in
existing and emerging cryptocurrency technologies, grasping the fundamentals, security
protocols, and practical applications is imperative. Your task is to devise programming
solutions for the following questions pertaining to cryptocurrencies.

Do the following:
• Open the incomplete program in the Question 1 folder.
• Enter your full name as a comment in the first line of the Question1_U.pas file.
• Compile and execute the program. Currently the program has no functionality.

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.4 that follow.

1.1       Button [1.1 – Panel Properties]

          Code the button btn1_1 to change the properties of panel pnlOutput as
          follows:

          1.   Set the font type to Arial.
          2.   Set the font size to 16.
          3.   Set the font to Bold and Italic.
          4.   Set the text to display on the right hand side of the panel.
          5.   Change the caption to ‘Crypto Exchange’.

Copyright reserved                                                               Please turn over

                            Hosted by www.ecexams.co.za.

### Page 5

Downloaded from hlayiso.com
(EC/SEPTEMBER 2024)              INFORMATION TECHNOLOGY P1                                 5

        Example of output:

                                                                                            (6)

 1.2    Button [1.2 – Share Coins]
        Three friends Tom, Jerry, and Andile, purchased Ethereum coins when the price
        was still low. They decide to ‘cash out’ now. You need to share the coins in the
        ratio 3 : 4 : 5 respectively. The number of coins bought is provided by the user
        in the edit box edtInput. If there are remaining coins, they will not be shared
        amongst the friends but rather left in the exchange for growth.
        *****Note that each coin will be treated as a full coin and no decimal values
        should be produced or displayed.*****

        Code the button btn1_2 to calculate how many coins each friend will receive,
        and how many coins will remain after sharing takes place. Output in the label
        lbl1_2 as per example screenshots. Ensure the correct use of apostrophes and
        enter spaces.
           Output if 56 coins were purchased.     Output if 12 coins were purchased.

                                                                                           (10)

Copyright reserved                                                           Please turn over

                          Hosted by www.ecexams.co.za.

### Page 6

Downloaded from hlayiso.com
6                             INFORMATION TECHNOLOGY P1                      (EC/SEPTEMBER 2024)

1.3     Button [Q1.3 – Password]

        Crypto accounts require strong passwords. You are thus required to write an
        algorithm that will generate a strong password.

        Code the button btn1_3 to generate a password based on the following rules.

        The password must contain the letters “CRYPTO”.

        1.   Loop through each letter of the word “CRYPTO”.
        2.   For each letter, randomly generate characters from ‘A’ to ‘Z’ until you find a
             character that matches the corresponding letter in “CRYPTO”.
        3.   Count the number of randomisations required to find the matching
             character.
        4.   Append the count of randomisations followed by the matched character
             (must be lowercase) to the password.
        5.   Repeat steps 2–4 for each letter in “CRYPTO”.
        6.   Display the generated password in the label lbl1_3.                               (12)

        Example of output (NOTE: each output will differ due to the random counts of
        each character).

Copyright reserved                                                              Please turn over

                           Hosted by www.ecexams.co.za.

### Page 7

Downloaded from hlayiso.com
(EC/SEPTEMBER 2024)                INFORMATION TECHNOLOGY P1                                  7

1.4    Button [Q1.4 – ASCII Art]

       Some of the MEME coins would like their branding to involve ASCII Art (art made
       from characters).

       Code the button btn1_4 to generate a pattern based on the following rules:
       1.   Prompt the user to input the length of the longest line for the pattern.
       2.   Construct the pattern using the character ‘&’.
       3.   Begin with a single ‘&’ character on the first line.
       4.   For each subsequent line, add one ‘&’ character to the end of the previous
            line.
       5.   After reaching the maximum number of characters, begin removing ‘&’
            characters from the beginning of each line until only one ‘&’ character remains
            on the last line.
       6.   Display the generated pattern in the rich edit redOutput.
       Example output:

            Output for maximum length of 5.        Output for maximum length of 10.

                                                                                               (7)

       •    Enter your name and surname as a comment in the first line of the program
            file.
       •    Save your program.
       •    A printout of the code may be required.

                                                                                              [35]

Copyright reserved                                                              Please turn over

                            Hosted by www.ecexams.co.za.

### Page 8

Downloaded from hlayiso.com
8                             INFORMATION TECHNOLOGY P1                   (EC/SEPTEMBER 2024)

QUESTION 2: SQL AND DATABASE PROGRAMMING

An application is required that will use the CryptoExchange.mdb database to manage the
data and queries of cryptocurrency traders.

The database contains two tables called tblMembers and tblCrypto.

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

Do the following:

•   Open the incomplete program in the Question 2 folder.
•   Enter your full name as a comment in the first line of the Question2_U.pas unit file.
•   Compile and execute the program. The program has limited functionality.
•   The contents of the tables are displayed as shown below on the selection of tab sheet
    Question 2.2

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

Copyright reserved                                                           Please turn over

                           Hosted by www.ecexams.co.za.

### Page 9

Downloaded from hlayiso.com
(EC/SEPTEMBER 2024)               INFORMATION TECHNOLOGY P1                                9

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.
• THREE variables are declared as public variables, as described in the table below:

           Variable      Data type                        Description
       tblCrypto        TADOTable       Refers to the data stored in the table tblCrypto
       tblMembers       TADOTable       Refers to the data stored in the table
                                        tblMembers
       qryInfo          TADOQuery       Query component that will query the two tables
                                        tblCrypto and tblMembers
2.1    Tab Sheet [Question 2.1]

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

       NOTE:
       • Use ONLY SQL code to answer QUESTION 2.1.1 to QUESTION 2.1.6.
       • Code to execute the SQL statements and display the results of the queries is
          provided. The SQL statements that will be assigned to the variables sSQL1,
          sSQL2, sSQL3, sSQL4, sSQL5, and sSQL6 are incomplete.
       Complete the SQL statements to perform the tasks described in QUESTION 2.1.1 to
       QUESTION 2.1.6 below.

Copyright reserved                                                           Please turn over

                          Hosted by www.ecexams.co.za.

### Page 10

Downloaded from hlayiso.com
10                             INFORMATION TECHNOLOGY P1                    (EC/SEPTEMBER 2024)

     2.1.1   Button [Q2.1.1]

             Write SQL code to display all the fields of all the members, sorted by the
             age of the member from youngest to oldest.

             Example of output (first 15 records):

                                                                                            (3)

     2.1.2   Button [Q2.1.2]

             Write SQL code to display the various types of Crypto available as well as
             the total amount of Crypto in each type.

             Example of output:

                                                                                            (4)

     2.1.3   Button [Q2.1.3]

             The user would like to know how many members celebrate their birthday in
             a certain month. Code has been provided to allow the user to fill in the
             month using an input box.

Copyright reserved                                                             Please turn over

                            Hosted by www.ecexams.co.za.

### Page 11

Downloaded from hlayiso.com
(EC/SEPTEMBER 2024)                INFORMATION TECHNOLOGY P1                                   11

              Write SQL code to display the number of birthdays that will be celebrated in
              the month chosen in the input box. Name the calculated field “Birthdays in
              [the correct month]”. You may make use of the provided constant array:
              ARRMONTHS.

              Example of output:

                 Input = 1                              Input = 6

                Input = 10
                                                                                                    (6)

     2.1.4    Button [Q2.1.4]

              You would like to see all the members who have Litecoin with the value of
              over R5 500. A variable with Litecoin’s exchange value has been declared
              and assigned for you.

              Write a SQL statement to display the Surname, Firstname, CryptoType,
              Amount, and the value of the Litecoin for that person. Name the calculated
              field “Value” and it must be displayed in Rands.

              Example of output:

                                                                                                    (9)

     2.1.5    Button [Q2.1.5]
              All investors have decided to burn their Ripple wallets.
              Write a SQL statement to delete all Ripple entries.
              NOTE: Since all Ripple is now removed, if you click on btn2.1.2, the following
              will output.

                                                                                                    (3)

Copyright reserved                                                              Please turn over

                             Hosted by www.ecexams.co.za.

### Page 12

Downloaded from hlayiso.com
12                            INFORMATION TECHNOLOGY P1                     (EC/SEPTEMBER 2024)

     2.1.6    Button [Q2.1.6]
              Bitcoin has started with its Bitcoin halving process.
              Write a SQL statement to change all of the Bitcoin amounts to half of their
              current amount.
              NOTE: Since Bitcoin has halved in amount, you can check your output
              using btn2.1.2, the following will output.

                                                                                             (3)

2.2 Tab Sheet [Question 2.2]
     Example of the graphical user interface (GUI) for QUESTION 2.2.

     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.
     • Use the global variables, tblMembers and tblCrypto, provided.

Copyright reserved                                                             Please turn over

                           Hosted by www.ecexams.co.za.

### Page 13

Downloaded from hlayiso.com
(EC/SEPTEMBER 2024)                    INFORMATION TECHNOLOGY P1                                     13

    2.2.1   Button [Q2.2.1]

            Member details need to be displayed when a user searches for a member.
            Code has been provided to you to extract the surname from the edit box as well
            as loop through the Members table.

            Write code to search in the loop if a member exists. If they exist, output to the
            rich edit redOutput as per example screenshot (Name, Surname, E-Mail,
            Gender).

            Example of output:

             If “Lightwood” was entered in the search.   If “Soap” was entered in the search.

                                                                                                          (5)

    2.2.2   Button [Q2.2.1]

            Currently 50 members are registered in the Members table. A request was
            made to display the various genders and how many of each gender owned
            some form of Cryptocurrency. NOTE: There are only FOUR gender types
            registered.

            Code has been provided to you to display the heading Total Members = 50.
            Write code to loop through the Members table and tally the various genders.
            Output to the rich edit redOutput as per example screenshots. Add a test to
            determine if your total gender count is the same or different to the original.

            You may make use of standard variables or arrays to solve this question.

            Example of output:

             If all data is correct.                     If data is incorrect. In this case faulty
                                                         spelling: Females instead of Female

                                                                                                        (12)

•    Enter your name and surname as a comment in the first line of the program file.
•    Save your program.
•    A printout of the code may be required.

                                                                                                        [45]

Copyright reserved                                                                   Please turn over

                              Hosted by www.ecexams.co.za.

### Page 14

Downloaded from hlayiso.com
14                            INFORMATION TECHNOLOGY P1                     (EC/SEPTEMBER 2024)

QUESTION 3: OBJECT-ORIENTED PROGRAMMING

Traders can create a Crypto account and select one of three different
Cryptocurrencies: Bitcoin, Ethereum or Litecoin. Once they have created their
account, they can purchase their chosen crypto asset by entering a Rand value they
are willing to spend. The program will determine the correct amount of the crypto asset
based on the exchange rate of the cryptocurrency. Since Cryptocurrencies fluctuate
so much, traders can view the current value of their crypto asset in the “Live” viewer.
The program updates every second and will display whether the trader has made a
Profit or a Loss based on their original purchase value.

Do the following:

• Open the incomplete program in the Question 3 folder.
• Open the incomplete object class Crypto_U.pas.
• Enter your full name as a comment in in the first line of both the Crypto_U.pas file
  and the Question3_u.pas file.
• Compile and execute the program. The program has limited functionality currently.
• Do NOT remove or change any provided code.

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

                           Hosted by www.ecexams.co.za.

### Page 15

Downloaded from hlayiso.com
 (EC/SEPTEMBER 2024)               INFORMATION TECHNOLOGY P1                                  15

Open the incomplete object class Crypto_U.pas.

3.1 The provided incomplete class (TCrypto) contains the declaration of six attributes that
    describe the objCrypto object.

          Name of
                                                    Description
         attributes
      fFirstName        String value containing trader’s first name
      fSurname          String value containing trader’s surname
      fCrypto           Integer value containing which Cryptocurrency the trader selected
      fAmount           Real value containing the Cryptocurrency amount
      fOriginalValue    Real value containing the money originally spent by the trader
      fCurrentValue     Real value containing the current value in Rands of the trader’s
                        Cryptocurrency

     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 named Create that will receive the
              following parameters:
               • First name
               • Surname
               • Cryptocurrency (value ranging between 0 and 2)
              Assign these parameter values to the correct attributes and set the remaining
              attributes to a default value of 0.                                                  (5)

     3.1.2    Write an accessor method called getCryptoName that returns the full name
              of the cryptocurrency based on the fCrypto field attribute. The mapping is as
              follows:
              •   0 = Bitcoin
              •   1 = Ethereum
              •   2 = Litecoin
              Uncomment the code in the toString method.                                           (4)

 Copyright reserved                                                            Please turn over

                            Hosted by www.ecexams.co.za.

### Page 16

Downloaded from hlayiso.com
16                              INFORMATION TECHNOLOGY P1                      (EC/SEPTEMBER 2024)

     3.1.3   Write code for a mutator method called setAmount that receives a value
             (purchase value of cryptocurrency) as a parameter.
             Set the fAmount attribute based on the following rules by multiplying the
             purchase value (received by the main unit) with the exchange rate:

                                     fCrypto    Conversion rate
                                        0       1 : 1 000 000
                                        1       1 : 50 000
                                        2       1 : 2 500

             Exchange Rate Calculation: 1 ÷ 1000000 = 0.000001

             Set the fOriginalValue attribute to the purchase value received from the
             main unit. This value must be able to update as more cryptocurrency of the
             same type is purchased.                                                             (7)

     3.1.4   Write code for a mutator method called setValue. This method will set the
             fCurrentValue parameter to the current exchange of the cryptocurrency
             (fAmount * exchange rate). Since cryptocurrencies are so volatile and
             constantly fluctuate, the conversion rates will be based on random values
             between certain ranges.

             Set the fCurrentValue attribute based on the following rules:

                      fCrypto    Currency rate is a random value (both
                                 values inclusive)
                          0                  400 000 – 1 600 000
                          1                    25 000 – 75 000
                          2                      500 – 3000                                      (5)

     3.1.5   Write a method called calcProfitLoss that will return a string value of a
             ‘Profit’, ‘Loss’ or ‘Even’.

             The method will make use of the object’s attributes to determine the output.
             • If the current value is greater than the original price, then it is a profit.
             • If the current value is less than the original price, then it is a loss.
             • If the current value is equal to the original price, then it is even.             (6)

Copyright reserved                                                                 Please turn over

                              Hosted by www.ecexams.co.za.

### Page 17

Downloaded from hlayiso.com
 (EC/SEPTEMBER 2024)                INFORMATION TECHNOLOGY P1                                   17

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 objCrypto.
      Write code to perform the tasks described in QUESTION 3.2.1 to QUESTION 3.2.3
      below.

      3.2.1    Button [3.2.1 – Instantiate Crypto Object]

               Write code to do the following:
               • Extract the name from the edit box edtName, the surname from the edit
                  box edtSurname and the number from the radio group rgpCrypto.
               • Use the information to instantiate the new Crypto object.
               • Display a message to the user that the Crypto Account has been created.              (6)

      3.2.2    Button [3.2.2 - Purchase Crypto]

                The crypto trader will enter their desired purchase price into the edit box.

                Write code to do the following:
                • Extract the price from the edit box edtMoney.
                • Call the setAmount method using the value from the edit box.                        (2)

      3.2.3    Timer [tmrLive]

                When the Live button is pressed, the program will update every second and
                display the current value of the cryptocurrency along with whether the trader
                has made a profit or a loss compared to their original purchase value.

                Write code on the timer tmrLive to do the following:
                • Call the setValue method.
                • Use the toString method to display the information of the updated
                    Crypto object in the rich edit redOutput.
                • Use the calcProfitLoss method to display the updated Crypto object
                    in the panel pnlOutput.

               Example of output if Joe Soap bought R50 000 of Ethereum: Rand values
               will be random.

                                  Profit                                    Loss

 Copyright reserved                                                                Please turn over

                             Hosted by www.ecexams.co.za.

### Page 18

Downloaded from hlayiso.com
18                           INFORMATION TECHNOLOGY P1                     (EC/SEPTEMBER 2024)

        Example of output if Lutho Mzi bought R10 000 of Bitcoin:

                         Profit                                     Loss

                                                                                                  (5)

        •   Enter your name and surname as a comment in the first line of the program
            file.
        •   Save your program.
        •   A printout of the code may be required.

                                                                                                 [40]

Copyright reserved                                                            Please turn over

                          Hosted by www.ecexams.co.za.

### Page 19

Downloaded from hlayiso.com
(EC/SEPTEMBER 2024)               INFORMATION TECHNOLOGY P1                                 19

QUESTION 4: PROBLEM-SOLVING PROGRAMMING

The cryptocurrency market consists of trillions of rands worth of money. This application
has been created to view 20 popular cryptocurrencies, along with their market capitalisation
in USD and currency value in ZAR (South African Rand).

Do the following:

•   Open the incomplete program in the Question 4 folder.
•   Enter your full name as a comment in in the first line of the Question4_u.pas file.
•   Compile and execute the program. The program has limited functionality currently.
•   Do NOT remove or change any provided code.

Example of the graphical user interface (GUI):

Copyright reserved                                                             Please turn over

                           Hosted by www.ecexams.co.za.

### Page 20

Downloaded from hlayiso.com
20                               INFORMATION TECHNOLOGY P1                           (EC/SEPTEMBER 2024)

The following have been provided in the program:

•     A text file called Crypto.txt holds data about 20 different cryptocurrencies
      in the following format:
Cryptocurrency Name, Symbol, Current Price in Rand (ZAR) Market Capitalisation in Dollars (USD).

•     A counter variable has been instantiated to store the number of
      cryptocurrencies from the text file.

•     A two-dimensional array called ar2Crypto has been instantiated for you.

•     This array will be used to store the data from the text file about the 20 different
      cryptocurrencies.

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

4.1     Button [4.1 – Read contents]

        The data from the text file Crypto.txt needs to be read into the two-dimensional
        array ar2Crypto. Each row of the array should represent a cryptocurrency and
        each column should hold the respective data field (Name, Symbol,
        CurrentPriceInZAR, MarketCapInUSD).

        Write code to do the following:
        • Read the data from the text file Crypto.txt and populate the two-
          dimensional array ar2Crypto.
        • Include any necessary error handling for opening the text file.                             (12)

4.2     Button [4.2 – Display]

        The contents of the two-dimensional ar2Crypto must be displayed neatly in a
        tabular format.

        Write code to do the following:
        •   Display the contents of the two-dimensional array in the rich edit
            redOutput.
        •   Ensure that the output is well-aligned.

Copyright reserved                                                                       Please turn over

                              Hosted by www.ecexams.co.za.

### Page 21

Downloaded from hlayiso.com
(EC/SEPTEMBER 2024)              INFORMATION TECHNOLOGY P1                21

       Example of output:

                                                                                (5)

Copyright reserved                                           Please turn over

                            Hosted by www.ecexams.co.za.

### Page 22

Downloaded from hlayiso.com
22                             INFORMATION TECHNOLOGY P1                   (EC/SEPTEMBER 2024)

4.3    Button [4.3 – Sort]
       Cryptocurrencies are ranked according to their market capitalisation.
       Write code to do the following:
       • Sort the two-dimensional array based on the current market capitalisation in
           descending order.
       • Display the contents of the sorted two-dimensional array in the rich edit
           redOutput.
       Example of output:

                                                                                             (10)

4.4    Button [4.3 – Total market cap]
       The total market capitalisation is the sum of the MarketCapInUSD values for all
       cryptocurrencies stored in the two-dimensional array.
       Write code to do the following:
       • Calculate the total market capitalisation and convert it to a rand (ZAR)
           value. The current exchange rate is:
                    1 USD = 18 ZAR
       • Display the total market capitalisation in the rich edit redOutput.
       Example of output:

                                                                                              (3)

       •   Enter your name and surname as a comment in the first line of the program
           file.
       •   Save your program.
       •   A printout of the code may be required.

                                                                                             [30]

                                                                                 TOTAL:      150
Copyright reserved                                                             Please turn over

                             Hosted by www.ecexams.co.za.

### Page 23

Downloaded from hlayiso.com
(EC/SEPTEMBER 2024)                INFORMATION TECHNOLOGY P1                                 23

                           INFORMATION TECHNOLOGY P1

DATABASE INFORMATION QUESTION 2:

The database CryptoExchange consists of tables tblMembers and tblCrypto.

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

The design of the database tables is as follows:

Table: tblMembers – This table contains details of the crypto trader members.

 Field Name           Data Type            Description
 MemID                Number               Unique ID for the crypto trader
 Surname              Text (30)            The surname of the crypto trader
 FirstName            Text (20)            The name of the crypto trader
 DateOfBirth          Date/Time            The date of birth of the crypto trader
 E-Mail               Text (255)           The email address of the crypto trader
 Gender               Text (20)            The gender of the crypto trader

Copyright reserved                                                              Please turn over

                          Hosted by www.ecexams.co.za.

### Page 24

Downloaded from hlayiso.com
24                           INFORMATION TECHNOLOGY P1                       (EC/SEPTEMBER 2024)

Example of the first few records in the tblMembers table:

Table: tblCrypto – This table contains details of the crypto transactions.

 Field Name            Data Type            Description
 ExchangeID            Number               Unique ID for the crypto trader
 MemID                 Number               The ID for the crypto trader who made crypto
                                            transaction
 ExchangeName          Text (20)            The crypto exchange name
 CryptoType            Text (30)            The crypto type
 Amount                Number               The amount of crypto purchased in the
                                            transaction
 DatePurchased         Date/Time            Date the purchase transaction was made

Copyright reserved                                                              Please turn over

                           Hosted by www.ecexams.co.za.

### Page 25

Downloaded from hlayiso.com
(EC/SEPTEMBER 2024)              INFORMATION TECHNOLOGY P1                25

Example of the first few records in the tblCrypto table:

Copyright reserved                                           Please turn over

                          Hosted by www.ecexams.co.za.

## Related documents

- [IT P2 MEMO GR12 SEPT 2024 English](https://www.hlayiso.com/library/it-p2-memo-gr12-sept-2024-english/4d74acb4-cb8b-4fd3-874f-4801fbcb8f44) — Information Technology · Memo · 2024 · Eng
- [INFORMATION TECHNOLOGY P1 GR 12 QP SEPT2020 English](https://www.hlayiso.com/library/information-technology-p1-gr-12-qp-sept2020-english/54a79498-b880-4b85-a745-f97411d425cb) — Information Technology · QP · 2020 · Eng
- [IT P1 GR12 QP SEPT 2019 English](https://www.hlayiso.com/library/it-p1-gr12-qp-sept-2019-english/13baa4c0-c4fc-48ad-be32-a39f4775b286) — Information Technology · QP · 2019 · Eng
- [IT P1 GR12 QP SEPT2018 English](https://www.hlayiso.com/library/it-p1-gr12-qp-sept2018-english/b77b5a5f-75b4-4d23-aaa6-5ab3653b9aeb) — Information Technology · QP · 2018 · Eng
- [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
- [IT P1 GR12 MEMO SEPT 2022 English](https://www.hlayiso.com/library/it-p1-gr12-memo-sept-2022-english/6e7cbe6a-69aa-4c7d-bcd4-dcfeaf4c8272) — Information Technology · Memo · 2022 · Eng

## More from Grade 12 Information Technology

- [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
- [IT P2 GR12 QP SEPT2022 English](https://www.hlayiso.com/library/it-p2-gr12-qp-sept2022-english/59a4dc5f-1ee1-44b9-b838-76b7e9322abb) — QP · 2022 · Eng
- [Information Technology P2 May June 2021 Eng](https://www.hlayiso.com/library/information-technology-p2-may-june-2021-eng-1/7454979b-cba2-4b39-a884-69e6b1c0f5c6) — QP · 2022 · Eng
- [Information Technology P2 May June 2021 Afr](https://www.hlayiso.com/library/information-technology-p2-may-june-2021-afr-1/500d3219-d02f-4c1c-af0e-452a5fe87f3b) — 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) — QP · 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.
