Computer Applications Technology Grade 11 P1 2026 Memo (Eng)

Mock 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 13 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): 1Athletics 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 Cover page 2 • Any built-in cover page inserted at the beginning of 1 the document 3 • Title: TrackStars Limpopo AND Subtitle: Athlete guide 1 2026 in the content controls (unused controls deleted) 3 1.2 New style: TrackSub 3 • Style named TrackSub, based on Heading 2 3 1 • Font colour any orange AND spacing after 6 pt 3 1 • TrackSub applied to ALL FOUR sub-headings (1.1, 1 2.1, 3.1, 4.1) 3 (Direct formatting of the sub-headings without a new style: no marks for the first two criteria) 1.3 Find and replace: ’Track Stars’ 3 • ’Track Stars’ replaced with ’TrackStars’ 3 1 • Replaced word formatted in bold 3 1 • ALL SIX occurrences replaced (none of the original 1 text remains) 3 1.4 Bullets below ’3.1 What to pack’ 3 • Symbol bullet (Define New Bullet – Symbol) applied 1 to the list 3 • Wingdings character code 252 (4) used for ALL SIX 1 items 3 • Text indent: 1 cm from the bullet (Adjust List Indents – 1 Text indent 1 cm more than the bullet position, OR a hanging indent of 1 cm) 3 1.5 Image: 1Runner 3 • ’Question/Vraag 1.5’ replaced with the 1Runner 1 image 3 • Width 4 cm with aspect ratio locked (height approx. 1 4.6 cm) 3 • Wrap text: Square AND image positioned on the right 1 of the page 3 1.6 Caption and table of figures 3 • Caption with label Figure inserted below the image 3 1 • Caption text: Figure 1: Sprinting technique 3 1 • Automatic table of figures replaced ’Question/Vraag 1 1.6’ (shows the Figure 1 entry) 3 Alt+F9: { TOC \h \z \c "Figure" } 1.7 Endnote: ’hydration’ 2 Copyright reserved Please turn over

Computer Applications Technology/P1 4 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • Endnote inserted on the word hydration with the text: 1 Drink small amounts of water often. 3 • Number format: 1, 2, 3 3 1 (A footnote instead of an endnote: maximum 1 mark) 1.8 Citation and bibliography 4 • New source with type of source: Book 3 1 • Author Ngobeni, Tiyani; Title; Year 2024; City; 1 Publisher – all correct 3 • Citation (Ngobeni, 2024) inserted at the end of the 1 highlighted text 3 • Automatic bibliography replaced ’Question/Vraag 1.8’ 1 and shows the source 3 1.9 Page numbers 3 • Automatic page numbers inserted in the footer 3 1 • Different Odd & Even Pages selected 3 1 • Odd pages right aligned AND even pages left aligned 1 3 (The cover page may have no number – Different First Page is applied automatically by a built-in cover page) 1.10 Watermark 2 • Custom text watermark with the text DRAFT 3 1 • Layout: Diagonal 3 1 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): 2Entry Total Q2: 14 No. Criteria Maximum Candidate mark mark 2.1 Text form field: ’Full name’ 2 • Legacy text form field replaced ’Question/Vraag 2.1’ 1 AND maximum length: 30 3 • Text format: Uppercase 3 1 2.2 Drop-down list: ’Main event’ 3 • Drop-down list content control replaced 1 ’Question/Vraag 2.2’ 3 • Items: 100 m, 200 m, 400 m, 800 m, Long jump (all 1 FIVE, no other items) 3 • ’Choose an item.’ removed from the list 3 1 (A legacy drop-down form field with the five items: maximum 1 mark) 2.3 Check box form field 2 • Legacy check box form field inserted in front of the 1 consent text 3 • Check box size: Exactly 12 pt AND default value: 1 Checked 3 2.4 Symbol and date field 3 • Wingdings character code 40 (%) inserted in front of 1 ’Contact number:’ 3 • Date field (Insert – Date & Time with Update 1 automatically, OR a DATE field) replaced ’Question/Vraag 2.4’ 3 • Format: yyyy/MM/dd 3 1 Alt+F9: { DATE \@ "yyyy/MM/dd" } 2.5 Page colour 2 • Fill effects: Gradient with Two colours 3 1 • Shading style: Horizontal 3 1 2.6 Text effects: heading 2 • Any outer shadow applied to ’TRACKSTARS ENTRY 1 FORM’ 3 • Any glow applied to ’TRACKSTARS ENTRY FORM’ 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): 3Results Total Q3: 38 No. Criteria Maximum Candidate mark mark 3.1 Merged cells A1:M1 2 • Fill effects: Gradient with two colours 3 1 • Vertical alignment: Centre 3 1 3.2 Freeze panes 2 • Freeze Panes applied 3 1 • At cell C7 (rows 1 to 6 AND columns A and B frozen) 1 3 3.3 Cell D2 2 =COUNTIF(D7:D46,"F") • Function: COUNTIF with range D7:D46 3 1 • Criteria: ”F” 3 1 (Expected answer: 20) 3.4 Cell D3 3 =SUMIF(F7:F46,"Thabakgolo High School",I7:I46) • Function: SUMIF with range F7:F46 3 1 • Criteria: ”Thabakgolo High School” (OR 1 ”Thabakgolo*”) 3 • Sum range: I7:I46 3 1 (Expected answer: 130. =SUMIFS(I7:I46,F7:F46,"Thabakgolo High School") also accepted) 3.5 Cell D4 2 =SMALL(H7:H46,3) • Function: SMALL with range H7:H46 3 1 •k=33 1 (Expected answer: 11.57. =MIN(...) only: 0 marks) 3.6 Cell D5 3 =ROUND(AVERAGEIF(D7:D46,"F",H7:H46),2) • Function: ROUND( …,2) 3 1 • Function: AVERAGEIF with range D7:D46 AND 1 criteria ”F” 3 • Average range: H7:H46 3 1 (Expected answer: 14.01. =ROUND(SUMIF(D7:D46,"F",H7:H46)/ COUNTIF(D7:D46,"F"),2) also accepted. =ROUND(AVERAGEIFS(H7:H46,D7:D46,"F"),2) also accepted. Formatting to 2 decimal places instead of ROUND: no mark for criterion 1) 3.7 Cells J7:J46 4 =DATEDIF(E7,$J$2,"Y") OR =INT(($J$2-E7)/365.25) OR =ROUNDDOWN(YEARFRAC(E7,$J$2),0) Copyright reserved Please turn over

