Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
SEPTEMBER 2017
COMPUTER APPLICATIONS TECHNOLOGY P1
MEMORANDUM
NAME OF CANDIDATE: GRADE:
SIGNATURE OF EDUCATOR:
TOTAL Q1 Q2 Q3 Q4 Q5 Q6 Q7
MARKS: 180 36 14 52 42 20 10 06
This memorandum consists of 9 pages.
Skip to contentAll 2017 papers 

_hlayiso.com_--f13e52b1-d03e-4ce0-9cbb-fd83efd28130/v1-8ef7c28c9e52e80e7e56/card.webp)
_hlayiso.com_--c01cc76d-6be5-4f8e-b0dd-c7487e06934f/v1-34719e235a0428d8db32/card.webp)


View all





Computer Applications Technology Grade 12 P1 2017 Memo (Eng)
Grade 12 Computer Applications Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2017 (English), 9 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2017. Memorandum, 9 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2017
- Exam period
- Eastern Cape Mock Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 9
- File size
- 577.6 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 9
This exam
Eastern Cape Mock Exam 2017
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2017)
QUESTION 1 File Name: 1_Turtle Facts
No Criteria Max Mark
1.1 Left and bottom margins set to 1.5 cm. 1
1.2 1.2.1 Heading “Save The Sea Turtles” added in the title
1
control on the cover page.
1.2.2 AutoShape filled with the image 1_Save The Turtle
Height and width set to exactly 8 cm. 3
1.3 Condensed spacing applied to the heading “BASIC
FACTS ABOUT SEA TURTLES”. 2
Spacing is 1.5 pt.
1.4 Drop Cap effect applied to the highlighted letter “S”
dropped over 4 lines. 2
Distance from the text is 0.5 cm.
1.5 Style
Yellow font colour applied to the existing style
“Sub Turtle”. 2
The rest of the text with the existing style is updated
automatically.
1.6 Columns
Highlighted paragraphs placed in 2 columns with a line in
between.
3
Column spacing is set to 1.5 cm.
Applied column break after the first paragraph so that the
other three paragraphs are moved to the second column
1.7 Glow effect applied to the text box. 1
1.8 Existing footnote changed to an endnote.
2
Endnote symbol changed to ‘*’ symbol.
1.9 Cell spacing of the table changed to 0.5 cm
Count
3
(Above) function used
(Answer 7 – no marks if the answer is just typed)
1.10 Multilevel bullets applied to the list under the heading
Glossary (not just as a bullet).
Bullet 1.jpg used as first level. `3
And Bullet 2.jpg as second level respectively.
1.11 Bibliography
Month edited and changed to August.
2
Comment inserted that reads Save Sea Turtles.
NB: check if it is updated in the bibliography as well.
1.12 Page orientation
1
Orientation of only the last 2 pages changed to landscape.
1.13 Table and Image caption
Outer table border changed to dashed line.
Thickness is 4½ pt. 3
Caption inserted to the correct image and it reads “Green
Sea Turtle”.
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2017) COMPUTER APPLICATIONS TECHNOLOGY P1 3
1.14 Inserted section break for the last 2 pages.
Page numbering applied in any format in the page
header. 3
Numbering starts from 1 onwards.
1.15 Hyperlink added to the word TOP OF THE DOCUMENT.
Linked created to the top of the document. 2
1.16 Watermark inserted only on the cover page (any correct
method can be awarded marks). 2
Watermark reads Billion Baby Turtles.
Total for QUESTION 1 [36]
QUESTION 2 File Name: 2_Observation Form
No Criteria Max Mark
2.1 Paragraph shading added to the heading "Sea Turtle
Observation Form”. 2
Any shade of green colour.
2.2 Text form field for the heading “How many turtles…”
formatted:
2
To accommodate 2 characters,
with no decimals places displayed.
2.3 “Select One Below” option added to the existing list.
2
That appears as the first option in the list.
2.4 Date field changed to d MMMM yyyy format. 1
2.5 Image cropped to resemble as follows:
1
2.6 Help text added to the cell number field.
Text “Please Enter only 10 Digits” entered correctly. 2
2.7 14 cm right aligned tab applied
With solid leader tabs 2
NB: reduce 1 mark if not done for all the three headings.
2.8 Screentip for the email address
2
To read as “Help Us To Save SEA Turtles”
Total for QUESTION 2 [14]
QUESTION 3 File Name: 3_Turtle Campaign
No Criteria Max Mark
Info worksheet
3.1 Cell H1:
1
Date in cell H1 changed to dd mmm YY format.
3.2 Cells A1:G2 merged and centred. 1
Copyright reserved Please turn over
Downloaded from hlayiso.com
4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2017)
3.3 Cell A3:O3 :
Thick cell borders applied. 2
Left and right borders of the cells changed.
3.4 Row 3 freezed 1
3.5 Cell A4:
=CONCATENATE(B4,LEN(E4),"#code")
OR
=B4&LEN(E4)& "#code") 5
CONCATENATE function OR & sign
B4
LEN (E4)
“#code”
3.6 Cell H4:
=ROUNDUP(($H$1-G4)/365.25,0)
ROUNDUP function
Use of correct cells H1 and G4
Minus sign (-) used correctly 6
Divided by 365.25 (or 365)
Absolute cell reference used
Formatted to zero decimal places
(Note to marker: Accept any other suitable method.)
3.7 Cell N20:
=(I20)*$I$2+(J20)*$J$2+(K20)*$K$2+(L20)*$L$2+(M20)
*$M$2
OR
=I20*$I$2+J20*$J$2+K20*$K$2+L20*$L$2+M20*$M$2
Values from I20:M20 correctly multiplied with values in 3
I2:M2
+ sign used correctly between the cells
Absolute cell reference used
(Answer: R200)
3.8 Conditional formatting:
3
Values between 200 and 250 shaded
2 colour shading applied
3.9 Cell O4:
=IF(($P$1-N4)<=0,"Adoption Cert",IF(($P$1-N4)>100,
"Participation Cert","-"))
IF function
Condition ($P$1-N4)<=0 and value 6
Condition ($P$1-N4)>100 and value
Value if all conditions are false
Absolute cell reference used
Correct use of open and closing brackets
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2017) COMPUTER APPLICATIONS TECHNOLOGY P1 5
3.10 Cell E51:
=SUMIF(E4:E49,E5,N4:N49)
OR
=SUMIF(E4:E49, “Platinum”,N4:N49)
SUMIF function
4
Range E4:E49
Criteria Platinum or any cell number that contains the
value Platinum
Sum range N4:N49
(Answer: R1 640)
3.11 Cell E52:
=COUNTIF(F4:F49,F6)
OR
=COUNTIF(F4:F49, “SEE Turtles”)
COUNTIF function 3
Range F4:F49
Criteria SEE Turtles or any cell number that contains
the value SEE Turtles
(Answer: 8)
3.12 Cell E53:
=AVERAGEIF(D4:D49,D33,C4:C49)
OR
=AVERAGEIF(D4:D49, “F”,C4:C49)
AVERAGEIF function 4
Range D4:D49
Criteria F or any cell number that contains the value F
Average range N4:N49
(Answer: 17.3)
3.13 Cell E54:
=COUNTBLANK(J4:J49)+COUNTBLANK(L4:L49)
COUNTBLANK function
3
Range J4:J49 and L4:L49
+ sign used correctly
(Accept any correct method – answer is 44)
Spotted worksheet
3.14 Cell B2:
=VLOOKUP(A2,LOOKUP!$A$1:$B$95,2,FALSE)
OR
=VLOOKUP(A2,LOOKUP!$A:$B,2,FALSE)
LOOKUP value: A2 5
Table array: LOOKUP!$A$1:$B$95
Absolute cell reference used
Column index number: 2
Range_Lookup: FALSE
Copyright reserved Please turn over
Downloaded from hlayiso.com
6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2017)
Graph worksheet
3.15 Graph
Data set for the year 2014 included in the graph.
Series overlapping is set at -50ͦ.
5
X axis name moved to the correct position.
Data labels displayed on top of each bar.
Minimum value for y axis set to 5.
Total for QUESTION 3 [52]
QUESTION 4 File Name: 4_Turtle Classification
No Criteria Max Mark
Table: Patient Details
4.1.1 Row height changed to standard height of 14.25. 1
4.1.2 Gridlines are changed to red colour. 1
4.1.3 The list Threatened moved
2
To the third position in the list.
4.1.4 Data type for the diet field changed to MEMO/Long Text
1
data type.
4.1.5 Scientific Name field:
Made as the required field 2
> symbol added in the format property field
4.1.6 Input mask for Turtle Id field:
L00\*9a
L
00 5
*
9
a
Turtle Images table and the frm4_2 form
4.2.1 Inserted the image Green sea turtle.jpg in the Turtle
Images table. 2
Displays in the form frm4_2 correctly.
4.2.2 Turtle images table exported to the exam folder.
Name of the file changed to Export4_2. 2
Query: qry4_3
4.3
Criteria
Total Species field:< 400 4
OR
<=399
Criteria
Diet field: Like "*jelly*" And Like "*crabs*"
(Answer: 3 records)
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2017) COMPUTER APPLICATIONS TECHNOLOGY P1 7
Query: qry4_4
4.4
Criteria
Turtle Name field: Between "G*" And "P*"
Between And function used 7
G* and P*
Sorted in the ascending order of Turtle Name field
Criteria
Weight in Pounds: Round
([weight(in kg)]/2.2046,1)
(Answer: 9 records)
Form: frm4_5
4.5 Border width of the image changed to 4pt.
Shadow effect applied to the image.
Command button inserted in the form footer to exit
the form. 6
Dividing lines are not visible.
Default form view changed to continuous.
Report: rpt4_6
4.6 Report rpt4_6 created based on Classification Table
Turtle Name, Tag ID, Colour, Weight (in kg) & Listed
As are the only fields displayed.
Report grouped based on Weight (in kg) field.
Grouping intervals set to 50s.
Page numbering changed as shown below so that it will
not be displayed in the first page of the report.
9
=Count (IIf ([listed as]="critically
endangered",0))
Proper label given for the calculation.
Total for QUESTION 4 [42]
Copyright reserved Please turn over
Downloaded from hlayiso.com
8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2017)
QUESTION 5 File Name: 5_Save Us
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
5.1 Title
<title> Save Sea Turtles </title>
2
‘Save Sea Turtle' appears
In the browser tab
5.2 Horizontal Line Size
<hr size="3" color="black"/> 1
Size changed to 6 that comes within the heading.
5.3 Image Tag
<img src="Baby Turtle.jpg" width="100%" height="45%"
alt="Baby Turtle">
Image tag added correctly
5
Image source is Baby Turtle.jpg
Width is 100%
Height is 45%
Alternate text is Baby Turtle
5.4 Bold formatting
<b>Seven</b> 1
Seven made Bold
5.5 Unordered List Type
<ul type="square">
2
Attribute used is type
Attribute value for type is “square”
5.6 Table Heading
<tr>
<th colspan="2">
<h1>Most Endangered Sea Turtles In The World</h1>
</th> 3
</tr>
<tr> </tr> new row added
<th> </th> tag added between the <h1> </h1> tag
Colspan=”2” added as an attribute to the <th> tag
5.7 Table Row color and font color:
<tr bgcolor="green">
<th><font color="white">Turtle Name</font></th>
<th><font color="white">Scientific Name</font></th>
2
</tr>
bgcolor attribute added after the <tr> tag to green
<font> </font> added for both the headings with white
colour attribute.
5.8 Caption tag
<centered><caption>Table 1:List Of Endangered Turtle
Species</caption></centered>
3
Caption tags used correctly
Aligned to the bottom of the table
Text inserted correctly and centred
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2017) COMPUTER APPLICATIONS TECHNOLOGY P1 9
5.9 Link
<a href="http://www.SEETURTLES.org"
target="_blank">SEETurtles.org</a> 1
The hyperlink tag corrected to add the attribute href
before the website link.
Total for QUESTION 5 [20]
QUESTION 6 File Name: 6_Spotted By & Scientific Info
No Criteria Max Mark
6.1 Spotted By & Scientific Info worksheet
1
Worksheets 2 and 3 hidden
6.2 Find and Replace
Find and replace option used or any appropriate
method 2
turtle changed to TURTLE in uppercase
(NB: -1 if not done fully)
6.3 Unique name
used conditional formatting to find the unique values in
2
the column
Name of the person is Taylor
6.4 Sorting
Sorted first based on the Scientific name field in the
descending order 3
Then in the ascending order of Spotted By field
Name of the turtle is Black Marsh Turtle
6.5 Password
Cells A1:D1 protected
2
With password 2017
(NB: award zero marks if the whole worksheet is protected)
Total for QUESTION 6 [10]
QUESTION 7 File Name: 7_Winners List 7_Certificate
7_Certificate (Word processing document)
No Criteria Max Mark
7.1 Mail Merge:
Winners worksheet in 7_Winners List spreadsheet
used as the data source.
Placeholders linked with appropriate fields.
In correct position
Edited the recipient list to include all the Platinum 6
Members and who achieved an adoption
certificate.
Saved the merged letter as 7_CertificateMerged in the
exam folder
(4 letters expected)
Total for QUESTION 7 [6]
TOTAL: 180
Copyright reserved Please turn over
Study this subject
Recommended for this subject

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

Question paper
Computer Applications Technology Grade 12 P1 2017 QP (Eng)
_hlayiso.com_--f13e52b1-d03e-4ce0-9cbb-fd83efd28130/v1-8ef7c28c9e52e80e7e56/card.webp)
Memorandum
Computer Applications Technology Grade 12 P2 2017 Memo (Afr)
_hlayiso.com_--c01cc76d-6be5-4f8e-b0dd-c7487e06934f/v1-34719e235a0428d8db32/card.webp)
Memorandum
Computer Applications Technology Grade 12 P2 2017 Memo (Eng)

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

Memorandum
Computer Applications Technology Grade 12 P1 2017 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