Computer Applications Technology Grade 12 P1 2021 Memo (Eng)

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2021 COMPUTER APPLICATIONS TECHNOLOGY P1 MARKING GUIDELINE NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 MARKS: 150 27 17 46 35 17 08 This marking guideline consists of 12 pages.

Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) QUESTION 1 File Name: 1_World Literacy Day Total Q1: 27 Maximum Candidate No. Criteria Mark Mark 1.1.1 Cover Page 1 x Filigree cover page style selected. 9 1 1.1.2 Cover Page x Document name and date field typed. 9 1 2 x All other fields deleted. 9 1 1.2. Table of Contents x Heading 2 levels activated. 9 1 2 x Table of contents updated. 9 1 1.3 Page Numbering x Section breaks applied on the second page. 9 1 x First two pages not numbered. 9 1 3 x Numbering starts on page 3 at number 1. 9 1 1.4 Shading x Green Accent 6 shading applied 9 1 2 x to the whole paragraph. 9 1 1.5 Footnotes x Footnote inserted 9 1 x with explanation ‘America’s most trusted online dictionary for English word definitions, meanings 1 3 and pronunciation.’ 9 x Footnote inserted below text. 9 1 1.6 Picture formatting x Picture wrapped to tight or through. 9 1 x Picture right aligned. 9 1 3 x Picture set to height 3.5 cm and width 7.5 cm. 9 1 1.7 References x Placeholder 1 edited with a book source. 9 1 Book title: Practical guide to functional 1 3 literacy: a method of training for development. 9 1 x Published in 1973. 9 1.8 Find and Replace x Word ‘Literacy’ made bold. 9 1 x Only those occurrences in lower case are 2 changed. 9 1 (Only 5 changes) Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.9 Page Orientation x Section breaks applied. 9 1 2 x Only second last page in landscape. 9 1 1.10 Table Styles x Table style applied 9 1 x Table style Grid Table 4 Accent 6 9 1 3 x Text aligned both horizontally and vertically 9 1 1.11 Word Count x Words counted. 9 1 1 Total for QUESTION 1 [27] Copyright reserved Please turn over

Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) QUESTION 2 File Name: 2_Registration Form Total Q2: 17 Candidate No. Criteria Maximum Mark Mark 2.1 Margins x Top and bottom margins set. 9 1 1 2.2 Page x Double line page border 9 1 1 2.3 Picture x Picture centred 9 1 2 x A soft edge oval picture style applied. 9 1 2.4 Legacy Form tools x Field set to maximum length of 4. 9 1 2 x Text format set to uppercase. 9 1 2.5 Dropdown field x Male and Female options added. 9 1 x Help message inserted. 9 1 3 x Text “For accommodation purposes”. 9 1 2.6 Smart Art x A shape called Advanced added to Digital Literacy Course. 9 3 x Two shapes Coding and Internet added to 1 Advanced shape. 9 1 x Correct naming of shapes. 9 1 2.7 Linked Documents x The pdf file ‘Benefits-digital-literacy.pdf’ has been inserted 9 1 3 x as an embedded file. 9 1 x Shows as an icon. 9 1 2.8 Footer x The text, ‘Registration Form’ added in the footer. 9 1 2 x Text right aligned in the footer. 9 1 Total for QUESTION 2 [17] Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 3 File Name: Attendees Total Q3: 46 Maximum Candidate No. Criteria Mark Mark Attendee_Info worksheet 3.1.1 Cell formatting x Row merged from Cell A1 to X2. 9 1 1 3.1.2 Text Alignment x Headings aligned horizontally and vertically. 9 1 1 3.1.3 Freeze Panes x Rows 1 to 8 frozen 9 1 1 3.2 Date x =Today() 9 1 2 x Custom formatted to yyyy-mmmm-dd 9 1 3.3 B9 =IF(F9="M","Mr.","Ms.") 1 x Function: IF 9 3 1 x Argument set correctly 9 x Both true and false values are correct 9 1 3.4 S10 =COUNTIF(H10:R10,"X") x Function: Countif 9 1 3 x Range: H10:R10 9 1 x Criteria: ‘X’ 9 1 3.5 U11 Calculation =$V$7*S11 1 x Correct cells used 9 3 x Multiplication sign used 9 1 x Absolute cell reference applied correctly 9 1 3.6 V13 Calculation =U13*75/100 or U13 * 0.75 1 2 x U13 Correct cell used 9 x Correct calculation of a percentage 9 1 3.7 Conditional formatting Formula =$T9="No" Range =$D$9:$D$108 1 x Formula: =$T9="No" 9 OR =T9="No" 9 x Absolute cell reference applied to the range 9 1 3 x Range: =D9:D108 9 1 (Accept if column doesn’t have Absolute cell reference) Copyright reserved Please turn over

Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) Maximum Candidate No. Criteria Mark Mark 3.8 W9 =IF(S9<=5, "Greens", IF(S9<=8, "Blues", IF(S9<=10, "Reds","Yellows"))) 1 x Function: Nested IF 9 4 x Correct criteria: 9 1 x Value true and false set correctly 9 1 x Answer copied to other cells 9 1 3.9 X9 =IF(AND(T9="Yes",V9>=50), "Discount"," ") 1 x Function: IF and AND 9 x First criteria: T9= "Yes"9 1 4 x Second criteria: V9>=50 9 1 x True and False Value: "Discount"," " 9 1 3.10 G111 Date = YEAR(TODAY())-YEAR(G108) 1 x YEAR(TODAY()) 9 3 x - minus sign 9 1 x YEAR(G108) 9 1 3.11 G113 =HLOOKUP(Statistics!F1,Statistics!A1:K2,2,False) x Function: HLOOKUP 9 1 x Lookup_value: Statistics!F1 9 1 x Table_array: Statistics!$A$1:$K$2 9 5 x Row_index_num: 2, 9 1 x Range_lookup: False 9 1 (Ignore if Absolute cell reference was not used) 1 3.12 G115 =SUMIF(T10:T108,"Yes",U9:U108) 1 x Function: Sumif 9 x Range: T10:T108 9 1 4 x Criteria: “Yes” 9 1 x Sum range: U9:U108 9 1 Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 7 3.13 Graph x Chart area formatted with a background picture 1 3Digital Literacy 9 x Transparency set to 50% 9 1 x Budget and Typing a letter removed 9 1 x Using a filter 9 7 x A data callout label added 9 1 x To the most popular course (Know your smart 1 phone) 9 x Graph moved to a new worksheet Graph 9 1 1 Total for QUESTION 3 [46] Copyright reserved Please turn over

Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) QUESTION 4 File Name: 4_Digital literacy Total Q4: 35 Candidate No Criteria Maximum Mark Mark Table: Personal Information 4.1.1 Field: Date of Birth 1 3 x <9= 9 Now () 9 1 1 4.1.2 Course Code: Input Mask x > 9 1 x 999 9 1 x -9 4 1 x LLL 9 1 4.1.3 Field: Courses x Lookup wizard used as data type 9 1 x Database table used 9 3 1 x Course information 9 1 4.2 Form: Attendee Information =(Date()-[Date of Birth])/365 x Functions added to details section 9 1 x =(Date() - 9 1 x [Date of Birth]) 9 1 1 6 x /365 9 x Date changed to Fixed/Standard format with no 1 decimal places 9 1 x Suitable label added 9 QUERIES 4.3.1 Qry4_3_1 Field: Date of Birth x Between Date() 9 1 3 x And #2003/01/01# 9 1 x Sorted in descending of Level of Literacy 9 1 Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 9 4.3.2 Qry4_3_2 Data: [No of days to attend] *30 Field: Data Bundle <>Vodacom x <>Vodacom 9 1 x Calculated Field: Data: 9 1 x [No of days to attend] 9 1 6 x *30 9 1 x Total calculated in datasheet view 9 1 x Total function used to calculate the total amount. 9 1 REPORT 4.4 Report4_4 x Report created. 9 x Only show the Last Name, Date of Birth, Gender, No of Courses, Level of Literacy and No of days to attend fields. 9 1 x Grouped according to Gender. 9 1 x Grouped again according to Level of Literacy. 9 1 1 10 x Report set to Landscape. 9 1 x =Count 9 ([gender]) 9 OR =Count 9 (*) 9 1 1 x Appropriate descriptive label added. 9 1 1 x All data displays fully. 9 1 x Report saved as rpt4_4. 9 Total for QUESTION 4 [35] Copyright reserved Please turn over

Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) QUESTION 5 File Name: 5_Digital Literacy Total Q5: 17 x This question should be marked from the HTML code. x Numerical attribute values do not need to be in inverted commas. Maximum Candidate No Criteria Mark Mark 5.1 Background Colour <body bgcolor = "cream"><font face = "Arial"> x Tag bgcolor used 9 2 1 x Colour cream applied to whole website 9 1 5.2 Image <p><center> <img src = "5Digital Picture.png"> </center> </p> x Img scr corrected to img src 9 1 3 x Jpg corrected to png 9 1 x Center tag used to centre the picture. 9 1 5.3 Unordered Lists <ul type = “square” > </ul> 1 2 x <ul> </ul> tags used 9 1 x Type = square used correctly 9 5.4 Table <table border = "5" bgcolor = "pink" width = 70%> < td align = "center" colspan = "3"> <b>Let us be digital literate</b></td> x Table border set to “5 pt” 9 1 x Table width set to 70% 9 1 6 1 x Row 7 merged 9 1 x Across 3 columns9 1 1 x Text aligned centre and in 9 x bold 9 Copyright reserved Please turn over

