CAT P1 MEMO GR12 SEPT 2025 ENG_watermark.pdf

NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2025 COMPUTER APPLICATIONS TECHNOLOGY P1 MARKING GUIDELINE NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: QUESTION Q1 Q2 Q3 Q4 Q5 Q6 Q7 TOTAL MARKS 35 10 30 10 35 15 15 150 CANDIDATE MARK MODERATED MARK This marking guideline consists of 17 pages.

2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2025) QUESTION 1 File Name: Q1 Rugby Total Q1: 35 No Criteria Maximum Candidate Mark Mark 1.1 BoxSmart Heading: Removed the highlighting from the heading Boxsmart on 1 1 the 2nd last page. ✓ 1.2 Table of contents: 1 RR1 Style applied to the legacy heading. ✓ 2 Table of contents updated. ✓ 1 1.3 Behavior under the heading The Journey Begins. Spelling setting for the word changed to English (South 1 1 Africa). ✓ (Original was English United States). 1.4 Citation under the heading The Journey Begins. 1 1 3 Text replaced with correct citation (Smith, John). ✓ Reference to page 10 added. ✓ 1 Year suppressed. ✓ 1.5 Paragraph under the heading Building the Culture. Sorted in descending order. ✓ 1 1 Copyright reserved Please turn over

(EC/SEPTEMBER 2025) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.6 Word Stadium under the heading Rapid Expansion and success: Word “stadium” replaced with any synonym listed 1 1 below: arena, ground, field, ring, pitch. ✓ 1.7 Hidden text under the heading Rapid Expansion and Success: Hidden text removed. ✓ How to mark: Inspect document for issues. No hidden text detected. 1 1 1.8 Style 1 Style created called Ball1. ✓ 4 Based on heading style 1. ✓ 1 Font colour changed to purple. ✓ Style applied to After Math. ✓ 1 1 1.9 Picture under the heading looking Ahead 1 Crop to heart shape. ✓ 1 3 Saturation 20%. ✓ Drop Cap Added. ✓(Dropped 3 lines) 1 1.10 Find and replace. 1 Find non-breaking space (^s). ✓ Replaced with *✓ 2 3 Replacements made. 1 Copyright reserved Please turn over

4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2025) 1.11 Textbox under the heading Jack Stonebridge (Fly- half). 1 Text moved into the text box. ✓ Highlight removed from the text. ✓ Link created between two textboxes. ✓ 1 3 1 (Note to marker: Click on first text box to see if link has been inserted.) 1.12 Table under the heading Liam Hawthrone 1 (Scrum-half) Row inserted at the top and Text typed in correctly. ✓ Merged cells. ✓ 1 Alignment of headings center and middle. ✓ Season text direction changed. ✓ 1 5 Tackles column formula: MAX(ABOVE). ✓ 1 1 Copyright reserved Please turn over

(EC/SEPTEMBER 2025) COMPUTER APPLICATIONS TECHNOLOGY P1 5 1.13 Paragraph under the heading Ethan Lockhart (Center). 1 Indentation Left ±1 cm. ✓ Indentation Right ±2 cm. ✓ First line indent ±1 cm. ✓ 1 (Note to marker: Must be within 0.2 cm) 3 1 1.14 Header of the document. 1 Q1Logo Picture added. ✓ Field name inserted and uppercase. ✓ 1 3 (Alt+F9: {FILENAME \* Upper \* MERGEFORMAT} Last page header reading Raptors Index. ✓ 1 1.15 Index on the last page. Run-in type index inserted. ✓ 1 One column. ✓ 2 (NOTE: r indicates run-in index inserted) 1 Total for QUESTION 1 [35] Copyright reserved Please turn over

6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2025) QUESTION 2 File Name: Q2Song Total Q2: 10 No Criteria Maximum Candidate Mark Mark 2.1 Page layout. 1 1 Page size A4. ✓ 2.2 Page border. Solid line border added ✓ 1 3 pt solid line ✓ 2 (Note to marker: Must be a solid border around the 1 whole page.) 2.3 Track changes. Accepted change. ✓ 1 1 (2024 added to “Compiled by Jordan Pieterse”). 2.4 Tab stops: ±3cm left. ✓ 1 ±9cm right. ✓ Solid leader. ✓ 1 3 (Note to marker: No mark awarded if a manual line is inserted.) 1 2.5 Anthem. 1 Line numbering added ✓ to the anthem only. (Not heading or compiled by A 1 3 Pieterse) ✓ Line numbering restarts on each page. ✓ 1 Total for QUESTION 2 [10] Copyright reserved Please turn over

