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

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

- Page: https://www.hlayiso.com/library/gr12-catn-p1-s16-memo-eng/999cfe79-26cb-4e2f-a155-caf3f7f7ae70
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2016
- 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 2016 Memo (Eng)](https://www.hlayiso.com/library/gr12-catn-p1-s16-memo-eng/999cfe79-26cb-4e2f-a155-caf3f7f7ae70)

## About this document

Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2016. 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 2016

  COMPUTER APPLICATIONS TECHNOLOGY P1
             MEMORANDUM

NAME OF CANDIDATE:          ____________________ GRADE:          _________

SIGNATURE OF EDUCATOR:      ____________________

          TOTAL        Q1       Q2       Q3      Q4         Q5    Q6     Q7

 MARKS:    180         32       18       50      15         33    20     12

                     This memorandum consists of 9 pages.

### Page 2

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

QUESTION 1                      File Name: 1_Heart Info
No                                      Criteria                                Max            Mark
1.1  1.1.1          Small caps effect added to the abstract on the cover
                                                                                 1
                     page.
         1.1.2      Soft edge rectangular picture style given to the picture
                                                                                 1
                     on the cover page. 
1.2       6pt spacing added before and after for the whole document.           1
1.3       Condensed spacing applied to the heading 'What Is Heart
            Attack…'                                                            2
          Spacing is 1pt 
1.4       Inserted a non-breaking hyphen between the numbers instead of
            an ordinary hyphen.                                                 2
          Inserted two times i.e. between 9-1-1.
1.5       Automatic caption added for the image. 
                                                                                 2
          Placed above the image. 
1.6       Footnote inserted with any symbol. 
                                                                                 2
          Footnote reads as 'Prescribed'. 
1.7       'Happy Heart' style applied. 
                                                                                 2
          To all the three paragraph headings shaded in green. 
1.8       Multilevel numbering used
          Level 1 is 1)…                                                       3
          Level 2 is a)… 
1.9       Three paragraphs placed in 3 columns
          With a line between
          Equal column width of 0.5 cm                                         4
          Applied column breaks to paragraph headings to start from the
            top. 
1.10      Name of the author inserted as 'James Beckerman' in the
            citation. 
          Citation updated in the document to include the name of the           2
            author as well. 
1.11       Section break included and changed the page layout to
                                                                                 1
            landscape. 
1.12       Table of Contents inserted on the second page of the
            document. 
           Format used is 'Distinctive'                                        3
           Only the three styles 'Love Heart', 'Heart Care', and 'Happy
            Heart' included in the TOC. 
1.13       Automatic page numbering inserted in the footer
           In any format
           No page numbers appear in the first and last page                  5
           Page numbering starts from 1 onwards

1.14       Left and bottom margins set to 1.5 cm.                              1
                            TOTAL FOR QUESTION 1                                [32]

    Copyright reserved                                                                 Please turn over

### Page 3

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

QUESTION 2                   File Name: 2_Heart Aware
 No                                  Criteria                         Max          Mark
 2.1     Text shading added to the heading 'Am I aware'
                                                                       2
         Any colour
 2.2 Text form field for the heading 'Surname' formatted
         To accommodate 20 characters                                2
         And to display in CAPITAL letters 
 2.3    Age field formatted so that
           It accepts 2 digits
           Help text added to the F1 key                             3
           The message reads ' Enter numbers between 20 and 70' 

 2.4           Check box form added to Male and Female option
               Check box size is exactly 15 pt.                      2

 2.5           Smoking option added to the existing list. 
               And moved to the top of the list.                     2

 2.6           Smoking and Fatty Diet grouped
               as a single object with the rest of the shapes        2

 2.7           10 cm tab set
               Dashed line leader tab set for 4 lines                2

 2.8    Formula inserted as follows
                                                  𝑊𝑒𝑖𝑔ℎ𝑡
                           𝐵𝑜𝑑𝑦 𝑀𝑎𝑠𝑠 𝐼𝑛𝑑𝑒𝑥 =                          3
                                                  𝐻𝑒𝑖𝑔ℎ𝑡 2 

                              TOTAL FOR QUESTION 2                    [18]

   Copyright reserved                                                      Please turn over

### Page 4

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

QUESTION 3                    File Name: 3_Heart Stat
No                                 Criteria                        Max          Mark
Patient Details worksheet
3.1   Cell O1:
                                                                    1
          Cell O1 formatted to display only the current time. 
3.2       Cells A1:L1 merged and centred.                         1
3.3      Cell A2:
             3_Heart Beat.jpg inserted in cell A2
                                                                    3
             Height is 1 cm
             Width is 15 cm
3.4      Cell A5:
         =CONCATENATE(LEFT(B5,1),LEN(C5),E5)
         OR
         =LEFT(B5,1)&LEN(C5)&E5
             CONCATENATE function OR & sign                       6
             LEFT  (B5,1) 
             LEN  (C5) 
             E5 
