Computer Applications Technology Grade 12 P1 2015 Memo (Eng)

NATIONAL SENIOR CERTIFICATE GRADE 12 COMPUTER APPLICATIONS TECHNOLOGY P1 FEBRUARY/MARCH 2015 MEMORANDUM/MARKING GUIDELINE MARKS: 180 CENTRE FINAL MARK NUMBER EXAMINATION NUMBER QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 28 22 18 31 40 20 21 180 CANDIDATE MARK MARKER CODE/ SIGNATURE MODERATED MARK This memorandum/marking guideline consists of 13 pages. Copyright reserved Please turn over

Computer Applications Technology/P1 2 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 1 File name: 1Energy_Energie Total Q1: 28 Maximum Candidate No Criteria Mark Mark 1.1.1 Cover page/Title page 1 • Any page border added  1 (Note to marker: Border can appear only on first page.) 1.1.2 Cover page/Title page 1 • Watermark appears only on first page  1 1.2 Table of contents 3 • Automatic Table of Contents inserted  1 • Three levels of headings appear  1 • Correct styles used: Title, Heading 1 and Heading 2 styles  1 (Note to marker: All three levels must be inserted correctly in order to obtain the last mark.) 1.3 Page numbering 3 • Page numbers have been inserted in the header  1 • Automatic page numbering starts as 1 on the second page  1 • Page numbering does not appear on the first page  1 1.4 Shape fill 1 • 'Social' shape has been filled with the picture 1Social_Sosiaal  1 (Note to marker: Accept if any of the other images have been used to fill the shape.) 1.5 Hyperlink 2 • Hyperlink applied on word 'resources'  1 • Linked to heading 'Where does our energy come from?'  1 (Note to marker: Allocate the marks if the candidate created a bookmark and linked the text to the bookmark.) 1.6 Table 2 • Text was correctly converted to table  1 • Any table style applied to the table other than the default  1 (Note to marker: Do not award the first mark if only one column appears.) Copyright reserved Please turn over

Computer Applications Technology/P1 3 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER 1.7 Citation 3 • Citation created  1 • Title – SMART LIVING HANDBOOK, Year – 2011  1 • APA style applied  1 (Note to marker: Allocate second mark if only the title or the year has been inserted.) 1.8 Caption 2 • Automatic caption changed from table to figure  1 • Caption appears with the text 'Figure1: Electricity'  1 1.9 Bullets 2 • Bullets formatted to a picture  1 • 1Bullet_Kolpunt picture used to format bullets  1 (Note to marker: Accept if only one bullet is changed.) 1.10 Style 4 • New style named Energy  1 • Font size set to 16 pt  1 • Font colour changed to red  1 • 'Energy' style applied to heading 'Decommissioning'  1 1.11 Find and Replace 2 • All occurrences of the whole word 'sustainnable' have been replaced with the word 'sustainable'  1 • Highlighted  1 (Note to marker: 2 replacements expected.) 1.12 Widow/Orphan 1 • Widow/Orphan control setting has been unchecked for third column in table  1 1.13 Table of Figures/Illustration Index 1 • Table of Figures/Illustration Index updated  1 (Notes to marker: • Check that the 'Imported gas' figure has been added to the table to mark this question. • Page numbers may differ.) Total for QUESTION 1 [28] Copyright reserved Please turn over

