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

> Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC November Exam 2014 (English), 16 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/cat-p1-nov-2014-memo-eng/b86e3e92-d8e8-45bf-b778-e2e28b3fd24c
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2014
- Exam period: NSC November Exam
- Paper: 1
- Curriculum: CAPS
- Pages: 16

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-nov-2014-memo-eng/b86e3e92-d8e8-45bf-b778-e2e28b3fd24c)

## About this document

Computer Applications Technology · Grade 12 · NSC November Exam · 2014. Memorandum, 16 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

                 COMPUTER APPLICATIONS TECHNOLOGY P1

                                NOVEMBER 2014

                      MEMORANDUM/MARKING GUIDELINE

MARKS: 180

CENTRE                                               FINAL MARK
NUMBER

EXAMINATION
NUMBER

QUESTION                1      2      3       4      5       6      7         TOTAL

POSSIBLE MARK          30     20      31     19      40      20     20           180

CANDIDATE
MARK

MARKER CODE/
SIGNATURE

MODERATED
MARK

              This memorandum/marking guideline consists of 16 pages.

Copyright reserved                                                      Please turn over

### Page 2

Downloaded from hlayiso.com
Computer Applications Technology/P1           2                                   DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

IGNORE SPELLING IN ALL CASES.
QUESTION 1                         File name: 1Africa_Afrika                                    Total Q1: 30
                                                                                  Maximum          Candidate
 No                                   Criteria
                                                                                    Mark             Mark
1.1     Margins                                                                             1
        • Left margin set to 2 cm                                            1
1.2.1   Cover Page/Title Page                                                               1
        • Cover page/title page added to beginning of document               1
        (Note to marker: Accept a blank cover/title page.)
1.2.2   Cover Page/Title Page                                                               1
        • Correct text added as title Beautiful Africa                       1
        (Notes to marker:
        • Accept title in any position.
        • Do not penalise if other controls appear on the page.)
1.3     WordArt/Fontwork                                                                    1
        • WordArt (MSO)/Fontwork (LO) applied to 'Table of Contents'         1
1.4     Table                                                                               6
        • Cells of row 1 merged                                              1
        • Contents 'Summary of Facts' added in row 1, right aligned          1
        • Degree symbol added just before 'S' and 'E'                        1
        • Table centred horizontally on page                                 1
        • All inner gridlines changed  to 1½ pt                             2
        (Notes to marker:
        • Text must appear and right aligned to award the mark.
        • Accept symbol or superscript, but not the hard space.
        • Accept if only one symbol or superscript is added.
        • Accept if only some inner gridlines are changed to 1 ½ pt.)
1.5     Bullets                                                                             2
        • Wingdings character number 39 () (MSO)/Wingdings character
           number U+F027 (LO) applied                                        1
        • Bullet position aligned at 3 cm from the left margin               1
        (Notes to marker:
        • Ignore if the text is not indented.
        • Accept if the indenting appears on the ruler.)