3.5      Cell H5:
         =G5/((H5/$O$2)*(H5/$O$2))
         OR
         =G5/POWER((H5/$O$2),2)
             G5                                                   5
             (H5/$O$2)*(H5/$O$2) OR POWER Function 
             Absolute cell reference used 
             Formatted to zero decimal places
         (Note to marker: Accept any other suitable method.)
3.6      Conditional formatting:
             Top three values shaded
                                                                    3
             Thin horizontal crosshatch pattern style applied
             Yellow pattern colour used
3.7      Cell N5:
         =VLOOKUP(I5,'BMI Category'!$A$5:$B$12,2,TRUE)
             LOOKUP value: I5
             Table array: 'BMI Category'!$A$5:$B$12
             Absolute cell reference                              6
             Column index number: 2
             Range_Lookup: TRUE
             Copied down for the rest of the cells

    Copyright reserved                                                  Please turn over

### Page 5

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

 3.8    Cell G26:
        =COUNTIFS(F5:F24,F5,M5:M24,M21)
            COUNTIFS function 
            Range: F5:F24 
            Criteria: F5 OR 'Male'                                           5
            Range: M5:M24 
            Criteria: M21 OR 'YES' 
        (Note to marker: Accept any other suitable method.)
 3.9    Cell G28:
        =COUNTBLANK(K5:K24)
                                                                               2
            COUNTBLANK 
            (K5:K24) 
 3.10   Cell G30:
        =ROUND(AVERAGE(O5:O24),0)
            ROUND function 
                                                                               4
            Average function 
            Range (O5:O24) 
            Zero decimal places 
 3.11   Cell G32:
        =SUMIF(F5:F24,F6,O5:O24)
        OR
        =SUMIF(F5:F24,"Female",O5:O24)
            SUMIF function                                                   4
            Range F5:F24 
            Criteria Female or any cell number that contains the value
              female 
            Sum range O5:O24 
 3.12   Cell P5:
        =IF(J5>=120,"Most Likely",IF(J5<80,"Not Likely","Least Likely"))
            IF function 
            Condition J5>=120 and value 
                                                                               5
            Condition J5<80 and value 
            Value if all conditions are false 
            Correct use of open and closing brackets 

 3.13   Graph
            Data label added to the highest value in the graph. 
            Highest data bar filled with the image 3_Overweight.jpg 
            Black outline applied to this data bar 
                                                                               5
            X axis values displayed in the reverse order. 
            Vertical gridlines displayed for both major and minor units. 

                             TOTAL FOR QUESTION 3                             [50]

   Copyright reserved                                                              Please turn over

### Page 6

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

QUESTION 4                   File Name: 4_Heart Patients
No                                   Criteria                           Max            Mark
Table: Patient Details
4.1        Row height changed to 20 pt.                                1
4.2        Vertical gridlines are visible.                             1
4.3    Customised alternate row colour
           Colour level for Red is 200 
                                                                         3
           Colour level for Green is 210 
           Colour level for Blue is 220 
4.4    Age column
           Average of ages found at the bottom of the age column.      2
           Corrected to zero decimal places. 
4.5    Input mask on the Patient Code field:
       >LL-009-"LPH"
           >
           LL 
           -                                                           6
           00 
           9
           LPH 
4.6        Patient code field made as the primary key.                 1
4.7        Data type for 'Money spent on junk food' field changed to    1
              currency. 
                           TOTAL FOR QUESTION 4                         [15]

    Copyright reserved                                                         Please turn over

### Page 7

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

QUESTION 5                            File Name: 5_Heart
No Criteria                                                                  Max           Mark
Table: Patient_History
5.1   Patient_History table:
          Applied a black gridline and                                      2
          Sunken cell effect to the table. 
5.2   5.2.1 Validation rule to gender field:
                  Male  or Female                                          3
              Validation message to gender field:
                  Any appropriate message 
      5.2.2 Change the Indexed field properties to Yes (Duplicates            1
              OK) 
5.3   Age field made a required field.                                       1
5.4
              Name, Age, Height (in cm), Body Mass (in kg) and BMR
               fields are displayed. 
              Calculated field name: BMR: 
                                                                              7
              BMR: 655.0955+ (9.5634 * [body mass (in kg)] ) +
               (1.8496*[height (in cm)] ) - (4.6756*[age] )
              All the signs used correctly. 
5.5

          Criteria
           Blood Pressure (Systolic) field: >120                            6
           OR >=119
          Criteria
           Blood Pressure (Diastolic) field: Between 90 And 95
          Criteria
           Suggested Action field: "*medical attention"
5.6       Name, Gender, Sugar Level and Risk fields inserted 
          Heading changed to Patient Sugar Levels
          Dividing lines are visible. 
                                                                              6
          Default form view changed to continuous
          5_Sugar Level.jpg inserted in the detail section
          Height and width of the image is 5 cm 
5.7
          Report created based on qry5_7 
          Report grouped based on Sugar Level (mmol/L) field. 
          Grouping intervals set to 10s
          Conditional formatting applied to Risk field with patients with    7
           Very High  risk shaded in red colour 
          =count(*) calculation used in the group footer
          Proper label given for the calculation.
                           TOTAL FOR QUESTION 5                              [33]

   Copyright reserved                                                               Please turn over

