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

> Grade 12 Computer Applications Technology Paper 1 memorandum from the Eastern Cape Prelim Exam 2024 (English), 14 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2024-english/91df7fb9-ea6b-4fed-8f93-a1466ec697c3
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Language: English
- Document type: Memorandum
- Year: 2024
- Exam period: Eastern Cape Prelim 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 2024 Memo (Eng)](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2024-english/91df7fb9-ea6b-4fed-8f93-a1466ec697c3)

## About this document

Computer Applications Technology · Grade 12 · Eastern Cape Prelim Exam · 2024 · English. Memorandum, 14 pages. Read online or download the PDF.

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

## Matching paper and memo

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

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

   COMPUTER APPLICATIONS TECHNOLOGY P1
            MARKING GUIDELINE

NAME OF CANDIDATE:                                                  GRADE:

SIGNATURE OF EDUCATOR:

QUESTION              Q1      Q2      Q3      Q4      Q5      Q6       Q7    TOTAL
POSSIBLE MARKS        36      13      27      16      34      13        11    150
CANDIDATE’S MARK
MODERATED MARK

                     This marking guideline consists of 14 pages.

                     Hosted by www.ecexams.co.za.

### Page 2

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

QUESTION 1                            File Name: Q1_Overview                   Total Q1: 36

                                                                       Maximum Candidate
    No.                             Criteria
                                                                         Mark    Mark

1.1       Text:
          LET THE GAMES BEGIN                                          1

          •   All caps font effect applied ✓                                   2
              (Do not accept font changed to uppercase.)
                                                                       1
          •   Outer offset bottom right shadow text effect applied ✓
1.2       Table of content:
          Style Esport1 used in Table of content. ✓
                                                                       1

                                                                       1

                                                                       1       5

          •   Table of content formal style ✓
          •   Solid line for page number ✓                             1
          •   Esport1 Style applied to multiplayer ✓
          •   Page break/next page section break inserted before
              Dota 2 so that page number reflects page 3 ✓

                                                                       1

Copyright reserved                                                            Please turn over

                              Hosted by www.ecexams.co.za.

### Page 3

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

1.3.1    First row of the table:
                                                                      1

                                                                      1           3
         •   Row added above the table ✓
         •   All cells merged ✓
         •   Heading Top Dota 2 Teams in the world moved (not         1
             copied) into merged cell and centre aligned ✓
1.3.2    Last row of the table:
                                                                      1

         •   Border inserted Thin inside line, thick outside line ✓               2
             (Note to marker: Must be thin inside and thick outside
             right around.)                                           1
         •   Formula = Average (Above) ✓
1.4      Columns:
         • Two columns with a line in between ✓
           (Must do both to get 1 mark.)
                                                                      1
         • Inserted a column break before the heading “Each” ✓

                                                                                  2

                                                                      1

1.5      Footnote to endnote:
                                                                      1
         Steam under the heading development
                                                                                  2
         •   Footnote converted to endnote ✓
                                                                      1
         •   Number format set to A, B, C, ... ✓
1.6      Citation:
         •   Citation under the heading international inserted ✓
                                                                      1           1

         (Note to marker: Must be the source Gwabeni, 2022.)

Copyright reserved                                                        Please turn over

                           Hosted by www.ecexams.co.za.

### Page 4

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

1.7      Picture:
         •   Picture under the heading Carry
             Reset ✓
                                                                       1            1

         (Note to marker: no mark if the picture AND size is reset.)
1.8      Index:
         •   Highlight remove from the index ✓
         Original:

         Correct:
                                                                       1            1

         (Note to marker: Update index and see if highlight is still
         removed; learner must remove highlight in document not on
         the index itself.)
1.9      Index sub entry:
         •   WarcraftIII subentry Blizzard added (Ignore spelling) ✓
                                                                       1
         •   Index update on the last page. ✓

                                                                                    2

                                                                       1

