Skip to content

Computer Applications Technology Grade 12 P1 2015 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 12201511 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2015 (English), 11 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 2015 COMPUTER APPLICATIONS TECHNOLOGY P1 MEMORANDUM NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 Q7 MARKS: 180 35 15 42 8 40 22 18 This memorandum consists of 11 pages.
Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2015) QUESTION 1 File: Q1Newsletter_Nuusbrief No. Criteria Max.  Mark 1.1 Margins 1 Top-and bottom margins 1.5cm 1.2 1.2.1 Font Formatting: Heading ‘The cost saving” formatted to: 2  Garamond font  12pt. 1.2.2 Line Spacing  Line spacing set to Exactly 2  14pt 1.2.3 Bulleted list  Text under heading ‘Resource Library’ is a bulleted list 2  Bullets are customised with the image tablet vs textbooks 1.3 Find and Replace  2 occurrences of ‘TRAIN YOUR BRAIN’ with ‘TYB’ 2  Displayed in bright green font (Note to marker: Total occurrences of TYB is 2) 1.4 Columns  Correct text selected  In three columns 4  Line appears  Text in columns fully justified 1.5 1.5.1 Styles  New style called Lets go digital createdbased on heading style 1 4  Surrounded by a shadow border  Paragraph spacing after 2.5 pt 1.5.2  Lets go digital style applied to headings highlighted 1 in red: ‘How it all works’ Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.6 Table of Contents  Page break inserted  Heading Table of Contents displayed  Format change to Distinctive  Contents display with tab leaders  TOC levels changed to displayed the correct order (According to the screen shot below) 5 1.7 Watermark  Picture watermark applied (correct image 1Chart used) 2  Scale set to 150% 1.8 Page numbering  Odd and Even page numbering  In the footer/header of the document 5  Odd left and Even right aligned  Start from number 10 (using ms word function) 1.9 Date 31 March 2001 Two hard spaces inserted (one mark for each) 2 31°March°2001 1.10 Character spacing  Character spacing expanded to 3 pt 3  Text appears in upper case (capital letters)  Is right-aligned Total for QUESTION 1: [35] Copyright reserved Please turn over
Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2015) QUESTION 2 File: Q2SubjectChoice_Vakkeuse No. Criteria Max.  Mark 2.1 Hyperlink 1  Removed 2.2 Symbol inserted Windows symbol  correctly inserted between ‘Subject 1 Choices” and ‘Vakkeuse’  2.3 Paragraph border  Paragraph border added 2  Only top and bottom borders appear (Do not accept text boxes, tables or any drawing shapes) 2.4 Drop-down control added Drop-down control for Group 2 label has the options 1 Accounting/Geography/Business Studies (Do not penalise if not in correct order) 2.5 Check box added  Check box control added for the Mathematics/Mathematical Literacy option 2  Align with tab stop at 8 cm (Do not accept the use of default tab stops) 2.6 Properties of Surname/Van field set to allow 10 characters 1 2.7 Table properties  Table inserted with 1 row and 10 columns  Table/columns set to ‘AutoFit to contents’ 3  Row height set to 0.8 cm (Do not penalise incorrect positioning) 2.8 Signature line added  Signature line added using a tab stop with any tab 2 leader 2.9 Password  Password ‘Help’ inserted 2  Editing option: Filling in form Total for QUESTION 2: [15] Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 3 File: Q3Staff_Personeel No. Criteria Max.  Mark 3.1 Row 1 1  Merge and centre cells A1 to P1 3.2 Cells A1 to P1 1  Fill colour changed 3.3 Cells A3 to P3 1 Headings align to 90˚ angle 3.4 Cell F12 1 Date formatted in dd-mmm-yy format, eg. 20-Jan-80 3.5 Cell D4 = UPPER(CONCATENATE(A4,RIGHT(B4,1),’’*’’,LEFT(C4,3)))) OR Cell D4 = UPPER(A4 & RIGHT(B4,1) &”*” & LEFT(C4,3)))  CONCATENATE or & operator  A4 6  asterisk “*”  RIGHT (B4,1)  LEFT (C4,3)  UPPER 3.6 3.6.1 Columns H3 to J3 =COUNTA(H4:H21)  COUNTA 2  H4:H21 OR  =COUNTIF (H4:H21,"Laptop") 3.6.2 Columns H3 to J3 =COUNTIFS(H4:H21,"Laptop",I4:I21,"Smartphone")  COUNTIFS 3  H4:H21 Laptop  I4:I21 Smartphones 3.7 Cell K4 =ROUND(((TODAY()-G4)/365),0)  (TODAY)  - G4 5  / 365 days  ROUND  0 decimals 3.8 Cell L4 =IF(K4>=30,"Gold",IF(K4>=20,"Silver","No Certificate"))  IF 4  K4>=30,"Gold"   K4>=20,"Silver"  "No Certificate" 3.9 Cell C22=LEN(C16)  LEN function used 2  Correct cell range Copyright reserved Please turn over
Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2015) 3.10 Column M22 =COUNTBLANK(M4:M21) 2  COUNTBLANK   (M4:M21) 3.11 Cell O9 =N9*120  N9 3  * 120  O9 formatted to currency 3.12 Cell O22 =SUMIF(E4:E21,"F",O4:O21)  SUMIF 4  E4:E21  “F”   O4:O21 3.13 Sheet 1 renamed to Invoice 1 3.14 Cell C20: VLOOKUP(B20,Costs_Lookup!A$2$:$D$12,2,TRUE)  VLOOKUP   B20 6  Costs_Lookup!A$2$:$D$12  Absolute cell reference used  Copied to C20:C30  2,TRUE  3.15 Cell D15 1 =Now() Total for QUESTION 3: 42 Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P1 7 QUESTION 4 File: Q4Marks_Punte No. Criteria Max.  Mark 4.1 Graph  Correct data range used C10:I10 and C2:I2  Column chart created  Data labels centred  Legend renamed to Asanda Lamani 8  and correctly displayed  Minimum of the y-axis changed to 20  and Maximum to 100  Chart moved to Graph sheet Total for QUESTION 4: 08 Copyright reserved Please turn over
Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2015) QUESTION 5 File: Q5_Reps Info No. Criteria Max.  Mark 5.1 5.1.1  Name of tab field appear before Model field 2  Primary key added to Name of tab field 5.1.2 Data type of DatePurchased field added to Date/Time 1 5.1.3  New field Operating systems   added before Screen size field 3  Data Type: OLE Object or Hyperlink 5.1.4  Field size of Review: Double 2  Decimal place: 1 5.1.5  Data type for Available colours field set to Lookup and Colours Black, White, Grey and Red entered  Limit to list checked 2 (Note to marker: Accept two and more entries) 5.1.6 Field Name of Tab: Input mask >LL\_000  Upper case and two letters >LL  2  Underscore and three digits _000  5.1.7 Field Name of tab Record no 6 spelling–from ‘Goegle’ to ‘Google’ 1 (Do not accept incorrect spelling) 5.2 Query: Q5Androids  Display all fields  Criteria: Like “A” 2 Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P1 9 5.3 Query: Device info  Only Name of Tab, Storage, Screen size and Current Value fields displayed  Criterion for Current Value field: >10 000  Sorted by ‘screen size in alphabetical order  Saved as Q5Modified 4 5.4 Query: Q5Tabs Query Deposit: [Current Value]*0.2  New field called Deposit 4  [Current Value]   Multiply  0.2 5.5 Form: Q5Signals_Seine 5.5.1 Operating system field removed 1 5.5.2  Date added as a field 2  In the footer of the form (Do not penalise if both date and time are added) 5.5.3  List box control added to the form 5  Values (Wi-Fi, 3G, and LTE) added to the control box  List box controls links to Connectivity_Seine  Suitable label linked to Name/Discription of the field  Label formatted to resemble existing labels (If candidate used a combo box instead of a list box they will lose 1 mark) 5.6 5.6.1 Paper size changed to Letter  1 5.6.2 Page number inserted. 3  = “Page” &[Page]& “of” & [Pages]   Right Aligned   At the Bottom of the report  5.6.3 Date inserted 1 =Date() 5.6.4 =Count(*) 3 Any appropriate label: Total No of Tabs 5.6.5 Report Heading: Q5Favourites_Gunsteling 1 formatted to blue font colour  Total for QUESTION 5: [40] Copyright reserved Please turn over
Downloaded from hlayiso.com 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2015) QUESTION 6 File: Question6.Html No. Criteria Max.  Mark 6.1 1 <title>Tablets on wheels</title> 6.2  < img src = “Q6_Logo.jpg”   align = “right”  4  height = “100”  width= “100”  6.3 <h1>Contact Details</h1> 1 6.4 <b>Address</b> 1 6.5 <font face = “Algerian” color = “red”>  3 <font> </font> tag 6.6 <ul type = “square”>  <li></li> <li> Acer </li> 4 <li> Apple </li> <li> Lenovo </li> </ul> 6.7 Shipment 5 <table border = "5" cellpadding = "8"> </table> 6.7.1 <table border = “5”  6.7.2 cellpadding = “8”  <th> Standard </th> <td></td> 6.8 <a href = "Tablets-v-textbooks.jpg"> "e-Books" </a href> <a href> </a href> 3 “Tablets-vtextbooks.jpg” Linked to the word “e-Books”  Total for QUESTION 6: [22] Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2015) COMPUTER APPLICATIONS TECHNOLOGY P1 11 QUESTION 7 Open the file Q7Myfile No. Criteria Max.  Mark 7.1 Subfolder music created 1 7.2 MP3 Files moved into the music folder (4 files) 1 7.3 Types of tablets Size = 11 KB  1 7.4 Selfie.docx protect with password  2 #Self12 7.5  Tables.docx converted to Tables.pdf 2  Tables.docx removed 7.6 Chart Staff_Personeel exported and linked  2 7.7  Ultimate7 compressed 2  Ultimate7 renamed to Q7Compress 7.8 Q7MyFile sorted descending by size 2 Screenshot added 7.9 Q7Answersheet_Antwoordblad 1 Students Name as Author 7.10  Envelope correctly created  Delivery address correctly entered   Return address correctly entered  Merge complete successful 4 Total for QUESTION 7: 18 TOTAL: 180 Copyright reserved Please turn over

Study this subject

More from Grade 12 Computer Applications Technology

View all