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

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

- Page: https://www.hlayiso.com/library/computer-applications-technology-p1-may-june-2025-mg-eng/8beb5c31-24fa-4cf4-b90c-aedcc234a4dd
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Language: English
- Document type: Memorandum
- Year: 2025
- Exam period: NSC June Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 14

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 2025 Memo (Eng)](https://www.hlayiso.com/library/computer-applications-technology-p1-may-june-2025-mg-eng/8beb5c31-24fa-4cf4-b90c-aedcc234a4dd)

## About this document

Computer Applications Technology · Grade 12 · NSC June Exam · 2025 · English. Memorandum, 14 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

SENIOR CERTIFICATE EXAMINATIONS/
         NATIONAL SENIOR CERTIFICATE EXAMINATIONS

                     COMPUTER APPLICATIONS TECHNOLOGY P1

                                       MAY/JUNE 2025

                                MARKING GUIDELINES

MARKS: 150

 CENTRE-                                                  FINAL MARK
 NUMBER

 EXAMINATION
 NUMBER

 QUESTION                  1      2       3       4      5       6     7       TOTAL

 POSSIBLE MARK            27      18      16     24      35      15    15        150

 CANDIDATE'S
 MARK

 MARKER'S CODE/
 SIGNATURE

 MODERATED
 MARK

                      These marking guidelines consists of 14 pages.

Copyright reserved                                                     Please turn over

### Page 2

Computer Applications Technology/P1                  2                       DBE/May/June 2025
                                         SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

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

QUESTION 1                                  File name: 1eSports                         Total Q1: 27

                                                                           Maximum       Candidate
 No.                                  Criteria
                                                                             Mark          Mark
1.1      File properties                                                          1
         • Status: eSports                                            1
1.2      Drop caps: e…                                                             2
         • Position: Dropped                                          1
         • Lines to drop: 5                                           1
1.3      Style: Win                                                                3
         • Text effect: Preset: Glow: 8 point; Orange …               1
         • Font: Character spacing
             o Scale: 150%                                            1
             o Spacing: Expanded                                      1
1.4      Find and Replace: games                                                   3
         • Text: 'games' replaced                                     1
         • Format: Styles: Win Char                                   1
         • 11 occurrences (Match case & Whole words)                  1
1.5      Image: How eSports Competitions …                                         3
         • Picture Style: Rotated, White                              1
         • Border colour: Light Blue                                  1
         • Artistic Effects: Paint Strokes                            1
1.6      Footnote/Endnote                                                          2
         • Format: Footnote/Endnote symbol:  Webdings                 1
           character code 185  (symbol changed in text and
           endnote/footnote)
         • Footnote converted to Endnote                              1
1.7      Bookmark: Sponsor                                                         2
         • Bookmark: Organiser changed to Sponsor                     1
         • Link to: Riot Games                                        1
1.8      SmartArt                                                                  3
         • Layouts: Vertical arrow list                               1
         • Shapes added after 2000s: Rise of …                        1
         • All text is in correct shape                               1
1.9      Page layout: SmartArt page                                                2
         • Section breaks inserted  (last two pages only)             1
         • Orientation: Landscape                                     1

Copyright reserved                                                             Please turn over

### Page 3

Computer Applications Technology/P1                3                     DBE/May/June 2025
                                       SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

1.10     Footer                                                                2
         • Type: ViewMaster (Vertical)                              1
         • Page number format: A, B, C, …                           1
1.11     Convert text to table                                                 4
         • All text converted to appear in table                    1
         • Second table merge with first table                      1
         • AutoFit content                                          1
         • Last row: Formula: =SUM(ABOVE)                           1
         Total for QUESTION 1                                                 [27]

Copyright reserved                                                         Please turn over

### Page 4

Computer Applications Technology/P1                   4                       DBE/May/June 2025
                                          SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

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

QUESTION 2                                   File name: 2Stats                            Total Q2: 18

                                                                            Maximum        Candidate
No.                                   Criteria
                                                                              Mark           Mark
2.1     Cover page                                                                   2
        • Built-in: Slice (Dark)                                       1
        • Document Title: Statistics                                   1
2.2     Columns: 'Viewer Demographics … and sponsorship                              4
        opportunities.'
        • Converted to 2 columns                                       1
        • Spacing: 1.5 cm                                              1
        • Line between: selected/checked                               1
        • Column break inserted before: 'The relationship
          between'                                                     1
2.3     Bullet list: below text 'The following list …'                               1
        • Bullets (♦) applied to the complete list                     1
2.4     Image AND WordArt                                                            3
        • Cropped to Star: 10 points                                   1
        • WordArt text appears on top of image                         1
        • All text and image grouped                                   1
2.5     Linked table                                                                 3
        • 2Team: Object (Data) inserted                                1
        • Linked object                                                1
        • Displays contents of 2Team                                   1

        Alt+F9: { LINK Excel.Sheet.12 … }
2.6     Page border                                                                  2
        • Any 3-line page border inserted                              1
        • Position: Left and right side only                           1
2.7     Text Field                                                                   3
        • Field: NumWords inserted                                     1
        • Format: First, Second, Third, …                              1
        • Text Direction feature: Horizontal                           1

        Alt+F9: { NUMWORDS \* OrdText \* MERGEFORMAT }
        Total for QUESTION 2                                                       [18]

Copyright reserved                                                              Please turn over

### Page 5

Computer Applications Technology/P1                  5                       DBE/May/June 2025
                                         SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

QUESTION 3                            File name: 3Rank                                Total Q3: 16

•     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).
•     Candidates 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
    (Sheet 1) Medals worksheet
    3.1    Sheet 1: Rename                                                        2
           • Renamed: Medals                                          1
           • Worksheet moved to be the last sheet                     1
    Players worksheet
    3.2    Row 5: Format cells                                                    2
           • Alignment: Text control: Wrap text selected              1
           • Alignment: Horizontal: Centre                            1
    3.3    Cell D3:                                                               2
           =LARGE(D6:D59,4)

           •   Function: LARGE(D6:D59, …)                             1
           •   Number: 4                                              1
    3.4    Cell F6:                                                               1
           =D6/E6
           • D6/E6                                                    1
    Tournament worksheet
    3.5    Cell C3:                                                               1
           =COUNTA(A7:A52) (Accept column A - G)
           OR
           =COUNT(B7:B52) (Accept column B, C, G)

           • Function: COUNTA(A7:A52)                                 1

