Computer Applications Technology Grade 11 P1 2016 Memo (Eng)

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.

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

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

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

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

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

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

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

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 <title>Unlimited Fun@uShaka </title> 2  'Unlimited Fun@uShaka' appears   In the browser tab  5.2 <body bgcolor="yellow">  Background colour changed to yellow  1 5.3 Font tag <font face="century gothic"> </font> 2  font face is century gothic   and tag closed correctly  5.4 Heading style: <h1>Unlimited Fun for EVERYONE!</h1> 1 Closing tag for <h1> tag corrected.  5.5 Horizontal line size and colour <hr color="red" size=4 />  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 <ol type="A"> 2  Type   Listed as A, B, C etc.  5.7 Image <img src="5_Fun Unlimited.jpg" height="50%" width="25%" align=right alt="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: <i>call 031 328 8000</i> 1  Text is displayed in italics  5.9 Link <a href="www.ushakamarineworld.co.za"> www.ushakamarineworld.co.za </a> 2  Link moves to 'www.ushakamarineworld.co.za'   Link works correctly  Total for QUESTION 5: [20] Copyright reserved Please turn over

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