# Computer Applications Technology Grade 12 P1 2022 Memo (Eng) > Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC November Exam 2022 (English), 13 pages. Read online or download the free PDF. - Page: https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2022-mg-eng/1d7459a9-14fb-45b9-a247-228e1a764f51 - Updated: 2026-10-29 - Subject: Computer Applications Technology - Grade: Grade 12 - Document type: Memorandum - Year: 2022 - Exam period: NSC November Exam - Paper: 1 - Curriculum: CAPS - Pages: 13 Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Computer Applications Technology](https://www.hlayiso.com/library/grade-12/computer-applications-technology) › [Computer Applications Technology Grade 12 P1 2022 Memo (Eng)](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2022-mg-eng/1d7459a9-14fb-45b9-a247-228e1a764f51) ## About this document Computer Applications Technology · Grade 12 · NSC November Exam · 2022. Memorandum. Read online or download the PDF. Read it free online on the page above; download the PDF from there. ## Document text Text extracted from the PDF. Layout, diagrams and tables may not survive extraction. ### Page 1 Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 12 COMPUTER APPLICATIONS TECHNOLOGY P1 NOVEMBER 2022 MARKING GUIDELINES MARKS: 150 CENTRE FINAL MARK NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 26 19 21 19 35 15 15 150 CANDIDATE MARK MARKER CODE/ SIGNATURE MODERATED MARK These marking guidelines consist of 13 pages. Copyright reserved Please turn over ### Page 2 Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER Check the accuracy and skill required before awarding a mark throughout. QUESTION 1 File name: 1Tourism Total Q1: 26 Maximum Candidate No. Criteria Mark Mark 1.1 Small caps: Extract from Report 1  Font: Small caps  1 1.2 Text Effect (inside shape): KWAZULU-NATAL 3  Text Fill: Gradient fill  1  Type: Rectangular  1  First Gradient Stop Position: 60%  1 1.3 Styles AND Indentation: (Showcasting style) 3  Paragraph indentation: Left set as 0 cm  1  Paragraph indentation: Special: Hanging by 1.5 cm  1  Numbering style: 01., 02., …  1 1.4 Citation: (Department of Statistics South Africa) 1  Citation in 3rd paragraph converted to static text  1 1.5 SmartArt 4  SmartArt: Circle Relationship  1  Level 1: Tourism  1  Text 'Tourism': 14 pt  1  Level 2: Employment, Transport, Food  1 (Note to marker: Accept if SmartArt graphic appears below the text 'Question/Vraag 1.5') 1.6 Find: 'tourism' 2  Match case + Find whole words only  1  Format: Highlight  (Accept any colour) 1 (Note to marker: 16 replacements) 1.7 Columns AND Page Orientation: PUBLIC RELATIONS … 2 effects of the pandemic.  Required text in 2 columns  1  Page orientation: Landscape applied to text in columns  1 Copyright reserved Please turn over ### Page 3 Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER 1.8 Index: Pandemic 1  Subentry 'Covid' added to the main entry 'Pandemic'  1 (Note to marker: Show/Hide: { XE "Pandemic:Covid" }) 1.9 Bibliography 2  Automatic bibliography added  1  Bibliography Style: Harvard - Anglia  1 (Note to marker: References → Citations & Bibliography Group → Style: Harvard) 1.10 Index 3  Index inserted  1  Page numbers: Right aligned  1  Tab leader: Solid line  1 ALT+F9: { INDEX \e " " \c "2" \z "7177" } 1.11 Unzip 4  File 1Poster unzipped  1 Image manipulation: Group of 5 images  Images appear on last page of 1Tourism document  1  All images are cropped to shape: Hexagons  1  Rhino image in line with and touches bottom of Elephant image  1 Total for QUESTION 1 [26] Copyright reserved Please turn over ### Page 4 Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER Check the accuracy and skill required before awarding a mark throughout. QUESTION 2 File name: 2Competition Total Q2: 19 Maximum Candidate No. Criteria Mark Mark 2.1 Drop Cap: W… 3  Position: Dropped  (Not 'In margin') 1  Lines to drop: 3  1  Distance from text: 0.5 cm  1 2.2 Paragraph border: Please share via … the number of 2 shares.  Paragraph border inserted around text  1  Border line width: 3 pt  1 2.3 Hyperlink: Win! Win! Win! 1  Hyperlink inserted to: https://gosafari.co.za/  1 2.4.1 Form Control: Age field 2  Form control: Drop down form field  /Combo/List box 1 content control  Options: <35; 35 – 55; >55  1 2.4.2 Form Control: Cell Number field 2  Type: Regular text  1  Maximum length: 10  (Accept values between 11 and 14) 1 2.4.3 Form Control: Extra entries field 3  Type: Calculation  1  Expression: =Share  *2  2 Alt+F9: { FORMTEXT {=Share*2 }} 2.5 Table manipulation/Text to table 2  Table appears  (3 rows x 3 columns) 1  Last two cells merged  1 2.6 Signature Line feature 2  Signature line feature applied  1  'Allow signer to add comments …' is checked  1 (Note to marker: Right click → Signature Setup) 2.7 Character & Paragraph spacing: Competition Terms … 2  Character spacing on heading: Condensed  1  Paragraph spacing of text below heading: 15 pt After  1 Total for QUESTION 2 [19] Copyright reserved Please turn over ### Page 5 Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 3 File name: 3Tourists Total Q3: 21  Mark the questions from the formulae and not the values/answers in the cell.  Check against candidate's actual work (Cell references may differ, depending on the candidate's response).  Candidate may use multiple formulae, cells or 'building blocks' to reach answers.  Named ranges can be used instead of cell references.  The answers must still be correct even if values are changed in the existing data. Maximum Candidate No. Criteria Mark Mark Data worksheet 3.1 Cell A3: Format 1  Format of cell A19 applied to cell A3  1 3.2 Cells A4 to G4: Vertically Centred and Border 2 lines/Column Width  Vertically Centred  1  Thick border lines applied to all cells  OR Column C width 1 adjusted 3.3 Cell B18: 4 =ROUNDUP((B17/100000)*8,0) OR =ROUNDUP((SUM(B5:B16)/100000)*8,0)  ROUNDUP (…,0)  1  B17 OR SUM(B5:B16) /100000  2  *8  1 Copyright reserved Please turn over ### Page 6 Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER 3.4 Cell G5: 5 =IF(COUNT(B5:F5)=5,SUM(B5:F5),"") OR =IF(COUNT(B5:F5)<5,"",SUM(B5:F5)) OR =IF(COUNTA(B5:F5)=5,SUM(B5:F5),"") OR =IF(COUNTA(B5:F5)<5,"",SUM(B5:F5)) OR = IF(COUNTBLANK(B5:F5)=0,SUM(B5:F5),"") OR =IF(COUNTBLANK(B5:F5)>0,"",SUM(B5:F5)) OR =IF(COUNTBLANK(B5:F5)<>0,"",SUM(B5:F5)) OR =IF(COUNTBLANK(B5:F5)<1,SUM(B5:F5),"")  Function: IF  1  Criteria: Determine number of cells with/without values  1 OR determine if all cells have values  Value if no empty cells are found:  SUM(B5:F5) 1  Value if empty cells are found:  "" 1  Copied down  1 3.5 Cells F20:F31: Conditional Formatting 4 (This Worksheet → Top rule → Check Edit Rule)  Condition/Criteria: Cell value >  F5  OR Cell value > $F5 2 OR=F5F5 OR =$F20>$F5  No absolute cell referencing on rows  1  Format: Blue fill colour  1 Chart worksheet 3.6 Chart/Graph 5  Data series for 2021: Series Value: Data!$C$20:$C$31  1  Data series for 2020: Series Name: 2020  1  Legend: below  1  Y-Axis: Number format: 'Use 1000 Separator'  1  X-Axis: Custom angle: -45°  1 (Mark by inspection: Can vary between -30 to -50) Total for QUESTION 3 [21] Copyright reserved Please turn over ### Page 7 Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 4 File name: 4Sightings Total Q4: 19  Mark the questions from the formulae and not the values/answers in the cell.  Check against candidate's actual work (Cell references may differ, depending on the candidate's response).  Candidate may use multiple formulae, cells or 'building blocks' to reach answers.  Named ranges can be used instead of cell references.  The answers must still be correct even if values are changed in the existing data. Maximum Candidate No. Criteria Mark Mark Lions worksheet 4.1 Cell D3: 1 =MAX(G7:G105) OR =LARGE(G7:G105,1)  Function: MAX(G7:G105)  1 4.2 Cell D4: 5 =SUMIFS(G7:G105,C7:C105,"Mpila Camp",H7:H105, "TRUE") OR =SUMIFS(G7:G105,H7:H105,"TRUE",C7:C105,"Mpila Camp")  Sum range: G7:G105  1  Criteria range 1: C7:C105  1  Criteria 1: "Mpila Camp"  (Accept if wildcard was 1 correctly used, e.g. "Mpila *", "Mp*", etc.)  Criteria range 2: H7:H105  1  Criteria 2: "TRUE"  OR TRUE 1 4.3 Cell A7: 3 =VLOOKUP(B7,Rangers!$B$2:$E$22,3)  Lookup value: B7  1  Table array: Rangers!$B$2:$E$22  OR 1 Rangers!$B$3:$E$22 OR  Rangers!B2:E22 OR Rangers!B3:E22  Row index number: 3  1 Copyright reserved Please turn over ### Page 8 Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER 4.4 Cell D7: Nested IF function modification 6 =IF(E7<$O$2,"Morning",IF(E7>=$O$3,"Night", "Afternoon")) OR =IF(E7>=$O$3,"Night",IF(E7<$O$2,"Morning", "Afternoon")) OR =IF(E7>=$O$3,"Night",IF(E7>=$O$2,"Afternoon", "Morning"))  Nested IF syntax: Returns correct output  1  Criteria: Start before 12:00 o E7<$O$2  OR E7=$O$3  OR E7>=O3 1 o Output: "Night"  1  Criteria from 12:00 to before 17:30: "Afternoon"  1 (Note to marker: Marks are allocated for two correct criteria and matching output and then one mark for the 'catch-all') (Accept reference to 'Oggend, Middag, Nag/Aand' for criteria) 4.5 Cell F7: 4 =E7+TIME(2,45,0) OR =TIME(HOUR(E7)+2,MINUTE(E7)+45,SECOND(E7))  Hour argument: +2 to original hour  1  Minute argument: +45 to original minutes  1  Second argument: 0  1  Cell reference: E7  1 Total for QUESTION 4 [19] Copyright reserved Please turn over ### Page 9 Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 5 File name: 5Bookings Total Q5: 35 Maximum Candidate No. Criteria Mark Mark Table: tbl5_1 5.1.1 Field: Surname 1  Required: Yes  1 5.1.2 Field: MemberNo (Input Mask) 4 = #2023/01/01# AND <=#2025/12/31 OR > #2022/12/31# AND <#2026/01/01 Copyright reserved Please turn over ### Page 10 Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER Query: qry5_3 5.3  Transport criteria: Taxi  OR Private  2 5  BookingAgent criteria: EasyStay  1  GroupSize criteria: >3 OR >=4 1  AND logic correctly applied  1 OR (Expected number of records: 4 records) Query: qry5_4 5.4  BookingAgent: Total Group By  1 2  Cost: Total: SUM  1 Query: qry5_5 5.5  Calculated field: DOB: [Year] & Left([ID],6) 6  DOB:  1  [Year]  1  & 1  Function: LEFT  1  [ID]  1  6 1 Report: rpt5_6 5.6  Fields displayed: Surname, Name, GroupSize, 6 Accommodation and Transport  1  Grouping: Transport  1  Function inserted in Transport footer  1  =SUM  ([GroupSize])  2  Sorted by Surname  1 Total for QUESTION 5 [35] Copyright reserved Please turn over ### Page 11 Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 6 File names: 6_1Dolphin, 6_2Heritage Total Q6: 15  This question should be marked from the HTML code.  Numerical attribute values and single words do not need to be in inverted commas. Maximum Candidate No. Criteria Mark Mark 6_1Dolphin 6.1.1 Body tag: Text attribute 1 …  Attribute: text="blue"  1 (Note to marker: Do NOT accept font tags) 6.1.2 Heading 2 tags: Did you know? 1

