Computer Applications Technology Grade 12 2013 Memo

Downloaded from hlayiso.com Province of the EASTERN CAPE EDUCATION NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2013 COMPUTER APPLICATIONS TECHNOLOGY P1 MEMORANDUM MARKS: 200 CANDIDATE’S MARKS CANDIDATE NAME QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 37 29 12 44 32 40 6 200 CANDIDATE MARK FINAL MARK This memorandum consists of 13 pages.

Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2013) QUESTION 1 File: q1Thermo_Rec No. Criteria Max.  Mark 1. Open the file q1Thermo-Rec 1.1 Paragraph spacing 2  Paragraph spacing set to 10 pt/2 lines/0.35 after  entire document 1.2 Margin 1  Right-hand margin set to 1.3 cm for the entire document 1.3 Document layout 2  Full justification – whole document  Automatic hyphenation zone changed to 0.5 cm 1.4 Heading: 8 WordArt/Fontworks  WordArt style 1 applied to “THERMO-REC”  3D Parallel style 1  Curved Right Arrow and the Curve Left Arrow inserted in correct position  Group WordArt and Arrows  Grouped logo - Width 10 cm  Grouped logo - Height 3 cm  Grouped logo - Centred horizontally  Centred relative to page 1.5 Image 5  Correct image inserted  Displays centred horizontally  Border 3 pt wide  Border blue  Picture background set to appear transparent 1.6 Styles 2  Heading 2 style modified to appear in a red font colour  Automatically updated 1.7 Page Numbering in Header 3  Page numbering changed to a, b, c etc. format  Different Odd and Even Pages selection removed  The same format and continuous page numbering appear in the header throughout the document 1.8 Drop Cap “T” 2  Drop Cap appears in margin  Drops over two lines 1.9 Watermark 3  Correct spelling “ Recycling”  Semi-transparent  Runs diagonally

Downloaded from hlayiso.com (SEPTEMBER 2013) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.10 Find and Replace – All occurrences of “Thermo Rec” appear in: 3  Small caps  Outline effect and  Thermo Rec – both words changed throughout 1.11 Columns 5  Three columns created  First column is 6 cm wide  Second and third columns are 4.5 cm wide  Vertical line between columns  Column breaks ensure that every paragraph starts at the top of a new column 1.12 Line spacing 1  Entire document line spacing is set to 14 pt [37]

Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2013) QUESTION 2 File: q2Waste No. Criteria Max.  Mark 2. Open the file q2Waste 2.1 Date 2  Date field inserted in the page header  Automatic update selected 2.2 Page Setup 2  Gutter position changed to left and 1 cm  Paper size changed to A4 2.3 Table of Contents 2  Automatic Table of contents inserted  Only the Heading style “NEW” is used in the table of contents 2.4 Bullets 4  Bullets applied to the correct text  Garbage.jpg image is used to define the bullets  Bullets centre aligned  Bullets appear at the left hand margin 2.5 Hyperlink removed 1  Hyperlink removed from the word “SCOPING” 2.6 Spelling errors corrected 1  Spelling error corrected 2.7 Bookmark 1  Bookmark named “First” is added to the picture on the first page 2.8 Table 8  Correct text is converted to a table  Heading in the first row is in uppercase  First row is merged  The first two rows are centred vertically and horizontally  Text direction is vertical in the second row  Height of the second row is 3 cm  First row is shaded grey  Borders are added as shown in the example 2.9 Formula in Table: =Count(Above) 1  Sum is changed to Count 2.10 Chart 2  Chart is moved to the correct position (“FEEDSTOCK” columns)  Text is wrapped around chart 2.11 Hyperlink added to link to bookmark 1  The word “FIRST” is hyperlinked to the bookmark “First”

