CAT P1 June July 2015 Memo Eng hlayiso.com

Downloaded from hlayiso.com SENIOR CERTIFICATE EXAMINATION COMPUTER APPLICATIONS TECHNOLOGY P1 2015 MEMORANDUM/MARKING GUIDELINE MARKS: 180 FINAL MARK CENTRE NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 31 20 32 17 41 19 20 180 CANDIDATE MARK MARKER CODE/ SIGNATURE MODERATED MARK This memorandum/marking guideline consists of 14 pages. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER. QUESTION 1 File name: 1Brain_Brein Total Q1: 31 Maximum Candidate No. Criteria Mark Mark 1.1 Margins 1 • Left margin changed to 2.3 cm  1 1.2 Page numbers 3 • Automatic page numbering added  1 • Different odd and even pages set  1 • Even page numbers left aligned and odd page numbers right aligned  1 (Note to marker: Accept in header or footer.) 1.3.1 Styles 1 • 'MyQuotes' style applied to text  1 1.3.2 Citation 2 • Placeholder for citation added  1 • Placeholder named 'Quote'  1 1.4 Dropped cap 3 • Dropped cap applied to first letter of text 'Music's'  1 • Over four lines  1 • Font changed to 'Bell MT'  1 (Note to marker: Do not accept 'In margin'.) 1.5 Heading styles 1 • All Heading 3 styles replaced with Heading 5 style  1 (Note to marker: All 6 occurrences should be replaced.) 1.6 Picture 4 • Picture was horizontally flipped  1 • Picture wrapping changed so that picture does not block any text  1 • Picture moved to right of paragraph  1 • Paragraph alignment set to justified  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER 1.7 Cross-reference 3 • Cross-reference added to text 'Mozart' below heading 'The Power of Music on Memory and Learning'  1 • Cross-referenced to Figure 1  1 • Figure number does not display in cross-reference (The music of Wolfgang Amadeus Mozart)  1 1.8 Caption 2 • Automatic figure caption added to picture  1 • Caption reads 'George Frederic Handel'  1 (Notes to marker: • The figure number does not have to display. • Accept the caption above or below the picture.) 1.9 Hyperlink 3 • Hyperlink created on word 'Napoleon'  1 • Hyperlink links to 1Hist_Gesk document  1 • Text 'Read more' displays as screen tip  1 (Note to marker: Allocate second mark if icon or link was pasted and links to 1Hist_Gesk.) 1.10 Book source 3 • Source inserted  1 • Book source selected  1 • Correct fields completed  1 1.11 Endnote ('Laurence O-Donnell III') 4 • Endnote inserted  1 • Any symbol inserted as custom mark  1 • Endnote text appears as 'Copyright 1999 by Laurence O'Donnell'  1 • Comment deleted  1 (Notes to marker: • Do not accept a number instead of a symbol as custom mark unless the number was inserted as a symbol. • Ignore if text was copied or moved. • Accept if endnote was added on or in proximity of text. • Do not allocate last mark if only text was deleted from the comment.) 1.12 Automatic bibliography 1 • Automatic bibliography inserted  1 (Notes to marker: • Book source added in 1.10 should appear. • Allocate mark if automatic bibliography was inserted even if no sources appear.) Total for QUESTION 1 [31] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 2 File name: 2Piece_Stuk Total Q2: 20 Maximum Candidate No. Criteria Mark Mark 2.1 WordArt/Fontwork 4 • WordArt/Fontwork applied to 'Music' text  1 • Filled with red colour  1 • Outlined with black colour  1 • Font size changed to 48 pt  1 2.2 Indenting 2 • First line indenting applied  1 • Set to approximately 2 cm  1 2.3 Columns 4 • Two columns applied to selected text  1 • Size of first column is 13 cm  1 • Spacing between columns set to 3 cm  1 • A border appears around the columns  1 2.4 Line numbers 2 • Line numbers added to document  1 • 'Restart each page' selected  1 (Note to marker: Accept if line numbers only appear on first page.) 2.5 Pagination 2 • Widows and orphans checked  1 • Keep lines together checked  1 2.6 Picture 2 • Picture moved to correct position  1 • Picture changed to fit in with the rest  1 2.7 Watermark 3 • Picture watermark added  1 • Picture 2Notes_Note used  1 • Watermark appears only on page 3 of document  1 2.8 Page colour 1 • Page colour changed to any shade of orange  1 (Note to marker: Accept if only one page's colour has been changed.) Total for QUESTION 2 [20] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 3 File name: 3Stats 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 answers. • Named ranges can be used instead of cell references. Maximum Candidate No. Criteria Mark Mark Data worksheet 3.1 Cells A1:B2: 1 • Picture 3Music_Musiek inserted into range A1:B2  1 3.2 Cells C1:O2: 1 • Any fill colour applied to cells  1 3.3 Cell A3: 2 • Comment added to cell  1 • Text 'Sales on 1 Jan 2015' added to comment  1 (Note to marker: Accept if any text is added to comment.) 3.4 Cell P2: 2 • Custom format  1 • Date format dd/mmm/yyyy  1 3.5 Cell B3: 1 • Text wrapped  1 3.6 Cell A4: 5 =UPPER(D4&RIGHT(F4,2)) OR =UPPER(CONCATENATE(D4, RIGHT(F4,2))) OR =UPPER(D4&MID(F4,LEN(F4)-1,2)) • UPPER  1 • D4  1 • RIGHT OR MID  (F4,2)  2 • & or CONCATENATE used correctly  1 Expected answer: MP3LY. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER 3.7 Cell I4: 3 =YEAR($P$2)-H4 • YEAR function  1 • $P$2  1 • - H4  1 Expected answer: 5 3.8 Cell K4: 5 =J4*125/100*114/100 OR =(J4+(J4*25/100))*114/100 OR =(J4+(J4*25/100))+((J4+(J4*25/100))*14/100) OR =1.25*J4*1.14 • Original price  1 • Calculation of profit  1 • Profit added to old price (selling price)  1 • Calculation of VAT  1 • Addition of VAT price and profit amount (selling price) 1  (Notes to marker: • Accept any other correct answer. • Also accept =(J4+(J4*25/100))+(J4+(J4*14/100)).) 3.9 Cell M4: 5 =VLOOKUP(L4,Status!$A$1:$B$4,2,TRUE) • VLOOKUP  1 • L4  1 • Status!$A$1:$B$4 (correct range/name range)  1 • Absolute cell referencing correctly used  1 • 2 1 (Note to marker: TRUE can be omitted.) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER 3.10 Column O: 5 =IF(N4>300,"High",IF(N4>=200,"Moderate","Low")) OR =IF(N4>=301,"High",IF(N4>199,"Moderate","Low")) OR =IF(N4>300,"High",IF(AND(N4>=200,N4<=300), "Moderate","Low")) OR =IF(N4<200,"Low",IF(AND(N4>=200,N4<=300), "Moderate","High")) OR =IF(N4<200,"Low",IF(N4<=300),"Moderate","High")) OR =IF(N4>300,"High",IF(N4<200,"Low","Moderate")) • Nested IF-construct implemented (no syntax errors)  1 • ‘High' correctly displayed for bitrate greater than 300  1 • ‘Moderate' correctly displayed for bitrates of 200 – 300  1 • ‘Low' correctly displayed for bitrates lower than 200  1 • Function copied to cells below  1 (Note to marker: • Check for correct use of conditional options. There are many alternative answers, one of which could be a VLOOKUP. • Penalise once for logical errors.) 3.11 Column P: 2 • Data validation list option 'No' added to the list  1 • Applied to column P  1 (Note to marker: Accept if only applied to some cells in column P.) Total for QUESTION 3 [32] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 4 File name: 4Sum_Ops Total Q4: 17 • 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. Maximum Candidate No. Criteria Mark Mark Sum_Ops worksheet 4.1 Cell E5: 1 =Sum(D5:D7)  1 Expected answer: 11. (Note to marker: Accept D5+D6+D7 or any correct alternative answer.) 4.2 Cell D2: 5 =COUNTIF(Data!A4:A71,A2)- COUNTIF(Data!A4:C42,C3)-COUNTIF(Data!A4:C42,C4) 1 OR 1 =COUNTIF(Data!A4:A71,"7Digital")-D3-D4 1 1 • Function/Formula to count  1 • Range matching function/formula  • Correct criteria based on the selected range  • Exclude other type of files in calculation  • Exclude other stores or type of product in calculation Expected answer: 34. (Note to marker: There are many alternative answers (e.g. =COUNTIFS(Data!A4:A71,"7Digital", Data!C4:C71,"MP3")). Evaluate candidate's answer against criteria and ensure that the answer will remain correct even if the data changes.) 4.3 Cell B13: 3 =SUMIF(Data!C4:C71,A13,Data!G4:G71) • Data!C4:C71  1 • A13 OR "MP3"  1 • Data!G4:G71 1 Expected answer: 29047704. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER Graph_Grafiek worksheet 4.4 Graph/Chart 8 • Graph/chart changed to column  1 • Title '7Digital' added  1 • Vertical axis interval set to 1  1 • Maximum value  1 1 • Vertical axis set to 12  1 • Format of vertical axis changed to currency  1 • Horizontal axis labels alignment changed to 90°  1 • 'Moving average' trend-line added  Total for QUESTION 4 [17] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 5 File name: 5Music_Musiek Total Q5: 41 Maximum Candidate No. Criteria Mark Mark Table: TMusic_TMusiek 5.1.1 Column width 1 • Column widths changed of Title_Titel and Artist_Kunst fields so that all text is visible  1 5.1.2 Field: Code_Kode 1 • Moved to appear as first field  1 (Note to marker: Code_Kode field can appear first in Design view OR Datasheet view.) 5.1.3 Field: Code_Kode 2 • All data from 5Code_Kode  1 • Data appears for Code_Kode field  1 5.1.4 Field: Artist_Kunst 1 • Required property set to Yes  1 5.1.5 Field: Type_Tipe 2 • Type_Tipe field is lookup field  1 • Values: MP3, CD, DVD  1 (Note to marker: Accept if only one value was entered.) 5.1.6 Field: Genre 4 • Validation Rule Validation rule inserted  1 1 Criteria Rock, Pop, Dance  1 OR correctly used  • Validation text Accept only Rock or Pop or Dance  1 (Notes to marker: • Accept any validation text that refers to the values that may be used. • Accept if only one value was inserted.) 5.1.7 Field: Demand_Aanvraag 1 • Data type changed to Yes/No  1 5.1.8 Field: Owner_Eienaar 5 Input mask • > 1 • L 1 • 00  2 • 9 OR #  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER Form: frm5_2 5.2.1 Form created 3 • Form frm5_2 using TMusic_Musiek created  1 • Columnar layout  1 • All fields included  1 5.2.2 Background colour 1 • Artist_Kunst label changed to any other colour besides the default  1 5.2.3 Date and Time 2 • Date and Time fields inserted  1 • In form footer  1 Query: qry5_3 5.3 • Only Title_Titel, Artist_Kunst, Year_Jaar and 4 Owners_Eienaars fields are displayed  1 Criteria: • Demand_Aanvraag field: Yes, True, -1, <> False  1 • Owners_Eienaars field: H*  1 Sort: • Artist_Kunst: sorted in descending order  1 (Notes to marker: • Expect 19 records. • Criteria for Demand_Aanvraag will depend on 5.1.7.) Query: qry5_4 5.4 • Calculated field IncCost: added correctly  1 4 • [Cost_Koste] *2 OR [Cost_Koste]+ [Cost_Koste] 2 • Field displayed in rand format  1 (Note to marker: Accept any currency format.) Report: rpt5_5 5.5.1 • Report shows only Title_Titel, Artist_Kunst, 3 Type_Tipe, Genre and Cost_Koste fields  1 • Report grouped according to the Genre field  1 • Report sorted (descending) according to the Type_Tipe field  1 5.5.2 • Title of report 'Songs by Genre'  1 2 • Title is centred or label is centred horizontally  1 5.5.3 • Function in group footer or group header  1 3 • = Sum  ([Cost_Koste])  2 5.5.4 • Conditional formatting: Cost_Koste greater than 2 100 , displayed in orange font colour  2 (Note to marker: Accept if applied to the function.) Total for QUESTION 5 [41] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 6 File name: 6Facts_Feite Total Q6: 19 • This question should be marked from the browser as far as possible, unless otherwise indicated or if it cannot be seen on the browser. • A maximum of 1 mark will be deducted if one or more closing tags are omitted. • The code of the candidates who use a word processor will contain additional unnecessary tags. Markers will need to work through the code to check for the answers provided below. Maximum Candidate No. Criteria Mark Mark 6.1 Title 1 <title>Facts_Feite</title> • Title tags for 'Facts_Feite' added to header section  1 6.2 Table row 3 <td width="50" height="25" bgcolor="grey"><center>Background</center></td> • Additional table cell inserted with 'Background'  1 • In correct position  1 • Appears exactly as the other cells (width, height, colour)  1 6.3 Font 2 <font face ="Forte" size =6></font> • Font changed to Forte  1 • Font size set to 6  1 6.4 Heading 1 <h3>Why do we like certain types of music?</h3> • Heading style 3 tags inserted for text 'Why do we like certain types of music?'  1 6.5 Paragraph alignment 1 align="center" • Second paragraph aligned to centre of page  1 (Note to marker: Accept 'center' tag.) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 13 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER 6.6 Bulleted list 3 <ul Type="circle"> <li>Studies showed the connection between music lessons and an improved memory</li> <li>Children engaged in music showed higher verbal ability </li> </ul> • Unordered list  1 • Correct 2 list items  1 • Type of bullet is circle  1 6.7.1 Image 2 img src="6Therapy_Terapie.jpg" • Image 6Therapy_Terapie.jpg inserted  1 • Image displays correctly  1 6.7.2 Image height and width 2 width="300" height="200" • Width = 300  1 • Height = 200  1 6.7.3 Alternative text on image 1 alt="Therapy" • Alternative text is 'Therapy'  1 6.8 Hyperlink 3 <a href="google.com">To read more</a> • Text 'To read more' entered  1 • Link added to text <a href … 1 • Linked to Google.com  1 Closing tag(s) or brackets omitted -1 Total for QUESTION 6 [19] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 14 DBE/2015 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 7 Total Q7: 20 File names: 7News_Nuus, 7Letters_Briewe Maximum Candidate No. Criteria Mark Mark 7.1 Bullets 2 • Bullet changed to 'Q'  1 • Indenting changed to match others  1 (Note to marker: Ignore if 'Answers' are also bulleted.) 7.2 Table 6 • First row merged  1 • Text centred horizontally and vertically  1 • Third row deleted  1 • Outer borders are double lined  1 • Inner borders are dashed  1 • Font of last row changed to 'Small caps'  1 (Note to marker: Accept any broken line/dashed/dotted inner borders.) 7.3 Form field controls 2 • Check box size changed to 10 pt  1 • Text box form field inserted next to 'Give us your feedback'  1 7.4 Footer 5 • Text 'Editor' added in footer  1 • Left aligned  1 • Date of modification field added  1 • Right aligned  1 • Horizontal line appears  above text 1 (Note to marker: Ignore if horizontal line appears below text.) 7.5 Merge 5 • Clients_Kliënte table in 7Names_Name database used as data source  1 • Clients sorted in descending order  according to 1 their surnames  1 • Name_Naam and Surname_Van merge fields added 1 • Mail merge completed and saved as 7Letters_Briewe  (11 letters expected) 1 Total for QUESTION 7 [20] TOTAL 180 Copyright reserved