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

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

- Page: https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2020-english/fe852a1d-d162-4072-a9a0-fa24c6d26774
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Language: English
- Document type: Memorandum
- Year: 2020
- Exam period: Eastern Cape Mock 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 2020 Memo (Eng)](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2020-english/fe852a1d-d162-4072-a9a0-fa24c6d26774)

## About this document

Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2020 · English. Memorandum, 12 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 GR12 QP SEPT 2020 English](https://www.hlayiso.com/library/cat-p1-gr12-qp-sept-2020-english/6e7f27db-454b-4095-a4e8-522ceffa7412) — QP · 2020 · 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 2020

   COMPUTER APPLICATIONS TECHNOLOGY P1
            MARKING GUIDELINE
NAME OF CANDIDATE: ____________________                       GRADE: _________

SIGNATURE OF EDUCATOR: ____________________

             TOTAL                Q1       Q2        Q3        Q4     Q5     Q6
 MARKS:
               180                35       15        56        42     21     11

               This marking guideline consists of 12 pages.

### Page 2

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

QUESTION 1                     File Name: 1_4th Industrial Revolution         Total Q1: 35

                                                                          Maximum       Candidate
     No.                            Criteria                                Mark          Mark
    1.1.1   Cover Page
                                                                      1           1
               Year changed to 2020 using the text control. 
    1.1.2   Cover Page
                                                                      1           1
               And rotated 90 degrees. 
    1.2.1   Table of Contents
                                                                      1
               Text set to Normal Style 
                                                                      1           3
               Only the text not heading changed 
                                                                      1
               Text not in ToC anymore 
    1.2.2   Style
                                                                      1
             Style modified to blue                                             2
             Spacing after paragraph set to 12pt                    1
    1.3     Find and Replace
                                                                      1
             All occurrences of 4th Industrial Revolution replaced
              by 4IR.                                                            2
                                                                      1
             All occurrences (5 Occurrences) 

    1.4     Border                                                    1
             Yellow border applied 
             2pt border                                             1           3
             an Offset Top shadow effect added to the
                                                                      1
                image 
    1.5     Picture
                                                                      1
             Picture has been wrapped tight, square or through 
             Moved to the right of the paragraph                    1
             Figure 2 has been moved below the picture                          3
                                                                      1
    1.6     Endnote
             Endnote inserted in the correct place                  1
             Text: “Founder and Executive Chairman of the                        2
              World Economic Forum” typed in                         1

Copyright reserved                                                               Please turn over

### Page 3

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

 1.7     Citation                                                1
              Journal Article (source) used 
                                                                 1     3
              Author Klaus Schwab inserted 
              Year 2020 inserted 
                                                                 1
 1.8     Page setup
                                                                 1
            Section breaks inserted before and after page 5 
            Page 5 set to landscape                            1     3
            All other pages set to remain in portrait 
                                                                 1

 1.9     Spell Check
          Labor changed to labour                              1     1

 1.10    Paragraphs
                                                                 1
          Paragraphs sorted                                          2
          In ascending order                                   1
 1.11    Page numbering                                          1
            Page numbering inserted 
                                                                 1
            In the footer of the document 
            Centred                                            1
                                                                       5
            First two pages not numbered 
            Numbering starts on page 3 as page 1               1
                                                                 1
 1.12    Watermark                                               1
          Watermark inserted 
          On the last page only                                1
          Text 4IR appear                                            4
          Displaying horizontally                              1

                                                                 1

          Total for QUESTION 1                                        [35]

Copyright reserved                                                    Please turn over

### Page 4

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

QUESTION 2                       File Name: 2_ 4IR Research               Total Q2: 15

                                                                     Maximum        Candidate
    No.                         Criteria
                                                                       Mark           Mark
 2.1      Paper size
           Top and bottom margins set to 1.5 cm 
                                                                 1
           Size of the page set to 20 cm wide and 28 cm
                                                                            2
             high                                               1
 2.2      Layout                                                 1
          Three columns created 
           Spaces between columns set to 1.1 cm                1
           Highlighted text appears on top of each                         4
              column                                            1
           Columns are justified 
                                                                 1
 2.3      Table
           Text is converted into a table with four columns    1
           Grid Table 4 Accent 2 style applied to the
               table                                            1
           Repeat header rows feature used to set table                    5
             headings appear on both pages in the table         1
           All data in table centred, vertically 
           and horizontally                                    1
                                                                 1

 2.4      Paragraph
             Shadowed border applied to the paragraph          1
                                                                            2
             Double line border style used                     1

 2.5      Date
           Current date inserted in the footer of the           1
             document                                           1          2
           Updates automatically 
          Total for QUESTION 2                                            [15]

Copyright reserved                                                               Please turn over

### Page 5

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

QUESTION 3                          File Name: 3_Resourcing                   Total Q3: 56

      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 or cells as '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
 WardInfo worksheet

 3.1.1 Merge and Centre
        Cells A1 to O1 are merged 
                                                                        1
        and centred                                                            2
                                                                        1

 3.1.2 Fill
         Any fill is applied to merged cells                          1
         Thin diagonal stripe pattern style fill effect applied                2
       (accept any diagonal stripes)                                    1

 3.1.3 Wrap Text
        Row 3 wrapped                                                  1        1

 3.1.4 Panes
                                                                        1
        Freeze panes 
                                                                                 2
        Row 3 
                                                                        1
 3.2     Comment
                                                                        1
          Comment inserted in cell E4 
                                                                                 2
          Text Unit Price displays 
                                                                        1
 3.3     Text functions (Cell B5)

         =CONCATENATE(LEFT(A5;1);
         RIGHT(A5;2);LOWER(LEFT(C5;1)))                                 1
            Correct function used (Concatenate or & function) 
            First letter of the Ward Name extracted                   1
                                                                                 4
            Last two letters of Ward Name 
            First letter of location in lower case                    1

                                                                        1

Copyright reserved                                                                   Please turn over

### Page 6

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

 3.4      Cell K5
          =SUM(E5:I5)
            Formula: Sum                                  1
                                                                 2
            Range: (E5:I5) 
                                                            1

    3.5   Cell L8
          =J8-K8
           Correct cells used 
           Subtraction sign                               1
                                                                 2
                                                            1

 3.6      M5
                                                            1
          =E5/$E$4
                                                            1
            Correct cells used 
                                                                 4
            Division sign used 
                                                            1
            Absolute cell reference applied to cell E4 
            Formula copied to all other cells 
                                                            1
 3.7      Cell N6                                           1
          =E6/K6*100 OR E6/K6
                                                            1
                                                                 3
            Correct cells used 
           Correct sign used                              1
           Set to a percentage with no decimal places 
 3.8      Conditional formatting
                                                            1
            Conditional formatting used in column L 
            Cell value <0                                 1    3
            Green fill with dark green text applied 
                                                            1

 3.9      Cell O5
          =IF(L5<0;" ";"Bonus")                             1
            Function: IF 
                                                            1
            Condition: L5<0                                   4
            Value if true is correct                      1
            Value if false is correct 
                                                            1
 3.10     Cell E37
          =SUMIF(C5:C34;"Urban";J5:J34)                     1
              Function: Sumif 
                                                            1
              Criteria range C5:C34                            4
              Criteria - Urban 
                                                            1
              Sum range J5:J34 
                                                            1

Copyright reserved                                                   Please turn over

### Page 7

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

 3.11    Cell E39
         =IF(AND(C7="Rural";N7>25);"Award";"No          1
         Award")
          Functions: IF and AND                      1    4
          Condition (C7="Rural";N7>25); 
          Value if true is correct                    1
          Value if false is correct                  1
 3.12    Cell E41                                       1
         =COUNTIF(C5:C34;"Semi Rural")
                                                        1
            Function: Countif                             3
            Range: C5:C34;                            1
            Criteria: "Semi Rural"

 3.13    Cell E43
                                                        1
         =VLOOKUP(A7;ExtraInfo!A2:C31;3;FALSE)
            Function: Vlookup                         1
            Lookup value : A7 
                                                             5
            Lookup range : ExtraInfo!A2:C31 (ignore   1
             if no absolute cell reference was used)
            Row number : 3                            1
            Range lookup : False 
                                                        1
 3.14    Cell E45
         =COUNTBLANK(E5:E34)                            1
                                                             2
                                                        1
          Function: COUNTBLANK 
          Range: (E5:E34) 
 3.14    Graph Worksheet
            Graph title Readiness for 4IR             1
            Both series points plotted correctly. 
            Any Stacked Bar graph used.               1
            Vertical axis appears as in graph 
                                                        1
            Centred                                        7
            Legend series added to top of graph 
                                                        1
            Move graph to the worksheet 4IR           1
                                                        1
                                                        1

          Total for QUESTION 3                              [56]

Copyright reserved                                                 Please turn over

### Page 8

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

QUESTION 4                                File Name: 4_4IR                   Total Q4: 42
                                                                   Maximum    Candidate
    No.                           Criteria
                                                                     Mark       Mark
 Table: Wards
 4.1.1    Field: WardName
               > inserted in Format field property               1     1
 4.1.2    Field: WardNumber
                                                                   1
              Required property set to Yes                             2
                                                                   1
            Format of field set to 'Fixed' format 
 4.1.3    Image
            Data type of Image field changed to OLE Object/       1     1
               Hyperlink 
 4.1.4    Validation
               <= 2020/06/30       OR < 2020/07/01
          OR <=#2020/06/30#     OR <#2020/07/01#                   1     3
                                                                   1
             Any appropriate validation text that refers to the   1
              limitation of the date
 4.1.5    Devices Field
                                                                   1
           New field created Devices 
                                                                   1     3
           Data type set to lookup value 
                                                                   1
           Data on the Info table used 

 4.2      Form: frm4_2
           Form frm4_2 based on WardInfo table and
            Columnar layout selected 
           Selected fields: WardName; WardNumber;
            Location; Budget; Expenditure and Balance             1
                                                                   1
           The background of the form header is yellow 
                                                                   1
           Font size of heading is 36 pt 
                                                                   1
           Heading is centred                                    1
           4_Form.jpg picture inserted                           1
                                                                        10
           In form header aligned right                          1
           Format of Budget field changed to Currency with        1
            zero decimal places                                   1
           Button inserted in form footer                        1
           Shows the next record when button is clicked 

Copyright reserved                                                           Please turn over

### Page 9

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

 4.3.1    Qry4_3_1
                                                          1
              Only Location and Expenditure 
              Location: Total: Grouped by               1        3
              Expenditure: Total: Sum 
                                                          1

 4.3.2    Qry4_3_2
           Only Rural                                   1
           and Semi-Rural records show 
           Total calculated                             1        4
           Total of Budget field  (SUM)                 1
                                                          1

 4.3.3    Qry4_3_3
                     Loan: 30/100*[Budget]                1
                                                          1
              Criteria Balance : <0 
              Loan:                                     1        5
              30/100                                    1
              *[Budget]                                 1
              Loan set to R currency 

 Report

 4.4                                                      1
          Report4_4
            Report created                              1
            Grouped according to Location and then
             according to Budget                         1
           Total budget for each Location calculated 
           in the Location footer = Sum([Budget])       1
           Rural Locations are formatted red 
           New field Future Projections created .       1      10
           Calculation of Future Projections 
           =10/100                                      1
           *[Budget] 
           +[Budget]                                    1
          OR =110/100*[Budget]
                                                          1
                                                          1
                                                          1
          Total for QUESTION 4                                   [42]

Copyright reserved                                                Please turn over

### Page 10

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

  QUESTION 5                       File Name: 5_MyWebsite                   Total Q5: 21

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

                                                                           Maximum         Candidate
     No                             Criteria
                                                                             Mark            Mark
 5.1      Heading 1
            <center><h1><font size="50" face="Century">THE             1
            TIME HAS COME</font></h1> </center>                                      2
           Heading is centred                                        1
           Font size set to 50 
 5.2      Anchor                                                       1
          <a name="Top"></a>
             Link tags correctly inserted                            1             3
             On words 'driver distraction' 
             Correct anchor name                                     1
 5.3      Image
          <p align="center"><img src="5Pic.png"
          border="5"></p>                                                            2
           Extension for the image corrected                         1
           Image centred                                             1
 5.4      Bulleted list
          <ul> </ul>
           Ordered list <ul> created.                                1             3
           <li> </li> tags used correctly                            1
           Applied to all listed items                               1
 5.5      Table
           Table colour is lightblue                                 1             2
           Width of the table is 80%                                 1

Copyright reserved                                                              Please turn over

### Page 11

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

 5.6     Table row
         <tr>
                        <th>AR</th>
                                                                     1
                        <td>15</td>
                        <td>34</td>                                           3
                                                                     1
                        </tr>
              New row added                                        1
              Correct tags used 
              Correct data entered 
 5.7     Table row
         <td align="center" colspan="3"><b>Be Ready!!
         </b></td>                                                            2
              Row merged across three columns                      1
                                                                     1
              Text changed bold 
 5.8     Link
         <a href="#Top">Back to top</a>
                                                                              3
              <a href> </a>                                        1
              Link created on the text ‘Back to Top                1
              Link moves to the top of website                     1
         Closing tag(s) or triangular brackets and correct nesting   1        1
         correctly used
         Total for QUESTION 5                                               [21]

Copyright reserved                                                       Please turn over

### Page 12

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

QUESTION 6                    File Name: 6_Calculation, 6_Quote              Total Q6: 11

                                                                    Maximum       Candidate
  No,                                Criteria
                                                                      Mark          Mark

 6.1.1   Date
                                                                    1
              Today’s date inserted                                      2
              In this format: (2020)(03)(10)                      1

 6.1.2   Table
                                                                    1
              Table created 
              3 columns and 2 rows                                1
                                                                           4
              Spacing between columns set                         1
              to 0.3 cm 
                                                                    1

 6.2     Mail Merge
              Recipients list filtered to send letters            1
              to the Wards that have a negative balance <0        1
              Insert Ward Names in the Ward Name field            1      5
              Mail merge completed                                1
              Completed letters saved as Letters                  1
         (Expect 6 Letters)

         Total for QUESTION 6                                            [11]
                                                            TOTAL        180

Copyright reserved                                                      Please turn over

## Related documents

- [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 QP SEPT2020 English](https://www.hlayiso.com/library/cat-p2-gr12-qp-sept2020-english/497f003b-193b-4666-867a-4761ef9d3e33) — Computer Applications Technology · QP · 2020 · 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 P2 GR12 MEMO SEPT2019 English](https://www.hlayiso.com/library/cat-p2-gr12-memo-sept2019-english/be90bdf5-3d2f-40b0-8dfd-16e7142e74e6) — Computer Applications Technology · Memo · 2019 · Eng
- [CAT P2 GR12 MEMO SEPT2017 (English)](https://www.hlayiso.com/library/cat-p2-gr12-memo-sept2017-english/c01cc76d-6be5-4f8e-b0dd-c7487e06934f) — Computer Applications Technology · Memo · 2017 · Eng
- [CAT P1 MEMO GR12 SEPT 2021 Afr D](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2021-afr-d/528606a4-6c50-4abf-95fd-6bf9eee17db9) — Computer Applications Technology · Memo · 2021 · 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
- [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
- [ERRATA CAT P1](https://www.hlayiso.com/library/errata-cat-p1/363f4b7e-98be-46d4-9d47-fcfea8705198) — Errata · 2022

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