COMPUTER APPLICATIONS TECHNOLOGY PAPER 1
GRADE 12
MEMORANDUM
SENIOR CERTIFICATE EXAMINATIONS
MAY/JUNE2017

IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER.
QUESTION 1 File name: 1Cost Total Q1: 24
1.1 WordArt

• Any text effect reflection applied to WordArt ✓
• WordArt text and reflection clearly visible ✓
• Text outline of 1.5 pt applied to WordArt ✓ (3)

1.2 Field

• Any field inserted ✓
• CreateDate field or 3 November 2016 inserted ✓ (2)

1.3 Find and Replace

• Any 'depreciation' replaced ✓
• Formatted to bold ✓ and strikethrough effect applied ✓
• All occurrences replaced (10 or 11 occurrences) ✓(4)

1.4 Columns

• Text inserted in two columns ✓
• Column break inserted in correct place ✓ (2)

1.5 Bullets

• Level 1 bullet: Image 1Bullet inserted ✓
• Level 1 bullet: Text indent set at 1.5 cm✓
• Level 2 numbering inserted in any format 1, 2, 3, … ✓
• Level 2 numbering alignment set to 0 cm ✓
• Bullets and numbering correctly used and applied as a multilevel list (not 'separate' bullets and numbering) ✓ (5)

1.6 Table (check all tables)

• Row height set to 0.9 cm for all or some rows ✓
• Any table style applied (other than Table Grid) ✓
• All contents centred vertically ✓
• Text ✓ 'Total Yearly Running Cost' added as table caption (above or below) starting with 'Table 4 …' ✓(5)

1.7 Section break and orientation

• Section break inserted ✓
• Only orientation of last page(s) changed to landscape (rest of pages remain portrait) ✓(2)

1.8 Table of figures
Any automatic table of figures ✓ inserted(1)
[24]

QUESTION 2 File name: 2Guide Total Q2: 23
2.1 Comment
Comment removed from first page ✓(1)
2.2 Cover page

• 'Car Front' style applied to the heading 'GUIDELINES TO BUYING A CAR' ✓
• 2Cars image inserted as watermark ✓
• Washout effect not applied ✓
• Section break inserted/Different first page ✓
• Watermark appears only on front page ✓(5)

2.3 Table of Contents

• Format changed to 'Modern' ✓ (Centred, bottom border)
• Page numbers do not display✓ (award only if attempted)
• Table of contents updated ✓ ('7. Safety features are important' appears) (3)

2.4 Citation
Citation source name of web page updated with text 'Facts for car buyers' ✓(1)
2.5 Indent

• Paragraph indentation set at 1.5 cm ✓
• Any indentation applied to at least one paragraph ✓(2)

2.6 Style: Heading 1

• Font size set to 20 pt and font colour set to reddish ✓
• Paragraph spacing set to 12 pt after ✓
• Changes made to 'Heading 1' style ✓ (3)

2.7 Footnote

• Footnote inserted on text 'emissions' ✓
• Footnote appears below text ✓ (check settings)
• Footnote symbol inserted ✓
• Footnote text 'Carbon dioxide' inserted ✓(4)

2.8 Hyperlink

• Any hyperlink inserted ✓ on text 'So you have made your decision'
• Linked to webpage www.cars4you.co.za ✓(2)

2.9 Alignment and Hyphenation

