Computer Applications Technology Grade 11 P1 2020 Memo (Eng)

NATIONAL SENIOR CERTIFICATE GRADE 11 NOVEMBER 2020 COMPUTER APPLICATIONS TECHNOLOGY P1 MARKING GUIDELINE (EXEMPLAR) NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 MARKS: 150 30 20 53 34 13 This marking guideline consists of 10 pages.

2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) QUESTION 1 File Name: 1WildCoast Total Q1: 30 Maximum Candidate No. Criteria Mark Mark 1.1.1 Cover Page  Size exactly 5 cm x 5 cm  1 2  Lock aspect ratio unchecked  1 1.1.2 Cover Page 1 1  Picture position set to Middle Centre  1.1.3 Cover Page  Learner name and surname inserted in author 1 1 control  1.2 Page Numbering  Border left page numbering used  1 2  Zero on first page removed (different first page)  1 1.3 Breaks 1 1  Page break used  1.4. Styles  New Style Eastern Cape Coasts created  1 1  Based on Heading 1 style  1  New style horizontally centred  5 1  Font colour of style is red  1  Style applied to heading  1.5.1 Table of Contents  Table of content inserted  1  Modern style format used  1 3  Ensure that heading ‘Wild Coast Region, Eastern 1 Cape’ appears in TOC  1.5.2 Table of Figures  Picture captioned  1 2  Table of figures updated  1 1.6 Footnote  Footnote inserted  1  Below the text  1 4  Wingdings character code 0046 or 70  used  1 1  Text ‘(www.wildcoast.com/xolobeni)’ added  1.7 Find and Replace 1  Transkei replaced with Former Transkei  2 1  All five occurrences replaced  Copyright reserved Please turn over

(EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.8 Citation  Web site chosen source  1  Wild Coast inserted as web site name  1 3  www.wildcoast.com inserted as the URL  1 1.9 Shapes  Horizontal scroll shape inserted  1  Correct text added/Copied  1 4  Shape style changed to Subtle effect – Blue Accent 1 1 1  Yellow text highlight removed from inserted text  Total for QUESTION 1 [30] Copyright reserved Please turn over

4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) QUESTION 2 File Name: 2Form Total Q2: 20 Maximum Candidate No. Criteria Mark Mark 2.1.1 WordArt  WordArt changed  1 2  Changed / transformed to Warped Ring Inside.  1 2.1.2 Grouping  Any picture inserted.  1  Picture 2Form.jpg inserted.  1 3  Picture and WordArt grouped.  1 2.2 Page background  Page background inserted.  1 1 3  Vertical gradient fill used.   Two colours, blue and white, used.  1 2.3 Watermark  Watermark inserted  1 1 3  2Watermark.jpg image used   Image scaled to 120%  1 2.4 Tabs  Tabs set to Surname  1 3  First tab set at 6 cm centred.  1  Second tab set at 14 cm right align.  1 2.5.1  Surname text form field 20 characters  1 2.5.2  Gender changed to dropdown form field  1  Male and Female entered.  1 6 2.5.3  The check box form field set to 14 pt  1  exactly  1  and BnB field checked.  1 Total for QUESTION 2 [20] Copyright reserved Please turn over

(EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 3 File Name: 3Wild Coast Visitors Total Q3: 53 Maximum Candidate No. Criteria Mark Mark Information worksheet 3.1.1 Merge and Centre  Cells A1 to Q1 are merged  1 2  and centred  1 3.1.2 Shading 1  Shading applied on merged cell  1  “From Corner” shading style used  4 1  use 2 colours   namely yellow and blue.  1 3.2 Date 1  D2: Today’s date inserted  2  Date format changed to dd-mm-yyyy  1 3.3 Wrap text  Text in row 4 wrapped  1 1 3.4 Freeze Panes  Row 4 frozen  1  All other text moves under row 4 when user scrolls 2 1 down  3.5 Printing 1  Row 1 to row 4 to repeat  1 3  at the top of each page  1  Gridlines inserted (ticked)  3.6 Conditional formatting  Conditional formatting applied in correct column 1 (column G)  1 3  Criteria only hotels  1  Reddish fill colour used  3.7 Column I  Rand Currency or Accounting  1 2  Zero decimal places  1 3.8 Cell D67 =MAX(H5:H64) / =LARGE((H5:H64),1) 1 2  Correct cells used  1  Max / large function used  3.9 Cell D69 =SUMIF(E5:E64,"China",L5:L64) 1  Sumif function correctly used  1 4  Criteria range E5:E64  1 1  Sum range L5:L64   Criteria – China  Copyright reserved Please turn over

6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) 3.10 Cell D71 =(H5*J5)*K5 1  H5 and J5 used  3 1  * sign used  1  K5  3.11 Cell D73 =COUNTBLANK(L5:L64) 1 2  Correct function used  1  Correct range used  3.12 Cell D75 =COUNTA(N5:N64) 2  Correct function used  1  Correct range used  1 3.13 Cell D77 =IF(L5>=3000,"Type A Accommodation","Regular Accommodation")  Correct function used  1 4  Correct condition specified  1  Value if true is correct  1  Value if false is correct  1 3.14 Cell D79 =L5/G2 2  Countif function used  1  Correct range  1 3.15 Cell Q5 =IF(COUNTA(M5:P5)>3;(0,3*H5);IF(COUNTA(M5:P5)=3; (0,15*H5);” “))  Function = IF  1  First condition: (COUNTA(M5:P5) >3  1 1 7  1,3*H5   Second condition: COUNTA(M5:P5)=3  1  1,15*H5  1  Value false condition: “ “ or Blank  1  Function copied to all cells  1 Lodge worksheet 3.16 Tab colour  Tab colour of Lodge worksheet set to blue  1 1 3.17 Filtering  Filtering used  1 2  on Type of Accommodation column  1 Copyright reserved Please turn over

(EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 7 3.18 Graph Worksheet  Sort table from Large to Small  1  Graph created  1 5  Graph title Wild Coast Lodges  1  Both series points plotted correctly.  1  Gap width set to 50%  1 Total for QUESTION 3 [53] Copyright reserved Please turn over

8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) QUESTION 4 File Name: 4WildCoast Total Q4: 34 Maximum Candidate No. Criteria Mark Mark 4.1.1 Row height 1 1  Row height set at 25 pt.  4.1.2 Row colour  Alternative row colour set to red.  1 2  Background colour set to green.  1 4.1.3 Field: Cell Number  Input mask set.  1 3  Ten compulsory numbers.  1  Correct format 000-0000 000.  1 4.1.4 Field: Cell Number 1 1  Cell Number field is set to Yes.  4.1.5 Field: Age 1  Validation rule: Between 18  1 3  And 60.  1  Suitable validation text inserted.  4.1.6 Field: Deposit Paid 1  Changed to currency.  2 1  With 2 decimal places.  4.1.7 Field: Home Combo box created in Home Town field.  1 Value list added.  3 1 All towns included (Port Elizabeth/East 1 London/Mthatha/Queenstown).  4.1.8 Field: email address 1 1  < symbol set on format  Form 4.2 Visitors Info  Form Visitors Info created.   Only Visitor, Gender, Email address, Country, 1 Number of people, Number of days and Deposit 1 field appear.  1  Image 4WildCoast.jpg used.  1  Centred in form header.  1 9  Date and time inserted.  1  Country field sorted alphabetically.  1  In descending order.  1 1  Any button inserted in the form footer.   Button action is to close the form.  Copyright reserved Please turn over

(EC/NOVEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 9 Queries 4.3 QryFemales  Fields used: Visitor, Deposit and Gender.  1 1  Gender does not show.  1 1  Gender criteria: Female.  1 5  Deposit criteria: >=  3200.  4.4 Qry4_4  Criteria of Country field: Russia.  Design view  Total function is used.   From the datasheet view.   Total deposits of the Russian visitors. (Sum)  1 1 1 4 1 Total for QUESTION 4 [34] Copyright reserved Please turn over

10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/NOVEMBER 2020) QUESTION 5 File Name: 5WildCoast Resource Total Q5: 13 Maximum Candidate No. Criteria Mark Mark 5.1 Export Data  Data exported from Spreadsheet 5WildCoast 1 Resource.  1  Exported to a new database – table - 5Resource.  1 6  Peak Rates, Number of Days and Deposits are assigned the correct data type.  1  Type of Accommodation moved to the first field.  1  Table sorted by Type of Accommodation field.  1  In descending order.  5.2 Graph  Graph created using the data in Sheet 2.  1  Countif: Females.  1  Countif: Males.  1  Pie Graph is used  7 1  Appropriate heading – anything around percentage per gender.  1  Graph is moved to the word document, 5MyDoc.  1  Paste special is used when pasting the graph.  1 Total for QUESTION 5 [13] TOTAL 150 Copyright reserved Please turn over