Copyright reserved                                                             Please turn over

### Page 6

Computer Applications Technology/P1                6                     DBE/May/June 2025
                                       SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

 3.6     Cell C4:                                                             4
         =SUMIF(D7:D52,"*Washington",G7:G52)

         •   Function: SUMIF(…)                                     1
         •   Criteria range: D7:D52                                 1
         •   Criteria: *Washington  OR *Washington*                 1
         •   Sum range: G7:G52                                      1
 3.7     Cell F9:                                                             4
         =VLOOKUP(E9,CountryCode!A3:E250,5,FALSE)

         •   Lookup_Value: E9                                       1
         •   Table_array: CountryCode!A3:E250                       1
         •   Col_Index_num: 5                                       1
         •   Range_lookup: False                                    1
         Total for QUESTION 3                                                [16]

Copyright reserved                                                         Please turn over

### Page 7

Computer Applications Technology/P1                  7                       DBE/May/June 2025
                                         SC/NSC – Marking Guidelines
                                 EXAMINATION
                                 NUMBER

QUESTION 4                                 File name: 4Shop                            Total Q4: 24
•     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).
•     Candidates 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
    September worksheet
    4.1.1   Cell D3:                                                              1
            =COUNTBLANK(G6:G46)

            •   Function: COUNTBLANK(G6:G46)                          1
    4.1.2   Cell H10:                                                             3
            =(F10+ G10)/24

            •   (F10+ G10)  /24                                     3
    4.2     Column A: Conditional formatting                                      4

            •   Applied to: =A6:A46                                   1
            •   Formula: =D6  >=3  OR $D6:$D46>=3 OR >2              2
                (no absolute cell reference applied to row number)
            •   Format: Fill colour: Green                            1
    4.3     Cell I6:                                                              5
            =IF(G6>0,"Notice","")
            OR
            =IF(G6="","","Notice")
            OR
            =IF(COUNT(G6)=1,"Notice","")
            OR
            =IF(COUNTBLANK(G6)=0,"Notice","")
                                                                       .

                                                                       1
            •   Function: IF(…)  (correct syntax used)
            •   Logical test:
                o Determine if the extra amount per month: G6         1
                    OR H6
                o is more than 0: >0  OR ""                           1
            •   True output: "Notice"                                 1
            •   False output: ""                                      1

Copyright reserved                                                             Please turn over

### Page 8

