Computer Applications Technology Grade 12 P1 2026 Memo (Eng)

hlayiso mock exams Practice Series: Grade 12 NSC Preparation WWW.HLAYISO.COM NATIONAL SENIOR CERTIFICATE GRADE 12 COMPUTER APPLICATIONS TECHNOLOGY P1 MOCK EXAMINATION 2026 MARKING GUIDELINES MARKS: 150 These marking guidelines consist of 12 pages. Copyright reserved Please turn over

Computer Applications Technology/P1 2 Hlayiso/Mock 2026 NSC – Marking Guidelines CENTRE NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 24 21 18 22 35 15 15 150 CANDIDATE MARK MARKER CODE/ SIGNATURE MODERATED MARK GENERAL NOTES TO MARKERS • Check the accuracy and skill required before awarding a mark throughout. • Mark the spreadsheet questions from the formulae and NOT from the values/answers in the cells. Cell references may differ, depending on the candidate’s response. • Candidates may use multiple formulae, cells or ’building blocks’ to reach answers. Named ranges may be used instead of cell references. The answers must still be correct if changes are made to the existing data. • Mark the HTML question from the code. Numerical attribute values and single words do not need to be in inverted commas. • Expected values/record counts are given as a guide; they are calculated on the original data files. Copyright reserved Please turn over

Computer Applications Technology/P1 3 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 1 File name(s): 1Power Total Q1: 24 No. Criteria Maximum Candidate mark mark Examination number in the header – (Note to marker: Not marked separately, but required to identify the work.) 1.1 Cover page 3 • Facet cover page inserted 3 1 • Document title: Going Solar 3 1 • Abstract content control removed 3 1 1.2 Style modified: Solar 3 • Border: Bottom border only 3 1 • Width 1½ pt AND any orange colour 3 1 • Spacing: After: 12 pt 3 1 (Style must be modified, not direct formatting on the paragraphs) 1.3 Image: 1Panel 3 • ’Question/Vraag 1.3’ replaced with 1Panel image 3 1 • Width: 6 cm with aspect ratio locked (height approx. 4 1 cm) 3 • Wrap text: Square 3 1 1.4 Find and replace: ’inverter’ 3 • Font: Bold 3 1 • Underline style: Double 3 1 • 10 replacements made (Find whole words only – 1 ’inverters’ NOT changed) 3 1.5 Table below ’2.1 Typical system costs’ 5 • Table style: Any Grid Table 4 style 3 1 • Price (R) column: Right aligned 3 1 • Formula field inserted in the last cell of the Average 1 row 3 • Function: =AVERAGE(ABOVE) 3 OR 1 =AVERAGE(C2:C5) • Number format: Currency with no decimals, e.g. 1 R#,##0 (displays R152 125) 3 Alt+F9: { =AVERAGE(ABOVE) \# "R#,##0" } 1.6 Footnote: ’NERSA’ 3 • Footnote inserted on the word NERSA 3 1 • Number format: i, ii, iii, … 3 1 • Footnote text: National Energy Regulator of South 1 Africa 3 1.7 Table of contents 3 • Automatic table of contents replaced ’Question/Vraag 1 1.7’ 3 Copyright reserved Please turn over

Computer Applications Technology/P1 4 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • Show levels: 2 (only Heading 1 and Heading 2 1 entries) 3 • Tab leader: Dash (- - - -) 3 1 Alt+F9: { TOC \o "1-2" \h \z \u } 1.8 Pagination: ’3. Battery storage’ 1 • Page break before 3 (OR manual page break 1 inserted before the heading) Total for QUESTION 1 [24] Copyright reserved Please turn over