1.6     Page numbers                                                                        6
        • Automatic page numbering inserted in the footer                    1
        • Section break is inserted before the page containing '1. Victoria
           Falls, Zambia'                                                    1
        • Previous pages (cover page, TOC page) not numbered                 1
        • Numbering starts as page 1 after the Table of Contents page        1
        • Even page numbers aligned on the right 
                                                                              1
        • Odd page numbers aligned on the left 
                                                                              1
        (Notes to marker:
        • Alignment must be used as opposed to being 'placed' on the
           left or right. Accept if odd and even was swopped.
        • If cover page was not added, accept 'Different first page'.
        • Do not award the third mark if no page numbers were added.
        • Award one mark if 'Different odd and even' was checked'.)
Copyright reserved                                                                   Please turn over

### Page 3

Downloaded from hlayiso.com
Computer Applications Technology/P1           3                                 DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

1.7     Bookmark                                                                         2
        • Hyperlink created                                                1
        • Link to the 'Precautions' bookmark                               1

        (Note to marker: Accept the hyperlink on any one of the two
        ‘Trekking Precautions’ text.)
1.8     Widow/Orphan control                                                             1
        • Widow/Orphan control applied to paragraph                        1
1.9     Bookmark                                                                         1
        • 'Summit' bookmark deleted                                        1

1.10    Headings and Table of Contents                                                   2
        • 'FormatHeading' or Heading 1 style applied to the heading
           '5. Mount Kenya, Kenya'                                         1
        • Table of Contents has been updated                               1

        (Notes to marker:
        • Heading must appear in the Table of Contents for the second
           mark.
        • Note also that the page numbers will have changed. )
1.11    Integration                                                                      2
        • Spreadsheet '1Visitors_Besoekers'                                1
        • Displayed as an icon (MSO)/button (LO)                           1

        (Notes to marker:
        • Award the mark for the icon/button even if it appears in a
           different location.
        • Do not accept an AutoShape.)
1.12    Caption                                                                          2
        • Caption field inserted                                           1
        • Caption position: above the image                                1

        (Note to marker: Award the second mark only if a caption has been
        used.)
1.13    Table of Figures/Illustration index                                              1
        • Automatic Table of Figures (MSO)/Illustration Index (LO) has
           been inserted                                                   1
1.14    Watermark                                                                        1
        • Watermark text: ‘Ace Travel’’ added on any page                  1

        Total for QUESTION 1                                                            [30]

Copyright reserved                                                                 Please turn over

### Page 4

Downloaded from hlayiso.com
Computer Applications Technology/P1           4                              DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

QUESTION 2              File names: 2Questionnaire_Vraelys, 2Temp                        Total Q2: 20
                                                                           Maximum        Candidate
 No                                 Criteria
                                                                             Mark           Mark
2.1     Comment                                                                      1
        • Comment deleted                                             1
2.2     Character spacing                                                            2
        • Character spacing of heading 'Ace Travel' expanded by 4
           pt                                                         1
        • Scale for character spacing of heading 'Ace Travel' set to
           120%                                                       1

2.3     Track changes                                                                2
        • Track change of Author accepted                             1
           ('r' inserted in Tour)
        • Text change of Assistant rejected                           1
           ('/s' rejected in Full Name/s)
2.4     Text form field: Date of Birth                                               3
        • Text form field set to Date format                          1
        • Date format set to yyyy-MM-dd or YYYY-MM-DD                 1
        • Help message displayed 'yyyy-MM-dd' or 'YYYY-MM-DD'
           on status bar                                              1

         (Notes to marker:
         • Accept either yyyy-MM-dd or YYYY-MM-DD.
         • Do not accept yyyy/MM/dd or yyyy MM dd.
         • Accept any help message.)
2.5     Combo box                                                                    2
        • Any combo box inserted                                      1
        • Items inserted: Vegetarian, White meat, Red meat            1

        (Notes to marker:
        • Accept if only one option is inserted.
        • Ignore any default text.
        • Accept a drop-down form field.)
2.6     Check box and Tabs                                                           5
        • Left or right tab set at 8 cm  dotted leader tab           2
        • Tabs applied correctly to at least one option               1
        • Check box form field inserted next to 'Victoria Falls,
           Zambia'                                                    1
        • Default value of first check box set to checked             1

2.7      Image                                                                       4
         • Wrapping set to any format except in line with text        1
         • Image resized to height and width at 4 cm                  1
         • Image moved not copied                                     1
         • All four images grouped as 1 image                         1
2.8     Template                                                                     1
        • Document saved as template .dotx/.ott/.dot etc.             1
        Total for QUESTION 2                                                      [20]

Copyright reserved                                                              Please turn over

### Page 5

Downloaded from hlayiso.com
Computer Applications Technology/P1           5                             DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                            EXAMINATION
                            NUMBER

QUESTION 3              File names: 3Clients_Kliënte, 3Draw_Trekking                    Total Q3: 31
•     Mark the questions from the formulae and not the values/answers in the cell.
•     Check against candidate's actual work (Cell references may differ, depending on the
      candidate's response).
•     Candidate may use multiple formulae or cells as 'building blocks' to reach answers.
•     Named ranges can be used instead of cell references.

                                                                          Maximum        Candidate
    No                             Criteria
                                                                            Mark           Mark

Clients_Kliënte worksheet

3.1.1     Row 1:                                                                    1
            • Text in row 1 text is centred                          1
3.1.2     Cell A3:                                                                  1
             • Contents of cell A3 wrapped                           1
3.2       Cell B5:                                                                  4
          = YEAR(TODAY()) – YEAR(A5)
              • YEAR  (TODAY())                                     2
              • -YEAR(A5)                                            1
              • Format set to General or Number                      1

          OR
          B5:= ROUNDDOWN((TODAY()-A5)/365,0)
             • ROUNDDOWN( ,0) 
             • TODAY() -A5) 
             • /365 or 365.25 
             • Format set to General or Number 
          OR
          B5:= ROUNDDOWN((NOW()-A5)/365,0)
             • ROUNDDOWN( ,0) 
             • NOW() -A5) 
             • /365 or 365.25
             • Format set to General or Number 
          (Notes to marker:
          • Accept TRUNC and INT instead of ROUNDDOWN.
          • Accept =ROUNDDOWN(YEARFRAC(TODAY(),A5,3),0).)
