CAT P1 MEMO GR12 SEPT 2022 English_hlayiso.com_.pdf

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2022 COMPUTER APPLICATIONS TECHNOLOGY P1 MARKING GUIDELINE NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 MARKS: 150 31 10 43 35 20 11 This marking guideline consists of 10 pages.

Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2022) QUESTION 1 File Name: 1_Social Networks Total Q1: 31 Maximum Candidate No. Criteria Mark Mark 1.1 New Style • Media Style created ✓ 1 • Size set to 17 pt. ✓ 1 4 • Paragraph spacing set to 18 After ✓ 1 • Style applied to the first heading ✓ 1 1.2 Drop Cap • Dropped cap applied on ‘S’ ✓ 1 3 • Applied over 2 lines ✓ 1 • Distance 0.2 cm from text ✓ 1 1.3 Footnote • Footnote added on social media ✓ 1 3 • Wingdings  (character 70) inserted ✓ 1 • Footnote text is ‘https://www.investopedia.com’ ✓ 1 1.4 Citation • Type of source: Film ✓ 1 3 • Title: The Social Networks ✓ 1 • APA Style used ✓ 1 1.5 Proofing Language • Set to English South Africa ✓ 1 1 (For the whole document) 1.6 Widow and Orphan • Widow and Orphan set on the paragraph ✓ 1 1 1.7 Bullets • 1_SN.jpg used as a bullet ✓ 1 2 • Bullets aligned to centre ✓ 1 1.8 Columns 1 • Paragraph changed to two columns ✓ 1 3 • Columns have a line in between ✓ 1 • Column break inserted ✓ 1.9 Multi-level list 1 • Level 1 Applied ✓ 1 • Set to 1 cm ✓ 1 4 • Level 2 Applied ✓ 1 • Set to 2 cm ✓ 1.10 Page Numbering • Arrow 1 Style applied ✓ 1 • Different First page applied ✓ 4 1 • Different odd ✓and 2 • Even numbers applied ✓ 1.11 Hyperlink • Hyperlink applied to the text “Back to the top” ✓ 1 2 • Place in this document “Top of the Document” ✓ 1 1.12 HideText • Text hidden ✓ 1 1 Total for QUESTION 1 [31] Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/SEPTEMBER 2022) COMPUTER APPLICATIONS TECHNOLOGY P1 3 QUESTION 2 File Name: 2_Flyer Total Q2: 10 Maximum Candidate No. Criteria Mark Mark 2.1 SmartArt • SmartArt modified to Cycle Diverging Radial ✓ 1 1 2.2 Edit text • All text added as it is in the picture ✓ 1 1 2.3 Picture • Correct picture inserted ✓ • In the centre of the SmartArt ✓ 1 1 5 • Picture size 2.5 cm x 2.5 cm ✓ 1 • Lock aspect ratio unchecked ✓ 1 1 • Picture style set to soft edge oval ✓ 2.4 Shapes • Any shape fill (colour) used ✓ 1 • Blue shape outline inserted ✓ 1 3 1 • Outline weight of 2¼ pt. ✓ Total for QUESTION 2 [10] Copyright reserved Please turn over

Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2022) QUESTION 3 File Name: 3_Survey Total Q3: 43 Maximu Candidate No. Criteria m Mark Mark Summary worksheet 3.1.1 Row 1 and Row 2 • Row 1 and 2 Merged from cell A1:U2. ✓ 1 1 3.1.2 Alignment • Heading must be horizontally and vertically centred ✓ 1 1 3.1.3 Fill colour • Background standard green. ✓ 1 1 3.1.4 Font colour • Font colour of the heading changed to white ✓ 1 1 3.2 Wrapping • Cell S4 Wrapped ✓ 1 1 3.3 Customise Date : Column D • Date changed to format dd-mm-yyyy ✓ 1 2 • Contents copied to all cells in column D ✓ 1 3.4 Cell E5 =INT(($E$3-D5)/365.25) • =INT ✓ • (($E$3-D5) ✓ 1 3 • /365.25) ✓ 1 or: TRUNC( .... ) 1 or: ROUNDDOWN( .... , 0) 3.5 Cell F5 =CONCATENATE(C5,".",LOWER(LEFT(B5,1)),"@school.za") • =CONCATENATE ✓ 1 4 • (C5,".", ✓ 1 • LOWER(LEFT(B5,1)), ✓ 1 • "@school.za") ✓ 1 3.6 Cell N6 =IF(AND(G5="WhatsApp", H5="Facebook"), "Old Users", "New Users") • IF AND function correctly used ✓ 1 4 • First criteria correct ✓ 1 • Second criteria correct ✓ 1 • Both value true and value false are correct ✓ 1 Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/SEPTEMBER 2022) COMPUTER APPLICATIONS TECHNOLOGY P1 5 3.7 4 Column P: Conditional Formatting • Cells Value equal to $P$10 (Watch Videos) ✓ 1 • Applies to =$P$5:$P$54 ✓ 1 • Filled with red ✓ 1 • Thin horizontal crosshatch pattern ✓ 1 3.8 Cell O5 =IF(COUNTIF(L5:N5,"Yes"),"Online Safety Course"," " ) • Function :IF ✓ 1 • Countif range: L5:N5 ✓ 1 5 • Countif criteria: ,"Yes" ✓ 1 • Value true correct: “Online Safety Course” ✓ 1 • Value true correct: " " ✓ 1 3.9 Cell S56 =MODE(S5:S54) 1 2 • Function : Mode ✓ 1 • Correct Range: (S5:S54) ✓ 3.10 Cell U5 Calculate deficit per learner =T5-S5 • Cell T5 and S5 ✓ 1 • Minus sign ✓ 1 Cell S58 6 =SUMIF (Q5:Q54,"MTN”, U5:U54) 1 • Function: Sumif ✓ 1 1 • Criteria Range: Q5:Q54 ✓ 1 • Criteria: MTN ✓ • Sum range ✓ 3.11 Graph Worksheet 1 • Chart title is centred ✓ 1 • Chart title inserted with correct text ✓ 1 • Legends correct ✓ 1 • Data labels are callout ✓ 1 8 • Point explosion only at MTN ✓ 1 • Point explosion set at 30% ✓ 1 • Plot area filled with gradient fill ✓ 1 • Sheet 1 renamed to Graph ✓ Total for QUESTION 3 [43] Copyright reserved Please turn over

Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2022) QUESTION 4 File Name: 4_LearnerSurvey Total Q4: 35 Maximum Candidate No. Criteria Mark Mark Table: Registrations table 4.1.1 Field: Input Mask: <LLL\ - >LL? • Lower letters: < ✓ 1 • LLL – three compulsory letters ✓ 1 5 • - hyphen ✓ 1 • > upper case LL two compulsory letters ✓ 1 • ? optional letter ✓ 1 4.1.2 Gender Field 1 • Combo field added. ✓ 2 1 • List values added: Male and Female. ✓ 4.1.3 CellNo: • Indexed property = Yes (No Duplicates) ✓ 1 1 4.1.4 Registration Date • >= ✓ 1 2 • #2021/10/01# ✓ 1 4.1.5 Default Values Default value = Yes ✓ 1 1 4.2 Form: frm4_2 • Background colour of the Detail section changed to any colour. ✓ 1 1 3 • Text in the CellNo field is distribute-aligned. ✓ • The Pledge textbox changed to Pledge. ✓ 1 4.3 Qry4_3 • Query Criteria CellNo: 083* ✓ 1 • Query Criteria Education: Class Groups ✓ 1 • Add Totals function ✓ 1 5 • Choose sum to add the amounts ✓ 1 • Sort in ascending order of surname ✓ 1 Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/SEPTEMBER 2022) COMPUTER APPLICATIONS TECHNOLOGY P1 7 4.4 Qry4_4 1 • Criteria for CellNo field: Is Null ✓ • Criteria for Type of users field: Old users ✓ 1 Calculation: Balance: ([Pledge])-([Pledge])*15/100 1 • New field Balance: created. ✓ 6 • Correct calculation of 15% deduction ✓ 1 • Correct subtraction of the 15% ✓ 1 • Red alternate row colour applied to the query ✓ 1 (Expect 6 records) 4.5 Rpt4_5 • Report is created with the following fields: Name, 1 Surname, CellNo, Pledge and Education ✓ 1 • Report is grouped according to Pledge field. ✓ 1 • Report sorted in ascending order of surname field ✓ 1 • =Count([Code]) or Count ✓ (*) ✓ 1 10 • in the Pledge footer. ✓ 1 • Calculation in the Pledge footer ✓ 1 • Sum ✓ ([Pledge]) ✓ 1 • Total amount in Rand format ✓ 1 • Save report as rpt4_5. ✓ 1 Total for QUESTION 4 [35] Copyright reserved Please turn over

Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2022) QUESTION 5 File Name: 5_Social Networks Total Q5: 20 • 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. Maximum Candidate No. Criteria Mark Mark 5.1 Title <title>Popular Social Networks</title> • Title tag added to the text Popular Social Networks’ to appear on the browser ✓ 1 1 5.2 Heading: Popular Networks for Children <center><h1> <font color = red>Popular Networks for Children </font> </h1> </center> 1 2 • Heading centred ✓ • Font colour changed to red ✓ 1 5.3 Bulleted list <ol type = "I"> • Correct tag used : type = I ✓ 1 3 • Uppercase Roman figures used ✓ 1 • Tags inserted: <li>creating online profiles</li> ✓ 1 5.4 Table <table border="1" width = "500" cellspacing = "5"> • Set the width of the table to 500 ✓ 2 1 • Set the cell spacing to 5 ✓ 1 5.5 Table <tr bgcolor = "Yellow"> • Background of colour of row 1 set to yellow ✓ 1 1 5.6 Image <img src="5_WhatsApp.png" width = 30 height = 30> 1 3 • Tag img src used ✓ 1 • Correct picture used ✓ 1 • Width and height set to 30 ✓ Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/SEPTEMBER 2022) COMPUTER APPLICATIONS TECHNOLOGY P1 9 5.7 Horizontal line <hr size = "10" color = "red"/> • Line size set to 10 ✓ 1 2 • colour set to red ✓ 1 5.8 Formatting <h2><b><i>Further Reading</b></i> </h2> 1 <h2> </h2> ✓ 2 1 <b><i> </b></i> ✓ 5.9 Link a href = <"https://raisingchildren.net.au/teens/entertainment- technology/digital-life/social-media"> Click here </a> 1 • <a href> </a> ✓ 3 1 • Link created on the text ‘Click here’ ✓ 1 • Link opens link provided ✓ Closing tag(s) or triangular brackets and nesting 1 1 correctly used. Total for QUESTION 5 [20] Copyright reserved Please turn over

Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2022) QUESTION 6 File Name: 6_Analysis and 6_Survey form Total Q6: 11 Maximum Candidate No. Criteria Mark Mark 6.1.1 Remove duplicates • Duplicates removed ✓ 1 3 • Only 50 records are left ✓ 1 1 • Cell E104 : Removed Duplicates ✓ 6.1.2 Cell C4 =time(9,130,0) • Correct function used: Time ✓ 3 1 • Start time and Minutes ✓ 1 1 • Answer in time format ✓ 6.2 Survey form • ‘Name’ Text form field inserted ✓ 1 • ‘Name’ Text form field Text format: Uppercase ✓ 1 • Drop down form field ‘TikTok’ added ✓ 1 • Check box form field inserted ✓ to replace 5 1 symbols • Yes checked ✓ 1 Total for QUESTION 6 [11] TOTAL: 150 Copyright reserved Please turn over