(EC/SEPTEMBER 2025) COMPUTER APPLICATIONS TECHNOLOGY P1 7 QUESTION 3 File Name: Q3Games Total Q3: 30 No Criteria Maximum Candidate Mark Mark BattleStats Worksheet 3.1 Cell A1: 1 1 Vertical alignment changed to Middle. ✓ 3.2 Column R: 1 1 Size changed to 10. ✓ 3.3 Column B: Surname appears in column B. ✓ 1 1 (Note to Marker: No function allowed) 3.4 Cell C2: =COUNTIF(G5:G53,">100") 1 =COUNTIF(G5:G53 ✓ 2 ">100" ✓ (Note to marker: Correct range and criteria one mark) 1 EXPECTED ANS: 43 3.5 Cell C3: 1 =COUNTBLANK(K5:K53) ✓/✓COUNTA(A5:A53) ✓ (Note to marker: Cell formatted to Percentage, if a 1 3 learner also *100. The learner loses the 1st mark). (Check for building blocks) 1 EXPECTED ANS: 75.51% 3.6 Cell H2: =SMALL(P5:P53,2) ✓ 1 (Note to marker: one mark for correct range and 2 Small). 1 EXPECTED ANS: 2 Copyright reserved Please turn over

8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2025) 3.7 Cell H3: 1 =SUMIFS(D5:D53,C5:C53,"Canada",J5:J53,">60") Sumifs ✓ 1 Sum range: D5:D53 ✓ 1 Criteria range 1: C5:C53 ✓ 6 Criteria 1: “Canada” ✓ 1 Criteria range 2: J5:J53 ✓ Criteria 2:”>60” ✓ 1 (Check for building blocks) 1 EXPECTED ANS: 18 3.8 Cell Q5: =VLOOKUP(O5,FitnessTable!$A$2:$B$7,2,TRUE) 1 VLOOKUP ✓ O5 ✓ Correct table ✓ Column index number 2 ✓ 1 FitnessTable!$A$2:$B$7 (Absolute cell referencing used on table) or named range used correctly ✓ Or nested if 1 =IF(O5>=FitnessTable!A7,FitnessTable!B7,IF(O5>=FitnessT 5 able!A6,FitnessTable!B6,IF(O5>=FitnessTable!A5,FitnessTa ble!B5,IF(O5>=FitnessTable!A4,FitnessTable!B4,IF(O5>=Fit nessTable!A3,FitnessTable!B3,IF(O5>=FitnessTable!A2,Fitn 1 essTable!B2)))))) Nested if used. ✓ Correct Logic test used for at least 1 condition. ✓ Correct Logic test used for all conditions. ✓ 1 Correct outcome for at least 1 condition. ✓ Correct outcomes for all 6 conditions. ✓ (Check for building blocks) Copyright reserved Please turn over