Copyright reserved                                                            Please turn over

                            Hosted by www.ecexams.co.za.

### Page 5

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

1.10     Find and Replace:
         •   Replaced all the IceFrog words with Gabe ✓                1
         •   Gabe format Red underline ✓ and Bold ✓
         •   Match Case ✓
             (Page 9 Below the heading Development.)
             (4 Words replaced.)                                       1
             (7 Words if match case was not selected.)
                                                                                   4

                                                                       1

                                                                       1

1.11     Caption:
         •   New caption Label Hero created and added to the correct   1
             picture ✓
         •   Caption read as follows: Crystal Maiden ✓
                                                                       1           3
         •   Updated in the table of figures on page 2/3 ✓

                                                                       1

1.12.1 Smart Art:
         • The None bullet is added to 2005 by adding the text below   1           1
           it and demoting it to the correct level. ✓
1.12.2 • Any colourful style applied ✓

                                                                       1           1

Copyright reserved                                                         Please turn over

                          Hosted by www.ecexams.co.za.

### Page 6

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

1.13     Multiple level list:
                                                              1
         • Level 1 A) ✓
         • (Note to marker: Must have ')' in
           order to get this mark.)                           1
         • Level 2 Bullet windings character                                4
           code 176 ✓
                                                              1
         • 2nd bullet aligned at 1cm ✓
         • 2nd bullet 2 cm hanging indent ✓
                                                              1

1.14     Source:
         •   Film source added ✓                              1
         •   Content added correctly ✓
                                                                            2

                                                              1

         Total for QUESTION 1                                             [36]

Copyright reserved                                                   Please turn over

                           Hosted by www.ecexams.co.za.

### Page 7

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

QUESTION 2                        File Name: Q2_Application                  Total Q2: 13

                                                                         Maximum Candidate
No.                                Criteria
                                                                           Mark    Mark

2.1 Drop down form field:                                                1
    • Blue Team added ✓                                                        2
    • In the correct order ✓                                             1
2.2 Game title field:
                                                                         1     1
    • Text format of Game Title field changed to UPPERCASE ✓
2.3 Name field:
                                                                         1     1
    • Name field size 20 ✓
2.4 Check box field:
                                                                         1     1
    • Check box form field is checked ✓
2.5 Instructions to the signer:
    • Please ensure this information is accurate ✓
                                                                         1     1

2.6 Text watermark:
                                                                         1
    • Text watermark inserted ✓
       (Accept horizontal and diagonal.)                                 1     3
    • Text read Registration form ✓
    • Must be on the 1st page only ✓                                     1
2.7 Tab stops:
    • Centre tab inserted on 7 cm ✓                                      1
    • Right tab 24 cm with leader a solid leader line ✓
    • Tab key applied to last line in two places ✓

                                                                         1

                                                                               4

                                                                         1

      •   Tabs applied to 11 Lines ✓
          (Note to the marker: A learner must insert the tab AND         1
          insert it in the right place (CM) in order to get one mark.)

      Total for QUESTION 2                                                    [13]

Copyright reserved                                                           Please turn over

                             Hosted by www.ecexams.co.za.

### Page 8

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

QUESTION 3                         File Name: Q3_IDplayer                     Total Q3: 27

                                                                      Maximum Candidate
No                                Criteria
                                                                        Mark    Mark

Q3_IDplayer
Players Worksheet
3.1 Column A:
                                                                      1          1
    • Autofill column A 1 to 50 ✓
3.2 Merged Cell:
     • Merged cell includes row 3 ✓                                   1          1
      (Merged A1:P3)
3.3 Cell D4:
     • =MAX(D8:D57) ✓
                                    OR                                1          1
     • =LARGE(D8:D57,1)
                                             Expected answer: 3961
