Computer Applications Technology Grade 12 P1 2018 Memo

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 12 COMPUTER APPLICATIONS TECHNOLOGY P1 NOVEMBER 2018 MARKING GUIDELINES MARKS: 180 CENTRE FINAL MARK NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 36 14 28 22 40 20 20 180 MARKER SM CM IM/EM These marking guidelines consist of 15 pages. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER. QUESTION 1 File name: 1Impression Total Q1: 36 Maximum Candidate No. Criteria Mark Mark 1.1 Font ('Welcome to Impressionism') 1 • Font changed to 'Wide Latin'  1 1.2.1 Justification 1 • First paragraph justified  1 1.2.2 Paragraph spacing 2 • Paragraph spacing after changed (not 12 pt)  1 • Set to 0 pt  1 1.3 Bookmark 2 • Bookmark inserted on text 'history'  1 • Bookmark named 'Monet'  1 1.4 Indents 2 • Left indent set to 2 cm  1 • Right indent set to 2 cm  (15 cm on the ruler) 1 1.5 SmartArt 4 • 'Futurism' shape added  1 • Sub-art form 'Analytical' added to 'Cubism' shape (demoted)  (mark from text pane) 1 • 'Post-Impressionism' shape appears after 'Cubism' shape  1 • Design style changed to any colourful range  1 1.6 Find and Replace 4 • Text 'colours' replaced with symbol:   OR  1 • In a red font  1 • Symbol  correct  1 • 10 (or 11) occurrences  (only if attempted) 1 1.7 'Artistic' style 3 • Font changed to small caps  1 • Border width set to 3 pt  1 • 4 (or 5) instances updated  (only if attempted) 1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER 1.8 Image 6 • Second image's height 5.5 cm  and width 8.2 cm  2 • Second image moved to the right of the first image  1 • Automatic caption added to second image  above  2 • Caption correctly appears above second image  1 1.9 Page layout/columns 4 • Orientation changed to Landscape  of selected text 1 only • Remaining text in Portrait  1 • Text displays in two columns  1 • Column break inserted before 'En Plein Air – The Passing Moment'  1 1.10 Page numbering 5 • Section breaks inserted after text  1 • Automatic page numbering added in footer  1 • Page number format a, b, c, etc.  1 • Page number restarted  at 'a' 1 • Page numbers do not display on previous pages  1 1.11 Table of figures 1 • Automatic table of figures inserted  1 1.12 Index 1 • Index updated  (10 entries) 1 Total for QUESTION 1 [36] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER This page is empty to facilitate accurate marking for side-by-side booklet printout. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 2 File name: 2Vote Total Q2: 14 Maximum Candidate No. Criteria Mark Mark 2.1 Text direction 1 • Text direction changed to 270° (bottom to top) 1 2.2 Footnote 2 • Footnote inserted on text 'works'  1 • 'Impression.org' as footnote text  1 2.3 Bullets 1 • Bullets replaced with 2Pic image  1 2.4 Form fields 5 • 'Name' text form field format set to uppercase  1 • Text 'Current date here' replaced with a text form field (date)  1 • Current date set as data type  1 • Date in the format yy/MM/dd  1 • 'Critic' option added to combo box  1 2.5 Tabs 3 • Left tab set to 4 cm  1 • Right tab set to 11 cm  1 • Tab setting applied  1 2.6 Tables 2 • Two tables merged into one table  (hard return 1 removed) • Shading applied to first row  1 Total for QUESTION 2 [14] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 3 File name: 3Paintings Total Q3: 28 • 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 Impress worksheet 3.1 Cells A1:J1: 2 • Border colour changed to red  1 • Fill colour set to black  1 3.2 Cell G3: 2 =MIN(C9:C120) OR SMALL(C9:C120,1) • MIN function OR SMALL(…,1)  1 • Range: (C9:C120)  1 3.3 Cell G4: 2 =COUNTBLANK(G9:G120) OR COUNTIF(G9:G120,"") • COUNTBLANK/COUNTIF(...,"") function  1 • Range: (G9:G120)  1 3.4 Cell G5: 2 =ROUNDUP(AVERAGE(F9:F120),1) • ROUNDUP  1 • ,1  1 3.5 Cell G6: 5 =SUMIFS(J9:J120,C9:C120,"<1900",I9:I120,"Chicago") OR =SUMIFS(J9:J120,I9:I120,"Chicago",C9:C120,"<1900") • SUMIFS(J9:J120,  1 • Criteria range: C9:C120,  1 • Criteria: "<1900",  1 • Criteria range: I9:I120,  1 • Criteria: "Chicago")  1 (Note to marker: If two SUMIF functions were used, mark only the criteria and criteria range of the first function.) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER 3.6 Conditional formatting: Cells B9:B120 4 • Conditional formatting applied  to cells B9:B120  2 • Unique value rule  1 • Any fill colour applied  1 3.7 Cell D9: 3 =YEAR(TODAY())-C9 OR =YEAR(NOW())-C9 • YEAR function correctly used  1 • TODAY() OR NOW() function  1 • -C9  1 Dupl worksheet 3.8 • Duplicates removed from list  (45 artists remain) 1 1 Chart_Grafiek worksheet 3.9 Chart/Graph 7 • Data from L to P display  (15 locations) 1 • Vertical axis display units displayed in billions  1 • Horizontal axis title displays 'Location'  1 • Any trendline inserted  1 • 'Moving Average' trendline displayed  1 • Legend text as 'Value'  1 • Plot area background set to 3Flowers image  1 Total for QUESTION 3 [28] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 4 File name: 4Famous Total Q4: 22 • 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 Art_Kuns worksheet 4.1 Row 7: Vertical alignment 1 • Text vertically centred  (ignore if horizontal 1 alignment is changed) 4.2 Cell H3: 2 =SUM(K8:K57) • SUM function  1 • Range: K8:K57  1 4.3 Cell H4: CHECK FOR BUILDING BLOCKS 6 =COUNTIF(H8:H57,"<>French")/ COUNTA(H8:H57)*100 OR =(COUNTA(H8:H57)-COUNTIF(H8:H57,"French"))/ (COUNTA(H8:H57))*100 • Count  Non-French artists  Correct range  3 • Division  1 • All artists/records  (accept columns A,B,C,F,G,H,I, 1 for COUNTA and K,L,M for COUNT) • Multiplied by 100 OR Formatted to percentage  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER 4.4 Cell J8: CHECK FOR BUILDING BLOCKS 5 =VLOOKUP(LEFT(I8,1),Code_Kode!$A$2:$B$7,2) OR =VLOOKUP(MID(I8,1,1),Code_Kode!$A$2:$B$7,2) • LEFT OR MID  1 • (I8) OR (I8,1) OR (I8,1,1)  1 • Table array: Code_Kode!A1:B7 OR Code_Kode!A2:B7 OR Code_Kode!$A$1:$B$7 OR Code_Kode!$A$2:$B$7  absolute cell reference  2 OR named range = two marks • Column index number: 2  1 4.5 Cell N8: CHECK FOR BUILDING BLOCKS 8 =IF(L8>=LARGE($L$8:$L$57,3),"Top3","") OR =IF(L8>LARGE($L$8:$L$57,4),"Top3","") OR =IF(LARGE($L$8:$L$57,3)<=L8,"Top3","") OR =IF(L8=LARGE($L$8:$L$57,1),"Top3", IF(L8=LARGE($L$8:$L$57,2),"Top3", IF(L8=LARGE($L$8:$L$57,3),"Top3",""))) OR =IF(OR(L8=LARGE($L$8:$L$57,1),L8= LARGE($L$8:$L$57,2),L8=LARGE($L$8:$L$57,3)), "Top3","") • IF function  1 • Criteria: Check that the 'Votes For' are equal or greater than the third largest value: L8  >=  LARGE(L8:L57 ,3 ) 4 • Correct output if true: "Top3"  1 • Correct output if false: ""  1 • Absolute cell address: $L$8:$L$57  (accept named 1 range) Total for QUESTION 4 [22] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 5 File name: 5ArtWorld Total Q5: 40 Maximum Candidate No. Criteria Mark Mark Table: tblPaintings 5.1.1 Field: Painting 1 • Format set to >  1 5.1.2 Field: YearPainted 4 • Validation rule >=1494  AND  <=1970  3 OR >1493 AND <1971 OR BETWEEN 1494 () AND () 1970 () OR [YearPainted]>=1494 AND [YearPainted]<=1970 • Validation text Appropriate validation text that refers to correct range (for example Any year from 1494 to 1970, inclusive)  1 5.1.3 Field: ID 4 Input mask: "IMP"&099 • IMP OR >imp  1 • & 1 • 0 1 • 99  1 5.1.4 Field: Area 4 • New field added: Area  1 • Data type: Calculated  1 • Expression: [Height]  * [Width]  2 5.1.5 Field: Age 1 • Age field unhidden and displays in Datasheet view 1 Form: frm5_2 5.2 • 5Girl  image displayed in form header  2 6 • Image size mode property set to stretch  1 • Detail background shaded  to any colour  2 • Rating combo box: 'Poor' added to existing items  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER Query: qry5_3 5.3 • Total row: Group By applied  1 3 • Gender criteria: "Male"  1 • NumberOfPaintings: Total: Sum  1 (Note to marker: 11 records expected.) Query: qry5_4 5.4 ID criteria: Like "??????*" OR 4 LEN([ID]) >="6" OR Like "??????" or Like "???????" (1 criteria) OR Like "*##*" (allocate first three marks) • Correct character: ?  (OR LEN([ID])) 1 • 6 characters: ??????  1 • Or more: *  (OR >=) 1 • Place criteria: Is Null  (OR NOT Like "*") 1 (Note to marker: 23 records expected.) Query: qry5_5 5.5 Calculated field and Nationality criteria: 7 Diff: [For]-[Against] • New field Diff:  [For] - [Against] 1 Correct fields  1 Correctly subtracted from each other  (correct order) 1 • Nationality criteria: NOT  (Like "French"  OR  Like "American")  4 (Penalise first mark if brackets are not included) OR <> () "French" () AND () <> "American" () OR NOT "French" AND NOT "American" OR NOT IN ("French","American") (Note to marker: 15 records expected.) Report: rpt5_6 5.6 • Fields inserted: Born and/or Born by Year, 6 BirthCountry, ArtistName, ArtistSurname  1 • Grouping on Born field  1 • Grouping on BirthCountry field  1 • Grouping intervals of Born field set to years  1 • Function: =COUNT(*)  (can be counted on any field) 1 • In BirthCountry group footer/group header  1 Total for QUESTION 5 [40] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 6 File name: 6Quirks 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 Font face 1 <h1 align="center"><font color="IndianRed" face="Vivaldi">Weird Personal Quirks of Historical Artists</font></h1> • Font face set to 'Vivaldi'  1 6.2 Horizontal line 2 <hr width="60%" align="right" color="Crimson"/> • Line width set to 60%  1 • Line aligned right  1 6.3 Heading 2 and italics 2 <h2><i>Believe it or Not!!!</i></h2> • Heading 2 added  1 • Heading 2 in italics  1 6.4 Link to target location 3 <a href="#Weird">ECCENTRICITY</a> • Link on text ECCENTRICITY  1 • Link href added correctly  1 • Target location: #Weird  1 6.5 Ordered list 3 <ol type="A"> <li>Stealing pens</li> <li>Carrying around guns</li> <li>Making time capsules</li> </ol> • Numbered list added  <ol> 1 • Numbered type: 'A' for list  <type="A"> 1 • <li>...</li> tags added to all list items  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 13 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER 6.6 Table 6 <table align="center" bgcolor="Coral" border="4" cellspacing="6" > <tr> <td rowspan="3">Weird Quirks</td> <td>…<td> <td><img src="6Michelangelo.jpg" height="200" width="200"></td> <td>…</td> </tr> <tr align="center"> <td>Dali</td> <td>Michelangelo </td> <td>Picasso </td> </tr> <tr> <td>Stole pens</td> <td>Never bathed</td> <td>Carried a gun</td> </tr> • Cellspacing set to 6  1 • First cell/heading added  and rowspan = 3  2 • Image source tag changed to src  (Michelangelo) 1 • Image extension .jpg added  (Michelangelo) 1 • Third row created with text 'Stole pens', 'Never bathed' and 'Carried a gun'  1 6.7 Closing table tag and bold 2 </table> <p><a name="Weird"> <b>SHOCKING BUT TRUE</b></a></p> • Closing table tag added  1 • Text displays in bold  1 Closing tag(s) and triangular brackets correct and 1 nesting correct (Question: .......................) 1 Total for QUESTION 6 [20] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 14 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 7 Total Q7: 20 File names: 7Lecture, 7LectureMerge, 7ArtForm, 7Summary, 7Timeline Maximum Candidate No. Criteria Mark Mark 7Lecture/7LectureMerge 7.1.1 WordArt 2 • WordArt applied to heading 'Lecture on Impressionism'  1 • Comment removed  1 7.1.2 Track changes 1 • All track changes rejected  ('Love to see you there!!!' 1 should not display at the end of the document) 7.1.3 Mail merge 5 • 7Lecture linked to data source 7Guests  (tblGuests) 1 • Data source: ArtForm criteria 'Painting'  (ArtForm = 1 "Painting") • Data source: NumberOfPaintings criteria > 60  1 (NumberOfPaintings >60) • <<Name>> replaced with Name-field  1 • <<Surname>> replaced with Surname-field  1 7LectureMerge 7.1.4 Merge completed 1 • Mail merge completed  1 (Note to marker: 4 letters expected; Africa, Hageman, Sabelo, Viljoen.) 7ArtForm 7.2 Convert text to columns 2 • Text divided into more than one column  1 • Text appears correctly in 3 columns  1 7Summary 7.3 Subtotal feature 3 • Subtotal feature used  1 • Grouped on: Birth Country_Geboorteland  1 • Function: MAX OR SUBTOTAL (4,...)  on Number of 1 Artworks_Aantal Kunswerke Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 15 DBE/November 2018 NSC – Marking Guidelines EXAMINATION NUMBER 7Timeline 7.4 Cell D5: 6 =IF(B5=B4,IF((C5-C4)=1,"True","False"),"False") OR =IF(B5<>B4,FALSE,IF((C5-C4)=1,"True","False")) OR =IF(AND(B5=B4,(C5-C4)=1),"True","False") OR =IF(B5=B4,IF((C5-1)=C4,"True","False"),"False") OR =AND(B5=B4,(C5-C4)=1) OR =IF(B5=B6,IF((C5-C6)=-1,"True","False"),"False") OR =IF(B5=B4,IF((C5=C4+1),True)) OR =IF(IF(B4=B5,1,0)+(C5-C4)=2,True,False) • Sorted according to artists  and then according to 1 the year completed  1 • Criteria 1: Check that consecutive artist names are equal (for example B5=B4)  1 • Criteria 2: Check if the difference between consecutive years painted of the same artist is equal to 1 (for example C5-C4=1, C5=C4+1)  1 • Correct output ("True") if both criteria are met  1 • Correct output (''False") if either one or both of the criteria is not met  1 (Note to marker: If the candidate sorted descending, check 2 will not be against the previous row but against the next row and the difference between the years will be positive and not negative.) Total for QUESTION 7 [20] TOTAL 180 Copyright reserved