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

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

- Page: https://www.hlayiso.com/library/gr12-catn-p1-sept2017-memo-eng-2/b5c28ac2-09a3-4703-849c-349924c32018
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2017
- Exam period: Eastern Cape Mock Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 9

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 2017 Memo (Eng)](https://www.hlayiso.com/library/gr12-catn-p1-sept2017-memo-eng-2/b5c28ac2-09a3-4703-849c-349924c32018)

## About this document

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

  COMPUTER APPLICATIONS TECHNOLOGY P1
                           MEMORANDUM

NAME OF CANDIDATE:                                               GRADE:

SIGNATURE OF EDUCATOR:

         TOTAL          Q1       Q2      Q3       Q4        Q5      Q6    Q7

MARKS:     180          36       14      52       42        20      10    06

                     This memorandum consists of 9 pages.

### Page 2

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

QUESTION 1     File Name: 1_Turtle Facts
  No                           Criteria                                Max           Mark
 1.1  Left and bottom margins set to 1.5 cm.                          1
 1.2 1.2.1  Heading “Save The Sea Turtles” added in the title
                                                                         1
             control on the cover page. 
     1.2.2  AutoShape filled with the image 1_Save The Turtle
            Height and width set to exactly 8 cm.                     3

 1.3       Condensed spacing applied to the heading “BASIC
            FACTS ABOUT SEA TURTLES”.                                   2
         Spacing is 1.5 pt. 
 1.4     Drop Cap effect applied to the highlighted letter “S”
            dropped over 4 lines.                                       2
         Distance from the text is 0.5 cm.
 1.5    Style
         Yellow font colour applied to the existing style
            “Sub Turtle”.                                               2
         The rest of the text with the existing style is updated
            automatically. 
 1.6    Columns
         Highlighted paragraphs placed in 2 columns with a line in
            between. 
                                                                         3
         Column spacing is set to 1.5 cm. 
         Applied column break after the first paragraph so that the
            other three paragraphs are moved to the second column
 1.7     Glow effect applied to the text box.                          1
 1.8     Existing footnote changed to an endnote. 
                                                                         2
         Endnote symbol changed to ‘*’ symbol. 
 1.9     Cell spacing of the table changed to 0.5 cm
         Count
                                                                         3
         (Above)  function used
        (Answer 7 – no marks if the answer is just typed)
 1.10    Multilevel bullets applied to the list under the heading
            Glossary (not just as a bullet). 
         Bullet 1.jpg used as first level.                            `3
         And Bullet 2.jpg as second level respectively. 
 1.11   Bibliography
         Month edited and changed to August. 
                                                                         2
         Comment inserted that reads Save Sea Turtles. 
        NB: check if it is updated in the bibliography as well.
 1.12   Page orientation
                                                                         1
        Orientation of only the last 2 pages changed to landscape.
 1.13   Table and Image caption
         Outer table border changed to dashed line.
         Thickness is 4½ pt.                                           3
         Caption inserted to the correct image and it reads “Green
            Sea Turtle”.

Copyright reserved                                                           Please turn over

### Page 3

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

 1.14       Inserted section break for the last 2 pages. 
            Page numbering applied in any format in the page
             header.                                                   3
            Numbering starts from 1 onwards. 
 1.15       Hyperlink added to the word TOP OF THE DOCUMENT.
            Linked created to the top of the document.                2

 1.16       Watermark inserted only on the cover page (any correct
             method can be awarded marks).                             2
            Watermark reads Billion Baby Turtles. 
                            Total for QUESTION 1                       [36]

QUESTION 2        File Name: 2_Observation Form
  No                              Criteria                             Max         Mark
 2.1  Paragraph shading added to the heading "Sea Turtle
         Observation Form”.                                            2
      Any shade of green colour. 
 2.2 Text form field for the heading “How many turtles…”
     formatted:
                                                                        2
      To accommodate 2 characters,
      with no decimals places displayed. 
 2.3  “Select One Below” option added to the existing list. 
                                                                        2
      That appears as the first option in the list. 
 2.4  Date field changed to d MMMM yyyy format.                       1
 2.5  Image cropped to resemble as follows: 

                                                                        1

 2.6        Help text added to the cell number field.
            Text “Please Enter only 10 Digits” entered correctly.     2

 2.7      14 cm right aligned tab applied
          With solid leader tabs                                      2
         NB: reduce 1 mark if not done for all the three headings.
 2.8      Screentip for the email address 
                                                                        2
          To read as “Help Us To Save SEA Turtles” 
                            Total for QUESTION 2                       [14]

QUESTION 3        File Name: 3_Turtle Campaign
  No                            Criteria                               Max         Mark
 Info worksheet
 3.1   Cell H1:
                                                                        1
           Date in cell H1 changed to dd mmm YY format. 
 3.2       Cells A1:G2 merged and centred.                            1

Copyright reserved                                                       Please turn over

### Page 4

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

 3.3    Cell A3:O3 :
            Thick cell borders applied.                                 2
            Left and right borders of the cells changed. 
 3.4    Row 3 freezed                                                    1
 3.5    Cell A4:
        =CONCATENATE(B4,LEN(E4),"#code")

        OR

        =B4&LEN(E4)& "#code")                                             5
             CONCATENATE function OR & sign
             B4 
             LEN  (E4) 
             “#code” 
 3.6    Cell H4:
        =ROUNDUP(($H$1-G4)/365.25,0)
             ROUNDUP function 
             Use of correct cells H1 and G4
             Minus sign (-) used correctly                              6
             Divided by 365.25 (or 365) 
             Absolute cell reference used 
             Formatted to zero decimal places
        (Note to marker: Accept any other suitable method.)
 3.7    Cell N20:
        =(I20)*$I$2+(J20)*$J$2+(K20)*$K$2+(L20)*$L$2+(M20)
        *$M$2
        OR
        =I20*$I$2+J20*$J$2+K20*$K$2+L20*$L$2+M20*$M$2
             Values from I20:M20 correctly multiplied with values in     3
               I2:M2 
             + sign used correctly between the cells
             Absolute cell reference used 
        (Answer: R200)
 3.8    Conditional formatting:

                                                                          3
            Values between 200 and 250 shaded
            2 colour shading applied
 3.9    Cell O4:
        =IF(($P$1-N4)<=0,"Adoption Cert",IF(($P$1-N4)>100,
        "Participation Cert","-"))
            IF function 
            Condition ($P$1-N4)<=0 and value                            6
            Condition ($P$1-N4)>100 and value 
            Value if all conditions are false 
            Absolute cell reference used 
            Correct use of open and closing brackets 

Copyright reserved                                                            Please turn over

### Page 5

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

 3.10 Cell E51:
       =SUMIF(E4:E49,E5,N4:N49)
       OR
       =SUMIF(E4:E49, “Platinum”,N4:N49)
           SUMIF function 
                                                                        4
           Range E4:E49 
           Criteria Platinum or any cell number that contains the
            value Platinum 
           Sum range N4:N49 
       (Answer: R1 640)
 3.11 Cell E52:
       =COUNTIF(F4:F49,F6)
       OR
       =COUNTIF(F4:F49, “SEE Turtles”)
           COUNTIF function                                           3
           Range F4:F49 
           Criteria SEE Turtles or any cell number that contains
            the value SEE Turtles 
       (Answer: 8)
 3.12 Cell E53:
       =AVERAGEIF(D4:D49,D33,C4:C49)
       OR
       =AVERAGEIF(D4:D49, “F”,C4:C49)
           AVERAGEIF function                                         4
           Range D4:D49 
           Criteria F or any cell number that contains the value F 
           Average range N4:N49 
       (Answer: 17.3)
 3.13 Cell E54:
       =COUNTBLANK(J4:J49)+COUNTBLANK(L4:L49)
           COUNTBLANK function 
                                                                        3
           Range J4:J49 and L4:L49
           + sign used correctly
       (Accept any correct method – answer is 44)
 Spotted worksheet
 3.14 Cell B2:
       =VLOOKUP(A2,LOOKUP!$A$1:$B$95,2,FALSE)
       OR
       =VLOOKUP(A2,LOOKUP!$A:$B,2,FALSE)
           LOOKUP value: A2                                           5
           Table array: LOOKUP!$A$1:$B$95
           Absolute cell reference used
           Column index number: 2
           Range_Lookup: FALSE

Copyright reserved                                                      Please turn over

### Page 6

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

 Graph worksheet
 3.15 Graph
          Data set for the year 2014 included in the graph. 
          Series overlapping is set at -50ͦ.
                                                                       5
          X axis name moved to the correct position. 
          Data labels displayed on top of each bar. 
          Minimum value for y axis set to 5. 
                         Total for QUESTION 3                        [52]

QUESTION 4         File Name: 4_Turtle Classification
 No                                Criteria                          Max           Mark
Table: Patient Details
4.1.1      Row height changed to standard height of 14.25.           1
4.1.2      Gridlines are changed to red colour.                      1
4.1.3      The list Threatened moved 
                                                                       2
           To the third position in the list. 
4.1.4      Data type for the diet field changed to MEMO/Long Text
                                                                       1
             data type.
4.1.5 Scientific Name field:
           Made as the required field                                2
           > symbol added in the format property field 
4.1.6   Input mask for Turtle Id field:
        L00\*9a
            L
            00                                                       5
            *
            9
            a
Turtle Images table and the frm4_2 form
4.2.1       Inserted the image Green sea turtle.jpg in the Turtle
               Images table.                                          2
            Displays in the form frm4_2 correctly.
4.2.2       Turtle images table exported to the exam folder. 
            Name of the file changed to Export4_2.                   2
Query: qry4_3
4.3

               Criteria
                Total Species field:< 400                             4
                OR
                <=399
               Criteria
                Diet field: Like "*jelly*" And Like "*crabs*"
                (Answer: 3 records)

Copyright reserved                                                         Please turn over

### Page 7

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

 Query: qry4_4
 4.4

             
             Criteria
             Turtle Name field: Between "G*" And "P*"
           Between And function used                                7
           G* and P* 
           Sorted in the ascending order of Turtle Name field
           Criteria
       Weight in Pounds: Round
       ([weight(in kg)]/2.2046,1)
       (Answer: 9 records)
 Form: frm4_5
 4.5       Border width of the image changed to 4pt. 
           Shadow effect applied to the image.
           Command button inserted in the form footer to exit
             the form.                                               6
           Dividing lines are not visible. 
           Default form view changed to continuous.
 Report: rpt4_6
 4.6    Report rpt4_6 created based on Classification Table
            Turtle Name, Tag ID, Colour, Weight (in kg) & Listed
              As are the only fields displayed.
            Report grouped based on Weight (in kg) field. 
            Grouping intervals set to 50s.
            Page numbering changed as shown below so that it will
              not be displayed in the first page of the report. 

                                                                      9

                =Count (IIf ([listed as]="critically
                 endangered",0))
                Proper label given for the calculation.
                              Total for QUESTION 4                   [42]

Copyright reserved                                                     Please turn over

### Page 8

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

QUESTION 5              File Name: 5_Save Us
 This question should be marked from the browser as far as possible, unless otherwise
    indicated or if it cannot be seen on the browser.
 A maximum of 1 mark will be deducted if one or more closing tags are omitted.
  No                                   Criteria                          Max  Mark
 5.1    Title
        <title> Save Sea Turtles </title>
                                                                          2
             ‘Save Sea Turtle' appears 
             In the browser tab 
 5.2    Horizontal Line Size
        <hr size="3" color="black"/>                                      1
             Size changed to 6 that comes within the heading. 
 5.3    Image Tag
        <img src="Baby Turtle.jpg" width="100%" height="45%"
        alt="Baby Turtle">
             Image tag added correctly 
                                                                          5
             Image source is Baby Turtle.jpg
             Width is 100%
             Height is 45%
             Alternate text is Baby Turtle
 5.4    Bold formatting
        <b>Seven</b>                                                      1
              Seven made Bold 
 5.5    Unordered List Type
        <ul type="square">
                                                                          2
             Attribute used is type 
             Attribute value for type is “square” 
 5.6    Table Heading
        <tr>
               <th colspan="2">
        <h1>Most Endangered Sea Turtles In The World</h1>
               </th>                                                      3
        </tr>
             <tr> </tr> new row added 
             <th> </th> tag added between the <h1> </h1> tag
             Colspan=”2” added as an attribute to the <th> tag
 5.7    Table Row color and font color:
        <tr bgcolor="green">
        <th><font color="white">Turtle Name</font></th>
        <th><font color="white">Scientific Name</font></th>
                                                                          2
        </tr>
             bgcolor attribute added after the <tr> tag to green
             <font> </font> added for both the headings with white
               colour attribute. 
 5.8    Caption tag
        <centered><caption>Table 1:List Of Endangered Turtle
        Species</caption></centered>
                                                                          3
             Caption tags used correctly
             Aligned to the bottom of the table
             Text inserted correctly and centred

Copyright reserved                                                        Please turn over

### Page 9

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

 5.9    Link
        <a href="http://www.SEETURTLES.org"
        target="_blank">SEETurtles.org</a>                                1
            The hyperlink tag corrected to add the attribute href
              before the website link. 
                           Total for QUESTION 5                         [20]

QUESTION 6         File Name: 6_Spotted By & Scientific Info
  No                              Criteria                              Max        Mark
 6.1 Spotted By & Scientific Info worksheet
                                                                          1
         Worksheets 2 and 3 hidden 
 6.2 Find and Replace
         Find and replace option used or any appropriate
            method                                                       2
         turtle changed to TURTLE in uppercase 
     (NB: -1 if not done fully)
 6.3 Unique name
         used conditional formatting to find the unique values in
                                                                          2
            the column
         Name of the person is Taylor
 6.4 Sorting
         Sorted first based on the Scientific name field in the
            descending order                                             3
         Then in the ascending order of Spotted By field
         Name of the turtle is Black Marsh Turtle 
 6.5 Password
         Cells A1:D1 protected
                                                                          2
         With password 2017
     (NB: award zero marks if the whole worksheet is protected)
                          Total for QUESTION 6                          [10]

QUESTION 7          File Name: 7_Winners List             7_Certificate
 7_Certificate (Word processing document)
 No                                 Criteria                                Max    Mark
 7.1    Mail Merge:
             Winners worksheet in 7_Winners List spreadsheet
               used as the data source. 
             Placeholders linked with appropriate fields. 
             In correct position
             Edited the recipient list to include all the Platinum          6
               Members and who achieved an adoption
               certificate. 
             Saved the merged letter as 7_CertificateMerged in the
               exam folder
                                                       (4 letters expected)
                            Total for QUESTION 7                            [6]
                                                                   TOTAL: 180

Copyright reserved                                                         Please turn over

## Related documents

- [GR12 CATN P1 Sept2017 MEMO Afr 2](https://www.hlayiso.com/library/gr12-catn-p1-sept2017-memo-afr-2/b5a0c65b-f27d-4e3e-85bd-cf66c1dcadc6) — Computer Applications Technology · Memo · 2017 · Afr
- [GR12 CATN P1 Sept2017 QP Eng 2](https://www.hlayiso.com/library/gr12-catn-p1-sept2017-qp-eng-2/7f2741dd-5b56-4f4d-9efb-26c2263be0a2) — Computer Applications Technology · QP · 2017 · Eng
- [CAT P2 GR12 MEMO SEPT2017 (Afrikaans)](https://www.hlayiso.com/library/cat-p2-gr12-memo-sept2017-afrikaans/f13e52b1-d03e-4ce0-9cbb-fd83efd28130) — Computer Applications Technology · Memo · 2017 · Afr
- [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 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 Nov 2017 Memo Afr Rewrite](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-afr-rewrite/4c3ced4d-1987-42e1-85c6-38ce6cec21d3) — Computer Applications Technology · Memo · 2017 · Afr

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