3.4 Cell G4:
                                                                      1
     =COUNTIFS(H8:H57,">1000",I8:I57,"<=2000")
     •   Countifs ✓                                                   1
     •   Range 1: H8:H57 ✓
                                                                      1          5
     •   Criteria 1: “>1000” ✓
     •   Range 2: I8:I57 ✓                                            1
     •   Criteria 2: “<=2000” ✓
                                               Expected answer: 16 1
3.5 Cell 08:
                                                                      1
     =IF(M8<"20/01/01",IF(E8>=2000,IF(F8<1500,"Yes",""),""),"")
     =IF(M8<DATE(2020,1,1),IF(E8>=2000,IF(F8<1500,"Yes",""),""),"") 1
     =IF(AND(M8<DATE(2020,01,01),E8>=2000,F8<1500),"Yes","")
                                                                      1
    • 1st Condition ✓                                                            6
    • 2nd Condition ✓                                                 1
    • 3rd Condition ✓
    • If true Yes ✓                                                   1
    • If false blank "" ✓
    • Used nested if as a AND or Used the AND function ✓              1
3.6 Cell P8:
                                                                      1
    • Column index number changed from 3 to 2 ✓
    • False Changed to True or removed ✓                              1          3
    • Sort Lookup Table from small to large according to column A ✓
                                                                      1

Copyright reserved                                                           Please turn over

                           Hosted by www.ecexams.co.za.

### Page 9

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

Travel worksheet
3.7 Cell E4:
                                                                  1
     =IF(C4="Yes",D4+$D$2,D4)
     =IF(C4="No",D4,D4+$D$2)                                      1
      •   C4="Yes" ✓                                                          4
      •   True: D4+$D$2 ✓                                         1
      •   Absolute Cell reference ✓
      •   False: D4 ✓                                             1
Graph Worksheet
3.8 Graph:
    • Heading Win vs Losses added ✓                               1
    • Vertical (Value) Axis: major units changed to 400.0 ✓
    • Fill the highest data label with a red colour ✓
    • Q3Chart Picture inserted in the chart area ✓                1
    • 70% Transparency applied to the picture ✓
    • Horizontal axis rotated to “Rotate all text 90°” ✓
                                                                  1

                                                                              6

                                                                  1

                                                                  1

                                                                  1

     Total for QUESTION 3                                                    [27]

Copyright reserved                                                    Please turn over

                           Hosted by www.ecexams.co.za.

### Page 10

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

QUESTION 4                       File Name: Excel: Q4_Players              Total Q4: 16

                                                                 Maximum Candidate
No.                             Criteria                                   Mark
                                                                   Mark

Q4_Players
Ranking Worksheet
4.1 File Header:
      •   Ranking Worksheet Filename inserted in the centre of   1     1
          the header ✓      Field: &[File] Output: Q4_Players
4.2 Conditional Formatting:
                                                                 1
      • Applied to range A4:A26 ✓
      • Formula: D4<=5 ✓
                                                                 1
          Or =$D4<=5
          Or =$D4:$D26<=5                                              4
          Or =$D4:$D26<6                                         1
          Or =$D4<6
      • Absolute cell reference removed, i.e. NOT $D$4 ✓         1
      • Colour fill blue ✓
4.3 Cell E3:                                                     1
      =CONCATENATE(MID(A4, FIND(" ", A4)+1 ,1), MID(B4
                                                                 1
      ,2,1), C4)
      •    CONCATENATE ✓ (No mark for &)                         1
      •    MID and A4 ✓
                                                                 1
      •    Find the space ✓
                                                                 1     8
      •    A4 + 1 ✓ (both for 1 mark)
      •    1st Character of the surname ✓                        1
      •    MID(B4) ✓
      •    2nd Character of ID number ✓                          1
      •    C4 ✓ (Pro or Amateur)
                                                                 1
      Check for building blocks.
4.4 Details worksheet:
                                                                 1
      •    Untick locked for cells B2:B4 ✓
      •    Sheet protected ✓
                                                                       2
       (Note to marker: no password added.
       If password added, learner loses second                   1
      mark)