Computer Applications Technology/P1 4 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 2 File name: 2School_Skool Total Q2: 22 Maximum Candidate No Criteria Mark Mark 2.1 Page orientation 2 • Only the first page changed to landscape  1 • Section break inserted and second page appears in portrait  1 2.2 Page border 2 • Top margin of page border changed to 17 pt  1 • From edge of page  1 2.3 Heading centred 1 • Heading has been centred horizontally  1 2.4 Columns 3 • Selected text displayed in three columns  1 • Spacing between columns set to 0.6 cm  1 • Column break inserted before the headings 'Switch off at the socket!' and 'Turn off the lights'  1 (Notes to marker: • Do not penalise if a line between columns was added. • Allocate the third mark if only one column break was inserted.) 2.5 Callout shape 3 • Text box has been changed to callout shape  1 • Grey fill colour applied to shape  1 • Shape sized to include all the original information so it is clearly visible  1 (Note to marker: Accept any similar callout shape.) 2.6 Grouping 2 • Pictures moved to correct position/order  1 • Pictures grouped as one object  1 2.7 Hyphenation 1 • Hyphenation set to automatic  1 2.8 Survey Form 4 • Three leader tab lines have been removed  1 • Text form field type of Age changed to Number type  1 • Blue placeholder replaced with a drop-down list  1 • Items appear as Moderate, Mild, Excessive  1 2.9 Symbol/Shape 1 • Correct symbol inserted next to 'Use Electricity Sparingly'  1 2.10 Watermark 3 • Watermark inserted on any page  1 • 2Back_Agter picture inserted  1 • Scale is set to 120%  1 Total for QUESTION 2 [22] Copyright reserved Please turn over

Computer Applications Technology/P1 5 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 3 File name: 3Individ Total Q3: 18 • 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 Main_Hoof worksheet 3.1 Cell B3: 1 = TODAY() OR NOW()  1 3.2 Cell B4: 4 =DATE(YEAR(B3)+2,MONTH(B3)+3,DAY(B3)) • DATE function  1 • (YEAR(B3)+2  1 • MONTH(B3)+3  1 • DAY(B3))  1 (Note to marker: Accept any other suitable method.) 3.3 Cell B7: 4 =CONCATENATE(LEFT(A7,3),J7) OR =LEFT(A7,3)&J7 • CONCATENATE function OR & sign  1 • LEFT  (A7,3)  2 • J7  1 3.4 Cell C19: 1 =MODE(C7:I18)  1 3.5 Column I: Data Validation 4 • Validation criteria: Allow whole number  1 • Criteria: <=  1 • 100  1 • Any suitable error message  1 3.6 Page Setup 2 • Print area set to A1:J19  1 • Gridlines – 'Print' checked in page setup  1 Transp worksheet 3.7 Transp worksheet 2 • Data copied from range A14:I16 from Main_Hoof worksheet to Transp worksheet  1 • Data correctly displayed/transposed  1 Total for QUESTION 3 [18] Copyright reserved Please turn over

Computer Applications Technology/P1 6 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 4 File name: 4Countries_Lande Total Q4: 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 answers. • Named ranges can be used instead of cell references. Maximum Candidate No Criteria Mark Mark Carbon_Koolstof worksheet 4.1 Carbon_Koolstof tab: 1 • Tab changed to any colour other than the original 1 colour  (Note to marker: The original tab colour was white.) 4.2 Cell A1: 2 • Comment added  1 • Comment text inserted: 'Carbon released' 1 (Note to marker: Ignore spelling.) 4.3 Cell C10: 4 = VLOOKUP(B10,Capital_Hoofstad!A2:B20,2,FALSE) OR 1 = VLOOKUP(B10,Capital_Hoofstad!A2:B20,2,0) 1 • LOOKUP value: B10  • Table array: Capital_Hoofstad!A2:B20  OR 1 Table array: Capital_Hoofstad!A1:B20) 1 • Column index number: 2  • Range_Lookup: False OR 0  OR = VLOOKUP(B10,Capital_Hoofstad!A2:B20,2) • LOOKUP-value: B10  • Table array: Capital_Hoofstad!A2:B20  OR Table array: Capital_Hoofstad!A1:B20) • Column index number: 2  • Data in range A2:B20 is sorted in alphabetical order in the Capital_Hoofstad worksheet according to country  (Note to marker: Absolute cell referencing can be used.) Copyright reserved Please turn over

