# Computer Applications Technology Grade 12 P1 2019 Memo

> Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC June Exam 2019, 13 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/computer-applications-technology-p1-may-june-2019-memo/513a7ad1-9ade-48ef-b406-7b5d8a936ddf
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2019
- Exam period: NSC June Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 13

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](https://www.hlayiso.com/library/computer-applications-technology-p1-may-june-2019-memo/513a7ad1-9ade-48ef-b406-7b5d8a936ddf)

## About this document

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

             SENIOR CERTIFICATE EXAMINATIONS/
         NATIONAL SENIOR CERTIFICATE EXAMINATIONS

                     COMPUTER APPLICATIONS TECHNOLOGY P1

                                             2019

                                MARKING GUIDELINES

                                                                      MARKS: 180

                                                         FINAL MARK
CENTRE NUMBER

EXAMINATION
NUMBER

QUESTION                 1       2       3          4    5       6    7     TOTAL

POSSIBLE MARK            30      20      30         21   40     20    19       180

MARKER

SM

CM

IM/EM

                      These marking guidelines consist of 13 pages.

Copyright reserved                                                    Please turn over

### Page 2

Downloaded from hlayiso.com
Computer Applications Technology/P1             2                                   DBE/2019
                                       SC/NSC – Marking Guidelines
                EXAMINATION
                NUMBER

IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON
THE ANSWER.
QUESTION 1                               File name: 1Street                          Total Q1: 30

                                                                         Maximum      Candidate
 No.                                  Criteria
                                                                           Mark         Mark
1.1.1   Title content control                                                   1
         Text 'Street' added to 'Title' content control            1
1.1.2   Font size                                                               1
         Font size of the 'A' changed to 200 pt                    1
1.1.3   Table borders                                                           2
         Inside borders only                                       1
         In a red colour                                           1
1.1.4   Picture (3rd row, 1st cell)                                             1
         Centred vertically                                        1
1.2     Table of contents                                                       2
         Style of 'http://www.widewalls.ch/defining-street-art/'
           changed to anything besides 'Heading 1'                  1
         Table of contents updated  (includes 'The Origins of      1
           Street Art')
1.3     Margin                                                                  2
         Bottom margin changed to 2 cm                             1
         From page 3 onwards                                       1
1.4.1   Line spacing                                                            2
         At least                                                  1
         20 pt                                                     1
1.4.2   Indentation                                                             2
         Left indent set to 1 cm                                   1
         Right indent set to 3 cm  (14 cm on the ruler)            1
1.5     Find and replace                                                        3
         's replaced                                               1
         with s                                                    1
         Only years changed  (all 4 occurrences should be          1
           replaced)
1.6     Bookmark                                                                2
         Some bookmark text formatted  (location of the            1
          bookmark)
         All text highlighted  ('It began with graffiti')          1

Copyright reserved                                                            Please turn over

### Page 3

Downloaded from hlayiso.com
Computer Applications Technology/P1            3                               DBE/2019
                                      SC/NSC – Marking Guidelines
                EXAMINATION
                NUMBER

1.7     Caption                                                           3
         New caption label 'Art' created  (Accept if more text    1
          appears)
         Caption 'Vhils process' inserted  (Do not allocate       1
          mark if 'Vhils process' appears as part of label)
         Appears above image                                      1
1.8     Bullets                                                           2
         Bullets inserted                                         1
         '' Wingdings 2, character code 147                      1
1.9     Table of figures                                                  2
         Automatic table of figures inserted on the last page     1
         Display 'Figure' entries  (7 or 8 entries)               1
1.10    References
         'Banksy, J.R.; Just Google it' source removed
1.11    Bibliography                                                      1
         Automatic bibliography inserted on the last page         1
1.12    Page numbering                                                    4
         Automatic page numbers inserted in footer                1
         Any Mosaic page numbering style used                     1
         Odd and even checked                                     1
         Consistent page numbering style applied to both odd
          (left) and even (right) pages                            1

        Total for QUESTION 1                                            [30]

Copyright reserved                                                      Please turn over

### Page 4

Downloaded from hlayiso.com
Computer Applications Technology/P1              4                                    DBE/2019
                                        SC/NSC – Marking Guidelines
                EXAMINATION
                NUMBER

QUESTION 2                      File names: 2Donations, 2Merged                     Total Q2: 20

                                                                          Maximum       Candidate
 No.                                  Criteria
                                                                            Mark          Mark
2.1     Spelling (In paragraph 1)                                               1
         Spelling error corrected  (intressting)                    1
2.2     Date form control                                                       2
         Control type changed to current date  (Accept              1
          current time if a date is displayed)
         Format set to 'dd MMMM yyyy'                               1
2.3     Columns                                                                 2
         Text converted to four columns (Check ruler)               1
         Column break inserted before '4. Help others in
           need'  (Accept with/without an open line above)           1
2.4     Endnote                                                                 4
         Endnote inserted next to 'Utopia'                          1
         Capital Roman numerals used                                1
         Text 'Perfect world'                                       1
         Added to the end of the section                            1
2.5.1   Table style                                                             1
         Any table style applied  (Besides Table Grid)              1
2.5.2   Check box form field                                                    2
         Any form field/control inserted                            1
         Check box form field inserted                              1
2.5.3   Help text for textbox form field                                        2
         Help text inserted 'Enter amount'                          1
         On F1 key                                                  1
2.5.4   Formula =SUM(Above)                                                     2
         Field inserted                                             1
         Field formula: =SUM(Above)                                 1
2.6     Mail merge                                                              4
        (Select * FROM 'Donors$' WHERE 'Amount' >=50000)
         Merge fields Name and/or Surname inserted                  1
         Data source filtered/selected >=50 000                     1
           (Amount >= 50 000)
         Roland Lewis removed from recipient list  (Check for       1
           13 letters after merge completed)
         Mail merge completed  (2Merged)                            1
        Total for QUESTION 2                                                   [20]

Copyright reserved                                                             Please turn over

### Page 5

Downloaded from hlayiso.com
Computer Applications Technology/P1              5                                    DBE/2019
                                        SC/NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

QUESTION 3                                File name: 3Comp                              Total Q3: 30

     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.
     Any function that works consistently for the data should be accepted.

                                                                           Maximum      Candidate
 No.                                  Criteria
                                                                             Mark         Mark
Entries_Inskrywing worksheet
3.1       Heading                                                                 2
           Cells A1:M1 merged                                        1
           Data vertically centred  (Ignore if horizontally          1
            centred)
3.2       Cells A1:M1                                                             2
           Blue colour                                               1
           Pattern fill                                              1
3.3       Autofill                                                                1
           Numbering continues to rest of column A  (Do not          1
            allocate the mark if the column is partly filled)
3.4       Cell D3: (Check for building blocks)                                    5
          =RIGHT(B3,LEN(B3)-LEN(C3)-1)
          OR
          =MID(B3,FIND(" ",B3)+1,LEN(B3))
          OR
          =RIGHT(B3,LEN(B3)-FIND(" ",B3))
          OR
          =MID(B3,LEN(C3)+2,LEN(B3)-LEN(C3))

             RIGHT/MID function                                      1
             B3                                                      1
             Determine length of text in B3                          1
             Determine position of space  (FIND OR SEARCH)           1
             Subtract position for space from length                 1

          (Note to marker: Ignore if there is a 3rd parameter in the
          FIND function.)

Copyright reserved                                                               Please turn over

### Page 6

Downloaded from hlayiso.com
Computer Applications Technology/P1            6                               DBE/2019
                                      SC/NSC – Marking Guidelines
                EXAMINATION
                NUMBER

3.5     Cell F4:                                                         5
        =A4&E4&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)

           & OR CONCATENATE function                              1
           A4                                                     1
           E4                                                     1
           RANDBETWEEN functions                                  1
           (0,9) OR (1,9)                                         1

        (Note to marker: Also accept correct use of the RAND
        function e.g. =A4&E4&RIGHT(RAND(),2).)
3.6     Cell G5:                                                         5
        =VLOOKUP(E5,Province_Provinsie!$A$2:$B$10,2)

           VLOOKUP function                                       1
           Lookup value: E5                                       1
           Lookup range: Province_Provinsie!$A$2:$B$10 OR
            Province_Provinsie!$A$1:$B$10 (Check for Named
            Range)                                                  1
           Column index: 2                                        1
           Absolute cell reference                                1
3.7     Cell M3:                                                         3
        =AVERAGE(J3:L3)

           AVERAGE function                                       1
           (J3:L3)                                                1
           Formatted to no decimal places                         1
3.8     Cell P2:                                                         4
        =DATE(YEAR(P1),MONTH(P1)+1,DAY(P1))

         YEAR(P1)                                                 1
         MONTH(P1)  + 1  (Allocate second mark if 31 has         2
          been added to DAY)
         DAY(P1)                                                  1

Subtotal worksheet
3.9     Subtotal:                                                        3
         Change in/Grouped by: Category_Kategorie                 1
         Function: MAX                                            1
         Subtotal added to Total score_Totale punte               1
        Total for QUESTION 3                                            [30]

Copyright reserved                                                      Please turn over

### Page 7

Downloaded from hlayiso.com
Computer Applications Technology/P1              7                                    DBE/2019
                                        SC/NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

QUESTION 4                                 File name: 4Entries                        Total Q4: 21

     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 answers.
     Named ranges can be used instead of cell references.
     Any function that works consistently for the data should be accepted.

                                                                          Maximum       Candidate
 No.                                  Criteria
                                                                            Mark          Mark
Provinces_Provinsies worksheet
4.1       Chart_Grafiek tab:                                                      1
           Tab colour changed to yellow                             1
4.2       Chart_Grafiek tab:                                                      1
           Chart_Grafiek worksheet moved to after
            Provinces_Provinsies                                     1
4.3       Cell M7 (Check in other cells):                                         3
          =COUNTIF(C3:C188,"LP")
           COUNTIF function                                         1
           Range C3:C188                                            1
           "LP"                                                     1
4.4       Sort: Cells L3:M11                                                      2
           Sorted on column L                                       1
           Descending                                               1
4.5       Conditional formatting: Column E                                        2
           All duplicate values                                     1
           Any background colour                                    1
4.6       Cell J3: (Check for building blocks)                                    7
          =IF(I3=MAX($I$3:$I$188),A3,"")
           IF function                                              1
           Criteria: I3                                             1
           =MAX                                                     1
           ($I$3:$I$188) OR (I3:I188)  (MAX(I3:I188) could be       1
             a building block)
           Correct use of absolute cell reference                   1
           Value if true: A3                                        1
           Copied down                                              1

Copyright reserved                                                               Please turn over

### Page 8

Downloaded from hlayiso.com
Computer Applications Technology/P1            8                               DBE/2019
                                      SC/NSC – Marking Guidelines
                EXAMINATION
                NUMBER

Chart_Grafiek worksheet
4.7     Chart/Graph:                                                     5
         Chart/graph changed to a bar chart                       1
         NW data does not display  (Do not accept if data         1
          removed from spreadsheet)
         Any glow applied to data series  (Do not accept          1
          shadow. Mark from the panel)
         Gap width of series changed to 50%                       1
         Colour of major vertical gridlines changed to red        1
        Total for QUESTION 4                                            [21]

Copyright reserved                                                      Please turn over

### Page 9

Downloaded from hlayiso.com
Computer Applications Technology/P1             9                                         DBE/2019
                                       SC/NSC – Marking Guidelines
                EXAMINATION
                NUMBER

QUESTION 5                                File name: 5Gallery                             Total Q5: 40

                                                                            Maximum          Candidate
 No                                   Criteria
                                                                              Mark             Mark
Table: tblExhibit
5.1.1   Field: City                                                                1
         Field size set to 50                                         1
5.1.2   Field: GalleryName                                                         1
         Field format changed to >                                   1
5.1.3   Field: PostCode                                                            3
         Data type changed to Short Text/Text                         1
        Input mask: 0000
         0 character used                                             1
         Four of the same characters inserted                         1

        OR

           Validation Rule added ()
           LEN([PostCode]) ()
           =4 () (Do not allocate this mark if the data type is not
            Number)
5.1.4   Field: Insure                                                              5
         New field Insure inserted                                    1
         Field type Calculated                                        1
         [TotalValue]  *  1.25                                      3
           OR ([TotalValue]*25/100)+[TotalValue]
           OR ([TotalValue]*0.25)+[TotalValue]
           OR ([TotalValue]*125/100)
Form: frm5_2
5.2         Form named frm5_2  created                                1             8
            Form based on qry5_2                                      1
            All fields included  (5 fields)                           1
            Form heading changed to 'Street Art'                      1
            5Street  image added as form background                  2
            Data sorted ascending  according to GalleryName          2
             (Check Form Properties, Data, Order by OR check
             sorting in qry5_2 query)

Copyright reserved                                                              Please turn over

### Page 10

Downloaded from hlayiso.com
Computer Applications Technology/P1            10                              DBE/2019
                                      SC/NSC – Marking Guidelines
                EXAMINATION
                NUMBER

Query: qry5_3
5.3        Province: Group By applied                            1    3
           Province criteria:<>"0"  OR Not Is Null OR Is Not      1
            Null OR <>"" OR "EC" OR "GP" OR "KZN" OR "WC"
           StockValue: Total: Sum                                1
        
        (Note to marker: 4 records expected.)
Query: qry5_4
5.4        Only GalleryName and NoInStock fields appear           1    7
            (Allocate the mark even if other fields are deleted)
           GalleryName criteria: *  gallery  *                  3
           TypeOfArt criteria: "Street Art"                       1
           Province criteria: Is Null  OR Not Like "*"            1
            OR Not Like '*'
           All inserted criteria on the same line AND             1

        (Note to marker: 5 records expected.)
Query: qry5_5
5.5     Calculated field:                                                8
        End: [Date]+30

           New field End created                                  1
           [Date]  + 30                                          2
           NoInStock criteria: >  150                            2
           Town criteria: "Johannesburg"                          1
           Date criteria: Year([Date])=2019
            OR >=#01/01/2019# AND <=#31/12/2019#
            OR >#31/12/2018# AND <#01/01/2020#
            OR BETWEEN #01/01/2019# AND <=#31/12/2019#
            OR Like "2019/*/*" (dependent on computer settings)
            o Correct year  (2019)                                1
            o Limited to full year                                 1

        (Note to marker: 6 records expected.)
Report: rpt5_6
5.6        Province field grouping removed                       1    4
           Province textbox and label removed                    1
           Function: =AVG  ([StockValue])                       2

        Total for QUESTION 5                                            [40]

Copyright reserved                                                      Please turn over

### Page 11

Downloaded from hlayiso.com
Computer Applications Technology/P1              11                                    DBE/2019
                                        SC/NSC – Marking Guidelines
                 EXAMINATION
                 NUMBER

QUESTION 6                                   File name: 6Famous                        Total Q6: 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
6.1       Title                                                                    1
             <title>Famous Street Art</title>

             Title tags inserted  (Accept if the <head> tags still     1
              appear OR if <head> tags have been replaced)
6.2       Cell padding                                                             2
            <table border="1" cellpadding="8"
            bgcolor="PaleGoldenrod">
             Cell padding of entire table set                          1
             To 8                                                      1
6.3       Alignment of picture                                                     1
            <img src="6_Art.png" width="100" height="100"
             align="right">

             6_Art picture aligned to right                            1
6.4       Font                                                                     1
            <font face="Calibri"><h1>Street Art</h1></font>

             Font of heading 'Street Art' set to Calibri               1
6.5       Picture size                                                             2
             <img src="6_5.jpg" width="195" height="145">

           Width set to 195                                            1
           Height set to 145                                           1

Copyright reserved                                                                Please turn over

### Page 12

Downloaded from hlayiso.com
Computer Applications Technology/P1            12                              DBE/2019
                                      SC/NSC – Marking Guidelines
                EXAMINATION
                NUMBER

6.6     Fourth row of table                                              7
          <tr align="center">
             <td><img src="6_3.jpg" width="200"
             height="200"></td>
             <td colspan="3"><font size="5"><i>3. Glasses in
             Russia</i></font>
             <p align="left">This photo went viral and appeared
             on plenty of media sites who marvelled at the 3D
             look that brought a simple pair of glasses to
             life.</p></td>
          </tr>

           One row inserted and centred                           1
           Two cells inserted                                     1
           'Colspan' of second cell set to 3                      1
           Text in second cell set to italics                     1
           Font size of second cell set to 5                      1
           Paragraph OR 2 breaks inserted                         1
           Left aligned                                           1

6.7     Bullets                                                          2
          <ul><li>#Banksy</li>
              <li>#List</li>
              <li>#Most Famous Pieces</li>
              <li>#Smates</li>
              <li>#Streetart</li></ul>

           Unordered list tags (bullets) inserted                 1
           5 list items tags inserted                             1
6.8     Hyperlink                                                        3
          <a href="Google.com">Read more</a>

           Hyperlink tags inserted                                1
           To correct text 'Read more'                            1
           Links to "Google.com"                                  1
        Closing tag(s) or triangular brackets and nesting                1
        correctly applied.                                          1
        Total for QUESTION 6                                            [20]

Copyright reserved                                                      Please turn over

### Page 13

Downloaded from hlayiso.com
Computer Applications Technology/P1              13                                     DBE/2019
                                        SC/NSC – Marking Guidelines
                EXAMINATION
                NUMBER

QUESTION 7                       File names: 7Logo, 7Globe, 7Art                        Total Q7: 19

                                                                            Maximum       Candidate
 No.                                  Criteria
                                                                              Mark          Mark
7Logo
7.1      Image manipulation                                                       7
          Wrapping of images changed to enable stacking               1
          Heart image style/shape changed to round shape              1
          'I Want Change' image cropped/resized                       1
          Text 'STREET ART' inserted  (Accept lower case)             1
          Text colour is light                                        1
          Original images arranged in the correct order               1
          Logo appears correctly as the example                       1

7Globe
7.2.1    Text watermark                                                           2
          Text watermark inserted                                     1
          Text 'Graffiti'                                             1
7.2.2    Sorting paragraphs                                                       2
          Paragraphs sorted                                           1
          In descending order  (Toronto ... Atlanta)                  1
7.2.3    Text inserted                                                            2
          Text from 7Europe.html file inserted                        1
          Linked to original document                                 1
7Art
7.3.1    Cell G3:                                                                 5
         =IF(E3<=$I$2,IF(F3>100,TRUE,""),"")

         OR
         =AND(E3<=$I$2,F3>100)

            Check if E3  smaller than or equal to date in $I$2       2
             (Accept NOW() OR TODAY())
            Check if F3  greater than 100                            2
            Display TRUE if both conditions are true                  1
7.3.2    Correct answer:                                                          1
          WC OR Western Cape                                          1
         Total for QUESTION 7                                                    [19]
                                                                TOTAL             180

Copyright reserved

## 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
- [Computer Application Technology P1 Nov 2019 Memo Afr](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2019-memo-afr/4a07e78a-9b1c-44e8-a466-b6c73c8cac4b) — Computer Applications Technology · Memo · 2019 · Afr
- [Computer Application Technology P1 May June 2017 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2017-memo-eng/7e7366e7-46e1-4300-a0da-3e88eb4b2ece) — Computer Applications Technology · Memo · 2017 · Eng
- [Computer Application Technology P1 May June 2016 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2016-memo-eng/fb474999-ae1e-4cfe-b1bd-c4aac95bb1b8) — Computer Applications Technology · Memo · 2016 · Eng
- [Computer Application Technology P1 Nov 2019 Eng](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2019-eng/b91547f0-b4ca-4f13-97a6-41dff1f1cae0) — Computer Applications Technology · QP · 2019 · Eng
- [Computer Application Technology P1 May June 2021 Eng](https://www.hlayiso.com/library/computer-application-technology-p1-may-june-2021-eng/5be0bf0e-69bd-4481-9ce4-d56745874ad6) — Computer Applications Technology · QP · 2021 · Eng

## More from Grade 12 Computer Applications Technology

- [CAT P1 QP GR12 SEPT 2025 AFRIK watermark](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2025-afrik-watermark/1b848d13-4e0f-4b33-91ef-2fcd3dc2e6b9) — QP · 2025 · Afr
- [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 Afrikaans](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-afrikaans/82b87849-4ee6-4b20-8b30-633307bd7329) — QP · 2024 · Afr
- [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

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