Computer Applications Technology Grade 12 P1 2013 Memo

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 12 COMPUTER APPLICATIONS TECHNOLOGY P1 NOVEMBER 2013 MEMORANDUM/MARK SHEET MARKS: 200 FINAL MARK CENTRE SPEED WPM NUMBER ENDORSEMENT EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 21 41 40 22 45 25 6 200 CANDIDATE MARK MARKER CODE/ SIGNATURE MODERATED MARK This memorandum/mark sheet consists of 20 pages. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER QUESTION 1 File name: 1Aware_Bewus Total Q1: 21 No Criteria Max Mark Candidate Mark 1.1 Paper size 1 • Paper size is set to A5  or any other size 1 1.2 Page orientation 1 • Page orientation is landscape  1 1.3 Page border 3 • Page border appears  1 • 3 pt shadowed  page border 2 (Note to marker: • Accept if the page border obscures the table slightly.) 1.4 Text wrapping 1 • Text wrapping of the layout (in the Format AutoShape dialog box) is set to 'behind text' /'send behind' 1 (MSOffice [MSO]) ('To background' – LibreOffice [LO]) (Note to marker: • Accept any other valid wrapping/formatting method that displays the hidden word 'NOW'/'now' still within the starburst/explosion shape.) 1.5 Grouping 1 • Four circles are grouped as one object  1 1.6 Text box 4 • Text box is inserted  1 • 2 pt  dashed border line  2 • The text 'Don't be part of the problem! Be part of the solution!' appears in the text box  1 (Note to marker: • Accept any non-solid line. • Do not allocate the 4th mark if the text was copied and not moved.) 1.7 Font 1 • 'Treat others as ... when socialising online' appears in italics  1 (Note to marker: • Accept these 6 words above or whole sentence.) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER 1.8 Spell Checker 1 • Spelling error 'inapproriate' is corrected to 'inappropriate'  1 (Note to marker: • Ignore spelling of 'cyberbullied'.) 1.9 Indentation 1 • Indent level of the bulleted list is decreased  1 (Note to marker: • Check that bulleted list is aligned against the left border of the 2nd cell in the 2nd column. • Check that indentation level is less than 0.63) 1.10 Column 3 • Table has a third column  1 • Heading 'What do you ... being bullied online?' appears in heading/first row of the third column  1 • Text 'Don't forward messages...' to '... report the bullying.' appears in the second row of the third 1 column  (Note to marker: • Ignore if third column is not bulleted.) 1.11 Table 1 • Table is resized to fit across the page  1 (Note to marker: • Ignore second empty/blank page.) 1.12 Cell alignment 1 • Cell alignment of the first row of the table is set to Align Centre  (vertically and horizontally centred) 1 1.13 Hyperlink 2 • Hyperlink inserted on text which links to the website  1 • Screen tip (MSO) 'Internet search' added to the hyperlink /'Mouse over Object' (LO) 1 (Note to marker: • Ignore spelling errors in screen tip and URL. • Open the footer to see the screen tip - mouse-over to see the screen tip • LibreOffice: Hyperlink should appear as 'Internet Search' linking to the given web address.) Total for QUESTION 1 [21] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER QUESTION 2 File name: 2Bully_Boelie Total Q2: 41 Candidate No Criteria Max Mark Mark 2.1 Margins 1 • Bottom page margin set to 2 cm  1 (Note to marker: • Ignore all other margins.) 2.2 WordArt/Fontwork 2 • 'Cyberbullying' placed in WordArt/Fontwork  1 textured fill  1 (Note to marker: • MSO 2010 – Accept texture as a background fill. • LibreOffice – 'n Bitmap texture is used.) 2.3 Find and Replace 1 • All occurrences of 'cyber bullying' replaced with 'cyberbullying'  1 (Note to marker: • Find 'cyber bullying' (as two words) to check a nil return.) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER 2.4 Table of Contents 5 • Automatic Table of Contents inserted  1 • 2 levels of headings appear  (Heading 1 and 1 Heading 2) • Page numbers  with no tab leader  appear 2 • No Hyperlinks  appear 1 How is it different to face-to-face bullying? 4 How do I deal with it? 4 What do you do if your friend is being bullied online? 4 Parents and teens can do come things that help reduce the cyberbullying statistics: 5 Cyberbullying Statistics 6 The Harford County Examiner reported similarly concerning cyberbullying statistics: 6 The Cyberbullying Research Center also did a series of surveys that found these cyberbullying statistics: 7 (Note to marker: • Check in the Available Styles in the TOC options that only Heading 1 and Heading 2 are selected. • Ignore if the text <Insert table of contents here> still appears. • Accept with or without the words 'Contents' or 'Table of Contents' and • Accept TOC anywhere in the document. • LibreOffice users need to apply a Table of Contents style such as Contents 1 or Index.) 2.5 Paragraph borders and shading 3 • 1½ pt shadowed border  2 • Greenish shading (highlight) 1 (Note to marker: • Mark in the formatting pane.) 2.6 Shapes 6 • Rounded rectangular callout shape is inserted  1 • The shape must be exactly 2 cm high  and 10 cm 1 wide  1 • The text 'Stand up and speak out!' appears inside the shape  1 • The text must be Arial Black  16 pt  2 (Note to marker: • Ignore text alignment. • Ignore if the original text still appears. • Ignore spelling errors.) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER 2.7 Watermark 3 • Section break inserted/different first page 1 • The section break in the header is unlinked to the previous section/watermark appears from page 2 onwards  1 • 2Logo_Logo used as a watermark  1 2.8.1 Justification 1 • Body text is fully justified  1 (Note to marker: • Allocate this mark if all or some of the body text 'Cyberbullying is ...' to '... consider suicide' is fully justified.) 2.8.2 Columns 3 • All text 'Interpretation: Cyberbullying is ...' to '... consider suicide'  appears in 2 equal columns  2 • Spacing between columns is set to 0.5 cm /14 pt 1 2.9 Drop Cap 3 • Drop Cap effect is applied to 'I'  of 'Interpretation' at 1 top of page 3 • Over 4 lines  1 • 0.5 cm/14 pt from text  1 (Note to marker: • Accept position of Drop Cap as Dropped or In margin.) 2.10 Page numbering 4 • Automatic page numbering has been inserted  (in 1 any format) • In the footer of the document  1 • First page is not numbered  1 • Second page starts at number 1  1 2.11 Paragraph spacing of paragraph under the sub- 3 heading 'Cyberbullying can take many forms:' • Paragraph spacing set to 10 pt/0.35 cm before  1 • Line spacing is set to exactly  26 pt/0.92 cm  2 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER 2.12 Bookmark 1 • Bookmark Stats links to text 'How do I deal with it?'  1 (Note to marker: • Click on bookmark and Go To to check that Stats bookmark link works. • Accept: Bookmark inserted on all or part of the text.) 2.13 Endnote 4 • Endnote  set on main heading of 'CyberBullying 1 Statistics'  1 • The web address is used as the text  (mouse-over) 1 • Text of the website does not appear twice in the document  1 2.14 Bullets 1 • Bullets changed to Webdings #151 (MSO) or U+F097 (LO):  symbol  1 Total for QUESTION 2 [41] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER QUESTION 3 File name: 3Schools_Skole Total Q3: 40 • Mark the questions from the formulae and not the values/answers in the cell. • Check against candidate's actual work. (The cell reference may differ depending on the candidate's response). • Candidate may use multiple formulae or cells as 'building blocks' to answer the questions. No Criteria Max Mark Candidate Mark 3.1 Sheet1 deleted 1 • Sheet1 has been deleted/does not appear  1 Policy_Beleid worksheet 3.2.1 Cell colour 1 • Merged cells A1:H1 filled with a reddish colour  1 3.2.2 Merge 1 • Cells A2:H2 merged  1 (Note to marker: • Accept if cells A1: H2 are merged.) 3.2.3 Font colour (Row 2) 2 • Font colour of the merged cells A2:H2 is white  1 • Heading is left aligned  1 3.2.4 Cell border (Cells A1:H2) 3 • Double line  1 • Outside border only  1 • Around cells A1:H2  1 (Note to marker: • Do not allocate the mark for the outside border if inside borders between cells are visible. • LO: check settings or enlarge the screen view.) 3.2.5 Column width 1 • Column F is 8 or 61 pixels wide  /1.6 cm (Calc) 1 3.3 Cell G4 2 =2013 – D4 • Correct cells  1 • Subtraction sign  1 (Note to marker: • Also accept: =2013 – D4 + 1) • Also accept =E4–D4 (Accept with/without absolute referencing) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER 3.4 Cell H4 = IF(F4="Yes","*","") 3 or Cell H4 = IF(F4<>"Yes","","*") or Cell H4 = IF(F4>="Yes","*","") or Cell H4 = IF(F4>"Yes","","*") or Cell H4 = IF(F4="No","","*") • Condition F4 = "Yes"  1 • True value "*"  1 • False value ""  1 (Note to marker: • Accept if a space was added for a blank cell.) 3.5 Columns hidden 1 • Columns I and J hidden  1 3.6 Cell M4 = ROUND(AVERAGE(G4:G51),1) 4 • Function ROUND  1 • Function AVERAGE  1 • Correct range (G4:G51)  1 • Number of digits rounded to (1)  1 3.7 Cell M6 = COUNTA(A4:A51) 2 or Cell M6 = COUNTA(B4:B51) or Cell M6 = COUNTA(C4:C51) or Cell M6 = COUNT(I4:I51) or Cell M6 = COUNT(J4:J51) • Function COUNTA  or COUNT 1 • Correct range  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER 3.8 Cell M8 3 = COUNTIF(F4:F51,"Yes") or = COUNTIF(C4:C51,"Yes") or = COUNTIF(H4:H51,"*") or = COUNTA(H4:H51) (Award 3 marks) or = COUNTIFS(C4:C51,"Yes", F4:F51, "Yes") • Function  1 • Correct range  1 • Correct criteria  1 (Note to marker: • Award only 2 marks if candidates did not use a function but the formula =M6 – M7.) 3.9 Chart/Graph (Source: Cells L1:M2) 6 • 3-D bevel/realistic format (on chart/chart area, top/bottom)  Doughnut chart/graph created  placed 2 across cells K15:N30  1 • Heading appears above the chart/graph  1 • Doughnut hole is approximately 20% (MSO)  /Object 1 borders are applied in 3-D view (LO) (Note to marker: Check the Format Selection in MSO to mark the Doughnut Hole Size.) • Category names appear as labels (legend) in 1 segments of chart/graph  Newest_Nuutste worksheet 3.10 Cell K1 = Hoërskool Superior  1 1 (Note to marker: • Accept anywhere in column K.) Codes_Kodes worksheet 3.11 Cell C4 = LEFT(A4,2) 2 or Cell C4 = MID(A4,1,2) • Function LEFT  1 • Cell A4 and 2 characters  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER 3.12 Cell D4 = MID(B4,3,2) 4 • Function MID  1 • Correct cell B4  1 • Start at character 3  and copy 2 characters  2 3.13 Cell G5 = UPPER(CONCATENATE(C5,D5,E5)) 3 • Function UPPER  1 • Function CONCATENATE  OR & between elements 1 • Correct cells: C5,D5,E5  1 Total for QUESTION 3 [40] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER QUESTION 4 File name: 4Report_Aanmeld Total Q4: 22 • Mark the questions from the formulae and not the values/answers in the cell. • Check against candidate's actual work. (The cell reference may differ depending on the candidate's response). • Candidate may use multiple formulae or cells as 'building blocks' to answer the questions. No Criteria Max Mark Candidate Mark Learners_Leerders worksheet 4.1 Tab colour 1 Tab colour applied to Learners_Leerders worksheet  (other than the default) 1 4.2 Conditional formatting: Column G 4 • Conditional formatting applied  1 • To cells containing the text 'Y'  1 • Light greyish fill colour  1 • Greenish border  1 4.3 Nested IF in cell E2 4 = IF(D2>17,"C",IF(D2 < 15,"A","B")) or =IF(AND(D2>=15,D2<=17),"B",IF(D2<15,"A","C")) • Condition: D2<15 is in group A 1 • Condition: D2>17 or >=17 is in group C  1 • Condition: all others (15, 16 or 17) are in group B  1 • Nested IF-construct is correctly used  1 4.4 VLOOKUP 3 Cell J2 =VLOOKUP(H2,Data_Data!$A$4:$F$51,6) • LOOKUP Value: H2  1 • Table array: Data_Data!A4:F51  1 • Column index number: 6  1 (Note to marker: • Can ignore range lookup or ignore if False value has been added. • Do not penalise if absolute cell addressing has not been used. • Accept if heading was included in range, i.e. A3.) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 13 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER 4.5 Cell M4 4 = M3/M2*100 or = M3/M2% or = M3/M2 and then format as % • Correct cells (M3 and M2)  1 • Division sign  1 • Multiplied by 100 /percentage symbol appears 1 • Cell only formatted to show one decimal place  1 (Note to marker: • Do not allocate mark if the ROUND function was used. • Accept if candidate calculated two percentages and added together to get an answer of 97%) 4.6 Chart/Graph 6 • The chart/graph is a column chart  1 • The value of the data labels appear at the top  of the 1 'Reported Aangemeld' column only  1 • The major unit on the Y-axis is 9 units  1 • The Y-axis title reads from top to bottom  1 • The longest column has a gradient fill  1 Total for QUESTION 4 [22] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 14 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER QUESTION 5 File name: 5Cyber_Kuber Total Q5: 45 No Criteria Max Mark Candidate Mark Table: 51School_Skool 5.1.1 Field: Schoolnum_Skoolnom 1 • Required/Entry required property is set to "Yes"  1 (Note to marker: Do not accept Primary Key.) 5.1.2 New field 4 • Visit_Besoek field inserted  1 • After the Province_Provinsie field  1 • Data type changed to Date/Time  1 • Date/Time format changed to Long Date format  1 5.1.3 Field: NumLearners_GetalLeerders 4 • Validation Rule >249  and  <2501 OR >=250 and <=2500 3 or Between 250 and 2500 (one mark for 'between', one mark for 'and' and one mark for upper and lower boundaries) • Validation text Enter a number from 250 to 2500  1 (Note to marker: • Accept any suitable message that contains the bounds for the number to be entered.) LibreOffice: Mark allocation shown as  • NumLearners  Form control  Data  Filter Filter  Condition 1 >=250  Condition 2 <=2500  NumLearners  Control Help text: Enter a number between 250 and 2500  (Note to marker: Accept any suitable message that contains the bounds for the number to be entered.) 5.1.4 Field size/type: Ratio_Verhouding 2 • Double  1 • Decimal places set to 1 1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 15 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER Query: Qry52 5.2 • Query exists and is based on 52Type_Tipe table  1 2 • Criterion: Reported_Aangemeld field: Is Null  1 (Expect 15 records) Query: Qry53 5.3 • Displays only Name_Naam, Surname_Van and 4 Grade_Graad fields  1 Criteria: • Gender_Geslag field : F  1 • Grade_Graad field : 11 or 12 1 • Rumours_Gerugte field: Yes  or True 1 (Note to marker: With reference to the 3rd bullet also accept >=11; >10; >=11 and <=12, etc.) (Expect 11 records) Query: Qry54 5.4 • Calculated field caption/alias is Calc54  1 5 • Grade_Graad field sorted  1 • Descending  1 • Totals shown (results displayed) 1 • Per Grade  1 Form: frmType_Tipe 5.5 • Form background changed to a reddish colour  1 6 • Heading/text box is centred  1 • Border around the heading is a solid line  1 • Combo box/Drop down list added  (Not a list box) 1 • M and F appear in the list  1 • Image moved to form footer /bottom (LibreOffice) 1 (Note to marker: • Accept if only one section of the background has a reddish colour. • Do not accept if the edit box is appears together with the drop down list/combo box.) Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 16 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER Report: MyReport 5.6 • Report called MyReport is created  1 5 • Report is based on Qry56  1 • Report shows only Name_Naam and Surname_Van fields  (Accept with Grade_Graad field showing.) 1 • Report grouped/sorted according to the Grade_Graad field  1 • The heading 'Bullying'  appears 1 Report: rptType_Tipe 5.7 • StatsID_StatsID field deleted  1 12 • Page orientation changed to landscape  1 • 'Name_Naam' heading resized to display all text  1 • Name_Naam field resized to display all text  1 • In group footer  or group header 1 = sum  ([Rumours_Gerugte])  2 (Note to marker: • Expected answer for the first group = 6. • Ignore a negative answer.) • In report footer  1 Function: Count  1 Field: [Reported_Aangemeld]) 1 • Examination number appears in a label in the page 1 footer  1 (Note to marker: • Accept if the header StatsID_StatsID remains.) Total for QUESTION 5 [45] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 17 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER QUESTION 6 File names: 6Data_Data, 6Statistics_Statistiek, 6Spreadsheet_Sigblad, 6Ready_Gereed, 6Merge_Saamvoeg Total Q6: 25 No Criteria Max Mark Candidate Mark 6Data_Data document 6.1 Numbered list 1 • Items below the question appear as an automatic numbered list, i.e. numbers 1 to 4  1 (Note to marker: • Accept numbering in any format with or without a full stop or bracket.) 6.2 Field: Age_Ouderdom 3 • Text form field control inserted  1 • Next to/in line with Age_Ouderdom field  1 • Data type set to number  1 6.3 Drop-down field control: Gender_Geslag 2 • 'Select one_Kies een' added as an additional option  1 • Appears as the default (first) option  1 6.4 Tab setting 2 • Left tab is set at 8 cm  1 • Form fields, drop-down items and check boxes are all aligned  at the tab setting 1 6.5 Alignment of the shape 1 • Shape appears at the top of the page 1 6.6 Date and Time field 2 • Date and time field added  (Accept any date/time 1 format) • At the bottom of the document/in a footer  1 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 18 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER 6Ready_Gereed/6Merge_Saamvoeg 6.7 Merge 7 • Name_Naam and Surname_Van fields appear  1 • Name and surname fields right aligned  with a letter 1 space between  1 • Reported_Aangemeld field filter is equal to Parents_Ouers  1 • Grade_Graad field filter is equal to 10  1 • Gender_Geslag field filter is equal to M  1 • Merge completed  (6Merge_Saamvoeg) 1 6Statistics_Statistiek 6.8.1 • Bullying Statistics and Cyberbullying Statistics 1 appears as two tables  1 (Note to marker: The second table could appear on the second page.) 6Spreadsheet_Sigblad 6.8.2 • 6Spreadsheet_Sigblad contains the Bullying 2 Statistics table  1 • Pasted as a link (Red font changes from Q6.8.3 1 reflect/updated in 6Spreadsheet_Sigblad) (Note to marker: • Allocate the mark only if any one complete table appears. • Click on File to check the Paste links.) 6Statistics_Statistiek and 6Spreadsheet_Sigblad 6.8.3 • The non-percentage data appears in a red font  in 1 1 the 6Statistics_Statistiek document. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 19 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER 6.8.4 • Table with primary school statistics appears  in 1 3 6Statistics_Statistiek (Accept 1 or 2 primary schools) • Table heading 'Primary Schools'  appears in the 1 table • Table appears (embedded/linked) in Sheet2 in 1 6Spreadsheet_Sigblad (Note to marker: • Allocate the 3rd mark irrespective of the heading appearing or not.) Total for QUESTION 6 [25] Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology/P1 20 DBE/November 2013 NSC – Memorandum EXAMINATION NUMBER QUESTION 7 File names: 7Age_Ouderdom, 7Count_Telling, and Exam_Eksamen folder Total Q7: 6 Candidate No Criteria Max Mark Mark 7.1 • The folder called Exam_Eksamen  appears 1 1 (Note to marker: • Do not allocate the mark if MyFolder_MyLeergids still appears. • Accept if only Exam or Eksamen or their examination number was used to rename the folder.) 7.2 (Note to marker: Ignore this question.) 7Count_Telling document 7.3 • Doc2_Dok2  1 3 • Size on disk: 188  KB /192 512 bytes 2 (Note to marker: • Check the size on disk on the candidate's actual file.) 7.4.1 • Word 'bully' in all word forms is highlighted (in any 1 1 colour)  7.4.2 • 53 times  1 1 Total for QUESTION 7 [6] GRAND TOTAL [200] Copyright reserved