Downloaded from hlayiso.com (SEPTEMBER 2013) COMPUTER APPLICATIONS TECHNOLOGY P1 5 2.12 Page Orientation 1  Orientation of the last page is changed to Landscape 2.13 Field inserted in footer 3  Field containing the name of the Author is inserted  On the right hand side of the footer  Formatted in Uppercase [29]

Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2013) QUESTION 3 File: q3Certificate, q3Final No. Criteria Max.  Mark 3. Open the file q3Certificate 3.1 Table converted to text 1  The table shaded in yellow has been converted to text and commas were used as separators 3.2 Table deleted 1  The table shaded in blue has been deleted 3.3 Art Page Border 1  Any page border from the Art gallery has been inserted 3.4 Mail Merge 3.4.1  The table called DATA in the q3Details.mdb database is 1 used as the data source 3.4.2  The certificates are sorted in descending order according 1 to Surname 3.4.3  Certificates are only awarded for Dedication as 1 Outstanding Quality (3 records comply to this criteria) 3.4.4 Sections between <<>> have been replaced with the relevant 2 merge fields:  Name replaced  Surname replaced 3.4.5  The final merged certificates are saved as q3Final.doc in 1 the 2013 EXAM DATA folder 3.5 Subfolder created 2  A subfolder called “Certificate “ has been created in the 2013 EXAM DATA folder  The q3Final.doc document is moved to this folder 3.6 File saved in PDF format 1  A copy of the q3Final.doc document has been saved in the Certificate subfolder in pdf format [12]

Downloaded from hlayiso.com (SEPTEMBER 2013) COMPUTER APPLICATIONS TECHNOLOGY P1 7 QUESTION 4 File: q4Calculations No. Criteria Max.  Mark 4. Open the spreadsheet q4Calculations and work in the Sales worksheet 4.1 Row 1 3  Cells A1 to I1 are merged  Main heading “Turning Waste into Job Opportunities” is centred horizontally and vertically  Font: Arial Black 27 pt  4.2 Row 2 4  Text Orientation of the headings: changed to 86º  Row Height: changed to 75  Text Wrapped  Blue fill colour added to cells with headings 4.3 All the data is clearly visible 1 4.4 Range F4:F29 2  Formatted in South African Currency  No decimal places 4.5 Cell C4 =UPPER(D4&"/"&LEFT(E4,3)) OR 5 =UPPER(CONCATENATE(D4,”/”,LEFT(E4,3)))  =UPPER  CONCATENATE or & operator  Cell D4  “/”  LEFT(E4,3) 4.6 Cell F9 =VLOOKUP(E9,VLOOKUP!$B$2:$C$27,2,FALSE) 4  Correct Cell E9  Correct sheet Range Absolute referenced  2nd Column  FALSE 4.7 Cell F30 =MODE(F4:F29) 2  =MODE  Correct Range 4.8 Cell F31 =ROUND(AVERAGE(F4:F29),0) 4  =ROUND  AVERAGE  Correct Range  Rounded to 0 decimal places and correct use of brackets 4.9 Cell F33 =COUNTIFS(A4:A29,"Mr",D4:D29,"DBN") 5  COUNTIFS  Correct Range A4:A29  Criteria “Mr”  2nd Correct Range D4:D29  Criteria “DBN”

Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2013) 4.10 Cell F36 =LARGE(G4:G29,2) 3  =LARGE  Correct Range G4:G29  Criteria 2  4.11 Cell F37 =COUNTBLANK(I4:I29) 2  =COUNTBLANK  Correct Range 4.12 Cell K4 =(F4*$K$3)+F4 OR =F4+(F4*$K$3) 3  Correct calculation F4*$K$3   Absolute reference  Correct Cell added: +F4 4.13 Cell M4 =AND(G4>250,L4>8) OR 3 =IF(L4>8,IF(G4>250,"TRUE","FALSE"))  Brackets and use of =AND function  Criteria G4>250  Criteria L4>8  4.14 Cell G31 1  Comment removed 4.15 Cell F38 =LEN(I20) 2  LEN function  Correct Cell [44]

