Computer Applications Technology Grade 11 P1 2012 Memo (Eng)

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.

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]

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]

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]

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

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]

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]

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]

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