Computer Applications Technology Grade 11 P1 2026 Memo (Eng)

hlayiso mock exams Practice Series: Grade 11 Exam Preparation WWW.HLAYISO.COM NATIONAL SENIOR CERTIFICATE GRADE 11 COMPUTER APPLICATIONS TECHNOLOGY P1 NOVEMBER EXAMINATION 2026 (MOCK) 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 TOTAL POSSIBLE MARK 28 14 38 36 20 14 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): 1Ewaste Total Q1: 28 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 Title: ’E-waste: what you need to know’ 2 • ’Title’ style applied to the first line 3 1 • Character spacing: Expanded by 2 pt 3 1 1.2 Style modified: Heading 1 3 • Font size: 16 pt 3 1 • Font effect: Small caps 3 1 • Spacing: Before: 18 pt 3 1 (Style must be modified – all FOUR Heading 1 headings change. Direct formatting on the headings: no marks) 1.3 Find and replace: ’ewaste’ 3 • ’ewaste’ replaced with ’e-waste’ 3 1 • Replaced word formatted in italics 3 1 • ALL FOUR occurrences replaced (all in the section 1 ’1. What is e-waste?’ and ’2. Why recycle?’) 3 1.4 Table below ’1.1 Common types of e-waste’ 5 • Text converted to a table with 3 columns and 7 rows 3 1 • Any table style applied 3 1 • AutoFit: AutoFit Contents 3 1 • Sorted by the ’Average mass (kg)’ column, type 1 Number 3 • Descending AND header row excluded from the sort 1 3 Expected order: CRT monitor (15.0); Desktop computer (9.5); Inkjet printer (6.4); LCD monitor (4.8); Laptop (2.2); Cellphone (0.15) 1.5 Image: 1Bin 3 • ’Question/Vraag 1.5’ replaced with the 1Bin image 3 1 • Height: 3 cm with aspect ratio locked (width approx. 1 2.6 cm) 3 • Wrap text: Tight 3 1 1.6 Columns: below ’2. Why recycle?’ 3 • Two columns applied 3 1 • Spacing between columns: 1 cm 3 1 • ONLY the TWO paragraphs are in columns 1 (continuous section breaks before and after) 3 1.7 Footnote: ’POPIA’ 2 • Footnote inserted on the word POPIA 3 1 Copyright reserved Please turn over

Computer Applications Technology/P1 4 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • Footnote text: Protection of Personal Information Act 1 4 of 2013 3 1.8 Comment: ’landfill’ 2 • Comment inserted on the word landfill 3 1 • Comment text: Add a definition 3 1 1.9 Table of contents 3 • Automatic table of contents replaced ’Question/Vraag 1 1.9’ 3 • Show levels: 1 (only the FOUR Heading 1 entries) 3 1 • Page numbers right aligned with a dotted tab leader 3 1 Alt+F9: { TOC \o "1-1" \h \z \u } 1.10 Section break: ’4. Drop-off points’ 2 • Section break (Next page) inserted before the 1 heading ’4. Drop-off points’ 3 • ONLY the last section in landscape orientation; the 1 rest remains portrait 3 Total for QUESTION 1 [28] Copyright reserved Please turn over

Computer Applications Technology/P1 5 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 2 File name(s): 2Donate Total Q2: 14 No. Criteria Maximum Candidate mark mark 2.1 Date picker: ’Collection date’ 2 • Date picker content control replaced ’Question/Vraag 1 2.1’ 3 • Date format: d MMMM yyyy (displays e.g. 15 March 1 2026) 3 2.2 Drop-down list: ’Type of device’ 3 • Drop-down list content control replaced 1 ’Question/Vraag 2.2’ 3 • Items: Laptop, Desktop, Cellphone, Printer (all 1 FOUR) 3 • Placeholder text: Select a device 3 1 2.3 Check boxes 2 • Check box content control(s) inserted 3 1 • In front of ALL THREE items 3 1 (Legacy form field check boxes also accepted) 2.4 Tab stop: Name, Cell number, E-mail 3 • Tab stop applied to all THREE lines 3 1 • Position 15 cm AND alignment: Right (OR Left at 15 1 cm) 3 • Leader: 4 (underline) ______ 3 1 2.5 Page border 2 • Box page border applied 3 1 • Width 3 pt AND any green colour 3 1 2.6 Restrict editing 2 • Editing restrictions: Filling in forms 3 1 • Enforcement started (no password) 3 1 Total for QUESTION 2 [14] Copyright reserved Please turn over

