Downloaded from hlayiso.com
SENIOR CERTIFICATE EXAMINATIONS
COMPUTER APPLICATIONS TECHNOLOGY P1
2016
MEMORANDUM/MARKING GUIDELINE
MARKS: 180
CENTRE FINAL MARK
NUMBER
EXAMINATION
NUMBER
QUESTION 1 2 3 4 5 6 7 TOTAL
POSSIBLE MARK 24 26 25 25 42 19 19 180
CANDIDATE'S
MARK
MARKER CODE/
SIGNATURE
MODERATED
MARK
This memorandum/marking guideline consists of 14 pages.
Copyright reserved Please turn over
Skip to contentAll 2016 papers 





View all





Computer Applications Technology Grade 12 P1 2016 Memo (Eng)
Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC June Exam 2016 (English), 14 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · NSC June Exam · 2016. Memorandum, 14 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2016
- Exam period
- NSC June Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 14
- File size
- 488.2 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 14
This exam
NSC June Exam 2016
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Computer Applications Technology/P1 2 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
IGNORE SPELLING IN CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE
ANSWER.
QUESTION 1 File name: 1Effect_Effek Total Q1: 24
Candidate
No Criteria Max Mark
Mark
1.1.1 First Page 3
• (Any) picture added to first page 1
• Correct picture 1Music_Musiek added 1
• Picture wrapping/alignment changed to appear at top
right-hand corner of page 1
1.1.2 First Page 2
• Text box added (anywhere) to the first page 1
• 'Elvis High School' added as text to the text box 1
1.2 Styles 3
• New style 'Music' created 1
• Font size formatted to 48 pt 1
• Text centred 1
1.3 Page Border 2
• Any page border added 1
• First page only 1
1.4 Watermark 2
• Watermark text: 'First Draft' added 1
• Watermark text added only to first page 1
(Note to marker: Do not accept if 'Different First Page' has
been selected and watermark has not been deleted from
second page.)
1.5 Comment 1
• Comment deleted 1
1.6 Text Effect 2
• Font colour orange gradient text fill effect applied 2
to heading 'The Effect Music Has On Me'
(Notes to marker:
• Allocate first mark if font colour was changed.
• Mark from dialogue box.)
1.7 Dropped Cap 3
• Dropped cap effect applied to the 'M' of 'Music' 1
• Over 2 lines 1
• 0.6 cm/16 pt away from text 1
1.8 Line Spacing 1
• Second paragraph line spacing set to 'Multiple 1.15' 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 3 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
1.9 Endnote 3
• Endnote inserted on text 'Rap and Rock' 1
• Appears in capital Roman number format 'I' 1
• Text entered in endnote ('Adapted from an article by 1
S Mariam')
1.10 Find and Replace 2
• 2 occurrences of manual line break (soft enter) 1
• Replaced with hard enters/paragraph marks 1
(Note to marker: Located at the end of the second and
third paragraphs under the heading 'The Effect Music Has
On Me'.)
Total for QUESTION 1 [24]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 4 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
QUESTION 2 File name: 2Facts_Feite Total Q2: 26
Candidate
No Criteria Max Mark
Mark
2.1 Page numbering 5
• Page numbering (any style) inserted in the footer 1
• Automatic page numbering inserted (as a field) 1
• Page numbers are centred 1
• First page is not numbered 1
• Numbering starts as page 1 on the second page
(after the table of contents page) 1
(Note to marker: Ignore if the numbering on the landscape
pages from Question 2.6 onwards differs.)
2.2 Table of Contents 4
• Automatic table of contents inserted 1
• Fancy style used (Small caps) 1
• Two levels of headings appear 1
• Solid line leader tab appears for page numbers 1
(Note to marker: Ignore if ToC appears twice.)
2.3 Styles and Table of Contents 2
• 'Heading 1' style applied to the heading 1
• Table of contents reflects new entry (any style) 1
2.4 Citations 3
• New interview source added 1
• 'Steve Johnson' inserted as interviewee 1
• Text 'Placeholder1' replaced with automatic citation 1
2.5 Columns 4
• Text appears in 3 columns 1
• Spacing between columns is set at 1.1 cm 1
• Column break applied to each sub-heading 1
• Text justified 1
(Note to marker: Award third mark for any column break.)
2.6 Page Orientation 2
• Page containing text in landscape orientation 1
• All other pages remain portrait orientation 1
2.7 Numbered and Bulleted List 5
• Level 1 numbering set to 1. 2. 3. 1
• Level 1 numbering aligned to 1 cm 1
• Level 1 text relatively aligned/indented to 2 cm 1
• Level 2 set to 1
• Level 2 bullet relatively aligned/indented to 2 cm 1
(Note to marker: Ignore if 1., 1 or 1) and type of bullet.)
2.8 Table 1
• Function inserted =AVERAGE(Above) 1
Total for QUESTION 2 [26]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 5 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
QUESTION 3 File name: 3Learners_Leerders Total Q3: 25
• Mark the questions from the formulae and not the values/answers in the cell.
• Check against candidates' actual work (Cell references may differ, depending on the
candidates' response).
• Candidates may use multiple formulae or cells as 'building blocks' to answers.
• Named ranges can be used instead of cell references.
Candidate
No Criteria Max Mark
Mark
Member_Lid worksheet
3.1 Range A1:M1: 1
• Merge and centre applied to text in range A1:M1 1
3.2 Cell G2: 1
• =TODAY() OR NOW() 1
3.3 Cell B3: 2
=COUNTA(B5:B103)
OR =COUNTIF(B5:B103,"*")
• COUNTA/COUNTIF function 1
• Range: (B5:B103) 1
(Note to marker: Accept COUNTA function on columns C,
D, E, F, G, I or L OR COUNT function on columns D, E,
F, G or I.)
3.4 Cell A5: 2
=UPPER(B5)
• UPPER function 1
• Cell (B5) 1
3.5 Print setting: 2
• Print area set to range B4:D103 1
• Print gridlines set to show 1
(Notes to marker:
• Accept if column A has been included.
• Accept if 'Headings – Print' were selected in 'Sheet
Options' and range is B5:D103.)
3.6 Column G: 1
• Format changed to yyyy-mm-dd 1
(Note to marker: Accept if just cell G5 formatted.)
3.7 Cell H5: 3
=CONCATENATE("011",I5) OR ="011"& I5
• CONCATENATE function OR & 1
• "011" 1
• I5 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 6 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
3.8 Cell K5: 4
=IF(J5="","Yes","No")
OR =IF(ISBLANK(J5),"Yes","No")
OR =IF(J5<>"","No","Yes")
OR =IF(COUNTA(J5)=0,"Yes","No")
OR =IF(LEN(J5)=0,"Yes","No")
• Testing if J5 is "blank" 1
• If cellphone is not available: "Yes" 1
• If cellphone is available: "No" 1
• Function copied to cells K6:K103 1
(Note to marker: Accept any suitable variations and if "Y"
and "N" used instead of "Yes" or "No".)
3.9 Cell M5: 7
=MID(L5,FIND("@",L5,1)+1,LEN(L5))
OR =RIGHT(L5,LEN(L5)-FIND("@",L5))
• To determine the position of the '@':
o FIND function 1
o '@' character 1
o In the correct cell: L5 1
• Extracting the domain:
o Function to extract (MID or RIGHT) 1
o Correct cell used to extract from: L5 1
o From after the position of the '@' sign 1
o To the end of the text/domain: LEN(L5), etc. 1
(Note to marker: Check for 'building blocks' in other
columns.)
Dec_Des worksheet
3.10 Extract and copy: 2
• Two members born in the month of December 1
• Copied to the Dec_Des worksheet 1
(Notes to marker:
• 2 members expected (Killian R and Hassim T).
• Accept if not all the information was copied.)
Total for QUESTION 3 [25]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 7 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
QUESTION 4 File name: 4Club_Klub Total Q4: 25
• Mark the questions from the formulae and not the values/answers in the cell.
• Check against candidates' actual work (Cell references may differ, depending on the
candidates' response).
• Candidates may use multiple formulae or cells as 'building blocks' to answers.
• Named ranges can be used instead of cell references.
Candidate
No Criteria Max Mark
Mark
Music_Musiek worksheet
4.1 Column B: 1
• All data is visible in column B 1
4.2 Column G: 1
• Data in column G formatted to 2 decimal places 1
(Note to marker: Accept if only part of the column has
been changed or if formatted as a currency format.)
4.3 Cell F2: 5
=VLOOKUP(A2,Code!$C$2:$D$4,2)
• Lookup value: A2 1
• Table array: Code_Kode!C2:D4 1
• Reference column: 2 or use of LOOKUP function 1
• Absolute cell reference: Code_Kode!C$2:D$4 1
• Copied to remaining cells 1
(Notes to marker:
• Ignore 'True' or 'False'.
• Also accept absolute cell reference $C$2:$D$4.)
4.4 Cell H2: 4
=IF(A2=1,G2*1.2,IF(A2=2,G2*1.25,G2*1.15))
OR
=IF(A2=1,G2+G2*20/100,IF(A2=2,G2+G2*25/100,G2+
G2*15/100))
OR
=IF(A2=1,G2*120/100,IF(A2=2,G2*125/100,
G2*115/100))
OR
=IF(F2="CD",G2*120/100,IF(F2="DVD",G2*125/100,
G2*115/100))
• Nested IF/Function-construct is correctly used 1
1
• Condition CD OR Code 1 and value G2*1.2
1
• Condition DVD OR Code 2 and value G2*1.25
1
• Condition MP3 OR Code 3 and value G2*1.15
(Note to marker: Accept if column F was used with 'MP3',
etc. If the percentage was calculated without the
increase, penalise conditions by one mark.)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 8 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
4.5 Cell L2: 2
=COUNTIF($D$2:$D$612,K2)
• Absolute cell reference D$2:D$612 1
• '1990' replaced with cell reference K2 1
(Note to marker: Accept ($D$2:$D$612) as range.)
4.6 Cell L21: 4
=SUMIF(E2:E612,"POP",G2:G612)
• SUMIF function 1
• Criteria range: (E2:E612) 1
• Criteria: "POP" OR K21 1
• Sum range: (G2:G612) 1
Copy_Kopieer worksheet
4.7 Cell J2: 3
• Expected answer: 101 1
Method J3:
• Removed duplicate owners 2
---------------------------------------------------------------------------------------------------------------
OR
• Sorted, deleted duplicate owners and counted
--------------------------------------------------------------------------
OR
• Sorted owners and counted unique owners
(Notes to marker:
• Accept any other correct method e.g.
=SUMPRODUCT((G2:G636<>"")/COUNTIF(G2:G636,
G2:G636)).
• Allocate all three marks if the correct answer
displays.)
Graph_Grafiek worksheet
4.8 Chart: 5
• Horizontal axis title ('Years') inserted 1
• Horizontal axis labels changed to display years 2000 -
2005 1
• Legend changed to 'Number of songs' 1
• Vertical axis label major unit set to fixed 50 1
• Data labels set (any position) to show values 1
Total for QUESTION 4 [25]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 9 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
QUESTION 5 File name: 5Music_Musiek Total Q5: 42
Candidate
No Criteria Max Mark
Mark
Table: Learners_Leerders
5.1.1 Field: Gender_Geslag 1
• Default value set to 'M' 1
5.1.2 Field: Grade_Graad 1
• Set as required field 1
5.1.3 Field: Class_Klas 3
• Display control: List box/Combo box 1
• Row source type: Value list 1
• Row source: A, B, C, D OR a, b, c, d 1
(Notes to marker:
• Allocate third mark if one option added.
• Also accept if separate table created and used with
rows/source type set to Table/Query.)
5.1.4 Field: DOB_Geboortedatum 2
• Format
Set to Medium Date 1
• Input Mask symbol
Placeholder changed to # via wizard:
00\->L<LL\-00;0;# 1
5.1.5 Field: Cell_Sel 4
• Validation rule: Len ([Cell_Sel]) =10 3
• Validation text: Refers to 10 characters 1
Form: frm5_2
5.2 • Displays all 12 fields from Learners_Leerders table 1 7
• Font colour of the data in the Owner_Eienaar field
appears as reddish 1
• Combo box/List box added in details section 1
• Row source based on Owner_Eienaar field 1
• Row source: SELECT
[Learners_Leerders].[Owner_Eienaar] FROM
Learners_Leerders; 1
• Label 'Find what' added 1
• Horizontal line added to form footer 1
(Notes to marker:
• Mark from Form view.
• Do not allocate fifth mark if selected record does not
display.
• Accept any line inserted anywhere in form footer.)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 10 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
Query: qry5_3
5.3 • Fields displayed: Title_Titel, Artist_Kunstenaar, 4
Year_Jaar and Genre 1
• Year_Jaar criteria: 1996 1
• Genre criteria: 'DANCE' 1
• Title_Titel field sorted ascending 1
(Note to marker: 1 record expected.)
Query: qry5_4
5.4 • Cost_Koste field added 1 5
and format set to any currency 1
• Calculated field added: Inc: [Cost_Koste] 2
* 2 award two marks if *2 is omitted 1
OR Inc: [Cost_Koste]+[Cost_Koste]
Query: qry5_5
5.5 • Total row displayed 1 3
• Grouped by Genre 1
• Cost_Koste field: Total property set to Sum 1
(Note to marker: 3 records for three genres expected.)
Query: qry5_6
5.6 Address_Adres field criteria: Like "13 *Crescent" 3
• 13
• Compulsory space after 13 1
• *Crescent/*Cre* 1
1
(Note to marker: 3 records expected. Accept any
alternative method.)
Report: rpt5_7
5.7 • Report display fields: Artist_Kunstenaar, Title_Titel, 9
Year_Jaar, Cost_Koste and Genre 1
• Report grouped according to Year_Jaar field 1
• Sorted on Artist_Kunstenaar field 1
• Report heading changed to 'Year released' 1
• Function in Year_Jaar footer/header : 1
=SUM([Cost_Koste]) and suitable label added 2
• Function in report footer/header : 1
=MAX([Cost_Koste]) 1
(Note to marker: Do not penalise if label in the report
footer is not given or not suitable.)
Total for QUESTION 5 [42]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 11 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
QUESTION 6 File name: 6Poster_Plakkaat Total Q6: 19
• This question should be marked from the web browser as far as possible unless
otherwise indicated or it cannot be seen in the web browser.
• A maximum of 1 mark will be deducted if one or more closing tags are omitted.
• The code of the candidates that use a word processor will contain additional
unnecessary tags. Markers will need to work through the code to check for the
answers provided below.
Candidate
No Criteria Max Mark
Mark
6.1 Title 1
<head>
<title>'60s Music</title>
</head>
• Title with title tags moved to head section of
web page 1
6.2 Image 2
<img src ="6Sixty_Sestig.jpg"….>
• Tags added for image source 1
• Image 6Sixty_Sestig.jpg named/used correctly 1
6.3 Alignment 1
<h1 align="center">Music</h1>
• 'Music' heading centred 1
6.4 Horizontal line 2
<hr size="3" width = "70%"/>
• Size of horizontal line set to 3 1
• Width of horizontal line set to 70% 1
6.5 Heading style 1
<h2>Before 1963</h2>
• Heading 2 style applied to text 1
6.6 Bold 1
<b>The Beatles</b>
• Bold applied to text 'The Beatles' 1
6.7 Italics 2
<p><i>To mention a few ...</i></p>
• Text 'To mention a few …' appears in italics 1
• In a separate paragraph 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 12 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
6.8 Table 4
<table bgcolor="orange" align="center" border="3">
<tr>
<th>Artist</th>
<th>Hits</th>
</tr>
• Table's background colour changed to orange 1
• Row added at the top of the table 1
• Two cell heading tags added 1
• Cells contain headings 'Artist' and 'Hits' respectively 1
(Notes to marker:
• Allocate last mark if only one heading appears.
• Do not accept <td> instead of <th>.)
6.9 Numbered list 2
<ol>
<li>Surfin' USA</li>
<li>Good Vibrations</li>
</ol>
• The text 'Surfin' USA' and 'Good Vibrations' appear in
a numbered list 1
• Two list tags/items 1
(Note to marker: Allocate mark if only one list item
appears. Accept ordered or unordered list.)
6.10 Link 3
<a href="#Top">Back to top</a>
• Text inserted 'Back to top' 1
• Link created on the text 'Back to top' 1
• Link moves to 'Top' 1
Closing tag(s) or triangular brackets omitted -1
Total for QUESTION 6 [19]
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 13 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
QUESTION 7 Total Q7: 19
File names: 7Form_Vorm, 7Compet_Kompet, 7Sixties_Sestigs, 7Data and
7Answ_Antw.
Candidate
No Criteria Max Mark
Mark
7Form_Vorm
7.1 Document properties 1
• Comment property reads 'CAT Exam' 1
7.2.1 Name: Form field control 1
• Text form field inserted next to text 'Name' 1
7.2.2 Surname: Text form field 1
• Text form field property set to display in uppercase 1
7.2.3 Drop down list 2
• Drop down form field inserted 1
• Options: Beatles, Elvis Presley, The Beach Boys 1
(Note to marker: Accept at least two options to allocate
the second mark.)
7Compet_Kompet, 7Data
7.3 Mail Merge 3
• 7Data used as the data source for the mail merge 1
• Name_Naam and DOB_Geboortedatum fields inserted
in correct positions 1
• Merge completed (7Data) 1
(Note to marker: 99 letters expected.)
7Sixties_Sestigs
7.4 Tables 3
• New table created called 7Comb 1
• Records from both tables combined (33 records) 1
• Records sorted in descending order according to
Name_Naam field 1
(Note to marker: Do not penalise if data in Code_Kode
field has changed.)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Computer Applications Technology/P1 14 DBE/2016
SCE – Memorandum/Marking Guideline
EXAMINATION
NUMBER
• Accept any method that will yield the correct answer.
• One mark for the answer and one mark for the method. If there is only an answer and
no method, allocate two marks if the answer is correct.
7Answ_Antw
7.5.1 Which song charted in both the American and British 2
charts on 1 August 1964?
• A Hard Day's Night 1
Method: 1
• Filter on Date and Year
• Filter search 1964-08-01
• Sort on Date, Year, Chart
7.5.2 How many different or unique titles by Elvis Presley 2
reached the charts? 1
• 9
1
Method:
• Filter on Artist, count only unique values
• Remove duplicate songs, count on Artist
• COUNTIF and count unique values
7.5.3 Which chart featured the most titles? 2
• American (178) 1
Method: 1
• COUNTIF British and American charts and compare
• Filter both and compare total on scroll bar
• Sort and count
7.5.4 Which year featured the most titles on the charts? 2
• 1964 (100) 1
Method: 1
• Filter each and see count on scroll bar
• Filter, copy and count
• COUNTIF
• Sort, select years and see count on scroll bar
• Use SUBTOTAL function
Total for QUESTION 7 [19]
TOTAL 180
Copyright reserved
Study this subject
Recommended for this subject

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

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

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

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

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

Memorandum
Computer Applications Technology Grade 12 P1 2016 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