• Any part of document is justified ✓ (not first paragraph)
• Hyphenation set to automatic ✓ (check hyphenation settings and don't only mark by inspection)(2)

[23]

QUESTION 3 File name: 3Car Total Q3: 32

• 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.

3.1 Row 1:
Text 'MZANSI CAR SALES' inserted in cell A1 ✓(1_
3.2 Cell A3:
=CONCATENATE(LEFT(B3,2), RIGHT(F3,3), K3)
OR
=LEFT(B3,2) & RIGHT(F3,3) & K3
OR
=MID(B3,1,2) & MID(F3,2,3) & K3

• CONCATENATE function OR & ✓
• LEFT✓ (B3,2) ✓ OR MID(B3,1,2)
• RIGHT✓ (F3,3) ✓ OR MID(F3,2,3)
• K3 ✓ (6)

3.3 Cell G4:
=YEAR(TODAY())-F4

• YEAR ✓
• TODAY() ✓ OR NOW()
• -F4 ✓
• Formatted to General/Number (decimal set to zero) to display as Integer ✓(4)

3.4 Column J:
=UPPER(I3)

• =Upper ✓(I3)
• Function in cell J3 copied to cells J4:J57 ✓
• Column I:
• Column I hidden (not deleted) ✓(3)

3.5 Cell L4:
=FIND(" ",K4) OR =SEARCH(" ", K4)

• FIND function ✓
• Used to determine position of space '' '' ✓
• In the correct cell (K4) ✓(3)

3.6 Cell M5:
=MID(K5,L5+1,LEN(K5))
OR
=RIGHT(K5,LEN(K5)-L5)

• Function to extract (RIGHT OR MID) ✓
• Extracted from correct cell (K5) ✓
• From space +1 character to the last character OR last character to space +1 character ✓
• Function to determine length (LEN) ✓
• Correct cell length determined (K5) ✓(5)

3.7 Cell O6:
=IF(F6>=2014,N6*10%,IF(F6>=2010,N6*20%,N6*30%))
OR
=IF(F6>=2014,N6*10%,IF(F6<=2009,N6*30%,N6*20%))
OR
=IF(F6<=2009,N6*30%,IF(F6>=2014,N6*10%,N6*20%))
OR
=IF(F6<=2009,N6*30%,IF(F6<=2013,N6*20%,N6*10%))
OR
=IF(F6>=2014,0.1*N6,IF(F6<=2009,0.3*N6,0.2*N6))
OR
=IF(F6>=2014,N6*10%,IF(AND(F6>=2010,F6<=2013),N6*20%,N6*30%))

• Nested IF syntax is correctly used ✓
• Condition >= 2014 and the value is 10%*N6 ✓
• Condition >= 2010 and the value is 20%*N6 ✓
• Condition <=2009 and the value is 30%*N6 ✓(4)

3.8 Cell Q7:
=(N7-O7+P7)/60

• (N7-O7+P7) OR (N7+P7-O7) OR (P7+N7-O7) ✓
• /60 ✓(2)

3.9 Cell R8:
=VLOOKUP(E8,'CO2'!$A$2:$B$10,2)
OR
=VLOOKUP(E8,'CO2'!$A$3:$B$10,2)
OR
=VLOOKUP(E8,'CO2'!A$2:B$10,2)

• Lookup value: E8 ✓
• Lookup range: 'CO2'!A2:B10 ✓
• Absolute cell reference on the whole range ✓
• Correct column: 2 ✓(4)

[32]

QUESTION 4 File name: 4Show Total Q4: 21

• 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.

4.1 Cell J15:
=COUNTIF(A3:A57,"Toyota")

• COUNTIF function ✓
• Range: A3:A57 OR A:A ✓
• Criteria: 'Toyota' OR I15 (in the Summary table, NOT in the data) ✓(3)

4.2 Cell J18:
=LARGE(J3:J16,2)

• LARGE function ✓
• (J3:J16 ✓
• 2) ✓(3)

4.3 Cell J19:
=SUM(J3:J16)
OR
=COUNTA(A3:A57) (or columns B or C)
OR
=COUNT(D3:D57) (or columns E or F)

• Function ✓
• Correct range linked to function ✓(2)

4.4 Cell J20:
=SUMIF(A3:A57,"VW",F3:F57)

• SUMIF function ✓
• Criteria range: A3:A57✓
• Criteria: "VW" OR I11 (in the Summary table, NOT in the data) ✓
• Sum range: F3:F57✓(4)

4.5 Conditional formatting: Cells J3:J16

• Conditional formatting applied to cells J13:J16 ✓
• Criteria applied: cells with unique values ✓
• Cells formatted with greenish fill colour ✓ (3)

Motor worksheet
4.6 Chart/Graph:

• Vertical axis title 'Number of cars' added ✓
• Chart/Graph title changed to 'Makes Available' ✓
• No gaps between columns (Gap width set to 0)✓
• 'Vary colours by point' ticked ✓
• Column borders changed to a solid line ✓ (black)
• Chart/Graph moved to the Motors worksheet 
  (Note to marker: Search through Motor worksheet.)(6)

[21]

QUESTION 5 File name: 5Sales Total Q5: 39
5.1.1 Field: Make
Field size set to 70 ✓(1)
5.1.2 Field: Type
'SUV' option added to dropdown field ✓(1)
5.1.3 Field: SellDate

• Data validation: >= ✓ NOW() OR DATE() ✓
• Appropriate validation text added (referring to date on/after current date) ✓(3)

5.1.4 Field: Photo
Data type: OLE object/hyperlink ✓(1)
5.1.5 Field: RegNumber
Input Mask: >LLAa

• Capital letters: > ✓
• LL – two compulsory letters ✓
• A – one compulsory letter or digit ✓
• a – one optional letter or digit ✓(4)

Query: qry5_2
5.2

• Title field added anywhere in query ✓
• Surname field moved to before Initials field ✓
• Ascending sort on Surname field ✓
• Ascending sort on Initials field ✓(4)

Query: qry5_3
5.3 Calculated field: Balance: [SellingPrice]-([Deposit]+ [Paid])

• Calculated field Balance added ✓
• Calculation: [SellingPrice] - ✓ ([Deposit] ✓+ [Paid]) ✓ OR
  [SellingPrice] - [Deposit] - [Paid]
• Format SellingPrice field to currency ✓ (accept any currency) (5)

Query: qry5_4
5.4

• Manufacturer criteria: "Nissan" ✓ or "Ford" ✓
• OR operator ✓ (PurchasePrice criteria on both lines)
• PurchasePrice criteria: <= 100000 ✓
  (Note to marker: 10 records expected.)(4)

Form: frm5_5
5.5

• Image 5Old.jpg in the form header ✓
• Colour field added to form ✓
• Popular checkbox default value set to No/False/0 ✓
• Function: =[PurchasePrice] ✓+ ✓ [PurchasePrice] ✓ * ✓ 0.1 ✓ OR
  Function: =[PurchasePrice] * 1.1 OR * 110/100 OR * 11/10(8)

Report: rpt5_6
5.6

• Orientation changed to landscape ✓
• Second grouping added on Year field ✓
• =Count([PurchasePrice]) changed to =Sum([PurchasePrice]) ✓
• Format changed to currency ✓
• =Year(Date()) changed to =Month(Date()) ✓
• =AVG ✓ ([PurchasePrice]) ✓ in Manufacturers group footer/header ✓(8)

[39]

QUESTION 6 File name: 6Beware 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.

6.1 Heading 1 font type
<h1><font face="Tahoma" size="24">Unsafe Driving in the Cellphone Era</font></h1>

• Font changed to Tahoma ✓
• Font size correctly set to 24 ✓(2)

6.2 Horizontal line
<hr/>

• Horizontal line inserted ✓(1)

6.3 Picture and border
<p align="center"><img src="/6Drive.jpg" border="5"></p>
OR
<center>"><img src="/6Drive.jpg" border="5"></center>

• Picture aligned to centred ✓
• Border around picture 5 pt ✓(2)

6.4 Heading
<h2>Driver Behaviour: Distracted While Driving.</h2>
Text 'Driver Behaviour: Distracted While Driving.' appears as heading 2 (1)
6.5
Hyperlink to anchor
<a href="#Distraction">driver distraction</a>

• Link tags correctly inserted ✓
• On words 'driver distraction' ✓
• Correct anchor name ✓()3

6.6 Bulleted list
<ul>
<li>Handling the phone: dialling, answering, text messaging, etc.</li>
<li>The conversation introduced to the environment.</li>
</ul>

• Unordered list <ul> created ✓
• List items added ✓(2)

6.7.1 Table
<Table border="5" bgcolor="lightblue" cellpadding="3" width="80%">

• Table background colour changed to 'lightblue' ✓
• Cellpadding set to 3 ✓
• Table width set to 80% ✓(3)

6.7.2 <tr height="80" valign="bottom">
<th><i>ACTION</i></th>

• Row height set to 80 ✓
• Vertical alignment set to bottom ✓
• Tags added to display 'Action' in italic ✓ (accept em)(3)

6.7.3 <td>14%</td>
Data '14%' added to fourth row, third column ✓(1)
6.7.4 <td align="center" colspan="3"><b>BE ALERT!!! </b></td>
Cells in the last row merged ✓(1)
Closing tag(s) or triangular brackets omitted -1
[19]

QUESTION 7 Total Q7: 22 File names: 7Statem, 7Acc, 7Chart, 7Buy, 7Answ
7.1 Linking data source

• 7Statem linked to tbClients table ✓
• of 7Acc database✓(2)

7.2 Insert fields from data source

• Text '<Insert Initials>' replaced by Initials field and/or text '<Insert Surname>' replaced by Surname field ✓
  (accept if only one field inserted)(1)

7.3 Form Controls

• Date form control:
  
  • Form control: Text form control/Date Picker form control ✓
  • Data type: Date ✓
• 'Amount Due' form control:
  
  • Data type: Number ✓
  • Number format: Currency with two decimal places/ R###0.00;(R###0.0) OR R#.##0.00;(R#.##0.00) ✓
• Dropdown form field:
  
  • Dropdown form control field added ✓
  • At least one option added: 'Up to date'/'Behind' ✓(6)

7Chart
7.4 Insert graph/chart data

• Column chart inserted ✓
• Interval of y-axis set to 10000 ✓
• Only data for 2014 appear ✓
• Major units on x-axis fixed to 3 Months ✓
• Legend displays correct text 'Cars sold' ✓
• Data labels added ✓ (6)
• Accept any method that will yield the correct answer.
• Allocate full marks if the answer is correct. One mark for the answer and one/two mark/s for the method. If the answer is incorrect check the method and allocate one/two mark/s for the correct method.

7Answ_Antw
7.5.1 How many records contain the text 'wood' in the city name?

• 10 ✓
  Method:
• Filter city : contains "Wood" ✓
  OR
• Criteria on city: Like "*Wood*"(2)

7.5.2 How many records contain buyers with two initials only?

• 113 ✓
  Method:
• Use a query with a criteria on initials:
  Like "??" OR LEN([Initials])=2 ✓
  OR
• Use an advanced filter field:
  LEN([Initials]) criteria = 2(2)

7.5.3 What is the average price paid by all car buyers from Durban?

• 125350.125 OR 125350.13 OR 125350 ✓
  Method:
• City field criteria: Durban✓
• Price field: Group by Avg ✓
  OR
• Filter on City field. Insert a Total and calculate Average
  OR
• Filter table on City field. Copy to spreadsheet and use Average function(3)

[22]

TOTAL: 180