Skip to content

Computer Applications Technology Grade 12 P1 2020 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 12202012 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2020 (English), 12 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 SEPTEMBER 2020 COMPUTER APPLICATIONS TECHNOLOGY P1 MARKING GUIDELINE NAME OF CANDIDATE: ____________________ GRADE: _________ SIGNATURE OF EDUCATOR: ____________________ TOTAL Q1 Q2 Q3 Q4 Q5 Q6 MARKS: 180 35 15 56 42 21 11 This marking guideline consists of 12 pages.
Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020) QUESTION 1 File Name: 1_4th Industrial Revolution Total Q1: 35 Maximum Candidate No. Criteria Mark Mark 1.1.1 Cover Page 1 1  Year changed to 2020 using the text control.  1.1.2 Cover Page 1 1  And rotated 90 degrees.  1.2.1 Table of Contents 1  Text set to Normal Style  1 3  Only the text not heading changed  1  Text not in ToC anymore  1.2.2 Style 1  Style modified to blue  2  Spacing after paragraph set to 12pt  1 1.3 Find and Replace 1  All occurrences of 4th Industrial Revolution replaced by 4IR.  2 1  All occurrences (5 Occurrences)  1.4 Border 1  Yellow border applied   2pt border  1 3  an Offset Top shadow effect added to the 1 image  1.5 Picture 1  Picture has been wrapped tight, square or through   Moved to the right of the paragraph  1  Figure 2 has been moved below the picture  3 1 1.6 Endnote  Endnote inserted in the correct place  1  Text: “Founder and Executive Chairman of the 2 World Economic Forum” typed in  1 Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2020) COMPUTER APPLICATIONS TECHNOLOGY P1 3 1.7 Citation 1  Journal Article (source) used  1 3  Author Klaus Schwab inserted   Year 2020 inserted  1 1.8 Page setup 1  Section breaks inserted before and after page 5   Page 5 set to landscape  1 3  All other pages set to remain in portrait  1 1.9 Spell Check  Labor changed to labour  1 1 1.10 Paragraphs 1  Paragraphs sorted  2  In ascending order  1 1.11 Page numbering 1  Page numbering inserted  1  In the footer of the document   Centred  1 5  First two pages not numbered   Numbering starts on page 3 as page 1  1 1 1.12 Watermark 1  Watermark inserted   On the last page only  1  Text 4IR appear  4  Displaying horizontally  1 1 Total for QUESTION 1 [35] Copyright reserved Please turn over
4 Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020) QUESTION 2 File Name: 2_ 4IR Research Total Q2: 15 Maximum Candidate No. Criteria Mark Mark 2.1 Paper size  Top and bottom margins set to 1.5 cm  1  Size of the page set to 20 cm wide and 28 cm 2 high  1 2.2 Layout 1 Three columns created   Spaces between columns set to 1.1 cm  1  Highlighted text appears on top of each 4 column  1  Columns are justified  1 2.3 Table  Text is converted into a table with four columns  1  Grid Table 4 Accent 2 style applied to the table  1  Repeat header rows feature used to set table 5 headings appear on both pages in the table  1  All data in table centred, vertically   and horizontally  1 1 2.4 Paragraph  Shadowed border applied to the paragraph  1 2  Double line border style used  1 2.5 Date  Current date inserted in the footer of the 1 document  1 2  Updates automatically  Total for QUESTION 2 [15] Copyright reserved Please turn over
(EC/SEPTEMBER 2020) Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 5 QUESTION 3 File Name: 3_Resourcing Total Q3: 56  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 WardInfo worksheet 3.1.1 Merge and Centre  Cells A1 to O1 are merged  1  and centred  2 1 3.1.2 Fill  Any fill is applied to merged cells  1  Thin diagonal stripe pattern style fill effect applied  2 (accept any diagonal stripes) 1 3.1.3 Wrap Text  Row 3 wrapped 1 1 3.1.4 Panes 1  Freeze panes  2  Row 3  1 3.2 Comment 1  Comment inserted in cell E4  2  Text Unit Price displays  1 3.3 Text functions (Cell B5) =CONCATENATE(LEFT(A5;1); RIGHT(A5;2);LOWER(LEFT(C5;1))) 1  Correct function used (Concatenate or & function)   First letter of the Ward Name extracted 1 4  Last two letters of Ward Name   First letter of location in lower case 1 1 Copyright reserved Please turn over
6 Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020) 3.4 Cell K5 =SUM(E5:I5)  Formula: Sum  1 2  Range: (E5:I5)  1 3.5 Cell L8 =J8-K8  Correct cells used   Subtraction sign  1 2 1 3.6 M5 1 =E5/$E$4 1  Correct cells used  4  Division sign used  1  Absolute cell reference applied to cell E4   Formula copied to all other cells  1 3.7 Cell N6 1 =E6/K6*100 OR E6/K6 1 3  Correct cells used   Correct sign used  1  Set to a percentage with no decimal places  3.8 Conditional formatting 1  Conditional formatting used in column L   Cell value <0  1 3  Green fill with dark green text applied  1 3.9 Cell O5 =IF(L5<0;" ";"Bonus") 1  Function: IF  1  Condition: L5<0  4  Value if true is correct  1  Value if false is correct  1 3.10 Cell E37 =SUMIF(C5:C34;"Urban";J5:J34) 1  Function: Sumif  1  Criteria range C5:C34  4  Criteria - Urban  1  Sum range J5:J34  1 Copyright reserved Please turn over
EC/SEPTEMBER 2020) Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 7 3.11 Cell E39 =IF(AND(C7="Rural";N7>25);"Award";"No 1 Award")  Functions: IF and AND  1 4  Condition (C7="Rural";N7>25);   Value if true is correct  1  Value if false is correct  1 3.12 Cell E41 1 =COUNTIF(C5:C34;"Semi Rural") 1  Function: Countif  3  Range: C5:C34;  1  Criteria: "Semi Rural" 3.13 Cell E43 1 =VLOOKUP(A7;ExtraInfo!A2:C31;3;FALSE)  Function: Vlookup  1  Lookup value : A7  5  Lookup range : ExtraInfo!A2:C31 (ignore 1 if no absolute cell reference was used)  Row number : 3  1  Range lookup : False  1 3.14 Cell E45 =COUNTBLANK(E5:E34) 1 2 1  Function: COUNTBLANK   Range: (E5:E34)  3.14 Graph Worksheet  Graph title Readiness for 4IR  1  Both series points plotted correctly.   Any Stacked Bar graph used.  1  Vertical axis appears as in graph  1  Centred  7  Legend series added to top of graph  1  Move graph to the worksheet 4IR  1 1 1 Total for QUESTION 3 [56] Copyright reserved Please turn over
8 Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020) QUESTION 4 File Name: 4_4IR Total Q4: 42 Maximum Candidate No. Criteria Mark Mark Table: Wards 4.1.1 Field: WardName  > inserted in Format field property  1 1 4.1.2 Field: WardNumber 1  Required property set to Yes  2 1  Format of field set to 'Fixed' format  4.1.3 Image  Data type of Image field changed to OLE Object/ 1 1 Hyperlink  4.1.4 Validation <= 2020/06/30  OR < 2020/07/01 OR <=#2020/06/30# OR <#2020/07/01# 1 3 1  Any appropriate validation text that refers to the 1 limitation of the date 4.1.5 Devices Field 1  New field created Devices  1 3  Data type set to lookup value  1  Data on the Info table used  4.2 Form: frm4_2  Form frm4_2 based on WardInfo table and Columnar layout selected   Selected fields: WardName; WardNumber; Location; Budget; Expenditure and Balance  1 1  The background of the form header is yellow  1  Font size of heading is 36 pt  1  Heading is centred  1  4_Form.jpg picture inserted  1 10  In form header aligned right  1  Format of Budget field changed to Currency with 1 zero decimal places  1  Button inserted in form footer  1  Shows the next record when button is clicked  Copyright reserved Please turn over
EC/SEPTEMBER 2020) Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 9 4.3.1 Qry4_3_1 1  Only Location and Expenditure   Location: Total: Grouped by  1 3  Expenditure: Total: Sum  1 4.3.2 Qry4_3_2  Only Rural  1  and Semi-Rural records show   Total calculated  1 4  Total of Budget field  (SUM) 1 1 4.3.3 Qry4_3_3 Loan: 30/100*[Budget] 1 1  Criteria Balance : <0   Loan:  1 5  30/100  1  *[Budget]  1  Loan set to R currency  Report 4.4 1 Report4_4  Report created  1  Grouped according to Location and then according to Budget  1  Total budget for each Location calculated   in the Location footer = Sum([Budget])  1  Rural Locations are formatted red   New field Future Projections created . 1 10  Calculation of Future Projections   =10/100  1  *[Budget]   +[Budget]  1 OR =110/100*[Budget] 1 1 1 Total for QUESTION 4 [42] Copyright reserved Please turn over
10 Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020) QUESTION 5 File Name: 5_MyWebsite Total Q5: 21  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 Heading 1 <center><h1><font size="50" face="Century">THE 1 TIME HAS COME</font></h1> </center> 2  Heading is centred 1  Font size set to 50  5.2 Anchor 1 <a name="Top"></a>  Link tags correctly inserted  1 3  On words 'driver distraction'   Correct anchor name  1 5.3 Image <p align="center"><img src="5Pic.png" border="5"></p> 2  Extension for the image corrected  1  Image centred  1 5.4 Bulleted list <ul> </ul>  Ordered list <ul> created.  1 3  <li> </li> tags used correctly 1  Applied to all listed items  1 5.5 Table  Table colour is lightblue  1 2  Width of the table is 80%  1 Copyright reserved Please turn over
EC/SEPTEMBER 2020) Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY P1 11 5.6 Table row <tr> <th>AR</th> 1 <td>15</td> <td>34</td> 3 1 </tr>  New row added  1  Correct tags used   Correct data entered  5.7 Table row <td align="center" colspan="3"><b>Be Ready!! </b></td> 2  Row merged across three columns  1 1  Text changed bold  5.8 Link <a href="#Top">Back to top</a> 3  <a href> </a>  1  Link created on the text ‘Back to Top  1  Link moves to the top of website  1 Closing tag(s) or triangular brackets and correct nesting 1 1 correctly used Total for QUESTION 5 [21] Copyright reserved Please turn over
Downloaded from hlayiso.com 12 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2020) QUESTION 6 File Name: 6_Calculation, 6_Quote Total Q6: 11 Maximum Candidate No, Criteria Mark Mark 6.1.1 Date 1  Today’s date inserted  2  In this format: (2020)(03)(10)  1 6.1.2 Table 1  Table created   3 columns and 2 rows  1 4  Spacing between columns set  1  to 0.3 cm  1 6.2 Mail Merge  Recipients list filtered to send letters  1  to the Wards that have a negative balance <0  1  Insert Ward Names in the Ward Name field  1 5  Mail merge completed  1  Completed letters saved as Letters  1 (Expect 6 Letters) Total for QUESTION 6 [11] TOTAL 180 Copyright reserved Please turn over

Study this subject

More from Grade 12 Computer Applications Technology

View all