Downloaded from hlayiso.com (SEPTEMBER 2013) COMPUTER APPLICATIONS TECHNOLOGY P1 9 QUESTION 5 File: q5Quarterly No. Criteria Max.  Mark 5. Work in the Data worksheet 5.1 Range C3:H3 1  Diagonal borders have been added 5.2 Row 1 1  Picture moved from the Image worksheet to the left of the heading in Row 1 of the Data worksheet 5.3 Cell B12 =SUMIF(A4:A9,"B",C4:C9) 3  1st Correct Range A4:A9  2nd Correct Range C4:C9  Correct criteria "B" 5.4 Range C4:H9 3  Original Conditional Formatting for this range is removed  New condition added: >R65 000  Formatting for new condition: filled with a yellow colour 5.5 Range A4:H9 Sorting 4  First sorted by District  In descending order  Secondly sorted by Branches  In ascending order Work in the Totals worksheet that is renamed to Sales 5.6 Cell B2 =SUM(Data!C9:H9) 2  Correct function  Correct Cell Range 5.7 Worksheet – Totals renamed 2  Renamed to Sales  Tab colour red 5.8 Cell C2 =IF(B2>=400000,"Excellent",IF(B2>=300000,"Good"," ")) 5  Nested IF constructed used correctly  Criteria for Excellent is correct  Criteria for Good is correct  Criteria for empty cell is correct  Function filled down for the Range C2:C7 Work in the Password worksheet 5.9 Password worksheet 1  Password removed from the worksheet

Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2013) Work in the Graph worksheet 5.10 Graph edited 10  Graph appears in a new sheet called Chart (not as an object in the sheet)  Chart title above the chart reading: “Total Sales”  Chart changed to a Pie chart  The Legend appears above the chart  Data labels - percentages  Data labels - position of percentages Inside End  Data labels - font size 36 pt  Data labels – font colour white  The largest segment/slice has been exploded/pulled out  The largest segment/slice is filled with the image named Green [32]

Downloaded from hlayiso.com (SEPTEMBER 2013) COMPUTER APPLICATIONS TECHNOLOGY P1 11 QUESTION 6 File: q6Branches No. Criteria Max.  Mark 6. Work in the RecycledStock table 6.1 ItemImage field 2  Data type changed to OLE object (OR Hyperlink)  Image Green.bmp added to the Norwood branch in Cape Town 6.2 InStock field 1  Field Size changed to Double 6.3 Field added 2  New field named Title is added  The Title field appears above the PersonResponsible field 6.4 Title field 3  List Box added (OR Combo Box)  Value list  Correct Raw Source data: Mr; Mrs; Ms 6.5 City field 1  Sorted in descending order 6.6 City field 1  Field properties: > added to format 6.7 InStock field >=1 And <=9000 OR Between 1 And 9000 3  Validation Rule: Correct conditions  Validation Rule: And  Any relevant Validation Text e.g.: “Stock must be any number from 1 to 9000” 6.8 BranchCode field - Input Mask ???0000"-REC" 3  ??? (optional letters)  0000 (required numbers)  "-REC" 6.9 BranchCode field 1  Required: Yes selected  6.10 Table gridlines 2  Only the vertical gridlines show  Vertical gridline colour is Red

Downloaded from hlayiso.com 12 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2013) Work in the NewValue query 6.11 NewValue query has been modified as follows: 6  Hidden fields Unhide  CurrentValue field is sorted in Ascending order Calculated field: NewValue:[CurrentValue]+([CurrentValue]*0.2)  New field name: NewValue:   Correct field multiplied by 20%: [CurrentValue]*0.2  Correct field added and correct use of brackets  NewValue field is displayed in South African currency Work in the Stock query 6.12 Stock query: 5  Query called Stock is created  Following fields are displayed: City; Colour  1st Correct criteria(give mark even if wild card is left out)  Use of wild card * in the first criteria  2nd Correct criteria Work in the RecycledStock form 6.13 RecycledStock form: 5  Green logo inserted to the Form Header  Date added as a function in Form Footer = Date()  Background colour of Branch field name is change to any colour  Combo box inserted for Colour field  Correct list added: Blue, Yellow, Green, Red and Black Work in the Branches report 6.14 Branches report 5  Grouped according to the City field  New field Label created in the Page Header: TotalValue  Correct calculation in Detail area: *  Text box used for the formula  Correct fields used : =[InStock]*[CurrentValue] [40]

Downloaded from hlayiso.com (SEPTEMBER 2013) COMPUTER APPLICATIONS TECHNOLOGY P1 13 QUESTION 7 File: q7Answers No. Criteria Max.  Mark 7.1  20 pt 1 7.2  Lewis 1 7.3  Recycling 1 7.4  10660 1 7.5  Footnote 1 7.6 1  [6] TOTAL: 200

(SEPTEMBER 2013) REKENAARTOEPASSINGSTEGNOLOGIE V1 13 VRAAG 7 Lêer: q7Answers Nr. Kriteria Maks.  Punt 7.1  20 pt 1 7.2  Lewis 1 7.3  Recycling 1 7.4  10660  1 7.5  Footnote 1 7.6 1  [6] TOTAAL: 200 Downloaded from hlayiso.com