Computer Applications Technology/P1                8                     DBE/May/June 2025
                                       SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

 Games worksheet
 4.4     Cell C3:                                                             5
         =COUNTIFS(E6:E19,">=60%",E6:E19,"<=75%")
         OR
         =COUNTIFS(E6:E19,"<=75%",E6:E19,">=60%")

         • Function: COUNTIFS(…)                                    1
         Criteria 1:
         • Criteria 1 range: E6:E19  count the cells if the         1
            criterion is 60% or more (>=60%)  OR >59                1
         AND
         Criteria 2:
         • Criteria 2 range: E6:E19  count the cells if the         1
            criterion is 75% or less (<=75%)  OR <76                1
 (Price) worksheet
 4.5     Chart/Graph:                                                         6

         •   Column graph created:
             Data range:
              =Games!$A$13:$A$19,Games!$D$13:$D$19                  1
             OR =Games!A13:A19,Games!D13:D19
         •   Chart area: Fill: 4Screen image                        1
         •   Gridlines: Primary Major Horizontal: removed           1
         •   Data labels: Label position: Outside End               1
         •   Trendline: Moving Average                              1
         •   Chart moved to a new sheet called: Price               1
         Total for QUESTION 4                                                [24]

Copyright reserved                                                         Please turn over

### Page 9

Computer Applications Technology/P1                  9                       DBE/May/June 2025
                                         SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

