# Computer Applications Technology Grade 11 P1 2016 Memo (Eng) > Grade 11 Computer Applications Technology Paper 1 memorandum from the Eastern Cape November 2016 (English), 10 pages. Read online or download the free PDF. - Page: https://www.hlayiso.com/library/cat-p1-gr11-memo-nov2016-eng/b2071b6d-e1cd-462b-b8d0-a71e6401285b - Updated: 2026-09-27 - Subject: Computer Applications Technology - Grade: Grade 11 - Document type: Memorandum - Year: 2016 - Exam period: Eastern Cape November - 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 2016 Memo (Eng)](https://www.hlayiso.com/library/cat-p1-gr11-memo-nov2016-eng/b2071b6d-e1cd-462b-b8d0-a71e6401285b) ## About this document Computer Applications Technology · Grade 11 · Eastern Cape November · 2016. 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 2016 COMPUTER APPLICATIONS TECHNOLOGY P1 MEMORANDUM NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 Q7 MARKS: 180 32 18 50 45 20 09 06 This memorandum consists of 10 pages. ### Page 2 Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2016) QUESTION 1 File Name: 1_uShaka Info No. Criteria Max.  Mark 1.1 1.1.1  Image 1_uShaka.jpg inserted inside the diamond 1 shape in the cover page.  1.1.2  Any glow effect applied to the diamond shape.  1 1.2  6pt spacing added before and after  for the whole 1 document. 1.3  Dropped cap effect added to the letter U over 3 lines  2  Distance from the text set to 1 cm  1.4  Left and bottom margins set to 1.5 cm  1 1.5  Place the paragraph Other attractions include in under 3 columns with equal width   Columns with a line in between   Column spacing set to 1 cm.  4  Applied column breaks for the two green highlighted words The Open Ocean and Seals to start at top of the new column. 1.6  The four paragraphs highlighted in pink made as a bulleted list.  2  1_Wet-n-Wild.jpg used as the bullet.  1.7  Style name changed to Unlimited Fun   Font colour changed to red   Blue paragraph shading applied  5  Right aligned   Update changes to the style for the whole document.  1.8  Footnote added to the text Souvenir  2  Text reads Memento  1.9  Degree (o) symbol inserted correctly as a superscript in both 1 the places  1.10  Bibliography edited to add the URL correctly as 1 www.ushakamarineworld.co.za  1.11  All six awards grouped  2  As single object  1.12  Section break added and changed the page layout of the last page to landscape.  2  Height and width of the uShaka Map changed to 15 cm and 25 cm.  1.13  Format of the TOC changed is Simple  2  Right aligned the page numbers.  Copyright reserved Please turn over ### Page 3 Downloaded from hlayiso.com (EC/NOVEMBER 2016) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.14  Automatic page numbering inserted in the footer.   Format is Page i   No page numbers appear in the first  5  and last page   Page numbering starts from Page i on page 2  Total for QUESTION 1: [32] Copyright reserved Please turn over ### Page 4 Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2016) QUESTION 2 File File Name: 2_Card Authorisation No. Criteria Max.  Mark 2.1  Text form field added after the word I …   Accepts a maximum of 25 characters  3  And displays in CAPITAL letters  2.2  Drop down list added   The following list is listed Platinum 2 Play Normal  2.3 Total Transaction Amount field formatted so that  It accepts 4 digits  2  And displays the value in currency format  2.4  Check box form field added after each card type  Check box size is exactly 15 pt.  2 2.5 Table inserted after the Card Number heading  With 20 columns and 1 row  2  AutoFit to the contents  2.6 Table style applied (other than the default) to the table under 1 the heading Client's Details  2.7  First tab stop set at 8 cm   Second tab stop at 17 cm   Dashed line leader used for both tab stops  3 NB: Tab stops can be set either left or right. 2.8  2_Credit Card Authorisation Form.pdf file inserted as an icon  3  in the text box .  Linked to source file.  Total for QUESTION 2: [18] Copyright reserved Please turn over ### Page 5 Downloaded from hlayiso.com (EC/NOVEMBER 2016) COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 3 File Name: 3_Visitors Analysis No. Criteria Max.  Mark Patient Details worksheet 3.1 Cell O2:  Change the data type of cell O2 to text so that it displays the 1 contact number correctly.  3.2  Cells A1:P1 merged and centred.   Dark blue fill colour added.  2 3.3 Cell A2:  3_Unlimited Fun.jpg inserted in cell A2  3  Height is 2 cm   Width is 17 cm  3.4 Cells H4:L4  Wrap text option used for the cells to display in multiple lines  2  Aligned the cells to the centre both horizontally and vertically.  3.5 Conditional formatting:  Age >60 formatted  3  Thin diagonal stripe pattern style applied   Red pattern colour used  3.6 Cell E5: =IF(D5<=12,"Child",IF(D5>=61,"Pensioner","Adult"))  IF function  Condition D5<=12 and value  5  Condition D5>=61 and value   Value if all conditions are false   Correct use of open and closing brackets  3.7 Cell M5: =COUNTIF(H5:L5,$H$5)  COUNTIF function   Range: H5:L5  5  Criteria: H5 OR any cell with the tick mark   Absolute cell reference used   Auto filled for the rest of the cells  (Note to marker: Accept any other suitable method.) 3.8 Cell P5: =COUNTA(H5)*$H$3+COUNTA(I5)*$I$3+COUNTA(J5)* $J$3+COUNTA(K5)*$K$3+COUNTA(L5)*$L$3  COUNTA function   Ranges H5, I5, J5, K5 and L5  6  * used correctly all through the calculation   + sign correctly used in the formula   H3, I3, J3, K3 and L3 used as the rates for each adventure.   Absolute cell reference used correctly  3.9  Tab colour changed to blue.  1 Copyright reserved Please turn over ### Page 6 Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2016) Monetary Details worksheet 3.10 Cell I3: =IF(G3=1,0.2*H3,IF(G3=2,0.25*H3,IF(G3=3,0.3*H3,"No Discount")))  IF function   Condition G3=1 and value  6  Condition G3=2 and value   Condition G3=3 and value   Value if all conditions are false   Correct use of open and closing brackets  3.11 Cell L2:  =SUMIF(D3:D102,"Pensioner",H3:H102)  SUMIF function  4  Range D3:D102  Criteria "Pensioner"   Sum range is H3:H102  3.12 Cell L5: =COUNTBLANK(J3:J102)  COUNTBLANK function  2  Range J3:J102  3.13 Current Date and Time  Inserted as a field in the header  2  Updates automatically.  Graph worksheet 3.14 Graph  Column graph created  with correct data   Chart title reads Preferred Adventure Per Gender Category.   X axis title is Adventure  8  Y axis title is Gender Total   Highest data bar filled with the image 3_Icon.jpg   Legend displayed at the bottom of the graph   Gridlines not displayed  Total for QUESTION 3: [50] Copyright reserved Please turn over ### Page 7 Downloaded from hlayiso.com (EC/NOVEMBER 2016) COMPUTER APPLICATIONS TECHNOLOGY P1 7 QUESTION 4 File Name: 4_Visitors Details No. Criteria Max.  Mark Table: Visitors Details 4.1 4.1.1  Row height of the table changed to 20pt.  1 4.1.2  Only horizontal gridlines are visible.  1 4.1.3  Alternate row colour to green.  2  Background colour level is yellow.  4.1.4  Table sorted in ascending order of Surname 1 field.  4.1.5 Input mask on the Cell Number field: (000)0000000  Input mask inserted for the Cell Number field 3  0000000000 (ten zeros)   Bracket inserted correctly  4.1.6  Visitor Pass ID field made as the primary key.  1 4.1.7  Drop down list added for the Gender Category field. 3  Row source type changed to value list   Values entered correctly.  4.1.8  Data type changed to currency for Pass Rates 1 field.  4.1.9  Gender Category moved before the Age field.  1 4.1.10  Required property set to Yes for Gender 1 Category field.  4.1.11 Validation Rule for Age field.  Between 3  And 70  OR any possible answer like >=3 And <=70 3 Validation message for Age field.  Suitable validation message added  Query: qry4_2 4.2  Name, Wet 'n Wild and Sea World fields are displayed.  5  Criteria: Wet 'n Wild field: yes  Criteria: Sea World field: yes  Criteria: Gender Category field: adult   or pensioner  Copyright reserved Please turn over ### Page 8 Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2016) Query: qry4_3 4.3 4  Criteria Cell Number field: Like "082*"  And  Like "*5"   Criteria Residing City field: Benoni  NOTE: The query should display 2 records. Form: frm4_4 4.4  Name, Gender Category, Pass Type, Wet 'n Wild, Sea World, Kids World, Dangerous Creatures and Chimp_Zee fields displayed.   Heading changed to Platinum Pass Members   Form header and footer filled with a black fill colour   Wet 'n Wild, Sea World, Kids World, Dangerous Creatures and Chimp_Zee fields are displayed on the right- hand side  7  of the detail section with a line in between  as shown below.  4_Platinum Pass.jpg inserted in the form header.  With height and width set to 3 cm.  Report: rpt4_5 4.5  Displayed the fields Name, Gender Category, Residing City, Wet 'n Wild, Sea World, Kids World and Pass Rates.   Grouped based on Gender Category field.   Sorted based on Residing City field.  Average amount paid by each gender category: Calculation in the Gender Category group footer: 9 =AVG  ([Pass Rates])   Displayed in Rands   With 2 decimal places  Total number of records in the report:  Calculation in the report footer: =COUNT(*)   Proper labels for both calculations.  4.6  rpt4_5 exported to Microsoft Word.  2  Saved as 4_Export in the exam folder.  Total for QUESTION 4: [45] Copyright reserved Please turn over ### Page 9 Downloaded from hlayiso.com (EC/NOVEMBER 2016) COMPUTER APPLICATIONS TECHNOLOGY P1 9 QUESTION 5 File Name: 5_uShaka  This question should be marked from the browser as far as possible, unless otherwise indicated or if it cannot be seen on the browser.  A maximum of 1 mark will be deducted if one or more closing tags are omitted. No. Criteria Max.  Mark 5.1 Title Unlimited Fun@uShaka 2  'Unlimited Fun@uShaka' appears   In the browser tab  5.2  Background colour changed to yellow  1 5.3 Font tag 2  font face is century gothic   and tag closed correctly  5.4 Heading style:

