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

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

- Page: https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2015-eng/72245bd8-e380-4a2c-a53d-71c10008964d
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2015
- Exam period: Eastern Cape Mock Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 11

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 2015 Memo (Eng)](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2015-eng/72245bd8-e380-4a2c-a53d-71c10008964d)

## About this document

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

COMPUTER APPLICATIONS TECHNOLOGY P1
            MEMORANDUM

NAME OF CANDIDATE:                                            GRADE:

SIGNATURE OF EDUCATOR:

          TOTAL          Q1      Q2      Q3      Q4          Q5    Q6   Q7

MARKS:      180           35     15      42       8          40    22   18

                     This memorandum consists of 11 pages.

### Page 2

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

QUESTION 1                     File: Q1Newsletter_Nuusbrief

No.        Criteria                                                      Max.             Mark
1.1       Margins
                                                                           1
          Top-and bottom margins 1.5cm
1.2       1.2.1 Font Formatting: Heading ‘The cost saving” formatted
                   to:
                                                                           2
                    Garamond font
                    12pt.
          1.2.2 Line Spacing
                    Line spacing set to Exactly                          2
                    14pt
          1.2.3 Bulleted list
                    Text under heading ‘Resource Library’ is a bulleted
                       list                                               2
                    Bullets are customised with the image tablet vs
                       textbooks
1.3       Find and Replace
           2 occurrences of ‘TRAIN YOUR BRAIN’ with ‘TYB’
                                                                           2
           Displayed in bright green font
          (Note to marker: Total occurrences of TYB is 2)
1.4       Columns
           Correct text selected
           In three columns                                              4
           Line appears
           Text in columns fully justified
1.5       1.5.1 Styles
                    New style called Lets go digital createdbased on
                       heading style 1                                    4
                    Surrounded by a shadow border
                    Paragraph spacing after 2.5 pt
          1.5.2  Lets go digital style applied to headings highlighted
                                                                           1
                       in red: ‘How it all works’

      Copyright reserved                                                        Please turn over

### Page 3

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

1.6       Table of Contents
           Page break inserted
           Heading Table of Contents displayed
           Format change to Distinctive
           Contents display with tab leaders
           TOC levels changed to displayed the correct order
          (According to the screen shot below)

                                                                     5

1.7       Watermark
           Picture watermark applied (correct image 1Chart used)   2
           Scale set to 150%
1.8       Page numbering
           Odd and Even page numbering
           In the footer/header of the document                    5
           Odd left and Even right aligned
           Start from number 10 (using ms word function)
1.9       Date 31 March 2001
          Two hard spaces inserted (one mark for each)
                                                                     2
          31°March°2001
1.10      Character spacing
           Character spacing expanded to 3 pt
                                                                    3
           Text appears in upper case (capital letters)
           Is right-aligned
                                            Total for QUESTION 1: [35]

Copyright reserved                                                       Please turn over

### Page 4

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

QUESTION 2                File: Q2SubjectChoice_Vakkeuse

No.     Criteria                                                       Max.         Mark
2.1     Hyperlink
                                                                         1
           Removed
2.2     Symbol inserted
        Windows symbol  correctly inserted between ‘Subject             1
        Choices” and ‘Vakkeuse’ 
2.3     Paragraph border
         Paragraph border added
                                                                         2
           Only top and bottom borders appear
        (Do not accept text boxes, tables or any drawing shapes)
2.4     Drop-down control added
        Drop-down control for Group 2 label has the options
                                                                         1
        Accounting/Geography/Business Studies
        (Do not penalise if not in correct order)
2.5     Check box added
         Check box control added for the
            Mathematics/Mathematical Literacy option                    2
         Align with tab stop at 8 cm
        (Do not accept the use of default tab stops)
2.6     Properties of Surname/Van field set to allow 10 characters      1
2.7     Table properties
         Table inserted with 1 row and 10 columns
         Table/columns set to ‘AutoFit to contents’                    3
         Row height set to 0.8 cm
        (Do not penalise incorrect positioning)
2.8     Signature line added
         Signature line added using a tab stop with any tab            2
            leader
2.9     Password
           Password ‘Help’ inserted                                    2
         Editing option: Filling in form
                                                 Total for QUESTION 2: [15]

Copyright reserved                                                        Please turn over

### Page 5

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

QUESTION 3                  File: Q3Staff_Personeel

No. Criteria                                                         Max.          Mark
3.1 Row 1
                                                                      1
      Merge and centre cells A1 to P1
3.2 Cells A1 to P1
                                                                      1
        Fill colour changed
3.3 Cells A3 to P3
                                                                      1
     Headings align to 90˚ angle
3.4 Cell F12
                                                                      1
     Date formatted in dd-mmm-yy format, eg. 20-Jan-80