Computer Applications Technology/P1 6 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 3 File name(s): 3Collect Total Q3: 38 No. Criteria Maximum Candidate mark mark 3.1 Cells A1:L1 2 • A1:L1 merged and centred 3 1 • Font size: 16 pt 3 1 3.2 Freeze panes 2 • Freeze Panes applied 3 1 • At row 8 (rows 1 to 7 frozen, e.g. cell A8 selected) 3 1 3.3 Cells D8:D47 – date format 2 • Custom format applied to D8:D47 3 1 • Format: dd mmm yyyy 3 1 3.4 Cell D3 2 =COUNTIF(C8:C47,"School") • Function: COUNTIF with range C8:C47 3 1 • Criteria: ”School” 3 1 (Expected answer: 6) 3.5 Cell D4 3 =SUMIF(C8:C47,"Business",H8:H47) • Function: SUMIF with range C8:C47 3 1 • Criteria: ”Business” 3 1 • Sum range: H8:H47 3 1 (Expected answer: 899.7) 3.6 Cell D5 1 • =MIN(D8:D47) 3 (OR =SMALL(D8:D47,1)) 1 (Expected answer: 2026/01/18) 3.7 Cells J8:J47 5 =VLOOKUP(F8,Rates!$A$2:$B$7,2,FALSE)*H8 OR =H8*VLOOKUP(F8,Rates!$A$1:$B$7,2,0) • Function: VLOOKUP with lookup value F8 3 1 • Table array: Rates!A2:B7 (Rates!A1:B7 also 1 accepted) 3 • Table array absolute AND copied to J47 3 1 • Column index: 2 AND range lookup FALSE OR 0 1 (table is NOT sorted) 3 • Multiplied by H8 3 1 (XLOOKUP accepted: lookup value 1, lookup array 1, return array 1, absolute 1, *H8 1. Expected: J8 = R84.00; J9 = R848.40; J10 = R1 389.60; total J8:J47 = R29 979.20) 3.8 Cells K8:K47 6 =IF(OR(C8="School",H8>=50),0,$K$3) OR =IF(C8="School",0,IF(H8>=50,0,$K$3)) OR =IF(AND(C8<>"School",H8<50),$K$3,0) • Function: IF with correct syntax/logic 3 1 Copyright reserved Please turn over

Computer Applications Technology/P1 7 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • OR( …) (OR nested IF/AND) 3 1 • Condition: C8=”School” 3 1 • Condition: H8>=50 3 1 • Value if TRUE: 0 AND value if FALSE: K3 3 1 • $K$3 absolute (OR K$3) 3 1 (Value 120 typed in the formula instead of K3: maximum 4 marks. Expected: K8 = R120; K9 = R0; 27 donations are charged; total fees = R3 240) 3.9 Cells L8:L47 4 =UPPER(LEFT(F8,2))&RIGHT(A8,3) OR =CONCATENATE(UPPER(LEFT(F8,2)),RIGHT(A8,3)) • Function: UPPER 3 1 • LEFT(F8,2) (OR MID(F8,1,2)) 3 1 • RIGHT(A8,3) (OR MID(A8,4,3)) 3 1 • Joined with & OR CONCATENATE/CONCAT 3 1 (Expected: L8 = CE001; L9 = MO002; L10 = DE003) 3.10 Cell H48 3 =ROUND(AVERAGE(H8:H47),1) • Function: ROUND( …,1) 3 1 • Function: AVERAGE 3 1 • Range: H8:H47 3 1 (Expected answer: 43.8) 3.11 Conditional formatting: I8:I47 3 • Conditional formatting applied to I8:I47 3 1 • Rule: Cell value equal to ”Faulty” (OR Text that 1 contains Faulty) 3 • Format: Light red fill with dark red text 3 1 (25 cells are formatted) 3.12 Chart – Summary worksheet 5 • Clustered column chart using A1:B7 (devices on the 1 horizontal axis) 3 • Chart title: Mass collected per device 3 1 • Vertical axis title: Mass (kg) 3 1 • Data labels displayed AND no legend 3 1 • Chart moved to a new chart sheet named Chart 3 1 (Expected values: Laptop 65.0; Desktop 955.7; Monitor 363.7; Printer 332.8; Cellphone 22.9; Mixed 12.8) Total for QUESTION 3 [38] Copyright reserved Please turn over

