Computer Applications Technology Grade 11 P1 2014 Memo

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 11 NOVEMBER 2014 COMPUTER APPLICATIONS TECHNOLOGY P1 MEMORANDUM NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 Q7 MARKS: 180 35 15 28 22 40 20 20 This memorandum consists of 13 pages.

Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2014) QUESTION 1 No. Criteria Max.  Mark 1.1 Right Aligned,  Change to Italics. Traffic Accident Investigation in South Africa, disturbing 2 facts. 1.2 Heading 1 colour changed to red  Main heading formatted with modified Heading 1 style  3 All subheadings formatted with Heading 2 style  1.3 Report Reference added:  In the correct position   Author: Volminck,S,D, Nathan   Title: News Updater   Year: 2013  7  City: Pretoria   Publisher: Daily News  1.4 3pt page border  around the document.  2 1.5  Caption “Vehicle Types “added correct  Above the diagram on page 1  (This diagram will now 3 be on page 2 because of the page break.)  Numbering format changed to A 1.6 Border around paragraph removed. 1 1.7 1.7.1  Created new style:  Name: Arrive Alive   Style type: Linked (Paragraph and character)  5  Style and Following style based on: Normal   Font colour dark red and 16   Paragraph spacing set to 3pt After.  1.7.2 “SAPS and the Metro Police”: formatted with this 1 new style 1.8 1.8.1 Footnote added to “Skidmarks”:  1.8.2 Number format changed to Roman Figure i.  3 1.8.3 Correct text appear in footer.  “Skidmarks are marks left on the roadway from a vehicle that has locked its breaks” Copyright reserved Please turn over

Downloaded from hlayiso.com (NOVEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.9 Section break inserted in the correct place (before Main 1 Heading: Background)  1.10 Table of Content Added  At the top of first page  Heading 1 and 2 style displayed  3 1.11 Automatic page numbering  2 In the centre of the footer  1.12 Drop cap added to first sentence in first paragraph  2 Distance set to 0.5 cm from text  [35] Copyright reserved Please turn over

Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2014) QUESTION 2 No. Criteria Max.  Mark 2.1 Font ‘Children Safety’ and ‘Cycle Fun Race’ changed to WordArt  2 Style Gradient Fill Gold, Accent 4  2.2 Pictures size of both set at exactly 2.73 cm  by 2.73 cm  3 2.3  WordArt images grouped with pictures 2  Displayed as one object.  2.4 2.4.1 Object colour Change Accent Colours 4 to 5. 2 2.4.2 Object style changed to 3-D  ‘Inset’ SmartArt 1 Style  2.4.3 Information/text of the first three finalists changed.  3 2.4.4 Picture Fill applied correctly image Q2_SA flag. 2 jpg  [15] Copyright reserved Please turn over

Downloaded from hlayiso.com (NOVEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 3 No. Criteria Max.  Mark 3.1  A1: L1 merged  2  Red fill colour  3.2 3.2.1 Row height changed to 34.  1 3.2.2 Headings in row 3 vertically centred  Wrap text applied  2 3.3 Column headings in row 3 Frozen  1 3.4 Column H:  Conditional Formatting applied  3  Condition: Greater than R65   Format: Green fill  3.5 Cell D106: =COUNTIF (C4:C104,"L") 3 3.6 Cell D107: =COUNTA (D4:D104)  2 OR=COUNTA(B4:B104) OR =COUNT(A4:A104) 3.7 Cell H106: =COUNTBLANK (K4:K104)  2 3.8 Cell H107: =SUMIF (C4:C104,"L",H4:H104) 4 3.9 Cell L4: =IF (C4="S","40km","75km") 4 Copyright reserved Please turn over

Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2014) 3.10 Cell J6: Format cell as text and insert 0 Custom format  Cell number correctly displayed  2 3.11 Borders inserted  In the correct range A3:L104  2 [28] Copyright reserved Please turn over

Downloaded from hlayiso.com (NOVEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 7 QUESTION 4 No. Criteria Max.  Mark 4.1 4.1.1 Cell G8: Correct formula *  2 Correct cells: =A8*F8   4.1.2 Auto fill/drag down method used  1 cells G8:G12  4.2 Cell G16: =SUM  2 (G8:G12)  4.3 Cell G17: =IF (G16>R3000,G16*10%,G16*0) 3 OR =IF(G16>3000,G16*0.1,”0”) 4.4 Cell G19: =G18 *0.14 3 OR =G18+14% 4.5 Cell G20: =SUM  (G18,G19)  OR G18 + G19 2 Copyright reserved Please turn over

Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2014) Work in the Graph worksheet. 4.6  Bar/column (suitable) chart inserted correctly   Correct data range used (excluding fruit juice)  Relevant title   Legend removed   Y-axis set to end at 100 (maximum value)   Axis title displayed   Data values correctly displayed   Platter names appear in full on X-axis.  8 4.7 Sheet 1 hidden  1 [22] Copyright reserved Please turn over