4.5 Renamed sheet1 to Game ✓                                     1     1
      Total for QUESTION 4                                            [16]

Copyright reserved                                                         Please turn over

                           Hosted by www.ecexams.co.za.

### Page 11

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

QUESTION 5                 File Name: Q5_GameStats                     Total Q5: 34

                                                              Maximum Candidate
 No.                             Criteria
                                                                Mark    Mark

5_1Table
5.1    Table 5_1Table in datasheet view:
                                                                 1
       •   Sunken cell effect ✓                                        2
       •   Alternative back colour green ✓                       1
5.2.1 Player ID Field:
                                                                 1     1
       •   Primary key added to the Player ID field ✓
5.2.2 PlayerName Field:
                                                                 1     1
       •   PlayerName field size 50 ✓
5.2.3 GamesPlayed Field:
       • GamesPlayed required field ✓                            1     1
        Or Validation rule: Is NOT Null
5.2.4 Distance traveled Field:
                                                                 1
       Validation rule added:
       •   Between 30 ✓ And ✓ 500 ✓                              1     3
           or >=30 And <=500
           or >29 And <501                                       1
5.2.5 Skins Field:
       •   Skins format changed to true/false ✓                  1     1
           (default was yes/no)
Qry5_3 Query
5.3    •   Totals activated in Design view ✓                     1
       •   Avg Frequency of logins ✓                             1     3
       •   Formatted to 0 decimal places ✓
                                                                 1
Qry5_4 Query
5.4    AccountAge:(Date()-[Date of account creation])/30         1
       Or AccountAge: (Date()-[Date of account
           creation])/365.25*12                                  1

       •   Calculated field called AccountAge Added. ✓           1
                                                                       5
       •   Date() ✓
                                                                 1
       •   Subtraced and used [Date of account creation]. ✓
       •   Correct use of brackets ✓
                                                                 1
       •   /30 ✓ Or /365.25*12.

Copyright reserved                                                   Please turn over

                          Hosted by www.ecexams.co.za.

### Page 12

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

Qry5_5 Query
5.5    •    >30000 on the followers column ✓
       •    Display only the username ✓                                  1
       •    Sort username in decending order ✓
       •    [Experience]< [Score] ✓ on correct fields ✓
                                                                         1

                                                               OR        1            5

                                                               OR        1

                                                                         1

Frm5_6 Form
5.6    •    Geographic location text box                                 1
            changed to a combo box ✓
       •    Q5_6 table used as row source ✓                              1
       •    Button inserted ✓
                                                                         1            5
       •    Operation to close the
            form ✓                                                       1
       •    Used 5_6Close picture for button ✓
                                                                         1
Rpt5_7 Report
5.7    •    Heading changed in the report header to "Total followers     1
            per country" and centred across the page ✓
       •    Grouped according to geographical location ✓                 1
       •    Moved the field geographical location to the group           1
            header ✓
       •    Calculated field added to the group footer of geographical   1            7
            location ✓                                                   1
       •    =Sum ✓ ([Followers]) ✓
                                                                         1
       •    Formatted the field geographical location to any grey
            background colour ✓                                          1
       Total for QUESTION 5                                                          [34]

Copyright reserved                                                              Please turn over

                           Hosted by www.ecexams.co.za.

### Page 13

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

QUESTION 6                  File Name: Q6_1ESport, Q6_2Ranking           Total Q6: 13

                                                                    Maximum Candidate
 No                              Criteria
                                                                      Mark    Mark

6.1.1 Tab Name:
      <title> Esport </title>                                       1     1
       •   Both <title> and </title> added on the correct place ✓
6.1.2 Dota 2 TI10 heading:
      <font size="10" color="red"><marquee>Dota 2                   1
      TI10</marquee> </font>                                              2
       •   Added font size of 10 ✓
                                                                    1
       •   Changed colour to color ✓