Computer Applications Technology/P1 5 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 2 File name(s): 2Tips Total Q2: 21 No. Criteria Maximum Candidate mark mark 2.1 Drop cap: ’Load-shedding and higher …’ 3 • Position: Dropped 3 1 • Lines to drop: 3 3 1 • Distance from text: 0.3 cm 3 1 2.2 Bookmark and hyperlink 3 • Bookmark ’Tips’ inserted on the heading ’Saving tips’ 1 3 • Hyperlink on ’see the tips’ to the Tips bookmark 3 1 • ScreenTip: Save power 3 1 Alt+F9: { HYPERLINK \l "Tips" \o "Save power" } 2.3 Bullets: ’Install a geyser blanket …’ 2 • Numbered list changed to a bulleted list (all FIVE 1 items) 3 • Symbol: Wingdings character code 74 (smiley face) 3 1 2.4 Columns 3 • Two columns applied 3 1 • Line between 3 1 • Only the text from ’Saving tips’ to ’…during peak 1 hours.’ is in columns (continuous section breaks) 3 2.5 Caption: Image below ’Measure your usage’ 3 • Caption inserted below the image, Label: Figure 3 1 • Numbering format: A, B, C, … 3 1 • Caption text: ’: Smart meter’ 3 (displays Figure A: 1 Smart meter) 2.6 Tab stop: Text below ’Contact our branches’ 3 • Tab stop applied to all FOUR lines 3 1 • Position 15 cm AND Alignment: Right 3 1 • Leader: 2 (dots) …… 3 1 2.7 Watermark 3 • Custom text watermark: LANGA 3 1 • Font: Arial 3 1 • Layout: Horizontal 3 1 2.8 Field: Number of words 1 • NumWords field replaced ’Question/Vraag 2.8’ 3 1 (Alt+F9: { NUMWORDS }) Total for QUESTION 2 [21] Copyright reserved Please turn over

Computer Applications Technology/P1 6 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 3 File name(s): 3Installs Total Q3: 18 No. Criteria Maximum Candidate mark mark 3.1 Cells A1:L1 2 • A1:L1 merged and centred 3 1 • Cell style: Heading 1 3 1 3.2 Cell D3 2 =COUNTIF(G6:G45,"Yes") • Function: COUNTIF(G6:G45, …) 3 1 • Criteria: ”Yes” 3 1 (Expected answer: 18) 3.3 Cell D4 4 =ROUND(AVERAGEIF(E6:E45,"Premium",H6:H45),2) • Function: ROUND( …,2) 3 1 • Function: AVERAGEIF 3 (OR 1 AVERAGEIFS(H6:H45,E6:E45,”Premium”)) • Range: E6:E45 AND Criteria: ”Premium” 3 1 • Average range: H6:H45 3 1 (Expected answer: R157 812.50) 3.4 Cells L6:L45 2 =TEXT(D6,"mmmm") • Function: TEXT(D6, …) 3 1 • Format: ”mmmm” AND copied to L45 3 1 (Expected L6: January) 3.5 Cells K6:K45 4 =VLOOKUP(E6,Rates!$A$2:$C$4,3,FALSE) OR =XLOOKUP(E6,Rates!$A$2:$A$4,Rates!$C$2:$C$4) • Function: VLOOKUP with lookup value E6 3 1 • Table array: Rates!$A$2:$C$4 (absolute; 1 Rates!$A$1:$C$4 also accepted) 3 • Column index: 3 3 1 • Range lookup: FALSE OR 0 (table is NOT sorted) 3 1 (XLOOKUP: lookup value 1, lookup array 1, return array 1, absolute references 1. Expected K6: 10) 3.6 Conditional formatting: B6:B45 4 • Conditional formatting applied to B6:B45 only 3 1 • Rule: Use a formula: =$J6 3 1 • Condition: >10000 3 1 • Format: Font colour red 3 1 (Rule: =$J6>10000 OR =J6>10000. 19 surnames display in red, e.g. Zulu in B6) Total for QUESTION 3 [18] Copyright reserved Please turn over

