Computer Applications Technology Grade 12 IEB Paper 2 2018 Memo

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 1 of 26 EXAMINATION NUMBER #VALUE! PERCENTAGE 0.56% ACTUAL MODERA POSSIBLE MARK 180 1 0 1 MARK TED MARKER MOD Q1 FILE AND FOLDER MANAGEMENT FINAL MARK 1.1 Folder renamed correctly. 1 0 0 0 1.2 File extensions displayed. 1 1 0 1 Folder uncompressed. 1.3 2 0 0 0 Saved as NewTeams2018. Folder options changed to show hidden files or folders. OldFiles2017 1.4 2 0 0 0 Hidden property changed. Additional author added. TeamsAttending.docx 1.5 2 0 0 0 Exam Number added. Search criteria shows author property. q1FileandFolderManagement.docx 1.6 2 0 0 0 Search words or part of "Jessica Mankowsi" used. Size of RAM recorded. 1.7 2 0 0 0 Correct screenshot added. Choose Start→Control Panel→System and Security. The Administrative Tools window appears. Click Defragment Your Hard Drive. The Disk Defragmenter dialog box appears. 4 0 0 0 Click the Analyse Disk button. When the analysis is complete, click the Defragment Disk button. 1.8 This is OS and version specific. Accept any four steps that are correct. Please see alternative solution below. Open Search, type defragment and enter. Click Defragment and optimise your drives. Click the Analyse Disk button. Click the Optimise button 1.9 Appropriate screenshot pasted. 1 0 0 0 1.10 New folder created and named correctly. AnswerFiles-ExamNumber 1 0 0 0 1.11 q1FileAndFolderManagement.docx moved to new folder. 1 0 0 0 Q1 TOTALS 19 1 0 1 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 2 of 26 MARKER MOD Q2 WORD PROCESSING - q2EventBrochure.docx FINAL MARK 2.1.1 Orientation changed to landscape. 1 0 0 0 All margins changed. 2.1.2 2 0 0 0 Changed to 1,5 cm. Width set to 29 cm. 2.1.3 2 0 0 0 Height set to 20 cm. Columns applied. 2.2.1 2 0 0 0 Three columns present. Column width adjusted. 2.2.2 2 0 0 0 Each column measures 7,5 cm. 2.2.3 Line inserted between columns. 1 0 0 0 Image inserted. 2.3.1 Inserted at the top of the middle column. 3 0 0 0 Image aligned to the left. Image resized. 2.3.2 Height set to 2 cm. 3 0 0 0 Width set to 2 cm. 2.3.3 Text wrapped tightly and appears only to the right of image. 1 0 0 0 2.3.4 Correct caption inserted. 200m Race 1 0 0 0 End note applied (search for " ^e" to see end note). 2.4 End note applied to correct text. "Behavioural Benefits" 3 0 0 0 Correct note used. 2.5 Last paragraph of the document highlighted yellow. 1 0 0 0 Q2 TOTALS 22 0 0 0 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 3 of 26 MARKER MOD Q3 WORD PROCESSING SNR_SUB_1 FINAL MARK 3.1.1 New file created. q3LetterHead-ExamNumber 1 0 0 0 Table inserted in header section. 3.1.2 2 0 0 0 Table has two columns and one row. 3.1.3 First column split into two rows. 1 0 0 0 3.1.4 Columns resized. 12cm and 4cm 1 0 0 0 3.2 WordArt inserted. 1 0 0 0 Text inserted. "Honesty, Commitment, Character" 3.3 2 0 0 0 as superscript. 3.4 Text added to the last column. 1 0 0 0 3.5 Only the bottom border is visible. 1 0 0 0 3.6.1 Text inserted in footer section. 1 0 0 0 3.6.2 Font changed to Arial. 1 0 0 0 3.6.3 Line inserted above text. 1 0 0 0 Section Break applied. (Next Page) 3.6.4 2 0 0 0 Only footer shows on second page. 3.7 Document saved as a template (.dotx). 1 0 0 0 Q3 TOTALS 16 0 0 0 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 4 of 26 MARKER MOD Q4 MAIL MERGE FINAL MARK 4.1.1 Officials.txt used as source. 1 0 0 0 4.1.2 Filter applied; managers selected. There will be 10 records. 1 0 0 0 Fields replaced. 4.1.3 2 0 0 0 Appropriate fields used. 4.2.1 Correct tab stop applied. 1 0 0 0 Radio buttons inserted. 4.2.2 2 0 0 0 Correct Options used. 4.2.3 Co-Ed button selected by default. 1 0 0 0 4.3 Text content control inserted. 1 0 0 0 4.4 Date picker content control inserted. 1 0 0 0 Merge completed. Only first two records used. 4.5 4 0 0 0 First document saved as q4MergeRec_1.docx. Second document saved as q4MergeRec_2.docx. Editing restricted. 4.6 2 0 0 0 Users can only fill in forms. Q4 TOTALS 16 0 0 0 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 5 of 26 MARKER MOD Q5.1 SPREADSHEETS YASSER OLIVER FINAL MARK 5.1.1 Colour of Officials tab changed to green. 1 0 0 0 5.1.2 (a) A1:F1 merged. 1 0 0 0 5.1.2 (b) Text aligned to the right. 1 0 0 0 5.1.2 (c) Font size changed. 1 0 0 0 Thin diagonal crosshatch fill. 5.1.2 (d) 2 0 0 0 Colour of crosshatch changed to green. 5.1.2 (e) Merged cells have a double-line border. 1 0 0 0 Filter applied. 5.1.3 Correct column used. 3 0 0 0 Only coaches selected. =rand() in any range corresponding to the boys OR RANDBETWEEN() =RANK 5.1.4 4 0 0 0 '(G15, $G$15:$G$21,0) in appropriate cells OR (1,2) in the range for the RANDBETWEEN IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 6 of 26 Green font, 5.1.5 (a) 2 0 0 0 strike through. 5.1.5 (b) Boys' Schools have a blue fill. 1 0 0 0 5.1.5 (c) Girls' Schools have a solid outline border. 1 0 0 0 Q5.1 TOTALS 18 0 0 0 MARKER MOD Q5.2 SPREADSHEETS FINAL MARK =IF( VALUE( MID( 5.2.1 C2, 7 0 0 0 7,4)) OR 7,1)) >4999, OR >4, as long as Value is used otherwise "4999" OR "4" "Male", "Female") =INT( OR ROUNDDOWN(….,0) (Competition_Details!$B$6 5.2.2 4 0 0 0 -Athletes!E2) /365) OR /365.25) IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 7 of 26 =HLOOKUP(F2, 5.2.3 Classification!$A$1:$G$2 OR Classification!$B$1:$G$2 must be absolut ref 3 0 0 0 2,0) =COUNTIF( Athletes!$H$2:$H$199, OR Athletes!H:H 5.2.4 4 0 0 0 Summary!A2) Copied to B11 =(COUNTIF( Athletes!I2:I199, "National Standard")) 5.2.5 6 0 0 0 / COUNT(Athletes!G2:G199) OR any other appropriate column Formatted as a percentage IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 8 of 26 5.2.6 (a) A16:B22 Used as source data for chart. 1 0 0 0 5.2.6 (b) 3D pie chart used. 1 0 0 0 5.2.6 (c) Legend appears to the right. 1 0 0 0 5.2.6 (d) Legend's text colour white. 1 0 0 0 Chart background changed. 5.2.6 (e) 2 0 0 0 Image applied. 5.2.6 (f) Correct chart title. 1 0 0 0 Q5.2 TOTALS 31 0 0 0 MARKER MOD Q6 DATABASES FINAL MARK Primary key applied 6.1.1 2 0 0 0 to [NAT_ID]. Input mask applied to the NAT_ID field. 6.1.2 0–9 only 3 0 0 0 13 digits IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 9 of 26 List Box applied. 6.1.3 Options available are "Male" and "Female". 3 0 0 0 Only the two options can be selected. Combo box created. 6.1.4 Looks up value from tblSchool. 3 0 0 0 Only [SchoolName] appears. Relationship created. 6.2.1 2 One to many. Referential Integrity enforced. 6.2.2 2 0 Cascade update related fields. IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 10 of 26 Primary key applied to EventNumber. 2 0 0 0 Primary key applied to Athlete. 6.3 6.4.1 Field size changed to 25. 1 0 6.4.2 The required field property set to "Yes". 1 0 Indexed field property set to "Yes". 6.4.3 2 0 "Duplicates" property applied to the indexed property. All fields used 6.5.1 2 0 0 0 from tblEventList. Fields Athlete, TimeOrDistance and Position used. 6.5.2 2 0 0 0 from tblEventManager. 6.5.3 Grouped by tblEventList. 1 0 0 0 6.5.4 Form header edited. 1 0 0 0 6.5.5 Font colour of labels changed. 1 0 0 0 Image inserted as background. 6.5.6 2 0 0 0 Image stretched over entire form. FIRST_NAME, SURNAME and DESCRIPTION or CODE fields used in query. Field DESCRIPTION or field CODE set to not show. 6.6.1 3 0 0 0 "National Standard" set as criteria in the DESCRIPTION field. Or "L1" set as criteria in the CODE field. IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 11 of 26 [Description] and [NAT_ID] used. 6.6.2 Totals or Group By applied. 3 0 0 0 Count applied to [NAT_ID]. 6.7.1 Report created. 1 0 0 0 Grouped by Classification and then by School. Do not award mark if Classification 1 0 0 0 6.7.2 only has been used for grouping. IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 12 of 26 6.7.3 =Count(*) OR =Count([NAT_ID]) OR =Count([CLASSIFICATION]) 2 0 0 0 Inserted into Group Footer Q6 TOTALS 40 0 0 0 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 13 of 26 MARKER MOD Q7 HTML - index.html FINAL MARK 7.1 <title> ExamNumber</title> must be in the head 1 0 0 0 <body background 7.2 2 0 0 0 ="Images\AthsSportsCentre.jpg"> 7.3.1 align = "center" 1 0 0 0 7.3.2 <font color = blue >###</font> 1 0 0 0 7.4.1 <img src="Images\NewLogo.jpeg" /> 1 0 0 0 width = 200px 7.4.2 2 0 0 0 height = 100px 7.4.3 <center> </center> or align = "center" 1 0 0 0 7.5 <hr color="Blue"/> 1 0 0 0 <a href = "TrackField.html"> 7.6 2 0 0 0 Track and Field Competitions</a> colspan attribute applied. 7.7.1 2 0 0 0 ="4" <th> 7.7.2 2 0 0 0 </th> <table border = 5px 7.7.3 2 0 0 0 = 5px> Q7 TOTALS 18 0 0 0 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 14 of 26 INTERNAL MODERATOR GB COMMENT IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 15 of 26 INTERNAL MODERATOR GB COMMENT IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 16 of 26 INTERNAL MODERATOR GB COMMENT IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 17 of 26 INTERNAL MODERATOR GB COMMENT IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 18 of 26 INTERNAL MODERATOR GB COMMENT IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 19 of 26 INTERNAL MODERATOR GB COMMENT IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 20 of 26 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 21 of 26 INTERNAL MODERATOR GB COMMENT IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 22 of 26 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 23 of 26 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 24 of 26 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 25 of 26 IEB Copyright © 2018

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE: COMPUTER APPLICATIONS TECHNOLOGY: PAPER II – MARKING GUIDELINES Page 26 of 26 INTERNAL MODERATOR GB COMMENT IEB Copyright © 2018