12 REKENAARTOEPASSINGSTEGNOLOGIE V1 (SEPTEMBER 2013) Werk in die NewValue-navraag 6.11 NewValue-navraag is aangepas as volg: 6  Verskuilde velde “Hidden fields” wys “Unhide”  CurrentValue-veld is in stygende orde gesorteer Berekende veld: NewValue:[CurrentValue]+([CurrentValue]*0.2)  Nuwe veld se naam: NewValue:   Korrekte veld vermenigvuldig met 20%: [CurrentValue]*0.2  Gebruik van hakkies en korrekte veld bygetel  NewValue-veld vertoon in Suid-Afrikaanse geldeenheid Werk in die Stock-navraag 6.12 Stock-navraag: 5  Navraag genaamd Stock is geskep  Volgende velde vertoon: City; Colour  1ste Korrekte kriteria(gee Punt al is die “wild card” uitgelaat)  Gebruik van “wild card” * in die eerste kriteria  2de Korrekte kriteria Werk in die RecycledStock-vorm 6.13 RecycledStock-vorm: 5  “Green” logo ingevoeg in vormboskrif (“Form Header”)  Datum as funksie in vormonderskrif = Date()  Agtergrondkleur van die Branch-veldnaam is verander na enige kleur  Keuselys (“Combo box”) ingevoeg by Colour-veld  Korrekte lys: Blue, Yellow, Green, Red en Black Werk in die Branches-verslag 6.14 Branches-verslag 5  Gegroepeer volgend die City-veld  Nuwe veld etiket vertoon in bladsyboskrif (“Page Header”): TotalValue  Korrekte berekening in “Detail” area: *  “Text box” gebruik vir formule  Korrekte velde gebruik: =[InStock]*[CurrentValue] [40] Downloaded from hlayiso.com

(SEPTEMBER 2013) REKENAARTOEPASSINGSTEGNOLOGIE V1 11 VRAAG 6 Lêer: q6Branches Nr. Kriteria Maks.  Punt 6. Werk in die RecycledStock-tabel 6.1 ItemImage veld 2  Datatipe verander na “OLE object” (OF Hiperskakel)  Prent Green.bmp by Norwood tak in Kaapstad ingevoeg 6.2 InStock-veld 1  Veldgrootte verander na “Double” 6.3 Veld bygevoeg 2  Nuwe veld genaamd Title is bygevoeg  Die Title-veld is bokant die PersonResponsible-veld 6.4 Title-veld 3  “List Box” gebruik (OF “Combo Box”)  “Value list”  Korrekte “Raw Source” data: Mr; Mrs; Ms 6.5 City-veld 1  In dalende orde gesorteer 6.6 City-veld 1  Veldeienskappe: > ingevoeg by formaat 6.7 InStock-veld “ >=1 And <=9000” OF “Between 1 And 9000” 3  Valideringsreel: Korrekte voorwaarde  Valideringsreel: And  Enige relevante Valideringsboodskap bv.: “Voorraad kan enige getal van 1 tot 9000 wees” 6.8 BranchCode-veld – toevoermasker (“Input Mask”) ???0000"-REC" 3  ??? (opsionele letters)  0000 (verpligte nommers)  "-REC" 6.9 BranchCode-veld 1  Vereiste veld (“Required”): “Yes” is geselekteer  6.10 Tabel-gidslyne 2  Slegs die vertikale gidslyne word vertoon  Vertikale gidslyne is ’n Rooi kleur Downloaded from hlayiso.com

10 REKENAARTOEPASSINGSTEGNOLOGIE V1 (SEPTEMBER 2013) Werk in die Graph-werkblad 5.10 Grafiek geredigeer 10  Grafiek is in ’n nuwe werkblad genaamd Chart (“not as an object in the sheet”)  Grafiektitel bokant die grafiek lees: “Total Sales”  Verander na ’n sirkelgrafiek “Pie-chart”  Die verklaring (“Legend”) is bokant die grafiek  Data waardes – persentasies  Data waardes – posisie “Inside End”  Data waardes – fontgrootte 36 pt  Data waardes – fontkleur wit  Die grootste segment is uitgetrek “exploded”  Die grootste segment is gevul met die Green-prent [32] Downloaded from hlayiso.com