### Page 8

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

QUESTION 6                            File Name: 6_Healthy Heart
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
  6.1 Title
       <title>Healthy Heart</title>
                                                                                       2
             'Healthy heart' appears 
             In the browser tab 
  6.2 Font tag
       <font face="century gothic" size="3"> </font>
                                                                                       2
             font face is century gothic 
             font size is 3 
  6.3 Heading style
       <h1 align="center">Heart Disease & You</h1>                                     1
              Heart Disease & You appear as heading 1 
  6.4 Bold and Italics formatting
       <b><i>Cardiovascular Disease</i></b>
              Cardiovascular Disease made Bold 
                                                                                       2
              Cardiovascular Disease made Italics 
       NOTE: Reduce 1 mark if tags are not closed in the
                reverse order.
  6.5 Horizontal line size and colour
       <hr color="black" size=3 />
                                                                                       2
             Line size set to 3 
             Line color set to black 
  6.6 Table Row and Column:
       <tr bgcolor="White">
                <th> Blood Pressure Category </th>
                <th> Systolic mm Hg (Upper #) </th>
                <th> <img src="6_Heart Pressure.jpg"> </th>
                <th> Diastolic mm Hg (Lower #) </th>
       </tr>
             Image appears as the third heading in the first row
             Image displays correctly 
       ------------------------------------------------------------------------------
       <tr bgcolor="red">                                                              6
                <td>Hypertensive Crisis (Emergency care needed)</td>
                <td>Higher than 180</td>
                <td>or</td>
                <td>Higher than 110</td>
       </tr>
             Row added at the bottom of the table. 
             All the relevant text entered correctly in the row. 
             Background colour of the row changed to red. 
             All the tags used correctly. 

    Copyright reserved                                                                Please turn over

### Page 9

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

 6.7 Ordered List
     <ol type="A"> </ol>
                                                                        2
          Existing unordered list changed to ordered list. 
          List numbers appears as uppercase alphabets, e.g. A, B. 
 6.8 Link
     <a href ="Healthy life style.pdf">
                Click here to view the TIPS on how to live a Healthy
                Life Style provided by THE HEART
                                                                        2
                AND STROKE FOUNDATION SOUTH AFRICA
     </a>
          Link moves to ' Healthy life style.pdf ' 
          Link works correctly
 6.9 Center tag
     <center> Have Your Heart In The Right Place </center>              1
          The text is centred using the centre tag 
                           TOTAL FOR QUESTION 6                        [20]
QUESTION 7                    File Name: 7_Food Diary
                                   7_CHD Death Rates
                                   7_Awareness
No Criteria                                                           Max      Mark
7_Food Diary (Word processing document)
7.1 7.1.1         First two cells in the last row merged             1
     7.1.2 Formula used in the shaded region
             =SUM(ABOVE)
                                                                       2
                  SUM function used 
                  Criteria is ABOVE 
     7.1.3 Organogram
                  Shape added before the shape name Fruits           2
                  New shape given the name Healthy Protein 
7.2 7.2.1 Death rates worksheet
                  Graph edited to include South Africa as well       2
                  All the data values displayed correctly 
     7.2.2 Cell G7:
             ='Death Rates'!B7
                                                                       2
                  'Death Rates'! 
                  B7 
7_Awareness (Word processing document)
7.3 Mail Merge:
         Patient Details table in 4_Heart Patients database used as
           the data source. 
         Name and Surname fields added.                              3
         Mail merge completed and saved as
           7_AwarenessInvitation 
        (22 letters expected)
                          TOTAL FOR QUESTION 7                        [12]
                                                               TOTAL: 180

   Copyright reserved                                                   Please turn over

## Related documents

- [Gr12 CATN P1 S16 QP Eng](https://www.hlayiso.com/library/gr12-catn-p1-s16-qp-eng/4dfd583a-548e-452f-8c6b-bf78b063b75f) — Computer Applications Technology · QP · 2016 · Eng
- [Gr12 AFRHL P1 S16 QP Afr](https://www.hlayiso.com/library/gr12-afrhl-p1-s16-qp-afr/fa66d3f7-cac1-40ac-a0bb-dce31e15b66e) — Computer Applications Technology · QP · 2016 · Afr
- [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 2016 Memo Afr](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2016-memo-afr/bae774d9-2998-4624-894c-ed6d9704d0d1) — Computer Applications Technology · Memo · 2016 · Afr
- [Computer Application Technology P1 Nov 2016 Memo Eng Backup](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2016-memo-eng-backup/cf150881-0fe7-4a1c-b832-22729d7b3d99) — Computer Applications Technology · Memo · 2016 · Eng
- [CAT P1 Feb March 2016 Memo Afr](https://www.hlayiso.com/library/cat-p1-feb-march-2016-memo-afr/d4ce7e0c-1a86-4a4f-8d1c-e16ade0bc386) — Computer Applications Technology · Memo · 2016 · 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.
