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

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

- Page: https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2022-english/837c4abb-40c6-4f10-a6eb-4a6db8bfe1b4
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Language: English
- Document type: Memorandum
- Year: 2022
- Exam period: Eastern Cape Mock Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 10

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/cat-p1-memo-gr12-sept-2022-english/837c4abb-40c6-4f10-a6eb-4a6db8bfe1b4)

## About this document

Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2022 · English. Memorandum, 10 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 2022 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2022-english/2c41f16c-52dc-4d98-a4a4-e3296512bace) — QP · 2022 · 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 2022

  COMPUTER APPLICATIONS TECHNOLOGY P1
           MARKING GUIDELINE

NAME OF CANDIDATE:                                               GRADE:

SIGNATURE OF EDUCATOR:

          TOTAL          Q1     Q2        Q3       Q4       Q5      Q6

 MARKS:     150          31      10       43       35       20      11

                     This marking guideline consists of 10 pages.

### Page 2

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

QUESTION 1            File Name: 1_Social Networks          Total Q1: 31
                                                                 Maximum       Candidate
    No.                        Criteria
                                                                   Mark          Mark
 1.1      New Style
          • Media Style created ✓                               1
          • Size set to 17 pt. ✓                                1       4
          • Paragraph spacing set to 18 After ✓                 1
          • Style applied to the first heading ✓                1
 1.2      Drop Cap
           • Dropped cap applied on ‘S’ ✓                       1       3
           • Applied over 2 lines ✓                             1
           • Distance 0.2 cm from text ✓                        1
 1.3      Footnote
          • Footnote added on social media ✓                    1       3
          • Wingdings  (character 70) inserted ✓               1
          • Footnote text is ‘https://www.investopedia.com’ ✓   1
 1.4      Citation
          • Type of source: Film ✓                              1       3
          • Title: The Social Networks ✓                        1
          • APA Style used ✓                                    1
 1.5      Proofing Language
          • Set to English South Africa ✓
                                                                1       1
             (For the whole document)
 1.6      Widow and Orphan
           • Widow and Orphan set on the paragraph ✓            1       1
 1.7      Bullets
          • 1_SN.jpg used as a bullet ✓                         1       2
          • Bullets aligned to centre ✓                         1
 1.8      Columns                                               1
          • Paragraph changed to two columns ✓
                                                                1       3
          • Columns have a line in between ✓
                                                                1
          • Column break inserted ✓
 1.9      Multi-level list                                      1
          • Level 1 Applied ✓                                   1
          • Set to 1 cm ✓
                                                                1       4
          • Level 2 Applied ✓
                                                                1
          • Set to 2 cm ✓
 1.10     Page Numbering
          • Arrow 1 Style applied ✓
                                                                1
          • Different First page applied ✓                              4
                                                                1
          • Different odd ✓and
                                                                2
          • Even numbers applied ✓
 1.11     Hyperlink
          • Hyperlink applied to the text “Back to the top” ✓   1       2
          • Place in this document “Top of the Document” ✓      1
 1.12     HideText
          • Text hidden ✓                                       1       1
          Total for QUESTION 1                                        [31]

Copyright reserved                                                         Please turn over

### Page 3

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

QUESTION 2                   File Name: 2_Flyer                       Total Q2: 10
                                                              Maximum    Candidate
 No.                           Criteria
                                                                Mark        Mark
 2.1    SmartArt
        • SmartArt modified to Cycle Diverging Radial ✓   1          1
 2.2    Edit text
         • All text added as it is in the picture ✓       1          1

 2.3    Picture
        • Correct picture inserted ✓
        • In the centre of the SmartArt ✓                 1
                                                          1          5
        • Picture size 2.5 cm x 2.5 cm ✓                  1
        • Lock aspect ratio unchecked ✓                   1
                                                          1
        • Picture style set to soft edge oval ✓
 2.4    Shapes
        • Any shape fill (colour) used ✓
                                                          1
        • Blue shape outline inserted ✓                   1          3
                                                          1
        • Outline weight of 2¼ pt. ✓

        Total for QUESTION 2                                        [10]

Copyright reserved                                                         Please turn over

### Page 4

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

