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

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

- Page: https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2019-english/ef2df5b1-6950-4769-9979-f22d14b986c1
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Language: English
- Document type: Memorandum
- Year: 2019
- 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 2019 Memo (Eng)](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2019-english/ef2df5b1-6950-4769-9979-f22d14b986c1)

## About this document

Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2019 · English. Memorandum, 12 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

Downloaded from hlayiso.com

                             NATIONAL
                        SENIOR CERTIFICATE

                                     GRADE 12

                         SEPTEMBER 2019

  COMPUTER APPLICATIONS TECHNOLOGY P1
           MARKING GUIDELINE

NAME OF CANDIDATE: ____________________                           GRADE: _________

SIGNATURE OF EDUCATOR: ____________________

          TOTAL                Q1        Q2        Q3       Q4        Q5     Q6

 MARKS:    180                  29       23        57        41       20      10

                  This marking guideline consists of 12 pages.

### Page 2

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

QUESTION 1                         File Name: 1LandPollution                Total Q1: 29
                                                                       Maximum      Candidate
    No.                           Criteria
                                                                         Mark         Mark
 1.1.1    Cover Page
                                                                   1          1
           Cover page Facet inserted. 
 1.1.2    Cover Page                                               1
           Type Land Pollution in title field, Save our Land in
            the subtitle field.                                   1          3
           Type landhighschool@ecdept.gov.za in the e-mail
                                                                   1
            field. 
           Delete the abstract field. 
 1.2.1    Table of Contents
                                                                   1          1
           Automatic Table of Contents inserted. 
 1.2.2    Table of Contents
                                                                   1          1
           Three levels of headings appear. 
 1.2.3    Table of Contents
           Correct styles used: Title, Heading 1 and Heading
            2 styles.                                             1          1

          (Note to marker: All three levels must be inserted
          correctly in order to obtain the last mark.)
 1.3.1    Page Numbering
                                                                   1          1
           Accent Bar Right page numbers inserted. 
 1.3.2    Page Numbering
                                                                   1
             Automatic page numbering starts as 1 on the
              second page.                                                   2
                                                                   1
             Page numbering does not appear on the first
              page. 
 1.4.1    Paragraph Formatting
                                                                   1          1
           Paragraph spacing is 6 pt before and 6 pt after the
            paragraph. 
 1.4.2    Line Formatting                                          1
                                                                              2
             Line spacing set to exactly 
             16 pt.                                              1

 1.4.3    Character Formatting
                                                                   1          1
           Character spacing expanded to 1.5 pt. 
 1.5      Document Editing
                                                                   1
             Correct occurrences of text changed                            2
             with the word “infect”.                             1
          (Note to marker: 2 Occurrences only 2 or 0 marks)

Copyright Reserved                                                          Please Turn Over

### Page 3

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

 1.6      Hyperlink                                            1
            Hyperlink on text ‘In factories and offices’. 
            URL ‘www.explainthatstuff.com/land-               1     3
             pollution.html’. 
            Tooltip ‘HowStuffWorks’ added.                   1

 1.7      Footnote
                                                               1
           Footnote added to text ‘Radioactive Waste’.       1     3
           Footnote symbol: Wingdings character 83.          1
           Footnote text: ‘by-product of nuclear power’. 
 1.8      Document formatting                                  1
            Document justified.                                    2
            Document hyphenated.                             1

 1.9      Citation
                                                               1
            Source added. 
                                                               1     3
            As a website source. 
            Author; Name of website; Year and URL appear.    1

 1.10     Bibliography
                                                               1     1
            Bibliography updated. 
 1.11     Quick Parts
                                                               1     1
            Date created field inserted (11 March 2019). 
          Total for QUESTION 1                                     [29]

Copyright Reserved                                                 Please Turn Over

### Page 4

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