Computer Applications Technology/P1 7 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER 4.4 Cell F22: 5 = SUMIF(D3:D21,"*America",F3:F21) • SUMIF function  1 • Criteria range: (D3:D21)  1 • Criteria: "* America"  2 • Sum range: (F3:F21)  1 OR =SUMIF(D3:D21,"South America",F3:F21) + SUMIF(D3:D21,"North America",F3:F21) • SUMIF function  • Criteria range: (D3:D21)  • Sum range: (F3:F21)  • Both criteria included   4.5 Cell H3: 5 =IF(G3>=$F$24,"High Risk","Low Risk") OR =IF(G3<$F$24,"Low Risk","High Risk") OR =IF(G3>=AVERAGE($G$3:$G$21),"High Risk", "Low Risk") OR =IF(G3<AVERAGE($G$3:$G$21),"Low Risk", "High Risk") • IF function  1 • Condition G3 >=F24 OR Average(G3:G21) and value "High Risk"  1 • Condition G3<F24 OR Average(G3:G21) and value "Low Risk"  1 • Absolute addressing $F$24 OR ($G$3: $G$21)  1 • Formula copied to cells H4 to H21  1 4.6 Cell J3: 5 =I3/SUM(I3:I21)*100 OR =I3/SUM(I3:I21)% • I3  1 • /  SUM(I3:I21)  2 • *100 OR cell formatted as percentage  1 • Formatted to 4 decimal places  1 Copyright reserved Please turn over

Computer Applications Technology/P1 8 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER 4.7 Cell F26: 4 =F3/E3*POWER(I3,5) • F3  1 • /E3  1 • * POWER(I3  ,5)  2 OR =F3/E3*I3^5 • F3  • /E3  • * I3  ^ 5  OR =F3/E3*I3*I3*I3*I3*I3 • F3  • /E3  • * I3  multiplied by itself 5 times  Nuclear_Kernkrag worksheet 4.8 Graph 5 • Horizontal axis title 'Country' inserted  1 • Highest column filled in a different colour  1 • Value data label set for France only  1 • Exponential trendline inserted  1 • Vertical axis scale set to automatically display the maximum value  1 Total for QUESTION 4 [31] Copyright reserved Please turn over

Computer Applications Technology/P1 9 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 5 File name: 5Course_Kursus Total Q5: 40 Maximum Candidate No Criteria Mark Mark Table: Cur_Kur 5.1.1 Field: Type_Tipe 12 • Drop-down field  1 • Options are Sust-Related and Sust-Focused  1 Field: Dept_Dept • Field size 15  1 Field: CourseID_KursusID • Required property set to Yes  1 • Indexed properties set to Yes (no duplicates)  1 • Input mask: > 1 LLL  1 ? 1 000  1 Field: Cost_Koste • Format set to currency (Rand) or data type changed to Currency  1 Field: Avail_Beskik • Format set to Yes/No  1 • Lookup display control changed to textbox  1 5.1.2 Format table 2 • Gridlines removed  1 • Background colour of table changed to grey  1 Course_Kursus 5.2 Export table 2 • Table Course_Kursus exported to word processing type document  1 • Saved as 5Exp_Uit  1 (Note to marker: Accept any document type that will open in a word processor.) Query: qry5_3 5.3 • Title_Titel, Cost_Koste and VATInc fields are 5 displayed  1 • Calculated field name: VATInc:  1 • [Cost_Koste]  1 • * 1 • 1.14  OR 14/100+[Cost_Koste] OR 114/100 OR 0.14+[Cost_Koste] 1 Copyright reserved Please turn over

Computer Applications Technology/P1 10 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER Query: qry5_4 5.4 • Criteria 5 Title_Titel = "*sustainable* " Both wildcards (*)  sustainable  2 • Student_Student field: >= 60  (>59) 1 AND  1 <100  (<=99) 1 (Note to marker: 2 records expected.) Query: qry5_5 5.5 • Fields included: Dept_Dep, Cost_Koste, Title_Titel, 4 Avail_Beskik  1 • Dept_Dept = "ACCT"  1 • Avail_Beskik = Yes  OR 1 OR True OR -1 1 • Title_Titel field sorted ascending  1 Form: frm5_6 5.6 • Only CourseID_KursusID, Title_Titel, Avail_Beskik 3 fields included  1 • Label in form header changed to 'Courses'  1 • Date inserted as field in form footer  1 Report: rpt5_7 5.7 • Report data source changed to qry5_7  1 7 • Grouped on Avail_Beskik field  1 Properties changed to 'keep whole group together on page'  1 • Function inserted in group footer or group header  1 =count  ([Title_Titel])  2 OR =count  (*)  • Suitable label (must refer to number of courses)  1 Total for QUESTION 5 [40] Copyright reserved Please turn over