3.3       Cell C4:                                                                  4
          =CONCATENATE(LEFT(E4,2),LEN(D4))
             • CONCATENATE function                                  1
             • LEFT  (E4, 2)                                        2
             • LEN(D4)                                               1
          OR
          =LEFT(E4,2)&LEN(D4)
             • LEFT  (E4,2)  & LEN(D4) 
          OR
          =MID(E4,1,2)&LEN(D4)
             • MID  (E4,1,2)  &  LEN(D4) 

Copyright reserved                                                             Please turn over

### Page 6

Downloaded from hlayiso.com
Computer Applications Technology/P1           6                           DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                          EXAMINATION
                          NUMBER

3.4     Conditional formatting in Column I:                                     3
        • Conditional formatting has been applied to
           column I                                                  1
        • 2-colour scale applied                                     1
        • Minimum and maximum value colours have been changed
                                                                     1

        (Notes to marker:
        • Default setting in MSO is orange and yellow.
        • Default setting in LO is red and blue.
        • No marks awarded if conditional formatting has not been
           applied.)
3.5     Cell J20:                                                               4
        =IF(B20>60,"Pensioner",IF(B20>=12,"Adult","Child"))

        OR
        =IF(B20>=61,"Pensioner",IF(B20>11,"Adult","Child"))

        OR
        =IF(B20>60,"Pensioner",IF(AND(B20>=12,B20<=60),
        "Adult","Child"))

        OR
        =IF(B20>=61,"Pensioner",IF(AND(B20>11,B20<61),
        "Adult","Child"))

        OR
        =IF(B20<12,"Child",IF(B20<=60,"Adult","Pensioner"))

        OR
        =IF(B20<=11,"Child",IF(B20<=60,"Adult","Pensioner"))

        OR
        =IF(B20>60,"Pensioner",IF(B20<12,"Child","Adult"))

        •   Nested IF-syntax is correctly used                       1
        •   Condition <=11 OR <12 and value "Child"                  1
        •   Condition >=12 and <=60 OR >11 AND <=60 and value
            "Adult"                                                  1
        •   Condition >60 OR >=61 and value "Pensioner"              1

        (Note to marker: There are many alternative answers, one of
        which could be a VLOOKUP. Evaluate the candidates answer
        against the bulleted options.)
3.6     Cell M8:                                                                2
        =SUM(G4:G53)
        • SUM function                                               1
        • Range: G4:G53                                              1

Copyright reserved                                                           Please turn over

### Page 7

Downloaded from hlayiso.com
Computer Applications Technology/P1           7                               DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

3.7     Cell M9:                                                                    3
        =COUNTIF(H4:H53,"False")
        • COUNTIF function                                               1
        • Range: (H4:H53)                                                1
        • Criteria: "False"                                              1

        OR
        =COUNTIF(H4:H53,"<>True") OR
        =COUNTIF(H4:H55,"<True")
        • COUNTIF function 
        • Range : (H4:H53) 
        • Criteria: "<>True" 

        (Note to marker: Accept True or False with or without quotation
        marks.)