Computer Applications Technology/P1 7 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 4 File name(s): 4Quotes Total Q4: 22 No. Criteria Maximum Candidate mark mark 4.1 Cell C3 2 =MAX(D10:D49) • Function: MAX(D10:D49) 3 (OR 1 LARGE(D10:D49,1)) • Format: d mmmm yyyy (Long Date, displays 22 April 1 2026) 3 4.2 Cell C4 4 =COUNTIFS(E10:E49,"Business",F10:F49,">20") • Criteria range 1: E10:E49 3 1 • Criteria 1: ”Business” 3 1 • Criteria range 2: F10:F49 3 1 • Criteria 2: ”>20” 3 1 (Expected answer: 6) 4.3 Cell C5 4 =SUMIFS(F10:F49,D10:D49,">=2026/03/01", D10:D49,"<=2026/03/31") OR =SUMIFS(F10:F49,D10:D49,">="&DATE(2026,3,1), D10:D49,"<"&DATE(2026,4,1)) OR =SUMPRODUCT((MONTH(D10:D49)=3)*F10:F49) • Function: SUMIFS with sum range F10:F49 3 1 • Criteria range: D10:D49 3 1 • Criteria: >= 1 March 2026 3 1 • Criteria: <= 31 March 2026 (OR < 1 April 2026) 3 1 (SUMPRODUCT: MONTH 1, D10:D49 = 3 1, multiplied by F10:F49 1, SUMPRODUCT 1. Expected answer: 190) 4.4 Cell J10 4 =UPPER(LEFT(B10,3))&RIGHT(C10,4) OR =CONCAT(UPPER(LEFT(B10,3)),RIGHT(C10,4)) • Function: UPPER 3 1 • Function: LEFT(B10,3) 3 (OR MID(B10,1,3)) 1 • Function: RIGHT(C10,4) 3 1 • Joined with & OR CONCAT/CONCATENATE 3 1 (Expected answer: MTH2802) 4.5 Cells H10:H49 6 =IF(E10="School",G10*10%, IF(AND(E10="Business",G10>150000),G10*5%,0)) OR =IF(E10="School",G10*0.1,IF(E10="Business", IF(G10>150000,G10*0.05,0),0)) • Correct nested IF syntax/logic and copied to H49 3 1 Copyright reserved Please turn over

Computer Applications Technology/P1 8 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • Criteria: E10=”School” 3 1 • Value if TRUE: G10*10% (OR *0.1 OR *10/100) 3 1 • Criteria: AND( …) OR nested IF 3 1 • E10=”Business” AND G10>150000 3 1 • Value if TRUE: G10*5% AND value if FALSE: 0 3 1 (Expected: H10 = R0.00; H11 = R22 200.00; total discount for H10:H49 = R279 907.50) 4.6 Cells K10:K49 2 =RANK(I10,$I$10:$I$49) OR =RANK.EQ(I10,$I$10:$I$49,0) • Function: RANK OR RANK.EQ with I10 3 1 • Range: $I$10:$I$49 (absolute) 3 1 (Expected K10: 22 when the discounts in 4.5 are correct) Total for QUESTION 4 [22] Copyright reserved Please turn over

Computer Applications Technology/P1 9 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 5 File name(s): 5Langa Total Q5: 35 No. Criteria Maximum Candidate mark mark Table: tbl5_1 5.1.1 Primary key 1 • TechID set as primary key 3 1 5.1.2 Field: Qualified 1 • Data type: Yes/No 3 1 5.1.3 Field: EmpCode – Input mask 3 >LL-000 OR >LL\-000 OR >LL"-"000 (;;_ / ;0; may be added) • Upper case: > 3 1 • Two compulsory letters: LL 3 1 • Hyphen followed by THREE compulsory digits: -000 1 3 5.1.4 Field: HourlyRate – Validation 3 >=150 And <=450 OR Between 150 And 450 • >=150 3 1 • And <=450 3 1 • Validation text: Any appropriate text that refers to the 1 rule 3 5.1.5 Field: StartDate 1 • Default value: Date() 3 (OR Now()) 1 5.1.6 Field: Branch – Lookup 3 • Display control: Combo box (OR List box) 3 1 • Row source type: Value list 3 1 • Row source: ”Johannesburg”;”Pretoria”;”Polokwane” 1 3 (Lookup wizard used: award the marks if the three values display in the drop-down list) Form: frm5_2 5.2 Form based on tblClients 6 • Form frm5_2 created with ALL six fields in a columnar 1 layout 3 • Saved as frm5_2 3 1 • 5Logo image inserted in the form header 3 1 • Title: Langa Solar Clients 3 1 • ClientID field: Locked: Yes 3 (OR Enabled: No) 1 • Detail section: Back colour any light yellow 3 1 Query: qry5_3 5.3 Query based on tblInstallations 5 • ONLY InstallID, ClientID, InstallDate, SystemType 1 and Battery displayed 3 • SystemType criteria (row 1): ”Premium” 3 1 Copyright reserved Please turn over