Computer Applications Technology/P1 11 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 6 File name: 6Tips_Wenke 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 Title 2 <title>Energy Tips</title> • 'Energy Tips' appears  1 • In the browser tab  1 6.2 Background colour 1 <body bgcolor="white"> • Background colour changed to white  1 6.3 Heading and alignment 2 <h1 align="center">Energy Saving Tips</h1> • 'Energy Saving Tips' appear as heading 1 1 • 'Energy Saving Tips' centred  1 6.4 Horizontal line size 1 <hr color="yellow" size="10"> • Line size set to 10  1 6.5 Table: Row and Column 4 <font face ="Arial"> <table border="1"> <tr> <td>Tip 1</td> <td>Leaving a computer monitor on overnight wastes as much energy as making 800 A4 photocopies!</td> </tr> </font> • Font of entire table changed to Arial  1 • Row inserted at the top of the table  1 • Text 'Tip 1' appears in the first cell of the new row  1 • Text 'Leaving a computer monitor on overnight wastes as much energy as making 800 A4 photocopies!' appears in the second cell in the new row  1 Copyright reserved Please turn over

Computer Applications Technology/P1 12 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER 6.6 Image: Height and Width 4 <img src="6Save_Spaar.jpg"height="200" width="200"> • Image appears below the table  1 • Image displays correctly  1 • Height = 200  1 • Width = 200  1 (Note to marker: Mark this from the HTML code.) 6.7 Ordered list 2 <ol><font size="6"> <li>Change a light!</li> <li>Fight the light!</li> <li>Don't leave it on!</li> <li>Shocking battery power</li> </font> </ol> • Bulleted list changed to numbered list  1 • Font size of list items changed to 6  1 (Note to marker: Mark the second bullet from the HTML code.) 6.8 Link 4 <a href="www.google.com">Link to Google</a> • Link text 'Link to Google' inserted  1 • Between paragraph tags  1 • Link moves to 'www.google.com'  1 1 • Link works correctly  (Note to marker: The link will work correctly if the web browser opens and the address displays in the address bar. No Internet access is needed.) Closing tag(s) or brackets omitted -1 Total for QUESTION 6 [20] Copyright reserved Please turn over

Computer Applications Technology/P1 13 DBE/Feb.–Mar. 2015 NSC – Memorandum/Marking Guideline EXAMINATION NUMBER QUESTION 7 Total Q7: 21 File names: 7Act_Akt, 7Temp and 7Video Maximum Candidate No Criteria Mark Mark 7Act_Akt 7.1 Extraction 1 • 7Video file extracted (7Video.mp4 appears in examination folder)  1 7.2.1 Cross-reference 3 • Cross-reference created  1 • On the text 'Temperatures'  1 • Linked to bookmark called 'Graph'  1 7.2.2 Equation 2 • Equation adjusted to include Kwh on top  1 • Day included below Kwh  1 7.2.3 Shape added 2 • Shape with text 'Human Resources' added  1 • In the correct position  1 (Note to marker: Ignore spelling.) 7Temp 7.3 Graph/Chart in 7Temp 6 • Years sorted in ascending order  1 • Duplicate values deleted  1 • Top 3 temperatures  1 appear with a border  1 • Graph inserted in 7Act_Akt document  1 • Reduced to fit in third column  1 7Act_Akt 7.4 Calculation in table 2 • =AVERAGE  1 • (ABOVE)  1 7.5 Text form field 2 • Maximum characters is set to 30  1 • Default text added as 'Add your name here'  1 7.6 Author properties 3 • Author property of document changed to examination number  1 • Author field inserted next to 'Created by:'  1 • Displays in capital letters  1 Total for QUESTION 7 [21] TOTAL 180 Copyright reserved