Computer Applications Technology/P1 7 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • Correct function/method to calculate the years 1 between the two dates 3 • Date of birth E7 AND date of meet J2 used in the 1 correct order 3 • Answer in COMPLETED years (”Y”, INT or 1 ROUNDDOWN) 3 • $J$2 absolute (OR J$2) AND copied to J46 3 1 (=2026-YEAR(E7) OR =YEAR(J2)-YEAR(E7): maximum 2 marks – not completed years. Expected: J7 = 14 (Ntsako Chauke turns 15 only on 4 December); J9 = 16; ages range from 12 to 17) 3.8 Cells K7:K46 5 =IF(J7<14,"U14",IF(J7<16,"U16","U19")) OR =IF(J7>=16,"U19",IF(J7>=14,"U16","U14")) OR =IFS(J7<14,"U14",J7<16,"U16",J7>=16,"U19") (award the nested-IF mark for the second condition) • Function: IF with correct syntax 3 1 • First condition and value, e.g. J7<14 , ”U14” 3 1 • Nested IF 3 1 • Second condition and value, e.g. J7<16 , ”U16” 3 1 • Final value if false: ”U19” AND copied to K46 3 1 (CA from the values in column J. Expected: K7 = U16; totals U14 = 7, U16 = 11, U19 = 22) 3.9 Cells L7:L46 3 =G7*$J$3 • Formula multiplies G7 by J3 3 1 • $J$3 absolute (OR J$3) 3 1 • Copied to L46 3 1 (Value 65 typed in the formula: maximum 1 mark. Expected: L7 = 130; L8 = 65; total of L7:L46 = 5 720) 3.10 Cells M7:M46 4 =UPPER(LEFT(C7,1)&LEFT(B7,3))&LEN(B7) OR =CONCATENATE(UPPER(LEFT(C7)), UPPER(LEFT(B7,3)),LEN(B7)) • LEFT(C7,1) AND LEFT(B7,3) (OR MID( …,1, …)) 3 1 • Function: UPPER applied to the letters 3 1 • Function: LEN(B7) 3 1 • Joined with & OR CONCATENATE/CONCAT AND 1 copied to M46 3 (Expected: M7 = NCHA6; M8 = PCHA6; M9 = VKEK6) 3.11 Conditional formatting: H7:H46 3 • Conditional formatting applied to H7:H46 3 1 • Rule: Top/Bottom Rules – Bottom 10 Items, changed 1 to 5 3 • Format: Green fill with dark green text 3 1 Copyright reserved Please turn over

