Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
COMPUTER APPLICATIONS TECHNOLOGY P1
FEBRUARY/MARCH 2017
MEMORANDUM/MARKING GUIDELINES
MARKS: 180
CENTRE FINAL MARK
NUMBER
EXAMINATION
NUMBER
QUESTION 1 2 3 4 5 6 7 TOTAL
POSSIBLE MARK 37 17 38 17 37 19 15 180
MARKER
SM
CM
IM/EM
This memorandum/marking guideline consists of 14 pages.
Copyright reserved Please turn over
Skip to contentAll 2017 papers 





View all





Computer Applications Technology Grade 12 P1 2017 Memo (Eng)
Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC Supplementary Exam 2017 (English), 14 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · NSC Supplementary Exam · 2017. Memorandum, 14 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2017
- Exam period
- NSC Supplementary Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 14
- File size
- 471.3 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 14
This exam
NSC Supplementary Exam 2017
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Computer Applications Technology/P1 2 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE AN IMPACT ON
THE ANSWER.
QUESTION 1 File name: 1Areas Total Q1: 37
Maximum Candidate
No Criteria
Mark Mark
1.1.1 Abstract 1
• Language set to ONLY English (South Africa) 1
1.1.2 Abstract alignment 1
• Text of abstract justified 1
1.2 Image 2
• Image cropped to any shape 1
• Sharpness set to 50% or any other % besides 0% 1
1.3 Subtitle text control 1
• Content control (not text) removed 1
1.4 Table of contents 4
• Table of contents inserted with 'Classic' style 1
• 'Water' style used as first heading style/level 1
• 'Heading 1' style used as second heading style/level 1
(Alt F9: {TOC \h \z \t "Heading 1,2,Water,1"})
• Page numbers have solid leaders 1
1.5 Page numbers 5
• Automatic page numbering inserted in the footer 1
• Formatted as 'Page 1' OR 'page 1' style 1
• Numbering starts as 1 on the 'Contents' page 1
• Odd page numbers aligned on the left 1
• Even page numbers aligned on the right 1
(Notes to marker:
• Accept if odd and even was swopped.
• Award the fourth mark if 'Different odd and even' was
checked, even if no numbers were inserted.)
1.6 Dropped cap 2
• Dropped cap applied on 'Our' (any number of lines) 1
• Spacing set to 0.5 cm from the text 1
1.7 Cross-reference 2
• Cross-reference added on text 'table 1' (Ref475517156) 1
• Links to table 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 3 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
1.8.1 Table style (Water Source Area Table) 1
• Any predefined style applied 1
1.8.2 Table heading 1
• 'Repeat Header Rows' checked for first row 1
1.8.3 Footnote 3
• Footnote inserted on text 'Grootwinterhoek' (check 1
'Grootwinterhoek' text on other pages)
• Reads as 'Strategic water sources' (accept any text) 1
• '*' used as symbol 1
1.9 Caption (WESTERN CAPE WATER SOURCE AREAS) 2
• Any automatic caption added to image 1
• Label reads as 'Image 1' (or 'image1') 1
1.10 Bullets 1
• Bullets below 'Boland Mountains' changed to Wingdings
character number 165 () 1
1.11 WordArt 2
• WordArt applied to 'Did you know?' 1
• Text wrapping set to 'Top and Bottom' 1
1.12 Chart/Graph (MPUMALANGA DRAKENSBERG) 2
• Any data of chart/graph changed 1
• Two changes correctly made to any graph (Cultivated 2%,
Natural 48%) 1
1.13 Citation 3
• Any automatic citation inserted 1
• Report source created 1
• Correct fields: Title: The effects of water, Year: 2015 1
entered (accept if only one field was entered)
1.14 Table of figures 2
• Table of figures added to show images 1
• Table of figures displaying tables has not been deleted 1
(award only if attempt was made for first bullet)
1.15 Page layout 2
• Last page changed to portrait 1
• Other pages remain in landscape (award only if attempt 1
was made for first bullet)
Total for QUESTION 1 [37]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 4 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
QUESTION 2 File names: 2Water, 2Done Total Q2: 17
Maximum Candidate
No Criteria
Mark Mark
2.1 Date field 2
• Any date added 1
• Field will automatically update 1
2.2 Textbox fill 2
• Second text box filled with 2Drops image 1
• All/some text bolded in any text box 1
2.3 Drop-down field: Gender 1
• 'Femail' spelling changed to 'Female' 1
2.4 Check box: 'Older than 60' 1
• Any check box inserted to the left of text (or in any 1
other position)
2.5 Text form field: 'Number of adults …' 1
• Type changed to 'Number' 1
2.6 Number form field: 'How much do you pay …' 1
• Number format changed to value with 'R' currency
format 1
2.7 Tabs 4
• Leader tabs/tab set to approximately 6 cm, 10 cm and
15 cm 1
• Left tabs used in all cases 1
• Tab leaders added in two cases (6 cm and 15 cm) 1
• All tabs correctly applied 1
2.8 Mail merge 5
• Data source 2Det_Bes used 1
• Any sorting done 1
in ascending order 1
• Name and Surname fields inserted 1
• Merge completed (2Done) 1
(Note to marker: 29 or 30 letters expected.)
Total for QUESTION 2 [17]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 5 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
QUESTION 3 File name: 3Rain_Reën Total Q3: 38
• 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.
• The answers must still be correct even if changes are made to the existing data.
Maximum Candidate
No Criteria
Mark Mark
Rain_Reën worksheet
3.1.1 Row 1: 1
• Merged cell changed to A1:O1 1
3.1.2 Row 1 fill: 2
• Any fill effect applied 1
• Thin diagonal stripe pattern style fill effect applied 1
(accept any diagonal stripes)
3.2 Freeze panes: 2
• Freeze panes effect applied 1
• Correct columns and rows (rows 1 and 2, columns A
and B) 1
3.3 Cell D3: 1
• =VALUE(C3) 1
(Note to marker: After sorting =VALUE(C6).)
3.4 Cell G48: 2
• =MODE (G3:G46) 2
3.5 Cell H49: 3
=ROUNDUP(AVERAGE(H3:H46),0)
OR
=CEILING(AVERAGE(H3:H46),1)
OR
=ROUND(AVERAGE(H3:H46)+0.5,0)
• AVERAGE(H3:H46) 1
• ROUNDUP/CEILING/INT 1
• ,0 for ROUND/ROUNDUP and ,1 for CEILING 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 6 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
3.6 Cell K50: 2
=LARGE(K3:K46,3)
• LARGE function 1
• Correct range and parameters (K3:K46,3) 1
3.7 Cell M51: 4
=SUMIF(B3:B46,"2015",M3:M46)
• SUMIF function 1
• Criteria range: (B3:B46) 1
• Criteria: "2015" 1
• Sum range: (M3:M46) 1
3.8 Conditional formatting Column D to Column O: 5
• Conditional formatting has been applied to cells
D3:O46 1
• 3 different colours applied (any colours) 1
• Lowest point set to 0 1
• Midpoint set to 100 1
• Highest point is set to 630 1
(Note to marker: No marks awarded if conditional
formatting has not been applied.)
3.9 Cell R4: 6
=IF(SUM(D24:O24)>650,"High","Low")
OR
=IF(SUM(D24:O24)<=650,"Low","High")
• IF-syntax is correctly used 1
Conditions:
• Sum of Cape Town 2015 (or any other range) 2
• Smaller than or equal to 650 (or greater than) 1
• Value "Low" if less than or equal to 650 1
• Else value "High" if greater than 650 1
(Notes to marker:
• Accept building blocks.
• There are many alternative answers. Evaluate the
candidates answer against the bulleted options.
• Accept D44:O44.)
3.10 Sorting: 2
• First sorted by year – smallest to largest 1
• Second sorted by city – A to Z 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 7 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
Durban worksheet
3.11 Cell C6: 2
=SUBTOTAL($A$6,C10:C53)
OR
=SUBTOTAL($A$6,C9:C53)
• Cell range C10:C53 1
• Absolute cell reference 1
3.12 Filter: 1
• Filter set on Durban 1
Bloemfontein worksheet
3.13 Graph 5
• Area chart/graph displays rainfall per month per year
for Bloemfontein (range B1:O12) 1
• Suitable chart title inserted 1
• Any legend inserted below 1
• Horizontal axis options display years 1
• Data labels inserted for 'Total' series 1
Total for QUESTION 3 [38]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 8 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
QUESTION 4 File name: 4Game_Speel Total Q4: 17
• 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.
• The answers must still be correct even if changes are made to the existing data.
Maximum Candidate
No Criteria
Mark Mark
Scores_Punte worksheet
4.1 Hyperlink: 1
• Hyperlink removed from heading 'Water Games' 1
4.2 Cell E3: 3
=(TODAY()-D3)/7
OR
=(NOW()-D3)/7
OR
=DAYS(NOW(),D3)/7
OR
=DAYS(TODAY(),D3)/7
• TODAY() function 1
• -D3 1
• /7 1
(Notes to marker:
• Accept if the current date was entered in a cell and
the cell reference was used.
• If the DAYS function was used allocate one mark for
the function and one mark each for the correct
parameters.)
4.3 Data validation: 2
• 'Black' removed from the list 1
• Applied to the whole column G 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 9 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
4.4 Cell I3: 7
=LEFT(C3,2)&" "&RANDBETWEEN(0,99)&LOWER(F3)
OR
=CONCATENATE(LEFT(C3,2)," ",RANDBETWEEN(0,9
9), LOWER(F3))
OR
= MID(C3,1,2)&" "&RANDBETWEEN(0,99)&
LOWER(F3)
• LEFT (or MID) function 1
• Cell reference and number of characters (C3,2) 1
• Space 1
• RANDBETWEEN function 1
• Parameters (0,99) 1
• LOWER function and cell reference F3 1
• CONCATENATE OR & operators correctly used 1
4.5 Cell J3: 4
=HLOOKUP(H3,Awards_Toekennings!$A$1:$E$3,2)
• HLOOKUP function 1
• Lookup value: H3 1
• Lookup range: Awards!$A$1:$E$3 (ignore if no 1
absolute cell reference, accept B1:E3)
• Row number: 2 1
(Note to marker: If the candidate changed the orientation
of the Awards_Toekennings worksheet, VLOOKUP may
be used.)
Total for QUESTION 4 [17]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 10 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
QUESTION 5 File name: 5Dam Total Q5: 37
Maximum Candidate
No Criteria
Mark Mark
Table: Dam
5.1.1 Field: Name or Location 1
• Set as primary key 1
5.1.2 Field: Town 1
• > inserted in Format field property 1
5.1.3 Field: Province 2
• Combo box created 1
• Row source: Province 1
5.1.4 Field: Completed 5
Input Mask: 00/>LLL/0000
• Two compulsory digits: 00 1
• Uppercase: > 1
• Three compulsory letters: LLL 1
• Four compulsory digits: 0000 1
• Divider: / (accept '-' due to computer settings) 1
5.1.5 Field: Capacity 1
• Validation Rule
>=0 OR NOT <0 1
5.1.6 Field: Illustration 2
• Data type changed to OLE Object/ Hyperlink 1
• 5AlbertFalls image inserted for the 'Albert Falls Dam'
record 1
(Note to marker: Check on Hyperlink when file is
transferred to another computer.)
Query: qry5_2
5.2 • Town field inserted 1 2
• Criteria in Province field: Limpopo 1
(Note to marker: 15 records expected.)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 11 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
Query: qry5_3
5.3 • Fields displayed: Province, Avg Of Capacity OR 5
Capacity 1
• Criteria on Province: "Free State" 1
OR "North West" 1
• AVG (ignore whether rounded or not) 1
• Calculated on Capacity field 1
(Note to marker: 2 records expected.)
Query: qry5_4
5.4 • Only Name and Town fields display 1 4
• Criteria on Surface: IS NOT NULL OR "Like *" OR
"True" 1
• Criteria on Completed:
Between #01/01/1990# AND #31/12/2000# 2
OR >=#1/1/1990# AND <=#12/31/2000#
(Notes to marker:
• 11 records expected.
• Format of the dates may differ depending on system
dates.)
Query: qry5_5
5.5 • Calculated field called Volume has been created 1 4
• Calculation: [Surface]*[Height]*0.3 1
• Format changed to Fixed/Standard and one 1
decimal place 1
Form: frm5_6
5.6 • 5AlbertFalls image added as form background 1 5
image 1
• Hyperlink inserted next to Province label 1
• Links to the Province table NOT database 1
• Examination number displays in the form footer 1
Report: rpt5_7
5.7 • Illustration label AND field removed 1 5
• Report grouped according to Province 1
• Report sorted by Town 1
• Function in Province report footer/report header 1
=MAX([Capacity]) 1
Total for QUESTION 5 [37]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 12 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
QUESTION 6 File name: 6Wise_Wys Total Q6: 19
• This question should be marked from the HTML code.
• Numerical attribute values do not need to be in inverted commas.
• A maximum of 1 mark will be deducted if one or more closing tags are omitted.
Maximum Candidate
No Criteria
Mark Mark
6.1 Title 1
<title>Examination number</title>
• Examination number inserted inside title tags 1
6.2 Table cell and image 3
<td><img src="6Life.jpg"></td>
• Additional cell inserted anywhere 1
• 6Life.jpg image inserted 1
• Image tags correctly inserted 1
6.3 Horizontal line 2
<hr size="5">
• Horizontal line inserted 1
• Size set to 5 1
6.4 Alignment and font 2
<h2 align="center"><font face="Arial">Are you water
wise?</font></h2>
• Alignment set to centre 1
• Font changed to 'Arial' 1
6.5 Table border 2
<table border="1" cellpadding="12">
• Border set to 1 1
• Cellpadding set to 12 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 13 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
6.6 Table columns 3
<td colspan="2">
<font size="3">
<i>The kitchen … Here are some suggestions:</i>
</font>
</td>
• One table cell appears 1
• Closing tags for first cell and opening tags for second
cell removed 1
• Column span set to 2 1
6.7 Alternative text 1
<tr>
<th><img src="6House.jpg" alt = "Inside">Inside the
house</th>
• Alternative text 'Inside' added on 6House image 1
6.8 Unordered list 2
<ul type="circle">
<li>Avoid ….</li>
<li>Run ....</li>
<li>Keep ....</li>
<li>Check your ...</li>
<li>Install ...</li>
<li>Take ...</li>
<li>When ...</li>
<li>Turn ....</li>
</ul>
• Type set to circle 1
• All list items have opening and closing tags 1
6.9 Link 3
<a href=mailto:"waterwize@water.co.za">
waterwize.co.za</a>
• Link created on the text 'waterwize.co.za' (accept any
text) 1
• Links to an e-mail address – Mailto: 1
• E-mail address 'waterwize@water.co.za' 1
Closing tag(s) or triangular brackets omitted or more
than one closing tag in the incorrect order -1
Total for QUESTION 6 [19]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 14 DBE/Feb.–Mar. 2017
NSC – Memorandum/Marking Guidelines
EXAMINATION
NUMBER
QUESTION 7 Total Q7: 15
File names: 7River_Rivier, 7Rivers_Riviere, 7Answ_Antw
Maximum Candidate
No Criteria
Mark Mark
7Rivers_Riviere worksheet
7.1.1 Header 3
• Worksheet name added 1
• As field 1
• In the left section of the header 1
7.1.2 Named range 1
• Named range changed to 'Name_River' 1
(Note to marker: Accept if a new named range
'Name_River' was inserted.)
7.1.3 Protection 2
• Columns A to C locked 1
• Password 123 used 1
7River_Rivier database
7.2 Import table 2
• Data from the 7Rivers_Riviere spreadsheet imported
in 7River_Rivier database 1
• Saved as a new database table called Rivers 1
7Answ_Antw
7.3.1 Gutter position of the document 1
• Top 1
7.3.2 Number of paragraphs in the document 1
• 83 1
7.3.3 Number of occurrences of the letter 'm' in the document 1
• 185 1
7.3.4 First word that appears on line 100 1
• rates OR crop 1
7.3.5 Line weight of the 'Intense Quote' style 1
• 0.5 OR (½) 1
7.3.6 Word marked as an index 1
• SHARPS 1
7.3.7 Title of the citation source that appears in the document 1
• Water Savers 1
Total for QUESTION 7 [15]
TOTAL 180
Copyright reserved
Study this subject
Recommended for this subject

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

Memorandum
Computer Applications Technology Grade 12 P2 2017 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P2 2017 Memo (Afr)

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

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

Memorandum
Computer Applications Technology Grade 12 P1 2017 Memo (Eng)
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