Skip to content

Computer Applications Technology Grade 12 P1 2015 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 12201513 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC November Exam 2015 (English), 13 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 2015 (2) MEMORANDUM/MARKING GUIDELINE MARKS: 180 FINAL MARK CENTRE NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 29 20 22 29 41 20 19 180 CANDIDATE MARK MARKER CODE/ SIGNATURE MODERATED MARK This memorandum/marking guideline consists of 13 pages. Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER IGNORE SPELLING IN ALL CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER. QUESTION 1 File name: 1Fynbos Total Q1: 29 Maximum Candidate No. Criteria Mark Mark 1.1 Margins 1 • Margins gutter set to left 1 cm  1 1.2 Cover page 2 • Text box filled  1 • With picture 1Title_Titel.jpg  1 (Note to marker: Ignore if the word 'Fynbos' still appears in the textbox.) 1.3 Alignment 1 • Text of first paragraph in document justified (i.e. left and right)  1 1.4 Dropped cap 3 • Dropped cap applied  1 • Over 5 lines  1 • 0.5 cm from text  1 1.5 Columns 2 • Text formatted into two columns  1 • Column break applied so that the heading 'Richness of plant life' appears at the top of the second column  1 1.6 Table 5 • Row 1 merged  1 • Small caps applied to heading in row 1  1 • Data in second column vertically centred  1 • Data in second column sorted alphabetically  1 • Outer border changed to a thicker border  1 (Notes to marker: • Award the third mark if the text is vertically and horizontally centred. • The images should match the description. If the candidate moved the text manually and the pictures are not moved accordingly, do not award the fourth mark.) 1.7 Hyperlink 2 • Hyperlink applied to text 'Threats to Fynbos'  1 • Link created to picture 1Fire_Vuur.jpg  1 1.8 Page orientation 2 • Landscape orientation applied to selected text only (section breaks included)  1 • All other pages are portrait  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER 1.9 Multilevel list 3 • Multi-level numbering applied  1 • First level numbering applied correctly (A..G)  1 • Second level numbering applied correctly (i..vi)  1 (Note to marker: Accept numbering in uppercase or lowercase.) 1.10 Comment 1 • Comment deleted  1 1.11 Endnote 3 • Endnote applied to heading 'Acknowledgements'  1 • Text added for endnote  1 • Letter 'A' used as custom mark  1 (Notes to marker: • Allocate second mark if all or some text has been added to the endnote. • Ignore if original text still appears.) 1.12 Automatic bibliography 1 • Automatic bibliography added  1 1.13 Watermark 3 • Watermark inserted  1 • Picture 1Wash_Was.gif used  1 • Only appears on last page  1 (Note to marker: Allocate the last mark if the watermark appears on the last page and not on the second last page, even if it appears on the other pages of the document.) Total for QUESTION 1 [29] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 2 File names: 2Entry_Inskryw Total Q2: 20 Maximum Candidate No. Criteria Mark Mark 2.1 Formatting 3 • Heading formatted to italics  1 • Appears over two lines  1 • Text underlined  1 (Note to marker: Accept any method of manipulating the heading to appear over two lines.) 2.2 Logo 4 • Logo 2Sanbi.png added  1 • Logo formatted to appear on right of text  1 • Width set to 8.1 cm  1 • Height set to 3.6 cm  1 2.3 Styles 1 • Heading 'Personal Details' formatted with 'Heading' style  1 2.4.1 Form controls 4 • First tab stop set to 1 cm  1 • Second tab stop set to 11 cm  1 • Tab stop positions applied to one  1 • Tab stop positions applied to all  1 2.4.2 Drop-down form field control 2 • Male option added  1 • Female option added  1 2.4.3 ID number control 2 • Text form field control added  1 • Maximum length set to 13  1 2.4.4 Date of birth date control 2 • Type set to Date  1 • Format set to yyyy/MM/dd  1 2.4.5 Check box control 1 • Check box control inserted next to 'Wednesday'  1 2.5 Subject property 1 • Text 'Entry form' added as subject to the properties  1 Total for QUESTION 2 [20] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 3 File name: 3Plant Total Q3: 22 • 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 answers. • Named ranges can be used instead of cell references. Maximum Candidate No. Criteria Mark Mark Plants_Plante worksheet 3.1 Row 1: 1 • Row height changed to 40 pt  1 3.2 Cell A1: 3 • Heading or part of heading 'List of Plants' added  1 • 'Aharoni' font applied  1 • Any pattern style applied to cell  1 3.3 Freeze Panes: 2 • Freeze panes applied  1 • Correct position: row 3  1 3.4 Row 2: 1 • Text wrapping applied  1 3.5 Border: 1 • Any orange border applied around cells A2:E79  1 3.6 Cell E3: 5 =COUNTIF(B3:B79, "*Sugarbush*") OR = COUNTIF(B:B, "*Sugarbush*") • COUNTIF function used  1 • Range: B3:B79  1 • Criteria: *  "Sugarbush"  *  3 (Note to marker: Expected answer is 26.) Summary worksheet 3.7 Bar chart/graph: 9 • Chart/graph created  1 • Bar chart/graph type  1 • Correct data series: A2:C5  1 • Data row/column switched  1 • Data labels on horizontal axis to show years  1 • Heading 'Species per year'  1 • Legend appears at the bottom  1 • Axis intervals changed to units of 15  1 • Data labels inserted  1 Total for QUESTION 3 [22] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 4 File names: 4StatsData Total Q4: 29 • 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. Maximum Candidate No. Criteria Mark Mark Stats worksheet 4.1.1 Cells A1:J1: 2 • Cells centred  1 • Cells merged  1 4.1.2 Text direction: 2 • Text rotated  1 • Only row 2  1 (Note to marker: Rotation must ensure that the text is clearly visible and reads correctly.) 4.2 Cell C3: 2 =AVERAGE(B3:B159) OR =AVERAGE(B:B) • AVERAGE function  1 • Range: B3:B159  1 (Note to marker: Expected answer is 143705.) 4.3 Conditional formatting: Column E 4 • Criteria >0  – font colour set to blue  2 • Criteria <0 – font colour set to red  2 (Note to marker: If a candidate includes zero in the criteria, penalise only once in any one of the criteria.) 4.4 Cell F3: 6 =HLOOKUP(G3,Code_Kode!$A$1:$D$2,2,FALSE) • HLOOKUP function used  1 • Lookup value: G3  1 • Lookup range: Code_Kode!$A$1:$D$2  1 • Column reference: 2  1 • Lookup range: False OR no False if lookup table has been sorted  1 • Absolute cell referencing  1 (Notes to marker: • Accept a VLOOKUP if candidates transposed/swopped the table in worksheet Code_Kode. • =VLOOKUP(G3:G159,Code_Kode!$A$1:$B$4,2, FALSE).) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER 4.5 Cell H3: 6 =IF(D3>30,"Well",IF(D3>25,"Moderate","Poor")) OR =IF(D3>=31,"Well",IF(D3>=26,"Moderate","Poor")) OR =IF(D3>30,"Well",IF(AND(D3>25,D3<=30),"Moderate", "Poor")) OR =IF(D3<=25,"Poor",IF(AND(D3>25,D3<=30),"Moderate ","Well")) OR =IF(D3<=25,"Poor",IF(D3<=30,"Moderate","Well")) OR =IF(D3>30,"Well",IF(D3<=25,"Poor","Moderate")) • Nested IF function  1 • Syntax of IF statement is correct  1 • 'Well' correctly displayed for conservation target greater than 30  1 • 'Moderate' correctly displayed for conservation target greater than 25  1 • 'Poor' correctly displayed for conservation target equal to and lower than 25  1 • Function copied to cells below  1 (Note to marker: Check for correct use of conditional options. There are many alternative answers, one of which could be a VLOOKUP.) 4.6 Cell I4: 7 =CONCATENATE(LEFT(A4,3),LEN(A4),F4) OR =LEFT(A4,3)&LEN(A4)&F4 • & operators OR CONCATENATE function used correctly  1 • LEFT function used  to extract the first three letters 1  from cell A4  2 • LEN  (A4)  2 • F4  1 (Note to marker: Expected answer is Agu24LT.) Total for QUESTION 4 [29] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 5 File name: 5CFKData Total Q5: 41 Maximum Candidate No. Criteria Mark Mark Table: Plant 5.1.1 Field: FamilyCommon 1 • Field size is 50  1 5.1.2 Field: EndemicSpecies 2 • Required property set to Yes  1 • Format of field set to 'Fixed' format  1 5.1.3 Field: Listing 2 • Combo box/List box applied to field  1 • Options added ('Endangered' and 'Threatened')  1 (Note to marker: Accept if only one option is added.) 5.1.4 Field: PlantCode 5 Input Mask: >LAAa • >  (enforce capital letters) 1 • L  (compulsory letter) 1 • AA  (two compulsory letters or digits) 2 • a  (optional letter or number) 1 5.1.5 Field: PlantCode 1 • Primary key set on PlantCode field  1 Form: frm5_2 5.2 • Form frm5_2 created based on Plant table  1 10 • Columnar layout selected  1 • Selected fields: FamilyCommon, FamilyBot, TotalSpecies and EndemicSpecies  1 • Font size of heading is 36  1 • Heading 'Plant' centred  1 • 5Erica.jpg picture inserted  in form header  2 • Background colour of form header changed to yellow  1 • Button inserted  1 • The next record is shown when the button is clicked  1 (Notes to marker: • Ignore if full heading is not visible. • Accept if heading centred across page or inside label. • Also accept 'Find Next' as action of the button.) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER Query: qry5_3 5.3 • Displays FamilyCommon and FamilyBot fields only 1 4 • EndemicSpecies field: o Show: not selected  1 o Criteria: >  1200  2 (Note to marker: Expected answer is 40 records.) Query: qry5_4 5.4 • FamilyBot field displayed in descending order  1 6 • Calculated field: Perc:  [EndemicSpecies]  /[TotalSpecies]  * 3 100  1 • FamilyBot and Perc fields display  1 (Notes to marker: • Only allocate the fifth mark if the answer is correct and the column displays the % sign. • Ignore if EndemicSpecies and TotalSpecies fields are also displayed.) Report: rpt5_5 5.5 • Fields included: FamilyCommon, FamilyBot, 10 EndemicSpecies and Genus  1 • Landscape orientation  1 • Grouped according to EndemicSpecies  1 • Calculation in report header or report footer  1 • Calculation: =Round (Avg ([EndemicSpecies]), 1)  4 • Appropriate label included  1 • All data displays fully  1 (Note to marker: Accept formatting to one decimal place instead of ROUND.) Total for QUESTION 5 [41] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 6 File name: 6Home, 6Flower, 6Ref Total Q6: 20 • This question should be marked from the browser as far as possible, unless otherwise indicated or if it cannot be seen on the browser. • A maximum of 1 mark will be deducted if one or more closing tags are omitted. • The code of the candidates who use a word processor will contain additional unnecessary tags. Markers will need to work through the code to check for the answers provided below. Maximum Candidate No. Criteria Mark Mark 6.1 Comment 1 <!--Examination number--> • Examination number added as an additional comment  1 6.2 Title 1 <title>Fynbos</title> • Title tags correctly added  1 6.3 Italics and font colour 2 <h1><font color="red"><i>Fynbos Information</i> </font></h1> • Font colour appears as red  1 • Heading 'Fynbos Information' appears in italics  1 6.4 Bulleted list 1 <ol> <li>Erica</li> <li>Protea</li> </ol> OR <ol type ="1"> <li>Erica</li> <li>Protea</li> </ol> • Unordered list changed to ordered list  1 6.5 Horizontal line 2 <hr width="50%"/> • Horizontal line added  1 • Width = "50%"  1 (Note to marker: Ignore position.) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER 6.6 Image 6 <img src="6Flower.jpg" height="191" width="181" alt="Nevillea"> • Image tags inserted correctly  1 • Correct source file 6Flower.jpg used  1 • Height set to 191  1 • Width set to 181  1 • Alternative text included  1 • Alternative text reads as 'Nevillea'  1 6.7 Bold 1 <b>Erica</b> • Text 'Erica' appears in bold  1 6.8 Link 3 <a href="6Ref.docx">Website References</a> • Link created  1 • On text 'Website References'  1 • Links to 6Ref.docx  1 6.9 Table border 3 <table border ="2" cellspacing ="1"> First <tr> after the table tag: <tr bgcolor="pink"> • Table border set to 2  1 • Cell spacing set to 1  1 • Attribute: bgcolor="any colour"  1 (Note to marker: Accept any colour for the background.) Closing tag(s) or triangular brackets omitted -1 Total for QUESTION 6 [20] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 7 File names: 7Flora, 7Answ_Antw, 7End Total Q7: 19 Maximum Candidate No. Criteria Mark Mark 7Flora 7.1 Page numbering 5 • Automatic page numbering of any format appears in 1 the footer  • No page numbering on cover page and table of 1 contents page  • Page numbering starts at 1 from the third page  1 • Even page numbers are right aligned  1 • Odd page numbers are left aligned  1 7.2.1 Table of contents 3 • Table of contents inserted  1 • Two levels of heading displayed  1 • No leader tabs included for page numbering  1 7.2.2 Table of contents 2 • Heading 2 style applied to the text 'RICHNESS OF PLANT LIFE',  1 • Displayed in table of contents  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 13 DBE/November 2015 (2) NSC – Memorandum/Marking Guideline EXAMINATION NUMBER • Accept any method that will yield the correct answer. • One mark for the answer and one mark for the method. If there is only an answer and no method, allocate only one mark if correct. 7Answ_Antw 7.3.1 How many records are in the table? 1 • 99  1 7.3.2 How many lemurs have no average size listed? 2 • 11  1 Method:  1 • Filter on blank Average size field • Switch on filter and select 'Blanks' • Sort on the Average size field and count • Create a query with a Is Null operator 7.3.3 What is the common name of the lemur that Forsyth 2 Major classified as vulnerable in 1894? • Milne-Edward's sportive lemur  1 Method:  1 • Sort or filter on Classified • Toggle filter on Conservation Status • Create a query on Classified and Conservation status with the criteria *Forsyth Major* under Classified and with the criteria 'vulnerable' under Conservation status 7.3.4 How many types of lemur families are there? 2 • 4 1 Method:  1 • Query grouped by Family-field • Filter and count filter (any method) • Scroll down and physically count the types • Duplicate Query 7.3.5 What is the average size of all the endangered species? 2 • 2 279.9  1 Method:  1 • Create a query or use filter • Filter on Conservation status: 'Endangered' • AVERAGE: Use a total function to average • Export to spreadsheet and calculate average Total for QUESTION 7 [19] TOTAL 180 Copyright reserved

Study this subject

More from Grade 12 Computer Applications Technology

View all