Computer Applications Technology/P1 8 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark (Formatted cells: 11.21; 11.53; 11.57; 11.73; 11.82. A rule such as Less than 11.83: maximum 2 marks) 3.12 Chart – Summary worksheet 5 • Pie chart using A1:B7 (schools as categories) placed 1 on the Summary worksheet below the data (not over A1:B7) 3 • Chart title: Athletes per school 3 1 • Data labels displayed as percentages 3 1 • Legend at the bottom 3 1 • Thabakgolo High School slice exploded 3 1 (Expected values: Thabakgolo 10 (25%); Letsatsi 1 (3%); Mmatau 6 (15%); Kgwerano 5 (13%); Nthabiseng 9 (23%); Muhuyu 9 (23%)) Total for QUESTION 3 [38] Copyright reserved Please turn over

Computer Applications Technology/P1 9 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 4 File name(s): 4TrackStars Total Q4: 36 No. Criteria Maximum Candidate mark mark Table: tblCoaches 4.1.1 Field: Surname – Field size 1 • Field size: 25 3 1 4.1.2 Field: CellNo – Input mask 3 000\ 000\ 0000;;# OR 000 000 0000;0;# OR 000" "000" "0000;;# • TEN compulsory digits: 0 (ten times) 3 1 • Spaces (literal characters) after the 3rd and 6th digits 1 3 • Placeholder character: # (third section of the mask) 3 1 (9 instead of 0: no mark for criterion 1) 4.1.3 Field: YearsExp – Validation 3 >=1 And <=40 OR Between 1 And 40 • >=1 (OR >0) 3 1 • And <=40 (OR <41) 3 1 • Validation text: Any appropriate text that refers to the 1 rule 3 4.1.4 Field: Province – Default value 1 • Default value: ”Limpopo” 3 1 4.1.5 Field: Email – Required 1 • Required: Yes 3 1 4.1.6 Field: Level – Lookup 3 • Display control: Combo box AND Row source type: 1 Value list 3 • Row source: ”Club”;”District”;”Provincial” 3 1 • Limit to list: Yes 3 1 (Lookup wizard used: award criteria 1 and 2 if the three values display in the drop-down list) 4.1.7 Datasheet formatting 2 • Font size: 12 pt 3 1 • Alternate row colour: any light orange 3 1 Form: frm4_2 4.2 Form based on tblAthletes 5 • Form frm4_2 with ONLY the six required fields 3 1 • Tabular layout 3 1 • Title: TrackStars athletes 3 1 • Text box in the form footer: =Min([HeatTime]) 3 1 • Detail section background colour: any light colour 3 1 (Expected value in the footer: 11.21) Query: qry4_3 4.3 Query based on tblAthletes 5 Copyright reserved Please turn over

Computer Applications Technology/P1 10 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • ONLY AthleteID, Surname, Gender, DOB and 1 HeatTime displayed 3 • Gender criteria: ”F” 3 1 • DOB: Between #2010/01/01# And #2011/12/31# (OR 1 >=#2010/01/01# And <#2012/01/01#) 3 • Both criteria on the SAME row 3 1 • HeatTime: Sort Ascending 3 1 (Expected: 10 records, first TS125 (12.51), last TS124 (15.59). Year([DOB]) Between 2010 And 2011 in a calculated column also accepted.) Query: qry4_4 4.4 Query based on tblAthletes 4 • Surname, FirstName, SchoolID and Events displayed 1 3 • Surname: Like ”R*” 3 1 • Events: 4 3 1 • Criteria on DIFFERENT rows (OR) 3 1 (Expected: 13 records) Query: qry4_5 4.5 Totals query 4 • Totals row activated 3 1 • SchoolID: Group By 3 1 • AthleteID (or any other field that is never empty): 1 Count 3 • HeatTime: Avg 3 1 (Expected: S01 13 – 13.29; S02 4 – 14.17; S03 8 – 13.17; S04 5 – 14.38; S05 10 – 13.83; S06 10 – 12.79 (averages shown rounded; Access may display more decimal places)) Report: rpt4_6 4.6 Report based on tblAthletes 4 • ONLY Gender, Surname, FirstName and HeatTime 1 displayed 3 • Grouped by Gender 3 1 • Sorted by HeatTime – smallest to largest within each 1 group 3 • Report title: Heat times per gender 3 1 (Expected: F – 27 records, fastest 12.51; M – 23 records, fastest 11.21) Total for QUESTION 4 [36] Copyright reserved Please turn over