Downloaded from hlayiso.com (NOVEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 9 QUESTION 5 No. Item / Criteria Max  Mark 5.1 5.1.1 ID field or CellNo field set as primary key  1 5.1.2 Drop down listwith correct data =  Mougins High,  Kilmore High, 2  Appleby High  (Display control and Row Source in the Lookup tab) 5.1.3 Volunteer code field: Required set as Yes  1 5.1.4 CellNo veld: Input Mask = 0000000000  2 5.2 Query: Mougins High Fields used for query: Name, Surname, CellNo, Volunteer code,  and School  School field not shown  Criteria for School field: Mougins High  Criteria for Volunteer Code field: 12  5 (5 records) 5.3 Query: K2K Volunteers Fields used for query: Name, Surname, School, Volunteer Code, CellNo, V_Vita C and V_1st Aid V_Vita C and V_1st Aid fields not shown  Criteria for Volunteer Code field:K2K_E OR K2K_L OR K2K_P Criteria for V_Vita C field: Yes or True or On  Criteria for V_1st Aid field: Yes or True or On  6 (Note: criteria must be repeated if on separate rows – ‘or’ logic) Sorted alphabetically by School (ascending)  Copyright reserved Please turn over

Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2014) 5.4 Form: List of Helpers Form Title: K2K Volunteers_2014 Calibri  (detail) 12 pt  Q5_Helmet image in form header  size 3 cm  6 pt solid  Red rectangular  border inserted around 4 fields Four fields moved to the right  9 Report: Volunteer List 5.5 5.5.1 Fields included: Name, Surname, School, Volunteer Code, V_H20, V-1st Aid, V_timekeepers, V_Vita C 1 and T_shirt Colour 5.5.2 Saved as List of volunteers  1 5.5.3 Grouped by School  then by Volunteer Code  2 5.5.4 Sorted by Surname  1 5.5.5 Orientation = Landscape  1 5.5.6 Title: Save our Cyclists!  1 5.5.7 Headings and details all clearly legible in Print Preview  and school field centre aligned  2 5.5.8 Statistics in Report Footer: = COUNT  ( * )( OR any field may be used) = COUNT  ( [School Name] )  5 Descriptive labels added for each calculation  [40] Copyright reserved Please turn over

