Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
COMPUTER APPLICATIONS TECHNOLOGY P1
NOVEMBER 2017
MARKING GUIDELINES
MARKS: 180
CENTRE FINAL MARK
NUMBER
EXAMINATION
NUMBER
QUESTION 1 2 3 4 5 6 7 TOTAL
POSSIBLE MARK 34 16 31 19 40 20 20 180
MARKER
SM
CM
IM/EM
These marking guidelines consist of 15 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 November Exam 2017 (English), 15 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · NSC November Exam · 2017. Memorandum, 15 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2017
- Exam period
- NSC November Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 15
- File size
- 454.3 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 15
This exam
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Computer Applications Technology/P1 2 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON
THE ANSWER.
QUESTION 1 File name: 1Harvest Total Q1: 34
Maximum Candidate
No. Criteria
Mark Mark
1.1.1 Heading (HARVEST FOOD FESTIVAL) 2
• Any WordArt applied to heading 1
• WordArt rotated by 90° or 270° 1
1.1.2 Picture 4
• Picture cropped to display only the basket and grapes 1
• Height set to 10 cm 1
• Width set to 12 cm 1
• Any oval-like picture style or shape applied 1
1.1.3 Table 2
• Default top cell margin set to 0.1 cm (check table or 1
cell options)
• No borders display 1
1.2 Page break 1
• Page break or section break (next page) inserted 1
1.3.1 Styles (Mark from Styles Gallery) 1
• Display1 style removed 1
1.3.2 Display2 style modified 4
• Numbering added in format 1., 2., (Accept 1), 2),) 1
• Any border added 1
• Left indent set to 0 cm 1
• All occurrences of the style updated 1
1.4 Cross reference (Figure 3: Gourmet Meals) 2
• Cross reference inserted within brackets (Accept 1
hyperlink/ bookmark)
• Reference to label 'Figure 3: Gourmet Meals' 1
1.5 Language 1
• Word 'explore' language changed to English (South
Africa) (mark from task bar) 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 3 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
1.6 Tabs 6
• Tab set at 2 cm 1
• Left aligned 1
• Tab set at 10 cm 1
• Right aligned 1
• Solid leader tab set 1
• Tab settings applied to all lines 1
1.7 Citation (Ward) 2
• Citation to 'Jean Ward' source inserted 1
• Year does not display 1
1.8.1 Caption (Figure 6: Jumping Castle) (Alt + F9) 2
• Automatic figure caption added to correct picture 1
• Text 'Jumping Castles' inserted for caption 1
1.8.2 Table of figures 1
• Table of figures updated (see 'Figure 5: Wine Shop') 1
1.9 Bibliography 2
Book, A. (2015). Too little too late. Entertainment All.
Business To All. (2016, July). Retrieved from Biz Communities:
www.biz_com.com
Sousher, P. L. (2014). Marketing South Africa. Business Journal, 61-62.
Ward, J. (2005). Coetzenburg: A Tourist Site.
• Automatic bibliography inserted 1
• Appears in APA style 1
1.10 Page numbering and section numbering 4
• Page number does not appear on first page 1
• Section 2/Last page formatted with i, ii, iii, … format 1
starts from i 1
• Style of page number with 'i' not changed 1
Total for QUESTION 1 [34]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 4 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 2 File name: 2Stay Total Q2: 16
Maximum Candidate
No. Criteria
Mark Mark
2.1 Page layout 2
• Page size set to 'Legal' (21.59 cm x 35.56 cm) 1
• Multiple pages set to 'Book fold' 1
2.2 Comment 2
• Any comment added ('New'/'Reply'/Edited) 1
• Any relevant response added 1
2.3 Watermark 3
• Any watermark added 1
• Image '2Pic.jpg' used 1
• Scale set to 200% 1
2.4 Check box: Special Shopper 7
• Default value set to checked 1
Combo box: Type of Accommodation
• Option 'B and B' added to combo box 1
• 'B and B' appears first 1
Text form field: Total
• Type: Number 1
• Number format: R# ##0.00;(R# ##0.00) 1
• Help text inserted on F1 key 1
• Any text entered (Days*Rate) (Allocate this mark if 1
text is in status bar)
2.5 SaveDate field (Alt + F9) 2
• Any date field added (Accept any date field in any 1
format)
• SaveDate field added 1
Total for QUESTION 2 [16]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 5 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 3 File name: 3Acc 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.
• The answers must still be correct even if changes are made to the existing data.
Maximum Candidate
No. Criteria
Mark Mark
Accom_Verblyf worksheet
3.1 Row 6: 2
• Row 6 height changed to exactly 45 pt 1
• Row 6 headings wrapped 1
3.2 Cell H7: 2
=G7-F7
OR
=DAYS(G7,F7)
OR
=DAY(G7)-DAY(F7)
• Correct cells used 1
• To determine difference correctly 1
3.3 Cell I8: 4
VLOOKUP(D8,Rate_Tarief!$B$3:$C$23,2)
OR
=VLOOKUP(D8,Rate_Tarief!$B$4:$C$23,2)
• Lookup value: D8 1
• Lookup range: Rate_Tarief!$B$3:$C$23 OR
Rate_Tarief!$B$4:$C$23 (accept named range) 1
• Absolute cell references correctly used (allocate 1
mark if named range was used)
• Correct column: 2 1
3.4 Cell J9: 3
=H9*I9 OR =PRODUCT(H9,I9) OR =(G9-F9)*I9
• Correct cells used 1
• Multiplication 1
• Format changed to any currency format 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 6 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
3.5 Cell L10: (Check for building blocks) 4
=LEN(K10)/100*J10
OR
=J10*LEN(K10)/100
OR
=J10*LEN(K10)%
OR
=LEN(K10)*1%*J10
OR
=J10*("0.0"&LEN(K10))
• LEN (K10) 2
• /100 (Accept decimals instead of percentages) 1
• * J10 1
(Notes to marker:
• Accept any method that will yield the correct answer.
• =IF(LEN(K10)=5,J10*5%,IF(LEN(K10)=4,J10*4%,
IF(LEN(K10)=3,J10*3%,IF(LEN(K10)=2,J10*2%,
J10*1%))))
• =IF(K10="*****",J10*5%,IF(K10="****",J10*4%,
IF(K10="***",J10*3%,IF(K10="**",J10*2%,J10*1%))).
• Mark allocation for nested if: test K10 for correct
number of stars, J10 used to calculate discount,
identified correct %, nested if correctly applied for all
options.)
3.6 Cell M7: (Check for building blocks) 6
=IF(VALUE(MID(C7,7,1))>=5,"Male","Female")
OR
=IF(VALUE(MID(C7,7,1))<5,"Female","Male")
• IF function 1
• Criteria: VALUE OR NUMBERVALUE function 1
((MID(C7,7,1 )) 1
>=5 OR >4 (OR >="5" if VALUE was not used) 1
• Value if true: "Male" OR "M" 1
• Value if false: "Female" OR "F" 1
(Notes to marker:
• Evaluate the candidates answer against the bulleted
options e.g. CODE function.
• Penalise only the second mark if VALUE was not used.)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 7 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
3.7 Cell G2: 3
=SMALL(I7:I66,3) OR =SMALL(I:I,3)
• SMALL function 1
• Range: I7:I66 1
• Third smallest: 3 1
3.8 Cell G3: 2
=MODE(I7:I66) OR =MODE(I:I)
• MODE function OR MODE.MULT OR MODE.SNGL
function 1
• Range: I7:I66 1
3.9 Cell G4: 5
=SUMIF(E7:E66,"Country*",J7:J66)
OR
=SUMIF(E7:E66,"*Country*",J7:J66)
OR
=SUMIF(E7:E66,"Country House",J7:J66)+SUMIF
(E7:E66,"Country Inn",J7:J66)
• SUMIF(S) function 1
• Criteria range: E7:E66 1
• Criteria: Country OR C * (accept * in front, 2
allocate both marks if "Country House" and "Country
Inn" was used)
• Sum range: J7:J66 1
(Note to marker: =SUMIFS(J7:J66,E7:E66,"Country*")
Total for QUESTION 3 [31]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 8 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 4 File name: 4Quest 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 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
Respons worksheet
4.1 Cell H3: 2
=COUNTBLANK(H6:H115)
OR
=COUNTIF(H6:H115,"")
• COUNTBLANK function 1
• Range: (H6:H115) 1
4.2 Cell K6: 4
=TIME(HOUR(J6),MINUTE(J6)+20,0)
OR
=J6+TIME(0,20,0)
OR
=SUM(TIME(0,20,0),J6)
OR
=J6+TIMEVALUE("0:20")
• J6 1
• Any time function 1
• 20 minutes 1
• Added 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 9 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
4.3 Cell K3: 4
=COUNTA(H6:H115)/K2*100
OR
=COUNTA(H6:H115)/K2
OR
=COUNTIF(H6:H115,"*")/K2
OR
=(K2-H3)/K2*100
OR
=(K2-H3)/K2
OR
=100*(1-H3/K2)
OR
=((K2-COUNTBLANK(H6:H115))/K2*100)/100
• COUNTA function OR K2-H3 1
• Range: (H6:H115) OR Correct use of brackets 1
• /K2 (Accept COUNTA of columns A, B, C, D or G) 1
• *100 OR format changed to percentage 1
4.4 Columns A and B: Conditional formatting 4
• Conditional formatting applied to A6:B115 1
• =$B$3=$G6 OR =$B$3=$G6:$G115 (Ignore 1
absolute cell reference)
• Absolute cell reference correctly applied ($G6 OR G6
OR $G6:$G115 OR G6:G115) 1
• Format style: Any fill colour 1
Earn_Verdien worksheet
4.5 Chart/Graph: 5
• Vertical axis title inserted 'Amount' 1
• 4Coin image inserted and stacked and scaled in 1
units of 100 000 (8 coins display) 1
• Horizontal axis labels:
o Alignment set to: Rotate all text 270° or 90° 1
o Major units set to 2 days 1
Total for QUESTION 4 [19]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 10 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 5 File name: 5Visit Total Q5: 40
Maximum Candidate
No. Criteria
Mark Mark
Table: tbAccom
5.1.1 Field: Name 1
• Field size changed to 30 1
5.1.2 Field: Surname 1
• Set as required field 1
5.1.3 Field: IdentityNumber 2
Input Mask: 0000000000000
• Compulsory digit used: 0 1
• 13 characters 1
5.1.4 Field: Province 2
• Option 'EC' added to drop down list 1
• Added as first option in drop down list 1
5.1.5 Field: DateIn 4
• Validation Rule:
>= #2017/11/18# AND <= #2017/11/28 # 3
OR >#2017/11/17# AND <#2017/11/29#
OR Between #2017/11/18# AND #2017/11/28#
OR Between "2017/11/18" AND "2017/11/28"
• Validation text
Any appropriate validation text that refers to the range
of dates 1
5.1.6 Field: Code 2
• Expression modified as: LEFT([Surname] 1
• ,3 ) 1
Form: frm5_2
5.2 • Form header text changed to examination number 1 6
(accept if examination number was added)
• Show date picker for DateIn field set to never 1
• Format of Rate field changed to any currency 1
• Date field inserted OR DATE() 1
• Time field inserted OR TIME() 1
• In the form footer 1
(Note to marker: Allocate Date and Time mark if =NOW()
was used.)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 11 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
Query: qry5_3
5.3 • Province criteria: LP OR MP OR In("LP","MP") 3 4
• Data sorted ascending by Surname 1
(Note to marker: 11 records expected.)
Query: qry5_4
5.4 • Total (Group by) row displayed 1 2
• SUM selected for NumberOfNights field in Total row 1
Query: qry5_5
5.5 • Only Name and Surname fields are displayed 1 7
• NumberOfNights criteria: <=5 (OR <6) 1
• Amount field criteria: <800 OR >2000 3
• DOB criteria: IS NULL OR Not Like "*" 1
• AND operator for all field criteria 1
(Note to marker: 2 records expected.)
Query: qry5_6
5.6 Calculated field: 4
Discount:[Amount]-[Amount]*10/100 OR
Discount:[Amount]-[Amount]*0.1 OR
Discount:[Amount]*0.9 OR
Discount:[Amount]*90/100
• New calculated field Discount added 1
• 10% calculated 1
• On the original Amount 1
• Subtract to get the difference 1
Report: rpt5_7
5.7 • Shading applied to Province field (in Province group 1 5
header)
• Amount field sorted in descending (largest to 1
smallest) order
• Function in Accommodation group footer/header 1
=SUM ([Amount]) 2
(Note to marker: Allocate the marks for the function even
if it appears in the wrong place.)
Total for QUESTION 5 [40]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 12 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 6 File name: 6Viti Total Q6: 20
• NO marks should be allocated for answering this question using Word.
• 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 Font Type 1
<font face="Arial">
• Font type set to 'Arial' 1
6.2 Heading 1: 'Growing Grapes' 2
<h1 align="center"><font color="blue">Growing
Grapes</font></h1>
OR
<h1><center><font color="Blue">Growing
Grapes</font></center></h1>
• Text 'Growing Grapes' alignment set to centre 1
align="center" OR <center></center>
• Text 'Growing Grapes' font colour set to blue 1
<font color="blue">
6.3 Horizontal line 2
<hr size="3"> OR <hr size="3"/>
• Horizontal line inserted 1
• Size set to 3 1
6.4 Bulleted list 3
<ul type="circle">
<li>the composition of the soil</li>
<li>the climate</li>
<li>situation of vineyard</li>
</ul>
• Unordered list 1
• Bullet circle type: type="circle" applied to all list
items 1
• List item applied to at least one item (if list items are 1
not closed, check line 1 for <<!DOCTYPE html>>)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 13 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
6.5 Image: Height and width 4
<img src="6Hectare.png" height="250" width="350">
• Img tag 1
• Correct source file: src = "6Hectare.png" 1
• Height set to 250 1
height="250"
• Width set to 350 1
width="350"
6.6 Table 5
<table border="5" width="60%">
<tr>
<td colspan="2"><font color="blue">
<b>Variety of grapes</b></font></td>
</tr>
…
<tr>
<td>Currants*</td>
<td>987 125</td>
</tr>
<tr>
<td>Sultana</td>
<td>148 759 871</td>
</tr>
</table>
• Table border changed to 5: border="5" 1
• Spans two columns: colspan="2" 1
• Last row added to table: <tr> … </tr> 1
• Two cells added to last row: <td> … </td> 1
• Any required text added in at least one cell 1
6.7 Hyperlink 3
<a href="6SAStats.docx"><img src=6More.jpg></a>
• Hyperlink created: <a href></a> 1
• On image 1
• To correct file: "6SAStats.docx"> 1
Closing tag(s) or triangular brackets omitted or
-1
incorrect nesting
Total for QUESTION 6 [20]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 14 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 7 File names: 7Calc, 7Rep Total Q7: 20
Maximum Candidate
No. Criteria
Mark Mark
7Calc: Num_Nom worksheet
7.1 Cell A3: 10
RANDBETWEEN (100,999)
OR
=RAND()*(999-100)+100
OR
=RANDBETWEEN(1,9)&RANDBETWEEN(0,9)&
RANDBETWEEN(0,9)
• RANDBETWEEN OR RAND function 1
• Lower boundary (Any 3-digit number) 1
• Upper boundary (Any 3-digit number) (Should be
larger than lower boundary) 1
Cell B3:
=LEFT(A3,1) OR TRUNC(A3/100) OR MID(A3,1,1) OR
INT(A3/100) OR LEFT(A3)
• LEFT function (OR TRUNC OR MID) 1
• Extract one character from cell A3 1
Cell C3:
=RIGHT(A3,1) OR MID(A3,3,1) OR MID(A3,LEN(A3),1)
OR A3-INT(A3/10)*10 OR RIGHT(A3)
• RIGHT function (OR MID) 1
• Extract one character from cell A3 1
Cell D3:
=IF(B3=C3,"YES","NO") OR
=IF(EXACT(B3,C3),"YES","NO")
• Check that B3=C3 (OR (B3<>C3)) 1
• Value if true: "YES" 1
• Value if false: "NO" 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 15 DBE/November 2017
NSC – Marking Guidelines
EXAMINATION
NUMBER
7Calc: Vouch_Bewys worksheet
7.2.1 Cell E2: (Check for building blocks) 7
=TODAY()<=DATE(YEAR(NOW()),MONTH(D2),DAY(D2))
OR
=IF(TODAY()>=DATE(2017,MONTH(D2),DAY(D2)),
"FALSE","TRUE")
OR
=IF(TODAY()<DATE(YEAR(TODAY()),MONTH(D2),DAY(D
2)), "TRUE","FALSE")
OR
=IF(DATE(YEAR(TODAY()),MONTH(D2),DAY(D2))>=TOD
AY(),"TRUE", "FALSE")
OR
=OR(AND(MONTH(D2)=MONTH(TODAY()),DAY(D2)
>=DAY(TODAY())),MONTH(D2)>MONTH(TODAY()))
OR
=OR(IF(MONTH(D2)>MONTH(TODAY()),TRUE),
AND(MONTH(D2)=MONTH(TODAY()),DAY(D2)
>=DAY(TODAY())))
OR
=IF(MONTH(D2)>MONTH(TODAY()),"TRUE",
IF(MONTH(D2)=MONTH(TODAY()),IF(DAY(D2)
>=DAY(TODAY()),"TRUE","FALSE"),"FALSE"))
• Criteria 1: Check if birth month is greater than current
month 1
• Correct output (TRUE) if birth month/date is greater
than current month/date 1
• Criteria 2: Check if current month is equal to birth
month AND current day is greater or equal to birth 1
day 1
• Correct output (TRUE) if both aspects in criteria 2 are
true 1
• Correct output (FALSE) if criteria 2 is false 1
• Function copied to cells E3:E111 1
(Note to marker: Award the output mark if the second
criteria is wrong but the output is correct.)
7.2.2 rpt7_2 report in 7Rep database 3
• 7Calc data imported to 7Rep (110 records) 1
• Any report created with 4 or 5 correct fields 2
Total for QUESTION 7 [20]
TOTAL 180
Copyright reserved
Study this subject
Recommended for this subject

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 (Afr)

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

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