CAT P1 GR12 MEMO SEPT 2019 English hlayiso.com

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2019 COMPUTER APPLICATIONS TECHNOLOGY P1 MARKING GUIDELINE NAME OF CANDIDATE: ____________________ GRADE: _________ SIGNATURE OF EDUCATOR: ____________________ TOTAL Q1 Q2 Q3 Q4 Q5 Q6 MARKS: 180 29 23 57 41 20 10 This marking guideline consists of 12 pages.

Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019) QUESTION 1 File Name: 1LandPollution Total Q1: 29 Maximum Candidate No. Criteria Mark Mark 1.1.1 Cover Page 1 1  Cover page Facet inserted.  1.1.2 Cover Page 1  Type Land Pollution in title field, Save our Land in the subtitle field.  1 3  Type landhighschool@ecdept.gov.za in the e-mail 1 field.   Delete the abstract field.  1.2.1 Table of Contents 1 1  Automatic Table of Contents inserted.  1.2.2 Table of Contents 1 1  Three levels of headings appear.  1.2.3 Table of Contents  Correct styles used: Title, Heading 1 and Heading 2 styles.  1 1 (Note to marker: All three levels must be inserted correctly in order to obtain the last mark.) 1.3.1 Page Numbering 1 1  Accent Bar Right page numbers inserted.  1.3.2 Page Numbering 1  Automatic page numbering starts as 1 on the second page.  2 1  Page numbering does not appear on the first page.  1.4.1 Paragraph Formatting 1 1  Paragraph spacing is 6 pt before and 6 pt after the paragraph.  1.4.2 Line Formatting 1 2  Line spacing set to exactly   16 pt.  1 1.4.3 Character Formatting 1 1  Character spacing expanded to 1.5 pt.  1.5 Document Editing 1  Correct occurrences of text changed  2  with the word “infect”.  1 (Note to marker: 2 Occurrences only 2 or 0 marks) Copyright Reserved Please Turn Over

(EC/SEPTEMBER 2019) Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.6 Hyperlink 1  Hyperlink on text ‘In factories and offices’.   URL ‘www.explainthatstuff.com/land- 1 3 pollution.html’.   Tooltip ‘HowStuffWorks’ added.  1 1.7 Footnote 1  Footnote added to text ‘Radioactive Waste’.  1 3  Footnote symbol: Wingdings character 83.  1  Footnote text: ‘by-product of nuclear power’.  1.8 Document formatting 1  Document justified.  2  Document hyphenated.  1 1.9 Citation 1  Source added.  1 3  As a website source.   Author; Name of website; Year and URL appear.  1 1.10 Bibliography 1 1  Bibliography updated.  1.11 Quick Parts 1 1  Date created field inserted (11 March 2019).  Total for QUESTION 1 [29] Copyright Reserved Please Turn Over

4 Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019) QUESTION 2 File Name: 2LandPollutionBrochure Total Q2: 23 Maximum Candidate No. Criteria Mark Mark 2.1 Page Orientation 1 1  Set to landscape.  2.2 Page border 1  2¼ pt wide border inserted.  1 3  Colour of border is red.  1  Page border.  2.3 Columns  Highlighted text displayed in three columns.  1 1  1 cm/0.39 inches space between columns.  4 1  A line in between columns appears.  1  Heading must be at the top of each column.  2.4 WordArt  Any WordArt inserted  1 3  to the correct text.  1  Gold colour Accent 4 Soft Bevel.  1 2.5 Bullets 1  Bullets changed to a picture 1 4  2Bullet.jpg.   Left indent – Bullet 0 cm.  1  Hanging – paragraph 1.5 cm.  1 2.6 Shapes  Any Callout inserted.  1  Oval Callout Shape.  1 4 1  Inserted at the bottom of first column. 1  Text “Save Our Land” inserted.  2.7 Watermark 1  Watermark inserted.  1  2LandPollution2.jpg used as watermark.  1 4  Without Washout effect.  1  Picture scaled to 120%.  Total for QUESTION 2 [23] Copyright Reserved Please Turn Over

