# Computer Applications Technology Grade 11 P1 2012 Memo (Eng) > Grade 11 Computer Applications Technology Paper 1 memorandum from the Eastern Cape November 2012 (English), 9 pages. Read online or download the free PDF. - Page: https://www.hlayiso.com/library/cat-p1-memo-eng-nov-2012/3a2a1189-2cd3-4689-8855-50eec1344f3d - Updated: 2026-09-27 - Subject: Computer Applications Technology - Grade: Grade 11 - Document type: Memorandum - Year: 2012 - Exam period: Eastern Cape November - Paper: 1 - Curriculum: CAPS - Pages: 9 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 2012 Memo (Eng)](https://www.hlayiso.com/library/cat-p1-memo-eng-nov-2012/3a2a1189-2cd3-4689-8855-50eec1344f3d) ## About this document Computer Applications Technology · Grade 11 · Eastern Cape November · 2012. Memorandum, 9 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 Province of the EASTERN CAPE EDUCATION NATIONAL SENIOR CERTIFICATE GRADE 11 NOVEMBER 2012 COMPUTER APPLICATIONS TECHNOLOGY P1 MEMORANDUM NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 Q7 MARKS: 200 18 25 31 38 32 31 25 This memorandum consists of 9 pages. ### Page 2 Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2012) QUESTION 1 Folder: q1DATA File: q1AnswerSheet No. Criteria Max.  Mark Open the q1DATA folder 1.1  The Subjects Code folder is moved to appear as a 1 subfolder of Census 2012 folder 1.2  A subfolder Students is created in the Purpose folder 1 1.3  The image file Netball in the subfolder Netball (that appears 1 in the Sports folder) has been deleted 1.4  The presentation file called Census Presentation is 1 compressed and appears in the q1DATA folder 1.5  The learner’s name appears as Author for the file Rules 1 1.6  A password has been added to the file Presentation 2  The file cannot be opened without the password 22x 1.7  The file imageCAY is copied to Background folder 1 1.8  A Shortcut to the Access file is created and 2  appears in the Transport folder 1.9  A Rich Text File has been created  and it 2  is saved as School.rtf in the q1DATA folder 1.10  The folder Transport is renamed to Mode of Transport 1 Open the q1AnswerSheet file 1.11 1.11.1  Words: 288 1 1.11.2  Files sorted by Name in descending order 4  Only the Date Modified and Name fields appear  Date Modified appears before Name  Screen shot pasted in the q1AnswerSheet file [18] ### Page 3 Downloaded from hlayiso.com (NOVEMBER 2011) COMPUTER APPLICATIONS TECHNOLOGY P1 3 QUESTION 2 File: q2CensusAtSchool No. Criteria Max.  Mark Open the file q2CensusAtSchool 2.1  Entire document: Justified 1 2.2 Main heading “CensusAtSchool” formatted as follow: 2  Font size 27 pt  Outline effect applied 2.3  Image Logo Census@school inserted 3  The image appears behind the heading  The image has been changed to washout 2.4  Left and Right margins changed to 3 cm and 2  Top and Bottom margins changed to 2 cm 2.5  Paper size is A4 and 2  Page Orientation is Portrait 2.6 Picture of foot: 3  resized to 60% of original Height and  rotated 90°  rotated left 2.7 First paragraph edited as follows: 4  Indented 2 cm on the left and right hand side  18 pt line spacing  Drop Cap effect added to the letter I  Drop Cap runs over 4 lines 2.8 Paragraph spacing for entire document set as follows: 2  Before: 3 pt  After: 12 pt 2.9  Bullets inserted to the paragraph under the heading 3 “Method”  The bullets are red  Wingdings 231  was used as bullets 2.10  Page break inserted so that “Interpreting questions” 1 appears on a separate page 2.11  Section Breaks inserted 2  Second last page appears in Landscape orientation(Give this mark only if the rest of the document is in Portrait orientation.) [25] ### Page 4 Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2012) QUESTION 3 File: q3Population No. Criteria Max.  Mark Open the file q3Population 3.1  Language English(South Africa) 1 3.2  Spelling errors checked 2  All 3 errors corrected 3.3 Main Heading changed as follows: 5  Border applied to text (placed around the main heading of the document)  The border has a shadow  The border line is 2¼ pt thick  The border is a dotted line  The heading has yellow background shading 3.4  All occurrences of the word “HIV” changed 2  to a green highlight 3.5  Two columns inserted using correct text 4  Column line inserted between the columns  Space between columns 2 cm  Column break inserted so that heading 3 appears on the right 3.6  Cells merged as indicated  Content centred horizontally and vertically in the table  Two rows at the bottom of the table deleted  Correct content sorted in descending order  Borders added as indicated 9  Shading added  Text direction changed  First column is exactly 3 cm  Formula used to calculate the total: =sum(above)  3.7  Date inserted at the end of the of the document 3  Date format: YYYY-MM-DD  Date set to update automatically 3.8  Watermark: Census added 3  Watermark: Font type Arial  Watermark: Font size 38 pt 3.9  Text converted to table (must not include comma)  2  The correct text converted [31] ### Page 5 Downloaded from hlayiso.com (NOVEMBER 2011) COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 4 File: q4Favourite Subjects No. Criteria Max.  Mark Open the file q4Favourite Subjects 4.1  Cells A1:G1 merged 2  Text centred vertically and horizontally 4.2  Font size of the heading in Row 1 is 14 pt 3  Green border in Row 1  Borders above and below the merged cell 4.3 Row 3: 2  Alignment 45°  Headings wrapped 4.4  Row 3: Borders added 1 4.5  Data on the worksheet must be clearly visible 1 4.6  Cell A2: =TODAY() 1 4.7  Delete Sheet 2 1 4.8  Rename Sheet 1 to “Subjects” 2  Tab colour changed to blue 4.9  Page Orientation of Subjects worksheet changed to 1 Landscape 4.10 Cell F4: =B4+D4 3  Correct cells used  Correct calculation  Formula filled down for all the remaining subjects 4.11 Column F: 4  Conditional Formatting used  Condition: Greater than 150  Condition: Less than 100  Format: Red and Green fill used correctly 4.12 Column G: =F4/$I$3 4  Correct cells used  Correct calculation  Absolute cell reference used  Cells formatted to show % 4.13  Row inserted above Row 22  1 ### Page 6 Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2012) 4.14 Sheet 3 3  Correct columns copied and pasted  on Sheet 3 and transposed  only values pasted 4.15 4.15.1 Cell B15: =ROUND(AVERAGE(B4:B12),0) 4  Round function used  Average function used  Correct cell reference  Rounded to correct unit 4.15.2 Cell B16: =MAX(D4:D12) 2  Max function used  Correct cell reference 4.15.3 Cell B18: =LARGE(F4:F12,2) 3  Large function used  Correct cell reference  Correct number (2) indicated [38] ### Page 7 Downloaded from hlayiso.com (NOVEMBER 2011) COMPUTER APPLICATIONS TECHNOLOGY P1 7 QUESTION 5 File: q5Samples No. Criteria Max.  Mark Work in the School worksheet 5.1 5.1.1  Row 1: Height changed to 40 1 5.1.2  WordArt heading “Census At Schools” added to the 3 left hand side of the top row  Font type Arial Narrow  Font size 16 pt 5.2  Cell A4 shaded blue 1 5.3  Picture moved to Cell A3 2  Picture resized so that it is the exact size of the cell 5.4 Column G: =IF(F7 =250,"Large","Small") 3 OR =IF(F7 250, "Small","Large")  IF(F7  >=250,   "Large","Small") 5.5 Cell B17: =COUNTA(A7:A15) 2  =COUNTA  (A7:A15)  5.6 Cell B18: =COUNTBLANK(B7:E15) 2 OR =COUNTIF(B7:E15, “”)  =COUNTBLANK  B7:E15) 5.7 Cell B19: =COUNTIF(G7:G15,"Small") 3  =COUNTIF  (G7:G15,   "Small") 5.8  Correct data sorted 2  in descending order according to Column F 5.9  Column Chart is created 2  Using correct data 5.9.1  Chart Title: “Distribution of School ”  1 5.9.2  The Axis Title for the (Y-axis) is Numbers  2  The Axis Title for the (X-axis) is Provinces 5.9.3  The legend is removed 1 5.9.4  Text on Horizontal axis rotated 90° 1 5.9.5  Data Labels added 3  Data Labels appear in the centre of the Series  Font colour white 5.9.6  Data Series filled with gradient 2  Correct gradient used: “Late Sunset” 5.10 Chart saved in a new worksheet 1 [32] ### Page 8 Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2012) QUESTION 6 File: q6Learners No. Criteria Max  Mark Open the table Subjects 6.1  Firstname field changed to Text 2  Firstname and Surname field sizes changed to 15 and 25 6.2  Record for Peter Marhala in 10E deleted 1 6.3  Field added and placed after the Surname field 4  Field Name: Age  Data Type: Date/Time  Format: Long Date 6.4  Data entered as shown 2  No errors in data 6.5  Table sorted according to the Surname field 2  Sorted in descending order  6.6  Only vertical gridlines show 1 Open the query CAT Learners 6.7  Query saved as CAT Learners 3  Criteria for Subject 6 field: “CAT”  Only fields showing: ID, Firstname, Surname, Class  Open the query Maths 6.8  Criteria for Class field: “12 E” 3  Criteria for Subject 2 field: “Mathematics” (all criteria on same line)  Sorted according to the Surname field Open the form Subjects 6.9  Form created by using all fields 4  Justified layout  Date inserted in the Form Footer  Date inserted as a function: =Date() and in a Text Box Open the report 2012Subjects 6.10 6.10.1  Learner name added to the Report Footer in a 1 Label 6.10.2  Heading in the Report Header reads: “2012 3 Census”  Font colour of the heading is blue  Heading centred in the Header of the Report 6.10.3  Report grouped according to the Class field 1 6.10.4  Function added to the Class Footer 4  =Count  (*) OR ([Surname]) etc.  Label for the function reads: “Number of students” [31] ### Page 9 Downloaded from hlayiso.com (NOVEMBER 2011) COMPUTER APPLICATIONS TECHNOLOGY P1 9 QUESTION 7 File: q7Form No. Criteria Max.  Mark Open the word processing document q7Form 7.1  Section Break removed 1 7.2  The heading “Census Form 2012” is converted to WordArt 6 style 1  Length image used to fill WordArt  WordArt centred at the top of the page  WordArt changed to be exactly 2 cm high by 13 cm wide  Striped Right Arrow shape added  Striped Right Arrow shape behind WordArt and grouped with WordArt 7.3 Tab stops inserted as follows: 2  Centre Tab: 7 cm  Right Tab: 14.5 cm 7.4  Horizontal line inserted (border line used and in correct position) 1 7.5  Symbol (Wingdings 168 )  inserted 3  Next to Boy? and Girl?  Font size 20 pt 7.6  Border around the heading Section B removed 1 7.7  Text moved to the table 2  Correct text moved 7.8  Page colour changed to grey 1 7.9  Table added  Next to the text: What is your date of birth? 4  Columns resized to AutoFit Contents  Text added correctly to table 7.10  Image inserted on the right hand side of Section B  2  Image resized 7.11  Leader tabs added to the appropriate text in the table 2  Leader tabs set to right align [25] TOTAL: 200 ## Related documents - [CAT-P1-ENG-NOV 2012](https://www.hlayiso.com/library/cat-p1-eng-nov-2012/b8c0c5bc-52d3-4656-8ee0-deb34b011929) — Computer Applications Technology · QP · 2012 · Eng - [CATN P2 N12 Memo Afr](https://www.hlayiso.com/library/catn-p2-n12-memo-afr/e12ec202-d8c1-4464-b146-75a83f367aed) — Computer Applications Technology · Memo · 2012 · Afr - [CATN P2 N12 Memo Eng](https://www.hlayiso.com/library/catn-p2-n12-memo-eng/d1206b6c-26db-483a-81d2-9ce3525d325f) — Computer Applications Technology · Memo · 2012 · 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 - [CAT P1 MEMO GR11 NOV 2020 ENG D](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2020-eng-d/d12def4a-982f-4449-b293-32fa4e40a517) — Computer Applications Technology · Memo · 2020 · Eng - [CAT P1 MEMO GR11 NOV 2019 Eng D](https://www.hlayiso.com/library/cat-p1-memo-gr11-nov-2019-eng-d/406f61c6-6558-402a-9648-12d1aff30bda) — Computer Applications Technology · Memo · 2019 · 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.