Skip to content

Computer Applications Technology Grade 12 P1 2017 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 12201714 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC Supplementary Exam 2017 (English), 14 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 FEBRUARY/MARCH 2017 MEMORANDUM/MARKING GUIDELINES MARKS: 180 CENTRE FINAL MARK NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 37 17 38 17 37 19 15 180 MARKER SM CM IM/EM This memorandum/marking guideline consists of 14 pages. Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE AN IMPACT ON THE ANSWER. QUESTION 1 File name: 1Areas Total Q1: 37 Maximum Candidate No Criteria Mark Mark 1.1.1 Abstract 1 • Language set to ONLY English (South Africa)  1 1.1.2 Abstract alignment 1 • Text of abstract justified  1 1.2 Image 2 • Image cropped to any shape  1 • Sharpness set to 50% or any other % besides 0%  1 1.3 Subtitle text control 1 • Content control (not text) removed  1 1.4 Table of contents 4 • Table of contents inserted  with 'Classic' style 1 • 'Water' style used as first heading style/level  1 • 'Heading 1' style used as second heading style/level  1 (Alt F9: {TOC \h \z \t "Heading 1,2,Water,1"}) • Page numbers have solid leaders  1 1.5 Page numbers 5 • Automatic page numbering inserted in the footer  1 • Formatted as 'Page 1' OR 'page 1' style  1 • Numbering starts as 1 on the 'Contents' page  1 • Odd page numbers aligned on the left  1 • Even page numbers aligned on the right  1 (Notes to marker: • Accept if odd and even was swopped. • Award the fourth mark if 'Different odd and even' was checked, even if no numbers were inserted.) 1.6 Dropped cap 2 • Dropped cap applied on 'Our' (any number of lines)  1 • Spacing set to 0.5 cm from the text  1 1.7 Cross-reference 2 • Cross-reference added on text 'table 1'  (Ref475517156) 1 • Links to table  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER 1.8.1 Table style (Water Source Area Table) 1 • Any predefined style applied  1 1.8.2 Table heading 1 • 'Repeat Header Rows' checked for first row  1 1.8.3 Footnote 3 • Footnote inserted on text 'Grootwinterhoek'  (check 1 'Grootwinterhoek' text on other pages) • Reads as 'Strategic water sources'  (accept any text) 1 • '*' used as symbol  1 1.9 Caption (WESTERN CAPE WATER SOURCE AREAS) 2 • Any automatic caption added to image  1 • Label reads as 'Image 1' (or 'image1')  1 1.10 Bullets 1 • Bullets below 'Boland Mountains' changed to Wingdings character number 165 ()  1 1.11 WordArt 2 • WordArt applied to 'Did you know?'  1 • Text wrapping set to 'Top and Bottom'  1 1.12 Chart/Graph (MPUMALANGA DRAKENSBERG) 2 • Any data of chart/graph changed  1 • Two changes correctly made to any graph (Cultivated 2%, Natural 48%)  1 1.13 Citation 3 • Any automatic citation inserted  1 • Report source created  1 • Correct fields: Title: The effects of water, Year: 2015 1 entered (accept if only one field was entered)  1.14 Table of figures 2 • Table of figures added to show images  1 • Table of figures displaying tables has not been deleted  1 (award only if attempt was made for first bullet) 1.15 Page layout 2 • Last page changed to portrait  1 • Other pages remain in landscape  (award only if attempt 1 was made for first bullet) Total for QUESTION 1 [37] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER QUESTION 2 File names: 2Water, 2Done Total Q2: 17 Maximum Candidate No Criteria Mark Mark 2.1 Date field 2 • Any date added  1 • Field will automatically update  1 2.2 Textbox fill 2 • Second text box filled with 2Drops image  1 • All/some text bolded in any text box  1 2.3 Drop-down field: Gender 1 • 'Femail' spelling changed to 'Female'  1 2.4 Check box: 'Older than 60' 1 • Any check box inserted  to the left of text (or in any 1 other position) 2.5 Text form field: 'Number of adults …' 1 • Type changed to 'Number'  1 2.6 Number form field: 'How much do you pay …' 1 • Number format changed to value with 'R' currency format  1 2.7 Tabs 4 • Leader tabs/tab set to approximately 6 cm, 10 cm and 15 cm  1 • Left tabs used in all cases  1 • Tab leaders added in two cases (6 cm and 15 cm)  1 • All tabs correctly applied  1 2.8 Mail merge 5 • Data source 2Det_Bes used  1 • Any sorting done  1 in ascending order  1 • Name and Surname fields inserted  1 • Merge completed  (2Done) 1 (Note to marker: 29 or 30 letters expected.) Total for QUESTION 2 [17] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER QUESTION 3 File name: 3Rain_Reën Total Q3: 38 • 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 Rain_Reën worksheet 3.1.1 Row 1: 1 • Merged cell changed to A1:O1  1 3.1.2 Row 1 fill: 2 • Any fill effect applied  1 • Thin diagonal stripe pattern style fill effect applied  1 (accept any diagonal stripes) 3.2 Freeze panes: 2 • Freeze panes effect applied  1 • Correct columns and rows (rows 1 and 2, columns A and B)  1 3.3 Cell D3: 1 • =VALUE(C3)  1 (Note to marker: After sorting =VALUE(C6).) 3.4 Cell G48: 2 • =MODE  (G3:G46)  2 3.5 Cell H49: 3 =ROUNDUP(AVERAGE(H3:H46),0) OR =CEILING(AVERAGE(H3:H46),1) OR =ROUND(AVERAGE(H3:H46)+0.5,0) • AVERAGE(H3:H46)  1 • ROUNDUP/CEILING/INT  1 • ,0 for ROUND/ROUNDUP and ,1 for CEILING  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER 3.6 Cell K50: 2 =LARGE(K3:K46,3) • LARGE function  1 • Correct range and parameters (K3:K46,3)  1 3.7 Cell M51: 4 =SUMIF(B3:B46,"2015",M3:M46) • SUMIF function  1 • Criteria range: (B3:B46)  1 • Criteria: "2015"  1 • Sum range: (M3:M46)  1 3.8 Conditional formatting Column D to Column O: 5 • Conditional formatting has been applied to cells D3:O46  1 • 3 different colours applied (any colours)  1 • Lowest point set to 0  1 • Midpoint set to 100  1 • Highest point is set to 630  1 (Note to marker: No marks awarded if conditional formatting has not been applied.) 3.9 Cell R4: 6 =IF(SUM(D24:O24)>650,"High","Low") OR =IF(SUM(D24:O24)<=650,"Low","High") • IF-syntax is correctly used  1 Conditions: • Sum  of Cape Town 2015  (or any other range) 2 • Smaller than or equal to 650 (or greater than)  1 • Value "Low" if less than or equal to 650  1 • Else value "High" if greater than 650  1 (Notes to marker: • Accept building blocks. • There are many alternative answers. Evaluate the candidates answer against the bulleted options. • Accept D44:O44.) 3.10 Sorting: 2 • First sorted by year – smallest to largest  1 • Second sorted by city – A to Z  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER Durban worksheet 3.11 Cell C6: 2 =SUBTOTAL($A$6,C10:C53) OR =SUBTOTAL($A$6,C9:C53) • Cell range C10:C53  1 • Absolute cell reference  1 3.12 Filter: 1 • Filter set on Durban  1 Bloemfontein worksheet 3.13 Graph 5 • Area chart/graph displays rainfall per month per year for Bloemfontein (range B1:O12)  1 • Suitable chart title inserted  1 • Any legend inserted  below 1 • Horizontal axis options display years  1 • Data labels inserted for 'Total' series  1 Total for QUESTION 3 [38] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER QUESTION 4 File name: 4Game_Speel Total Q4: 17 • 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 Scores_Punte worksheet 4.1 Hyperlink: 1 • Hyperlink removed from heading 'Water Games'  1 4.2 Cell E3: 3 =(TODAY()-D3)/7 OR =(NOW()-D3)/7 OR =DAYS(NOW(),D3)/7 OR =DAYS(TODAY(),D3)/7 • TODAY() function  1 • -D3  1 • /7  1 (Notes to marker: • Accept if the current date was entered in a cell and the cell reference was used. • If the DAYS function was used allocate one mark for the function and one mark each for the correct parameters.) 4.3 Data validation: 2 • 'Black' removed from the list  1 • Applied to the whole column G  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER 4.4 Cell I3: 7 =LEFT(C3,2)&" "&RANDBETWEEN(0,99)&LOWER(F3) OR =CONCATENATE(LEFT(C3,2)," ",RANDBETWEEN(0,9 9), LOWER(F3)) OR = MID(C3,1,2)&" "&RANDBETWEEN(0,99)& LOWER(F3) • LEFT (or MID) function  1 • Cell reference and number of characters (C3,2)  1 • Space  1 • RANDBETWEEN function  1 • Parameters (0,99)  1 • LOWER function and cell reference F3  1 • CONCATENATE OR & operators correctly used  1 4.5 Cell J3: 4 =HLOOKUP(H3,Awards_Toekennings!$A$1:$E$3,2) • HLOOKUP function  1 • Lookup value: H3  1 • Lookup range: Awards!$A$1:$E$3  (ignore if no 1 absolute cell reference, accept B1:E3) • Row number: 2  1 (Note to marker: If the candidate changed the orientation of the Awards_Toekennings worksheet, VLOOKUP may be used.) Total for QUESTION 4 [17] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER QUESTION 5 File name: 5Dam Total Q5: 37 Maximum Candidate No Criteria Mark Mark Table: Dam 5.1.1 Field: Name or Location 1 • Set as primary key  1 5.1.2 Field: Town 1 • > inserted in Format field property  1 5.1.3 Field: Province 2 • Combo box created  1 • Row source: Province  1 5.1.4 Field: Completed 5 Input Mask: 00/>LLL/0000 • Two compulsory digits: 00  1 • Uppercase: >  1 • Three compulsory letters: LLL  1 • Four compulsory digits: 0000  1 • Divider: / (accept '-' due to computer settings)  1 5.1.5 Field: Capacity 1 • Validation Rule >=0 OR NOT <0  1 5.1.6 Field: Illustration 2 • Data type changed to OLE Object/ Hyperlink  1 • 5AlbertFalls image inserted for the 'Albert Falls Dam' record  1 (Note to marker: Check on Hyperlink when file is transferred to another computer.) Query: qry5_2 5.2 • Town field inserted  1 2 • Criteria in Province field: Limpopo  1 (Note to marker: 15 records expected.) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER Query: qry5_3 5.3 • Fields displayed: Province, Avg Of Capacity OR 5 Capacity  1 • Criteria on Province: "Free State"  1 OR "North West"  1 • AVG  (ignore whether rounded or not) 1 • Calculated on Capacity field  1 (Note to marker: 2 records expected.) Query: qry5_4 5.4 • Only Name and Town fields display  1 4 • Criteria on Surface: IS NOT NULL OR "Like *" OR "True"  1 • Criteria on Completed: Between #01/01/1990#  AND #31/12/2000#  2 OR >=#1/1/1990# AND <=#12/31/2000# (Notes to marker: • 11 records expected. • Format of the dates may differ depending on system dates.) Query: qry5_5 5.5 • Calculated field called Volume has been created  1 4 • Calculation: [Surface]*[Height]*0.3  1 • Format changed to Fixed/Standard  and one 1 decimal place  1 Form: frm5_6 5.6 • 5AlbertFalls image added  as form background 1 5 image  1 • Hyperlink inserted  next to Province label 1 • Links to the Province table NOT database  1 • Examination number displays in the form footer  1 Report: rpt5_7 5.7 • Illustration label AND field removed  1 5 • Report grouped according to Province  1 • Report sorted by Town  1 • Function in Province report footer/report header  1 =MAX([Capacity])  1 Total for QUESTION 5 [37] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER QUESTION 6 File name: 6Wise_Wys 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 inserted inside title tags  1 6.2 Table cell and image 3 <td><img src="6Life.jpg"></td> • Additional cell inserted anywhere  1 • 6Life.jpg image inserted  1 • Image tags correctly inserted  1 6.3 Horizontal line 2 <hr size="5"> • Horizontal line inserted  1 • Size set to 5  1 6.4 Alignment and font 2 <h2 align="center"><font face="Arial">Are you water wise?</font></h2> • Alignment set to centre  1 • Font changed to 'Arial'  1 6.5 Table border 2 <table border="1" cellpadding="12"> • Border set to 1  1 • Cellpadding set to 12  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 13 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER 6.6 Table columns 3 <td colspan="2"> <font size="3"> <i>The kitchen … Here are some suggestions:</i> </font> </td> • One table cell appears  1 • Closing tags for first cell and opening tags for second cell removed  1 • Column span set to 2  1 6.7 Alternative text 1 <tr> <th><img src="6House.jpg" alt = "Inside">Inside the house</th> • Alternative text 'Inside' added  on 6House image 1 6.8 Unordered list 2 <ul type="circle"> <li>Avoid ….</li> <li>Run ....</li> <li>Keep ....</li> <li>Check your ...</li> <li>Install ...</li> <li>Take ...</li> <li>When ...</li> <li>Turn ....</li> </ul> • Type set to circle  1 • All list items have opening and closing tags  1 6.9 Link 3 <a href=mailto:"waterwize@water.co.za"> waterwize.co.za</a> • Link created on the text 'waterwize.co.za' (accept any text)  1 • Links to an e-mail address – Mailto:  1 • E-mail address 'waterwize@water.co.za'  1 Closing tag(s) or triangular brackets omitted or more than one closing tag in the incorrect order -1 Total for QUESTION 6 [19] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 14 DBE/Feb.–Mar. 2017 NSC – Memorandum/Marking Guidelines EXAMINATION NUMBER QUESTION 7 Total Q7: 15 File names: 7River_Rivier, 7Rivers_Riviere, 7Answ_Antw Maximum Candidate No Criteria Mark Mark 7Rivers_Riviere worksheet 7.1.1 Header 3 • Worksheet name added  1 • As field  1 • In the left section of the header  1 7.1.2 Named range 1 • Named range changed to 'Name_River'  1 (Note to marker: Accept if a new named range 'Name_River' was inserted.) 7.1.3 Protection 2 • Columns A to C locked  1 • Password 123 used  1 7River_Rivier database 7.2 Import table 2 • Data from the 7Rivers_Riviere spreadsheet imported in 7River_Rivier database  1 • Saved as a new database table called Rivers  1 7Answ_Antw 7.3.1 Gutter position of the document 1 • Top  1 7.3.2 Number of paragraphs in the document 1 • 83  1 7.3.3 Number of occurrences of the letter 'm' in the document 1 • 185  1 7.3.4 First word that appears on line 100 1 • rates OR crop  1 7.3.5 Line weight of the 'Intense Quote' style 1 • 0.5 OR (½)  1 7.3.6 Word marked as an index 1 • SHARPS  1 7.3.7 Title of the citation source that appears in the document 1 • Water Savers  1 Total for QUESTION 7 [15] TOTAL 180 Copyright reserved

Study this subject

More from Grade 12 Computer Applications Technology

View all