Skip to content

Computer Applications Technology Grade 12 P1 2014 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 1220149 pages

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

Free to read online, no sign-up needed

Answer online

Loading document…

Loading document…

Eastern Cape Mock Exam 2014

Questions in this paper

Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2014 COMPUTER APPLICATIONS TECHNOLOGY P1 MEMORANDUM NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 Q7 MARKS: 180 34 15 27 24 40 20 20 This memorandum consists of 9 pages.
Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2014) QUESTION 1 File: Q1_ID No. Criteria Max.  Mark Open the file Q1_ID 1.1 Heading Identity Document formatted to Bold  and Dark 2 blue text colour  1.2 Picture inserted and formatted as follows:  Picture labelled smart id used   Picture centre aligned  and text wrapped  5  3pt  border added  1.3 Subheadings  on page 1 and 2 formatted to style 2 Heading 1  1.4 New style created and formatted as follows:  New style Register elections created  Style based on Heading 2   Comic Sans size 16 used   Blue paragraph border   With pink background  6  New style set to change automatically  1.5 Table of Contents created and modified as follows:  Formatted text with Modified Heading 1 style   Page numbers not shown  6  Hyperlinks is shown instead   Only one level shown   Modern style used  1.6 Footer added  “Quote by Mandela” added  4 Automatic page numbering added  Not on cover page  1.7  Cover page added, any style  2  Main heading of the document  1.8 Paragraph spacing for the entire document changed to 12pt 2 after each paragraph  1.9 “Copy” watermark inserted  2 Horizontally displayed  1.10 Word “identity”  replaced with word “ID” in all occurrences  Appear in red font  (13 replacements) 3 [34]
Downloaded from hlayiso.com (SEPTEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 3 QUESTION 2 File: Q2_Brochure No. Criteria Max.  Mark Open the file Q2_Brochure 2.1 Margins changed to narrow  1 2.2 Document formatted as follows:  Orientation Landscape   Column break inserted as indicated on Annexure  4  Insert columns with a line between   Column width 8.22 cm and spacing 1.25 cm 2.3  6pt   Art border inserted  3  whole page 2.4 Electronic form in the 3rd column formatted as follows:  Table inserted   13 columns and 1 row to 0.4 cm   Text form field added to “Municipality”   Drop down list added to Province  6  Edit list to “Western Province”, “Eastern Province”, “Gauteng”, “Kwazulu-Natal” and “Northern Cape”   Check box added to the sentence “You are eligible …”  2.5 Pictures are grouped as one object 1 [15]
Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2014) QUESTION 3 File: Q3_Budget No. Criteria Max.  Mark Open the Wards_2014 worksheet. 3.1 Width of all cells have been adjusted  1 3.2 Red Colour of sheet Wards_2014 changed to Blue  1 3.3 Hyperlink of thumb.jpg image inserted in cell A1 2 3.4 Cell K2 =(F2-K1)*24-3  Formula: =(F2-K1) *24  3  - 3 hours for lunch breaks  3.5 Cell K22 =SUM(K2:K20)*45.25  =SUM(K2:K20)  2  Correct value used: 45.25  3.6 Cell C2 =LOWER(CONCATENATE(LEFT(A2,2),"*",RIGHT(B2,3)))  Function: =LOWER  (CONCATENATE)  5  "*"  LEFT(A2,2)   RIGHT(B2,3)  3.7 Cell H2 =D2*G2  1 3.8 Cell J2 =H2-I2  2 Auto fill down to Cell J22  3.9 Cell D25 =COUNTA(A2:A20)  Function = COUNTA  2  Range (A2:A20)  3.10 Conditional formatting to Range I2:I20 2  Red font   Underlined (yellow) 3.11 Cell D26 =RANDBETWEEN(10,20)  Function: =RANDBETWEEN  2  (10,20)  3.12 Cell H27 =IF(D2<=69,G2*8%,G2*12%) 3 3.13 SA Currency added to Column G, H and I 1 [27]
Downloaded from hlayiso.com (SEPTEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 4 File: Q4Ward_Reps No. Criteria Max.  Mark Open the Ward_Reps worksheet. 4.1 Displayed cellphone number correctly in Range D3:D28  Format Cells to Custom and   Insert 0##########   Or set as Text 2 4.2 Cell F3 = E3*$L$2 (Correct cells used) Multiplication used  3 Absolute Reference used in $L$2 only  4.3 Cell E33 = SUMIF(A3:A28,"Ward Fynbos",E3:E28)  Function: SUMIF   Range: A3:A28  4  Ward Fynbos Ward: "Ward Fynbos"   Range: E3:E28  4.4 Cell C35 =COUNTIF(C3:C28,"F")  Function: COUNTIF  2  Criteria: F  4.5 Cell D36 =COUNTBLANK(D3:D28)  Function: COUNTBLANK  2  RANGE: D3:D28  4.6 Cell J12: =VLOOKUP(B12,V_Lookup!A2:B27,2,FALSE)  Function: VLOOKUP   lookup_Value: B2  5  table_array: V_Lookup!A2:B27   index_num: 2   range_lookup: FALSE  4.7 Create 3D Pie Chart:  3D-Pie chart created   Data labels display as percentage   Chart Title – Youth-2014  6  Chart Title – bold italic   Chart Title – Strike through effect added   Chart Title – Yellow solid fill  [24]
Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2014) QUESTION 5 File: Q5_Reps Info No. Criteria Max.  Mark Open the Ward_Reps table. 5.1 Contact No field formatted as follows  Data type: Text  3  Input Mask: "0"000000000  5.2 New field added:  Above Ward Representative  2  New Field name Title  5.3  Drop down list added   Row source type: Value List  3  Row source: “Mr”, “Mrs”, “Prof”  5.4 Table sorted in ascending order of Ward Representative 1 field  5.5 Computers field renamed to Computer Skills  2 NB: Caption used instead of rename function  5.6 Format Ward field to Capital Letters 1  Format: >  5.7 Validation rule and Text added to Gender field  Gender field formatted   Validation Rule: “F” or “M”   Any validation text acceptable  3 5.8 Primary Key set on Ward ID field  1 5.9 T-Shirt costs field moved to after T-Size field  1 Open the Ward_Reps query. 5.10 Query modified as follows: (3 records displayed)  Gender: M   Computers: Advanced   Medical Aid: Yes  3
Downloaded from hlayiso.com (SEPTEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 7 5.11 Query created based on Accommodation table  Query name: Voters Accom  3  Show all database fields   Contact number field hidden  5.12 Calculated field added:  Field Name: Deposit   Calculate 25% of the   Rate field   Display as Rand  4 Open the form MyVote 5.13 Logo inserted: 5.13.1 Insert SA Flag logo in the header top right  1 5.13.2 Image resized to 4 cm  x 4 cm  1 5.13.3 Background colour of all form fields to yellow  1 5.14 T-Shield Size field converted to combo box  Change to Combo Box   Data Row Source Type changed format to 4 Value List   Edit List to “S” “M” “L” “XL” “XXL”  Open the Report Total Costs 5.15 Report modified as follows:  Changed page orientation to Landscape   Today’s date displayed on the page footer  6  Report grouped according to the T-Shirt size   Sorted by Ward Representative of field   Calculate the Total T-Shirt cost per group  [40]
Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2014) QUESTION 6 File: Q6Webdesign No. Criteria Max.  Mark Use the application program Notepad 6.1 The title of the web page is “Election Help”. 1 6.2 Heading “IEC” should be centre align horizontally  1 6.3 Insert the image called IEC.jpg   above the IEC Heading  3  Right align  6.4 Format the paragraph heading “when can I register::  font face: comic sans 3  size: 6   colour: green 6.5 “You must be” to an upper case alphabetical list.  A. be a South African citizen 2 B. be at least 16-years-old C. and have a green, bar-coded ID book 6.6 Insert a hyperlink to the isiXhosa.pdf  and “Important”  4 6.7 Format the table (position)  a caption “ACCOMMODATION” should display   table headers should be bold  6  table data should be entered correctly  [20]
Downloaded from hlayiso.com (SEPTEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 9 QUESTION 7 File: Q7_Intergration No. Criteria Max.  Mark Open the file Q7_Intergration 7.1 7.1.1  numbering x of y on the right hand side of the footer  2  start on the 2nd page.  7.1.2  Date added correctly  and must update 2 automatically  7.2 7.2.1  Correct data exported   Export Totals to Rich text  3  Renamed to Q7_export  7.2.2  Import Register spreadsheet to new table.   Rename table Import  4  Save correctly  7.3 7.3.1  Merge fields Name  and Surname  added 2 7.3.2  Letters sorted in ascending order by name.  1 7.3.3  Mail merge completed  2 7.4 7.4.1  Track changes accepted  1 7.4.2  Track changes turned off  1 7.4.3  Income renamed to Egos_Income  1 7.4.4  Comment in CELL C4 deleted. (Egos_Income sheet)  1 [20] TOTAL: 180

Study this subject

More from Grade 12 Computer Applications Technology

View all