(SEPTEMBER 2013) REKENAARTOEPASSINGSTEGNOLOGIE V1 9 VRAAG 5 Lêer: q5Quarterly Nr. Kriteria Maks.  Punt 5. Werk in die Data werkblad 5.1 Reeks C3:H3 1  Diagonale lyne (“borders”) is ingevoeg 5.2 Ry 1 1  Prent is geskuif van die Image-werkblad na die linkerkant van die opskrif in Ry 1 van die Data-werkblad 5.3 Sel B12 =SUMIF(A4:A9,"B",C4:C9) 3  1ste Korrekte Reeks A4:A9  2de Korrekte Reeks C4:C9  Korrekte Kriteria "B" 5.4 Reeks C4:H9 3  Oorspronklike voorwaardelike formatering verwyder  Nuwe voorwaarde ingevoeg: >R65 000  Formatering van nuwe voorwaarde: geel vulkleur 5.5 Reeks A4:H9 Sortering 4  Eerstens volgens “District” gesorteer  In dalende (“descending”) volgorde  Tweedens volgens “Branches” gesorteer  In stygende (“ascending”) volgorde Werk in die Totals-werkblad wat hernoem is na Sales 5.6 Sel B2 =SUM(Data!C9:H9) 2  Korrekte funksie  Korrekte Selreeks 5.7 Werkblad – Totals is herbenoem 2  Herbenoem na Sales  “Tab” kleur rooi 5.8 Sel C2 =IF(B2>=400000,"Excellent",IF(B2>=300000,"Good"," ")) 5  “Nested IF” korrek saamgestel  Kriteria vir “Excellent” is korrek  Kriteria vir “Good” is korrek  Kriteria vir leë sel is korrek  Funksie ondertoe gekopieer na die Reeks C2:C7 Werk in die Password-werkblad 5.9 Password-werkblad 1  Wagwoord is verwyder van die werkblad Downloaded from hlayiso.com

8 REKENAARTOEPASSINGSTEGNOLOGIE V1 (SEPTEMBER 2013) 4.10 Sel F36 =LARGE(G4:G29,2) 3  =LARGE  Korrekte Reeks G4:G29  Kriteria 2  4.11 Sel F37 =COUNTBLANK(I4:I29) 2  =COUNTBLANK  Korrekte Reeks 4.12 Sel K4 =(F4*$K$3)+F4 OF =F4+(F4*$K$3) 3  Korrekte berekening F4*$K$3   Absolute selverwysing  Korrekte Sel bygetel: +F4 4.13 Sel M4 =AND(G4>250,L4>8) OF 3 =IF(L4>8,IF(G4>250,"TRUE","FALSE"))  Hakkies en =AND funksie  Kriteria G4>250  Kriteria L4>8  4.14 Sel G31 1  Kommentaar verwyder 4.15 Sel F38 =LEN(I20) 2  LEN funksie  Korrekte Sel [44] Downloaded from hlayiso.com

(SEPTEMBER 2013) REKENAARTOEPASSINGSTEGNOLOGIE V1 7 VRAAG 4 Lêer: q4Calculations Nr. Kriteria Maks.  Punt 4. Maak die sigblad q4Calculations oop en werk in die Sales-werkblad 4.1 Ry 1 3  Selle A1 tot I1 saamgesmelt  Hoofopskrif “Turning Waste into Job Opportunities” is horisontaal en vertikaal gesentreerd  Font: Arial Black 27 pt  4.2 Ry 2 4  Teks oriëntering van opskrifte: verander na 86º  Ry hoogte: verander na 75  Woordomvou toegepas (“Wrapped”)  Blou vul-kleur vir selle met opskrifte ingevoeg 4.3 Alle data is duidelik sigbaar 1 4.4 Reeks F4:F29 2  Geformateer in Suid-Afrikaanse geldeenheid  Geen desimale plekke 4.5 Sel C4 =UPPER(D4&"/"&LEFT(E4,3)) OF 5 =UPPER(CONCATENATE(D4,”/”,LEFT(E4,3)))  =UPPER  CONCATENATE of & operator  Sel D4  “/”  LEFT(E4,3) 4.6 Sel F9 =VLOOKUP(E9,VLOOKUP!$B$2:$C$27,2,FALSE) 4  Korrekte Sel E9  Korrekte werkblad-Reeks met Absolute selverwysing  2de Kolom  FALSE 4.7 Sel F30 =MODE(F4:F29) 2  =MODE  Korrekte Reeks 4.8 Sel F31 =ROUND(AVERAGE(F4:F29),0) 4  =ROUND  AVERAGE  Korrekte Reeks  Afgerond na 0 desimale plekke en korrekte gebruik van hakkies 4.9 Sel F33 =COUNTIFS(A4:A29,"Mr",D4:D29,"DBN") 5  COUNTIFS  Korrekte Reeks A4:A29  Kriteria “Mr”  2nd Korrekte Reeks D4:D29  Kriteria “DBN” Downloaded from hlayiso.com