(EC/SEPTEMBER 2019) Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 3 File Name: 3_LandSheet Total Q3: 57  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 Stats per Province worksheet 3.1.1 Stats per Province  Tab changed to any colour other than the original 1 1 colour.  (Note to marker: Colour was white.) 3.1.2 Merge and Centre 1 1  Cells A1 to T1 are merged and centred.  3.1.3 Fill 1  Applied any thin diagonal stripe pattern style fill 2 effect to merged cells.  1  Colour Red.  3.1.4 Row 4 1 1  Wrapped  3.2 Freeze panes 1 2  Freeze pane effect applied 1  Column A.  3.3 Format Date =(dd)-(mm)-( yyyy) 1  Correct use of brackets.  3 1  Correct use of -.  1  Correct specifications for day, month and year.  3.4 Cell A5 1 =CONCATENATE(UPPER(LEFT(B5;2));"-”; 1 LEN(B5))  Concatenate or & function used  1 5  (LEFT(B5;2))   "-”  1  LEN(B5))   UPPER – All in upper case  1 Copyright Reserved Please Turn Over

6 Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019) 3.5 Cell C3 =FIND(" ";B5) 1  Find function used to determine.  1 3  Correct position of space.  1  In cell (B5).  3.6 Data Validation 1  Validation criteria: Allow whole number  1  Criteria: Between  1 4  Minimum value 0 and Maximum value 999999 1  Any suitable error message  3.7 Cell E3 =COUNTIFS(D5:D13;">=100000";E5:E13;"<=55") 1  Countifs function  1  Criteria range 1: (D5:D13)  1 5  Criteria 1: >=100 000 1  Criteria range 2: (E5:E13)  1  Criteria 2: <=55 3.8 Nested IF 1 =IF(E5<51;"Less Dense"; IF(E5<=100;"Dense";"Highly Dense")) 1 4  Nested IF syntax  1  Condition: <51 and “Less Dense”   Condition: <=100 and “Dense”  1  Condition: >100 and “Highly Dense”  3.9 Conditional formatting  Conditional formatting used  1 3  in correct column  1 1  a red data bar.  3.10 Cell Q15 1 =SUMIF(B5:B13;"*Cape";Q5:Q13)  Sumif function 1 4  Criteria range: B5:B13  Sum range: Q5:Q13  1  Criteria: *Cape  1 Copyright Reserved Please Turn Over

(EC/SEPTEMBER 2019) Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 7 3.11 Cell R5 =P5-Q5 1  =P5; Q4  3 1  Minus sign (-)   Function in cell R5 copied to cells R5:R13  1 3.12 Cell S5 1 =IF(P5<=Q5,"Top up"," ") OR 1 =IF(Q5>=P5, “Top up”, “ ”) 4  IF- Function  1  Correct condition specified: P5<=Q5  Value if true is correct 1  Value if false is correct 3.13 Cell T9 1 =VLOOKUP(B9,Towns!$A$2:$B$10,2, FALSE) 1  Vlookup function  5  Lookup value: B9 1  Lookup range: Towns!$A$2:$B$10  (ignore if no absolute cell reference) 1  Column: 2   Lookup range: False  1 3.14 Graph Worksheet 1  Graph created title changed to 1 WasteTreatment.   Both series points plotted.  1  Column graph and Line graph appear together.  1 7  Vertical axis ‘Waste Treatment Facilities’ and horizontal axis “Provinces” added.  1  Legends series placed and edited.   Picture Fill applied in the chart area.  1  Graph moved to Graph worksheet.  1 Total for QUESTION 3 [57] Copyright Reserved Please Turn Over

8 Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019) QUESTION 4 File Name: 4_LandPollution Total Q4: 41 Maximum Candidate No. Criteria Mark Mark Table: Waste Pollution 4.1.1 Field: ID 1 1  ID field removed.  4.1.2 Field: Image  New field created.  1 3  After province field.  1  Data type: OLE Object Or attachment.  1 4.1.3 Primary key 1 1 Primary key set to Province field.  4.1.4 Required Field: Hazardous Waste 1 1  Set as required field.  4.1.5 Validation rule and text: Own refuse dump 1  Between or And functions used. 1  Lower boundary set to greater than 2 and upper 3 boundary set to less than 99.  1  Appropriate validation text referring to limits. Between 2 And 98 OR >2 And <99 4.1.6 Budget Field 1 1 Default value set to R10000.  4.2 Form: frm4_2  Only Provinces; Hazardous Waste; Budget 1 and Expenditure fields are shown.  1  Background colour of the form changed to red. 1  1 7  Title/Label changed to Waste. 1  Date field inserted in the form header.  1  Calculation in the form footer. 1  Count   (*) Copyright Reserved Please Turn Over