QUESTION 3                          File Name: 3_Survey               Total Q3: 43
                                                                    Maximu Candidate
    No.                              Criteria
                                                                    m Mark      Mark
 Summary worksheet
 3.1.1    Row 1 and Row 2
          • Row 1 and 2 Merged from cell A1:U2. ✓                   1        1
 3.1.2    Alignment
          • Heading must be horizontally and vertically centred ✓   1        1
 3.1.3    Fill colour
          • Background standard green. ✓                            1        1
 3.1.4    Font colour
          • Font colour of the heading changed to white ✓           1        1
 3.2      Wrapping
          • Cell S4 Wrapped ✓                                       1        1

 3.3      Customise Date : Column D
          • Date changed to format dd-mm-yyyy ✓                     1        2
          • Contents copied to all cells in column D ✓              1
 3.4      Cell E5
          =INT(($E$3-D5)/365.25)
          • =INT ✓
          • (($E$3-D5) ✓                                            1        3
          • /365.25) ✓                                              1
              or:   TRUNC( .... )                                   1
              or:   ROUNDDOWN( .... , 0)
 3.5      Cell F5

          =CONCATENATE(C5,".",LOWER(LEFT(B5,1)),"@school.za")
          •     =CONCATENATE ✓                                      1        4
          •     (C5,".", ✓                                          1
          •     LOWER(LEFT(B5,1)), ✓                                1
          •     "@school.za") ✓
                                                                    1
 3.6      Cell N6

          =IF(AND(G5="WhatsApp", H5="Facebook"), "Old
          Users", "New Users")

          •    IF AND function correctly used ✓                     1        4
          •    First criteria correct ✓                             1
          •    Second criteria correct ✓                            1
          •    Both value true and value false are correct ✓        1

Copyright reserved                                                         Please turn over

### Page 5

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

 3.7

                                                                             4
          Column P: Conditional Formatting
          • Cells Value equal to $P$10 (Watch Videos) ✓             1
          • Applies to =$P$5:$P$54 ✓                                1
          • Filled with red ✓                                       1
          • Thin horizontal crosshatch pattern ✓                    1
 3.8      Cell O5
          =IF(COUNTIF(L5:N5,"Yes"),"Online Safety Course"," " )
          • Function :IF ✓
                                                                    1
          • Countif range: L5:N5 ✓                                  1        5
          • Countif criteria: ,"Yes" ✓                              1
          • Value true correct: “Online Safety Course” ✓            1
          • Value true correct: " " ✓                               1
 3.9      Cell S56
          =MODE(S5:S54)
                                                                    1        2
          • Function : Mode ✓
                                                                    1
          • Correct Range: (S5:S54) ✓
 3.10     Cell U5
          Calculate deficit per learner
                =T5-S5
          • Cell T5 and S5 ✓                                        1
          • Minus sign ✓                                            1
          Cell S58                                                           6
          =SUMIF (Q5:Q54,"MTN”, U5:U54)                             1
          • Function: Sumif ✓                                       1
                                                                    1
          • Criteria Range: Q5:Q54 ✓
                                                                    1
          • Criteria: MTN ✓
          • Sum range ✓
 3.11     Graph Worksheet
                                                                    1
          •   Chart title is centred ✓
                                                                    1
          •   Chart title inserted with correct text ✓
                                                                    1
          •   Legends correct ✓                                     1
          •   Data labels are callout ✓                             1        8
          •   Point explosion only at MTN ✓                         1
          •   Point explosion set at 30% ✓                          1
          •   Plot area filled with gradient fill ✓                 1
          •   Sheet 1 renamed to Graph ✓

          Total for QUESTION 3                                             [43]

Copyright reserved                                                      Please turn over

### Page 6

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

QUESTION 4                    File Name: 4_LearnerSurvey                 Total Q4: 35
                                                                  Maximum Candidate
    No.                           Criteria
                                                                    Mark       Mark

 Table: Registrations table
 4.1.1    Field:
          Input Mask:    <LLL\ - >LL?
          •   Lower letters: < ✓                                  1
          •   LLL – three compulsory letters ✓                    1      5
          •   - hyphen ✓                                          1
          •   > upper case LL two compulsory letters ✓            1
          •   ? optional letter ✓                                 1

 4.1.2    Gender Field
                                                                  1
          •   Combo field added. ✓                                       2
                                                                  1
          •   List values added: Male and Female. ✓
 4.1.3    CellNo:
          • Indexed property = Yes (No Duplicates) ✓              1      1

 4.1.4    Registration Date
          •   >= ✓                                                1      2
          •   #2021/10/01# ✓                                      1
 4.1.5    Default Values
          Default value = Yes ✓                                   1      1

 4.2      Form: frm4_2
          • Background colour of the Detail section
             changed to any colour. ✓                             1
                                                                  1      3
          •   Text in the CellNo field is distribute-aligned. ✓
          •   The Pledge textbox changed to Pledge. ✓             1

 4.3      Qry4_3
          •   Query Criteria CellNo: 083* ✓
                                                                  1
          •   Query Criteria Education: Class Groups ✓
                                                                  1
          •   Add Totals function ✓                               1      5
          •   Choose sum to add the amounts ✓                     1
          •   Sort in ascending order of surname ✓                1

Copyright reserved                                                           Please turn over

### Page 7

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

 4.4     Qry4_4
                                                                   1
         •     Criteria for CellNo field: Is Null ✓
         •     Criteria for Type of users field: Old users ✓       1
         Calculation: Balance: ([Pledge])-([Pledge])*15/100
                                                                   1
         •   New field Balance: created. ✓                               6
         •   Correct calculation of 15% deduction ✓                1
         •   Correct subtraction of the 15% ✓                      1
         •   Red alternate row colour applied to the query ✓
                                                                   1
         (Expect 6 records)

 4.5     Rpt4_5
         •   Report is created with the following fields: Name,    1
             Surname, CellNo, Pledge and Education ✓
                                                                   1
         •   Report is grouped according to Pledge field. ✓
                                                                   1
         •   Report sorted in ascending order of surname field ✓
                                                                   1
         •   =Count([Code]) or Count ✓ (*) ✓
                                                                   1    10
         •   in the Pledge footer. ✓
                                                                   1
         •   Calculation in the Pledge footer ✓
                                                                   1
         •   Sum ✓ ([Pledge]) ✓
                                                                   1
         •   Total amount in Rand format ✓                         1
         •   Save report as rpt4_5. ✓                              1

         Total for QUESTION 4                                          [35]

Copyright reserved                                                     Please turn over

### Page 8

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

QUESTION 5                   File Name: 5_Social Networks                     Total Q5: 20
•     This question should be marked from the browser as far as possible, unless otherwise
      indicated or if it cannot be seen on the browser.
•     A maximum of 1 mark will be deducted if one or more closing tags are omitted.

                                                                    Maximum       Candidate
    No.                          Criteria
                                                                      Mark          Mark
    5.1   Title
              <title>Popular Social Networks</title>
           • Title tag added to the text Popular Social Networks’
              to appear on the browser ✓                            1        1
    5.2   Heading: Popular Networks for Children
          <center><h1> <font color = red>Popular Networks
          for Children </font> </h1> </center>
                                                                    1        2
          •   Heading centred ✓
          •   Font colour changed to red ✓                          1
    5.3   Bulleted list
          <ol type = "I">
          • Correct tag used : type = I ✓                           1        3
          • Uppercase Roman figures used ✓                          1
          • Tags inserted: <li>creating online profiles</li> ✓      1
    5.4   Table
          <table border="1" width = "500" cellspacing = "5">
          • Set the width of the table to 500 ✓                              2
                                                                    1
          • Set the cell spacing to 5 ✓                             1
    5.5   Table
          <tr bgcolor = "Yellow">
          • Background of colour of row 1 set to yellow ✓           1        1
    5.6   Image
          <img src="5_WhatsApp.png" width = 30 height =
          30>                                                       1        3
          •   Tag img src used ✓                                    1
          •   Correct picture used ✓                                1
          •   Width and height set to 30 ✓

Copyright reserved                                                               Please turn over

### Page 9

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

 5.7     Horizontal line
         <hr size = "10" color = "red"/>
         •      Line size set to 10 ✓                                     1     2
         •      colour set to red ✓                                       1
 5.8     Formatting
         <h2><b><i>Further Reading</b></i> </h2>                          1
         <h2> </h2> ✓                                                           2
                                                                          1
         <b><i> </b></i> ✓
 5.9     Link
         a href = <"https://raisingchildren.net.au/teens/entertainment-
         technology/digital-life/social-media"> Click here </a>
                                                                          1
         •   <a href> </a> ✓                                                    3
                                                                          1
         •   Link created on the text ‘Click here’ ✓
                                                                          1
         •   Link opens link provided ✓
         Closing tag(s) or triangular brackets and nesting
                                                                          1     1
         correctly used.
         Total for QUESTION 5                                                 [20]

Copyright reserved                                                            Please turn over

### Page 10

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

QUESTION 6              File Name: 6_Analysis and 6_Survey form Total Q6: 11
                                                         Maximum Candidate
  No.                       Criteria
                                                            Mark      Mark
 6.1.1   Remove duplicates
         • Duplicates removed ✓
                                                             1    3
         • Only 50 records are left ✓                        1
                                                             1
         • Cell E104 : Removed Duplicates ✓
 6.1.2   Cell C4

         =time(9,130,0)
         • Correct function used: Time ✓                          3
                                                             1
         • Start time and Minutes ✓                          1
                                                             1
         • Answer in time format ✓
 6.2     Survey form
         • ‘Name’ Text form field inserted ✓                 1
         • ‘Name’ Text form field Text format: Uppercase ✓   1
         • Drop down form field ‘TikTok’ added ✓             1
         • Check box form field inserted ✓ to replace             5
                                                             1
           symbols
         • Yes checked ✓                                     1

         Total for QUESTION 6                                    [11]

                                                   TOTAL:        150

Copyright reserved                                                      Please turn over

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