6.1.3 List of events of 2023 heading:
      <font face = "arial">                                         1     1
       •   Changed type to face ✓
6.1.4 Bullet list:
      <ol type="A">..</ol>                                          1

       • Changed the <ul> to <ol> and </ul>
         to </ol> ✓                                                 1     3
       • Type = "A" ✓
       • Closing tag of first list item changed
         from <li> to </li> ✓                                       1

6.1.5 Name No Tail:
      <td valign = "Middle" align = "center">No                     1
      Tail</td>                                                           2
       •   <td valign = "Middle" ✓
                                                                    1
       •   align = "center" ✓>No Tail</td>
6.2.1 Team Liquid picture:
      <img src ="Q6PIC/TL.jfif"                                     1     1
       • TL.png changed to TL.jfif ✓
6.2.2 Stats heading:
      <th colspan="4">Stats</th>                                    1
                                                                          2
       •   Colspan = 4 ✓
                                                                    1
       •   Correct position: inserted in the <th> tag ✓
       Closing tags, nesting done correctly ✓                       1     1
       Total for QUESTION 6                                              [13]

Copyright reserved                                                        Please turn over

                           Hosted by www.ecexams.co.za.

### Page 14

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

QUESTION 7           File Name: Q7_Cardtype, Q7_Data, Q7_MergeLetter       Total Q7: 11

                                                                 Maximum Candidate
 No                             Criteria
                                                                   Mark    Mark

7.1.1 Q7_MergeLetter:
                                                                 1     1
      • Both track changes accepted ✓
7.1.2 Q7_MergeLetter:
      •    Correct source “Q7_CardType.docx” used ✓              1
      •    Only the visa card type ✓
      •    Replaced the name and surname fields ✓
                                                                 1

                                                                       4

                                                                 1

      •    Merged completed & Saved as Q7Merged ✓
                                                                 1
                     9 completed letters expected in Q7Merged.
7.2.1 Q7_Data file IP worksheet:
      • Data validation applied to Colum E gender ✓
      • Only male and female accepted ✓                          1

                                                                       2

                                                                 1

7.2.2 Dup worksheet:
                                                                 1     1
      •    All dup removed 50 records left ✓
7.2.3 Company worksheet:
                                                                 1
      •    At each change in: Type of company ✓
      •    Use function: Count used ✓                            1     3
      •    Add subtotal to: Type of company ✓
                                                                 1

      Total for QUESTION 7                                            [11]

                                                      TOTAL:          150

Copyright reserved                                                         Please turn over

                           Hosted by www.ecexams.co.za.

## Related documents

- [CAT P2 GR12 QP SEPT 2024 English](https://www.hlayiso.com/library/cat-p2-gr12-qp-sept-2024-english/b8b0a9f3-f8c6-4f0a-8ddf-30b58008b603) — Computer Applications Technology · QP · 2024 · Eng
- [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
- [CAT P1 QP GR12 SEPT 2022 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2022-english/2c41f16c-52dc-4d98-a4a4-e3296512bace) — Computer Applications Technology · QP · 2022 · Eng
- [CAT P1 GR12 QP SEPT 2020 English](https://www.hlayiso.com/library/cat-p1-gr12-qp-sept-2020-english/6e7f27db-454b-4095-a4e8-522ceffa7412) — Computer Applications Technology · QP · 2020 · 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) — Computer Applications Technology · QP · 2024 · Afr

## 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
- [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 P2 GR12 SEPT2022 English deaf](https://www.hlayiso.com/library/cat-p2-gr12-sept2022-english-deaf/54bb9db8-ddb8-49da-98d3-9305d3e38697) — QP · 2022 · Eng
- [CAT P2 GR12 SEPT2022 English](https://www.hlayiso.com/library/cat-p2-gr12-sept2022-english/5bf11b7b-3780-438b-a247-980dec6042a6) — QP · 2022 · 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) — 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.