(EC/SEPTEMBER 2025) COMPUTER APPLICATIONS TECHNOLOGY P1 9 3.9 Cell R6: 1 =IF(OR(C6="Canada",C6="South Africa"), IF(L6=0,IF(HOUR(I6)>=3,"Yes","No"),"No"),"No") 1 OR =IF(OR(C6="Canada",C6="South Africa"), 1 IF(L6=0,IF(I6>TIME(3,0,0),"Yes","No"),"No"),"No") OR ✓ 1 Correct use of logic test for 1st condition. ✓ 7 (C6="South Africa”,C6="Cananda") 1 Correct use of logic test for 2nd condition. ✓ L6=0 1 Correct use of logic test for 3rd condition. ✓ (I6>TIME(3,0,0) Function used for 3 hours (Check for buidling blocks). ✓ 1 Correct output for true ✓ and false. ✓ 3.10 Double worksheet Freeze Pane: First three rows. ✓ 1 2 First two columns. ✓ 1 Total for QUESTION 3 [30] Copyright reserved Please turn over

10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2025) QUESTION 4 File Name: Q4_Detail Total Q4: 10 No Criteria Maximum Candidate Mark Mark General worksheet 4.1 Cell I3: =G3=H3 1 1 =H3 ✓ (=G3 was given) 4.2 Conditional Formatting: Applied to column A. ✓ 1 Formula: =E3:E12>=LARGE($E$3:$E$12,3). ✓ OR =E3>=LARGE($E$3:$E$12,3). Red fill applied. ✓ 1 3 1 4.3 Cell M3: 1 =UPPER(CONCATENATE(RIGHT(B3,1), LEFT(C3,RANDBETWEEN(1,LEN(C3))),F3)) 1 OR =UPPER(RIGHT(A3,1)&LEFT(C3, 1 RANDBETWEEN(1,LEN(C3))))&F3 6 1 UPPER and CONCATENATE or & used. ✓ RIGHT and B3 and 1. ✓ 1 LEFT and C3. ✓ RANDBETWEEN and 1. ✓ Len and C3. ✓ 1 F3. ✓ Total for QUESTION 4 [10] Copyright reserved Please turn over

(EC/SEPTEMBER 2025) COMPUTER APPLICATIONS TECHNOLOGY P1 11 QUESTION 5 File Name: Q5Ridgeview Total Q5: 35 No Criteria Maximum Candidate Mark Mark Tbl5_1 Datasheet view 5.1.1 Text formatting dialog box of table: Border to column header underline. ✓ 1 dots. ✓ 2 1 5.1.2 Record of Christiano Cubbin: Record Christiano Cubbin deleted. ✓ 1 1 (3rd record in original data). 5.1.3 Table: Table sorted form smallest to largest according to year 1 1 joined. ✓ 5.1.4 Date field: Data type changed to Date/Time. ✓ 1 2 Format: Short date. ✓ 1 5.1.5 RUGBY Boots (Pair) field: Validation rule: Between 1 and 10 ✓ 1 OR 1 >=1 and <=10 OR >0 and <11 5.1.6 Position field: Input mask: 0 ✓9 ✓ OR 90 1 2 1 Copyright reserved Please turn over

12 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2025) 5.2 Qry5_2: Display First Name field only ✓ 1 Passport: True/Yes/On ✓ Police Clearance: True/Yes/On ✓ Travel Mode: A ✓ 1 4 1 (32 Records EXPECTED) 1 5.3 Qry5_3: NewDonate: [Donated]+500 New Field called NewDonate. ✓ 1 [Donate] ✓ +500. ✓ Format to display in South Africa rand. ✓ 1 All the forwards <=8 or <9 ✓ OR between 1 and 8 5 1 1 (47 Records EXPECTED) 1 Copyright reserved Please turn over

(EC/SEPTEMBER 2025) COMPUTER APPLICATIONS TECHNOLOGY P1 13 5.4 Qry5_4: Totals activated in design view. ✓ 1 Swopped columns around. (Jersey colour first) ✓ Count any field. ✓ 1 3 1 5.5 Frm5_5: 1 Both label and field of position moved to the header section. ✓ 1 Label renamed to Preferred position. ✓ Surname field italics. ✓ 1 Text box below line properties changed to visible yes. ✓ Salary field widened. ✓ 1 Value list inherited from the table ✓ 8 1 Q5Picture picture inserted. ✓ With a thick black border. (Mark by inspection) ✓ 1 1 1 5.6 Rpt5_6: 1 New label added New Adjusted Salary. ✓ 1 Label inserted in the page header. ✓ Label Bold. ✓ 1 6 Textbox moved from the grouped footer to the detail 1 section. ✓ (The textbox is already formatted to currency 1 and no border.) Formula in textbox =[Salary ✓] *1.1 ✓ 1 Total for QUESTION 5 [35] Copyright reserved Please turn over