Did you know?

  Heading 2 tags inserted  1 6.1.3 Bold tags 1 The Dolphin Coast … year-round tropical climate.  Bold tags applied to text  1 6.1.4 Link tags 3

For more information e-mail: dolphincoast@gmail.com

 Anchor tags inserted  1  Attribute: href=mailto:dolphincoast@gmail.com  1 (Accept with/without mailto and/or hash tag (#))  Text: dolphincoast@gmail.com (appears twice)  1 Copyright reserved Please turn over ### Page 12 Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER 6_2Heritage 6.2 …  8 …  …
  • Established: 1895
  • Area: 3 280 km squared
  • Reference No.: 345
  • UNESCO Site Id: 914
  • Designated: 2 October 1986
 Image  File extension for image: jpg  1  Table  Background colour: bgcolor="beige"  1  Colspan: colspan="3"  1  Alignment: align="center"  OR 1 OR
…
 Rowspan: rowspan="4"  1  Unordered list  Unordered list tags:
    …
tags  1  Bullet type: type="circle"  1  List tag closed: Area: 3 280 km squared  1 Closing tag(s) or triangular brackets and nesting correctly used.  1 1 Total for QUESTION 6 [15] Copyright reserved Please turn over ### Page 13 Downloaded from hlayiso.com Computer Applications Technology/P1 13 DBE/November 2022 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 7 File names: 7Map, 7TravelMode, 7Travellers Total Q7: 15 Maximum Candidate No. Criteria Mark Mark 7Map 7.1 Table calculation and Textbox 5 7.1.1  Cell calculation: KwaZulu-Natal: =100-  SUM(ABOVE)  2 OR =B11-SUM(B2:B9) OR =SUM(BELOW)-SUM(ABOVE) Alt+F9 { … } 7.1.2  Textbox:  Position: Moved to KwaZulu-Natal area on the map  1  Shape border: No Outline  1  Rotation: Between 300° and 320°  (Mark by inspection) 1 7TravelMode – Info table 7.2  Imported 7Travellers spreadsheet into 7TravelMode database  1 3  As a linked table  1  Linked table named as Info  1 7BigFive 7.3 Cell M2: (Note to marker: OR function not IF statement) 7 =OR(F2=$B$11,F2=$B$12,F2=$B$13,F2=$B$14,F2=$B$15) Versioning: Candidate and Marker MSO 365 Marker in MSO 2016/2019/2021  Cell reference: F2  1  Reference to all 5 options in the OR function  1  Displays required result when copied down to cells M3:M7  1 Cell P3: =COUNTIF(I3:O3,True)=5 OR =IF(COUNTIF(I3:O3,True)=5,True,False)  Determine if all Big Five animals were seen  1 e.g. COUNTIF / IF(COUNTIF) function(s)  References cells in the range I3 to O3  1  Criteria: True  1  Logical: =5  / True, False (Ignore if quotation marks added) 1 Total for QUESTION 7 [15] TOTAL 150 Copyright reserved ## Related documents - [CAT P1 MEMO GR12 SEPT 2022 English](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2022-english/837c4abb-40c6-4f10-a6eb-4a6db8bfe1b4) — Computer Applications Technology · Memo · 2022 · Eng - [Computer Application Technology P1 Nov 2020 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2020-memo-eng/29afe53d-081b-47cd-88fe-246bb4374530) — Computer Applications Technology · Memo · 2021 · Eng - [Computer Application Technology P1 Nov 2019 Memo Afr](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2019-memo-afr/4a07e78a-9b1c-44e8-a466-b6c73c8cac4b) — Computer Applications Technology · Memo · 2019 · Afr - [Computer Application Technology P1 Nov 2018 FINAL Memo Afr1](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2018-final-memo-afr1/8974d61d-2852-48cf-bd6a-b0d1137b07a1) — Computer Applications Technology · Memo · 2018 - [Computer Application Technology P1 Nov 2017 Memo Afr Rewrite](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-afr-rewrite/4c3ced4d-1987-42e1-85c6-38ce6cec21d3) — Computer Applications Technology · Memo · 2017 · Afr - [Computer Application Technology P1 Nov 2017 Memo Eng Rewrite](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2017-memo-eng-rewrite/f3f97e51-029e-44ca-83f9-dff3eec080ff) — Computer Applications Technology · Memo · 2017 · Eng ## More from Grade 12 Computer Applications Technology - [CAT P1 QP GR12 SEPT 2025 AFRIK watermark](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2025-afrik-watermark/1b848d13-4e0f-4b33-91ef-2fcd3dc2e6b9) — QP · 2025 · Afr - [CAT P2 GR12 QP September 2025 ENG watermark](https://www.hlayiso.com/library/cat-p2-gr12-qp-september-2025-eng-watermark/fd63d968-a454-409d-9293-0862b56232b1) — QP · 2025 · Eng - [CAT P1 QP GR12 SEPT 2024 Afrikaans](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-afrikaans/82b87849-4ee6-4b20-8b30-633307bd7329) — QP · 2024 · Afr - [CAT P1 QP GR12 SEPT 2024 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-english/bf2518c3-ae79-4251-8145-1b062895b12f) — QP · 2024 · Eng - [CAT P2 GR12 QP SEPT 2024 English](https://www.hlayiso.com/library/cat-p2-gr12-qp-sept-2024-english/b8b0a9f3-f8c6-4f0a-8ddf-30b58008b603) — QP · 2024 · Eng - [Computer Applications Technology P1 Nov 2024 Afr](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2024-afr/502fe6df-4d11-41d1-8e23-b219565e715b) — QP · 2024 · Afr ## Collection - [Grade 12 past papers](https://www.hlayiso.com/grade-12/past-papers) --- Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.
10 Jewels of the Wetland Park Lake St Lucia
…