Computer Applications Technology Grade 12 P1 2012 Memo

Downloaded from hlayiso.com Province of the EASTERN CAPE EDUCATION NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2012 COMPUTER APPLICATIONS TECHNOLOGY P1 MEMORANDUM/MARKING GUIDELINE MARKS: 200 CANDIDATE MARKS CANDIDATE NAME QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 19 27 21 36 30 45 22 200 CANDIDATE MARK FINAL MARK This memorandum consists of 9 pages.

Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (Memo) (SEPTEMBER 2012) QUESTION 1 Folder: q1Data File: q1Answer Sheet.doc No. Criteria Max.  Mark 1 Open the q1Data folder 1.1 Subfolder called Latest created in the INFO folder 1 1.2 All the Word processing files moved 2 to the ZA Destinations subfolder 1.3 All the GIF files in q1Data folder and subfolders deleted (0 1 if all not deleted) 1.4 Password code added to the spreadheet Stock.xls so that the worksheet Details cannot be edited 3 and only the cells that are shaded yellow are unprotected 1.5 The format of the Destinations file in the ZA Destinations 1 folder is changed to Rich Text 1.6 A shortcut to the ZA Destinations folder 2 appears in the Image folder 1.7 The text file Cities is renamed to SA Cities 1 1.8 The Subject in the properties of Marathon.xls file appears 1 as holiday 1.9 Picture appears on the folder of the Image folder Picture used is Sydney.jpg 2 (to view select the Properties of the folder and click on the custom tab) Open the q1Answer Sheet file 1.10.1 Files sorted in descending order by Name The Date modified and Name fields are the only fields that appear in the screenshot The Date modified field appears before the Name field in 5 the screenshot Extensions of the files are visible Screenshot is pasted in the q1Answer Sheet file [19]

Downloaded from hlayiso.com (SEPTEMBER 2012) COMPUTER APPLICATIONS TECHNOLOGY P1 (Memo) 3 QUESTION 2 File: q2Travel Info.doc No. Criteria Max.  Mark 2 Open the file q2Travel Info.doc 2.1 Top gutter of 1 cm added 2 Page size set to A4 2.2 All paragraphs Justified 1 2.3 Heading: “Contents” typed at top of page 2 font Arial Black 3 font size 14pt 2.4 Heading 1 style applied to “How a Travel Agent Can Help 1 you” 2.5 Automatic Table of contents inserted on page 2 2 Heading 1 & 2 are the only styles used 2.6 Insert a page break or a section break (next page) above 1 the heading “References” 2.7 The paragraph below the heading “A travel agent needs to be ready to:” is formatted as follows: bullets inserted 3 bullet customized to  (Wingdings 39)  bullet appears in a red font colour 2.8 All occurrences of the word “ZA-Travel” formatted: in a blue font colour and 2 in Small Caps (10 replacements) 2.9 Paragraph below the heading “About ZA-Travel” changed into: two columns 3 of 7 cm each with a column line between the columns 2.10 Endnote inserted after the heading: “What ZA-Travel’s clients Say” 3 referenced with the symbol (Wingdings 85)  endnote reads: ”Collected from satisfied clients” 2.11 Orientation of the last page changed to Landscape 1 2.12 Line numbers added to all the lines of the document 3 Continuous line numbering used 2.13 Hyperlink added to the words: “http://www.fasterinfo.com/Travel/Travel_Agents” 2 hyperlink set to the above website address [27]

Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (Memo) (SEPTEMBER 2012) QUESTION 3 Filename: q3Trips No. Criteria Max.  Mark 3 Open the file q3Trips 3.1 Type missing data (0 if any errors) Tab stop position: 9 cm centre aligned 4 Leader 4 line allocated to 9 cm and 16 cm tab Second tab stop 16 cm right aligned 3.2 Lines removed 2 line spacing changed to 1.5 lines 3.3 Format the logo “ZA-TRAVEL” so that the Text Wrapping 1 is changed to In Line with text. 3.4 All the data on the page centred. 1 3.5 Symbol of the telephone moved to the left hand side of the 1 telephone number. 3.6 Format of the heading “Affordable Bus Trip” in Outline 1 Effect. 3.7 “VeriSign” logo inserted at the bottom centre of page 2 Logo changed to Greyscale 3.8 Any green Page Border inserted Border width 6 pt 3 Only on the left and at the bottom of the page 3.9 Paragraph border added 2 above and below the Bus trip information 3.10 Bookmark removed from the word “Bus” 1 3.11 Picture of the light bulb removed from the page 1 3.12 Hyperlink added to the word “Affordable” 2 Linked to the q4Travel.xls document  [21]