QUESTION 2                   File Name: 2LandPollutionBrochure           Total Q2: 23

                                                                    Maximum       Candidate
    No.                         Criteria
                                                                      Mark          Mark

 2.1      Page Orientation
                                                                1          1
             Set to landscape. 
 2.2      Page border
                                                                1
              2¼ pt wide border inserted.                     1          3
              Colour of border is red.                        1
              Page border. 
 2.3      Columns
              Highlighted text displayed in three columns.    1
                                                                1
              1 cm/0.39 inches space between columns.                    4
                                                                1
              A line in between columns appears.              1
              Heading must be at the top of each column. 

 2.4      WordArt
              Any WordArt inserted                            1
                                                                           3
              to the correct text.                            1
              Gold colour Accent 4 Soft Bevel.                1

 2.5      Bullets
                                                                1
              Bullets changed to a picture
                                                                1          4
              2Bullet.jpg. 
              Left indent – Bullet 0 cm.                      1
              Hanging – paragraph 1.5 cm.                     1

 2.6      Shapes
              Any Callout inserted.                           1
              Oval Callout Shape.                             1          4
                                                                1
              Inserted at the bottom of first column.
                                                                1
              Text “Save Our Land” inserted. 
 2.7      Watermark
                                                                1
              Watermark inserted.                             1
              2LandPollution2.jpg used as watermark.          1
                                                                           4
              Without Washout effect.                         1
              Picture scaled to 120%. 

          Total for QUESTION 2                                           [23]

Copyright Reserved                                                         Please Turn Over

### Page 5

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

QUESTION 3                             File Name: 3_LandSheet               Total Q3: 57

 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

 Stats per Province worksheet

 3.1.1    Stats per Province
                Tab changed to any colour other than the original     1     1
                 colour. 
         (Note to marker: Colour was white.)
 3.1.2    Merge and Centre
                                                                       1     1
                Cells A1 to T1 are merged and centred. 
 3.1.3    Fill
                                                                       1
                Applied any thin diagonal stripe pattern style fill         2
                 effect to merged cells.                              1
                Colour Red. 
 3.1.4    Row 4
                                                                       1     1
                Wrapped 
 3.2      Freeze panes                                                 1
                                                                             2
                Freeze pane effect applied                           1
                Column A. 
 3.3      Format Date
          =(dd)-(mm)-( yyyy)
                                                                       1
                Correct use of brackets.                                   3
                                                                       1
                Correct use of -.                                    1
                Correct specifications for day, month and year. 

 3.4      Cell A5                                                      1
          =CONCATENATE(UPPER(LEFT(B5;2));"-”;
                                                                       1
          LEN(B5))
                Concatenate or & function used                       1     5
                (LEFT(B5;2)) 
                "-”                                                  1
                LEN(B5)) 
                UPPER – All in upper case                            1

Copyright Reserved                                                           Please Turn Over

### Page 6

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

 3.5     Cell C3
         =FIND(" ";B5)
                                                          1
             Find function used to determine.           1
                                                               3
             Correct position of space.                 1
             In cell (B5). 

 3.6     Data Validation
                                                          1
             Validation criteria: Allow whole number    1
             Criteria: Between                          1
                                                               4
             Minimum value 0 and Maximum value 999999   1
             Any suitable error message 

 3.7     Cell E3
         =COUNTIFS(D5:D13;">=100000";E5:E13;"<=55")
                                                          1
             Countifs function                          1
             Criteria range 1: (D5:D13)                 1    5
             Criteria 1: >=100 000                      1
             Criteria range 2: (E5:E13)                 1
             Criteria 2: <=55

 3.8     Nested IF
                                                          1
         =IF(E5<51;"Less Dense";
         IF(E5<=100;"Dense";"Highly Dense"))              1
                                                               4
             Nested IF syntax                           1
             Condition: <51 and “Less Dense” 
             Condition: <=100 and “Dense”               1
             Condition: >100 and “Highly Dense” 
 3.9     Conditional formatting
             Conditional formatting used                1
                                                               3
             in correct column                          1
                                                          1
             a red data bar. 
 3.10    Cell Q15
                                                          1
         =SUMIF(B5:B13;"*Cape";Q5:Q13)
             Sumif function                             1
                                                               4
             Criteria range: B5:B13
             Sum range: Q5:Q13                          1
             Criteria: *Cape 
                                                          1

