Skip to content

Computer Applications Technology Grade 12 P1 2016 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 1220169 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2016 (English), 9 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 2016 COMPUTER APPLICATIONS TECHNOLOGY P1 MEMORANDUM NAME OF CANDIDATE: ____________________ GRADE: _________ SIGNATURE OF EDUCATOR: ____________________ TOTAL Q1 Q2 Q3 Q4 Q5 Q6 Q7 MARKS: 180 32 18 50 15 33 20 12 This memorandum consists of 9 pages.
Downloaded from hlayiso.com 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2016) QUESTION 1 File Name: 1_Heart Info No Criteria Max  Mark 1.1 1.1.1  Small caps effect added to the abstract on the cover 1 page. 1.1.2  Soft edge rectangular picture style given to the picture 1 on the cover page.  1.2  6pt spacing added before and after for the whole document. 1 1.3  Condensed spacing applied to the heading 'What Is Heart Attack…'  2  Spacing is 1pt  1.4  Inserted a non-breaking hyphen between the numbers instead of an ordinary hyphen.  2  Inserted two times i.e. between 9-1-1. 1.5  Automatic caption added for the image.  2  Placed above the image.  1.6  Footnote inserted with any symbol.  2  Footnote reads as 'Prescribed'.  1.7  'Happy Heart' style applied.  2  To all the three paragraph headings shaded in green.  1.8  Multilevel numbering used  Level 1 is 1)…  3  Level 2 is a)…  1.9  Three paragraphs placed in 3 columns  With a line between  Equal column width of 0.5 cm 4  Applied column breaks to paragraph headings to start from the top.  1.10  Name of the author inserted as 'James Beckerman' in the citation.   Citation updated in the document to include the name of the 2 author as well.  1.11  Section break included and changed the page layout to 1 landscape.  1.12  Table of Contents inserted on the second page of the document.   Format used is 'Distinctive' 3  Only the three styles 'Love Heart', 'Heart Care', and 'Happy Heart' included in the TOC.  1.13  Automatic page numbering inserted in the footer  In any format  No page numbers appear in the first and last page 5  Page numbering starts from 1 onwards 1.14  Left and bottom margins set to 1.5 cm.  1 TOTAL FOR QUESTION 1 [32] Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2016) COMPUTER APPLICATIONS TECHNOLOGY P1 3 QUESTION 2 File Name: 2_Heart Aware No Criteria Max  Mark 2.1  Text shading added to the heading 'Am I aware' 2  Any colour 2.2 Text form field for the heading 'Surname' formatted  To accommodate 20 characters 2  And to display in CAPITAL letters  2.3 Age field formatted so that  It accepts 2 digits  Help text added to the F1 key 3  The message reads ' Enter numbers between 20 and 70'  2.4  Check box form added to Male and Female option  Check box size is exactly 15 pt.  2 2.5  Smoking option added to the existing list.   And moved to the top of the list.  2 2.6  Smoking and Fatty Diet grouped  as a single object with the rest of the shapes 2 2.7  10 cm tab set  Dashed line leader tab set for 4 lines 2 2.8 Formula inserted as follows 𝑊𝑒𝑖𝑔ℎ𝑡 𝐵𝑜𝑑𝑦 𝑀𝑎𝑠𝑠 𝐼𝑛𝑑𝑒𝑥 = 3 𝐻𝑒𝑖𝑔ℎ𝑡 2  TOTAL FOR QUESTION 2 [18] Copyright reserved Please turn over
Downloaded from hlayiso.com 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2016) QUESTION 3 File Name: 3_Heart Stat No Criteria Max  Mark Patient Details worksheet 3.1 Cell O1: 1  Cell O1 formatted to display only the current time.  3.2  Cells A1:L1 merged and centred.  1 3.3 Cell A2:  3_Heart Beat.jpg inserted in cell A2 3  Height is 1 cm  Width is 15 cm 3.4 Cell A5: =CONCATENATE(LEFT(B5,1),LEN(C5),E5) OR =LEFT(B5,1)&LEN(C5)&E5  CONCATENATE function OR & sign 6  LEFT  (B5,1)   LEN  (C5)   E5  3.5 Cell H5: =G5/((H5/$O$2)*(H5/$O$2)) OR =G5/POWER((H5/$O$2),2)  G5  5  (H5/$O$2)*(H5/$O$2) OR POWER Function   Absolute cell reference used   Formatted to zero decimal places (Note to marker: Accept any other suitable method.) 3.6 Conditional formatting:  Top three values shaded 3  Thin horizontal crosshatch pattern style applied  Yellow pattern colour used 3.7 Cell N5: =VLOOKUP(I5,'BMI Category'!$A$5:$B$12,2,TRUE)  LOOKUP value: I5  Table array: 'BMI Category'!$A$5:$B$12  Absolute cell reference  6  Column index number: 2  Range_Lookup: TRUE  Copied down for the rest of the cells Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2016) COMPUTER APPLICATIONS TECHNOLOGY P1 5 3.8 Cell G26: =COUNTIFS(F5:F24,F5,M5:M24,M21)  COUNTIFS function   Range: F5:F24   Criteria: F5 OR 'Male'  5  Range: M5:M24   Criteria: M21 OR 'YES'  (Note to marker: Accept any other suitable method.) 3.9 Cell G28: =COUNTBLANK(K5:K24) 2  COUNTBLANK   (K5:K24)  3.10 Cell G30: =ROUND(AVERAGE(O5:O24),0)  ROUND function  4  Average function   Range (O5:O24)   Zero decimal places  3.11 Cell G32: =SUMIF(F5:F24,F6,O5:O24) OR =SUMIF(F5:F24,"Female",O5:O24)  SUMIF function  4  Range F5:F24   Criteria Female or any cell number that contains the value female   Sum range O5:O24  3.12 Cell P5: =IF(J5>=120,"Most Likely",IF(J5<80,"Not Likely","Least Likely"))  IF function   Condition J5>=120 and value  5  Condition J5<80 and value   Value if all conditions are false   Correct use of open and closing brackets  3.13 Graph  Data label added to the highest value in the graph.   Highest data bar filled with the image 3_Overweight.jpg   Black outline applied to this data bar  5  X axis values displayed in the reverse order.   Vertical gridlines displayed for both major and minor units.  TOTAL FOR QUESTION 3 [50] Copyright reserved Please turn over
Downloaded from hlayiso.com 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2016) QUESTION 4 File Name: 4_Heart Patients No Criteria Max  Mark Table: Patient Details 4.1  Row height changed to 20 pt.  1 4.2  Vertical gridlines are visible.  1 4.3 Customised alternate row colour  Colour level for Red is 200  3  Colour level for Green is 210   Colour level for Blue is 220  4.4 Age column  Average of ages found at the bottom of the age column.  2  Corrected to zero decimal places.  4.5 Input mask on the Patient Code field: >LL-009-"LPH"  >  LL   - 6  00   9  LPH  4.6  Patient code field made as the primary key.  1 4.7  Data type for 'Money spent on junk food' field changed to 1 currency.  TOTAL FOR QUESTION 4 [15] Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2016) COMPUTER APPLICATIONS TECHNOLOGY P1 7 QUESTION 5 File Name: 5_Heart No Criteria Max  Mark Table: Patient_History 5.1 Patient_History table:  Applied a black gridline and  2  Sunken cell effect to the table.  5.2 5.2.1 Validation rule to gender field:  Male  or Female  3 Validation message to gender field:  Any appropriate message  5.2.2 Change the Indexed field properties to Yes (Duplicates 1 OK)  5.3 Age field made a required field.  1 5.4  Name, Age, Height (in cm), Body Mass (in kg) and BMR fields are displayed.   Calculated field name: BMR:  7  BMR: 655.0955+ (9.5634 * [body mass (in kg)] ) + (1.8496*[height (in cm)] ) - (4.6756*[age] )  All the signs used correctly.  5.5  Criteria Blood Pressure (Systolic) field: >120  6 OR >=119  Criteria Blood Pressure (Diastolic) field: Between 90 And 95  Criteria Suggested Action field: "*medical attention" 5.6  Name, Gender, Sugar Level and Risk fields inserted   Heading changed to Patient Sugar Levels  Dividing lines are visible.  6  Default form view changed to continuous  5_Sugar Level.jpg inserted in the detail section  Height and width of the image is 5 cm  5.7  Report created based on qry5_7   Report grouped based on Sugar Level (mmol/L) field.   Grouping intervals set to 10s  Conditional formatting applied to Risk field with patients with 7 Very High  risk shaded in red colour   =count(*) calculation used in the group footer  Proper label given for the calculation. TOTAL FOR QUESTION 5 [33] Copyright reserved Please turn over
Downloaded from hlayiso.com 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2016) QUESTION 6 File Name: 6_Healthy Heart 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. No Criteria Max  Mark 6.1 Title <title>Healthy Heart</title> 2  'Healthy heart' appears   In the browser tab  6.2 Font tag <font face="century gothic" size="3"> </font> 2  font face is century gothic   font size is 3  6.3 Heading style <h1 align="center">Heart Disease & You</h1> 1  Heart Disease & You appear as heading 1  6.4 Bold and Italics formatting <b><i>Cardiovascular Disease</i></b>  Cardiovascular Disease made Bold  2  Cardiovascular Disease made Italics  NOTE: Reduce 1 mark if tags are not closed in the reverse order. 6.5 Horizontal line size and colour <hr color="black" size=3 /> 2  Line size set to 3   Line color set to black  6.6 Table Row and Column: <tr bgcolor="White"> <th> Blood Pressure Category </th> <th> Systolic mm Hg (Upper #) </th> <th> <img src="6_Heart Pressure.jpg"> </th> <th> Diastolic mm Hg (Lower #) </th> </tr>  Image appears as the third heading in the first row  Image displays correctly  ------------------------------------------------------------------------------ <tr bgcolor="red"> 6 <td>Hypertensive Crisis (Emergency care needed)</td> <td>Higher than 180</td> <td>or</td> <td>Higher than 110</td> </tr>  Row added at the bottom of the table.   All the relevant text entered correctly in the row.   Background colour of the row changed to red.   All the tags used correctly.  Copyright reserved Please turn over
Downloaded from hlayiso.com (EC/SEPTEMBER 2016) COMPUTER APPLICATIONS TECHNOLOGY P1 9 6.7 Ordered List <ol type="A"> </ol> 2  Existing unordered list changed to ordered list.   List numbers appears as uppercase alphabets, e.g. A, B.  6.8 Link <a href ="Healthy life style.pdf"> Click here to view the TIPS on how to live a Healthy Life Style provided by THE HEART 2 AND STROKE FOUNDATION SOUTH AFRICA </a>  Link moves to ' Healthy life style.pdf '   Link works correctly 6.9 Center tag <center> Have Your Heart In The Right Place </center> 1  The text is centred using the centre tag  TOTAL FOR QUESTION 6 [20] QUESTION 7 File Name: 7_Food Diary 7_CHD Death Rates 7_Awareness No Criteria Max  Mark 7_Food Diary (Word processing document) 7.1 7.1.1  First two cells in the last row merged  1 7.1.2 Formula used in the shaded region =SUM(ABOVE) 2  SUM function used   Criteria is ABOVE  7.1.3 Organogram  Shape added before the shape name Fruits  2  New shape given the name Healthy Protein  7.2 7.2.1 Death rates worksheet  Graph edited to include South Africa as well  2  All the data values displayed correctly  7.2.2 Cell G7: ='Death Rates'!B7 2  'Death Rates'!   B7  7_Awareness (Word processing document) 7.3 Mail Merge:  Patient Details table in 4_Heart Patients database used as the data source.   Name and Surname fields added.  3  Mail merge completed and saved as 7_AwarenessInvitation  (22 letters expected) TOTAL FOR QUESTION 7 [12] TOTAL: 180 Copyright reserved Please turn over

Study this subject

More from Grade 12 Computer Applications Technology

View all