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

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

- Page: https://www.hlayiso.com/library/cat-p1-gr12-memo-eng-sept-2014/f694b747-f711-4b51-8411-49573692810d
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2014
- 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 2014 Memo (Eng)](https://www.hlayiso.com/library/cat-p1-gr12-memo-eng-sept-2014/f694b747-f711-4b51-8411-49573692810d)

## About this document

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

COMPUTER APPLICATIONS TECHNOLOGY P1
            MEMORANDUM

NAME OF CANDIDATE:                                           GRADE:

SIGNATURE OF EDUCATOR:

          TOTAL          Q1      Q2     Q3      Q4      Q5        Q6   Q7

MARKS:      180           34     15     27      24          40    20   20

                     This memorandum consists of 9 pages.

### Page 2

Downloaded from hlayiso.com
2                  COMPUTER APPLICATIONS TECHNOLOGY P1                       (SEPTEMBER 2014)

QUESTION 1                          File: Q1_ID

No.    Criteria                                                         Max.           Mark

Open the file Q1_ID

1.1    Heading Identity Document formatted to Bold  and Dark
                                                                         2
       blue text colour 
1.2    Picture inserted and formatted as follows:
           Picture labelled smart id used 
           Picture centre aligned  and text wrapped                   5
           3pt  border added 

1.3    Subheadings  on page 1 and 2 formatted to style
                                                                         2
       Heading 1 
1.4    New style created and formatted as follows:
          New style Register elections created
          Style based on Heading 2 
          Comic Sans size 16 used 
          Blue paragraph border 
          With pink background                                         6
          New style set to change automatically 

1.5    Table of Contents created and modified as follows:
            Formatted text with Modified Heading 1 style 
            Page numbers not shown 
                                                                         6
            Hyperlinks is shown instead 
            Only one level shown 
            Modern style used 
1.6    Footer added 
       “Quote by Mandela” added 
                                                                         4
       Automatic page numbering added 
       Not on cover page 
1.7         Cover page added, any style 
                                                                         2
            Main heading of the document 
1.8    Paragraph spacing for the entire document changed to 12pt
                                                                         2
       after each paragraph 
1.9    “Copy” watermark inserted 
                                                                         2
       Horizontally displayed 
1.10   Word “identity”  replaced with word “ID” in all occurrences 
       Appear in red font  (13 replacements)                            3

                                                                        [34]

### Page 3

Downloaded from hlayiso.com
(SEPTEMBER 2014)         COMPUTER APPLICATIONS TECHNOLOGY P1                      3

 QUESTION 2                     File: Q2_Brochure

 No.    Criteria                                                     Max.      Mark

 Open the file Q2_Brochure

 2.1    Margins changed to narrow                                    1
 2.2    Document formatted as follows:
           Orientation Landscape 
           Column break inserted as indicated on Annexure           4
           Insert columns with a line between 
           Column width 8.22 cm and spacing 1.25 cm
 2.3       6pt 
           Art border inserted                                      3
           whole page
 2.4    Electronic form in the 3rd column formatted as follows:
           Table inserted 
           13 columns and 1 row to 0.4 cm 
           Text form field added to “Municipality” 
           Drop down list added to Province                         6
           Edit list to “Western Province”, “Eastern Province”,
              “Gauteng”, “Kwazulu-Natal” and “Northern Cape” 
           Check box added to the sentence “You are eligible …” 
 2.5    Pictures are grouped as one object                            1
                                                                     [15]

### Page 4

Downloaded from hlayiso.com
4                  COMPUTER APPLICATIONS TECHNOLOGY P1           (SEPTEMBER 2014)

QUESTION 3                      File: Q3_Budget

No.    Criteria                                             Max.           Mark

Open the Wards_2014 worksheet.

3.1    Width of all cells have been adjusted                1
3.2    Red Colour of sheet Wards_2014 changed to Blue       1
3.3    Hyperlink of thumb.jpg image inserted in cell A1
                                                             2
3.4    Cell K2 =(F2-K1)*24-3
           Formula: =(F2-K1) *24                          3
           - 3 hours for lunch breaks 
3.5    Cell K22 =SUM(K2:K20)*45.25
           =SUM(K2:K20)                                    2
           Correct value used: 45.25 
3.6    Cell C2
       =LOWER(CONCATENATE(LEFT(A2,2),"*",RIGHT(B2,3)))
           Function: =LOWER
           (CONCATENATE)                                   5
           "*"
           LEFT(A2,2) 
           RIGHT(B2,3) 
3.7    Cell H2 =D2*G2                                       1
3.8    Cell J2 =H2-I2 
                                                             2
       Auto fill down to Cell J22 
3.9    Cell D25 =COUNTA(A2:A20)
           Function = COUNTA                               2
           Range (A2:A20) 
3.10   Conditional formatting to Range I2:I20

                                                             2
           Red font 
           Underlined (yellow)
3.11   Cell D26 =RANDBETWEEN(10,20)
           Function: =RANDBETWEEN                          2
           (10,20) 
3.12   Cell H27
       =IF(D2<=69,G2*8%,G2*12%)                           3

3.13   SA Currency added to Column G, H and I                1
                                                            [27]

### Page 5

Downloaded from hlayiso.com
(SEPTEMBER 2014)       COMPUTER APPLICATIONS TECHNOLOGY P1                  5

 QUESTION 4                  File: Q4Ward_Reps

 No.    Criteria                                               Max.      Mark

 Open the Ward_Reps worksheet.

 4.1    Displayed cellphone number correctly in Range D3:D28
            Format Cells to Custom and 
            Insert 0########## 
            Or set as Text

                                                                 2

 4.2    Cell F3 = E3*$L$2 (Correct cells used)
        Multiplication used                                     3
        Absolute Reference used in $L$2 only 
 4.3    Cell E33 = SUMIF(A3:A28,"Ward Fynbos",E3:E28)
            Function: SUMIF 
            Range: A3:A28                                      4
            Ward Fynbos Ward: "Ward Fynbos" 
            Range: E3:E28 
 4.4    Cell C35 =COUNTIF(C3:C28,"F")
            Function: COUNTIF                                  2
            Criteria: F 
 4.5    Cell D36 =COUNTBLANK(D3:D28)
            Function: COUNTBLANK                               2
            RANGE: D3:D28 
 4.6    Cell J12: =VLOOKUP(B12,V_Lookup!A2:B27,2,FALSE)
            Function: VLOOKUP 
            lookup_Value: B2 
                                                                 5
            table_array: V_Lookup!A2:B27 
            index_num: 2 
            range_lookup: FALSE 
 4.7    Create 3D Pie Chart:
            3D-Pie chart created 
            Data labels display as percentage 
            Chart Title – Youth-2014                           6
            Chart Title – bold italic 
            Chart Title – Strike through effect added 
            Chart Title – Yellow solid fill 
                                                               [24]

### Page 6

Downloaded from hlayiso.com
6                  COMPUTER APPLICATIONS TECHNOLOGY P1               (SEPTEMBER 2014)

QUESTION 5                       File: Q5_Reps Info

No.    Criteria                                                 Max.           Mark

Open the Ward_Reps table.

5.1    Contact No field formatted as follows
          Data type: Text                                      3
          Input Mask: "0"000000000 
5.2    New field added:
          Above Ward Representative                            2
          New Field name Title 
5.3         Drop down list added 
            Row source type: Value List                        3
            Row source: “Mr”, “Mrs”, “Prof” 
5.4    Table sorted in ascending order of Ward Representative
                                                                 1
       field 
5.5    Computers field renamed to Computer Skills 

                                                                 2

       NB: Caption used instead of rename function 
5.6    Format Ward field to Capital Letters
                                                                 1
           Format: > 
5.7    Validation rule and Text added to Gender field
           Gender field formatted 
           Validation Rule: “F” or “M” 
           Any validation text acceptable 
                                                                 3

5.8    Primary Key set on Ward ID field                         1
5.9    T-Shirt costs field moved to after T-Size field          1

Open the Ward_Reps query.

5.10   Query modified as follows: (3 records displayed)
          Gender: M 
          Computers: Advanced 
          Medical Aid: Yes 
                                                                 3

### Page 7

Downloaded from hlayiso.com
(SEPTEMBER 2014)         COMPUTER APPLICATIONS TECHNOLOGY P1             7

 5.11   Query created based on Accommodation table
            Query name: Voters Accom 
                                                                   3
            Show all database fields 
            Contact number field hidden 
 5.12   Calculated field added:
            Field Name: Deposit 
            Calculate 25% of the 
            Rate field 
            Display as Rand                                      4

 Open the form MyVote

 5.13   Logo inserted:
        5.13.1 Insert SA Flag logo in the header top right        1
        5.13.2 Image resized to 4 cm  x 4 cm                     1
        5.13.3 Background colour of all form fields to yellow     1

 5.14   T-Shield Size field converted to combo box
            Change to Combo Box 
            Data Row Source Type changed format to                4
              Value List 
            Edit List to “S” “M” “L” “XL” “XXL” 

 Open the Report Total Costs

 5.15   Report modified as follows:
           Changed page orientation to Landscape 
           Today’s date displayed on the page footer 
                                                                   6
           Report grouped according to the T-Shirt size 
           Sorted by Ward Representative of field 
           Calculate the Total T-Shirt cost per group 
                                                                  [40]

### Page 8

Downloaded from hlayiso.com
8                  COMPUTER APPLICATIONS TECHNOLOGY P1              (SEPTEMBER 2014)

QUESTION 6                     File: Q6Webdesign

No.    Criteria                                              Max.             Mark

Use the application program Notepad

6.1    The title of the web page is “Election Help”.          1
6.2    Heading “IEC” should be centre align horizontally      1
6.3    Insert the image called IEC.jpg 
            above the IEC Heading                            3
            Right align 
6.4    Format the paragraph heading “when can I register::
            font face: comic sans
                                                               3
            size: 6 
            colour: green
6.5    “You must be” to an upper case alphabetical list. 
         A. be a South African citizen
                                                               2
         B. be at least 16-years-old
         C. and have a green, bar-coded ID book
6.6    Insert a hyperlink to the isiXhosa.pdf  and
       “Important” 
                                                               4

6.7    Format the table (position)
          a caption “ACCOMMODATION” should display 
          table headers should be bold 
                                                               6
          table data should be entered correctly 

                                                             [20]

### Page 9

Downloaded from hlayiso.com
  (SEPTEMBER 2014)              COMPUTER APPLICATIONS TECHNOLOGY P1                           9

QUESTION 7                          File: Q7_Intergration

No.    Criteria                                                                    Max.      Mark

Open the file Q7_Intergration

7.1 7.1.1            numbering x of y on the right hand side of the footer 
                                                                                    2
                     start on the 2nd page. 
      7.1.2          Date added correctly  and must update
                                                                                    2
                      automatically 
7.2 7.2.1            Correct data exported 
                     Export Totals to Rich text                                   3
                     Renamed to Q7_export 
      7.2.2          Import Register spreadsheet to new table. 
                     Rename table Import                                          4
                     Save correctly 

7.3 7.3.1            Merge fields Name  and Surname  added
                                                                                    2
      7.3.2          Letters sorted in ascending order by name.                   1
      7.3.3          Mail merge completed 
                                                                                    2
7.4 7.4.1            Track changes accepted                                       1
    7.4.2            Track changes turned off                                     1
    7.4.3            Income renamed to Egos_Income                                1
    7.4.4            Comment in CELL C4 deleted. (Egos_Income sheet)              1
                                                                                   [20]

                                                                          TOTAL:   180

## Related documents

- [RTT V1 MEMO GR12 Afr SEPT 2014](https://www.hlayiso.com/library/rtt-v1-memo-gr12-afr-sept-2014/801181e3-10fd-4f1f-b41a-34de5cd7b428) — Computer Applications Technology · Memo · 2014 · Afr
- [CAT P1 Nov 2014 Memo Eng](https://www.hlayiso.com/library/cat-p1-nov-2014-memo-eng/b86e3e92-d8e8-45bf-b778-e2e28b3fd24c) — Computer Applications Technology · Memo · 2014 · Eng
- [CAT P1 MEMO GR12 SEPT 2022 English](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2022-english/837c4abb-40c6-4f10-a6eb-4a6db8bfe1b4) — Computer Applications Technology · Memo · 2022 · Eng
- [CAT P1 MEMO GR12 SEPT 2021 Afr D](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2021-afr-d/528606a4-6c50-4abf-95fd-6bf9eee17db9) — Computer Applications Technology · Memo · 2021 · Afr
- [CAT P1 MEMO GR12 SEPT 2021 ENG D](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2021-eng-d/1b3ca7d1-9908-4164-be1b-cb607c6c21e1) — Computer Applications Technology · Memo · 2021 · Eng
- [CAT P1 GR12 MEMO SEPT 2020 Afrikaans](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2020-afrikaans/8de0d6b8-beca-46cb-8a39-0618c4e464e6) — Computer Applications Technology · Memo · 2020 · 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.