Downloaded from hlayiso.com (NOVEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 11 QUESTION 6 No. Item / Criteria Max  Mark 6.1 Title: Zero Tolerance <title> Zero Tolerance </title> 2 Opening and closing tags for title  6.2 Background colour <body bgcolor ="green"> 1 bgcolor="green" attribute added to <body> tag  6.3 Heading: Burry Stander Foundation <h1> <font color="yellow" align="center"> The Burry Stander Foundation</font ></h1> Text appears between<h1> … </h1> tags  4 <font> … </font> tags added  With the following attributes applied to the text font: Align=centre  colour = “yellow”  6.4 <body bgcolor = “green”>< font colour =”white”>  1 6.5 Q6_SA mug.gif 1 Image name changed to “Q6_SA mug.jpg”  6.6 Italics 1 Italics tag closed after ‘lost’: <i> lost </i>  6.7 Numbered list under the Heading: We stand for… <ul> . . . </ul> changed to <ol> . . . </ol>  <li> added to Pedestrians 3 <li> added to Cycling commuters <li> added to Motorbikes </li> 2 marks for opening and closing the list tags <li> ……</li>( 6.8 6.8.1 Immediate Goals 1 Bold removed <b>………</b> 6.8.2 u>………</u> added to the text 1 Copyright reserved Please turn over

Downloaded from hlayiso.com 12 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2014) 6.9 6.9.1 How can you help <p> How can you help </p> changed to 1 <p align="centre"> How can you help </p> Align = “Centre” added as indicated  6.9.2 Horizontal lines Above and below the text “How can you …”  <hr colour="red" /> 2 colour= “red”  (-1 if either of the two lines is missing) 6.10 Font face attribute face=”jokerman”  2 added to Petition [20] Copyright reserved Please turn over

Downloaded from hlayiso.com (NOVEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 13 QUESTION 7 No. Criteria Max.  Mark 7.1 Sheet 2 removed  1 7.2 7.2.1 Copy  and saved Q7-Fatalities  Data on 3 Fatalities is linked / updatable  7.3 Caption “Figure1” 1 7.4 PowerPoint file Q7_Slide_ display correct as icon and 2 linked to original file location  7.5 7.5.1 Imported: Q7_Manager_Details to a new table  1 7.5.2 Date of Birth column excluded 1 7.5.3 NO primary key  1 7.5.4 Renamed Q7_Manager_Details  1 7.6 7.6.1 File converted to Rich Text Format (Q7_Hard 2 facts.rtf).  7.6.2 Author property changed to Name and Surname in 1 the download.jpg file  7.6.3 Q7_Hard facts .rtf set to Read-only attribute  1 7.7 63 files  1 7.8 7.8.1 Order changed, from left to right; to Size, Name 1 and Type.  7.8.2 Screenshot pasted in the Q7 Answer file  1 7.9 My bike.docx  protected with a Password: NOV_14  1 [20] TOTAL: 180 Copyright reserved Please turn over

(NOVEMBER 2014) REKENAARSTOEPASSINGSTEGNOLOGIE V1 13 VRAAG 7 Nr. Kriteria Maks  Punt 7.1 Sheet 2 verwyder  1 7.2 7.2.1 Grafiek gekopieer  en gestoor Q7-Fatilities 2 Data kan outomaties opdateer  1 7.3 Byskrif “Figure1” 1 7.4 PowerPoint lêer Q7_Slide_ vertoon korrek as “icon”  2 gekoppel aan die oorspronklike posisie van die lêer.  7.5 7.5.1 Q7_Manager_Details by databasistabel ingevoeg  1 7.5.2 Date of Birth kolom nie bygevoeg  1 7.5.3 Geen primêre sleutel  1 7.5.4 Herbenoem Q7_Manager_Details  1 7.6 7.6.1 Lêer (Q7_Hard facts) verander na Rich Text 2 Formaat   7.6.2 Author eienskap verander na eie naam en van in 1 die download.jpg lêer.  7.6.3 Read-only eienskap verwyder Q7_Hard facts.rtf  1 7.7 63 lêers  1 7.8 7.8.1 Orde verander van links na regs; na Size, Name 1 en Type.  7.8.2 Screenshot in Q7 Answer lêer geplak.  1 7.9 My bike.docx wagwoord NOV_14 gebruik.  1 [20] TOTAAL: 180 Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

12 REKENAARTOEPASSINGSTEGNOLOGIE V1 (NOVEMBER 2014) 6.9 6.9.1 How can you help <p> How can you help </p> verander na <p align="center"> How can you help 1 </p> Align = “Centre” bygevoeg soos aangetoon  6.9.2 2 x Horizontal lines Bo en die onder die teks “How can you …”  <hr color="red" /> 2 <hr/>  color= “RED”  (-1 as enige van die twee lyne kort) 6.10 Font face attribute: face=”jokerman”  2 Bygevoeg by Petition [20] Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

(NOVEMBER 2014) REKENAARSTOEPASSINGSTEGNOLOGIE V1 11 VRAAG 6 Nr. Item / Kriteria Maks.  Punt 6.1 Title: Zero Tolerance <title> Zero Tolerance </title> 2 Begin en eind tags soos aangedui, bygevoeg  6.2 Background colour <body bgcolor="green"> 1 bgcolor="green" attribuut by die <body> tag gevoeg 6.3 Heading: Burry Stander Foundation <font color="yellow" align="center"> <h1> The Burry Stander Foundation</font color="yellow" align="center"></h1> Teks verskyn tussen<H1> … </h1> tags  4 <font> … </font> tags bygevoeg  Die volgende attribute bygevoeg: Align=center color = “yellow”  6.4 Color attribute bygevoeg by die font tag van nuwe paragraaf 1 <p>font color=”white”>  6.5 Q6_SA mug.gif 1 Image naam verander na “Q6_SA mug.jpg”  6.6 Skuinsdruk probleem 1 Italics tag gesluit na ‘lost’: <i> lost </i>  6.7 Genommerde lys na die opskrif: We stand for… <ol> . . . </ol> verander na <ul> . . . </ul>  <li> bygevoeg by Pedestrians <li> bygevoeg by Cycling commuters 3 <li> bygevoeg by Motorbikes 2 punte vir die oop- en toemaakmaak van die list tags <li> ……</li>( 6.8 6.8.1 Immediate Goals 1 Vetdruk (‘Bold’) verwyder <b>………</b> 6.8.2 u>………</u> by die teks bygevoeg.t 1 Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

10 REKENAARTOEPASSINGSTEGNOLOGIE V1 (NOVEMBER 2014) 5.4 Form: List of Helpers Form Title: K2K Volunteers_2014 Calibri  (detail) 12 pt  Q5_Helmet image in form header  size 3 cm  6 pt solid  Red rectangular  border inserted around 4 fields Four fields moved to the right  9 Verslag: Volunteer List 5.5 5.5.1 Velde ingesluit: Name, Surname, School, Volunteer Code, V_H20, V-1st Aid, V_timekeepers, V_Vita C 1 and T_shirt Colour  5.5.2 Stoor as List of volunteers  1 5.5.3 Gegroepeer volgens School  en daarna Volunteer 2 Code 5.5.4 Gesorteer volgens Surname  1 5.5.5 Oriëntasie Landscape  1 5.5.6 Titel: Save our Cyclists!  1 5.5.7 Opskrifte en besonderhede duidelik leesbaar (Print Preview)  2 Skool se detail gesentreer  5.5.8 Statistics in Report Footer: = COUNT  ( * )(OF enige veld kan gebruik word) = COUNT  ( [School Name] )  5 Geskikte beskrywing (etiket) by elke berekening  [40] Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

(NOVEMBER 2014) REKENAARSTOEPASSINGSTEGNOLOGIE V1 9 VRAAG 5 Nr. Item / Kriteria Maks  Punt 5.1 5.1.1 ID veld of SelNo veld as primêre sleutel gestel.  1 5.1.2 Combo box bestaan uit  Mougins High  Kilmore High 2  Appleby High  (Kontroleer Display control en Row Source in die Lookup tab) 5.1.3 Volunteer code-veld: Required gestel as Yes  1 5.1.4 CellNo veld: Input Mask = 0000000000  2 5.2 Navraag: Mougins High Velde in navraag gebruik: Name, Surname, CellNo, School en Graad12  ‘Show’ afgehaal by School veld  Kriteria vir School veld: Mougins High  Kriteria vir Volunteer Code vield: 12 5 (5 records) 5.3 Navraag: K2K Volunteers Velde in navraag gebruik: Name, Surname, School, Volunteer Code, CellNo, V_Vita C and V_1st Aid ‘Show’ afgehaal by V_Vita C en V_1st Aid fields  Kriteria vir Volunteer Code vield:K2K_E OR K2K_L OR K2K_P  Kriteria vir V_Vita C vield: Yes or True or On  Kriteria vir V_1st Aid vield: Yes or True or On  6 (Nota: kriteria moet herhaal word indien op aparte rye – ‘or’ logic) Sorteer alfabeties (ascending) volgens school  Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

8 REKENAARTOEPASSINGSTEGNOLOGIE V1 (NOVEMBER 2014) Grafiek werksblad 4.6  Gepaste grafiek (bar, column) korrek ingevoeg  Korrekte data reeks gebruik:  vrugtesap nie ingesluit nie!  Beskrywende titel   Legend verwyder   Y-as gestel 100 (maksimum waarde).   Titel van as korrek   Vertoon data waardes korrek   Name van platters volledig op x-as.  8 4.7 Sheet 1 weggesteek (hide)  1 [22] Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

(NOVEMBER 2014) REKENAARSTOEPASSINGSTEGNOLOGIE V1 7 VRAAG 4 Nr. Kriteria Maks.  Punt 4.1 4.1.1 Sel G8: Korrekte formule  2 =A8*F8  4.1.2 Gebruik Auto fill/Drag down metode  1 Selle G8:G12 4.2 Sel G16: =SUM  2 (G8:G12)  4.3 Sel G17: =IF (G16>R3000,G16*10%,G16*0) 3 OF =IF(G16>3000,G16*0.1,”0”) 4.4 Sel G19: =G18*0.14 3 OF =G18+14% 4.5 Sel G20: =SUM (G18,G19)  OF G18 + G19 2 Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

6 REKENAARTOEPASSINGSTEGNOLOGIE V1 (NOVEMBER 2014) 3.10 Sel J6: formateer sel na teks en voeg 0 in Custom Format  Cell no. vertoon korrek  2 3.11 Raam bygevoeg  Korrekte reeks A3:L104  2 [28] Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

(NOVEMBER 2014) REKENAARSTOEPASSINGSTEGNOLOGIE V1 5 VRAAG 3 Nr. Kriteria Maks.  Punt 3.1 A1:L1 saamgevoeg  2 Rooi vulkleur  3.2 3.2.1 Ry hoogte verander na 34.  1 3.2.2 Kolomme vertikaal gesentreer in ry 3.  Teks omvou 2 3.3 Kolom opskrifte in ry 3 gevries  1 3.4 Kolom H:  Voorwaardelike formatering korrek  3  Kondisie: Meer as R65   Formatering: Groen vul  3.5 Sel D106: =COUNTIF (C4:C104,"L")  3 3.6 Sel D107: =COUNTA (D4:D104)  2 OR=COUNTA(B4:B104) OR =COUNT(A4:A104) 3.7 Sel H106: =COUNTBLANK  (K4:K104)  2 3.8 Sel H107: =SUMIF (C4:C104,"L",H4:H104) 4 3.9 Sel L4: =IF (C4="S","40km","75km")  4 Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

4 REKENAARTOEPASSINGSTEGNOLOGIE V1 (NOVEMBER 2014) VRAAG 2 Nr. Kriteria Maks.  Punt 2.1 Font tipe verander ‘Children Safety’ and ‘Cycle Fun Race’ na WordArt  2 Gradient Fill, Gold, and Accent 4.  2.2 Prentgrootte van beide presies  2.73 cm  by 2.73 cm 3 2.3  WordArt en prente gegroepeer  2  As een voorwerp.  2.4 2.4.1 Kleur verander Change Accent Colors 4 to 5. 2 2.4.2 voorwerp styl verander na ‘Inset’ SmartArt Style 1 2.4.3 Eerste drie finaliste se informasie verander.  3 2.4.4 Picture Fill toegepas met korrekte prent Q2_SA 2 flag.jpg  [15] Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

(NOVEMBER 2014) REKENAARSTOEPASSINGSTEGNOLOGIE V1 3 1.9 Section break (new page) korrek ingevoeg voor hoofopskrif 1 (Background)  1.10 Table of Content bygevoeg  boaan eerste bladsy  Heading1 en Heading2 styl vertoon  3 1.11 Gesentreerde outomatiese  bladsynommering in voetnota 2 (footer). 1.12 ‘Drop cap’ by eerste sin van eerste paragraaf bygevoeg.  2 Afstand/spasie 0.5 cm van teks.  [35] Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

2 REKENAARTOEPASSINGSTEGNOLOGIE V1 (NOVEMBER 2014) VRAAG 1 Nr. Kriteria Maks.  Punt 1.1 Regs inlyn,  verander na Italics,  Traffic Accident Investigation in South Africa, disturbing 2 facts. 1.2 Heading 1 kleur verander na rooi  Hoof opskrif (Background) geformateer met aangepaste 3 Heading1 styl  Alle sub-opskrifte met Heading2 styl  1.3 Verwysing vir report: Korrekte posisie   Author: Volminck,S,D,Nathan   Title: News Updater   Year: 2013  7  City: Pretoria   Publisher: Daily News  1.4 3pt bladsyraam  2 1.5 Byskrif bygevoeg  “Vehicle types” bo-aan diagram.  (Hierdie diagram sal 3 nou op bladsy 2 a.g.v.die bladsybreuk wees.) Nommer formaat verander na A  1.6 Raam rondom die paragraaf verwyder.  1 1.7 1.7.1  Nuwe styl geskep:  Name: Arrive Alive   Style type: Linked (Paragraph and Character)  5  Style en Following style based on: Normal   Fontkleur donkerrooi en 16  Paragraafspasiëring gestel 3pt After.  1.7.2 Formateer “SAPS and Metro Police”:  met 1 nuwe styl 1.8 1.8.1 Voetnota bygevoeg: ‘“Skidmarks”’  1.8.2 Nommer formateer na Roman Figure i. 3 1.8.3 Korrekte teks in voetnota (‘footer’). ““Skidmarks are marks left on the roadway from a vehicle that has locked its breaks” Kopiereg voorbehou Blaai om asseblief Downloaded from hlayiso.com

NASIONALE SENIOR SERTIFIKAAT GRAAD 11 NOVEMBER 2014 REKENAARTOEPASSINGSTEGNOLOGIE V1 MEMORANDUM NAAM VAN KANDIDAAT: GRAAD: HANDTEKENING VAN ONDERWYSER: TOTAAL V1 V2 V3 V4 V5 V6 V7 PUNTE: 180 35 15 28 22 40 20 20 Hierdie memorandum bestaan uit 13 bladsye. Downloaded from hlayiso.com