Computer Applications Technology/P1 10 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • InstallDate criteria (same row): Between 1 #2026/01/01# And #2026/03/31# 3 • SystemType criteria (OR row): ”Basic” 3 1 • Battery criteria (same OR row): Yes OR True OR -1 3 1 (Expected records: 10) Query: qry5_4 5.4 Calculated field 4 CostPerPanel: [Cost]/[Panels] • Field name: CostPerPanel 3 1 • Calculation: [Cost]/[Panels] 3 1 • Format property: Currency 3 1 • Sorted: Descending on CostPerPanel 3 1 (Expected first record: I043 – R11 416.67; last record: I028 – R7 683.33) Query: qry5_5 5.5 Totals query 4 • SystemType: Group By 3 1 • InstallID (or any field): Count 3 1 • Cost: Sum 3 1 • SumOfCost sorted Descending 3 1 Expected: SystemType CountOfInstallID SumOfCost Standard 21 R2 132 300.00 Premium 10 R1 606 800.00 Basic 14 R915 300.00 Report: rpt5_6 5.6 Report based on tblInstallations 4 • Area, InstallID, SystemType and Cost fields displayed 1 and grouped by Area 3 • Area footer: =Sum([Cost]) 3 1 • Page orientation: Landscape 3 1 • Report title: Installations per area 3 1 (Expected totals, e.g. Soweto R996 700.00; Centurion R750 400.00; Sandton R158 600.00) Total for QUESTION 5 [35] Copyright reserved Please turn over

Computer Applications Technology/P1 11 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 6 File name(s): 6_1Solar; 6_2Battery Total Q6: 15 No. Criteria Maximum Candidate mark mark 6.1.1 Comment 1 <!--1234567890123--> • Examination number inserted as a comment 3 1 6.1.2 Image: 6_1Sun 3 <img src="6_1Sun.png" align="right" width="150"/> • Image tag with src=”6_1Sun.png” 3 1 • Attribute: align=”right” 3 1 • Attribute: width=”150” 3 1 6.1.3 Heading 2 <h1 align="center"><font color="DarkOrange">Langa Solar</font></h1> OR <center> tags around the heading • Centred: align=”center” OR <center> 3 1 • Font colour: <font color=”DarkOrange”> 3 1 6.1.4 Table 3 <table border="2"> <th colspan="3">Our packages</th> • Attribute: border=”2” 3 1 • Attribute: colspan 3 1 • Value: 3 3 1 6.1.5 List 2 <ol type="i"> … </ol> • <ul> changed to <ol> (opening AND closing tags) 3 1 • Attribute: type=”i” 3 1 6.2 6_2Battery 3 <img src="6_2Battery.png" height="200" align="left"/> <p><i>Did you know? … evening.</i></p> <p><a href="6_1Solar.html">Back to home page</a></p> • Image: align=”left” 3 1 • Italic tags around the ’Did you know? …’ text 3 1 • Link: <a href=”6_1Solar.html”> … </a> on ’Back to 1 home page’ 3 Closing tags and nesting 1 • Closing tags/triangular brackets and nesting correctly 1 used in BOTH web pages 3 Total for QUESTION 6 [15] Copyright reserved Please turn over

Computer Applications Technology/P1 12 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 7 File name(s): 7Letter; 7Merged; 7Usage Total Q7: 15 No. Criteria Maximum Candidate mark mark 7Letter; 7Merged 7.1 Mail merge 5 • 7Clients linked as the data source of 7Letter 3 1 • Filter: City equal to Pretoria 3 1 • Filter: Battery equal to No 3 1 • <<NAME>> replaced with the <<FirstName>> 1 merge field 3 • Merge completed and saved as 7Merged 3 1 (Expected: 8 letters in 7Merged) 7Usage – Usage worksheet 7.2 Chart 5 • Correct data used: A1:D13 (months, Generated, 1 Consumed and Savings) 3 • Generated and Consumed as clustered columns 3 1 • Savings as a line on the secondary axis 3 1 • Chart title: Energy usage 2025 3 1 • Chart moved to a new chart sheet named Chart 3 1 7Usage – Payments worksheet 7.3 Data validation: C2:C61 3 • Data validation applied to C2:C61, Allow: List 3 1 • Source: Cash,EFT,Card 3 1 • Error alert message: Choose from the list 3 1 7.4 Page setup 2 • Print titles: Rows to repeat at top: $1:$1 3 1 • Scaling: Fit All Columns on One Page (Fit to 1 page 1 wide) 3 Total for QUESTION 7 [15] TOTAL: 150 Copyright reserved