Travellers_Reisigers worksheet
3.8     Graph                                                                       6
        • Pie chart/graph inserted                                       1
        • Correct data series selected: =Clients!L11:M13                 1
        • Chart title inserted besides the default                       1
        • Correct percentages displayed for each category                1
        • Category (Adults/Volwassenes) with the highest
           percentage filled with 3Airplane_Vliegtuig image              1
        • The chart appears in the sheet named
           'Travellers_Reisigers'                                        1

        (Note to marker: Also accept if the chart/graph has been
        copied to sheet named 'Travellers_Reisigers'.)
Draw_Trekking worksheet
3.9     Cell G1:                                                                    3
        • Data from text file 3Draw_Trekking combined with the
           worksheet Draw_Trekking                                       1
        • Only Male clients extracted                                    1
        • Clients that have >= 200 extracted                             1

        (Notes to marker:
        • 19 records expected if both criteria are met – award all
           three marks.
        • If 26 records only male extracted – award the first two
           marks.
        • If 40 records only >=200 extracted – award the first and
           last marks.
        • Candidates may first sort by gender and delete all female
           records and then sort by lucky draw points and delete all
           records less than 200.
        • OR Candidates may sort according to two rules, first
           gender and then points.
        • OR Candidates may use filter to obtain the answer.
        • Accept any suitable method to obtain the answer.)
        Total for QUESTION 3                                                       [31]

Copyright reserved                                                               Please turn over

### Page 8

Downloaded from hlayiso.com
Computer Applications Technology/P1           8                             DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                             EXAMINATION
                             NUMBER

QUESTION 4                        File name: 4Book_Bespreek                             Total Q4: 19

•     Mark the questions from the formulae and not the values/answers in the cell.
•     Check against candidate's actual work (Cell references may differ, depending on the
      candidate's response).
•     Candidate may use multiple formulae or cells as 'building blocks' to answers.
•     Named ranges can be used instead of cell references.

                                                                          Maximum         Candidate
    No                               Criteria
                                                                            Mark            Mark

Bookings_Besprekings worksheet

4.1       Cell F4:                                                                  2
          • =E4 - D4                                                2

          OR
          =E4 - D4 +1
             • E4 
             • - D4 + 1 

          OR
          =DAYS360(D4,E4)
4.2       Cell G5:                                                                  2
          • =F5  * L5  OR =PRODUCT(F5,L5)                           2

4.3       Cell H6:                                                                  4
          =VLOOKUP(J6,'Levy_Heffing'!$A$2:$C$28,M6+1)

          •   LOOKUP Value: J6 
          •   Table array: 'Levy_Heffing'!$A$2:$C$28  OR             1
              Table array: 'Levy_Heffing'!$A$1:$C$28)                 1
          •   Absolute cell reference                                1
          •   Column index number: M6 +1                             1

          OR
          =IF(M6=1,(VLOOKUP(J6,Levy_Heffing!$A$2:$C$28,2)),
          (VLOOKUP(J6,Levy_Heffing!$A$2:$C$28,3)))

          •   IF (M6=1 ,
          •   (VLOOKUP(J6 ,Levy_Heffing!$A$2:$C$28,2)),
          •   (VLOOKUP(J6,Levy_Heffing!$A$2:$C$28,3) ))
          •   Absolute cell reference 

          OR
          =VLOOKUP(J6,Levy_heffing!$A$2:$C$28,IF(M6=1,2,3))

          (Note to marker: Absolute cell referencing must be used.)

Copyright reserved                                                             Please turn over

### Page 9

Downloaded from hlayiso.com
Computer Applications Technology/P1           9                              DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

