Computer Applications Technology Grade 11 P1 2013 Memo (Eng)

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.

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 

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]

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]

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)

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]

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 

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* 

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 <head> 1 <title>Use of Internet</title>  </head> 6.2 Horizontal Red Line: <hr color="red"/>  correct position  3  colour   line  6.3 Heading Style 1: <h1 align="center">Introduction</h1>  h1 large style  2  alignment is centre 

Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (NOVEMBER 2013) 6.4 Heading Style 2 – 6 <h2>Why Now</h2> <h2>Why use the Internet</h2> 2  h2 or smaller style – open and closing tag   heading style size added to both headings  6.5 Background colour: <body bgcolor="yellow">  body colour changed: bgcolor  2  to: =“yellow”  6.6 Text formatting: <b>E-Learning</b> OR <strong> … </strong> 1  correct opening and closing tag in correct position  6.7 Text formatting: <i>virtual classroom</i>  correct opening and closing tag and in correct 1 position  6.8 Paragraphs: <p>By using the Internet … learners such as:</p> 1  correct opening and closing tag and in correct position  6.9 Numbered list <ol> <li>Email questions and queries</li> <li>Could create a <i>virtual classroom</i></li> </ol> 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: <center><img src="q6Computer.png"/></center>  Image inserted  3  Correct image at bottom of page  image centred horizontally  6.11 Closing tag 1  </html> [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