Computer Applications Technology/P1 8 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 4 File name(s): 4ReBoot Total Q4: 36 No. Criteria Maximum Candidate mark mark Table: tblVolunteers 4.1.1 Primary key 1 • VolID set as primary key 3 1 4.1.2 Field: Surname – Format 1 • Format property: > 3 1 4.1.3 Field: VolCode – Input mask 3 >LL099 (;;_ OR ;0; may be added) • Upper case: > 3 1 • Two compulsory letters: LL 3 1 • One compulsory digit followed by TWO optional 1 digits: 099 3 (>LL0## also accepted) 4.1.4 Field: DateJoined – Validation 3 >=#2020/01/01# And <=Date() OR Between #2020/01/01# And Date() • >=#2020/01/01# 3 1 • And <=Date() 3 1 • Validation text: Any appropriate text that refers to the 1 rule 3 4.1.5 New field: Photo 2 • Field Photo inserted directly below Surname 3 1 • Data type: Attachment (OR OLE Object) 3 1 4.1.6 Field: Shift – Lookup 3 • Display control: Combo box (OR List box) 3 1 • Row source type: Value list 3 1 • Row source: ”Morning”;”Afternoon”;”Saturday” 3 1 (Lookup wizard used: award the marks if the three values display in the drop-down list) Form: frm4_2 4.2 Form based on tblSchools 5 • Form frm4_2 created with ALL six fields in a columnar 1 layout 3 • 4Logo image inserted in the form header 3 1 • Title: Partner schools 3 1 • Text box in the form footer with =Date() (OR =Now()) 1 3 • Command button in the form footer that closes the 1 form (Form Operations – Close Form) 3 Query: qry4_3 4.3 Query based on tblDevices 5 • ONLY DeviceID, DeviceType, RAM_GB, 1 DateReceived and Refurbished displayed 3 Copyright reserved Please turn over

Computer Applications Technology/P1 9 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • DeviceType criteria: ”Laptop” 3 1 • RAM_GB criteria: >=8 3 1 • Refurbished criteria: Yes OR True OR -1 (all on the 1 SAME row) 3 • DateReceived: Sort Ascending 3 1 (Expected: 6 records – D004, D029, D032, D034, D037, D040) Query: qry4_4 4.4 Query based on tblDevices 4 • DeviceID, DeviceType, DateReceived and Fault 1 displayed 3 • DateReceived: Between #2026/03/01# And 1 #2026/03/31# (OR >=#2026/03/01# And <#2026/04/01#) 3 • Fault: Like ”*screen*” 3 1 • Criteria on DIFFERENT rows (OR) 3 1 (Expected: 21 records. Month([DateReceived])=3 in a calculated column also accepted.) Query: qry4_5 4.5 Calculated field 4 SellPrice: [EstValue]*0.6 OR SellPrice: [EstValue]*60/100 • ONLY DeviceID, DeviceType and EstValue displayed 1 with the calculated field 3 • Field name: SellPrice 3 1 • Calculation: [EstValue]*0.6 3 1 • Format property: Currency 3 1 (Expected first record: D001 – R1 430.00 – R858.00) Report: rpt4_6 4.6 Report based on tblDevices 5 • ONLY DeviceType, DeviceID, DateReceived and 1 EstValue displayed 3 • Grouped by DeviceType 3 1 • Function: =Count([DeviceID]) (OR =Count(*)) 3 1 • Placed in the DeviceType footer 3 1 • Report title: Devices per type 3 1 (Expected counts: Desktop 15; Laptop 28; Tablet 5) Total for QUESTION 4 [36] Copyright reserved Please turn over

Computer Applications Technology/P1 10 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 5 File name(s): 5Laptops Total Q5: 20 No. Criteria Maximum Candidate mark mark 5.1 Title 1 • <title>ReBoot SA</title> inside the head section 1 3 5.2 Heading 2 <h1 align="center"><font color="green">ReBoot SA</font></h1> OR <center> tags around the heading • Centred: align=”center” OR <center> 3 1 • Font colour: <font color=”green”> 3 1 5.3 Image: 5Laptop 4 <img src="5Laptop.png" width="200" align="right" alt="Refurbished laptop"/> • Image tag with src=”5Laptop.png” 3 1 • Attribute: width=”200” 3 1 • Attribute: align=”right” 3 1 • Attribute: alt=”Refurbished laptop” 3 1 5.4 Paragraph font 2 <p><font face="Verdana" size="4"> … </font></p> • Attribute: face=”Verdana” 3 1 • Attribute: size=”4” 3 1 5.5 Horizontal line 3 <hr size="4" width="60%" color="008000"/> • Attribute: size=”4” 3 1 • Attribute: width=”60%” 3 1 • Attribute: color=”008000” (OR ”#008000”) 3 1 5.6 List 2 <ol type="a"> … </ol> • <ul> changed to <ol> (opening AND closing tags) 3 1 • Attribute: type=”a” 3 1 5.7 Table 3 <table border="2" cellpadding="6"> <tr><th>Device</th><th>Number collected</th></tr> • Attribute: border=”2” 3 1 • Attribute: cellpadding=”6” 3 1 • <td> changed to <th> for BOTH cells in the first row 3 1 5.8 E-mail link 2 <a href="mailto:info@rebootsa.org.za">Contact us</a> • <a href= …>Contact us</a> 3 1 Copyright reserved Please turn over

Computer Applications Technology/P1 11 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • mailto:info@rebootsa.org.za 3 1 Closing tags and nesting 1 • Closing tags/triangular brackets and nesting correctly1 used 3 Total for QUESTION 5 [20] Copyright reserved Please turn over

Computer Applications Technology/P1 12 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 6 File name(s): 6Schools; 6Letter; 6Merged; 6Volunteers Total Q6: 14 No. Criteria Maximum Candidate mark mark 6Schools (.xlsx and .pdf) 6.1 Sort 3 • Data range A1:F31 sorted with the headings 1 excluded (no data mixed up) 3 • First level: Province – A to Z 3 1 • Second level: Learners – Largest to Smallest 3 1 (Expected first record: Inkanyezi Comprehensive School, Eastern Cape, 1 460 learners; last record: Zakhele Secondary School, Mpumalanga, 560 learners) 6.2 Page setup and PDF 3 • Sheet options: Print gridlines 3 1 • Scaling: Fit All Columns on One Page (Fit to 1 page 1 wide) 3 • Saved as a PDF file called 6Schools 3 1 (Check the PDF for gridlines and that all six columns are on one page) 6Letter; 6Merged 6.3 Mail merge 5 • 6Schools linked as the data source of 6Letter 3 1 • Filter: Province equal to KwaZulu-Natal 3 1 • Filter: Learners greater than 1000 (same filter, And) 3 1 • <<Principal>> AND <<SchoolName>> merge 1 fields replaced the placeholder text 3 • Merge completed and saved as 6Merged 3 1 (Expected: 8 letters in 6Merged) 6Volunteers (.xlsx) 6.4 Import a text file 3 • Data imported (delimited) with each field in a 1 separate column 3 • Data starts in cell A1 and all 25 records plus the 1 heading row appear in A1:E26 3 • Saved as 6Volunteers in .xlsx format 3 1 Total for QUESTION 6 [14] TOTAL: 150 Copyright reserved