Downloaded from hlayiso.com (EC/SEPTEMBER 2021) COMPUTER APPLICATIONS TECHNOLOGY P1 11 5.5 Links <p>For further digital literacy training, <a href="Brochure.pdf"> Click here for the brochure</a> 3 x Link created <a href 9 1 x To the correct file Brochure.pdf 9 1 x Inserted on the correct text 9 1 Closing tag(s) or triangular brackets and correct 1 1 nesting correctly used. Total for QUESTION 5 [17] Copyright reserved Please turn over

Downloaded from hlayiso.com 12 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2021) QUESTION 6 File Name: 6_Digital Technology in SA Total Q6: 8 6_Compare and 6_Compare 1 Maximum Candidate No. Criteria Mark Mark 6.1.1 Non-Breaking Space 9 x South Africa: a non-breaking space which prevents the automatic line break applied to the words “South Africa”. 1 1 6.2 Cut and Paste x Paragraph cut and pasted using “keep text only” 1 2 option. 9 1 x Cut and Pasted at the end of the document. 9 6.3 Track Changes x Two changes (Million and Million) accepted 9 1 1 6.4 Compare documents x Two documents compared (6_Compare and 6_Compare 1) 9 x Five (5) changes are shown in a screenshot 1 4 1 x Screenshot done 9 1 x Screenshot pasted at the end of 6_Compare 1 document. 9 Total for QUESTION 6 [8] TOTAL: 150 Copyright reserved Please turn over