# 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-docx/edc66805-6745-4779-9ac0-6d2ec33b4148 - 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-docx/edc66805-6745-4779-9ac0-6d2ec33b4148) ## 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 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 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  Size exactly 5 cm x 5 cm  1 2  Lock aspect ratio unchecked  1 1.1.2 Cover Page 1 1  Picture position set to Middle Centre  1.1.3 Cover Page  Learner name and surname inserted in author 1 1 control  1.2 Page Numbering  Border left page numbering used  1 2  Zero on first page removed (different first page)  1 1.3 Breaks 1 1  Page break used  1.4. Styles  New Style Eastern Cape Coasts created  1 1  Based on Heading 1 style  1  New style horizontally centred  5 1  Font colour of style is red  1  Style applied to heading  1.5.1 Table of Contents  Table of content inserted  1  Modern style format used  1 3  Ensure that heading ‘Wild Coast Region, Eastern 1 Cape’ appears in TOC  1.5.2 Table of Figures  Picture captioned  1 2  Table of figures updated  1 1.6 Footnote  Footnote inserted  1  Below the text  1 4  Wingdings character code 0046 or 70  used  1 1  Text ‘(www.wildcoast.com/xolobeni)’ added  1.7 Find and Replace 1  Transkei replaced with Former Transkei  2 1  All five occurrences replaced  Copyright reserved Please turn over ### Page 3 (EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.8 Citation  Web site chosen source  1  Wild Coast inserted as web site name  1 3  www.wildcoast.com inserted as the URL  1 1.9 Shapes  Horizontal scroll shape inserted  1  Correct text added/Copied  1 4  Shape style changed to Subtle effect – Blue Accent 1 1 1  Yellow text highlight removed from inserted text  Total for QUESTION 1 [30] Copyright reserved Please turn over ### Page 4 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  WordArt changed  1 2  Changed / transformed to Warped Ring Inside.  1 2.1.2 Grouping  Any picture inserted.  1  Picture 2Form.jpg inserted.  1 3  Picture and WordArt grouped.  1 2.2 Page background  Page background inserted.  1 1 3  Vertical gradient fill used.   Two colours, blue and white, used.  1 2.3 Watermark  Watermark inserted  1 1 3  2Watermark.jpg image used   Image scaled to 120%  1 2.4 Tabs  Tabs set to Surname  1 3  First tab set at 6 cm centred.  1  Second tab set at 14 cm right align.  1 2.5.1  Surname text form field 20 characters  1 2.5.2  Gender changed to dropdown form field  1  Male and Female entered.  1 6 2.5.3  The check box form field set to 14 pt  1  exactly  1  and BnB field checked.  1 Total for QUESTION 2 [20] Copyright reserved Please turn over ### Page 5 (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  Cells A1 to Q1 are merged  1 2  and centred  1 3.1.2 Shading 1  Shading applied on merged cell  1  “From Corner” shading style used  4 1  use 2 colours   namely yellow and blue.  1 3.2 Date 1  D2: Today’s date inserted  2  Date format changed to dd-mm-yyyy  1 3.3 Wrap text  Text in row 4 wrapped  1 1 3.4 Freeze Panes  Row 4 frozen  1  All other text moves under row 4 when user scrolls 2 1 down  3.5 Printing 1  Row 1 to row 4 to repeat  1 3  at the top of each page  1  Gridlines inserted (ticked)  3.6 Conditional formatting  Conditional formatting applied in correct column 1 (column G)  1 3  Criteria only hotels  1  Reddish fill colour used  3.7 Column I  Rand Currency or Accounting  1 2  Zero decimal places  1 3.8 Cell D67 =MAX(H5:H64) / =LARGE((H5:H64),1) 1 2  Correct cells used  1  Max / large function used  3.9 Cell D69 =SUMIF(E5:E64,"China",L5:L64) 1  Sumif function correctly used  1 4  Criteria range E5:E64  1 1  Sum range L5:L64   Criteria – China  Copyright reserved Please turn over ### Page 6 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) 3.10 Cell D71 =(H5*J5)*K5 1  H5 and J5 used  3 1  * sign used  1  K5  3.11 Cell D73 =COUNTBLANK(L5:L64) 1 2  Correct function used  1  Correct range used  3.12 Cell D75 =COUNTA(N5:N64) 2  Correct function used  1  Correct range used  1 3.13 Cell D77 =IF(L5>=3000,"Type A Accommodation","Regular Accommodation")  Correct function used  1 4  Correct condition specified  1  Value if true is correct  1  Value if false is correct  1 3.14 Cell D79 =L5/G2 2  Countif function used  1  Correct range  1 3.15 Cell Q5 =IF(COUNTA(M5:P5)>3;(0,3*H5);IF(COUNTA(M5:P5)=3; (0,15*H5);” “))  Function = IF  1  First condition: (COUNTA(M5:P5) >3  1 1 7  1,3*H5   Second condition: COUNTA(M5:P5)=3  1  1,15*H5  1  Value false condition: “ “ or Blank  1  Function copied to all cells  1 Lodge worksheet 3.16 Tab colour  Tab colour of Lodge worksheet set to blue  1 1 3.17 Filtering  Filtering used  1 2  on Type of Accommodation column  1 Copyright reserved Please turn over ### Page 7 (EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 7 3.18 Graph Worksheet  Sort table from Large to Small  1  Graph created  1 5  Graph title Wild Coast Lodges  1  Both series points plotted correctly.  1  Gap width set to 50%  1 Total for QUESTION 3 [53] Copyright reserved Please turn over ### Page 8 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  Row height set at 25 pt.  4.1.2 Row colour  Alternative row colour set to red.  1 2  Background colour set to green.  1 4.1.3 Field: Cell Number  Input mask set.  1 3  Ten compulsory numbers.  1  Correct format 000-0000 000.  1 4.1.4 Field: Cell Number 1 1  Cell Number field is set to Yes.  4.1.5 Field: Age 1  Validation rule: Between 18  1 3  And 60.  1  Suitable validation text inserted.  4.1.6 Field: Deposit Paid 1  Changed to currency.  2 1  With 2 decimal places.  4.1.7 Field: Home Combo box created in Home Town field.  1 Value list added.  3 1 All towns included (Port Elizabeth/East 1 London/Mthatha/Queenstown).  4.1.8 Field: email address 1 1  < symbol set on format  Form 4.2 Visitors Info  Form Visitors Info created.   Only Visitor, Gender, Email address, Country, 1 Number of people, Number of days and Deposit 1 field appear.  1  Image 4WildCoast.jpg used.  1  Centred in form header.  1 9  Date and time inserted.  1  Country field sorted alphabetically.  1  In descending order.  1 1  Any button inserted in the form footer.   Button action is to close the form.  Copyright reserved Please turn over ### Page 9 (EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 9 Queries 4.3 QryFemales  Fields used: Visitor, Deposit and Gender.  1 1  Gender does not show.  1 1  Gender criteria: Female.  1 5  Deposit criteria: >=  3200.  4.4 Qry4_4  Criteria of Country field: Russia.  Design view  Total function is used.   From the datasheet view.   Total deposits of the Russian visitors. (Sum)  1 1 1 4 1 Total for QUESTION 4 [34] Copyright reserved Please turn over ### Page 10 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  Data exported from Spreadsheet 5WildCoast 1 Resource.  1  Exported to a new database – table - 5Resource.  1 6  Peak Rates, Number of Days and Deposits are assigned the correct data type.  1  Type of Accommodation moved to the first field.  1  Table sorted by Type of Accommodation field.  1  In descending order.  5.2 Graph  Graph created using the data in Sheet 2.  1  Countif: Females.  1  Countif: Males.  1  Pie Graph is used  7 1  Appropriate heading – anything around percentage per gender.  1  Graph is moved to the word document, 5MyDoc.  1  Paste special is used when pasting the graph.  1 Total for QUESTION 5 [13] TOTAL 150 Copyright reserved Please turn over ## Related documents - [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 ENG D](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2020-eng-d/626bb77a-d3e1-44d5-b03e-7d722e43252f) — Computer Applications Technology · Memo · 2020 · Eng - [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.