Skip to content

Computer Applications Technology Grade 12 P1 2017 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 12201716 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC November Exam 2017 (English), 16 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 COMPUTER APPLICATIONS TECHNOLOGY P1 NOVEMBER 2017 (2) MARKING GUIDELINES MARKS: 180 CENTRE FINAL MARK NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 27 24 24 26 41 19 19 180 MARKER SM CM IM/EM These marking guidelines consist of 16 pages. Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER. QUESTION 1 File name: 1Rio Total Q1: 27 Maximum Candidate No. Criteria Mark Mark 1.1 Cover page 3 • Text 'Rio Carnival' or any other text inserted in 'Title' control  1 • Text 'Rio Carnival is the Mother of All Brazilian Carnival Parties' moved (not copied) into 'Subtitle' control (ignore formatting but no marks allocated if text also appears in original position)  1 • 'Company' control removed  1 1.2 Style 1 • 'Heading 1' style renamed to 'Rio'  1 1.3 Table of contents 1 • Table of contents updated  ('The Carnival Original' 1 does not appear) 1.4 Page numbers 3 • Section break inserted  1 • Page number from 'Table of Contents' page removed  1 • Page after 'Table of Contents' page numbered as 1  1 1.5 Superscript 1 • 'Adapted from www.dobrazilrigth.com' appears in superscript  (Accept all or part of text) 1 1.6 Line spacing 2 • Paragraph 'Carnival is on …' line spacing changed to 'Multiple'  1 • At 1.2  1 1.7 Footnote 1 • Footnote removed from the word 'Portuguese'  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER 1.8 Columns 3 • Text inserted into 2 columns  1 • First column width set to 5 cm  1 • Second column width set to 10 cm  1 1.9 Leader tabs 3 • Tab set on 10 cm  1 • Right-aligned  1 • Dotted leader tab set  1 1.10 WordArt/Picture 3 • Picture 1Mask.jpg inserted  1 • Wrapping changed to Square/Tight/Through/Behind Text/In Front of Text  (Mask appears to the right of Rio 1 and above the WordArt) • Picture adjusted and moved to resemble example  1 1.11 Find and replace 2 • All occurrences (5 changes/6 occurrences)  (accept 7 1 occurrences if original is still in document) • ao replaced with ão  1 1.12 Hyperlink screentip 1 • Screentip 'Read more' inserted on hyperlink  (Accept 1 any text for the screentip) 1.13 Source 2 • Website source inserted  1 • URL OR name of website inserted  1 1.14 Bibliography 1 • Automatic bibliography inserted  1 Total for QUESTION 1 [27] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 2 File name: 2Party Total Q2: 24 Maximum Candidate No. Criteria Mark Mark 2.1 Page footer 2 • File path inserted as a field  (File name will be 1 included) • Appear in page footer  (not header) 1 2.2 Widow/Orphan control 1 • Widow/Orphan control checked  for paragraph that 1 starts with 'Blocos are groups …' 2.3 Caption 2 • Automatic caption inserted on picture either above or below  1 • 'Figure 1: Orguestra' (accept any text)  1 2.4 Indentation 2 • Number position set at 0 cm  1 • Text indent set at 1.4 cm  1 2.5 Antonym 1 • 'Successors' replaced with 'predecessors'  1 2.6 Comment 1 • Comment inserted on '2010' with text 'Since 2000'  1 2.7 Cross-reference 2 • Cross-reference added  on 'ref' 1 • Moves to '9.Other Blocos'  1 2.8 Bullets 2 • Bullets changed  1 • To 2Maraca.jpg  1 2.9 Table 7 • Table style changed to any other table style  1 • Repeat row header selected  (not for whole table) 1 • Textbox form control type changed to 'Date'  1 • Displays in date format 'dd Mmm' OR 'dd mmm' OR 'dd MMM'  1 • First five cells in last row merged  (Accept any 1 number of cells merged) • Formula entered: =SUM  (Above)  2 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER 2.10 Spreadsheet inserted 2 • Data from spreadsheet 2Carnival inserted as table  1 • As linked object  (Verify by checking 'Edit Links to 1 Files' or checking that 'Update Link' appears on the right-click menu) 2.11 Table to text 2 • Table converted to text  1 • Character used to separate '#'  1 Total for QUESTION 2 [24] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 3 File name: 3Stat Total Q3: 24 • Mark the questions from the formulae and not the values/answers in the cell. • Check against candidate's actual work (Cell references may differ, depending on the candidate's response). • Candidate may use multiple formulae or cells as 'building blocks' to reach answers. • Named ranges can be used instead of cell references. • The answers must still be correct even if changes are made to the existing data. Maximum Candidate No. Criteria Mark Mark Visit_Besoek worksheet 3.1 Foreign worksheet: 1 • Foreign worksheet shows  1 3.2 Cell D4: 1 • =VALUE(C4)  1 3.3 Cell E89: 1 =SUM(E4:E88) • E89 changed to E88  1 3.4 Cell F89: 3 =LARGE(F4:F88,7) • LARGE function  1 • F4:F88  1 • ,7  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER 3.5 Cell G4: 6 =RIGHT(A4,3)&LEN(B4)&RANDBETWEEN(100,200) OR =CONCATENATE(RIGHT(A4,3),LEN(B4), RANDBETWEEN(100,200)) OR =RIGHT(A4,3)&LEN(B4)&TRUNC(RAND()*(200- 100)+100) • RIGHT function  1 • (A4,3)  1 • LEN(B4)  1 • RANDBETWEEN function/(TRUNC(RAND() …)  1 • (100,200)/(200-100)+100  1 • & OR CONCATENATE  1 3.6 Conditional formatting: 3 • Conditional formatting applied to cells B4:B88  1 • Format all unique values  1 • Font colour set to red  1 Summary_Opsom worksheet 3.7 Cell C2: 3 • Hyperlink set in cell C2  1 • Links to cell F4  in the Visit_Besoek worksheet  2 3.8 Graph/Chart: 6 • Graph/Chart title inserted 'Visitors'  1 • Column graph/chart created for 'National' and 'Foreign'  and line graph with or without markers for 1 'Total'  1 • Legend displayed on left of chart/graph  1 • 3Brazil set as plot/chart area background  1 • 'National' data series filled with any pattern  1 Total for QUESTION 3 [24] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 4 File name: 4Tickets Total Q4: 26 • Mark the questions from the formulae and not the values/answers in the cell. • Check against candidate's actual work (Cell references may differ, depending on the candidate's response). • Candidate may use multiple formulae or cells as 'building blocks' to reach answers. • Named ranges can be used instead of cell references. • The answers must still be correct even if changes are made to the existing data. Maximum Candidate No. Criteria Mark Mark Sales_Verkoop worksheet 4.1 Page orientation 1 • Page orientation changed to landscape  1 4.2.1 Row 1 height 1 • Row height changed from 78.75 to 135 pt  1 4.2.2 Picture 1 • Picture stretched to approximately fit into cell A1  1 4.3 Cells A2:K2: 2 • Headings appear in bold  1 • Background shaded to any colour  1 4.4 Cell K1: 4 =DATE(2018,2,1) • Year: 2018  1 • Month: 2  1 • Day: 1  1 • Custom format: dd MMMM yyyy  (Accept dd-MMM- 1 yyyy) 4.5 Cell G4: 3 =(F4-E4)*24 • (F4-E4)  1 • *24  1 • Cell's number format changed to number or general  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER 4.6.1 Cell N3: 4 =ROUNDDOWN(AVERAGE(H3:H80),0) OR =INT(AVERAGE(H3:H80) OR =INT(AVERAGE(H:H) • ROUNDDOWN function  1 • AVERAGE function  1 • Range: (H3:H80)  (OR H:H) 1 • ,0  1 4.6.2 Cell J3: 5 =IF(H3>=$N$2,IF(H3<=$N$3, "TRUE","FALSE"),"FALSE") OR =IF(AND(H3>=$N$2,H3<= $N$3),"TRUE","FALSE") OR =(H3-$N$2)*(H3-$N$3)<=0 OR =IF(AND(H3>$N$3,H3>$N$2),"FALSE",IF(AND(H3<$N $3,H3<$N$2),"FALSE","TRUE")) OR 1 =AND(H3>=$N$2,H3<=$N$3) 1 1 • IF H3  1 • >=N2  (Ignore absolute cell reference) 1 • AND <=N3  (Ignore absolute cell reference) • TRUE if between  • FALSE if not between  Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER 4.7 Cell K3: 5 =VLOOKUP(I3,Places_Plekke!A2:C7,3,False)*H3 OR =VLOOKUP(I3,Places_Plekke!A2:C7,3)*H3 OR =VLOOKUP(I3,Places_Plekke!$A$1:$C$7,3)*H3 • VLOOKUP function  1 • Lookup value: I3  1 • Lookup array Places_Plekke!A2:C7 OR Places_Plekke!A1:C7  (Ignore absolute cell 1 reference) • Column index: 3  1 • *H3  1 Total for QUESTION 4 [26] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 5 File names: 5Samba, 5_7Gender.pdf Total Q5: 41 Maximum Candidate No. Criteria Mark Mark Table: tbComp 5.1.1 Field: Entry 1 • Field size changed to 15  1 5.1.2 Field: PerformanceDay 5 Input Mask: >L?09 • > 1 • L 1 • ? 1 • 0 1 • 9 1 5.1.3 Field: Class 2 Validation rule: "A" or "B" or "C" or "D" or "E" or "F" • AND operator changed to OR operator  1 • Suitable validation text entered that refers to characters A–F to be entered  1 5.1.4 New field 2 • New field added with suitable name (should refer to sound clips)  1 • Data type set to OLE object /attachment /hyperlink  1 5.1.5 Field: Year 1 • Moved to appear last in field list  (Check in 1 datasheet view and design view) 5.1.6 Sorting 1 • Database sorted according to school names  (Check 1 in datasheet view and design view) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER Form: frm5_2 5.2 • Form created with all fields from tbComp table  1 7 • Heading 'Entries' inserted in form header  (May 1 appear with default heading) • Class field changed to combo box  1 • Row source: "A";"B";"C";"D";"E";"F"  1 • Row source type: "Value list"  1 • Label with examination number  added in form 1 footer  1 Query: qry5_3 5.3 • Sorted first by Surname  1 4 then by School  1 • Criteria on Position: 1  1 • School, Surname, Name fields displayed  1 (Note to marker: 6 records expected.) Query: qry5_4 5.4 • Criteria in PerformanceDay: 7 Between #2017/03/02#  AND #2017/03/03#  2 OR >=#2017/03/02# AND <=#2017/03/03# OR #2017/03/02# OR #2017/03/03# OR Day([PerformanceDay])=2 OR Day([PerformanceDay])=3 AND Month([PerformanceDay])=3 AND Year([PerformanceDay])=2017 • Calculated field: [TotalPoints]*110/100 OR ([TotalPoints]*0.1) + [TotalPoints] OR [TotalPoints] *1.1 OR ([TotalPoints]*10/100) + [TotalPoints] NewPoints field name:  1 [TotalPoints]*  1 Calculation of 10%  1 Added to [TotalPoints]  1 • TotalPoints criteria: >265  1 (Notes to marker: • 17 records expected. • The format of the date may differ.) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 13 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER Query: qry5_5 5.5 • Criteria in Entry: Like "??" OR LEN([Entry])=2 2 o ?  (correct character or use of LEN function) 1 o Two characters  1 (Note to marker: 15 records expected.) Report: rpt5_6 5.6 • Fields inserted PerformanceDay, Class, Surname, 7 Name, Title, School  (Ignore sequence) 1 • Report firstly grouped by PerformanceDay  1 • Performance grouping intervals set to Normal/Day  1 • Report secondly grouped by Class  1 • Function in Class group footer/group header  1 =Max  ([TotalPoints])  2 (Note to marker: Allocate the marks for the function even if it appears in the wrong place.) PDF: 5_7Gender 5.7 • Report exported  1 2 • As PDF  1 Total for QUESTION 5 [41] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 14 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 6 File name: 6Post Total Q6: 19 • This question should be marked from the HTML code. • Numerical attribute values do not need to be in inverted commas. • A maximum of 1 mark will be deducted if one or more closing tags are omitted. Maximum Candidate No. Criteria Mark Mark 6.1 Title 1 <title>Examination number</title> • Examination number added as title  1 6.2 Body background colour 2 <body text="#ecf8a4" bgcolor="green"> • Background of web page (bgcolor)  1 • Changed to green  (ignore if text tags removed) 1 6.3 Image 3 <img src="6Redeem.jpg" width="24%" height="200"> <img src="6House.jpg" width="24%" height="200"> <img src="6Flag.jpg" width="24%" height="200"> <img src="6Dance.jpg" width="24%" height="200"> • Picture inserted as second image  • Picture 6House.jpg inserted correctly  1 • Width="24%" and Height="200"  (copied from other 1 images) 1 6.4 Alignment 1 <h3 align="center">SAMBA DANCERS | FREE PAINT | FREE CARNIVAL MASKS</h3> OR <center><h3>SAMBA DANCERS | FREE PAINT | FREE CARNIVAL MASKS</h3></center> • Text centred  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 15 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER 6.5 Horizontal line 2 <hr size="4"/> • Horizontal line tag corrected  1 • Size set to 4  1 6.6 Font size 2 <font size="20">It starts on Friday</font> • Font size tags inserted  1 • Font size set to 20 pt  1 6.7 Table 6 <table border="2"> <th colspan="2">Facts about Brazil</th> <tr> <td>OFFICIAL NAME:</td> <td>Federal Republic of Brazil</td></tr> <tr> <td>CAPITAL:</td><td>Brasilia</td></tr> <tr> <td>POPULATION:</td><td>183 888 841</td> </tr> <tr> <td>OFFICIAL LANGUAGE:</td> <td>Portuguese</td></tr> </table> • Table inserted  1 • Table border added  1 • First row merged (colspan=2)  1 • First row contain a heading (th)  1 • Table contains 5 rows (correct text)  1 • Table contains 2 columns (correct text)  1 6.8 Hyperlink 2 <a href="http://www.riotickets.com">www.riotickets.com </a> • Tag completed (<a href=)  1 • To correct target http://www.riotickets.com  (ignore if 1 'http://' is left out) Closing tag(s) or triangular brackets omitted -1 Total for QUESTION 6 [19] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 16 DBE/November 2017 (2) NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 7 Total Q7: 19 File names: 7Travel.docx, 7Handout & 7Tickets Maximum Candidate No. Criteria Mark Mark 7Travel_Toer 7.1.1 Page border 2 • Page border inserted  1 • Any double line  border 1 7.1.2 Footnote 2 • Footnote (or endnote) added on the 'Redeemer' picture  1 • Any footnote text added  1 7.1.3 Picture formatting 2 • Alt Text Title inserted  1 • Alt Text Description changed to 'Photo of Hotel'  1 7.1.4 Hyperlink 1 • Hyperlink removed  1 7Handout 7.2 Handouts 3 • Slides exported to word processing document  1 • As handouts  1 • Provision for notes next to slides  1 7Tickets 7.3 Tickets table 9 • Table created  1 • 5 (6) fields added  1 • Date set to Date data type  1 • Date field format set to any date format  1 • Section, Row set to Short Text/Text  1 • Section, Row field size changed to less than 255  1 (Accept if only one field size changed) • Price set to Currency  1 • Price field format changed to Euro  1 • Sold field set to Yes/No  1 Total for QUESTION 7 [19] TOTAL 180 Copyright reserved

Study this subject

More from Grade 12 Computer Applications Technology

View all