Downloaded from hlayiso.com (SEPTEMBER 2012) COMPUTER APPLICATIONS TECHNOLOGY P1 (Memo) 5 QUESTION 4 Filename: q4Travel No. Criteria Max.  Mark 4. Open the spreadsheet q4Travel and work in the Holiday worksheet 4.1 Cell I3: heading Total Cost added 1 4.2 Row 1: cells A1:L1 merged main heading “ZA-Travel” centred horizontally 4 Font type of row 1 - Bradley Hand ITC  Font size 47 pt 4.3 Row 3: Text Alignment of the headings 90º vertically Headings centred horizontally and vertically 5 row height 60 pt text wrapped a blue fill colour added to the heading cells 4.4 All the data is clearly visible.  1 4.5 Column I: =G4*F4 correct cell reference 2 correct calculation 4.6 Cell G2: =ROUND(AVERAGE(G4:G28),0) =ROUND AVERAGE 4 Correct cell reference: G4:G28 Rounded to ,0 decimals and correct use of brackets 4.7 Column K: =J4-TODAY() =J4 (must appear first) and correct calculation: -  3 TODAY() Properties changed so that it appears as a number  4.8 Column L: =I4/$L$2 Correct cell reference Correct calculation 4 Absolute referencing Euro currency with 2 decimal places 4.9 Cell I30: =LARGE(I4:I28,2) =LARGE 3 Cell reference and brackets Second largest indicated ,2 4.10 Cell J4 displayed as a date 1 4.11 Bar Chart created On a new worksheet (not copied to worksheet)  Total Cost in Column I and the Cost per person per day in Column G used Only AfriTour Packages are used. 8 Package name appears next to the vertical axis Chart title reads “ZA-Travel Packages”  Legend indicates Total Cost and Cost per person per day Legend moved to below the chart [36]

Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (Memo) (SEPTEMBER 2012) QUESTION 5 Filename: q5Lookup No. Criteria Max.  Mark 5. Work in the Packages worksheet 5.1 A double line 2 border around the heading “Travel Packages”  5.2 Column I: =L4-K4 Correct cell reference 3 Correct calculation Cell properties changed to NUMBER or GENERAL 5.3 Column O: =IF(D4>=4,"Discount","No Discount") =IF with correct use of brackets D4>=4,  3 "Discount","No Discount" OR =IF(D4<4,"No Discount",”Discount”) 5.4 Column A: =UPPER(RIGHT(C4,3)&LEFT(B4,2)) OR =UPPER(CONCATENATE(RIGHT(C4,3),LEFT(B4,2))) 4 UPPER RIGHT(C4,3)  LEFT(B4,2)  & OR CONCATENATE and correct use of brackets 5.5 Cell E32: =COUNTIF(E4:E28,"BEA Inc") =COUNTIF 3 E4:E28 ,"BEA Inc" and correct use of brackets 5.6 Column H: 3 equal to Fly red font colour border 5.7 Cell N30: =SUMIF(E4:E28,"BEA Inc",N4:N28) =SUMIF E4:E28 4 ,"BEA Inc", and correct use of brackets N4:N28 Work in the New Income worksheet 5.8 Cells B11 to D11: =VLOOKUP(B10,$A$2:$B$4,2,TRUE) =VLOOKUP Lookup_value: “BEA Inc” Table_array: $A$2:$B$4 6 Col_index_num: 2 Range_lookup: TRUE Absolute referencing 5.9 Cells B12 to D12: =B11*B10 Correct cell reference 2 Correct calculation (no mark if function used) [30]

