# Computer Applications Technology Grade 12 P1 2022 Memo (Eng)

> Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC June Exam 2022 (English), 12 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/computer-applications-technology-p1-may-june-2022-mg-eng/34c86097-71f6-4e9e-b0ea-06f9903e76e1
- Updated: 2026-10-29
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2022
- Exam period: NSC June Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 12

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Computer Applications Technology](https://www.hlayiso.com/library/grade-12/computer-applications-technology) › [Computer Applications Technology Grade 12 P1 2022 Memo (Eng)](https://www.hlayiso.com/library/computer-applications-technology-p1-may-june-2022-mg-eng/34c86097-71f6-4e9e-b0ea-06f9903e76e1)

## About this document

Computer Applications Technology · Grade 12 · NSC June Exam · 2022. Memorandum. 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

                     COMPUTER APPLICATIONS TECHNOLOGY P1

                                             2022

                                MARKING GUIDELINES

MARKS: 150

CENTRE                                                   FINAL MARK
NUMBER

EXAMINATION
NUMBER

QUESTION                 1       2       3          4   5       6      7          TOTAL

POSSIBLE MARK            22      23     25      15      35     15      15           150

CANDIDATE
MARK

MARKER CODE/
SIGNATURE

MODERATED
MARK

                       These marking guidelines consist of 12 pages.

Copyright reserved                                                          Please turn over

### Page 2

Downloaded from hlayiso.com
 Computer Applications Technology/P1               2                                   DBE/2022
                                       SC/NSC – Marking Guidelines

               EXAM NUMBER

 Check the accuracy and skill required before awarding a mark throughout.

 QUESTION 1                                       File name: 1Types                         Total Q1: 22
                                                                             Maximum          Candidate
No                                     Criteria
                                                                               Mark             Mark
1.1    Style: Island Types                                                             1
        Title style applied                                            1
1.2    Image grouping                                                                  1
        Five images grouped                                            1
1.3    Paragraph formatting: Continental islands … volcanic origin.                    2
        Paragraph border: Shadow border                                1
        Border width: 3 pt                                             1
1.4    Drop Cap: O of Oceanic                                                          2
        Lines to drop: 3                                               1
        Distance from text: 1 cm                                       1
1.5    Columns: How many islands … island formation.                                   3
        Text placed in two columns                                     1
        Alignment: Justified                                           1
        Hyphenation applied                                            1
1.6    Image inserted and formatted                                                    4
        Image: 1Seychelles inserted                                    1
        Picture style: Soft Edge Oval                                  1
        Layout option: Through or Tight text wrap                     1
        Position: Top left: 'calmness and', Bottom left: 'sediment,',
          Bottom right: 'which …'                                       1
1.7    Endnote: Magma                                                                  2
        Endnote numbering: I, II, III …                                1
        Endnote text: 'Dangerous'                                      1
1.8    References: Manage Sources: Tarbuck                                             2
        City field: New Jersey                                         1
        Comments field: Island Structure                               1
          (Show All Bibliography Fields)
1.9    Edit Citation                                                                   2
        Author and Year displays  (Only Title suppressed)              1
        Pages: 130-140                                                 1
1.10   Find and Replace                                                                3
        Find: Island – Match case used                                 1
        Find: Island – Find whole words                                1
        Replace with: Symbol  (Webdings, Character code 74)           1
       (Expect 6 or 7 occurrences)
       Total for QUESTION 1                                                          [22]

 Copyright reserved                                                            Please turn over

### Page 3

Downloaded from hlayiso.com
 Computer Applications Technology/P1               3                                     DBE/2022
                                       SC/NSC – Marking Guidelines

                EXAM NUMBER

 Check the accuracy and skill required before awarding a mark throughout.

 QUESTION 2                            File name: 2Top10, 2Confidential                       Total Q2: 23

                                                                               Maximum          Candidate
 No                                    Criteria                                  Mark             Mark
2Top10
2.1      Cover Page                                                                      3
          Title (Top 10 …) moved (not copied) into Title control         1
          Abstract (The world's …) moved into Abstract control           1
          Page break removed                                             1
2.2      Image: below 9. TASMANIA (AUSTRALIA)                                            3
          Height: 5 cm                                                   1
          Width: 10 cm                                                   1
          Alignment: Centred                                             1
2.3      Hyperlink: on heading 8. BALI (INDONESIA) (Alt+F9)                              2
          Hyperlink created on heading                                   1
          Linked to: Top of the Document                                 1
2.4      Page Orientation: Last page                                                     2
          Orientation: Landscape                                         1
          Last page only                                                 1
2.5      SmartArt graphics                                                               4
          1st level shape:     Text inserted: Islands                    1
                                Font colour: White                        1
            2nd level shape:   Shape added: Coral islands                1
                                Shape position: Bottom right              1

2.6      Field: (Alt+F9) { FILENAME \* Upper \* MERGEFORMAT }                            2
          FileName field inserted: 2Top10                                1
          Field format: Uppercase  /Capital letters                      1
2.7      Page numbering                                                                  5
          Automatic page numbering inserted in the footer                1
          No page numbering on the first two pages                       1
          Page numbering starts with 1 on third page and continues       1
          Odd page numbers: Right aligned                                1
          Even page numbers: Left aligned        }
                                                  (If Odd/even selected)
                                                                           1

2Confidential
2.8      Unzip file                                                                      2
          File unzipped                                                  1
          Watermark: Confidential                                        1
         (Accept diagonal or horizontal Confidential watermark)
         Total for QUESTION 2                                                          [23]

 Copyright reserved                                                              Please turn over

### Page 4

Downloaded from hlayiso.com
Computer Applications Technology/P1               4                                           DBE/2022
                                      SC/NSC – Marking Guidelines

                EXAM NUMBER

QUESTION 3                                   File name: 3Population                              Total Q3: 25

     Mark the questions from the formulae and not the values/answers in the cell.
     Check against candidate's actual work (Cell references may differ, depending on the candidate's
      response).
     Candidate may use multiple formulae, cells or 'building blocks' to reach answers.
     Named ranges can be used instead of cell references.
     The answers must still be correct even if changes are made to the existing data.

                                                                                Maximum         Candidate
    No                                Criteria
                                                                                  Mark            Mark

