Skip to content

Computer Applications Technology Grade 12 P1 2017 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 1220179 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2017 (English), 9 pages. Read online or download the free PDF.

Free to read online, no sign-up needed

Answer online

Loading document…

Loading document…

Questions in this paper

Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2017 COMPUTER APPLICATIONS TECHNOLOGY P1 MEMORANDUM NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 Q7 MARKS: 180 36 14 52 42 20 10 06 This memorandum consists of 9 pages.
Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2017) QUESTION 1 File Name: 1_Turtle Facts No Criteria Max  Mark 1.1  Left and bottom margins set to 1.5 cm. 1 1.2 1.2.1  Heading “Save The Sea Turtles” added in the title 1 control on the cover page.  1.2.2  AutoShape filled with the image 1_Save The Turtle  Height and width set to exactly 8 cm.  3 1.3  Condensed spacing applied to the heading “BASIC FACTS ABOUT SEA TURTLES”.  2  Spacing is 1.5 pt.  1.4  Drop Cap effect applied to the highlighted letter “S” dropped over 4 lines.  2  Distance from the text is 0.5 cm. 1.5 Style  Yellow font colour applied to the existing style “Sub Turtle”.  2  The rest of the text with the existing style is updated automatically.  1.6 Columns  Highlighted paragraphs placed in 2 columns with a line in between.  3  Column spacing is set to 1.5 cm.   Applied column break after the first paragraph so that the other three paragraphs are moved to the second column 1.7  Glow effect applied to the text box.  1 1.8  Existing footnote changed to an endnote.  2  Endnote symbol changed to ‘*’ symbol.  1.9  Cell spacing of the table changed to 0.5 cm  Count 3  (Above)  function used (Answer 7 – no marks if the answer is just typed) 1.10  Multilevel bullets applied to the list under the heading Glossary (not just as a bullet).   Bullet 1.jpg used as first level.  `3  And Bullet 2.jpg as second level respectively.  1.11 Bibliography  Month edited and changed to August.  2  Comment inserted that reads Save Sea Turtles.  NB: check if it is updated in the bibliography as well. 1.12 Page orientation 1 Orientation of only the last 2 pages changed to landscape. 1.13 Table and Image caption  Outer table border changed to dashed line.  Thickness is 4½ pt. 3  Caption inserted to the correct image and it reads “Green Sea Turtle”. Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2017) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.14  Inserted section break for the last 2 pages.   Page numbering applied in any format in the page header. 3  Numbering starts from 1 onwards.  1.15  Hyperlink added to the word TOP OF THE DOCUMENT.  Linked created to the top of the document.  2 1.16  Watermark inserted only on the cover page (any correct method can be awarded marks).  2  Watermark reads Billion Baby Turtles.  Total for QUESTION 1 [36] QUESTION 2 File Name: 2_Observation Form No Criteria Max  Mark 2.1  Paragraph shading added to the heading "Sea Turtle Observation Form”.  2  Any shade of green colour.  2.2 Text form field for the heading “How many turtles…” formatted: 2  To accommodate 2 characters,  with no decimals places displayed.  2.3  “Select One Below” option added to the existing list.  2  That appears as the first option in the list.  2.4  Date field changed to d MMMM yyyy format. 1 2.5  Image cropped to resemble as follows:  1 2.6  Help text added to the cell number field.  Text “Please Enter only 10 Digits” entered correctly.  2 2.7  14 cm right aligned tab applied  With solid leader tabs 2 NB: reduce 1 mark if not done for all the three headings. 2.8  Screentip for the email address  2  To read as “Help Us To Save SEA Turtles”  Total for QUESTION 2 [14] QUESTION 3 File Name: 3_Turtle Campaign No Criteria Max  Mark Info worksheet 3.1 Cell H1: 1  Date in cell H1 changed to dd mmm YY format.  3.2  Cells A1:G2 merged and centred.  1 Copyright reserved Please turn over
Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2017) 3.3 Cell A3:O3 :  Thick cell borders applied.  2  Left and right borders of the cells changed.  3.4 Row 3 freezed 1 3.5 Cell A4: =CONCATENATE(B4,LEN(E4),"#code") OR =B4&LEN(E4)& "#code") 5  CONCATENATE function OR & sign  B4   LEN  (E4)   “#code”  3.6 Cell H4: =ROUNDUP(($H$1-G4)/365.25,0)  ROUNDUP function   Use of correct cells H1 and G4  Minus sign (-) used correctly 6  Divided by 365.25 (or 365)   Absolute cell reference used   Formatted to zero decimal places (Note to marker: Accept any other suitable method.) 3.7 Cell N20: =(I20)*$I$2+(J20)*$J$2+(K20)*$K$2+(L20)*$L$2+(M20) *$M$2 OR =I20*$I$2+J20*$J$2+K20*$K$2+L20*$L$2+M20*$M$2  Values from I20:M20 correctly multiplied with values in 3 I2:M2   + sign used correctly between the cells  Absolute cell reference used  (Answer: R200) 3.8 Conditional formatting: 3  Values between 200 and 250 shaded  2 colour shading applied 3.9 Cell O4: =IF(($P$1-N4)<=0,"Adoption Cert",IF(($P$1-N4)>100, "Participation Cert","-"))  IF function   Condition ($P$1-N4)<=0 and value  6  Condition ($P$1-N4)>100 and value   Value if all conditions are false   Absolute cell reference used   Correct use of open and closing brackets  Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2017) COMPUTER APPLICATIONS TECHNOLOGY P1 5 3.10 Cell E51: =SUMIF(E4:E49,E5,N4:N49) OR =SUMIF(E4:E49, “Platinum”,N4:N49)  SUMIF function  4  Range E4:E49   Criteria Platinum or any cell number that contains the value Platinum   Sum range N4:N49  (Answer: R1 640) 3.11 Cell E52: =COUNTIF(F4:F49,F6) OR =COUNTIF(F4:F49, “SEE Turtles”)  COUNTIF function  3  Range F4:F49   Criteria SEE Turtles or any cell number that contains the value SEE Turtles  (Answer: 8) 3.12 Cell E53: =AVERAGEIF(D4:D49,D33,C4:C49) OR =AVERAGEIF(D4:D49, “F”,C4:C49)  AVERAGEIF function  4  Range D4:D49   Criteria F or any cell number that contains the value F   Average range N4:N49  (Answer: 17.3) 3.13 Cell E54: =COUNTBLANK(J4:J49)+COUNTBLANK(L4:L49)  COUNTBLANK function  3  Range J4:J49 and L4:L49  + sign used correctly (Accept any correct method – answer is 44) Spotted worksheet 3.14 Cell B2: =VLOOKUP(A2,LOOKUP!$A$1:$B$95,2,FALSE) OR =VLOOKUP(A2,LOOKUP!$A:$B,2,FALSE)  LOOKUP value: A2 5  Table array: LOOKUP!$A$1:$B$95  Absolute cell reference used  Column index number: 2  Range_Lookup: FALSE Copyright reserved Please turn over
Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2017) Graph worksheet 3.15 Graph  Data set for the year 2014 included in the graph.   Series overlapping is set at -50ͦ. 5  X axis name moved to the correct position.   Data labels displayed on top of each bar.   Minimum value for y axis set to 5.  Total for QUESTION 3 [52] QUESTION 4 File Name: 4_Turtle Classification No Criteria Max  Mark Table: Patient Details 4.1.1  Row height changed to standard height of 14.25.  1 4.1.2  Gridlines are changed to red colour.  1 4.1.3  The list Threatened moved  2  To the third position in the list.  4.1.4  Data type for the diet field changed to MEMO/Long Text 1 data type. 4.1.5 Scientific Name field:  Made as the required field  2  > symbol added in the format property field  4.1.6 Input mask for Turtle Id field: L00\*9a  L  00 5  *  9  a Turtle Images table and the frm4_2 form 4.2.1  Inserted the image Green sea turtle.jpg in the Turtle Images table. 2  Displays in the form frm4_2 correctly. 4.2.2  Turtle images table exported to the exam folder.   Name of the file changed to Export4_2.  2 Query: qry4_3 4.3  Criteria Total Species field:< 400  4 OR <=399  Criteria Diet field: Like "*jelly*" And Like "*crabs*" (Answer: 3 records) Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2017) COMPUTER APPLICATIONS TECHNOLOGY P1 7 Query: qry4_4 4.4  Criteria Turtle Name field: Between "G*" And "P*"  Between And function used 7  G* and P*   Sorted in the ascending order of Turtle Name field  Criteria Weight in Pounds: Round ([weight(in kg)]/2.2046,1) (Answer: 9 records) Form: frm4_5 4.5  Border width of the image changed to 4pt.   Shadow effect applied to the image.  Command button inserted in the form footer to exit the form. 6  Dividing lines are not visible.   Default form view changed to continuous. Report: rpt4_6 4.6 Report rpt4_6 created based on Classification Table  Turtle Name, Tag ID, Colour, Weight (in kg) & Listed As are the only fields displayed.  Report grouped based on Weight (in kg) field.   Grouping intervals set to 50s.  Page numbering changed as shown below so that it will not be displayed in the first page of the report.  9  =Count (IIf ([listed as]="critically endangered",0))  Proper label given for the calculation. Total for QUESTION 4 [42] Copyright reserved Please turn over
Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2017) QUESTION 5 File Name: 5_Save Us  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 <title> Save Sea Turtles </title> 2  ‘Save Sea Turtle' appears   In the browser tab  5.2 Horizontal Line Size <hr size="3" color="black"/> 1  Size changed to 6 that comes within the heading.  5.3 Image Tag <img src="Baby Turtle.jpg" width="100%" height="45%" alt="Baby Turtle">  Image tag added correctly  5  Image source is Baby Turtle.jpg  Width is 100%  Height is 45%  Alternate text is Baby Turtle 5.4 Bold formatting <b>Seven</b> 1  Seven made Bold  5.5 Unordered List Type <ul type="square"> 2  Attribute used is type   Attribute value for type is “square”  5.6 Table Heading <tr> <th colspan="2"> <h1>Most Endangered Sea Turtles In The World</h1> </th> 3 </tr>  <tr> </tr> new row added   <th> </th> tag added between the <h1> </h1> tag  Colspan=”2” added as an attribute to the <th> tag 5.7 Table Row color and font color: <tr bgcolor="green"> <th><font color="white">Turtle Name</font></th> <th><font color="white">Scientific Name</font></th> 2 </tr>  bgcolor attribute added after the <tr> tag to green  <font> </font> added for both the headings with white colour attribute.  5.8 Caption tag <centered><caption>Table 1:List Of Endangered Turtle Species</caption></centered> 3  Caption tags used correctly  Aligned to the bottom of the table  Text inserted correctly and centred Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2017) COMPUTER APPLICATIONS TECHNOLOGY P1 9 5.9 Link <a href="http://www.SEETURTLES.org" target="_blank">SEETurtles.org</a> 1  The hyperlink tag corrected to add the attribute href before the website link.  Total for QUESTION 5 [20] QUESTION 6 File Name: 6_Spotted By & Scientific Info No Criteria Max  Mark 6.1 Spotted By & Scientific Info worksheet 1  Worksheets 2 and 3 hidden  6.2 Find and Replace  Find and replace option used or any appropriate method  2  turtle changed to TURTLE in uppercase  (NB: -1 if not done fully) 6.3 Unique name  used conditional formatting to find the unique values in 2 the column  Name of the person is Taylor 6.4 Sorting  Sorted first based on the Scientific name field in the descending order  3  Then in the ascending order of Spotted By field  Name of the turtle is Black Marsh Turtle  6.5 Password  Cells A1:D1 protected 2  With password 2017 (NB: award zero marks if the whole worksheet is protected) Total for QUESTION 6 [10] QUESTION 7 File Name: 7_Winners List 7_Certificate 7_Certificate (Word processing document) No Criteria Max  Mark 7.1 Mail Merge:  Winners worksheet in 7_Winners List spreadsheet used as the data source.   Placeholders linked with appropriate fields.   In correct position  Edited the recipient list to include all the Platinum 6 Members and who achieved an adoption certificate.   Saved the merged letter as 7_CertificateMerged in the exam folder (4 letters expected) Total for QUESTION 7 [6] TOTAL: 180 Copyright reserved Please turn over

Study this subject

More from Grade 12 Computer Applications Technology

View all