3.5 Cell D4 = UPPER(CONCATENATE(A4,RIGHT(B4,1),’’*’’,LEFT(C4,3))))
                                    OR
    Cell D4 = UPPER(A4 & RIGHT(B4,1) &”*” & LEFT(C4,3)))
     CONCATENATE or & operator
     A4                                                             6
     asterisk “*”
     RIGHT (B4,1)
     LEFT (C4,3)
     UPPER
3.6 3.6.1    Columns H3 to J3
             =COUNTA(H4:H21)
              COUNTA
                                                                      2
              H4:H21
                                    OR
              =COUNTIF (H4:H21,"Laptop")
    3.6.2    Columns H3 to J3
             =COUNTIFS(H4:H21,"Laptop",I4:I21,"Smartphone")
              COUNTIFS                                              3
              H4:H21 Laptop
              I4:I21 Smartphones
3.7 Cell K4
    =ROUND(((TODAY()-G4)/365),0)
     (TODAY)
     - G4                                                           5
     / 365 days
     ROUND
     0 decimals
3.8 Cell L4
    =IF(K4>=30,"Gold",IF(K4>=20,"Silver","No Certificate"))
     IF
                                                                      4
     K4>=30,"Gold" 
     K4>=20,"Silver"
     "No Certificate"
3.9 Cell C22=LEN(C16)
     LEN function used                                              2
       Correct cell range

   Copyright reserved                                                  Please turn over

### Page 6

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

3.10   Column M22
       =COUNTBLANK(M4:M21)
                                                               2
        COUNTBLANK 
        (M4:M21)
3.11   Cell O9
       =N9*120
        N9                                                   3
        * 120
        O9 formatted to currency
3.12   Cell O22
       =SUMIF(E4:E21,"F",O4:O21)
        SUMIF
                                                               4
        E4:E21
        “F” 
        O4:O21
3.13   Sheet 1 renamed to Invoice                             1
3.14   Cell C20:
       VLOOKUP(B20,Costs_Lookup!A$2$:$D$12,2,TRUE)
        VLOOKUP 
        B20
                                                               6
        Costs_Lookup!A$2$:$D$12
        Absolute cell reference used
        Copied to C20:C30
        2,TRUE 
3.15   Cell D15
                                                               1
       =Now()
                                       Total for QUESTION 3: 42

Copyright reserved                                              Please turn over

### Page 7

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

QUESTION 4                      File: Q4Marks_Punte

No.      Criteria                                                  Max.               Mark
4.1      Graph
            Correct data range used C10:I10 and C2:I2
            Column chart created
            Data labels centred
            Legend renamed to Asanda Lamani                           8
            and correctly displayed
            Minimum of the y-axis changed to 20
            and Maximum to 100
            Chart moved to Graph sheet
                                             Total for QUESTION 4: 08

Copyright reserved                                                          Please turn over

### Page 8

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

QUESTION 5                           File: Q5_Reps Info

No.               Criteria                                                  Max.            Mark
5.1 5.1.1          Name of tab field appear before Model field
                                                                             2
                   Primary key added to Name of tab field
          5.1.2   Data type of DatePurchased field added to Date/Time       1
          5.1.3    New field Operating systems 
                   added before Screen size field                          3
                   Data Type: OLE Object or Hyperlink
          5.1.4    Field size of Review: Double
                                                                             2
                   Decimal place: 1
          5.1.5    Data type for Available colours field set to Lookup and
                     Colours Black, White, Grey and Red entered
                   Limit to list checked

                                                                             2

                  (Note to marker: Accept two and more entries)
          5.1.6   Field Name of Tab: Input mask >LL\_000
                   Upper case and two letters >LL                          2
                   Underscore and three digits _000 
          5.1.7   Field Name of tab
                  Record no 6 spelling–from ‘Goegle’ to ‘Google’            1
                  (Do not accept incorrect spelling)
5.2               Query: Q5Androids
                     Display all fields
                     Criteria: Like “A”

                                                                             2

      Copyright reserved                                                           Please turn over

### Page 9

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

5.3       Query: Device info
           Only Name of Tab, Storage, Screen size and Current Value
            fields displayed
           Criterion for Current Value field: >10 000
           Sorted by ‘screen size in alphabetical order
           Saved as Q5Modified
                                                                                        4

5.4       Query: Q5Tabs Query
          Deposit: [Current Value]*0.2
           New field called Deposit
                                                                                        4
           [Current Value] 
           Multiply
           0.2
