# Computer Applications Technology Grade 11 P1 2014 Memo

> Grade 11 Computer Applications Technology Paper 1 memorandum from the Eastern Cape November 2014, 26 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/cat-p1-memo/8c51d7f8-5fbe-47f4-ab75-09fcea6e5854
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 11
- Document type: Memorandum
- Year: 2014
- Exam period: Eastern Cape November
- Paper: 1
- Curriculum: CAPS
- Pages: 26

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 11](https://www.hlayiso.com/library/grade-11) › [Computer Applications Technology](https://www.hlayiso.com/library/grade-11/computer-applications-technology) › [Computer Applications Technology Grade 11 P1 2014 Memo](https://www.hlayiso.com/library/cat-p1-memo/8c51d7f8-5fbe-47f4-ab75-09fcea6e5854)

## About this document

Computer Applications Technology · Grade 11 · Eastern Cape November · 2014. Memorandum, 26 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 11

                         NOVEMBER 2014

  COMPUTER APPLICATIONS TECHNOLOGY P1
             MEMORANDUM

NAME OF CANDIDATE:                                                GRADE:

SIGNATURE OF EDUCATOR:

          TOTAL          Q1      Q2      Q3       Q4         Q5       Q6   Q7

MARKS:      180          35      15       28      22         40       20   20

                     This memorandum consists of 13 pages.

### Page 2

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

 QUESTION 1

 No.      Criteria                                                             Max.          Mark

 1.1      Right Aligned,  Change to Italics.
          Traffic Accident Investigation in South Africa, disturbing            2
          facts.

 1.2      Heading 1 colour changed to red 
          Main heading formatted with modified Heading 1 style                 3
          All subheadings formatted with Heading 2 style 

 1.3      Report Reference added:  In the correct position 
            Author: Volminck,S,D, Nathan 
            Title: News Updater 
            Year: 2013                                                        7
            City: Pretoria 
            Publisher: Daily News 

 1.4      3pt page border  around the document. 
                                                                                2

 1.5          Caption “Vehicle Types “added correct
               Above the diagram on page 1  (This diagram will now
                                                                                3
               be on page 2 because of the page break.)
              Numbering format changed to A

 1.6      Border around paragraph removed.                                     1

 1.7      1.7.1          Created new style:
                         Name: Arrive Alive 
                         Style type: Linked (Paragraph and character) 
                                                                                5
                         Style and Following style based on: Normal 
                         Font colour dark red and 16 
                         Paragraph spacing set to 3pt After. 

          1.7.2      “SAPS and the Metro Police”: formatted with this
                                                                                1
                     new style

 1.8      1.8.1      Footnote added to “Skidmarks”: 

          1.8.2      Number format changed to Roman Figure i. 
                                                                                3
          1.8.3      Correct text appear in footer. 
                     “Skidmarks are marks left on the roadway from a vehicle
                     that has locked its breaks”

Copyright reserved                                                              Please turn over

### Page 3

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

 1.9      Section break inserted in the correct place (before Main
                                                                       1
          Heading: Background) 
 1.10     Table of Content Added  At the top of first page 
          Heading 1 and 2 style displayed                             3

 1.11     Automatic page numbering 
                                                                       2
          In the centre of the footer 

 1.12     Drop cap added to first sentence in first paragraph 
                                                                       2
          Distance set to 0.5 cm from text 
                                                                     [35]

Copyright reserved                                                         Please turn over

### Page 4

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

 QUESTION 2

 No.      Criteria                                                      Max.            Mark

 2.1      Font ‘Children Safety’ and ‘Cycle Fun Race’ changed to
          WordArt                                                       2
          Style Gradient Fill Gold, Accent 4 

 2.2      Pictures size of both set at exactly
          2.73 cm  by 2.73 cm                                          3

 2.3          WordArt images grouped with pictures
                                                                         2
              Displayed as one object. 

 2.4      2.4.1      Object colour Change Accent Colours 4 to 5.
                                                                         2

          2.4.2      Object style changed to 3-D  ‘Inset’ SmartArt
                                                                         1
                     Style 

          2.4.3      Information/text of the first three finalists
                     changed.                                         3

          2.4.4      Picture Fill applied correctly image Q2_SA flag.
                                                                         2
                     jpg 
                                                                        [15]

Copyright reserved                                                       Please turn over

### Page 5

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

 QUESTION 3

 No.      Criteria                                               Max.             Mark

 3.1          A1: L1 merged 
                                                                  2
              Red fill colour 

 3.2      3.2.1      Row height changed to 34. 
                                                                  1

          3.2.2      Headings in row 3 vertically centred 
                     Wrap text applied                           2

 3.3      Column headings in row 3 Frozen                        1

 3.4      Column H:

                 Conditional Formatting applied                 3
                 Condition: Greater than R65 
                 Format: Green fill 

 3.5      Cell D106:
          =COUNTIF (C4:C104,"L")
                                                                  3

 3.6      Cell D107:
          =COUNTA (D4:D104)                                     2
          OR=COUNTA(B4:B104) OR =COUNT(A4:A104)

 3.7      Cell H106:
          =COUNTBLANK (K4:K104)                                 2

 3.8      Cell H107:
          =SUMIF (C4:C104,"L",H4:H104)
                                                                  4

 3.9      Cell L4:
          =IF (C4="S","40km","75km")
                                                                  4

Copyright reserved                                                    Please turn over

### Page 6

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

    3.10   Cell J6: Format cell as text and insert 0
           Custom format 
           Cell number correctly displayed 

                                                             2

    3.11   Borders inserted 
           In the correct range A3:L104                     2

                                                           [28]

Copyright reserved                                           Please turn over

### Page 7

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

 QUESTION 4

 No.      Criteria                                               Max.            Mark

 4.1      4.1.1      Cell G8:
                     Correct formula *                           2
                     Correct cells: =A8*F8 
                     
          4.1.2      Auto fill/drag down method used 
                                                                  1
                     cells G8:G12 

 4.2      Cell G16:
          =SUM                                                   2
          (G8:G12) 

 4.3      Cell G17:
          =IF (G16>R3000,G16*10%,G16*0)
                                                                  3
                OR
          =IF(G16>3000,G16*0.1,”0”)

 4.4      Cell G19:
          =G18 *0.14                                           3
          OR =G18+14%

 4.5      Cell G20:
          =SUM  (G18,G19)  OR G18 + G19                      2

Copyright reserved                                                    Please turn over

### Page 8

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

    Work in the Graph worksheet.

    4.6       Bar/column (suitable) chart inserted correctly 
              Correct data range used (excluding fruit juice)
              Relevant title 
              Legend removed 
              Y-axis set to end at 100 (maximum value) 
              Axis title displayed 
              Data values correctly displayed 
              Platter names appear in full on X-axis. 
                                                                     8

    4.7   Sheet 1 hidden                                            1
                                                                   [22]

Copyright reserved                                                Please turn over

### Page 9

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

QUESTION 5

No.     Item / Criteria                                                   Max             Mark

5.1     5.1.1        ID field or CellNo field set as primary key          1

        5.1.2        Drop down listwith correct data =
                      Mougins High,
                      Kilmore High,                                       2
                      Appleby High 
                     (Display control and Row Source in the Lookup tab)

        5.1.3        Volunteer code field: Required set as Yes            1

        5.1.4        CellNo veld: Input Mask = 0000000000 
                                                                           2

5.2     Query: Mougins High
        Fields used for query: Name, Surname, CellNo, Volunteer
        code,  and School 
        School field not shown 
        Criteria for School field: Mougins High 
        Criteria for Volunteer Code field: 12                            5
        (5 records)

5.3     Query: K2K Volunteers
        Fields used for query: Name, Surname, School, Volunteer
        Code, CellNo, V_Vita C and V_1st Aid
        V_Vita C and V_1st Aid fields not shown 
        Criteria for Volunteer Code field:K2K_E OR K2K_L OR
        K2K_P
        Criteria for V_Vita C field: Yes or True or On 
        Criteria for V_1st Aid field: Yes or True or On                   6
        (Note: criteria must be repeated if on separate rows – ‘or’
        logic)
        Sorted alphabetically by School (ascending) 

Copyright reserved                                                             Please turn over

### Page 10

Downloaded from hlayiso.com
10                    COMPUTER APPLICATIONS TECHNOLOGY P1                       (NOVEMBER 2014)

5.4     Form: List of Helpers Form
        Title: K2K Volunteers_2014 Calibri  (detail) 12 pt 
        Q5_Helmet image in form header  size 3 cm 
        6 pt solid  Red rectangular  border inserted around 4
        fields
        Four fields moved to the right 

                                                                          9

Report: Volunteer List

5.5     5.5.1        Fields included: Name, Surname, School, Volunteer
                     Code, V_H20, V-1st Aid, V_timekeepers, V_Vita C      1
                     and T_shirt Colour

        5.5.2        Saved as List of volunteers                         1

        5.5.3        Grouped by School  then by Volunteer Code 
                                                                          2

        5.5.4        Sorted by Surname                                   1

        5.5.5        Orientation = Landscape                             1

        5.5.6        Title: Save our Cyclists!                           1

        5.5.7        Headings and details all clearly legible in Print
                     Preview  and school field centre aligned 
                                                                          2

        5.5.8        Statistics in Report Footer:
                     = COUNT  ( * )( OR any field may be used)
                     = COUNT  ( [School Name] )                         5
                     Descriptive labels added for each calculation 

                                                                         [40]

Copyright reserved                                                        Please turn over

### Page 11

Downloaded from hlayiso.com
(NOVEMBER 2014)           COMPUTER APPLICATIONS TECHNOLOGY P1                             11

QUESTION 6

No.     Item / Criteria                                               Max             Mark

6.1     Title: Zero Tolerance
        <title> Zero Tolerance </title>                                2
        Opening and closing tags for title 

6.2     Background colour
        <body bgcolor ="green">                                        1
        bgcolor="green" attribute added to <body> tag 

6.3     Heading: Burry Stander Foundation
        <h1> <font color="yellow" align="center">
        The Burry Stander Foundation</font ></h1>
        Text appears between<h1> … </h1> tags 
                                                                       4
        <font> … </font> tags added 
        With the following attributes applied to the text font:
        Align=centre 
        colour = “yellow” 

6.4     <body bgcolor = “green”>< font colour =”white”>               1

6.5     Q6_SA mug.gif
                                                                       1
        Image name changed to “Q6_SA mug.jpg” 

6.6     Italics
                                                                       1
        Italics tag closed after ‘lost’: <i> lost </i> 

6.7     Numbered list under the Heading: We stand for…
        <ul> . . . </ul> changed to <ol> . . . </ol> 
        <li> added to Pedestrians                                     3
        <li> added to Cycling commuters
        <li> added to Motorbikes </li>
        2 marks for opening and closing the list tags <li> ……</li>(

6.8     6.8.1        Immediate Goals
                                                                       1
                     Bold removed <b>………</b>

        6.8.2        u>………</u> added to the text                      1

Copyright reserved                                                          Please turn over

### Page 12

Downloaded from hlayiso.com
12                   COMPUTER APPLICATIONS TECHNOLOGY P1              (NOVEMBER 2014)

6.9     6.9.1    How can you help
                 <p> How can you help </p>
                 changed to                                    1
                  <p align="centre"> How can you help </p>
                 Align = “Centre” added as indicated 

        6.9.2    Horizontal lines
                 Above and below the text “How can you …” 
                 <hr colour="red" />                           2
                 colour= “red” 
                 (-1 if either of the two lines is missing)

6.10    Font face attribute
        face=”jokerman”                                       2
         added to Petition
                                                              [20]

Copyright reserved                                                 Please turn over

### Page 13

Downloaded from hlayiso.com
(NOVEMBER 2014)           COMPUTER APPLICATIONS TECHNOLOGY P1                               13

 QUESTION 7

 No.      Criteria                                                      Max.              Mark

 7.1      Sheet 2 removed                                                1

 7.2      7.2.1      Copy  and saved Q7-Fatalities  Data on
                                                                          3
                     Fatalities is linked / updatable 

 7.3      Caption “Figure1”                                              1

 7.4      PowerPoint file Q7_Slide_ display correct as icon and
                                                                          2
          linked to original file location 

 7.5      7.5.1      Imported: Q7_Manager_Details to a new table         1

          7.5.2      Date of Birth column excluded                        1

          7.5.3      NO primary key                                      1

          7.5.4      Renamed Q7_Manager_Details                          1

 7.6      7.6.1      File converted to Rich Text Format (Q7_Hard
                                                                          2
                     facts.rtf). 

          7.6.2      Author property changed to Name and Surname in
                                                                          1
                     the download.jpg file 

          7.6.3      Q7_Hard facts .rtf set to Read-only attribute       1

 7.7      63 files                                                       1

 7.8      7.8.1      Order changed, from left to right; to Size, Name
                                                                          1
                     and Type. 

          7.8.2      Screenshot pasted in the Q7 Answer file             1

 7.9      My bike.docx  protected with a Password: NOV_14               1
                                                                        [20]

                                                                               TOTAL:       180

Copyright reserved                                                            Please turn over

### Page 14

(NOVEMBER 2014)           REKENAARSTOEPASSINGSTEGNOLOGIE V1                             13
 VRAAG 7
 Nr.      Kriteria                                                     Maks          Punt
 7.1      Sheet 2 verwyder                                             1
 7.2      7.2.1      Grafiek gekopieer  en gestoor Q7-Fatilities      2
                     Data kan outomaties opdateer                      1
 7.3      Byskrif “Figure1”                                            1
 7.4      PowerPoint lêer Q7_Slide_ vertoon korrek as “icon” 
                                                                        2
          gekoppel aan die oorspronklike posisie van die lêer. 
 7.5      7.5.1      Q7_Manager_Details by databasistabel ingevoeg     1
          7.5.2      Date of Birth kolom nie bygevoeg                  1
          7.5.3      Geen primêre sleutel                              1
          7.5.4      Herbenoem Q7_Manager_Details                      1
 7.6      7.6.1      Lêer (Q7_Hard facts) verander na Rich Text
                                                                        2
                     Formaat  
          7.6.2      Author eienskap verander na eie naam en van in
                                                                        1
                     die download.jpg lêer. 
          7.6.3      Read-only eienskap verwyder Q7_Hard facts.rtf     1
 7.7      63 lêers                                                     1
 7.8      7.8.1      Orde verander van links na regs; na Size, Name
                                                                        1
                     en Type. 
          7.8.2      Screenshot in Q7 Answer lêer geplak.              1
 7.9      My bike.docx wagwoord NOV_14 gebruik.                         1
                                                                       [20]
                                                                        TOTAAL:         180
Kopiereg voorbehou                                                       Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 15

12                   REKENAARTOEPASSINGSTEGNOLOGIE V1                     (NOVEMBER 2014)
6.9     6.9.1   How can you help
                <p> How can you help </p>
                verander na <p align="center"> How can you help    1
                </p>
                Align = “Centre” bygevoeg soos aangetoon 
        6.9.2   2 x Horizontal lines
                Bo en die onder die teks “How can you …” 
                <hr color="red" />
                                                                   2
                <hr/> 
                color= “RED” 
                (-1 as enige van die twee lyne kort)
6.10    Font face attribute:
        face=”jokerman”                                           2
         Bygevoeg by Petition
                                                                  [20]
Kopiereg voorbehou                                                     Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 16

(NOVEMBER 2014)            REKENAARSTOEPASSINGSTEGNOLOGIE V1                              11
VRAAG 6
Nr.     Item / Kriteria                                              Maks.           Punt
6.1     Title: Zero Tolerance
        <title> Zero Tolerance </title>                                2
        Begin en eind tags soos aangedui, bygevoeg 
6.2     Background colour
        <body bgcolor="green">                                         1
        bgcolor="green" attribuut by die <body> tag gevoeg
6.3     Heading: Burry Stander Foundation
        <font color="yellow" align="center">
        <h1> The Burry Stander Foundation</font color="yellow"
        align="center"></h1>
        Teks verskyn tussen<H1> … </h1> tags                          4
        <font> … </font> tags bygevoeg 
        Die volgende attribute bygevoeg:
        Align=center
        color = “yellow” 
6.4     Color attribute bygevoeg by die font tag van nuwe
        paragraaf                                                      1
        <p>font color=”white”> 
6.5     Q6_SA mug.gif
                                                                       1
        Image naam verander na “Q6_SA mug.jpg” 
6.6     Skuinsdruk probleem
                                                                       1
        Italics tag gesluit na ‘lost’:       <i> lost </i> 
6.7     Genommerde lys na die opskrif: We stand for…
        <ol> . . . </ol> verander na <ul> . . . </ul> 
        <li> bygevoeg by Pedestrians
        <li> bygevoeg by Cycling commuters                            3
        <li> bygevoeg by Motorbikes
        2 punte vir die oop- en toemaakmaak van die list tags <li>
        ……</li>(
6.8     6.8.1        Immediate Goals
                                                                       1
                     Vetdruk (‘Bold’) verwyder <b>………</b>
        6.8.2        u>………</u> by die teks bygevoeg.t                 1
Kopiereg voorbehou                                                         Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 17

10                    REKENAARTOEPASSINGSTEGNOLOGIE V1                           (NOVEMBER 2014)
5.4     Form: List of Helpers Form
        Title: K2K Volunteers_2014 Calibri  (detail) 12 pt 
        Q5_Helmet image in form header  size 3 cm 
        6 pt solid  Red rectangular  border inserted around 4
        fields
        Four fields moved to the right 
                                                                           9
Verslag: Volunteer List
5.5     5.5.1        Velde ingesluit: Name, Surname, School, Volunteer
                     Code, V_H20, V-1st Aid, V_timekeepers, V_Vita C       1
                     and T_shirt Colour 
        5.5.2        Stoor as List of volunteers                          1
        5.5.3        Gegroepeer volgens School  en daarna Volunteer
                                                                           2
                     Code
        5.5.4        Gesorteer volgens Surname                            1
        5.5.5        Oriëntasie Landscape                                 1
        5.5.6        Titel: Save our Cyclists!                            1
        5.5.7        Opskrifte en besonderhede duidelik leesbaar (Print
                     Preview) 
                                                                           2
                     Skool se detail gesentreer 
        5.5.8        Statistics in Report Footer:
                     = COUNT  ( * )(OF enige veld kan gebruik word)
                     = COUNT  ( [School Name] )                          5
                     Geskikte beskrywing (etiket) by elke berekening 
                                                                          [40]
Kopiereg voorbehou                                                         Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 18

(NOVEMBER 2014)             REKENAARSTOEPASSINGSTEGNOLOGIE V1                                  9
VRAAG 5
Nr.     Item / Kriteria                                                   Maks             Punt
5.1     5.1.1        ID veld of SelNo veld as primêre sleutel gestel.     1
        5.1.2        Combo box bestaan uit
                           Mougins High
                           Kilmore High                                   2
                         Appleby High 
                     (Kontroleer Display control en Row Source in die
                     Lookup tab)
        5.1.3        Volunteer code-veld: Required gestel as Yes          1
        5.1.4        CellNo veld:     Input Mask = 0000000000 
                                                                           2
5.2     Navraag: Mougins High
        Velde in navraag gebruik: Name, Surname, CellNo, School
        en Graad12 
        ‘Show’ afgehaal by School veld 
        Kriteria vir School veld:   Mougins High 
        Kriteria vir Volunteer Code vield: 12                            5
        (5 records)
5.3     Navraag: K2K Volunteers
        Velde in navraag gebruik: Name, Surname, School, Volunteer
        Code, CellNo, V_Vita C and V_1st Aid
        ‘Show’ afgehaal by V_Vita C en V_1st Aid fields 
        Kriteria vir Volunteer Code vield:K2K_E OR K2K_L OR
        K2K_P 
        Kriteria vir V_Vita C vield: Yes or True or On 
        Kriteria vir V_1st Aid vield: Yes or True or On 
                                                                           6
        (Nota: kriteria moet herhaal word indien op aparte rye – ‘or’
        logic)
        Sorteer alfabeties (ascending) volgens school 
Kopiereg voorbehou                                                             Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 19

8                    REKENAARTOEPASSINGSTEGNOLOGIE V1                     (NOVEMBER 2014)
 Grafiek werksblad
 4.6         Gepaste grafiek (bar, column) korrek ingevoeg
             Korrekte data reeks gebruik:  vrugtesap nie ingesluit
              nie!
             Beskrywende titel 
             Legend verwyder 
             Y-as gestel 100 (maksimum waarde). 
             Titel van as korrek 
             Vertoon data waardes korrek 
             Name van platters volledig op x-as.                        8
 4.7     Sheet 1 weggesteek (hide)                                       1
                                                                        [22]
Kopiereg voorbehou                                                     Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 20

(NOVEMBER 2014)            REKENAARSTOEPASSINGSTEGNOLOGIE V1                         7
 VRAAG 4
 Nr.      Kriteria                                             Maks.            Punt
 4.1      4.1.1      Sel G8:
                     Korrekte formule                           2
                     =A8*F8 
          4.1.2      Gebruik Auto fill/Drag down metode 
                                                                 1
                     Selle G8:G12
 4.2      Sel G16:
          =SUM                                                  2
          (G8:G12) 
 4.3      Sel G17:
          =IF (G16>R3000,G16*10%,G16*0)
                                                                 3
                OF
          =IF(G16>3000,G16*0.1,”0”)
 4.4      Sel G19:
          =G18*0.14                                           3
          OF =G18+14%
 4.5      Sel G20:
          =SUM (G18,G19)  OF G18 + G19                      2
Kopiereg voorbehou                                                   Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 21

6                    REKENAARTOEPASSINGSTEGNOLOGIE V1          (NOVEMBER 2014)
 3.10    Sel J6: formateer sel na teks en voeg 0 in
         Custom Format 
         Cell no. vertoon korrek 
                                                         2
 3.11    Raam bygevoeg 
         Korrekte reeks A3:L104                         2
                                                        [28]
Kopiereg voorbehou                                       Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 22

(NOVEMBER 2014)             REKENAARSTOEPASSINGSTEGNOLOGIE V1                         5
 VRAAG 3
 Nr.      Kriteria                                              Maks.             Punt
 3.1      A1:L1 saamgevoeg 
                                                                  2
          Rooi vulkleur 
 3.2      3.2.1      Ry hoogte verander na 34. 
                                                                  1
          3.2.2      Kolomme vertikaal gesentreer in ry 3. 
                     Teks omvou                                  2
 3.3      Kolom opskrifte in ry 3 gevries                        1
 3.4      Kolom H:
                 Voorwaardelike formatering korrek              3
                 Kondisie: Meer as R65 
                 Formatering: Groen vul 
 3.5      Sel D106:
          =COUNTIF (C4:C104,"L") 
                                                                  3
 3.6      Sel D107:
          =COUNTA (D4:D104)                                     2
          OR=COUNTA(B4:B104) OR =COUNT(A4:A104)
 3.7      Sel H106:
          =COUNTBLANK  (K4:K104)                                2
 3.8      Sel H107:
          =SUMIF (C4:C104,"L",H4:H104)
                                                                  4
 3.9      Sel L4:
          =IF (C4="S","40km","75km") 
                                                                  4
Kopiereg voorbehou                                                    Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 23

4                     REKENAARTOEPASSINGSTEGNOLOGIE V1                           (NOVEMBER 2014)
 VRAAG 2
 Nr.     Kriteria                                                        Maks.            Punt
 2.1     Font tipe verander ‘Children Safety’ and ‘Cycle Fun Race’
         na WordArt                                                       2
         Gradient Fill, Gold, and Accent 4. 
 2.2     Prentgrootte van beide presies 
         2.73 cm  by 2.73 cm                                             3
 2.3         WordArt en prente gegroepeer 
                                                                           2
             As een voorwerp. 
 2.4     2.4.1       Kleur verander Change Accent Colors 4 to 5.
                                                                           2
         2.4.2       voorwerp styl verander na ‘Inset’ SmartArt Style     1
         2.4.3       Eerste drie finaliste se informasie verander. 
                                                                           3
         2.4.4       Picture Fill toegepas met korrekte prent Q2_SA
                                                                           2
                     flag.jpg 
                                                                          [15]
Kopiereg voorbehou                                                          Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 24

(NOVEMBER 2014)         REKENAARSTOEPASSINGSTEGNOLOGIE V1                                  3
 1.9      Section break (new page) korrek ingevoeg voor hoofopskrif
                                                                       1
          (Background) 
 1.10     Table of Content bygevoeg  boaan eerste bladsy 
          Heading1 en Heading2 styl vertoon                           3
 1.11     Gesentreerde outomatiese  bladsynommering in voetnota
                                                                       2
          (footer).
 1.12     ‘Drop cap’ by eerste sin van eerste paragraaf bygevoeg. 
                                                                       2
          Afstand/spasie 0.5 cm van teks. 
                                                                      [35]
Kopiereg voorbehou                                                         Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 25

2                     REKENAARTOEPASSINGSTEGNOLOGIE V1                            (NOVEMBER 2014)
 VRAAG 1
 Nr.     Kriteria                                                         Maks.            Punt
 1.1     Regs inlyn,  verander na Italics, 
         Traffic Accident Investigation in South Africa, disturbing         2
         facts.
 1.2     Heading 1 kleur verander na rooi 
         Hoof opskrif (Background) geformateer met aangepaste
                                                                            3
         Heading1 styl 
         Alle sub-opskrifte met Heading2 styl 
 1.3     Verwysing vir report: Korrekte posisie 
             Author: Volminck,S,D,Nathan 
             Title: News Updater 
             Year: 2013                                                   7
             City: Pretoria 
             Publisher: Daily News 
 1.4     3pt bladsyraam 
                                                                            2
 1.5     Byskrif bygevoeg 
         “Vehicle types” bo-aan diagram.  (Hierdie diagram sal
                                                                            3
         nou op bladsy 2 a.g.v.die bladsybreuk wees.)
         Nommer formaat verander na A 
 1.6     Raam rondom die paragraaf verwyder.                               1
 1.7     1.7.1          Nuwe styl geskep:
                        Name: Arrive Alive 
                        Style type: Linked (Paragraph and Character) 
                                                                            5
                        Style en Following style based on: Normal 
                        Fontkleur donkerrooi en 16
                        Paragraafspasiëring gestel 3pt After. 
         1.7.2           Formateer “SAPS and Metro Police”:  met
                                                                            1
                         nuwe styl
 1.8     1.8.1       Voetnota bygevoeg: ‘“Skidmarks”’ 
         1.8.2       Nommer formateer na Roman Figure i.
                                                                            3
         1.8.3       Korrekte teks in voetnota (‘footer’).
                     ““Skidmarks are marks left on the roadway from a
                     vehicle that has locked its breaks”
Kopiereg voorbehou                                                          Blaai om asseblief
                     Downloaded from hlayiso.com

### Page 26

NASIONALE
                      SENIOR SERTIFIKAAT
                              GRAAD 11
                        NOVEMBER 2014
    REKENAARTOEPASSINGSTEGNOLOGIE V1
              MEMORANDUM
NAAM VAN KANDIDAAT:                                             GRAAD:
HANDTEKENING VAN
ONDERWYSER:
          TOTAAL         V1       V2      V3      V4       V5       V6   V7
PUNTE:      180          35       15      28       22      40       20   20
                   Hierdie memorandum bestaan uit 13 bladsye.
             Downloaded from hlayiso.com

## Related documents

- [CAT P1 QP](https://www.hlayiso.com/library/cat-p1-qp/4e8cf26e-8192-4700-bc7d-56a57a61a5c7) — Computer Applications Technology · QP · 2014
- [CAT P2 Memo](https://www.hlayiso.com/library/cat-p2-memo/2582ceb9-a54c-4a5e-ac40-51579657f02c) — Computer Applications Technology · Memo · 2014
- [CAT P1 MEMO GR11 NOV 2020 AFR D](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2020-afr-d/5b4dbc89-ee3d-4dae-b544-5840b8d39592) — Computer Applications Technology · Memo · 2020 · Afr
- [CAT P1 MEMO GR11 NOV 2020 ENG D](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2020-eng-d/d12def4a-982f-4449-b293-32fa4e40a517) — Computer Applications Technology · Memo · 2020 · Eng
- [CAT P1 MEMO GR11 NOV 2019 Eng D](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2019-eng-d/406f61c6-6558-402a-9648-12d1aff30bda) — Computer Applications Technology · Memo · 2019 · Eng
- [CAT P1 MEMO NOV 2019 Afr D](https://www.hlayiso.com/library/cat-p1-memo-nov-2019-afr-d/236e1556-0895-4c96-a2cf-7a1c4bb1df01) — Computer Applications Technology · Memo · 2019 · Afr

## More from Grade 11 Computer Applications Technology

- [CAT Grade 11 Teacher's Guide v2](https://www.hlayiso.com/library/cat-grade-11-teacher-s-guide-v2/60db7f6c-ce96-4df2-a9d1-f5b6025c8386) — Guide
- [Gr11 CAT Practical LB print 20-9-19](https://www.hlayiso.com/library/gr11-cat-practical-lb-print-20-9-19/07dcc91e-6e6d-4426-af23-33bd059dee2f) — Textbook
- [Gr11 CAT Practical LB web 20-9-19](https://www.hlayiso.com/library/gr11-cat-practical-lb-web-20-9-19/53763877-ca8b-4e6f-a0b4-5472a940eac2) — Textbook
- [Gr11-CAT-TG-Study-Guide LR](https://www.hlayiso.com/library/gr11-cat-tg-study-guide-lr/fc7c0458-b409-4945-b66a-1e47960bd705) — Guide
- [Gr11 CAT Theory LB print 19-11-19](https://www.hlayiso.com/library/gr11-cat-theory-lb-print-19-11-19/9605fb7a-c0fc-44fb-bf73-5bc54e1e618e) — Textbook
- [Grade 11 CAT P1 November 2026 Mock](https://www.hlayiso.com/library/grade-11-computer-applications-technology-2026-november-mock-exam-question-paper-paper-1/4876f0e2-e346-4e36-8971-81494db33178) — QP · 2026 · Eng

## Collection

- [Grade 11 past papers](https://www.hlayiso.com/grade-11/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.