Islands worksheet

3.1       Column B: Formatting                                                            2

             Column Width: 40 pt                                          1
             Wrap text: applied to B8:B55                                 1
3.2       Cell C3:                                                                        2
          =AVERAGE(E8:E55)

             Function: AVERAGE                                            1
             Range: E8:E55                                                1
3.3       Cell C4:                                                                        4
          =COUNTIF(B8:B55,"*part*")

           Function: COUNTIF                                              1
           Range: B8:B55                                                  1
           Criteria: part  *…* (both wildcards)                         2
          (Expected answer: 10)
3.4       Cell C5:                                                                        5
          =SUMIFS(E8:E55,C8:C55,"Oceanic",D8:D55,">1000")
          OR
          =SUMIFS(E8:E55, D8:D55,">1000",C8:C55,"Oceanic")

             Sum range: E8:E55                                            1
             Criteria range 1: C8:C55                                     1
             Criteria 1: "Oceanic"                                        1
             Criteria range 2: D8:D55                                     1
             Criteria 2: >1000                                            1

Copyright reserved                                                                  Please turn over

### Page 5

Downloaded from hlayiso.com
Computer Applications Technology/P1               5                                         DBE/2022
                                      SC/NSC – Marking Guidelines

              EXAM NUMBER

3.5     Column D: Conditional Formatting                                              4

           Icon set: 3 Flags                                               1
           Green flag icon: >=280000                                       1
           Orange flag icon: >=30001  OR >30000                            1
           Value Type: Number                                              1
3.6     Cell F9:                                                                      3
        =E9/D9

           E9  /D9                                                        2
           Formatted to zero decimal places                                1

Polynesia worksheet
3.7     Chart                                                                         5

           Density (in millions) Digtheid (in miljoene) data series graph
            type: Column chart                                              1
           Primary axis display units: Millions                            1
           Area (km2) Oppervlakte (km2) data series: Secondary
            axis                                                            1
           Legend added                                                    1
           Legend appears below – no overlap                               1

        Total for QUESTION 3                                                         [25]

Copyright reserved                                                               Please turn over

### Page 6

Downloaded from hlayiso.com
Computer Applications Technology/P1               6                                             DBE/2022
                                      SC/NSC – Marking Guidelines

                EXAM NUMBER

QUESTION 4                                File name: 4Bookings                                   Total Q4: 15

     Mark the questions from the formulae and not the values/answers in the cell.
     Check against candidate's actual work (Cell references may differ, depending on the candidate's
      response).
     Candidate may use multiple formulae, cells or 'building blocks' to reach answers.
     Named ranges can be used instead of cell references.
     The answers must still be correct even if changes are made to the existing data.

                                                                                   Maximum         Candidate
    No                                 Criteria
                                                                                     Mark            Mark