(EC/SEPTEMBER 2019) Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 9 4.3 Qry4_3 1  Only Province, Population served by municipality and Own Refuse Dump fields are 1 shown.   Criteria: Population served by municipality: >=50. 1 5   Hazardous field: Yes 1  Sorted: Own Refuse Dump field.   Sorted: In ascending order.  1 4 Records 4.4 Qry4_4 1  Province: Total: Grouped by.   Budget: Total: Sum  1 3  Criteria: >=50 000  1 4 Records 4.5 Qry4_5 1 Balance: [Budget]-[Expenditure] 1  Calculated field name: Balance:   Budget and Expenditure fields used  1  - 6 1  Correct use of brackets   Balance: <0  1  Hazardous Waste: Yes  1 2 Records 4.6 Report4_6  Report is created  1  with all the required fields other than ID field.  1  Report is grouped according to Licensed facilities field.  1  Then is grouped according to Hazardous field.  1  Report sorted according to the Budget field.  1 10  Page orientation change to landscape.  1  Calculation on the footer of the Licensed Facilities field:  1  =Sum([Expenditure])  1  Total amount is in any currency format.  1 1  Picture inserted in the report header.  Total for QUESTION 4 [41] Copyright Reserved Please Turn Over

10 Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019) QUESTION 5 File Name: 5_MyWebsite Total Q5: 20  This question should be marked from the HTML code.  Numerical attribute values do not need to be in inverted commas. Maximum Candidate No. Criteria Mark Mark 5.1 Title <title>Land Pollution </title> 1 1  Title tag added  5.2 Heading: LandPollution <h1 align ="center"><font color = "Brown"> 1 Land Pollution</font></h1> 2 1  Heading aligned centre   Font colour changed to brown  5.3 Horizontal line 1 <hr size=7 color="Red"/> 2  Size of line changed to 7. 1  Line colour changed to red.  5.4 Ordered list 1 <ol type = "I" > </ol> 1 3  Ordered list <ol> created.   Type of bullet set to Roman figures.  1  Roman figures in upper case.  Copyright Reserved Please Turn Over

(EC/SEPTEMBER 2019) Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 11 5.5 Table  First row added - <th>  <tr> 1 <th>Type of Land Pollution</th> <th>Cause</th> <th>Area found</th> </tr> 1  Table border set at 2  1  Cellpadding set at 25  <table border = 2 cellpadding = "25"> 1 <tr bgcolor = "Pink">  9 <th>Type of Land Pollution</th> <th>Cause</th> <th>Area found</th> 1 </tr> 1  Colspan = “3”  1  Image = 5LandPollution.jpg  1  align = "middle"  1  height =200 width = 300   Alt = “Dump”  <tr><td colspan ="3" align = "middle"> <img src ="5LandPollution.jpg" align = "middle" height =200 width = 300 Alt = “Dump”> </td></tr> 5.6 Link <a href="#Top"> Home </a>  <a href> </a>  1 3  Link created on the text ‘Home.  1  Link moves to the top of website.  1 Closing tag(s) or triangular brackets omitted -1 Total for QUESTION 5 [20] Copyright Reserved Please Turn Over

12 Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019) QUESTION 6 File Name: 6Letter.docx Total Q6: 10 Maximum Candidate No. Criteria Mark Mark 6.1.1  Pictures grouped.  1  Picture moved below heading Waterfall 2 1 Community.  6.1.2  Cross reference created next to the word “my”.  1  Links to the endnote “Waterfall Community 2 Leader”.  1 6.1.3  Correct changes are made to the graph.  1 2  The changes are showing in the graph.  1 6.1.4  Widow/orphan control is checked.  1 2  Keep lines together is checked.  1 6.1.5  6Poster copied and pasted to the letter.  1 2  Pasted as an icon.  1 Total for QUESTION 6 [10] TOTAL: 180 Copyright Reserved Please Turn Over