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
Skip to contentAll 2014 papers 





View all





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.
Computer Applications Technology · Grade 12 · NSC November Exam · 2014. Memorandum, 16 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2014
- Exam period
- NSC November Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 16
- File size
- 349.5 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 16
This exam
NSC November Exam 2014
Questions in this paper
Document textSearch extracted text and jump to a page.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Study this subject
Recommended for this subject

Question paper
Computer Applications Technology Grade 12 P1 2014 QP (Afr)

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

Memorandum
Computer Applications Technology Grade 12 P1 2021 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P1 2019 Memo (Afr)

Memorandum
Computer Applications Technology Grade 12 P1 2018 Memo (Afr)

Memorandum
Computer Applications Technology Grade 12 P1 2017 Memo (Afr)
More from Grade 12 Computer Applications Technology

Question paper
Computer Applications Technology Grade 12 P1 2025 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P2 2025 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P1 2024 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P1 2024 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P2 2024 QP (Eng)

Question paper