# Computer Applications Technology Grade 11 P1 2013 Memo (Eng) > Grade 11 Computer Applications Technology Paper 1 memorandum from the Eastern Cape November 2013 (English), 10 pages. Read online or download the free PDF. - Page: https://www.hlayiso.com/library/catn-p1-memo-eng-gr11-nov2013/676a2277-a921-4985-aa59-89514cf5cd21 - Updated: 2026-09-27 - Subject: Computer Applications Technology - Grade: Grade 11 - Document type: Memorandum - Year: 2013 - 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 2013 Memo (Eng)](https://www.hlayiso.com/library/catn-p1-memo-eng-gr11-nov2013/676a2277-a921-4985-aa59-89514cf5cd21) ## About this document Computer Applications Technology · Grade 11 · Eastern Cape November · 2013. 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 2013 COMPUTER APPLICATIONS TECHNOLOGY P1 MEMORANDUM NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 Q7 MARKS: 180 42 15 43 15 42 20 3 This memorandum consists of 10 pages. ### Page 2 Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2013) QUESTION 1 File: q1Form No. Criteria Max.  Mark Open the file q1Form 1.1 Cover page 1  Replaced with Alphabet cover page  1.2 Alignment 1  Entire document: Justified  1.3 Language 1  Entire document: English (South Africa)  1.4 Spelling 1  All errors corrected  1.5 Automatic hyphenation 1  Applied to the entire document  1.6 Main heading is formatted as follows:  Style Title is applied to the main heading: “Computers 1 in…Realities”  1.7 Content page  Automatic table of contents is created  2  Only headings formatted with the style Heading 1 appear in the table of contents  1.8 Columns  Correct text appears in two columns  2  1 cm/0.39 inches spacing between columns  1.9 Bullets  Bullets are changed to Wingdings (56)   2  Bullet size 14 pt  1.10 Replace  All occurrences where two space were left was 1 replaced with one space  1.11 WordArt heading is formatted as follows:  Filled with a Water droplets texture  3  Horizontally centred above the image   Spacing between letters adjusted to Very Loose  1.12 Paragraph indentation:  Left indentation is removed from the paragraph shaded 1 in blue  1.13 Footnote  Numbered footnote is inserted next to “Web Based learning”  2  Footnote wording “Online Education” appears on the same page  1.14 Page Footer  Automatic page numbers are inserted in the footer (of the odd pages)  The file name is inserted as a field in the footer (of the 4 even pages)  The odd and even page are different   The data in the even and odd pages is correct  ### Page 3 Downloaded from hlayiso.com (NOVEMBER 2013) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.15 Reference Source  Reference added  2  Automatic Bibliography using all Reference sources is inserted  1.16 The form at end of the document is formatted as follows: 1.16.1 Form field shading is showing  1 1.16.2  Drop-down Form Field inserted next to “Title”  2  Options added: Mr, Mrs, Miss and Dr  1.16.3  Check box Form Fields inserted   Next to “CAT” and “Tourism”  2 1.16.4 The Text Form Field next to “Today’s date” is  A Current date type  2  Formatted as follows: yyyy-MM-dd  1.16.5 The properties of Text Form Field for “Child’s 1 Name” is set to display in Uppercase 1.16.6 Table  Table inserted next to “ID Number”  3  13 columns and one row   Columns are 0.5 cm wide  1.16.7 Leader Tab  A solid line leader tab is inserted next to “Signature”  2  The leader tab starts at 6 cm and ends at 14 cm  1.17 Page Border  Page border inserted  3  3 pt double line   Around the second last page only  1.18 Learner name added as Author of the document  1 [42] ### Page 4 Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2013) QUESTION 2 File: q2Letter; q2Merge No. Criteria Max.  Mark Open the file q2Letter 2.1 Drop Cap  Drop effect does not appear in the margin  2  Dropped over 2 lines  2.2 Margins 1  Right margin is changed to 1.5 cm  2.3 Line spacing 1  Changed to exactly 15 pt for the entire document  2.4 Watermark 1  Picture watermark is removed  2.5 Mail Merge 1  The q2Parent table is linked as a data source  2.6 Mail Merge fields  Merge fields are inserted 2  All placeholders are replaced with the correct fields 2.7 Integration  The content of the Table worksheet is pasted (keeping 2 source formatting) in the correct position   The table is pasted as a linked object  2.8 Rule inserted  The rule is inserted below the table   Message displayed for those who are not hostel 3 borders: “Please hand in at the office”   Message displayed for hostel borders: “Please post to our school”  2.9 Final step for Mail Merge completed:  Only recipients who do not have email addresses are 2 selected   Merged document is saved as q2Merge  [15] ### Page 5 Downloaded from hlayiso.com (NOVEMBER 2013) COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 3 File: q3Incredible No. Criteria Max.  Mark Open the Info worksheet (Incredible renamed to Info) 3.1 Heading  “Incredible Computer Stock” is typed in Row 1  2  Font size 25 pt  3.2 Row Height 1  Row 1: height 60  3.3 Merge Range A1:I1  Cells A1:I1 merged 2  Text centred vertically and horizontally  3.4 Border  Green border added to Row 1  2  Below the merged cells 3.5 Row 2  Text wrapped  2  Text alignment vertical  3.6 Row 2  Row height changed to match example  2  All headings are centred vertically and horizontally and look exactly the same as the example  3.7 Cell J1 1  Current date inserted: =TODAY() 3.8 Sheet name and colour  Rename Incredible to Info  2  Tab Colour changed to Red  3.9 The panes of the worksheet are changed to “Unfreeze”  1 3.10 Range E3:E83 1  Changed to South African currency  3.11 Column F 1  Date format: e.g. 01 February 2012  3.12 Cell C91 1  Spelling error corrected = Average(E3:E83)  3.13 Column E  Original Conditional Formatting Rule removed   New condition added: Above Average in Red  2 (Note that other correct solutions must also be accepted) ### Page 6 Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2013) 3.14 Cell E86: =ROUND(AVERAGE(E3:E83),2)  ROUND function used   AVERAGE function used   Correct range  4  Correct number of decimal places and use of brackets  3.15 Functions: 3.15.1 Cell C84: =COUNTA(D3:D83)  =COUNTA  2  (D3:D83)  3.15.2 Cell C86: =LARGE(E3:E83,2)  =LARGE  2  (E3:E83,2)  3.15.3 Cell C88: =COUNTIF(C3:C83,"*Printer*”)  =COUNTIF   Correct range  4  "Printer"   Use of wild card *  3.16 Range A3:I83: sorted  First by: Room No  2  Secondly by: Device Type  Open the Protect worksheet 3.17 Protection  Password stored as comment in Cell A1 is used to  2  Unprotect the worksheet  (Note: only 0 or 2 marks can be allocated) Open the UserCodes worksheet 3.18 Cell B2: =RAND()*100 OR RANDBETWEEN(0,99)  RAND()   Multiply  4  by 100   Formatted to show no decimal places  Open the Info worksheet 3.19 Cell H4 1  UserCodes!B3  Open the Import worksheet 3.20  Data imported from text file called Upload  2  To the worksheet called Import  [43] ### Page 7 Downloaded from hlayiso.com (NOVEMBER 2013) COMPUTER APPLICATIONS TECHNOLOGY P1 7 QUESTION 4 File: q4Statistics No. Criteria Max.  Mark Open the Invoice worksheet 4.1 File Path: &[Path]&[File] 1  Inserted on the right hand side of the page header  4.2 Cell F22: =SUM(F10:F13,F17:F19)  =SUM 2  (F10:F13,F17:F19)  4.3 Cell F24: =0.14*(F22-F23)  =0.14* 2  (F22-F23)  Open the CHART worksheet 4.4 Cell D27 1  =COUNTBLANK(B7:D24)  4.5 Cell E7: =IF(SUM(B7:D7)>=800,"Excellent"," ")  =IF(SUM(B7:D7)   >=800,  3  "Excellent"," "  4.6 Chart type 1  Change to Clustered Column chart  4.7 Chart Title 1  “Sales per Person Responsible” added to chart 4.8 Y-axis 1  Minimum value is 50  4.9 Gridlines 1  Only minor horizontal gridlines are displayed  4.10 Order 1  Values are shown in reverse order  4.11 Texture Fill 1  Longest bar is filled with any textured fill  [15] QUESTION 5 File: q5Stock No. Criteria Max  Mark Open the table Incredible 5.1 CurrentValue field is formatted as follows: 5.1.1  Data Type: Currency  1 5.1.2  Field Properties Format: Currency (South 1 African rand)  5.1.3  Field Properties Decimal Places: 2  1 5.1.4  Description: “Current value of apparatus”  1 5.2 New record added:  Record added  2  Data correct  ### Page 8 Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2013) 5.3 New field added:  New Field Name: Cellphone   Below: PersonResponsible field  5  Data Type: Text   Field size: 10   Input Mask: 0000000000  5.4 Sorting  Table sorted according to the PersonResponsible 2 field   Sorted in descending order  5.5 Gridlines 1  Only vertical gridlines show  5.6 Primary Key 1  SerialNumber field set as Primary Key  5.7 Default Value 1  WorkingOrder field - Default Value: Yes 5.8 Validation Rule for DatePurchased field: >=#2005/01/01#  >=   #2005/01/01#  3  Correct Validation Text added: “Cannot be purchased before 1 January 2005”  5.9 Room field 1  Set as a required field: Yes  Open the TextBooks table 5.10 Table imported  Table imported from the q5Table spreadsheet  3  New table called: TextBooks   Row 1 of worksheet: used as Field Names  Open the Printers query 5.11 Query created  Query based on the Incredible table  7  Query saved as Printers   Only the following fields show: SerialNumber, Model and DeviceType   Fields show in the correct order as above   Query sorted according to the Room field   Criteria for the DeviceType field is: "Printer"   Criteria for the Model field is: *HP*  ### Page 9 Downloaded from hlayiso.com (NOVEMBER 2013) COMPUTER APPLICATIONS TECHNOLOGY P1 9 Open the Stock form 5.12 Form created 6  Form created and saved as Stock   Using all the fields from the Incredible table   Layout: Justified   Form Header: Label changed to “All Stock”   Details section: Background colour green   Form Footer: Date inserted as a function  Open the Items report 5.13 Items Report is edited 5.13.1 Report Header  Font colour of the heading: Red  2  Alignment of heading: centred in report  5.13.2 Logo (“Image”) inserted  Inserted in Report Header  2  Image used is Group.jpg  5.13.3 Grouping and Sorting in the report  Grouped by DeviceType  2  Sorted by Model [42] QUESTION 6 File: q6Digital No. Criteria Max.  Mark Open the file q6Digital Markers Note: There may be multiple solutions to the instructions – test all solutions and allocate marks if results are correct. 6.1 Title 1 Use of Internet  6.2 Horizontal Red Line:
 correct position  3  colour   line  6.3 Heading Style 1:

