Computer Applications Technology Grade 12 P1 2023 Memo (Eng)

NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2023 COMPUTER APPLICATIONS TECHNOLOGY P1 MARKING GUIDELINE NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 MARKS: 150 27 13 44 31 21 14 This marking guideline consists of 10 pages.

2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2023) QUESTION 1 File Name: 1_10 biggest dams in South Africa Total Q1: 27 Maximum Candidate No. Criteria Mark Mark 1.1.1 Textbox • Text box inserted. ✓ 1 3 • Filled with gradient fill. ✓ 1 • Linear down fill used. ✓ 1 1.1.2 Textbox/Size • Height = 3 cm and width = 15 cm ✓ 1 1 1.1.3 Textbox/Border 1 • Textbox border red ✓ 2 1 • and 3pt ✓ 1.2 Find and replace • All occurrences of ‘Mzansi’ replaced by South Africa 1 2 (2 occurrences) ✓ 1 • South Africa is in small caps ✓ 1.3 Captions • Caption inserted ✓ 1 • New label ‘Picture’ created. ✓ 1 4 • Caption displays below the picture. ✓ 1 • The other two pictures have captions with label 1 Picture 2 and Picture 3 ✓ 1.4 Style 1 • Style modified to be bold ✓ 2 1 • Style modified to font size 19 ✓ 1.5 Paragraphs • Heading, image and paragraph together moved to 1 2 next page. ✓ 1 • Keep with next checked ✓ 1.6 Citation 1 • Website source used ✓ 1 3 • Name of website added ✓ 1 • URL added ✓ 1.7 Synonym • Beach, shore, coastline, seashore or oceanfront 1 1 replaced shoreline ✓ 1.8 Watermark 1 • ‘Top dams in SA’ changed to any WordArt ✓ 1 3 • Button (Curve) shape used ✓ • Font type changed to Arial Narrow. ✓ 1 1.9 Page numbering ` • Circle page numbering used ✓ 1 • On the footer ✓ 1 4 • Odd pages set on left ✓ 1 • Even pages set on right ✓ 1 Total for QUESTION 1 [27] Copyright reserved Please turn over

(EC/SEPTEMBER 2023) COMPUTER APPLICATIONS TECHNOLOGY P1 3 QUESTION 2 File Name: 2_Brochure Total Q2: 13 Maximum Candidate No. Criteria Mark Mark 2.1 Page Colour 1 • Brochure filled with any colour ✓ 1 3 • Brochure filled with two colour gradient fill ✓ 1 • Red and Orange are colours used ✓ 2.2 Picture 1 • The other picture is deleted/replaced. ✓ 1 3 • Picture replaced with ‘2_Logo’ picture. ✓ • The image is stretched to fill the space provided. ✓ 1 2.3 Controls 1 • SA Dams inserted in the company name control ✓ 1 2.4 Date 1 • Date field inserted ✓ 2 1 • Formatted MMMM yyyy ✓ 2.5 SmartArt • SmartArt inserted ✓ 1 • Basic Pie Relationship SmartArt used ✓ 1 3 • The three names of the dams inserted in the 1 SmartArt ✓ 2.6 Font • Font of ‘3 Sterkfontein Dam’ paragraph is changed 1 1 to be like the first two paragraphs ✓ Total for QUESTION 2 [13] Copyright reserved Please turn over

4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2023) QUESTION 3 File Name: 3_Dams Total Q3: 44 Maximum Candidate No. Criteria Mark Mark 3 _Dams Worksheet 3.1 Cells A1:N2 1 • Cell A1 to N2 merged and ✓ 2 1 • data centred vertically ✓ 3.2 Cell A3 1 1 • =Now() ✓ 3.3 Cell A5: =CONCATENATE(D5;LEFT(B5;3);RANDBETWEEN 1 (100;999)) • Concatenate function ✓ 1 5 • D5 ✓ 1 • Left(B5;3) ✓ • Randbetween function ✓ 1 • (100;999) ✓ 1 3.4 Cell C56 =SMALL(C5:C54;1) 1 3 • Correct function used. Small ✓ 1 • Correct range used – C5:54 ✓ ;2 ✓ 1 3.5 Cell F58: =COUNTIF(F5:F54; "Eastern Cape") 1 3 • Correct function used ‘Countif’ ✓ 1 • Correct range (F5:F54) ✓ 1 • Correct criteria ‘Eastern Cape’ ✓ 3.6 Cell H6 Countifs 1 =COUNTIFS(F5:F54;"Free State";H5:H54;">500") 1 • Function: Countifs ✓ • Criteria range 1 : F5:F54 ✓ 1 5 • Criteria 1 : “Free State” ✓ 1 • Criteria range 1 : H5: H54 ✓ • Criteria 2 : ‘>500” ✓ 1 3.7 Cell J62 Sumif =SUMIF(F5:F54;"Eastern Cape";J5:J54) 1 • Sumif function used ✓ 4 1 • Criteria range : F5 : F54 ✓ • Criteria : “Eastern Cape” ✓ 1 • Sum range : J5:J54 ✓ 1 Copyright reserved Please turn over

(EC/SEPTEMBER 2023) COMPUTER APPLICATIONS TECHNOLOGY P1 5 3.8 Cell J64 Nestedif statement 1 =IF(J5>4000000;"BIG DAM";IF(J5<1000000;"SMALL DAM";"NORMAL DAM")) 1 • Nested if function used ✓ 1 5 • Criteria 1: J5>4000000 ✓ • Criteria 2: J5<1000000 ✓ 1 • Correct output: for both criteria ✓ • Criteria output if false ✓ 1 3.9 Conditional formatting 5 • Conditional formatting feature use ✓ 1 1 • Correct formatting style: Icon Sets ✓ 1 • Correct Icon style: 3 Symbol uncircled indicator ✓ 1 • Icon if value greater than 80 ✓ 1 • Icon if value less than 40 ✓ 3.10 Subtotal • Applied to “Province” ✓ 1 3 1 • Function: Average ✓ 1 • Add subtotal to Capacity field ✓ 3.11 Graph • Correct data used ✓ 1 • 3D Column Clustered graph used ✓ 1 • Column Shape cone used ✓ 1 • Axis title named correctly ✓ 1 8 • Chart title named correctly ✓ 1 • Chart area fill done ✓ 1 • Correct picture (3_Map of SA Dams) used to fill 1 chart area ✓ 1 • Moved to new sheet called My Graph ✓ Total for QUESTION 3 [44] Copyright reserved Please turn over

6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2023) QUESTION 4 File Name: 4_SA Top 50 Dams Total Q4: 31 Maximum Candidate No. Criteria Mark Mark Table: Magazine Compilers 4.1.1 • Field size for Surname field set to 50 ✓ 1 1 4.1.2 • Vertical gridlines are visible. ✓ 1 1 4.1.3 • IDNO field set to required Yes ✓ 1 1 4.1.4 • E-mail field set to < in format field ✓ 1 1 4.1.5 Input mask on the Password field: LL-009-"WORD" • LL ✓ 1 • -✓ 1 • 00 ✓ 1 6 1 • 9✓ 1 • -✓ 1 • “WORD” ✓ 4.2.1 • Conditional formatting ✓ 1 • Applied to the Capacity field ✓ 1 3 • All values less than 3 Million display in a red font ✓ 1 4.2.2 • Function inserted in the form footer ✓ 1 2 • Displays the current date =date() ✓ 1 4.3 Qry4_3 • Date field inserted ✓ 1 4 • Date field does not show ✓ 1 • Criteria for Date field – “<1970” ✓ 1 • Criteria Eastern Cape in Province field ✓ 1 Expected answer: 3 records 4.4 Qry4_4 1 • Add a totals function ✓ 1 3 • Group by Dam field ✓ 1 • Sum by Capacity field ✓ Copyright reserved Please turn over

(EC/SEPTEMBER 2023) COMPUTER APPLICATIONS TECHNOLOGY P1 7 4.5 Report 1 • Report created called rpt4_5 ✓ 1 • Dam, Province, River and Capacity fields ✓ 1 • Grouped according to the Province field ✓ 1 • Sort according to River field ✓ 1 9 • Calculation in the Province footer ✓ • =sum ([Capacity_10³ m³]) ✓ 1 • In report footer ✓ 1 • =count(*) ✓ 1 • Labels removed ✓ 1 Total for QUESTION 4 [31] Copyright reserved Please turn over

8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2023) QUESTION 5 File Name: 5_Dams Total Q5: 21 Maximum Candidate No. Criteria Mark Mark 5.1 <title> Big dams in South Africa </title> 1 1 • Title tag inserted ✓ 5.2 <center><h1>The Big Dams</h1></center> • Heading 1 applied to the text ✓ 1 2 1 • Text centred ✓ 5.3 Background colour <body bgcolor = “pink”> 1 1 • Entire web page background is pink ✓ 5.4 <hr color = "green"/> • hr/ tag used ✓ 1 2 • Colour of the line set to green ✓ 1 5.5 <img src = "5_Dam Picture.jpg" height = "200" width = "200" align = "right"> • Correct picture used ✓ 3 1 • Both height and width set at 200 ✓ 1 • Picture aligned to the right ✓ 1 5.6 List • Change the unordered list tag (ul) to ordered list 1 1 tag (ol) ✓ Copyright reserved Please turn over

(EC/SEPTEMBER 2023) COMPUTER APPLICATIONS TECHNOLOGY P1 9 5.7 Table <table bgcolor = yellow width = "100%" border = "3"> <tr bgcolor = "green"> <th>1 No</th> <th>Name of Dam </th> <th> Town </th> <th>Capacity 10³ m³ </th> </tr> <tr> <td>1</td> <td>Free State dam</td> <td>Norvals Point</td> <td>5342932 </td> </tr> <tr > <td> 5</td> <td>Pongolapoort</td> 6 <td>Pongola</td> <td>2267068</td> </tr> </table> • Table border = 3 ✓ 1 • Table width set at 100% ✓ 1 1 • Cellspacing = 5 ✓ 1 1 • Free state dam replaced with Gariep ✓ 1 • Header row filled with green and ✓ • rest of table filled with yellow ✓ 5.8 Links <a href = "5_Dam Picture.jpg"> About the picture </a> • Hyperlink inserted ✓ 1 4 • Hyperlink tag used – a href ✓ 1 1 • To correct text – About the picture ✓ 1 • Links to the correct picture 5_Dam Picture.jpg ✓ Closing tag(s) and nesting correctly used ✓ 1 1 Total for QUESTION 5 [21] Copyright reserved Please turn over

10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2023) QUESTION 6 File Name: 6_Certificate of Achievement Merge’ document ‘6_Merge Spreadsheet Total Q6: 14 Maximum Candidate No. Criteria Mark Mark 6.1.1 Shapes • Wave shape replaced ✓ 1 1 • Replaced by basic sun shape ✓ 1 4 • Alt text of picture is Shape ✓ 1 • Alt description is Basic Sun Shape ✓ 6.1.2 Tabs stops • First tab stop o Position at 4 cm and alignment right ✓ • Second tab stop 1 5 o Position at 19 cm and alignment left ✓ 1 • Third tab stop 1 1 o Position at 24 cm and no alignment right ✓ 1 • Leader for first ✓ and second stops : Solid line ✓ 6.1.3 Merge letters • Mail Merge feature used ✓ • Surname and name fields replaced ✓ 1 1 • Only learners who were regulars in attending 1 meetings received letters. ✓ 5 1 • Correct data source used – ‘6_Merge Spreadsheet’ ✓ 1 • Merged letters saved as 6_Merged ✓ (8 certificates) Total for QUESTION 6 [14] TOTAL: 150 Copyright reserved Please turn over