14 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2025) QUESTION 6 File Name: Q6_1Home, Q6_2Open, Q6_3Info, Q6_4Rugby Total Q6: 15 No Criteria Maximum Candidate Mark Mark 6.1.1 Q6_1Home: 1 1 Two or more <br/> ✓ added above the table. 6.1.2 <tr bgcolor ✓ = "red" ✓> 1 2 1 6.1.3 Comment added to MainPage <!—MainPage--> ✓ 1 1 6.1.4 <a href="Q6_4Rugby.html">About</a></th> 1 1 .html added. ✓ 6.2.1 Q6_2Open: 1 1 <h2> ✓ Player Spotlight: Jane Doe </h2> 6.2.2 <ol> <li>Blue Team </li> 1 <ol> ✓1. <li>Ethan "Lightning" Faulkner</li> <li>Jake "Ironclad" Marlowe</li> ✓2. (Both) 1 </ol> 1. <ol> inserted </li> 2. <li>Jake 4 <li>Red Team</li> "Ironclad" <ol> ✓3. Marlowe</li> 1 <li>Marco "Rock" Mason</li> 3. <ol> inserted <li>Mason "Crusher" Reid</li> 4. </ol> inserted </ol> ✓4. 1 </ol> 6.2.3 <th colspan ✓ =”3” ✓>Rugby Club</th> 1 2 1 6.3.1 Q6_3Info: Tab browser: 1 1 <title>Contact Us Raptors</title> ✓ Copyright reserved Please turn over

(EC/SEPTEMBER 2025) COMPUTER APPLICATIONS TECHNOLOGY P1 15 6.3.2 <img src = “Q6_3Pic.jpeg” width = “200” height = “300” alt = Logo of Raptor/> 1 1 “Q6_3Pic.jpeg” Added. ✓ Correct use of tags and triangular brackets. 1 1 Total for QUESTION 6 [15] Copyright reserved Please turn over

16 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2025) QUESTION 7 File Name: Q7Red, Q7Graph, Q7Warning, Q7Screenshot, Q7Founders Total Q7: 15 No Criteria Maximum Candidate Mark Mark 7.1 Q7Red: Filter applied. ✓ 1 To the Red card = 2. ✓ 2 1 7.2 Page layout dialog box sheet. Comments set to display at end of sheet. ✓ 1 1 7.3 Q7Graph: Paste the pie chart yellow card in the Q7Graph document. ✓ 1 As a link. ✓ 2 Alt F9: 1 7.4 Q7Warning: Less than equal to ✓ 5 ✓ 1 OR Less than 6 1 4 Q7ScreenShot: 1 Circle invalid data selected. ✓ Screenshot taken and pasted in Q7ScreenShot. ✓ 1 7.5 Q7Warning: 1 1 Author: Name and surname added as the author. ✓ Copyright reserved Please turn over

(EC/SEPTEMBER 2025) COMPUTER APPLICATIONS TECHNOLOGY P1 17 7.6 Q7Founders: Cover Page: 1 • Ridgeview raptors added to document title. ✓ • Content control cannot be deleted ticked. ✓ 2 1 7.7 Q7Founders: 1 Caption under founding members: Caption founder used. ✓ 1 3 Founder 4 (Move anchor element down to create 4). ✓ Text Simon Fairbanks. ✓ 1 Total for QUESTION 7 [15] TOTAL: [150] Copyright reserved Please turn over