6 REKENAARTOEPASSINGSTEGNOLOGIE V1 (SEPTEMBER 2013) VRAAG 3 Lêer: q3Certificate, q3Final Nr. Kriteria Maks.  Punt 3. Maak die q3Certificate lêer oop 3.1 Tabel omgeskakel in teks 1  Die tabel wat in geel uitgelig is, is omgeskakel na teks - kommas is gebruik om die teks te skei. 3.2 Tabel verwyder 1  Die tabel wat in blou uitgelig is, is verwyder 3.3 Kuns/patroon Bladsyraam 1  Enige bladsyraam van die “Art gallery” is ingevoeg 3.4 Possamevoeging (“Mail Merge”) 3.4.1  Die tabel genaamd DATA in die q3Details.mdb databasis 1 is gebruik as databron 3.4.2  Die sertifikate is in dalende orde volgens van (“Surname”) 1 gesorteer 3.4.3  Sertifikate is slegs aan lede wat “Dedication” as hulle 1 uitstaande kenmerk het, uitgereik (3 rekords voldoen aan kriteria) 3.4.4 Die gedeeltes tussen <<>> is vervang met die geskikte 2 samevoegingsvelde:  “Name” vervang  “Surname” vervang 3.4.5  Die finale saamgevoegde sertifikate is gestoor as 1 q3Final.doc in die 2013 EXAM DATA-lêergids 3.5 Sublêergids geskep 2  ‘n Sublêergids genaamd “Certificate “is in die 2013 EXAM DATA-lêergids geskep  Die q3Final.doc dokument is geskuif na die lêergids 3.6 Lêer gestoor in PDF formaat 1  ’n Kopie van die q3Final.doc dokument is gestoor in die Certificate-sublêergids in pdf formaat [12] Downloaded from hlayiso.com

(SEPTEMBER 2013) REKENAARTOEPASSINGSTEGNOLOGIE V1 5 2.12 Bladsyoriëntasie 1  Laaste bladsy is in “Landscape” oriëntasie 2.13 Veld in bladsyonderskrif 3  Veld wat die outeurnaam (“Author”) aandui is ingevoeg  Aan die regterkant van die bladsyonderskrif  Bokasformaat is geselekteer [29] Downloaded from hlayiso.com

4 REKENAARTOEPASSINGSTEGNOLOGIE V1 (SEPTEMBER 2013) VRAAG 2 Lêer: q2Waste Nr. Kriteria Maks.  Punt 2. Maak die lêer q2Waste oop 2.1 Datum 2  Datum as veld in bladsyboskrif  Gestel om outomaties op te dateer 2.2 Bladsy Uiteensetting 2  “Gutter” posisie verander na links en 1 cm  Papiergrootte is verander na A4 2.3 Inhoudsopgawe 2  Outomatiese Inhoudsopgawe ingevoeg  Slegs die Heading-styl genaamd “NEW” is in die Inhoudsopgawe gebruik 2.4 Kolpunte 4  Kolpunte by die korrekte teks gebruik  Garbage.jpg prent is gebruik as kolpunte  Kolpunte is gesentreerd  Kolpunte verskyn by die linkerkantlyn 2.5 Skakel (“Hyperlink”) verwyder 1  Skakel van die woord “SCOPING” verwyder 2.6 Spelfoute gekorrigeer 1  Spelfout is gekorrigeer 2.7 Boekmerk 1  Boekmerk genaamd “First” is aan die prent op die eerste bladsy geheg 2.8 Tabel 8  Korrekte teks is in ‘n tabel omgeskakel  Opskrif in die eerste ry is in bokas  Eerste ry is saamgesmelt  Die eerste twee rye is vertikaal en horisontaal gesentreer  Teksrigting is vertikaal in die tweede ry  Hoogte van die tweede ry is 3 cm  Eerste ry is gevul met ’n grys kleur  Omramings is soos in die voorbeeld ingevoeg 2.9 Formule in Tabel: =Count(Above) 1  “Sum” is verander na “Count” 2.10 Grafiek 2  Grafiek is geskuif na die korrekte posisie (“FEEDSTOCK” kolomme)  Teks vou om die grafiek 2.11 Skakel (“Hyperlink”) na boekmerk 1  Die woord “FIRST” is geskakel met die boekmerk “First”  Downloaded from hlayiso.com

