Computer Applications Technology P1 May June 2019 Memo hlayiso.com

Downloaded from hlayiso.com SENIOR CERTIFICATE EXAMINATIONS/ NATIONAL SENIOR CERTIFICATE EXAMINATIONS COMPUTER APPLICATIONS TECHNOLOGY P1 2019 MARKING GUIDELINES MARKS: 180 FINAL MARK CENTRE NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 30 20 30 21 40 20 19 180 MARKER SM CM IM/EM These marking guidelines consist of 13 pages. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER. QUESTION 1 File name: 1Street Total Q1: 30 Maximum Candidate No. Criteria Mark Mark 1.1.1 Title content control 1  Text 'Street' added to 'Title' content control  1 1.1.2 Font size 1  Font size of the 'A' changed to 200 pt  1 1.1.3 Table borders 2  Inside borders only  1  In a red colour  1 1.1.4 Picture (3rd row, 1st cell) 1  Centred vertically  1 1.2 Table of contents 2  Style of 'http://www.widewalls.ch/defining-street-art/' changed to anything besides 'Heading 1'  1  Table of contents updated  (includes 'The Origins of 1 Street Art') 1.3 Margin 2  Bottom margin changed to 2 cm  1  From page 3 onwards  1 1.4.1 Line spacing 2  At least  1  20 pt  1 1.4.2 Indentation 2  Left indent set to 1 cm  1  Right indent set to 3 cm  (14 cm on the ruler) 1 1.5 Find and replace 3  's replaced  1  with s  1  Only years changed  (all 4 occurrences should be 1 replaced) 1.6 Bookmark 2  Some bookmark text formatted  (location of the 1 bookmark)  All text highlighted  ('It began with graffiti') 1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER 1.7 Caption 3  New caption label 'Art' created  (Accept if more text 1 appears)  Caption 'Vhils process' inserted  (Do not allocate 1 mark if 'Vhils process' appears as part of label)  Appears above image  1 1.8 Bullets 2  Bullets inserted  1  '' Wingdings 2, character code 147  1 1.9 Table of figures 2  Automatic table of figures inserted on the last page  1  Display 'Figure' entries  (7 or 8 entries) 1 1.10 References  'Banksy, J.R.; Just Google it' source removed 1.11 Bibliography 1  Automatic bibliography inserted on the last page  1 1.12 Page numbering 4  Automatic page numbers inserted in footer  1  Any Mosaic page numbering style used  1  Odd and even checked  1  Consistent page numbering style applied to both odd (left) and even (right) pages  1 Total for QUESTION 1 [30] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 2 File names: 2Donations, 2Merged Total Q2: 20 Maximum Candidate No. Criteria Mark Mark 2.1 Spelling (In paragraph 1) 1  Spelling error corrected  (intressting) 1 2.2 Date form control 2  Control type changed to current date  (Accept 1 current time if a date is displayed)  Format set to 'dd MMMM yyyy'  1 2.3 Columns 2  Text converted to four columns (Check ruler) 1  Column break inserted before '4. Help others in need'  (Accept with/without an open line above) 1 2.4 Endnote 4  Endnote inserted next to 'Utopia' 1  Capital Roman numerals used  1  Text 'Perfect world'  1  Added to the end of the section  1 2.5.1 Table style 1  Any table style applied  (Besides Table Grid) 1 2.5.2 Check box form field 2  Any form field/control inserted  1  Check box form field inserted  1 2.5.3 Help text for textbox form field 2  Help text inserted 'Enter amount'  1  On F1 key  1 2.5.4 Formula =SUM(Above) 2  Field inserted  1  Field formula: =SUM(Above)  1 2.6 Mail merge 4 (Select * FROM 'Donors$' WHERE 'Amount' >=50000)  Merge fields Name and/or Surname inserted  1  Data source filtered/selected >=50 000  1 (Amount >= 50 000)  Roland Lewis removed from recipient list  (Check for 1 13 letters after merge completed)  Mail merge completed  (2Merged) 1 Total for QUESTION 2 [20] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 3 File name: 3Comp Total Q3: 30  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.  Any function that works consistently for the data should be accepted. Maximum Candidate No. Criteria Mark Mark Entries_Inskrywing worksheet 3.1 Heading 2  Cells A1:M1 merged  1  Data vertically centred  (Ignore if horizontally 1 centred) 3.2 Cells A1:M1 2  Blue colour  1  Pattern fill  1 3.3 Autofill 1  Numbering continues to rest of column A  (Do not 1 allocate the mark if the column is partly filled) 3.4 Cell D3: (Check for building blocks) 5 =RIGHT(B3,LEN(B3)-LEN(C3)-1) OR =MID(B3,FIND(" ",B3)+1,LEN(B3)) OR =RIGHT(B3,LEN(B3)-FIND(" ",B3)) OR =MID(B3,LEN(C3)+2,LEN(B3)-LEN(C3))  RIGHT/MID function  1  B3  1  Determine length of text in B3  1  Determine position of space  (FIND OR SEARCH) 1  Subtract position for space from length  1 (Note to marker: Ignore if there is a 3rd parameter in the FIND function.) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER 3.5 Cell F4: 5 =A4&E4&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)  & OR CONCATENATE function  1  A4  1  E4  1  RANDBETWEEN functions  1  (0,9) OR (1,9)  1 (Note to marker: Also accept correct use of the RAND function e.g. =A4&E4&RIGHT(RAND(),2).) 3.6 Cell G5: 5 =VLOOKUP(E5,Province_Provinsie!$A$2:$B$10,2)  VLOOKUP function  1  Lookup value: E5  1  Lookup range: Province_Provinsie!$A$2:$B$10 OR Province_Provinsie!$A$1:$B$10 (Check for Named Range) 1  Column index: 2  1  Absolute cell reference  1 3.7 Cell M3: 3 =AVERAGE(J3:L3)  AVERAGE function  1  (J3:L3)  1  Formatted to no decimal places  1 3.8 Cell P2: 4 =DATE(YEAR(P1),MONTH(P1)+1,DAY(P1))  YEAR(P1)  1  MONTH(P1)  + 1  (Allocate second mark if 31 has 2 been added to DAY)  DAY(P1)  1 Subtotal worksheet 3.9 Subtotal: 3  Change in/Grouped by: Category_Kategorie  1  Function: MAX  1  Subtotal added to Total score_Totale punte  1 Total for QUESTION 3 [30] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 4 File name: 4Entries 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 answers.  Named ranges can be used instead of cell references.  Any function that works consistently for the data should be accepted. Maximum Candidate No. Criteria Mark Mark Provinces_Provinsies worksheet 4.1 Chart_Grafiek tab: 1  Tab colour changed to yellow  1 4.2 Chart_Grafiek tab: 1  Chart_Grafiek worksheet moved to after Provinces_Provinsies  1 4.3 Cell M7 (Check in other cells): 3 =COUNTIF(C3:C188,"LP")  COUNTIF function  1  Range C3:C188  1  "LP"  1 4.4 Sort: Cells L3:M11 2  Sorted on column L  1  Descending  1 4.5 Conditional formatting: Column E 2  All duplicate values  1  Any background colour  1 4.6 Cell J3: (Check for building blocks) 7 =IF(I3=MAX($I$3:$I$188),A3,"")  IF function  1  Criteria: I3  1  =MAX  1  ($I$3:$I$188) OR (I3:I188)  (MAX(I3:I188) could be 1 a building block)  Correct use of absolute cell reference  1  Value if true: A3  1  Copied down  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER Chart_Grafiek worksheet 4.7 Chart/Graph: 5  Chart/graph changed to a bar chart  1  NW data does not display  (Do not accept if data 1 removed from spreadsheet)  Any glow applied to data series  (Do not accept 1 shadow. Mark from the panel)  Gap width of series changed to 50%  1  Colour of major vertical gridlines changed to red  1 Total for QUESTION 4 [21] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 5 File name: 5Gallery Total Q5: 40 Maximum Candidate No Criteria Mark Mark Table: tblExhibit 5.1.1 Field: City 1  Field size set to 50  1 5.1.2 Field: GalleryName 1  Field format changed to >  1 5.1.3 Field: PostCode 3  Data type changed to Short Text/Text  1 Input mask: 0000  0 character used  1  Four of the same characters inserted  1 OR  Validation Rule added ()  LEN([PostCode]) ()  =4 () (Do not allocate this mark if the data type is not Number) 5.1.4 Field: Insure 5  New field Insure inserted  1  Field type Calculated  1  [TotalValue]  *  1.25  3 OR ([TotalValue]*25/100)+[TotalValue] OR ([TotalValue]*0.25)+[TotalValue] OR ([TotalValue]*125/100) Form: frm5_2 5.2  Form named frm5_2  created 1 8  Form based on qry5_2  1  All fields included  (5 fields) 1  Form heading changed to 'Street Art'  1  5Street  image added as form background  2  Data sorted ascending  according to GalleryName  2 (Check Form Properties, Data, Order by OR check sorting in qry5_2 query) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER Query: qry5_3 5.3  Province: Group By applied   1 3  Province criteria:<>"0"  OR Not Is Null OR Is Not 1 Null OR <>"" OR "EC" OR "GP" OR "KZN" OR "WC"  StockValue: Total: Sum  1  (Note to marker: 4 records expected.) Query: qry5_4 5.4  Only GalleryName and NoInStock fields appear  1 7 (Allocate the mark even if other fields are deleted)  GalleryName criteria: *  gallery  *  3  TypeOfArt criteria: "Street Art"  1  Province criteria: Is Null  OR Not Like "*" 1 OR Not Like '*'  All inserted criteria on the same line AND  1 (Note to marker: 5 records expected.) Query: qry5_5 5.5 Calculated field: 8 End: [Date]+30  New field End created  1  [Date]  + 30  2  NoInStock criteria: >  150  2  Town criteria: "Johannesburg"  1  Date criteria: Year([Date])=2019 OR >=#01/01/2019# AND <=#31/12/2019# OR >#31/12/2018# AND <#01/01/2020# OR BETWEEN #01/01/2019# AND <=#31/12/2019# OR Like "2019/*/*" (dependent on computer settings) o Correct year  (2019) 1 o Limited to full year  1 (Note to marker: 6 records expected.) Report: rpt5_6 5.6  Province field grouping removed  1 4  Province textbox and label removed  1  Function: =AVG  ([StockValue])  2 Total for QUESTION 5 [40] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 6 File name: 6Famous Total Q6: 20  This question should be marked from the HTML code.  Numerical attribute values do not need to be in inverted commas. Maximum Candidate No. Criteria Mark Mark 6.1 Title 1 <title>Famous Street Art</title>  Title tags inserted  (Accept if the <head> tags still 1 appear OR if <head> tags have been replaced) 6.2 Cell padding 2 <table border="1" cellpadding="8" bgcolor="PaleGoldenrod">  Cell padding of entire table set  1  To 8  1 6.3 Alignment of picture 1 <img src="6_Art.png" width="100" height="100" align="right">  6_Art picture aligned to right  1 6.4 Font 1 <font face="Calibri"><h1>Street Art</h1></font>  Font of heading 'Street Art' set to Calibri  1 6.5 Picture size 2 <img src="6_5.jpg" width="195" height="145">  Width set to 195  1  Height set to 145  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER 6.6 Fourth row of table 7 <tr align="center"> <td><img src="6_3.jpg" width="200" height="200"></td> <td colspan="3"><font size="5"><i>3. Glasses in Russia</i></font> <p align="left">This photo went viral and appeared on plenty of media sites who marvelled at the 3D look that brought a simple pair of glasses to life.</p></td> </tr>  One row inserted and centred  1  Two cells inserted  1  'Colspan' of second cell set to 3  1  Text in second cell set to italics  1  Font size of second cell set to 5  1  Paragraph OR 2 breaks inserted  1  Left aligned  1 6.7 Bullets 2 <ul><li>#Banksy</li> <li>#List</li> <li>#Most Famous Pieces</li> <li>#Smates</li> <li>#Streetart</li></ul>  Unordered list tags (bullets) inserted  1  5 list items tags inserted  1 6.8 Hyperlink 3 <a href="Google.com">Read more</a>  Hyperlink tags inserted  1  To correct text 'Read more'  1  Links to "Google.com"  1 Closing tag(s) or triangular brackets and nesting 1 correctly applied. 1 Total for QUESTION 6 [20] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 13 DBE/2019 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 7 File names: 7Logo, 7Globe, 7Art Total Q7: 19 Maximum Candidate No. Criteria Mark Mark 7Logo 7.1 Image manipulation 7  Wrapping of images changed to enable stacking  1  Heart image style/shape changed to round shape  1  'I Want Change' image cropped/resized  1  Text 'STREET ART' inserted  (Accept lower case) 1  Text colour is light  1  Original images arranged in the correct order  1  Logo appears correctly as the example  1 7Globe 7.2.1 Text watermark 2  Text watermark inserted  1  Text 'Graffiti'  1 7.2.2 Sorting paragraphs 2  Paragraphs sorted  1  In descending order  (Toronto ... Atlanta) 1 7.2.3 Text inserted 2  Text from 7Europe.html file inserted  1  Linked to original document  1 7Art 7.3.1 Cell G3: 5 =IF(E3<=$I$2,IF(F3>100,TRUE,""),"") OR =AND(E3<=$I$2,F3>100)  Check if E3  smaller than or equal to date in $I$2  2 (Accept NOW() OR TODAY())  Check if F3  greater than 100  2  Display TRUE if both conditions are true  1 7.3.2 Correct answer: 1  WC OR Western Cape 1 Total for QUESTION 7 [19] TOTAL 180 Copyright reserved