QUESTION 5                                File name: 5Games                              Total Q5: 35

                                                                           Maximum       Candidate
  No                                  Criteria
                                                                             Mark          Mark
 Table: tbI5_1
 5.1.1   Field: Tournament                                                        1
         • Field size: 15                                             1
 5.1.2   Field: Date                                                              2
         • Format: Short date  OR yyyy/mm/dd                          1
         • Show date picker: For dates                                1
 5.1.3   Field: Location                                                          3
         • Display control: Combo Box                                 1
         • Row Source: SELECT [tblCountry].[Country] FROM
            tblCountry                                                1
         • Sort: ORDER BY [Country]                                   1
 5.1.4   Field: Prize                                                             2
         • Validation rule: >15000                                    1
         • Validation Text: Any appropriate text that refers to
            the rule                                                  1
 Form: frm5_2
 5.2     Image:                                                                      5
         • Image moved to form header  (appears below                 1
            heading)
         • Size mode: Clip                                            1

         Discount fee: =([Fee]*0.9,0)
         • ([Fee]-  ([Fee] *10/100)  OR ([Fee]*0.9)                  2
         • Format: Currency                                           1
 Query: qry5_3
 5.3     •   Query created:Game, Fee and GameDate fields              1             5
         •   GameDate field criteria:
             o Between #2025/01/01#  OR >=#2025/01/01#                1
                OR >#2024/12/31#
             o And                                                    1
             o #2025/04/30#  OR <=#2025/04/30# OR                     1
                <#2025/05/01#
         •   Sorted: Game field in ascending order                    1

         (Expected records: 19)

Copyright reserved                                                             Please turn over

### Page 10

Computer Applications Technology/P1              10                     DBE/May/June 2025
                                      SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

 Query: qry5_4
 5.4     •   Genre criteria: "Classic"                             1         4
         •   Genre criteria: NOT "Action" OR <> "Action"           1
         •   Rating criteria: >8 OR >=9                            1
         •   <>"Action" AND >"8" OR "Classic" logic used           1

         (Expected records: 17)
 Query: qry5_5
 5.5     •   Genre field: Group by                                 1         3
         •   Rating field: AVG                                     1
         •   Rating field: Format: Standard  OR Fixed              1

 Query: qry5_6
 5.6     New field:                                                           4
         Code: Left([Game],3)&Month([GameDate])

         •   New field: Code                                       1
         •   Left([Game],3)
             o Function: Left([Game], …)                           1
             o Number of characters: 3                             1
         •   Function: &                                           1
 Report: rpt5_7
 5.7     •   Report rpt5_7 created with Genre, Rating, Game and               6
             Fee fields                                            1
         •   Grouped according to Genre  then according to         1
             Rating                                                1
         •   Function inserted in Genre group footer               1
         •   Function: Min([Fee])                                  1
         •   Label: Lowest Fee                                     1

         (Note to marker: Ignore currency)
         Total for QUESTION 5                                               [35]

Copyright reserved                                                        Please turn over

### Page 11

Computer Applications Technology/P1                 11                      DBE/May/June 2025
                                         SC/NSC – Marking Guidelines
                                  EXAMINATION
                                  NUMBER

QUESTION 6                      File name: 6_1Tournament, 6_2Entry                      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_1Tournament
    6.1.1   Alignment tag                                                           1
            <body align="center">

            •   Attribute: align="Center"                             1
    6.1.2   Image                                                                   2
            <img src="6_1Logo.png" alt=" Logo" align="center"/>

            •   File extension of the image: .png                     1
            •   Attribute: alt ="Logo"                                1
    6.1.3   Heading                                                                 1
            <h2>Welcome to the Tournament!</h2>

            •   <h2> …. </h2> tags inserted                           1
    6.1.4   Table data                                                              1
            <td>Date: 25 November 2025</td>

            •   <td>…</td> tags inserted                              1
    6.1.5   Horizontal line                                                         3
            <hr width="50%" size="10%" color ="Gold"/>

            •   <hr> tag inserted                                     1
            •   Attribute: size="10%"                                 1
            •   Attribute: color="Gold"                               1
    6.1.6   Hyperlink                                                               2
            <a href="Therisingsun.html">Register Now</a>

            •   href inserted                                         1
            •   <a> Closing tag moved to end of line                  1

Copyright reserved                                                            Please turn over

### Page 12

Computer Applications Technology/P1              12                        DBE/May/June 2025
                                      SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

 6_2Entry
         …..                                                                       4

         <body bgcolor="lightyellow">

         <p> Please complete the form in full.</p>

               <table>

                 <tr>
                         <th colspan="2">ESports Event Entry</th>
                 </tr>

                 <table>
                         
                 <p><b> Please note standard rules and regulations
                 apply.</b></p>

         </body>
         </html>

           Attribute: bgcolor="lightyellow"                          1
           Table: border removed  OR border = "0"                    1
           Colspan="2"                                               1
           Bold Tag: <b> …</b>                                       1
         Closing tag(s) or triangular brackets and nesting                         1
         correctly used.                                 ..........   1
         Total for QUESTION 6                                                     [15]

Copyright reserved                                                           Please turn over

### Page 13

Computer Applications Technology/P1                13                     DBE/May/June 2025
                                        SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

QUESTION 7               File names: 7Report, 7Staff, 7Export, 7Results                Total Q7: 15

                                                                          Maximum        Candidate
 No                                   Criteria
                                                                            Mark           Mark
7Report
7.1.1    Table of contents                                                         3
         • Table of content inserted                                 1
         • Level 1: Gaming style                                     1
         • Level 2: Heading 3 style                                  1

         ALT+F9: { TOC \h \z \t "Heading 3,2,Gaming,1" }
7.1.2    Hyperlink                                                                 2
         • Link added: On QR code to 7Results.html                   1
         • ScreenTip: 'Viewing'                                      1
7Staff
7.2      Cell H5:                                                                  4
         =AND(B5<>"Yes",F5<>"Host",G5<>"Host")
         OR
         =AND(B5="No",F5<>"Host",G5<>"Host")

         •   Operator: <>                                            1
         •   B5<>"Yes"  OR B5="No"                                   1
         •   F5<>"Host"                                              1
         •   G5<>"Host"                                              1
7Export
7.3      Exporting: tblSA                                                          3
         • Records exported: Player 1 – Player 20                    1
         • Export data with formatting & layout                      1
         • File name: 7Export.xlsx                                   1

Copyright reserved                                                          Please turn over

### Page 14

Computer Applications Technology/P1              14                         DBE/May/June 2025
                                      SC/NSC – Marking Guidelines
                                EXAMINATION
                                NUMBER

7Results
7.4     …..                                                                        3
        <ol type = "I" >
               <img src="7Podium.png" alt="First Place Winner"
             border ="3">

                <li><h2>Johan Sundstein</h2> </li>
                 <p>Prize: R37 425.00</p>
                
                <li><h2>Kuro Takhasomi</h2></li>
                <p>Prize: R30 357.00</p>

                <li><h2>Saahil Arora</h2></li>
                <p>Prize: R21 257.00</p>
              </ol>

          List: Attribute: type = 'I'                                 1
          Image border: 3 pt                                          1
          2nd Place winner displays as list item: <li> …. </li>       1
        TOTAL FOR QUESTION 7                                                       [15]
                                                                TOTAL              150

Copyright reserved

## Related documents

- [CAT P1 GR12 MEMO SEPT 2020 English](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2020-english/fe852a1d-d162-4072-a9a0-fa24c6d26774) — Computer Applications Technology · Memo · 2020 · Eng
- [CAT P1 GR12 MEMO SEPT 2019 English](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2019-english/ef2df5b1-6950-4769-9979-f22d14b986c1) — Computer Applications Technology · Memo · 2019 · 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
- [CAT P1 QP GR12 SEPT 2024 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-english/bf2518c3-ae79-4251-8145-1b062895b12f) — Computer Applications Technology · QP · 2024 · Eng

## More from Grade 12 Computer Applications Technology

- [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 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
- [Computer Applications Technology P1 Nov 2023 Eng](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2023-eng/60311585-04c7-46dc-bcf6-87da09dc1ea5) — QP · 2023 · Eng
- [ERRATA CAT P1](https://www.hlayiso.com/library/errata-cat-p1/363f4b7e-98be-46d4-9d47-fcfea8705198) — Errata · 2022
- [CAT P1 QP GR12 SEPT 2022 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2022-english/2c41f16c-52dc-4d98-a4a4-e3296512bace) — 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.