5.5       Form: Q5Signals_Seine
          5.5.1 Operating system field removed                                     1
          5.5.2  Date added as a field                                            2
                  In the footer of the form
                 (Do not penalise if both date and time are added)
          5.5.3  List box control added to the form                               5
                  Values (Wi-Fi, 3G, and LTE) added to the control box
                  List box controls links to Connectivity_Seine
                  Suitable label linked to Name/Discription of the field
                  Label formatted to resemble existing labels
                   (If candidate used a combo box instead of a list box they will
                   lose 1 mark)
5.6       5.6.1    Paper size changed to Letter                                    1
          5.6.2    Page number inserted.                                            3
                    = “Page” &[Page]& “of” & [Pages] 
                    Right Aligned 
                    At the Bottom of the report 
          5.6.3    Date inserted                                                    1
                   =Date()
          5.6.4    =Count(*)                                                      3
                   Any appropriate label: Total No of Tabs

          5.6.5    Report Heading: Q5Favourites_Gunsteling                          1
                   formatted to blue font colour 

                                                       Total for QUESTION 5: [40]

      Copyright reserved                                                                    Please turn over

### Page 10

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

QUESTION 6                          File: Question6.Html

No.       Criteria                                                     Max.             Mark
6.1                                                                     1
          <title>Tablets on wheels</title>
6.2         < img src = “Q6_Logo.jpg” 
            align = “right” 
                                                                         4
            height = “100”  width= “100” 

6.3       <h1>Contact Details</h1>                                      1
6.4       <b>Address</b>                                                1
6.5        <font face = “Algerian” color = “red”> 
                                                                         3
          <font> </font> tag
6.6       <ul type = “square”> 
          <li></li>
              <li> Acer </li>
                                                                         4
              <li> Apple </li>
              <li> Lenovo </li>
          </ul>
6.7       Shipment

                                                                         5
          <table border = "5" cellpadding = "8"> </table>
          6.7.1 <table border = “5” 
          6.7.2 cellpadding = “8” 
               <th> Standard </th>
                <td></td>
6.8       <a href = "Tablets-v-textbooks.jpg"> "e-Books" </a href>
          <a href> </a href>
                                                                         3
          “Tablets-vtextbooks.jpg”
          Linked to the word “e-Books” 
                                                 Total for QUESTION 6: [22]

Copyright reserved                                                            Please turn over

### Page 11

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

QUESTION 7                     Open the file Q7Myfile

No.       Criteria                                                 Max.            Mark
7.1       Subfolder music created                                  1
7.2       MP3 Files moved into the music folder
          (4 files)                                                  1
7.3       Types of tablets Size = 11 KB                             1
7.4       Selfie.docx protect with password 
                                                                     2
          #Self12
7.5        Tables.docx converted to Tables.pdf
                                                                     2
           Tables.docx removed
7.6       Chart Staff_Personeel exported and linked 
                                                                     2
7.7         Ultimate7 compressed
                                                                     2
            Ultimate7 renamed to Q7Compress
7.8       Q7MyFile sorted descending by size
                                                                     2
          Screenshot added
7.9       Q7Answersheet_Antwoordblad
                                                                     1
          Students Name as Author
7.10       Envelope correctly created
           Delivery address correctly entered 
           Return address correctly entered
           Merge complete successful

                                                                     4

                                              Total for QUESTION 7: 18

                                                           TOTAL: 180

Copyright reserved                                                       Please turn over

## Related documents

- [CAT P1 GR12 MEMO SEPT 2015 AFR](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2015-afr/e7b20f60-c3b1-44da-aa1e-3bc6f06b937d) — Computer Applications Technology · Memo · 2015 · Afr
- [CAT P1 SEPTEMBER 2015 ERRATA](https://www.hlayiso.com/library/cat-p1-september-2015-errata/4afc69af-514d-4061-bc09-01a17d1bf421) — Computer Applications Technology · Errata · 2015
- [CATN P1 GR12 SEPT2015 QP Afr](https://www.hlayiso.com/library/catn-p1-gr12-sept2015-qp-afr/5b26d882-c5a2-45a8-96f9-3044ac09280e) — Computer Applications Technology · QP · 2015 · Afr
- [CATN P2 MEMO GR12 AFR SEP 2015](https://www.hlayiso.com/library/catn-p2-memo-gr12-afr-sep-2015/e93173b1-3656-4239-af0b-822a4acf42d0) — Computer Applications Technology · Memo · 2015 · Afr
- [CAT P1 Nov 2015 Memo Afr](https://www.hlayiso.com/library/cat-p1-nov-2015-memo-afr/ec56d95b-8740-4d2e-970a-bdbe22ca475f) — Computer Applications Technology · Memo · 2015 · Afr
- [CAT P1 Nov 2015 Memo Eng](https://www.hlayiso.com/library/cat-p1-nov-2015-memo-eng/665607d0-ebce-4a13-8397-d47212e70694) — Computer Applications Technology · Memo · 2015 · 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.
