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.
Skip to contentAll 2016 papers 





View all





Computer Applications Technology Grade 12 P1 2016 Memo (Eng)
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.
Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2016. Memorandum, 9 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2016
- Exam period
- Eastern Cape Mock Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 9
- File size
- 451.6 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 9
This exam
Eastern Cape Mock Exam 2016
Questions in this paper
Document textSearch extracted text and jump to a page.
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
Recommended for this subject

Question paper
Computer Applications Technology Grade 12 P1 2016 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P1 2016 QP (Afr)

Memorandum
Computer Applications Technology Grade 12 P1 2016 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P1 2016 Memo (Afr)

Memorandum
Computer Applications Technology Grade 12 P1 2016 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P1 2016 Memo (Afr)
More from Grade 12 Computer Applications Technology

Question paper
Computer Applications Technology Grade 12 P1 2025 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P2 2025 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P1 2024 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P1 2024 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P2 2024 QP (Eng)

Question paper