Skip to content

Computer Applications Technology Grade 12 P1 2019 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 12201915 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC November Exam 2019 (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 2019 MARKING GUIDELINES MARKS: 180 CENTRE FINAL MARK NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 27 23 24 26 40 20 20 180 MARKER SM CM IM/EM These marking guidelines consist of 15 pages. DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER. QUESTION 1 File name: 1Mahal Total Q1: 27 Maximum Candidate No Criteria Mark Mark 1.1.1 Text outline 3 • Any red text outline set  1 • Width: 1.5 pt  1 • Applied to 'A Marvel'  1 1.1.2 Picture scale 2 • Height set to 60%  (4.73 cm OR 4.74 cm) 1 • Width set to 40%  (6.23 cm) 1 1.1.3 Vertical page alignment: First page 1 • Vertical page alignment set to centre  1 1.2 Table of contents (below heading 'Table of Contents') 1 • Any automatic table of contents inserted  (ignore if the 1 text 'Contents' OR 'Table of Contents' appear twice) 1.3 Style modified: Heading 1 4 • Any bullet added to heading  1 • Correct bullet   1 • Bullet indent set at 0  (mark from Reveal Formatting) 1 • All occurrences of 'Heading 1' style updated  1 (7 occurrences) 1.4 Drop cap 2 • Dropped cap option applied to 'W' of 'What'  1 • Appears over 4 lines  (allocate second mark if appears 1 as example) 1.5 Hyperlink ('Agra') 1 • Hyperlink links to 1Town OR 1town file  1 1.6 Footnote text 1 • Text 'Indian poet' added to original footnote  (do not 1 allocate mark if * symbol was changed) 1.7 Pagination options ('Over 20 000 people …') 1 • 'Keep lines together' checked  1 DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER 1.8 Index subentry ('Taj Mahal Garden') 2 • Subentry added to 'Paradise Garden'  (2 entries appear 1 if Show/Hide is switched on {XE "Paradise Garden: Multiples of 4"}{XE "Paradise Garden Timurid Style"}) • 'Multiples of 4' added as text to subentry  1 1.9 Shape and textbox ('Photos of Taj Mahal') 5 • Left arrow shape added  1 • Fill of shape removed/white  1 • Text 'Splendid workmanship' added  1 • Outline of textbox removed/wrapping applied  1 • Shape and textbox/text appear similar to the screenshot  1 1.10 Hidden text (font effect) 1 • Text 'Adapted from https://www.holidify.com/' hidden  1 (at the end of the document) (switch on Show/Hide setting to mark) 1.11 Page footer 3 • Section break/Next Page (break) added on the second last page  1 • Text 'Taj Mahal' appears in footer  1 • Text appears only on last page  1 Total for QUESTION 1 [27] DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER This page is empty to facilitate accurate marking for side-by-side booklet printout. DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 2 File name: 2Visit Total Q2: 23 Maximum Candidate No Criteria Mark Mark 2.1 Line spacing 1 • Line spacing set to Double OR set to 2  1 2.2 Hyphenation 1 • Automatic hyphenation applied  1 2.3 Page numbering 1 • Numbering style changed to any 'Accent Bar'  1 2.4 Cross-reference 2 • Cross reference replace text 'crowds'  (Alt+F9 1 {REF_ Ref……… \h}) • Moves to heading 'Tourist influx at Taj Mahal'  1 2.5 Source – Corporate author ('Visit Wonderful India') 2 • 'India Tourism' added to source  (anywhere) 1 • As 'Corporate author'  1 2.6 Edit citation 1 • Citation pages '43-49' inserted  (pp. 43-49) 1 2.7 Table 4 • First row merged  1 • Fitted across page  (preferred width 100%) 1 • Any outside border added  1 • Outside thick-thin border added  1 2.8 Multi-level list 5 • First level number set to 1)  1 • Second number set to a)  1 o Alignment of second level set to 0.7 cm  1 o Text indent of second level set to 1.5 cm  1 • Multi-level list applied  1 2.9 Chart/Graph 4 • Any chart inserted on the last page  1 • Pie chart  inserted 1 • Data from 2Time used  1 • Chart title appears: 'Time spent at (the) Taj Mahal'  1 2.10 Page colour/background 2 • Page colour changed  (not light yellow) 1 • Picture 2Back used  (do not allocate second mark if 1 inserted as a watermark) Total for QUESTION 2 [23] DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 3 File name: 3Stats 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, cells or '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 Foreign worksheet 3.1 Cells A1:I3: 2 • Correct cells merged  (do not allocate the mark if the 1 heading was centred) • Font size changed to 26  1 3.2 Foreign tab colour: 1 • Tab colour changed to any purple colour  1 3.3 Cell B17 (Expected answer: R 9 397 276): 2 • =C17/5  1 • Rand currency/Accounting/Custom (ZAR) format applied  1 3.4 Cell C74 (Expected answer: ₹ 10 030 329 040): 1 =SUM(C9,C15,C33,C42,C52,C63,C73) • Cell C52 included anywhere in function  1 3.5 Cell D8 (Expected answer: 1 118 983): 2 =D9-D7 OR E8-(E8*G8/100) • Correct cells used (D9,D7 OR E8,G8)  1 • Calculated correctly  1 3.6 Conditional formatting: Cells H17:H32 5 • Conditional formatting applied to cells H17:H32  1 • Formula: =H17  > G17  OR H17:H32>G17:G32 2 (ignore the position of the absolute cell reference) • Absolute cell reference applied to column only OR removed  (=$H17>$G17 OR 1 $H17:$H32>$G17:$G32 OR =H17>G17) • Cells formatted to green font  1 DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER 3.7 Cell I7: (CHECK FOR BUILDING BLOCKS) 5 =IF(E7>D7,IF(F7>E7,"Regular","Strong"),"Strong") OR =IF(D7>E7,"Strong",IF(E7>F7,"Strong","Regular")) OR =IF(D7<E7,IF(E7<F7,"Regular","Strong"),"Strong") OR =IF(D7>E7,"Strong",IF(E7<F7,"Regular","Strong")) OR =IF(G7>0,IF(H7>0,"Regular","Strong"),"Strong") OR =IF(G7<=0,"Strong",IF(H7<=0,"Strong","Regular")) OR =IF((E7-D7)<0,"Strong",IF((F7-E7)<0,"Strong", "Regular")) Accept =IF(AND(E7>D7,F7>E7),"Regular","Strong") OR =IF(AND(D7<E7,E7<F7),"Regular","Strong") OR =IF(AND(G7>0,H7>0),"Regular","Strong") OR =IFS(AND(G7>0,H7>0),"Regular",OR(G7<0, H7<0),"Strong") • Criteria 1: Check for increase from 2016 to 2017  1 • Criteria 2: Check for increase from 2017 to 2018  1 • Output 1: "Regular"  if both conditions true  2 • Output 2: "Strong" for any other combinations  1 Country worksheet 3.8 Chart/Graph 6 • 2017 series deleted  1 • Minor gridlines formatted to 60% transparency  1 • 'Series 1' changed to 2016  1 • 2018 series filled  with 3Taj image  and stacked  3 Total for QUESTION 3 [24] DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 4 File name: 4Tourists 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, cells or '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 Info worksheet 4.1 Row 6: Wrap text 1 • Column headings wrapped  1 4.2 Cell E2 (Expected answer: 21): 2 =MAX(F7:F206) OR LARGE(F7:F206,1) • MAX function OR LARGE( ,1) inserted in cell E2  1 • Range: F7:F206  1 4.3 Cell E3 (Expected answer: 193): 2 =COUNTA(J7:J206) • COUNTA function inserted in cell E3  1 • Range: J7:J206  1 4.4 Cell E4 (Expected answer: 2 971 918.00): 4 =SUMIF(K7:K206,"2",L7:L206) OR =SUMIFS(L7:L206,K7:K206,"2") • SUMIF/S function inserted in cell E4  1 • Criteria range: K7:K206  1 • Criteria: "2"  (accept without "") 1 • Sum range: L7:L206  1 4.5 Cell E5 (Expected answer: 3): 5 =COUNTIFS(D7:D206,"Spain",M7:M206,"Yes") OR =COUNTIFS(M7:M206,"Yes",D7:D2016,"Spain") • COUNTIFS function inserted in cell E5  1 • Criteria range 1: D7:D206  1 • Criteria 1: "Spain"  1 • Criteria range 2: M7:M206  1 • Criteria 2: "Yes"  1 DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER 4.6 Cell I7: 2 =HOUR(H7-G7) Accept =HOUR(H7)-HOUR(G7) • HOUR function used for both values (G7,H7)  1 • Subtracted correctly  1 4.7 Cell L7: 5 =VLOOKUP(D7,Countries!$A$3:$C$65,K7)*F7 OR =IF(K7=2,VLOOKUP(D7,Countries!$A$3:$C$65,2), VLOOKUP(D7,Countries!$A$2:$C$65,3)*F7 OR =VLOOKUP(D7,Countries!$A$3:$C$65,IF(K7=2,2,3)) *F7 • Lookup value: D7  1 • Table array: Countries!$A$3:$C$65  OR 1 Countries!$A$2:$C$65 • Absolute cell referencing  (also accept on rows) 1 • Return column: K7  (OR IF(K7=2…)) 1 • * F7  1 4.8 Cell N7: 5 =DATE(YEAR(E7),MONTH(E7)-3,DAY(E7)) OR =EDATE(E7,-3) • MONTH function  and DAY function  (allocate 2 2 marks for EDATE) • Correct cell reference on MONTH and DAY (E7)  1 • Subtract  1 • 3 months  1 Total for QUESTION 4 [26] DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 5 File name: 5Survey Total Q5: 40 Maximum Candidate No Criteria Mark Mark Table: tblInfo 5.1.1 Field: SurveyNo 1 • Primary key set on SurveyNo field  1 5.1.2 Field: Name 1 • Moved to after Surname field  1 5.1.3 Field: Code 4 Input Mask: >L0000C All caps • > 1 Compulsory letter • L 1 4 compulsory digits • 0000  1 Optional or required character or space • C  OR & 1 5.1.4 Field: DateIn 2 • Appropriate validation text inserted that refers to correct dates from 2017/12/31  to 2019/10/10  (do 2 not allocate marks if validation rule was copied) 5.1.5 Field: Days 1 • Order of fields swopped [DateOut]-[DateIn]  OR 1 Abs([DateIn]-[DateOut]) OR -([DateIn]-[DateOut]) 5.1.6 Field: WillReturn 1 • Format changed to 'True/False'  1 Form: frm5_2 5.2 • Examination number and the original data displays in 7 form header  1 • Show DatePicker set to 'Never' for DateIn  1 • Field inserted  1 o Combo box inserted  1 o Control source: TravellerType field  1 o Row source: tblOptions OR SELECT [tblOptions].[Options] FROM [tblOptions]  1 • Page header and page footer does not display  1 DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER Query: qry5_3 5.3 • EstimateAmount field inserted  1 5 • Rating criteria 5  1 • Total row switched on  1 • EstimatedAmount: Total: AVG  and format changed 1 to 'Currency'  (2 decimal places) OR 'Fixed' 1 OR 'Standard' (Note to marker: 3 records expected.) Query: qry5_4 5.4 • Criteria Code: S????0 OR S*0 5 OR Like "S*" AND Like "*0" o S 1 o * OR ????  1 o 0 1 • Criteria Reaction o <>  "Unmoved"  2 OR NOT "Unmoved" OR NOT "Unm*" OR "Amused" OR "Angry" OR "Excited" OR "Happy" OR "Sad" (if Reaction criteria are on separate lines, Code criteria should be repeated for all lines) (Note to marker: 3 records expected.) Query: qry5_5 5.5 • Displays Name, Surname and/or CodeLetter  1 7 • Gender criteria: "Female"  OR "F*" 1 • Calculated field: CodeLetter:  1 Left  ([Reaction],  1)  OR MID([Reaction],1,1) 3 Reaction field appears only in calculated field  1 (Note to marker: 100 records expected.) Report: rpt5_6 5.6 • EstimateAmount grouping removed  1 6 • Function: =Sum (  [EstimateAmount] ) in 2 TravellerType group footer  1 • Suitable label (must refer to function used)  1 • EstimateAmount field font changed to italics  1 (also accept in calculated field) Total for QUESTION 5 [40] DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 6 File name: 6_1Wonder, 6_2Tourism Total Q6: 20 • This question should be marked from the HTML code. • Numerical attribute values and single words do not need to be in inverted commas. Maximum Candidate No Criteria Mark Mark 6_1Wonder 6.1.1 Background colour 1 <body bgcolor="beige"> • Background colour set to beige  1 6.1.2 Font 2 <font size="50" face="Century">Agra</font> • Font size set to 50  1 • Font type set to 'Century'  1 6.1.3 Line break and picture 5 <br/> <img src="6City.jpg" height="350" width="600"/> • Line break/Paragraph tags added before the picture  1 • <img src> tags inserted  1 • 6City.jpg inserted  1 • Height set to 350  1 • Width set to 600  1 6.1.4 Ordered list 1 <ol> <li>…</li> <li>...</li> <li>…</li> <li>...</li> </ol> • Ordered list tags added  1 DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 13 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER 6_2Tourism 6.2 <html> 10 <body> <h1><i>Foreign Taj Mahal Tourist</i></h1> <table border="3"> <tr> <th colspan="3"> 2018 Figures</th> </tr> <tr> <td>Year</td> <td>Arrival</td> <td>%</td> </tr> <tr> <td>2018</td> <td>10.04</td> <td>14.0</td> </tr> </table> <a href ="www.tajmahal.in">Click for more information: www.tajmahal.in</a> </body> </html> • Heading o Heading level 1 OR 2  OR Font size and/or bold 1 o Italics applied to heading  1 • Table o Table created  with any border  2 o Three sets of rows created  (accept two rows with 1 first row th or td) o First row <td> or <th> merged across 3 columns  1 o Three sets of columns created  1 o Table heading OR centred in first row and bold  1 • Hyperlink o Hyperlink created on text 'Click for more information: www.tajmahal.in'  1 o Links to 'www.tajmahal.in'  (mark from code) 1 Closing tag(s), triangular brackets and nesting 1 correctly used 1 Total for QUESTION 6 [20] DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 14 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 7 File names: 7Protect, 7Calculations, 7Numbers Total Q7: 20 Maximum Candidate No Criteria Mark Mark 7Protect 7.1.1 Caption 2 • Automatic caption inserted  1 • Caption text 'Unobstructed view of Taj Mahal'  1 (ignore if original text still appears) 7.1.2 Reviewing 2 • At least one change accepted  1 • Only changes made by author ABC accepted  1 ((ASI) inserted, fourth paragraph removed. DEF left unchanged OR rejected (1,000 has a comma).) 7Calculations 7.2.1 Cell B2: (CHECK FOR BUILDING BLOCKS) 7 =IF(FIND("#",A2)<>LEN(A2),"More","One") OR =IF(FIND("#",A2)=LEN(A2),"One","More") OR =IF(LEN(A2)>FIND("#",A2),"More","One") OR =IF(FIND("#",A2)<LEN(A2),"More","One") OR =IF(MID(A2,FIND("#",A2)+1,LEN(A2)- FIND("#",A2))="","One","More") OR =IF(LEN(MID(A2,FIND("#",A2)+1,LEN(A2)- FIND("#",A2)))>0,"More","One") OR =IF(LEN(RIGHT(A2,LEN(A2)-FIND("#",A2)))>0, "More","One") OR =IF(FIND("#",A2)<LEN(A2),"More","One") OR =IF(MID(A2,FIND("#",A2)+1,LEN(A2))="","One","More") OR =IF(LEN(MID(A2,FIND("#",A2)+1,LEN(A2)))>0,"More", "One") • Determine position of the first # character o Find  # character  2 o In correct cell  (cell A2) 1 • Determine if there is text after the # character o Search for any characters after first # character (Len(A2)) OR Extract remaining characters OR Find second # character  o Test  (IF and correct logical operator) 1 • Output in correct cell 1 o 'One' displays if only one word  o 'More' displays if more than one word  1 1 DBE Stamp Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 15 DBE/November 2019 NSC – Marking Guidelines EXAMINATION NUMBER 7.2.2 Subtotal feature (Mark by inspection) 3 • Change added to: Traveller Type_Reisigertipe  1 • Entries counted  (SUBTOTAL(3,…)) 1 • Subtotal added to: Gender_Geslag  1 7Numbers 7.3 Importing data from HTML file (table In OR tblOut) 6 • New table created named 'In'  1 • Correct data  (7Half) 1 • Appears in database  (6 records) 1 • Field names correct  (Month, 2016, 2017, 2018) 1 • No primary key created  1 • Month field size changed to acceptable size  (8–50) 1 Total for QUESTION 7 [20] TOTAL 180 DBE Stamp Copyright reserved

Study this subject

More from Grade 12 Computer Applications Technology

View all