Computer Applications Technology/P1 11 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 5 File name(s): 5Meet Total Q5: 20 No. Criteria Maximum Candidate mark mark 5.1 Title 1 • <title>TrackStars Limpopo</title> inside the 1 head section 3 5.2 Body 2 <body bgcolor="lightyellow" text="navy"> • Attribute: bgcolor=”lightyellow” 3 1 • Attribute: text=”navy” 3 1 5.3 Heading 2 <h2><i>Capricorn Schools Championship</i></h2> • <h3> changed to <h2> (opening AND closing tags) 3 1 • <i> … </i> around the heading text 3 1 5.4 Image: 5Track 4 <p align="center"><img src="5Track.png" height="150" border="2" alt="Athletics track"/></p> • Image tag with src=”5Track.png” below the first 1 paragraph AND height=”150” 3 • Attribute: border=”2” 3 1 • Attribute: alt=”Athletics track” 3 1 • Centred: <p align=”center”> OR <center> 3 1 5.5 List 2 <ul type="square"> … </ul> • <ol> changed to <ul> (opening AND closing tags) 3 1 • Attribute: type=”square” 3 1 5.6 Target location 2 <h3><a name="programme"></a>Programme</h3> OR <a name="programme"><h3>Programme</h3></a> • <a name= …></a> at the heading Programme 3 1 • Name: programme (matches the existing 1 href=”#programme”) 3 (id=”programme” on the h3 tag also accepted) 5.7 Table 3 <table border="1" cellspacing="4"> <tr><td colspan="3" align="center">Event times</td></tr> • Attribute: colspan=”3” on the ’Event times’ cell 3 1 • Centred: align=”center” on the td (OR tr) OR <th> 3 1 • Attribute: cellspacing=”4” 3 1 5.8 Text formatting 3 <p><b><font color="red" size="5">Entries close on …</font></b></p> • <b> … </b> 3 1 Copyright reserved Please turn over

Computer Applications Technology/P1 12 Hlayiso/Mock 2026 NSC – Marking Guidelines No. Criteria Maximum Candidate mark mark • Attribute: color=”red” (OR ”ff0000”/”#ff0000”) 3 1 • Attribute: size=”5” 3 1 Closing tags and nesting 1 • Closing tags/triangular brackets and nesting correctly 1 used 3 Total for QUESTION 5 [20] Copyright reserved Please turn over

Computer Applications Technology/P1 13 Hlayiso/Mock 2026 NSC – Marking Guidelines QUESTION 6 File name(s): 6Coaches; 6Certificate; 6Merged; 6Report Total Q6: 14 No. Criteria Maximum Candidate mark mark 6Coaches (.xlsx and .pdf) 6.1 Page setup 3 • Orientation: Landscape 3 1 • Print titles: Rows to repeat at top $1:$1 3 1 • Centre on page: Horizontally 3 1 6.2 Filter and PDF 3 • Filter (AutoFilter or custom filter) applied on the Town 1 column 3 • ONLY Polokwane AND Seshego displayed; no data 1 deleted 3 • Saved as a PDF file called 6Coaches (shows the 1 filtered data) 3 (Expected: 17 coaches displayed) 6Certificate; 6Merged 6.3 Mail merge 5 • 6Winners linked as the data source of 6Certificate 3 1 • Filter: Position less than or equal to 3 (OR less than 1 4) 3 • <<FirstName>> <<Surname>> replaced 1 <<NAME>> (with a space) 3 • <<Event>> replaced <<EVENT>> 3 1 • Merge completed and saved as 6Merged 3 1 (Expected: 18 certificates in 6Merged) 6Report 6.4 Linked data 3 • Data replaced ’Question/Vraag 6.4’ 3 1 • ALL the data in A1:B5 (three levels and the total) 3 1 • Pasted as a link (Paste Special – Paste link, OR Link 1 & Keep Source Formatting) 3 (Expected values: Club 15; District 20; Provincial 7; Total 42. Alt+F9 shows a LINK field.) Total for QUESTION 6 [14] TOTAL: 150 Copyright reserved