Introduction

 h1 large style  2  alignment is centre  ### Page 10 Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2013) 6.4 Heading Style 2 – 6

Why Now

Why use the Internet

2  h2 or smaller style – open and closing tag   heading style size added to both headings  6.5 Background colour:  body colour changed: bgcolor  2  to: =“yellow”  6.6 Text formatting: E-Learning OR … 1  correct opening and closing tag in correct position  6.7 Text formatting: virtual classroom  correct opening and closing tag and in correct 1 position  6.8 Paragraphs:

By using the Internet … learners such as:

1  correct opening and closing tag and in correct position  6.9 Numbered list
  1. Email questions and queries
  2. Could create a virtual classroom
3  ordered list opening and closing tag in correct position   items listed with opening and closing tags   two items listed individually  6.10 Image inserted:
 Image inserted  3  Correct image at bottom of page  image centred horizontally  6.11 Closing tag 1   [20] QUESTION 7 File: q7Answers No. Criteria Max.  Mark Open the file q7Answers 7.1 360  1 7.2 3093  1 7.3 q7Answers file save in pdf format in the EXAM DATA folder 1 [3] TOTAL: 180 ## Related documents - [CATN-P1- MEMO AFR GR11 NOV2013](https://www.hlayiso.com/library/catn-p1-memo-afr-gr11-nov2013/82da6368-3080-4a31-921c-4077df90a469) — Computer Applications Technology · Memo · 2013 · Afr - [CATN-P1- QP ENG GR11 N0V2013](https://www.hlayiso.com/library/catn-p1-qp-eng-gr11-n0v2013/95a7894a-c793-4fdc-8e1a-3cd18906b348) — Computer Applications Technology · QP · 2013 · Eng - [CATN-P1- QP AFR GR11 NOV2013](https://www.hlayiso.com/library/catn-p1-qp-afr-gr11-nov2013/9d98430b-275d-48dd-a2ee-c30c99b71994) — Computer Applications Technology · QP · 2013 · Afr - [CAT P2 MEMO (Eng)](https://www.hlayiso.com/library/cat-p2-memo-eng/74ef0d36-6cbc-41b7-8355-be1ae197f1f0) — Computer Applications Technology · Memo · 2013 · Eng - [CAT P2 MEMO (AFR)](https://www.hlayiso.com/library/cat-p2-memo-afr/213e211f-75ab-465c-bd4e-f4bd9fc994a4) — Computer Applications Technology · Memo · 2013 · Afr - [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.