Skip to content

Computer Applications Technology Grade 12 P1 2017 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 12201715 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC November Exam 2017 (English), 15 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 MARKING GUIDELINES MARKS: 180 CENTRE FINAL MARK NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 34 16 31 19 40 20 20 180 MARKER SM CM IM/EM These marking guidelines consist of 15 pages. Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER. QUESTION 1 File name: 1Harvest Total Q1: 34 Maximum Candidate No. Criteria Mark Mark 1.1.1 Heading (HARVEST FOOD FESTIVAL) 2 • Any WordArt applied to heading  1 • WordArt rotated by 90° or 270°  1 1.1.2 Picture 4 • Picture cropped to display only the basket and grapes  1 • Height set to 10 cm  1 • Width set to 12 cm  1 • Any oval-like picture style or shape applied  1 1.1.3 Table 2 • Default top cell margin set to 0.1 cm  (check table or 1 cell options) • No borders display  1 1.2 Page break 1 • Page break or section break (next page) inserted  1 1.3.1 Styles (Mark from Styles Gallery) 1 • Display1 style removed  1 1.3.2 Display2 style modified 4 • Numbering added in format 1., 2.,  (Accept 1), 2),) 1 • Any border added  1 • Left indent set to 0 cm  1 • All occurrences of the style updated  1 1.4 Cross reference (Figure 3: Gourmet Meals) 2 • Cross reference inserted within brackets  (Accept 1 hyperlink/ bookmark) • Reference to label 'Figure 3: Gourmet Meals'  1 1.5 Language 1 • Word 'explore' language changed to English (South Africa)  (mark from task bar) 1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER 1.6 Tabs 6 • Tab set at 2 cm  1 • Left aligned  1 • Tab set at 10 cm  1 • Right aligned  1 • Solid leader tab set  1 • Tab settings applied to all lines  1 1.7 Citation (Ward) 2 • Citation to 'Jean Ward' source inserted  1 • Year does not display  1 1.8.1 Caption (Figure 6: Jumping Castle) (Alt + F9) 2 • Automatic figure caption added  to correct picture 1 • Text 'Jumping Castles' inserted  for caption 1 1.8.2 Table of figures 1 • Table of figures updated  (see 'Figure 5: Wine Shop') 1 1.9 Bibliography 2 Book, A. (2015). Too little too late. Entertainment All. Business To All. (2016, July). Retrieved from Biz Communities: www.biz_com.com Sousher, P. L. (2014). Marketing South Africa. Business Journal, 61-62. Ward, J. (2005). Coetzenburg: A Tourist Site. • Automatic bibliography inserted  1 • Appears in APA style  1 1.10 Page numbering and section numbering 4 • Page number does not appear on first page  1 • Section 2/Last page formatted with i, ii, iii, … format  1 starts from i  1 • Style of page number with 'i' not changed  1 Total for QUESTION 1 [34] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 2 File name: 2Stay Total Q2: 16 Maximum Candidate No. Criteria Mark Mark 2.1 Page layout 2 • Page size set to 'Legal' (21.59 cm x 35.56 cm)  1 • Multiple pages set to 'Book fold'  1 2.2 Comment 2 • Any comment added ('New'/'Reply'/Edited)  1 • Any relevant response added  1 2.3 Watermark 3 • Any watermark added  1 • Image '2Pic.jpg' used  1 • Scale set to 200%  1 2.4 Check box: Special Shopper 7 • Default value set to checked  1 Combo box: Type of Accommodation • Option 'B and B' added to combo box  1 • 'B and B' appears first  1 Text form field: Total • Type: Number  1 • Number format: R# ##0.00;(R# ##0.00)  1 • Help text inserted on F1 key  1 • Any text entered  (Days*Rate) (Allocate this mark if 1 text is in status bar) 2.5 SaveDate field (Alt + F9) 2 • Any date field added  (Accept any date field in any 1 format) • SaveDate field added  1 Total for QUESTION 2 [16] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 3 File name: 3Acc Total Q3: 31 • 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 Accom_Verblyf worksheet 3.1 Row 6: 2 • Row 6 height changed to exactly 45 pt  1 • Row 6 headings wrapped  1 3.2 Cell H7: 2 =G7-F7 OR =DAYS(G7,F7) OR =DAY(G7)-DAY(F7) • Correct cells used  1 • To determine difference correctly  1 3.3 Cell I8: 4 VLOOKUP(D8,Rate_Tarief!$B$3:$C$23,2) OR =VLOOKUP(D8,Rate_Tarief!$B$4:$C$23,2) • Lookup value: D8  1 • Lookup range: Rate_Tarief!$B$3:$C$23 OR Rate_Tarief!$B$4:$C$23  (accept named range) 1 • Absolute cell references correctly used  (allocate 1 mark if named range was used) • Correct column: 2  1 3.4 Cell J9: 3 =H9*I9 OR =PRODUCT(H9,I9) OR =(G9-F9)*I9 • Correct cells used  1 • Multiplication  1 • Format changed to any currency format  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER 3.5 Cell L10: (Check for building blocks) 4 =LEN(K10)/100*J10 OR =J10*LEN(K10)/100 OR =J10*LEN(K10)% OR =LEN(K10)*1%*J10 OR =J10*("0.0"&LEN(K10)) • LEN  (K10)  2 • /100  (Accept decimals instead of percentages) 1 • * J10  1 (Notes to marker: • Accept any method that will yield the correct answer. • =IF(LEN(K10)=5,J10*5%,IF(LEN(K10)=4,J10*4%, IF(LEN(K10)=3,J10*3%,IF(LEN(K10)=2,J10*2%, J10*1%)))) • =IF(K10="*****",J10*5%,IF(K10="****",J10*4%, IF(K10="***",J10*3%,IF(K10="**",J10*2%,J10*1%))). • Mark allocation for nested if: test K10 for correct number of stars, J10 used to calculate discount, identified correct %, nested if correctly applied for all options.) 3.6 Cell M7: (Check for building blocks) 6 =IF(VALUE(MID(C7,7,1))>=5,"Male","Female") OR =IF(VALUE(MID(C7,7,1))<5,"Female","Male") • IF function  1 • Criteria: VALUE OR NUMBERVALUE function  1 ((MID(C7,7,1 )) 1 >=5  OR >4 (OR >="5" if VALUE was not used) 1 • Value if true: "Male" OR "M"  1 • Value if false: "Female" OR "F"  1 (Notes to marker: • Evaluate the candidates answer against the bulleted options e.g. CODE function. • Penalise only the second mark if VALUE was not used.) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER 3.7 Cell G2: 3 =SMALL(I7:I66,3) OR =SMALL(I:I,3) • SMALL function  1 • Range: I7:I66  1 • Third smallest: 3  1 3.8 Cell G3: 2 =MODE(I7:I66) OR =MODE(I:I) • MODE function OR MODE.MULT OR MODE.SNGL function  1 • Range: I7:I66  1 3.9 Cell G4: 5 =SUMIF(E7:E66,"Country*",J7:J66) OR =SUMIF(E7:E66,"*Country*",J7:J66) OR =SUMIF(E7:E66,"Country House",J7:J66)+SUMIF (E7:E66,"Country Inn",J7:J66) • SUMIF(S) function  1 • Criteria range: E7:E66  1 • Criteria: Country OR C  *  (accept * in front, 2 allocate both marks if "Country House" and "Country Inn" was used) • Sum range: J7:J66  1 (Note to marker: =SUMIFS(J7:J66,E7:E66,"Country*") Total for QUESTION 3 [31] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 4 File name: 4Quest Total Q4: 19 • 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 Respons worksheet 4.1 Cell H3: 2 =COUNTBLANK(H6:H115) OR =COUNTIF(H6:H115,"") • COUNTBLANK function  1 • Range: (H6:H115)  1 4.2 Cell K6: 4 =TIME(HOUR(J6),MINUTE(J6)+20,0) OR =J6+TIME(0,20,0) OR =SUM(TIME(0,20,0),J6) OR =J6+TIMEVALUE("0:20") • J6  1 • Any time function  1 • 20 minutes  1 • Added  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER 4.3 Cell K3: 4 =COUNTA(H6:H115)/K2*100 OR =COUNTA(H6:H115)/K2 OR =COUNTIF(H6:H115,"*")/K2 OR =(K2-H3)/K2*100 OR =(K2-H3)/K2 OR =100*(1-H3/K2) OR =((K2-COUNTBLANK(H6:H115))/K2*100)/100 • COUNTA function OR K2-H3  1 • Range: (H6:H115) OR Correct use of brackets  1 • /K2  (Accept COUNTA of columns A, B, C, D or G) 1 • *100 OR format changed to percentage  1 4.4 Columns A and B: Conditional formatting 4 • Conditional formatting applied to A6:B115  1 • =$B$3=$G6  OR =$B$3=$G6:$G115 (Ignore 1 absolute cell reference) • Absolute cell reference correctly applied ($G6 OR G6 OR $G6:$G115 OR G6:G115)  1 • Format style: Any fill colour  1 Earn_Verdien worksheet 4.5 Chart/Graph: 5 • Vertical axis title inserted 'Amount'  1 • 4Coin image inserted  and stacked and scaled in 1 units of 100 000  (8 coins display) 1 • Horizontal axis labels: o Alignment set to: Rotate all text 270° or 90°  1 o Major units set to 2 days  1 Total for QUESTION 4 [19] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 5 File name: 5Visit Total Q5: 40 Maximum Candidate No. Criteria Mark Mark Table: tbAccom 5.1.1 Field: Name 1 • Field size changed to 30  1 5.1.2 Field: Surname 1 • Set as required field  1 5.1.3 Field: IdentityNumber 2 Input Mask: 0000000000000 • Compulsory digit used: 0  1 • 13 characters  1 5.1.4 Field: Province 2 • Option 'EC' added to drop down list  1 • Added as first option in drop down list  1 5.1.5 Field: DateIn 4 • Validation Rule: >= #2017/11/18#  AND <= #2017/11/28 #  3 OR >#2017/11/17# AND <#2017/11/29# OR Between #2017/11/18# AND #2017/11/28# OR Between "2017/11/18" AND "2017/11/28" • Validation text Any appropriate validation text that refers to the range of dates  1 5.1.6 Field: Code 2 • Expression modified as: LEFT([Surname]  1 • ,3 ) 1 Form: frm5_2 5.2 • Form header text changed  to examination number 1 6 (accept if examination number was added) • Show date picker for DateIn field set to never  1 • Format of Rate field changed to any currency  1 • Date field inserted OR DATE()  1 • Time field inserted OR TIME()  1 • In the form footer  1 (Note to marker: Allocate Date and Time mark if =NOW() was used.) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER Query: qry5_3 5.3 • Province criteria: LP  OR  MP  OR In("LP","MP") 3 4 • Data sorted ascending by Surname  1 (Note to marker: 11 records expected.) Query: qry5_4 5.4 • Total (Group by) row displayed  1 2 • SUM selected for NumberOfNights field in Total row  1 Query: qry5_5 5.5 • Only Name and Surname fields are displayed  1 7 • NumberOfNights criteria: <=5  (OR <6) 1 • Amount field criteria: <800  OR  >2000  3 • DOB criteria: IS NULL OR Not Like "*" 1 • AND operator for all field criteria  1 (Note to marker: 2 records expected.) Query: qry5_6 5.6 Calculated field: 4 Discount:[Amount]-[Amount]*10/100 OR Discount:[Amount]-[Amount]*0.1 OR Discount:[Amount]*0.9 OR Discount:[Amount]*90/100 • New calculated field Discount added  1 • 10% calculated  1 • On the original Amount  1 • Subtract to get the difference  1 Report: rpt5_7 5.7 • Shading applied to Province field  (in Province group 1 5 header) • Amount field sorted  in descending (largest to 1 smallest) order • Function in Accommodation group footer/header  1 =SUM  ([Amount])  2 (Note to marker: Allocate the marks for the function even if it appears in the wrong place.) Total for QUESTION 5 [40] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 6 File name: 6Viti Total Q6: 20 • NO marks should be allocated for answering this question using Word. • 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 Font Type 1 <font face="Arial"> • Font type set to 'Arial'  1 6.2 Heading 1: 'Growing Grapes' 2 <h1 align="center"><font color="blue">Growing Grapes</font></h1> OR <h1><center><font color="Blue">Growing Grapes</font></center></h1> • Text 'Growing Grapes' alignment set to centre  1 align="center" OR <center></center> • Text 'Growing Grapes' font colour set to blue  1 <font color="blue"> 6.3 Horizontal line 2 <hr size="3"> OR <hr size="3"/> • Horizontal line inserted  1 • Size set to 3  1 6.4 Bulleted list 3 <ul type="circle"> <li>the composition of the soil</li> <li>the climate</li> <li>situation of vineyard</li> </ul> • Unordered list  1 • Bullet circle type: type="circle" applied to all list items  1 • List item applied to at least one item  (if list items are 1 not closed, check line 1 for <<!DOCTYPE html>>) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 13 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER 6.5 Image: Height and width 4 <img src="6Hectare.png" height="250" width="350"> • Img tag  1 • Correct source file: src = "6Hectare.png"  1 • Height set to 250  1 height="250" • Width set to 350  1 width="350" 6.6 Table 5 <table border="5" width="60%"> <tr> <td colspan="2"><font color="blue"> <b>Variety of grapes</b></font></td> </tr> … <tr> <td>Currants*</td> <td>987 125</td> </tr> <tr> <td>Sultana</td> <td>148 759 871</td> </tr> </table> • Table border changed to 5: border="5"  1 • Spans two columns: colspan="2"  1 • Last row added to table: <tr> … </tr>  1 • Two cells added to last row: <td> … </td>  1 • Any required text added in at least one cell  1 6.7 Hyperlink 3 <a href="6SAStats.docx"><img src=6More.jpg></a> • Hyperlink created: <a href></a>  1 • On image  1 • To correct file: "6SAStats.docx">  1 Closing tag(s) or triangular brackets omitted or -1 incorrect nesting Total for QUESTION 6 [20] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 14 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 7 File names: 7Calc, 7Rep Total Q7: 20 Maximum Candidate No. Criteria Mark Mark 7Calc: Num_Nom worksheet 7.1 Cell A3: 10 RANDBETWEEN (100,999) OR =RAND()*(999-100)+100 OR =RANDBETWEEN(1,9)&RANDBETWEEN(0,9)& RANDBETWEEN(0,9) • RANDBETWEEN OR RAND function  1 • Lower boundary (Any 3-digit number)  1 • Upper boundary (Any 3-digit number)  (Should be larger than lower boundary) 1 Cell B3: =LEFT(A3,1) OR TRUNC(A3/100) OR MID(A3,1,1) OR INT(A3/100) OR LEFT(A3) • LEFT function  (OR TRUNC OR MID) 1 • Extract one character from cell A3  1 Cell C3: =RIGHT(A3,1) OR MID(A3,3,1) OR MID(A3,LEN(A3),1) OR A3-INT(A3/10)*10 OR RIGHT(A3) • RIGHT function  (OR MID) 1 • Extract one character from cell A3  1 Cell D3: =IF(B3=C3,"YES","NO") OR =IF(EXACT(B3,C3),"YES","NO") • Check that B3=C3  (OR (B3<>C3)) 1 • Value if true: "YES"  1 • Value if false: "NO"  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 15 DBE/November 2017 NSC – Marking Guidelines EXAMINATION NUMBER 7Calc: Vouch_Bewys worksheet 7.2.1 Cell E2: (Check for building blocks) 7 =TODAY()<=DATE(YEAR(NOW()),MONTH(D2),DAY(D2)) OR =IF(TODAY()>=DATE(2017,MONTH(D2),DAY(D2)), "FALSE","TRUE") OR =IF(TODAY()<DATE(YEAR(TODAY()),MONTH(D2),DAY(D 2)), "TRUE","FALSE") OR =IF(DATE(YEAR(TODAY()),MONTH(D2),DAY(D2))>=TOD AY(),"TRUE", "FALSE") OR =OR(AND(MONTH(D2)=MONTH(TODAY()),DAY(D2) >=DAY(TODAY())),MONTH(D2)>MONTH(TODAY())) OR =OR(IF(MONTH(D2)>MONTH(TODAY()),TRUE), AND(MONTH(D2)=MONTH(TODAY()),DAY(D2) >=DAY(TODAY()))) OR =IF(MONTH(D2)>MONTH(TODAY()),"TRUE", IF(MONTH(D2)=MONTH(TODAY()),IF(DAY(D2) >=DAY(TODAY()),"TRUE","FALSE"),"FALSE")) • Criteria 1: Check if birth month is greater than current month  1 • Correct output (TRUE) if birth month/date is greater than current month/date  1 • Criteria 2: Check if current month is equal to birth month  AND current day is greater or equal to birth 1 day  1 • Correct output (TRUE) if both aspects in criteria 2 are true  1 • Correct output (FALSE) if criteria 2 is false  1 • Function copied to cells E3:E111  1 (Note to marker: Award the output mark if the second criteria is wrong but the output is correct.) 7.2.2 rpt7_2 report in 7Rep database 3 • 7Calc data imported to 7Rep  (110 records) 1 • Any report created  with 4 or 5 correct fields  2 Total for QUESTION 7 [20] TOTAL 180 Copyright reserved

Study this subject

More from Grade 12 Computer Applications Technology

View all