4.4     Cell I10: =IF(LEFT(A10,1)="X",TRUE,FALSE)                                  5
        • IF function 
                                                                         1
        • LEFT function 
                                                                         1
        • Correct range and parameters (A10,1)="X" 
                                                                         1
        • TRUE displayed if international hotel/lodge                   1
        • FALSE displayed if domestic hotel/lodge                       1
        OR
        =IF(MID(A10,1,1)="X",TRUE,FALSE)
        • IF function 
        • MID function 
        • Correct range and parameters (A10,1,1)="X" 
        • TRUE displayed if international hotel/lodge 
        • FALSE displayed if domestic hotel/lodge 
        OR
        =IF(MID(A10,1,1)="D",FALSE,TRUE)
        • IF function 
        • MID function 
        • Correct range and parameters (A10,1,1)="D" 
        • TRUE displayed if international hotel/lodge 
        • FALSE displayed if domestic hotel/lodge 
        OR
         =IF(LEFT(A10,1)="D",FALSE,TRUE)
        • IF function 
        • LEFT function 
        • Correct range and parameters (A10,1)="D" 
        • TRUE displayed if international hotel/lodge 
        • FALSE displayed if domestic hotel/lodge 
        OR
        =IF(A10>"X","TRUE","FALSE")
        OR
        =IF(A10="X*","TRUE","FALSE")
        (Notes to marker:
        • Accept if column K was used i.e. K10="South Africa".
        • Accept any other suitable method to obtain the answer.
        • Accept True or False with or without quotation marks
        • Accept any nested if function that yields the correct result
           when copied down.)
4.5     Cell O7: =SMALL(L4:L54,3)                                                  2
        • SMALL function                                                1
        • Correct range and parameters (L4:L54,3)                       1
4.6     Cell O10: =SUMIF(K4:K54,"Kenya",F4:F54)                                    4
        • SUMIF function                                                1
        • Criteria range: (K4:K54)                                      1
        • Criteria: Kenya                                               1
        • Sum range: (F4:F54)                                           1
        OR
        =SUMIFS(F4:F54,K4:K54,"Kenya")
        Total for QUESTION 4                                                      [19]

Copyright reserved                                                              Please turn over

### Page 10

Downloaded from hlayiso.com
Computer Applications Technology/P1           10                          DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

QUESTION 5                                File name: 5Ace                             Total Q5: 40

                                                                        Maximum        Candidate
 No                                 Criteria
                                                                          Mark           Mark
Table: Clients_Kliënte
5.1.1   Field: Name_Naam                                                          1
        • Field size 40                                            1
5.1.2   Field: ID_ID                                                              1
        • Set as primary key                                       1

        (Note to marker: Accept CellNumber_Selnommer field.)
5.1.3   Field: International_Internasionaal                                       3
        • Data type changed to Yes/No                              1

        Field: Notes_Notas
        • Data type changed to Memo/Attachment/Long Text/OLE
            Object                                                 1

        Field: Grading_Gradering
        • Data type changed to Number                              1