Copyright Reserved                                              Please Turn Over

### Page 7

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

 3.11     Cell R5
          =P5-Q5                                             1
             =P5; Q4                                            3
                                                             1
             Minus sign (-) 
             Function in cell R5 copied to cells R5:R13    1

 3.12     Cell S5
                                                             1
          =IF(P5<=Q5,"Top up"," ")
          OR                                                 1
          =IF(Q5>=P5, “Top up”, “ ”)                              4
             IF- Function                                 1
             Correct condition specified: P5<=Q5
             Value if true is correct                     1
             Value if false is correct
 3.13     Cell T9
                                                             1
          =VLOOKUP(B9,Towns!$A$2:$B$10,2,
          FALSE)
                                                             1
             Vlookup function 
                                                                  5
             Lookup value: B9                              1
             Lookup range: Towns!$A$2:$B$10 
              (ignore if no absolute cell reference)         1
             Column: 2 
             Lookup range: False                           1

 3.14     Graph Worksheet                                    1
             Graph created title changed to                 1
              WasteTreatment. 
             Both series points plotted.                   1
             Column graph and Line graph appear
              together.                                     1    7
             Vertical axis ‘Waste Treatment Facilities’
              and horizontal axis “Provinces” added.        1
             Legends series placed and edited. 
             Picture Fill applied in the chart area.       1
             Graph moved to Graph worksheet. 
                                                             1
          Total for QUESTION 3                                   [57]

Copyright Reserved                                                      Please Turn Over

### Page 8

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

QUESTION 4                          File Name: 4_LandPollution               Total Q4: 41

                                                                  Maximum     Candidate
    No.                          Criteria
                                                                    Mark        Mark

 Table: Waste Pollution
 4.1.1    Field: ID
                                                                  1     1
             ID field removed. 
 4.1.2    Field: Image
             New field created.                                 1     3
             After province field.                              1
             Data type: OLE Object Or attachment.               1
 4.1.3    Primary key
                                                                  1     1
          Primary key set to Province field. 

 4.1.4    Required Field: Hazardous Waste
                                                                  1     1
             Set as required field. 
 4.1.5    Validation rule and text: Own refuse dump
                                                                  1
             Between or And functions used.
                                                                  1
             Lower boundary set to greater than 2 and upper            3
              boundary set to less than 99. 
                                                                  1
             Appropriate validation text referring to limits.
          Between 2 And 98 OR >2 And <99
 4.1.6    Budget Field
                                                                  1     1
          Default value set to R10000. 

 4.2      Form: frm4_2
           Only Provinces; Hazardous Waste; Budget               1
            and Expenditure fields are shown.                    1
           Background colour of the form changed to red.         1
                                                                 1     7
           Title/Label changed to Waste.                        1
           Date field inserted in the form header.              1
           Calculation in the form footer.                      1
           Count 
           (*)

Copyright Reserved                                                          Please Turn Over