Travellers worksheet
4.1       Background                                                                        1
           4Logo inserted as background                                      1
4.2       Gridlines                                                                         1
           Gridlines do not display                                          1
4.3       Column B:                                                                         5
          =MID(A10,FIND(" ",A10)+1,LEN(A10))                           OR
          =MID(A10,FIND(" ",A10)+1,LEN(A10)-FIND(" ",A10))             OR
          =RIGHT(A10,LEN(A10)-FIND(" ",A10))

             Function to find space: FIND(" "                                1
             Extract from cell: A10 
                                                                               1
             Function to copy text from space onwards:
               MID +1  OR                                                  2
               RIGHT subtract text before space
             Function to copy text from space to end of text: LEN            1
4.4      Cell I15:                                                                          5
         =VLOOKUP(F15,Cost!$A$3:$D$18,TravelIers!H15+1) OR
         =VLOOKUP(F15,Cost!A1:D18,IF(Travellers!H15="1",2,
          IF(Travellers!H15="2",3,4)))

             Function: VLOOKUP                                               1
             Lookup value: F15                                               1
             Array table: Cost!$A$3:$D$18  OR Cost!$A$1:$D$18                1
             Column index: H15 +1                                           2
Style worksheet
4.5       Subtotal feature (Mark by inspection)                                             3

             At each change in: Travel Style Reisstyl                        1
             Function: Max                                                   1
             Subtotal added to: Group Cost Groepkoste                        1
          Total for QUESTION 4                                                            [15]

Copyright reserved                                                                   Please turn over

### Page 7

Downloaded from hlayiso.com
Computer Applications Technology/P1               7                                     DBE/2022
                                      SC/NSC – Marking Guidelines

                EXAM NUMBER

QUESTION 5                                  File name: 5Details                          Total Q5: 35

                                                                          Maximum           Candidate
 No                                   Criteria
                                                                            Mark              Mark
Table: tbl5_1
5.1.1   Field: Name                                                                 1

           Field size set to 20                                     1
5.1.2   Field: StartDate                                                            2
        Validation Rule: >= #15/03/2012#         OR   >#14/03/2012#

           >=  OR >                                                 1
           #15/03/2012#                                             1
5.1.3   Field: AccessCode                                                           4
        Input Mask: LL\@0009 OR LL"@"0009

           LL                                                       1
           @                                                        1
           000                                                      1
           9  OR        #                                           1
5.1.4   Field: Position                                                             3

           Display control: Combo box                               1
           Row source type: Value list                              1
           Row source:
            Manager; Administrator; Accountant                       1
5.1.5   Field: IDPhoto                                                              2

           Field inserted: IDPhoto                                  1
           Data type: OLE object OR Attachment                     1
Form: frm5_2
5.2        Rectangle control added around the last four fields      1             5
           (Any) Command button control added                       1
           Button Action: Go to Next Record                         1
           Date displays in medium date format                      1
           Date appears in form footer                              1

Copyright reserved                                                           Please turn over

### Page 8

Downloaded from hlayiso.com
Computer Applications Technology/P1               8                                 DBE/2022
                                      SC/NSC – Marking Guidelines

               EXAM NUMBER

Query: qry5_3
5.3         DestinationIsland field moved to be first field        1          3
            Totals option: Group By applied                        1
            LeisureCost field function: Sum                        1

Query: qry5_4 / tblData Query / Query1
5.4         Query created based on: tblData                        1          7
            Only Name, Surname, DateOfBirth and DestinationIsland
             fields displayed                                       1
            Sorted by Surname field in ascending order             1
            DestinationIsland field criteria:
             Bora Bora Island  OR  Cyprus                         3
            LeisureActivity field criteria: Fishing                1
         (Expected number of records: 3)

         (Note to marker: Accept wild card character for Bora Bora
         Island, e.g. B*, Bora*, Bora Bora*)
Query: qry5_5
5.5      Calculated field                                                       5
         60&Older: (Date()–[DateOfBirth])/365.25

            Field name: 60&Older:                                 1
            Current date: (Date()  OR Now()                       1
            Subtract date of birth: –[DateOfBirth])                1
            Expressed as years: /365.25  OR /365                   1
            Field criteria: >=60                                   1
         (Expected number of records: 15)
Report: rpt5_6
5.6      Display                                                                3
          TotalLeisureCost field displays full values              1

         Calculation:
         =AVG([LeisureCost])

            Function: =AVG (…)                                     1
            Field: [LeisureCost]                                  1

         Total for QUESTION 5                                                 [35]

Copyright reserved                                                       Please turn over

### Page 9

Downloaded from hlayiso.com
Computer Applications Technology/P1                9                                         DBE/2022
                                       SC/NSC – Marking Guidelines

               EXAM NUMBER

QUESTION 6                            File name: 6_1Win, 6_2Expensive                         Total Q6: 15

    This question should be marked from the HTML code.
    Numerical attribute values and single words do not need to be in inverted commas.

                                                                               Maximum          Candidate
    No                                 Criteria
                                                                                 Mark             Mark
6_1Win
6.1.1    Font                                                                            1
         <font face="Tempus Sans ITC" size="5">

            Font attribute: face                                         1
6.1.2    Horizontal line                                                                 3
         <hr color="black" size="5"/>             OR
         <hr size="5" color="black"/>             OR
         <hr size="5" color="#000000"/>

            Tag: <hr .../>                                               1
            Attribute: color="black"                                     1
            Attribute: size="5"                                          1
6.1.3    Hyperlink                                                                       2
         <center><a href="https://www.travelstart.co.za/lp/birthday-
         competition"><img src="6_1Button.png"></a></center>

            Anchor tags <a …>… </a> correctly inserted                   1
            Hyperlink created to website                                 1
6.1.4    Heading                                                                         2
         <center><h3>Fun things to do</h3></center>

            Heading: <h3>…</h3>                                          1
            Text inserted: Fun things to do                              1
6.1.5    Ordered List                                                                    2
           <ol>
               <li>Visit Port Louis</li>
               <li>Try Deep Sea Fishing</li>
               <li>Head to Caudan Waterfront</li>
               <li>Shop at Chinatown</li>
            </ol>

            Ordered list tags: <ol> … </ol>                              1
            First list tags inserted: <li>Visit Port Louis</li>          1

Copyright reserved                                                                Please turn over

### Page 10

Downloaded from hlayiso.com
Computer Applications Technology/P1              10                               DBE/2022
                                      SC/NSC – Marking Guidelines

              EXAM NUMBER

6_2 Expensive
6.2     <body>                                                                4
        <center>
          …
          <img src="6_2Cocoa.jpg" width="250 "height="150">
            <img src="6_2Fregate.jpg" width="250" height="150">
           <img src="6_2Mustique.jpg" width="250" height="150">
        <br/>
        <br/>
          <table border="1" width="50%">
              <tr>
                   <th>Island</th>
                   <th>Country</th>
                   <th>Language 1</th>
                  <th>Language 2</th>
              </tr>
              <tr>
                  <td>Cocoa Island</td>
                  <td>Maldives</td>
                  <td align="center">Divehi </td>
               <td align="center" rowspan="5">English</td>
            </tr>
          </table>
        <center>

           Web page centred 
             Center tags inserted correctly                       1
           Image 
             Image inserted with correct width and height         1
           Table  & 
             Table attribute: border="1"                          1
             Cell attribute: rowspan="5"                          1
        Close tag(s) or triangular brackets and nesting correctly             1
        used.                                                      1
        Total for QUESTION 6                                                [15]

Copyright reserved                                                      Please turn over

### Page 11

Downloaded from hlayiso.com
Computer Applications Technology/P1              11                                     DBE/2022
                                      SC/NSC – Marking Guidelines

              EXAM NUMBER

QUESTION 7                   File name: 7Discount, 7Card, 7MergedCard                       Total Q7: 15

                                                                              Maximum         Candidate
 No                                    Criteria
                                                                                Mark            Mark
7Discount
Code worksheet
7.1.1   Cell D2: Nested IF(AND                                                          6
        =IF(AND(YEAR(B2)<1960,C2="Mid-Range"), 5,
        IF(AND(YEAR(B2)<1960,C2="Luxury"),4,0))

        OR
        =IF((AND(YEAR(B2)<1960,C2="Mid-Range"),"5",IF(AND
        (YEAR(B2)<1960,C2="Luxury"),"4","0")))

           Function: YEAR(B2)                                           1
           Criteria 1: Check Date of Birth <1960 AND travel style Mid-
            Range                                                        1
           Output for Criteria 1: Discount code is 5                    1
           Criteria 2: Check year <1960 AND travel style is Luxury      1
           Output for Criteria 2: Discount code is 4                    1
           Output for all other values: 0                               1

        Alternative answer: Cell D2: Nested IF
        =IF(YEAR(B2)<1960,IF(C2="Mid-range",5,IF(C2=
        "Luxury",4,0)),0)

        OR
        =IF(YEAR(B2)>=1960,0,IF(C2="Budget",0,IF(C2= "Mid-
        Range",5,4)))

           Function: YEAR(B2)
           Logical test: Date of Birth >=1960 then travel style Budget
           Output: Discount code is 0
           Criteria: Travel style is Mid-Range
           Output: Discount code is 5
           Output for all other values: 4
List worksheet
7.1.2   Filter                                                                          3
         Filter option switched on                                      1
         Filter criteria: 1979                                          1
         Filter sub-criteria: January, February, March  (3 records)     1

Copyright reserved                                                              Please turn over

### Page 12

Downloaded from hlayiso.com
Computer Applications Technology/P1              12                                DBE/2022
                                      SC/NSC – Marking Guidelines

              EXAM NUMBER

7Card and 7MergedCard
7.2     Mail merge                                                                6
         Recipients' list is filtered to: Travel Style = Luxury            1
         Merge field: Name Naam                                           1
         Merge field: Entrance Code Toegangskode                           1
         Labels updated                                                    1
         Mail merge completed                                              1
         Saved as 7MergedCard                                             1

                                                                                 [15]

                                                                     TOTAL       150

Copyright reserved

## Related documents

- [CAT P1 MEMO GR12 SEPT 2022 English](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2022-english/837c4abb-40c6-4f10-a6eb-4a6db8bfe1b4) — Computer Applications Technology · Memo · 2022 · Eng
- [Computer Applications Technology P1 May June 2019 Memo](https://www.hlayiso.com/library/computer-applications-technology-p1-may-june-2019-memo/513a7ad1-9ade-48ef-b406-7b5d8a936ddf) — Computer Applications Technology · Memo · 2019
- [Computer Application Technology P1 May June 2017 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2017-memo-eng/7e7366e7-46e1-4300-a0da-3e88eb4b2ece) — Computer Applications Technology · Memo · 2017 · Eng
- [Computer Application Technology P1 May June 2016 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2016-memo-eng/fb474999-ae1e-4cfe-b1bd-c4aac95bb1b8) — Computer Applications Technology · Memo · 2016 · Eng
- [Computer Applications Technology P2 May June 2022 Eng](https://www.hlayiso.com/library/computer-applications-technology-p2-may-june-2022-eng/72d0b5ab-f52d-4c0f-9774-0b77bfd2a0ec) — Computer Applications Technology · QP · 2022 · Eng
- [ERRATA CAT P1](https://www.hlayiso.com/library/errata-cat-p1/363f4b7e-98be-46d4-9d47-fcfea8705198) — Computer Applications Technology · Errata · 2022

## More from Grade 12 Computer Applications Technology

- [CAT P1 QP GR12 SEPT 2025 AFRIK watermark](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2025-afrik-watermark/1b848d13-4e0f-4b33-91ef-2fcd3dc2e6b9) — QP · 2025 · Afr
- [CAT P2 GR12 QP September 2025 ENG watermark](https://www.hlayiso.com/library/cat-p2-gr12-qp-september-2025-eng-watermark/fd63d968-a454-409d-9293-0862b56232b1) — QP · 2025 · Eng
- [CAT P1 QP GR12 SEPT 2024 Afrikaans](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-afrikaans/82b87849-4ee6-4b20-8b30-633307bd7329) — QP · 2024 · Afr
- [CAT P1 QP GR12 SEPT 2024 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-english/bf2518c3-ae79-4251-8145-1b062895b12f) — QP · 2024 · Eng
- [CAT P2 GR12 QP SEPT 2024 English](https://www.hlayiso.com/library/cat-p2-gr12-qp-sept-2024-english/b8b0a9f3-f8c6-4f0a-8ddf-30b58008b603) — QP · 2024 · Eng
- [Computer Applications Technology P1 Nov 2024 Afr](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2024-afr/502fe6df-4d11-41d1-8e23-b219565e715b) — QP · 2024 · Afr

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