5.1.4   Field: Birthdate_Geboortedatum                                            5
        • Required property
            Set to Yes                                             1
        • Format
            Set to Medium Date                                     1
        • Validation Rule
            <=  Now()                                             2
            OR
            <= Today()
            OR
            <=Date()
        • Validation text
            'Do not enter a date later than today'                 1

        (Notes to marker:
        • Accept date format of dd-MM-yy
        • Accept any appropriate message referring to the current
           date that should be used.
        • Accept if candidates used <=#2014/10/20#.)
5.1.5   Field: CellNumber_Selnommer                                               3
        Input Mask: 000 000 0000 will appear as 000\ 000\ 0000 or
        000" "000" "0000
        • Correct character 0                                      1
        • One or two spaces correctly placed                       1
        • Ten valid placeholders                                   1

Copyright reserved                                                           Please turn over

### Page 11

Downloaded from hlayiso.com
Computer Applications Technology/P1           11                             DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

Form: frm5_2
5.2     •   Font colour of the text in the form header is a shade of               6
            orange                                                      1
        •   Format of Rate_Tarief field changed to currency             1
        •   Combo box added in details section                          1
        •   Control source: Country                                     1
        •   Row Source: 'Kenya', 'Namibia',' South Africa', 'Tanzania'
            and 'Zambia'                                                1
        •   Suitable label added                                        1

        (Notes to marker:
        • Accept any currency.
        • Ignore duplicates in values of combo box.
        • Accept list box.)
Query: qry5_3
5.3     •   HotelGrading_HotelGradering criteria: 9                     1         3
        •   HotelsLodges_HotelleLodges criteria: Like "S  * "          2

        (Notes to marker:
        • 2 records expected.
        • Accept Between "S" and "T".)
Query: qry5_4
5.4     •   DateIn_DatumIn criteria: >=#2014/10/01# or Between                     6
            #2014/10/01# and #2014/10/31# OR
            Month([DateIn_DatumIn])=10 OR >=#2014/10/01# And
            <=#2014/10/31#                                              1
        •   DateOut_DatumUit criteria: <=#2014/10/31# OR Between
            #2014/10/01# and #2014/10/31# OR
            Month([DateOut_DatumUit])=10 OR >=#2014/10/01# And
            <=#2014/10/31#                                              1
        •   Calculated field is Tot: [Charges_Koste] + [Levy_Heffing]
            Calculated field name: Tot                                  1
            Two fields used correctly                                   1
            Addition                                                    1
        •   Only ClientName_KliëntNaam,
            HotelsLodges_HotelleLodges, DateIn_DatumIn,
            DateOut_DatumUit fields are displayed                       1

        (Notes to marker:
        • 12 records expected.
        • Date format could differ due to Regional settings.
        • Accept any date range that incorporates the month of
           October. E.g. Like "*/10/*".
        • Accept the use of the month function as an additional field
           or as criteria.

Copyright reserved                                                              Please turn over

### Page 12

Downloaded from hlayiso.com
Computer Applications Technology/P1           12                        DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                           EXAMINATION
                           NUMBER

Query: qry5_5
5.5     •   HotelsLodges_HotelleLodges field: Sorted ascending     1         6
        •   Country_Land field criteria: NOT "Tanzania" OR
            <>"Tanzania"                                           1
        •   Rate_Tarief field criteria : >=5000  and  <=7000     3

            OR Between 5000 and 7000

            OR >4999 and <7001

        •   Only HotelsLodges_HotelleLodges, Country_Land and
            Rate_Tarief fields displayed                           1

        (Note to marker: 6 records expected.)
Report: rpt5_6
5.6     •   Landscape orientation                                  1         6
        •   Report shows only ClientSurname_KliëntVan,
            HotelsLodges_HotelleLodges, Country_Land and
            Days_Dae fields                                        1
        •   Report firstly grouped according to Country_Land       1
        •   Report secondly grouped by HotelsLodges_HotelleLodges
                                                                   1
        •   Function in HotelsLodges_HotelleLodges group
            footer/group header                                    1
            =sum([Days_Dae])                                       1

        Total for QUESTION 5                                                 [40]

Copyright reserved                                                         Please turn over

### Page 13

Downloaded from hlayiso.com
Computer Applications Technology/P1           13                                 DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                              EXAMINATION
                              NUMBER

QUESTION 6                              File name: 6Serengeti                                Total Q6: 20

•     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.
•     The code of the candidates who use a word processor will contain additional
      unnecessary tags. Markers will need to work through the code to check for the
      answers provided below.

                                                                               Maximum        Candidate
    No                                Criteria
                                                                                 Mark           Mark
6.1       Title                                                                          2
          <title>Serengeti Information</title>

          •   Title tags                                                  1
          •   Applied to the correct text 'Serengeti Information'         1
6.2       Alignment and Font Colour                                                      2
          <h1 Align="Center"><Font color="red">Serengeti National
          Park</font></h1>

          •   'Serengeti National Park' centred                           1
              align="center"
          •   'Serengeti National Park' font colour changed to red        1
              font color="red"

6.3.1     Image                                                                          2
          • <img src="6SerengetiPark                                      1
          • .jpg" >                                                       1

          (Note to marker: Mark this from the HTML code.)
6.3.2     Height and Width                                                               2
          • width="200"  height="180"                                    2

          (Notes to marker:
          • Mark this from the HTML code.
          • Ignore if the values are swopped.)
6.4       Bulleted list                                                                  2
          <ul>
           <li>About the Serengeti</li>
           <li>Serengeti Facts</li>
          </ul>

          •   The text 'About the Serengeti, Serengeti Facts' appears in
              a bulleted list                                             1
          •   Two list tags/items                                         1

          (Note to marker: Allocate mark if at least one item appears in
          the list.)

Copyright reserved                                                                  Please turn over

### Page 14

Downloaded from hlayiso.com
Computer Applications Technology/P1           14                         DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                          EXAMINATION
                          NUMBER

6.5     Link                                                                   3
        • <a href=                                                 1
        • "#Contact" >                                             1
        • Contact us </a>                                          1
6.6     Paragraph from Info_Inligting document                                 2
        • Text copied from document                                1
        • Placed as third paragraph                                1

6.7     Table                                                                  4
        <table border="2" width="500">
               <tr>
               <td>
               <h2>Serengeti Facts</h2>
               </td>
               <td>
                 Country Tanzania</br>
                 Coordinates 17.9233S, 25.856E</br>
                 Plain 5 km</br>
                 Water Course Olduvai</br>
               UNESCO World Heritage Site1989</br>
               </td>
               </tr>
               <tr>
               <td>
               <h2><a name="Contact">Contact Details
               </a></h2>
               </td>
               <td>
                  Tel: 997 521 8547</br>
                  Fax: 998 521 8547</br>
                  Email: serengeti@africa.com</br>
               </td>
               </tr>
        </table>

        •   The table consists of two rows and two columns         1
        •   Only headings appear in column 1                       1
        •   Data/information appears in column 2                   1
        •   Border thickness set to 2                              1

        (Note to marker: Mark this question from HTML code.)
6.8     Comment                                                                1
        <!-- Examination Number-->

        •   Examination number appears as a comment                1

        (Notes to marker:
        • Mark this question from HTML code.
        • Accept any text in the comment.)
        Closing tag(s) omitted                                      -1

        Total for QUESTION 6                                                  [20]

Copyright reserved                                                          Please turn over

### Page 15

Downloaded from hlayiso.com
Computer Applications Technology/P1           15                                      DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                             EXAMINATION
                             NUMBER

QUESTION 7                                                                                        Total Q7: 20
       File names: 7Top10, 7Convert_Verander, 7TouristsSA_ToeristeSA,
            7Attract_Besiens, 7Merge_Saamvoeg, and 7MData_MData
                                                                                    Maximum        Candidate
 No                                   Criteria
                                                                                      Mark           Mark
7Top10
7.1      Author property                                                                      1
         • Author property changed to examination number                       1

         (Note to marker: Accept the word 'examination number'.)
7Convert_Verander
7.2      Convert to web page                                                                  1
         • 7Convert_Verander saved as a single web page                        1

         (Note to marker: Accept any of .mhtml, .mht, .html, .xhtml
         extensions.)
7GraphSA_GrafiekSA
7.3      Edit graph/chart                                                                     2
         • Data range extended to A2:C13                                       1
         • Graph/chart changed to 3-D Line/3D-Lines                            1

7Attract_Besiens
7.4.1    Footnote                                                                             2
         • Footnote added to the text 'How many people visit South
            Africa?'                                                           1
         • Footnote reads: 'Refer to the website www.attractions.com'
                                                                               1
7.4.2    Linked graph/chart                                                                   2
         • Graph pasted in 7Attract_Besiens                                    1
         • Graph pasted as a link                                              1

         (Note to marker: Click on File, Edit links to determine if a link to
         the original document was created, even if the spreadsheet
         does not open.)
7.4.3    Find and Replace                                                                     2
         • All occurrences of the whole word 'tour' have been
            replaced with the word 'trip'                                      1
         • In a bluish font colour                                             1

         (Notes to marker:
         • The word 'trip' appears 5 times, two should appear in blue.
         • Do not allocate the first mark if the word 'tours' or 'tourism'
            has been changed.)

Copyright reserved                                                                       Please turn over

### Page 16

Downloaded from hlayiso.com
Computer Applications Technology/P1           16                             DBE/November 2014
                               NSC – Memorandum/Marking Guideline
                          EXAMINATION
                          NUMBER

7.4.4   Columns                                                                    3
        • The last two paragraphs (Oudtshoorn, Robben Island)
           appear as two columns                                        1
        • Column break inserted in correct position (before Robben
           Island)                                                      1
        • Text has been justified                                       1

        (Notes to marker:
        • Ignore if line is added between columns.
        • Check the properties for columns even if the text appears
           in one column.)
7Merge_Saamvoeg, 7MData
7.5     Merge                                                                      7
        • Trips_Reise greater than 20 (>20)  (Steel Brown should        1
           not be displayed)
        • International Traveller is equal to TRUE (=TRUE)              1
        • Sorted according to Name_Naam                                 1
           in ascending order                                           1
        • Name_Naam                                                     1
           and IntTraveller_IntReisiger fields appear                   1
        • Merge completed  (7MData)                                     1

        (Notes to marker:
        • Expected records: 10.
        • If International Travellers have not been selected expect 16
             records )
                                Number of
              Client Name          Trips
         Ashely Gilbert                  39
         Bertha Hood                     66
         Hayley Walsh                    38
         Illana Molina                   24
         Ima Lloyd                       50
         Kylan Maldonado                 45
         Linda Rich                      27
         Michelle Stokes                 30
         Otto Moss                       53
         Zoe Newman                      21
        Total for QUESTION 7                                                      [20]
                                                              TOTAL              180

Copyright reserved

## Related documents

- [CAT P1 Nov 2014 Afr](https://www.hlayiso.com/library/cat-p1-nov-2014-afr/1ee554bf-1d02-4780-acdf-8d6f3c4fb2d3) — Computer Applications Technology · QP · 2014 · Afr
- [CAT P1 GR12 MEMO ENG SEPT 2014](https://www.hlayiso.com/library/cat-p1-gr12-memo-eng-sept-2014/f694b747-f711-4b51-8411-49573692810d) — Computer Applications Technology · Memo · 2014 · Eng
- [Computer Application Technology P1 Nov 2020 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2020-memo-eng/29afe53d-081b-47cd-88fe-246bb4374530) — Computer Applications Technology · Memo · 2021 · Eng
- [Computer Application Technology P1 Nov 2019 Memo Afr](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2019-memo-afr/4a07e78a-9b1c-44e8-a466-b6c73c8cac4b) — Computer Applications Technology · Memo · 2019 · Afr
- [Computer Application Technology P1 Nov 2018 FINAL Memo Afr1](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2018-final-memo-afr1/8974d61d-2852-48cf-bd6a-b0d1137b07a1) — Computer Applications Technology · Memo · 2018
- [Computer Application Technology P1 Nov 2017 Memo Afr Rewrite](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-afr-rewrite/4c3ced4d-1987-42e1-85c6-38ce6cec21d3) — Computer Applications Technology · Memo · 2017 · Afr

## More from Grade 12 Computer Applications Technology

- [CAT P1 QP GR12 SEPT 2025 AFRIK watermark](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2025-afrik-watermark/1b848d13-4e0f-4b33-91ef-2fcd3dc2e6b9) — QP · 2025 · Afr
- [CAT P2 GR12 QP September 2025 ENG watermark](https://www.hlayiso.com/library/cat-p2-gr12-qp-september-2025-eng-watermark/fd63d968-a454-409d-9293-0862b56232b1) — QP · 2025 · Eng
- [CAT P1 QP GR12 SEPT 2024 Afrikaans](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-afrikaans/82b87849-4ee6-4b20-8b30-633307bd7329) — QP · 2024 · Afr
- [CAT P1 QP GR12 SEPT 2024 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-english/bf2518c3-ae79-4251-8145-1b062895b12f) — QP · 2024 · Eng
- [CAT P2 GR12 QP SEPT 2024 English](https://www.hlayiso.com/library/cat-p2-gr12-qp-sept-2024-english/b8b0a9f3-f8c6-4f0a-8ddf-30b58008b603) — QP · 2024 · Eng
- [Computer Applications Technology P1 Nov 2024 Afr](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2024-afr/502fe6df-4d11-41d1-8e23-b219565e715b) — QP · 2024 · Afr

## Collection

- [Grade 12 past papers](https://www.hlayiso.com/grade-12/past-papers)

---

Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.
