Skip to content

Computer Applications Technology Grade 12 P1 2016 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 12201614 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the NSC June Exam 2016 (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 SENIOR CERTIFICATE EXAMINATIONS COMPUTER APPLICATIONS TECHNOLOGY P1 2016 MEMORANDUM/MARKING GUIDELINE MARKS: 180 CENTRE FINAL MARK NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 24 26 25 25 42 19 19 180 CANDIDATE'S MARK MARKER CODE/ SIGNATURE MODERATED MARK This memorandum/marking guideline consists of 14 pages. Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 2 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER IGNORE SPELLING IN CASES WHERE IT WOULD NOT HAVE ANY IMPACT ON THE ANSWER. QUESTION 1 File name: 1Effect_Effek Total Q1: 24 Candidate No Criteria Max Mark Mark 1.1.1 First Page 3 • (Any) picture added to first page  1 • Correct picture 1Music_Musiek added  1 • Picture wrapping/alignment changed to appear at top right-hand corner of page  1 1.1.2 First Page 2 • Text box added (anywhere) to the first page  1 • 'Elvis High School' added as text to the text box  1 1.2 Styles 3 • New style 'Music' created  1 • Font size formatted to 48 pt  1 • Text centred  1 1.3 Page Border 2 • Any page border added  1 • First page only  1 1.4 Watermark 2 • Watermark text: 'First Draft' added  1 • Watermark text added only to first page  1 (Note to marker: Do not accept if 'Different First Page' has been selected and watermark has not been deleted from second page.) 1.5 Comment 1 • Comment deleted  1 1.6 Text Effect 2 • Font colour orange  gradient text fill effect  applied 2 to heading 'The Effect Music Has On Me' (Notes to marker: • Allocate first mark if font colour was changed. • Mark from dialogue box.) 1.7 Dropped Cap 3 • Dropped cap effect applied to the 'M' of 'Music'  1 • Over 2 lines  1 • 0.6 cm/16 pt away from text  1 1.8 Line Spacing 1 • Second paragraph line spacing set to 'Multiple 1.15'  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 3 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER 1.9 Endnote 3 • Endnote inserted  on text 'Rap and Rock' 1 • Appears in capital Roman number format 'I'  1 • Text entered in endnote  ('Adapted from an article by 1 S Mariam') 1.10 Find and Replace 2 • 2 occurrences  of manual line break (soft enter) 1 • Replaced with hard enters/paragraph marks  1 (Note to marker: Located at the end of the second and third paragraphs under the heading 'The Effect Music Has On Me'.) Total for QUESTION 1 [24] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 4 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 2 File name: 2Facts_Feite Total Q2: 26 Candidate No Criteria Max Mark Mark 2.1 Page numbering 5 • Page numbering (any style) inserted in the footer  1 • Automatic page numbering inserted (as a field)  1 • Page numbers are centred  1 • First page is not numbered  1 • Numbering starts as page 1 on the second page (after the table of contents page)  1 (Note to marker: Ignore if the numbering on the landscape pages from Question 2.6 onwards differs.) 2.2 Table of Contents 4 • Automatic table of contents inserted  1 • Fancy style used (Small caps)  1 • Two levels of headings appear  1 • Solid line leader tab appears for page numbers  1 (Note to marker: Ignore if ToC appears twice.) 2.3 Styles and Table of Contents 2 • 'Heading 1' style applied to the heading  1 • Table of contents reflects new entry (any style)  1 2.4 Citations 3 • New interview source added  1 • 'Steve Johnson' inserted  as interviewee 1 • Text 'Placeholder1' replaced with automatic citation  1 2.5 Columns 4 • Text appears in 3 columns  1 • Spacing between columns is set at 1.1 cm  1 • Column break  applied to each sub-heading 1 • Text justified  1 (Note to marker: Award third mark for any column break.) 2.6 Page Orientation 2 • Page containing text in landscape orientation  1 • All other pages remain portrait orientation  1 2.7 Numbered and Bulleted List 5 • Level 1 numbering set to 1. 2. 3.  1 • Level 1 numbering aligned to 1 cm  1 • Level 1 text relatively aligned/indented to 2 cm  1 • Level 2 set to   1 • Level 2 bullet relatively aligned/indented to 2 cm  1 (Note to marker: Ignore if 1., 1 or 1) and type of  bullet.) 2.8 Table 1 • Function inserted =AVERAGE(Above)  1 Total for QUESTION 2 [26] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 5 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 3 File name: 3Learners_Leerders Total Q3: 25 • Mark the questions from the formulae and not the values/answers in the cell. • Check against candidates' actual work (Cell references may differ, depending on the candidates' response). • Candidates may use multiple formulae or cells as 'building blocks' to answers. • Named ranges can be used instead of cell references. Candidate No Criteria Max Mark Mark Member_Lid worksheet 3.1 Range A1:M1: 1 • Merge and centre  applied to text in range A1:M1 1 3.2 Cell G2: 1 • =TODAY()  OR NOW() 1 3.3 Cell B3: 2 =COUNTA(B5:B103) OR =COUNTIF(B5:B103,"*") • COUNTA/COUNTIF function  1 • Range: (B5:B103) 1 (Note to marker: Accept COUNTA function on columns C, D, E, F, G, I or L OR COUNT function on columns D, E, F, G or I.) 3.4 Cell A5: 2 =UPPER(B5) • UPPER function  1 • Cell (B5)  1 3.5 Print setting: 2 • Print area set  to range B4:D103 1 • Print gridlines set to show  1 (Notes to marker: • Accept if column A has been included. • Accept if 'Headings – Print' were selected in 'Sheet Options' and range is B5:D103.) 3.6 Column G: 1 • Format changed to yyyy-mm-dd  1 (Note to marker: Accept if just cell G5 formatted.) 3.7 Cell H5: 3 =CONCATENATE("011",I5) OR ="011"& I5 • CONCATENATE function OR &  1 • "011"  1 • I5  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 6 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER 3.8 Cell K5: 4 =IF(J5="","Yes","No") OR =IF(ISBLANK(J5),"Yes","No") OR =IF(J5<>"","No","Yes") OR =IF(COUNTA(J5)=0,"Yes","No") OR =IF(LEN(J5)=0,"Yes","No") • Testing if J5 is "blank"  1 • If cellphone is not available: "Yes"  1 • If cellphone is available: "No"  1 • Function copied to cells K6:K103  1 (Note to marker: Accept any suitable variations and if "Y" and "N" used instead of "Yes" or "No".) 3.9 Cell M5: 7 =MID(L5,FIND("@",L5,1)+1,LEN(L5)) OR =RIGHT(L5,LEN(L5)-FIND("@",L5)) • To determine the position of the '@': o FIND function  1 o '@' character  1 o In the correct cell: L5  1 • Extracting the domain: o Function to extract (MID or RIGHT)  1 o Correct cell used to extract from: L5  1 o From after the position of the '@' sign  1 o To the end of the text/domain: LEN(L5), etc. 1 (Note to marker: Check for 'building blocks' in other columns.) Dec_Des worksheet 3.10 Extract and copy: 2 • Two members born in the month of December  1 • Copied to the Dec_Des worksheet  1 (Notes to marker: • 2 members expected (Killian R and Hassim T). • Accept if not all the information was copied.) Total for QUESTION 3 [25] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 7 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 4 File name: 4Club_Klub Total Q4: 25 • Mark the questions from the formulae and not the values/answers in the cell. • Check against candidates' actual work (Cell references may differ, depending on the candidates' response). • Candidates may use multiple formulae or cells as 'building blocks' to answers. • Named ranges can be used instead of cell references. Candidate No Criteria Max Mark Mark Music_Musiek worksheet 4.1 Column B: 1 • All data is visible in column B  1 4.2 Column G: 1 • Data in column G formatted to 2 decimal places  1 (Note to marker: Accept if only part of the column has been changed or if formatted as a currency format.) 4.3 Cell F2: 5 =VLOOKUP(A2,Code!$C$2:$D$4,2) • Lookup value: A2  1 • Table array: Code_Kode!C2:D4  1 • Reference column: 2  or use of LOOKUP function 1 • Absolute cell reference: Code_Kode!C$2:D$4  1 • Copied to remaining cells  1 (Notes to marker: • Ignore 'True' or 'False'. • Also accept absolute cell reference $C$2:$D$4.) 4.4 Cell H2: 4 =IF(A2=1,G2*1.2,IF(A2=2,G2*1.25,G2*1.15)) OR =IF(A2=1,G2+G2*20/100,IF(A2=2,G2+G2*25/100,G2+ G2*15/100)) OR =IF(A2=1,G2*120/100,IF(A2=2,G2*125/100, G2*115/100)) OR =IF(F2="CD",G2*120/100,IF(F2="DVD",G2*125/100, G2*115/100)) • Nested IF/Function-construct is correctly used  1 1 • Condition CD OR Code 1 and value G2*1.2  1 • Condition DVD OR Code 2 and value G2*1.25  1 • Condition MP3 OR Code 3 and value G2*1.15  (Note to marker: Accept if column F was used with 'MP3', etc. If the percentage was calculated without the increase, penalise conditions by one mark.) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 8 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER 4.5 Cell L2: 2 =COUNTIF($D$2:$D$612,K2) • Absolute cell reference D$2:D$612  1 • '1990' replaced with cell reference K2  1 (Note to marker: Accept ($D$2:$D$612) as range.) 4.6 Cell L21: 4 =SUMIF(E2:E612,"POP",G2:G612) • SUMIF function  1 • Criteria range: (E2:E612)  1 • Criteria: "POP" OR K21  1 • Sum range: (G2:G612)  1 Copy_Kopieer worksheet 4.7 Cell J2: 3 • Expected answer: 101  1 Method J3: • Removed duplicate  owners  2 --------------------------------------------------------------------------------------------------------------- OR • Sorted, deleted duplicate owners  and counted  -------------------------------------------------------------------------- OR • Sorted owners  and counted unique owners  (Notes to marker: • Accept any other correct method e.g. =SUMPRODUCT((G2:G636<>"")/COUNTIF(G2:G636, G2:G636)). • Allocate all three marks if the correct answer displays.) Graph_Grafiek worksheet 4.8 Chart: 5 • Horizontal axis title ('Years') inserted  1 • Horizontal axis labels changed to display years 2000 - 2005  1 • Legend changed to 'Number of songs'  1 • Vertical axis label major unit set to fixed 50  1 • Data labels set (any position) to show values  1 Total for QUESTION 4 [25] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 9 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 5 File name: 5Music_Musiek Total Q5: 42 Candidate No Criteria Max Mark Mark Table: Learners_Leerders 5.1.1 Field: Gender_Geslag 1 • Default value set to 'M'  1 5.1.2 Field: Grade_Graad 1 • Set as required field  1 5.1.3 Field: Class_Klas 3 • Display control: List box/Combo box  1 • Row source type: Value list  1 • Row source: A, B, C, D OR a, b, c, d  1 (Notes to marker: • Allocate third mark if one option added. • Also accept if separate table created and used with rows/source type set to Table/Query.) 5.1.4 Field: DOB_Geboortedatum 2 • Format Set to Medium Date  1 • Input Mask symbol Placeholder changed to # via wizard: 00\->L<LL\-00;0;#  1 5.1.5 Field: Cell_Sel 4 • Validation rule: Len  ([Cell_Sel])  =10  3 • Validation text: Refers to 10 characters  1 Form: frm5_2 5.2 • Displays all 12 fields from Learners_Leerders table  1 7 • Font colour of the data in the Owner_Eienaar field appears as reddish  1 • Combo box/List box added in details section  1 • Row source based on Owner_Eienaar field  1 • Row source: SELECT [Learners_Leerders].[Owner_Eienaar] FROM Learners_Leerders;  1 • Label 'Find what' added  1 • Horizontal line added to form footer  1 (Notes to marker: • Mark from Form view. • Do not allocate fifth mark if selected record does not display. • Accept any line inserted anywhere in form footer.) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 10 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER Query: qry5_3 5.3 • Fields displayed: Title_Titel, Artist_Kunstenaar, 4 Year_Jaar and Genre  1 • Year_Jaar criteria: 1996  1 • Genre criteria: 'DANCE'  1 • Title_Titel field sorted ascending  1 (Note to marker: 1 record expected.) Query: qry5_4 5.4 • Cost_Koste field added  1 5 and format set to any currency  1 • Calculated field added: Inc:  [Cost_Koste]  2 * 2  award two marks if *2 is omitted 1 OR Inc: [Cost_Koste]+[Cost_Koste] Query: qry5_5 5.5 • Total row displayed  1 3 • Grouped by Genre  1 • Cost_Koste field: Total property set to Sum  1 (Note to marker: 3 records for three genres expected.) Query: qry5_6 5.6 Address_Adres field criteria: Like "13 *Crescent" 3 • 13  • Compulsory space after 13  1 • *Crescent/*Cre*  1 1 (Note to marker: 3 records expected. Accept any alternative method.) Report: rpt5_7 5.7 • Report display fields: Artist_Kunstenaar, Title_Titel, 9 Year_Jaar, Cost_Koste and Genre  1 • Report grouped according to Year_Jaar field  1 • Sorted on Artist_Kunstenaar field  1 • Report heading changed to 'Year released'  1 • Function in Year_Jaar footer/header : 1 =SUM([Cost_Koste])  and suitable label added  2 • Function in report footer/header : 1 =MAX([Cost_Koste])  1 (Note to marker: Do not penalise if label in the report footer is not given or not suitable.) Total for QUESTION 5 [42] Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 11 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 6 File name: 6Poster_Plakkaat Total Q6: 19 • This question should be marked from the web browser as far as possible unless otherwise indicated or it cannot be seen in the web browser. • A maximum of 1 mark will be deducted if one or more closing tags are omitted. • The code of the candidates that use a word processor will contain additional unnecessary tags. Markers will need to work through the code to check for the answers provided below. Candidate No Criteria Max Mark Mark 6.1 Title 1 <head> <title>'60s Music</title> </head> • Title with title tags moved to head section of web page  1 6.2 Image 2 <img src ="6Sixty_Sestig.jpg"….> • Tags added for image source  1 • Image 6Sixty_Sestig.jpg named/used correctly  1 6.3 Alignment 1 <h1 align="center">Music</h1> • 'Music' heading centred  1 6.4 Horizontal line 2 <hr size="3" width = "70%"/> • Size of horizontal line set to 3  1 • Width of horizontal line set to 70%  1 6.5 Heading style 1 <h2>Before 1963</h2> • Heading 2 style applied to text  1 6.6 Bold 1 <b>The Beatles</b> • Bold applied to text 'The Beatles'  1 6.7 Italics 2 <p><i>To mention a few ...</i></p> • Text 'To mention a few …' appears in italics  1 • In a separate paragraph  1 Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 12 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER 6.8 Table 4 <table bgcolor="orange" align="center" border="3"> <tr> <th>Artist</th> <th>Hits</th> </tr> • Table's background colour changed to orange  1 • Row added at the top of the table  1 • Two cell heading tags added  1 • Cells contain headings 'Artist' and 'Hits' respectively  1 (Notes to marker: • Allocate last mark if only one heading appears. • Do not accept <td> instead of <th>.) 6.9 Numbered list 2 <ol> <li>Surfin' USA</li> <li>Good Vibrations</li> </ol> • The text 'Surfin' USA' and 'Good Vibrations' appear in a numbered list  1 • Two list tags/items  1 (Note to marker: Allocate mark if only one list item appears. Accept ordered or unordered list.) 6.10 Link 3 <a href="#Top">Back to top</a> • Text inserted 'Back to top'  1 • Link created on the text 'Back to top'  1 • Link moves to 'Top'  1 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 13 DBE/2016 SCE – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 7 Total Q7: 19 File names: 7Form_Vorm, 7Compet_Kompet, 7Sixties_Sestigs, 7Data and 7Answ_Antw. Candidate No Criteria Max Mark Mark 7Form_Vorm 7.1 Document properties 1 • Comment property reads 'CAT Exam'  1 7.2.1 Name: Form field control 1 • Text form field inserted next to text 'Name'  1 7.2.2 Surname: Text form field 1 • Text form field property set to display in uppercase  1 7.2.3 Drop down list 2 • Drop down form field inserted  1 • Options: Beatles, Elvis Presley, The Beach Boys  1 (Note to marker: Accept at least two options to allocate the second mark.) 7Compet_Kompet, 7Data 7.3 Mail Merge 3 • 7Data used as the data source for the mail merge  1 • Name_Naam and DOB_Geboortedatum fields inserted in correct positions  1 • Merge completed  (7Data) 1 (Note to marker: 99 letters expected.) 7Sixties_Sestigs 7.4 Tables 3 • New table  created called 7Comb 1 • Records from both tables combined (33 records)  1 • Records sorted in descending order according to Name_Naam field  1 (Note to marker: Do not penalise if data in Code_Kode field has changed.) Copyright reserved Please turn over
Downloaded from hlayiso.com Computer Applications Technology/P1 14 DBE/2016 SCE – 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 two marks if the answer is correct. 7Answ_Antw 7.5.1 Which song charted in both the American and British 2 charts on 1 August 1964? • A Hard Day's Night  1 Method:  1 • Filter on Date and Year • Filter search 1964-08-01 • Sort on Date, Year, Chart 7.5.2 How many different or unique titles by Elvis Presley 2 reached the charts? 1 • 9 1 Method:  • Filter on Artist, count only unique values • Remove duplicate songs, count on Artist • COUNTIF and count unique values 7.5.3 Which chart featured the most titles? 2 • American  (178) 1 Method:  1 • COUNTIF British and American charts and compare • Filter both and compare total on scroll bar • Sort and count 7.5.4 Which year featured the most titles on the charts? 2 • 1964  (100) 1 Method:  1 • Filter each and see count on scroll bar • Filter, copy and count • COUNTIF • Sort, select years and see count on scroll bar • Use SUBTOTAL function Total for QUESTION 7 [19] TOTAL 180 Copyright reserved

Study this subject

More from Grade 12 Computer Applications Technology

View all