### Page 9

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

 4.3     Qry4_3
                                                                  1
            Only Province, Population served by
             municipality and Own Refuse Dump fields are          1
             shown. 
            Criteria: Population served by municipality: >=50.   1     5
             
            Hazardous field: Yes                                1
            Sorted: Own Refuse Dump field. 
            Sorted: In ascending order.                         1
         4 Records
 4.4     Qry4_4
                                                                  1
            Province: Total: Grouped by. 
            Budget: Total: Sum                                  1     3
            Criteria: >=50 000 
                                                                  1
         4 Records
 4.5     Qry4_5
                                                                  1
         Balance: [Budget]-[Expenditure]
                                                                  1
            Calculated field name: Balance: 
            Budget and Expenditure fields used                  1
            -                                                         6
                                                                  1
            Correct use of brackets 
            Balance: <0                                         1
            Hazardous Waste: Yes                                1
         2 Records
 4.6     Report4_6
          Report is created                                     1
          with all the required fields other than ID field.     1
          Report is grouped according to Licensed facilities
           field.                                                1
          Then is grouped according to Hazardous field.         1
          Report sorted according to the Budget field.          1    10
          Page orientation change to landscape.                 1
          Calculation on the footer of the Licensed
           Facilities field:                                     1
          =Sum([Expenditure])                                   1
          Total amount is in any currency format.               1
                                                                  1
          Picture inserted in the report header. 

         Total for QUESTION 4                                         [41]

Copyright Reserved                                                    Please Turn Over

### Page 10

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

QUESTION 5                            File Name: 5_MyWebsite                 Total Q5: 20

        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       Title
              <title>Land Pollution </title>                                   1
                                                                    1
             Title tag added 
 5.2       Heading: LandPollution
           <h1 align ="center"><font color = "Brown">               1
           Land Pollution</font></h1>                                          2
                                                                    1
             Heading aligned centre 
             Font colour changed to brown 
 5.3       Horizontal line
                                                                    1
           <hr size=7 color="Red"/>                                            2
             Size of line changed to 7.                           1
             Line colour changed to red. 
 5.4       Ordered list                                             1
           <ol type = "I" > </ol>
                                                                    1          3
             Ordered list <ol> created. 
             Type of bullet set to Roman figures. 
                                                                    1
             Roman figures in upper case. 

Copyright Reserved                                                             Please Turn Over

### Page 11

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

 5.5     Table
                First row added - <th> 
         <tr>                                                 1
                 <th>Type of Land Pollution</th>
                 <th>Cause</th>
                 <th>Area found</th>
         </tr>                                                1
              Table border set at 2                         1
              Cellpadding set at 25 
         <table border = 2 cellpadding = "25">
                                                              1
         <tr bgcolor = "Pink"> 
                                                                    9
                <th>Type of Land Pollution</th>
                <th>Cause</th>
                <th>Area found</th>                           1
         </tr>
                                                              1
              Colspan = “3” 
                                                              1
              Image = 5LandPollution.jpg 
                                                              1
              align = "middle" 
                                                              1
              height =200 width = 300 
              Alt = “Dump” 
         <tr><td colspan ="3" align = "middle">
         <img src ="5LandPollution.jpg" align = "middle"
         height =200 width = 300 Alt = “Dump”> </td></tr>

 5.6     Link
         <a href="#Top"> Home </a>
            <a href> </a>                                   1     3
            Link created on the text ‘Home.                 1
            Link moves to the top of website.               1

              Closing tag(s) or triangular brackets omitted
                                                              -1

         Total for QUESTION 5                                      [20]

Copyright Reserved                                                  Please Turn Over

### Page 12

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

QUESTION 6                 File Name: 6Letter.docx                            Total Q6: 10

                                                                    Maximum       Candidate
  No.                          Criteria
                                                                      Mark          Mark

 6.1.1      Pictures grouped. 
                                                                1
            Picture moved below heading Waterfall                        2
                                                                1
             Community. 

 6.1.2      Cross reference created next to the word “my”. 
                                                                1
            Links to the endnote “Waterfall Community
                                                                          2
             Leader”. 
                                                                1

 6.1.3      Correct changes are made to the graph.            1
                                                                          2
            The changes are showing in the graph.             1

 6.1.4      Widow/orphan control is checked.                  1
                                                                          2
            Keep lines together is checked.                   1

 6.1.5    6Poster copied and pasted to the letter.            1
                                                                          2
          Pasted as an icon.                                  1

         Total for QUESTION 6                                            [10]

                                                     TOTAL:              180

Copyright Reserved                                                                Please Turn Over

## Related documents

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

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