# Computer Applications Technology Grade 11 P1 2020 Memo (Eng) > Grade 11 Computer Applications Technology Paper 1 memorandum from the National Exemplar November Exam 2020 (English). Read online or download the free PDF. - Page: https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2020-eng-d/626bb77a-d3e1-44d5-b03e-7d722e43252f - Updated: 2026-09-27 - Subject: Computer Applications Technology - Grade: Grade 11 - Document type: Memorandum - Year: 2020 - Exam period: National Exemplar November Exam - Paper: 1 - Curriculum: CAPS - Pages: 10 Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 11](https://www.hlayiso.com/library/grade-11) › [Computer Applications Technology](https://www.hlayiso.com/library/grade-11/computer-applications-technology) › [Computer Applications Technology Grade 11 P1 2020 Memo (Eng)](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2020-eng-d/626bb77a-d3e1-44d5-b03e-7d722e43252f) ## About this document Computer Applications Technology · Grade 11 · National Exemplar November Exam · 2020. Memorandum, 10 pages. 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 11 NOVEMBER 2020 COMPUTER APPLICATIONS TECHNOLOGY P1 MARKING GUIDELINE (EXEMPLAR) NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 MARKS: 150 30 20 53 34 13 This marking guideline consists of 10 pages. ### Page 2 Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) QUESTION 1 File Name: 1WildCoast Total Q1: 30 Maximum Candidate No. Criteria Mark Mark 1.1.1 Cover Page x Size exactly 5 cm x 5 cm 9 1 2 x Lock aspect ratio unchecked 9 1 1.1.2 Cover Page 1 1 x Picture position set to Middle Centre 9 1.1.3 Cover Page x Learner name and surname inserted in author 1 1 control 9 1.2 Page Numbering x Border left page numbering used 9 1 2 x Zero on first page removed (different first page) 9 1 1.3 Breaks 1 1 x Page break used 9 1.4. Styles x New Style Eastern Cape Coasts created 9 1 1 x Based on Heading 1 style 9 1 x New style horizontally centred 9 5 1 x Font colour of style is red 9 1 x Style applied to heading 9 1.5.1 Table of Contents x Table of content inserted 9 1 x Modern style format used 9 1 3 x Ensure that heading ‘Wild Coast Region, Eastern 1 Cape’ appears in TOC 9 1.5.2 Table of Figures x Picture captioned 9 1 2 x Table of figures updated 9 1 1.6 Footnote x Footnote inserted 9 1 x Below the text 9 1 4 x Wingdings character code 0046 or 70 ) used 9 1 1 x Text ‘(www.wildcoast.com/xolobeni)’ added 9 1.7 Find and Replace 1 x Transkei replaced with Former Transkei 9 2 1 x All five occurrences replaced 9 Copyright reserved Please turn over ### Page 3 Downloaded from hlayiso.com (EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.8 Citation x Web site chosen source 9 1 x Wild Coast inserted as web site name 9 1 3 x www.wildcoast.com inserted as the URL 9 1 1.9 Shapes x Horizontal scroll shape inserted 9 1 x Correct text added/Copied 9 1 4 x Shape style changed to Subtle effect – Blue Accent 1 19 1 x Yellow text highlight removed from inserted text 9 Total for QUESTION 1 [30] Copyright reserved Please turn over ### Page 4 Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) QUESTION 2 File Name: 2Form Total Q2: 20 Maximum Candidate No. Criteria Mark Mark 2.1.1 WordArt x WordArt changed 9 1 2 x Changed / transformed to Warped Ring Inside. 9 1 2.1.2 Grouping x Any picture inserted. 9 1 x Picture 2Form.jpg inserted. 9 1 3 x Picture and WordArt grouped. 9 1 2.2 Page background x Page background inserted. 9 1 1 3 x Vertical gradient fill used. 9 x Two colours, blue and white, used. 9 1 2.3 Watermark x Watermark inserted 9 1 1 3 x 2Watermark.jpg image used 9 x Image scaled to 120% 9 1 2.4 Tabs x Tabs set to Surname 9 1 3 x First tab set at 6 cm centred. 9 1 x Second tab set at 14 cm right align. 9 1 2.5.1 x Surname text form field 20 characters 9 1 2.5.2 x Gender changed to dropdown form field 9 1 x Male and Female entered. 9 1 6 2.5.3 x The check box form field set to 14 pt 9 1 x exactly 9 1 x and BnB field checked. 9 1 Total for QUESTION 2 [20] Copyright reserved Please turn over ### Page 5 Downloaded from hlayiso.com (EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 3 File Name: 3Wild Coast Visitors Total Q3: 53 Maximum Candidate No. Criteria Mark Mark Information worksheet 3.1.1 Merge and Centre x Cells A1 to Q1 are merged 9 1 2 x and centred 9 1 3.1.2 Shading 1 x Shading applied on merged cell 9 1 x “From Corner” shading style used 9 4 1 x use 2 colours 9 x namely yellow and blue. 9 1 3.2 Date 1 x D2: Today’s date inserted 9 2 x Date format changed to dd-mm-yyyy 9 1 3.3 Wrap text x Text in row 4 wrapped 9 1 1 3.4 Freeze Panes x Row 4 frozen 9 1 x All other text moves under row 4 when user scrolls 2 1 down 9 3.5 Printing 1 x Row 1 to row 4 to repeat 9 1 3 x at the top of each page 9 1 x Gridlines inserted (ticked) 9 3.6 Conditional formatting x Conditional formatting applied in correct column 1 (column G) 9 1 3 x Criteria only hotels 9 1 x Reddish fill colour used 9 3.7 Column I x Rand Currency or Accounting 9 1 2 x Zero decimal places 9 1 3.8 Cell D67 =MAX(H5:H64) / =LARGE((H5:H64),1) 1 2 x Correct cells used 9 1 x Max / large function used 9 3.9 Cell D69 =SUMIF(E5:E64,"China",L5:L64) 1 x Sumif function correctly used 9 1 4 x Criteria range E5:E64 9 1 x Sum range L5:L64 9 1 x Criteria – China 9 Copyright reserved Please turn over ### Page 6 Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) 3.10 Cell D71 =(H5*J5)*K5 x H5 and J5 used 9 1 3 1 x * sign used 9 1 x K5 9 3.11 Cell D73 =COUNTBLANK(L5:L64) 1 2 x Correct function used 9 1 x Correct range used 9 3.12 Cell D75 =COUNTA(N5:N64) 2 x Correct function used 9 1 x Correct range used 9 1 3.13 Cell D77 =IF(L5>=3000,"Type A Accommodation","Regular Accommodation") x Correct function used 9 1 4 x Correct condition specified 9 1 x Value if true is correct 9 1 x Value if false is correct 9 1 3.14 Cell D79 =L5/G2 2 x Countif function used 9 1 x Correct range 9 1 3.15 Cell Q5 =IF(COUNTA(M5:P5)>3;(0,3*H5);IF(COUNTA(M5:P5)=3; (0,15*H5);” “)) x Function = IF 9 1 x First condition: (COUNTA(M5:P5) >3 9 1 1 7 x 1,3*H5 9 x Second condition: COUNTA(M5:P5)=3 9 1 x 1,15*H5 9 1 x Value false condition: “ “ or Blank 9 1 x Function copied to all cells 9 1 Lodge worksheet 3.16 Tab colour x Tab colour of Lodge worksheet set to blue 9 1 1 3.17 Filtering x Filtering used 9 1 2 x on Type of Accommodation column 9 1 Copyright reserved Please turn over ### Page 7 Downloaded from hlayiso.com (EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 7 3.18 Graph Worksheet x Sort table from Large to Small 9 1 x Graph created 9 1 5 x Graph title Wild Coast Lodges 9 1 x Both series points plotted correctly. 9 1 x Gap width set to 50% 9 1 Total for QUESTION 3 [53] Copyright reserved Please turn over ### Page 8 Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) QUESTION 4 File Name: 4WildCoast Total Q4: 34 Maximum Candidate No. Criteria Mark Mark 4.1.1 Row height 1 1 x Row height set at 25 pt. 9 4.1.2 Row colour x Alternative row colour set to red. 9 1 2 x Background colour set to green. 9 1 4.1.3 Field: Cell Number x Input mask set. 9 1 3 x Ten compulsory numbers. 9 1 x Correct format 000-0000 000. 9 1 4.1.4 Field: Cell Number 1 1 x Cell Number field is set to Yes. 9 4.1.5 Field: Age 1 x Validation rule: Between 18 9 1 3 x And 60. 9 1 x Suitable validation text inserted. 9 4.1.6 Field: Deposit Paid 1 x Changed to currency. 9 2 1 x With 2 decimal places. 9 4.1.7 Field: Home xCombo box created in Home Town field. 9 1 xValue list added. 9 3 1 xAll towns included (Port Elizabeth/East 1 London/Mthatha/Queenstown). 9 4.1.8 Field: email address 1 1 x < symbol set on format 9 Form 4.2 Visitors Info x Form Visitors Info created. 9 x Only Visitor, Gender, Email address, Country, 1 Number of people, Number of days and Deposit 1 field appear. 9 1 x Image 4WildCoast.jpg used. 9 1 x Centred in form header. 9 1 9 x Date and time inserted. 9 1 x Country field sorted alphabetically. 9 1 x In descending order. 9 1 1 x Any button inserted in the form footer. 9 x Button action is to close the form. 9 Copyright reserved Please turn over ### Page 9 Downloaded from hlayiso.com (EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 9 Queries 4.3 QryFemales x Fields used: Visitor, Deposit and Gender. 9 1 1 x Gender does not show. 9 1 1 x Gender criteria: Female. 9 1 x Deposit criteria: >= 9 3200. 9 5 4.4 Qry4_4 x Criteria of Country field: Russia. 9 Design view x Total function is used. 9 x From the datasheet view. 9 x Total deposits of the Russian visitors. (Sum) 9 1 1 1 4 1 Total for QUESTION 4 [34] Copyright reserved Please turn over ### Page 10 Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) QUESTION 5 File Name: 5WildCoast Resource Total Q5: 13 Maximum Candidate No. Criteria Mark Mark 5.1 Export Data x Data exported from Spreadsheet 5WildCoast 1 Resource. 9 1 x Exported to a new database – table - 5Resource. 9 1 6 x Peak Rates, Number of Days and Deposits are assigned the correct data type. 9 1 x Type of Accommodation moved to the first field. 9 1 x Table sorted by Type of Accommodation field. 9 1 x In descending order. 9 5.2 Graph x Graph created using the data in Sheet 2. 9 1 x Countif: Females. 9 1 x Countif: Males. 9 1 x Pie Graph is used 9 7 1 x Appropriate heading – anything around percentage per gender. 9 1 x Graph is moved to the word document, 5MyDoc. 9 1 x Paste special is used when pasting the graph. 9 1 Total for QUESTION 5 [13] TOTAL 150 Copyright reserved Please turn over ## Related documents - [CAT P1 MEMO GR11 NOV 2020 ENG .docx](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2020-eng-docx/edc66805-6745-4779-9ac0-6d2ec33b4148) — Computer Applications Technology · Memo · 2020 · Eng - [CAT P1 QP MEMO GR11 NOV 2020 AFR D](https://www.hlayiso.com/library/cat-p1-qp-memo-gr11-nov-2020-afr-d/f2a72551-9050-46a8-b88e-1b28a007d393) — Computer Applications Technology · Memo · 2020 · Afr - [CAT P1 MEMO GR11 NOV 2020 AFR D](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2020-afr-d/1fac92e5-647f-4bed-b2bf-2c06bca11bc2) — Computer Applications Technology · Memo · 2020 · Afr - [CAT P1 MEMO GR11 NOV 2020 AFR .docx](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2020-afr-docx/0b1ffd6b-2131-4541-9312-0624a821f52a) — Computer Applications Technology · Memo · 2020 · Afr - [CAT P1 QP MEMO GR11 NOV 2020 ENG D](https://www.hlayiso.com/library/cat-p1-qp-memo-gr11-nov-2020-eng-d/3f9f0dba-a9cb-4ebb-80b5-8a1760f6e35b) — Computer Applications Technology · Memo · 2020 · Eng - [CAT P1 QP GR11 NOV 2020 ENG](https://www.hlayiso.com/library/cat-p1-qp-gr11-nov-2020-eng/f22727e6-48a7-4d29-9689-17fd4a8cd908) — Computer Applications Technology · QP · 2020 · Eng ## More from Grade 11 Computer Applications Technology - [CAT Grade 11 Teacher's Guide v2](https://www.hlayiso.com/library/cat-grade-11-teacher-s-guide-v2/60db7f6c-ce96-4df2-a9d1-f5b6025c8386) — Guide - [Gr11 CAT Practical LB print 20-9-19](https://www.hlayiso.com/library/gr11-cat-practical-lb-print-20-9-19/07dcc91e-6e6d-4426-af23-33bd059dee2f) — Textbook - [Gr11 CAT Practical LB web 20-9-19](https://www.hlayiso.com/library/gr11-cat-practical-lb-web-20-9-19/53763877-ca8b-4e6f-a0b4-5472a940eac2) — Textbook - [Gr11-CAT-TG-Study-Guide LR](https://www.hlayiso.com/library/gr11-cat-tg-study-guide-lr/fc7c0458-b409-4945-b66a-1e47960bd705) — Guide - [Gr11 CAT Theory LB print 19-11-19](https://www.hlayiso.com/library/gr11-cat-theory-lb-print-19-11-19/9605fb7a-c0fc-44fb-bf73-5bc54e1e618e) — Textbook - [Grade 11 CAT P1 November 2026 Mock](https://www.hlayiso.com/library/grade-11-computer-applications-technology-2026-november-mock-exam-question-paper-paper-1/4876f0e2-e346-4e36-8971-81494db33178) — QP · 2026 · Eng ## Collection - [Grade 11 past papers](https://www.hlayiso.com/grade-11/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.