(SEPTEMBER 2013) REKENAARTOEPASSINGSTEGNOLOGIE V1 3 1.10 Vervang (“Find and Replace”) voorvalle van “Thermo Rec” 3  Klein hoofletters  Buitelyn-effek en  “Thermo Rec” – albei woorde is deurgaans vervang 1.11 Kolomme 5  Teks vertoon in drie kolomme  Eerste kolom is 6 cm wyd  Tweede en derde kolom is 4.5 cm wyd  Vertikale lyne kom tussen die kolomme voor  Kolombreuke verseker dat elke paragraaf bo aan ’n nuwe kolom begin 1.12 Lynspasiëring 1  Hele dokument se lynspasiëring is 14 pt [37] Downloaded from hlayiso.com

2 REKENAARTOEPASSINGSTEGNOLOGIE V1 (SEPTEMBER 2013) VRAAG 1 Lêer: q1Thermo_Rec Nr. Kriteria Maks.  Punt 1. Maak die lêer q1Thermo_Rec oop 1.1 Paragraaf spasiëring 2  Paragraaf spasiëring gestel 10 pt/”2 lines”/0.35 na  hele dokument 1.2 Kantlyn 1  Regterkantlyn gestel op 1.3 cm vir die hele dokument 1.3 Uitleg van dokument 2  Volinlyn gestel – hele dokument  Outomatiese woordbreking “zone” verander na 0.5 cm 1.4 Opskrif: 8 WordArt/Fontworks  WordArt-styl 1 toegepas op “THERMO-REC”  3D Parallel-styl 1  “Curved Right Arrow” en ‘n “Curved Left Arrow” ingevoeg in die korrekte posisie  WordArt en pyle (“Arrows”) is gegroepeer  Saamgevoegde logo - 10 cm wyd  Saamgevoegde logo - 3 cm hoog  Saamgevoegde logo – Horisontaal gesentreerd  Relatief tot bladsy gesentreerd 1.5 Prent 5  Korrekte prent ingevoeg  Vertoon horisontaal gesentreerd  Omraming 3 pt wyd  Blou omraming  Prent se agtergrond is deurskynend (“transparent”) 1.6 Style 2  “Heading 2”-styl se fontkleur is verander na rooi  Die styl is gestel om outomaties op te dateer 1.7 Bladsynommering in die boskrif 3  Bladsynommering formaat is verander na a, b, c ens.  Verskillende “Odd and Even Pages” seleksie is afgehaal  Die bladsynommers verskyn in dieselfde formaat en is deurlopend op al die bladsye van die dokument 1.8 Vergrote hoofletter (“Drop Cap”) “T” 2  Vertoon in die kantlyn  Strek oor twee lyne 1.9 Watermerk 3  Spelling korrek, “Recycling”   Semi-deursigtig (“Semi-transparent”)  Vertoon diagonaal Downloaded from hlayiso.com

Province of the EASTERN CAPE EDUCATION NASIONALE SENIOR SERTIFIKAAT GRAAD 12 SEPTEMBER 2013 REKENAARTOEPASSINGSTEGNOLOGIE V1 MEMORANDUM PUNTE: 200 KANDIDAAT SE PUNTE KANDIDAAT NAAM VRAAG 1 2 3 4 5 6 7 TOTAAL MOONTLIKE PUNT 37 29 12 44 32 40 6 200 KANDIDAAT SE PUNT FINALE PUNT Hierdie memorandum bestaan uit 13 bladsye. Downloaded from hlayiso.com