Downloaded from hlayiso.com (SEPTEMBER 2012) COMPUTER APPLICATIONS TECHNOLOGY P1 (Memo) 7 QUESTION 6 Filename: q6Packages No. Criteria Max.  Mark 6. Open the q6Table1 6.1 Code field is defined as primary key 1 6.2 Number of people field: Data type changed to Number 3 Field Size is Double with 0 decimal places 6.3 Confirm field added Data Type set as Yes/No 3 Move the field to below Cost (pps) field 6.4 Lookup Wizard use for the Mode field items appear in the drop down list 3 Correct items added: Fly; Drive; Cruise; Fly-Drive; Fly-Cruise 6.5 Client field sorted 2 in descending order 6.6 Background colour of table red Alternative rows green 3 Only vertical gridlines show 6.7 Client field properties edited: 1 > added to the Format option 6.8 Properties of the Number of people field changed: 1 Default Value changed to 2 6.9 Validation rule with validation text added to the Cost (pps) field. Validation Rule: <=10500 3 Validation Text: May not exceed 10500 6.10 Field properties of the Company field changed to required 1 Open Query1 6.11 Query created using q6Table1 Criteria Cost (pps) field: ,<=4000 Criteria Destination field: "Kruger Park" Or "Victoria Falls" 5 Show only the Company, Package Name, Mode, Duration and Cost (pps) fields Query sorted by the Duration field Open Query2 6.12 Query created showing all the fields Add a calculated field: FinalCost:[Cost (pps)]*[Number of people] Field name 5 Correct fields and use of brackets Correct operator used Field displayed in South African Currency

Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (Memo) (SEPTEMBER 2012) Open q6frmClients 6.13 Form created based on the q6Table1 2 Use the COLUMNAR layout 6.13.1 Name and surname added to the header of the form in a label Date added as a function to the footer of the form =Date() Date formatted so that it appears as a short date format Background colour of the label of the Code field 6 changed Combo Box (linked to the table) inserted for the Destination field Correct list added: Victoria Falls, Cape Town, Kruger Park, Europe, Knysna, Asia, Mozambique, Buenos Aires and Egypt Open q6Package 6.14 Records grouped according to Destination Records sorted in ascending order according to the Duration Picture Logo inserted in the Report Header Suitable formula in Group Header or Footer:=Count(*) 6 Suitable label for formula e.g. Total number Conditional formatting used to change the font colour of amounts in the Cost (pps) field to red, for the packages that cost more than R5 000 (pps)  [45]

Downloaded from hlayiso.com (SEPTEMBER 2012) COMPUTER APPLICATIONS TECHNOLOGY P1 (Memo) 9 QUESTION 7 Filenames: q7Specials; q7Letter; q7Addresses; q7Merge and Sydney No. Criteria Max.  Mark Open q7Letter 7.1 Heading converted to Arch Up (curve) WordArt The font type is Tempus Sans ITC The font is Bold The font size is 48 pt 7 The image Sydney.jpg is inserted below the WordArt and is resized to 2 cm by 2 cm The image and the WordArt is grouped The grouped image is moved to the top centre of the page 7.2 The date is inserted as a field 2 Date updates automatically 7.3 The table that is shaded in blue has been converted to text 1 and the comma is used as separator 7.4 The table that is shaded in red has been deleted from the 1 letter 7.5 Reply slip at the bottom of the letter edited as follow: Properties of the Text Form Field next to Name - Text format is Uppercase  3 and the Maximum length is 30  Properties of the Check Box Form Field next to Other - default value is Checked.  7.6 Worksheet from the q7Specials file inserted 2 Linked to the spreadsheet.  7.7 A custom watermark reading ”NEW WEBSITE” is inserted 1 7.8 7.8.1 Table called Addresses in the q7Addresses.mdb 1 Database is used as data source 7.8.2 Sections between << >> have been replaced with the 1 relevant merge fields 7.8.3 The letters is sorted according to Last Name  2 In descending order 7.8.4 Final merged letters saved as q7Merge.doc in the 1 2012 EXAM DATA folder.  [22] TOTAL: 200