Computer Application Technology P1 May June 2017 Memo Eng hlayiso.com

Downloaded from hlayiso.com SENIOR CERTIFICATE EXAMINATIONS COMPUTER APPLICATIONS TECHNOLOGY P1 2017 MARKING GUIDELINES MARKS: 180 CENTRE FINAL MARK NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 24 23 32 21 39 19 22 180 MARKER SM CM IM/EM These marking guidelines consist of 14 pages. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER. QUESTION 1 File name: 1Cost Total Q1: 24 Maximum Candidate No Criteria Mark Mark 1.1 WordArt 3 • Any text effect reflection applied to WordArt  1 • WordArt text and reflection clearly visible  1 • Text outline of 1.5 pt applied to WordArt  1 1.2 Field 2 • Any field inserted  1 • CreateDate field or 3 November 2016 inserted  1 1.3 Find and Replace 4 • Any 'depreciation' replaced  1 • Formatted to bold  1 and strikethrough effect applied  1 • All occurrences replaced (10 or 11 occurrences)  1 1.4 Columns 2 • Text inserted in two columns  1 • Column break inserted in correct place  1 1.5 Bullets 5 • Level 1 bullet: Image 1Bullet inserted  1 • Level 1 bullet: Text indent set at 1.5 cm  1 • Level 2 numbering inserted in any format 1, 2, 3, …  1 • Level 2 numbering alignment set to 0 cm  1 • Bullets and numbering correctly used and applied as a multilevel list (not 'separate' bullets and numbering)  1 1.6 Table (check all tables) 5 • Row height set to 0.9 cm for all or some rows  1 • Any table style applied (other than Table Grid)  1 • All contents centred vertically  1 • Text  'Total Yearly Running Cost' added as table caption 1 (above or below) starting with 'Table 4 …'  1 1.7 Section break and orientation 2 • Section break inserted  1 • Only orientation of last page(s) changed to landscape (rest of pages remain portrait)  1 1.8 Table of figures 1 • Any automatic table of figures  inserted 1 Total for QUESTION 1 [24] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER QUESTION 2 File name: 2Guide Total Q2: 23 Maximum Candidate No Criteria Mark Mark 2.1 Comment 1 • Comment removed from first page  1 2.2 Cover page 5 • 'Car Front' style applied to the heading 'GUIDELINES TO BUYING A CAR'  1 • 2Cars image inserted as watermark  1 • Washout effect not applied  1 • Section break inserted/Different first page  1 • Watermark appears only on front page  1 2.3 Table of Contents 3 • Format changed to 'Modern'  (Centred, bottom border) 1 • Page numbers do not display  (award only if attempted) 1 • Table of contents updated  ('7. Safety features are 1 important' appears) 2.4 Citation 1 • Citation source name of web page updated with text 'Facts for car buyers'  1 2.5 Indent 2 • Paragraph indentation set at 1.5 cm  1 • Any indentation applied to at least one paragraph  1 2.6 Style: Heading 1 3 • Font size set to 20 pt and font colour set to reddish  1 • Paragraph spacing set to 12 pt after  1 • Changes made to 'Heading 1' style  1 2.7 Footnote 4 • Footnote inserted on text 'emissions'  1 • Footnote appears below text  (check settings) 1 • Footnote symbol '' inserted  1 • Footnote text 'Carbon dioxide' inserted  1 2.8 Hyperlink 2 • Any hyperlink inserted  on text 'So you have made your 1 decision' • Linked to webpage www.cars4you.co.za  1 2.9 Alignment and Hyphenation 2 • Any part of document is justified  (not first paragraph) 1 • Hyphenation set to automatic  (check hyphenation 1 settings and don't only mark by inspection) Total for QUESTION 2 [23] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER 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. Maximum Candidate No Criteria Mark Mark Info worksheet 3.1 Row 1: 1 • Text 'MZANSI CAR SALES' inserted in cell A1  1 3.2 Cell A3: 6 =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 &  1 • LEFT (B3,2)  OR MID(B3,1,2) 2 • RIGHT (F3,3)  OR MID(F3,2,3) 2 • K3  1 3.3 Cell G4: 4 =YEAR(TODAY())-F4 • YEAR  1 • TODAY()  OR NOW() 1 • -F4  1 • Formatted to General/Number (decimal set to zero) to display as Integer  1 3.4 Column J: 3 =UPPER(I3) • =Upper (I3) 1 • Function in cell J3 copied to cells J4:J57  1 Column I: • Column I hidden (not deleted)  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER 3.5 Cell L4: 3 =FIND(" ",K4) OR =SEARCH(" ", K4) • FIND function  1 • Used to determine position of space '' ''  1 • In the correct cell (K4)  1 3.6 Cell M5: 5 =MID(K5,L5+1,LEN(K5)) OR =RIGHT(K5,LEN(K5)-L5) 1 • Function to extract (RIGHT OR MID)  1 • Extracted from correct cell (K5)  • From space +1 character to the last character OR last character to space +1 character  1 • Function to determine length (LEN)  1 • Correct cell length determined (K5)  1 3.7 Cell O6: 4 =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  1 • Condition >= 2014 and the value is 10%*N6  1 • Condition >= 2010 and the value is 20%*N6  1 • Condition <=2009 and the value is 30%*N6  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER 3.8 Cell Q7: 2 =(N7-O7+P7)/60 • (N7-O7+P7) OR (N7+P7-O7) OR (P7+N7-O7)  1 • /60  1 3.9 Cell R8: 4 =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  1 • Lookup range: 'CO2'!A2:B10  1 • Absolute cell reference on the whole range  1 • Correct column: 2  1 Total for QUESTION 3 [32] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER 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. Maximum Candidate No Criteria Mark Mark Types_Tipe worksheet 4.1 Cell J15: 3 =COUNTIF(A3:A57,"Toyota") • COUNTIF function  1 • Range: A3:A57 OR A:A  1 • Criteria: 'Toyota' OR I15 (in the Summary table, NOT in the data)  1 4.2 Cell J18: 3 =LARGE(J3:J16,2) • LARGE function  1 • (J3:J16  1 • 2)  1 4.3 Cell J19: 2 =SUM(J3:J16) OR =COUNTA(A3:A57) (or columns B or C) OR =COUNT(D3:D57) (or columns E or F) • Function  1 • Correct range linked to function  1 4.4 Cell J20: 4 =SUMIF(A3:A57,"VW",F3:F57) • SUMIF function  1 • Criteria range: A3:A57 1 • Criteria: "VW" OR I11 (in the Summary table, NOT in the data)  1 • Sum range: F3:F57 1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER 4.5 Conditional formatting: Cells J3:J16 3 • Conditional formatting applied to cells J13:J16  1 • Criteria applied: cells with unique values  1 • Cells formatted with greenish fill colour  1 Motor worksheet 4.6 Chart/Graph: 6 • Vertical axis title 'Number of cars' added  1 • Chart/Graph title changed to 'Makes Available'  1 • No gaps between columns (Gap width set to 0)  1 • 'Vary colours by point' ticked  1 • Column borders changed to a solid line  (black) 1 • Chart/Graph moved to the Motors worksheet  1 (Note to marker: Search through Motor worksheet.) Total for QUESTION 4 [21] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER QUESTION 5 File name: 5Sales Total Q5: 39 Maximum Candidate No Criteria Mark Mark Table: tbSales 5.1.1 Field: Make 1 • Field size set to 70  1 5.1.2 Field: Type 1 • 'SUV' option added to dropdown field  1 5.1.3 Field: SellDate 3 • Data validation: >=  NOW() OR DATE()  2 • Appropriate validation text added (referring to date on/after current date)  1 5.1.4 Field: Photo 1 • Data type: OLE object/hyperlink  1 5.1.5 Field: RegNumber 4 Input Mask: >LLAa • Capital letters: >  1 • LL – two compulsory letters  1 • A – one compulsory letter or digit  1 • a – one optional letter or digit  1 Query: qry5_2 5.2 • Title field added anywhere in query  1 4 • Surname field moved to before Initials field  1 • Ascending sort on Surname field  1 • Ascending sort on Initials field  1 Query: qry5_3 5.3 Calculated field: Balance: [SellingPrice]-([Deposit]+ 5 [Paid]) • Calculated field Balance added  1 • Calculation: [SellingPrice] -  ([Deposit] + [Paid])  3 OR [SellingPrice] - [Deposit] - [Paid] • Format SellingPrice field to currency  (accept any 1 currency) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER Query: qry5_4 5.4 4 • Manufacturer criteria: "Nissan"  or "Ford"  2 • OR operator  (PurchasePrice criteria on both lines) 1 • PurchasePrice criteria: <= 100000  1 (Note to marker: 10 records expected.) Form: frm5_5 5.5 • Image 5Old.jpg in the form header  1 8 • Colour field added to form  1 • Popular checkbox default value set to No/False/0  1 • Function: =[PurchasePrice] +  2 [PurchasePrice]  *  0.1  3 OR Function: =[PurchasePrice] * 1.1 OR * 110/100 OR * 11/10 Report: rpt5_6 5.6 • Orientation changed to landscape  1 8 • Second grouping added on Year field  1 • =Count([PurchasePrice]) changed to =Sum([PurchasePrice])  1 • Format changed to currency  1 • =Year(Date()) changed to =Month(Date())  1 • =AVG  ([PurchasePrice])  2 in Manufacturers group footer/header  1 Total for QUESTION 5 [39] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER 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. Maximum Candidate No Criteria Mark Mark 6.1 Heading 1 font type 2 <h1><font face="Tahoma" size="24">Unsafe Driving in the Cellphone Era</font></h1> • Font changed to Tahoma  1 • Font size correctly set to 24  1 6.2 Horizontal line 1 <hr/> • Horizontal line inserted  1 6.3 Picture and border 2 <p align="center"><img src="6Drive.jpg" border="5"></p> OR <center>"><img src="6Drive.jpg" border="5"></center> • Picture aligned to centred  1 • Border around picture 5 pt  1 6.4 Heading 1 <h2>Driver Behaviour: Distracted While Driving.</h2> • Text 'Driver Behaviour: Distracted While Driving.' appears as heading 2  1 6.5 Hyperlink to anchor 3 <a href="#Distraction">driver distraction</a> • Link tags correctly inserted  1 • On words 'driver distraction'  1 • Correct anchor name  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER 6.6 Bulleted list 2 <ul> <li>Handling the phone: dialling, answering, text messaging, etc.</li> <li>The conversation introduced to the environment.</li> </ul> • Unordered list <ul> created  1 • List items added  1 6.7.1 Table 3 <Table border="5" bgcolor="lightblue" cellpadding="3" width="80%"> • Table background colour changed to 'lightblue'  1 • Cellpadding set to 3  1 • Table width set to 80%  1 6.7.2 <tr height="80" valign="bottom"> 3 <th><i>ACTION</i></th> • Row height set to 80  1 • Vertical alignment set to bottom  1 • Tags added to display 'Action' in italic  (accept em) 1 6.7.3 <td>14%</td> 1 • Data '14%' added to fourth row, third column  1 6.7.4 <td align="center" colspan="3"><b>BE ALERT!!! 1 </b></td> • Cells in the last row merged  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/2017 SCE – Marking Guidelines EXAMINATION NUMBER QUESTION 7 Total Q7: 22 File names: 7Statem, 7Acc, 7Chart, 7Buy, 7Answ Maximum Candidate No Criteria Mark Mark 7Statem 7.1 Linking data source 2 • 7Statem linked to tbClients table  1 • of 7Acc database  1 7.2 Insert fields from data source 1 • Text '<Insert Initials>' replaced by Initials field and/or text '<Insert Surname>' replaced by Surname field  1 (accept if only one field inserted) 7.3 Form Controls 6 • Date form control:  Form control: Text form control/Date Picker form control  1  Data type: Date  1 • 'Amount Due' form control:  Data type: Number  1  Number format: Currency with two decimal places/ R###0.00;(R###0.0) OR R#.##0.00;(R#.##0.00)  • Dropdown form field: 1  Dropdown form control field added   At least one option added: 'Up to date'/'Behind'  1 1 7Chart 7.4 Insert graph/chart data 6 • Column chart inserted  1 • Interval of y-axis set to 10000  1 • Only data for 2014 appear  1 • Major units on x-axis fixed to 3 Months  1 • Legend displays correct text 'Cars sold'  1 • Data labels added  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 14 DBE/2017 SCE – Marking Guidelines EXAMINATION NUMBER • 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 2 name? • 10  1 Method: • Filter city : contains "Wood"  1 OR • Criteria on city: Like "*Wood*" 7.5.2 How many records contain buyers with two initials only? 2 • 113  1 Method: • Use a query with a criteria on initials: Like "??" OR LEN([Initials])=2  1 OR • Use an advanced filter field: LEN([Initials]) criteria = 2 7.5.3 What is the average price paid by all car buyers from 3 Durban? • 125350.125 OR 125350.13 OR 125350  1 Method: • City field criteria: Durban 1 • Price field: Group by Avg  1 OR • Filter on City field. Insert a Total and calculate Average OR • Filter table on City field. Copy to spreadsheet and use Average function Total for QUESTION 7 [22] TOTAL 180 Copyright reserved