Unlimited Fun for EVERYONE!

1 Closing tag for

tag corrected.  5.5 Horizontal line size and colour
 Line size set to 4   Line colour set to red  3  Inserted after the heading 'Unlimited Fun for EVERYONE!' and before the last line of the web page starting with 'For more information …'  5.6 Ordered List for lists under the heading Sea World
    2  Type   Listed as A, B, C etc.  5.7 Image Unlimited Fun  5_Fun Unlimited.jpg image inserted before the heading Wet 'n Wild  6  Image displays correctly   Height is 50%   Width is 25%   Alignment to the right   Alternate text reads 'Unlimited Fun'  5.8 Italics tag: call 031 328 8000 1  Text is displayed in italics  5.9 Link www.ushakamarineworld.co.za 2  Link moves to 'www.ushakamarineworld.co.za'   Link works correctly  Total for QUESTION 5: [20] Copyright reserved Please turn over ### Page 10 Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2016) QUESTION 6 File Name: 6_Comparison 6_Visitor Trend No. Criteria Max.  Mark 6_Comparison (Word processing document) 6.1 6.1.1 Formula used in the shaded region =MAX(ABOVE) 2  MAX function used   Criteria is ABOVE  6.1.2 Paste graph as a link  Graph pasted in the allocated area from 6_Visitor Trend spreadsheet file  2  Pasted as a link so that it updates automatically. 6.1.3 Custom watermark  Custom watermark reads STATISTICS  2  Font size for the watermark is 90  6.1.4  File name inserted as a field   In the header of the document.  3  Displayed in UPPERCASE  Total for QUESTION 6: [9] QUESTION 7 File Name: 7_Birthday Invitation 7_Birthday Months No. Criteria Max.  Mark 7_Birthday Invitation (Word processing document) 7.1 7.1.1 Mail Merge:  Month Of Birth worksheet in 7_Birthday Months spreadsheet used as the data source.   Name field added.   Filtering option used to select only 'Child' from Gender Category field.  6  Filtering option used to select only 'December' from Month Of Birth field.   Name field sorted in the ascending order   Mail merge completed and saved as 7_Merged Invitation (3 letters expected) Total for QUESTION 7: [6] TOTAL: 180 Copyright reserved Please turn over ## Related documents - [CAT P1 GR12 MEMO NOV2016 AFR](https://www.hlayiso.com/library/cat-p1-gr12-memo-nov2016-afr/0d30d9cc-3bb9-4e55-812f-23f990990239) — Computer Applications Technology · Memo · 2016 · Afr - [CATN P1 GR11 SEPT2016 QP Afr](https://www.hlayiso.com/library/catn-p1-gr11-sept2016-qp-afr/3b5f6012-f59b-4196-8c04-bd26bf220ad9) — Computer Applications Technology · QP · 2016 · Afr - [CATN P1 GR12 NOV2016 QP Eng](https://www.hlayiso.com/library/catn-p1-gr12-nov2016-qp-eng/b2c53b10-f39b-4697-a1f1-e7d57c0e10b7) — Computer Applications Technology · QP · 2016 · Eng - [CAT P2 GR11 MEMO AFR NOV2016](https://www.hlayiso.com/library/cat-p2-gr11-memo-afr-nov2016/933641ee-b64b-4359-b9aa-bdfac81a6dd9) — Computer Applications Technology · Memo · 2016 · Afr - [CAT P2 GR11 MEMO ENG NOV2016](https://www.hlayiso.com/library/cat-p2-gr11-memo-eng-nov2016/058fe5a3-03b9-4068-8c91-187650e0fc46) — Computer Applications Technology · Memo · 2016 · Eng - [CAT P1 MEMO GR11 NOV 2020 AFR D](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2020-afr-d/5b4dbc89-ee3d-4dae-b544-5840b8d39592) — Computer Applications Technology · Memo · 2020 · Afr ## 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.