Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
SEPTEMBER 2014
COMPUTER APPLICATIONS TECHNOLOGY P1
MEMORANDUM
NAME OF CANDIDATE: GRADE:
SIGNATURE OF EDUCATOR:
TOTAL Q1 Q2 Q3 Q4 Q5 Q6 Q7
MARKS: 180 34 15 27 24 40 20 20
This memorandum consists of 9 pages.
Skip to contentAll 2014 papers 





View all





Computer Applications Technology Grade 12 P1 2014 Memo (Eng)
Grade 12 Computer Applications Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2014 (English), 9 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2014. Memorandum, 9 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2014
- Exam period
- Eastern Cape Mock Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 9
- File size
- 385.3 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 9
This exam
Eastern Cape Mock Exam 2014
- Paper 1Question paperMemo
- Paper 2Question paperMemo
- Other filesMemo
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
2 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2014)
QUESTION 1 File: Q1_ID
No. Criteria Max. Mark
Open the file Q1_ID
1.1 Heading Identity Document formatted to Bold and Dark
2
blue text colour
1.2 Picture inserted and formatted as follows:
Picture labelled smart id used
Picture centre aligned and text wrapped 5
3pt border added
1.3 Subheadings on page 1 and 2 formatted to style
2
Heading 1
1.4 New style created and formatted as follows:
New style Register elections created
Style based on Heading 2
Comic Sans size 16 used
Blue paragraph border
With pink background 6
New style set to change automatically
1.5 Table of Contents created and modified as follows:
Formatted text with Modified Heading 1 style
Page numbers not shown
6
Hyperlinks is shown instead
Only one level shown
Modern style used
1.6 Footer added
“Quote by Mandela” added
4
Automatic page numbering added
Not on cover page
1.7 Cover page added, any style
2
Main heading of the document
1.8 Paragraph spacing for the entire document changed to 12pt
2
after each paragraph
1.9 “Copy” watermark inserted
2
Horizontally displayed
1.10 Word “identity” replaced with word “ID” in all occurrences
Appear in red font (13 replacements) 3
[34]
Downloaded from hlayiso.com
(SEPTEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 3
QUESTION 2 File: Q2_Brochure
No. Criteria Max. Mark
Open the file Q2_Brochure
2.1 Margins changed to narrow 1
2.2 Document formatted as follows:
Orientation Landscape
Column break inserted as indicated on Annexure 4
Insert columns with a line between
Column width 8.22 cm and spacing 1.25 cm
2.3 6pt
Art border inserted 3
whole page
2.4 Electronic form in the 3rd column formatted as follows:
Table inserted
13 columns and 1 row to 0.4 cm
Text form field added to “Municipality”
Drop down list added to Province 6
Edit list to “Western Province”, “Eastern Province”,
“Gauteng”, “Kwazulu-Natal” and “Northern Cape”
Check box added to the sentence “You are eligible …”
2.5 Pictures are grouped as one object 1
[15]
Downloaded from hlayiso.com
4 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2014)
QUESTION 3 File: Q3_Budget
No. Criteria Max. Mark
Open the Wards_2014 worksheet.
3.1 Width of all cells have been adjusted 1
3.2 Red Colour of sheet Wards_2014 changed to Blue 1
3.3 Hyperlink of thumb.jpg image inserted in cell A1
2
3.4 Cell K2 =(F2-K1)*24-3
Formula: =(F2-K1) *24 3
- 3 hours for lunch breaks
3.5 Cell K22 =SUM(K2:K20)*45.25
=SUM(K2:K20) 2
Correct value used: 45.25
3.6 Cell C2
=LOWER(CONCATENATE(LEFT(A2,2),"*",RIGHT(B2,3)))
Function: =LOWER
(CONCATENATE) 5
"*"
LEFT(A2,2)
RIGHT(B2,3)
3.7 Cell H2 =D2*G2 1
3.8 Cell J2 =H2-I2
2
Auto fill down to Cell J22
3.9 Cell D25 =COUNTA(A2:A20)
Function = COUNTA 2
Range (A2:A20)
3.10 Conditional formatting to Range I2:I20
2
Red font
Underlined (yellow)
3.11 Cell D26 =RANDBETWEEN(10,20)
Function: =RANDBETWEEN 2
(10,20)
3.12 Cell H27
=IF(D2<=69,G2*8%,G2*12%) 3
3.13 SA Currency added to Column G, H and I 1
[27]
Downloaded from hlayiso.com
(SEPTEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 5
QUESTION 4 File: Q4Ward_Reps
No. Criteria Max. Mark
Open the Ward_Reps worksheet.
4.1 Displayed cellphone number correctly in Range D3:D28
Format Cells to Custom and
Insert 0##########
Or set as Text
2
4.2 Cell F3 = E3*$L$2 (Correct cells used)
Multiplication used 3
Absolute Reference used in $L$2 only
4.3 Cell E33 = SUMIF(A3:A28,"Ward Fynbos",E3:E28)
Function: SUMIF
Range: A3:A28 4
Ward Fynbos Ward: "Ward Fynbos"
Range: E3:E28
4.4 Cell C35 =COUNTIF(C3:C28,"F")
Function: COUNTIF 2
Criteria: F
4.5 Cell D36 =COUNTBLANK(D3:D28)
Function: COUNTBLANK 2
RANGE: D3:D28
4.6 Cell J12: =VLOOKUP(B12,V_Lookup!A2:B27,2,FALSE)
Function: VLOOKUP
lookup_Value: B2
5
table_array: V_Lookup!A2:B27
index_num: 2
range_lookup: FALSE
4.7 Create 3D Pie Chart:
3D-Pie chart created
Data labels display as percentage
Chart Title – Youth-2014 6
Chart Title – bold italic
Chart Title – Strike through effect added
Chart Title – Yellow solid fill
[24]
Downloaded from hlayiso.com
6 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2014)
QUESTION 5 File: Q5_Reps Info
No. Criteria Max. Mark
Open the Ward_Reps table.
5.1 Contact No field formatted as follows
Data type: Text 3
Input Mask: "0"000000000
5.2 New field added:
Above Ward Representative 2
New Field name Title
5.3 Drop down list added
Row source type: Value List 3
Row source: “Mr”, “Mrs”, “Prof”
5.4 Table sorted in ascending order of Ward Representative
1
field
5.5 Computers field renamed to Computer Skills
2
NB: Caption used instead of rename function
5.6 Format Ward field to Capital Letters
1
Format: >
5.7 Validation rule and Text added to Gender field
Gender field formatted
Validation Rule: “F” or “M”
Any validation text acceptable
3
5.8 Primary Key set on Ward ID field 1
5.9 T-Shirt costs field moved to after T-Size field 1
Open the Ward_Reps query.
5.10 Query modified as follows: (3 records displayed)
Gender: M
Computers: Advanced
Medical Aid: Yes
3
Downloaded from hlayiso.com
(SEPTEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 7
5.11 Query created based on Accommodation table
Query name: Voters Accom
3
Show all database fields
Contact number field hidden
5.12 Calculated field added:
Field Name: Deposit
Calculate 25% of the
Rate field
Display as Rand 4
Open the form MyVote
5.13 Logo inserted:
5.13.1 Insert SA Flag logo in the header top right 1
5.13.2 Image resized to 4 cm x 4 cm 1
5.13.3 Background colour of all form fields to yellow 1
5.14 T-Shield Size field converted to combo box
Change to Combo Box
Data Row Source Type changed format to 4
Value List
Edit List to “S” “M” “L” “XL” “XXL”
Open the Report Total Costs
5.15 Report modified as follows:
Changed page orientation to Landscape
Today’s date displayed on the page footer
6
Report grouped according to the T-Shirt size
Sorted by Ward Representative of field
Calculate the Total T-Shirt cost per group
[40]
Downloaded from hlayiso.com
8 COMPUTER APPLICATIONS TECHNOLOGY P1 (SEPTEMBER 2014)
QUESTION 6 File: Q6Webdesign
No. Criteria Max. Mark
Use the application program Notepad
6.1 The title of the web page is “Election Help”. 1
6.2 Heading “IEC” should be centre align horizontally 1
6.3 Insert the image called IEC.jpg
above the IEC Heading 3
Right align
6.4 Format the paragraph heading “when can I register::
font face: comic sans
3
size: 6
colour: green
6.5 “You must be” to an upper case alphabetical list.
A. be a South African citizen
2
B. be at least 16-years-old
C. and have a green, bar-coded ID book
6.6 Insert a hyperlink to the isiXhosa.pdf and
“Important”
4
6.7 Format the table (position)
a caption “ACCOMMODATION” should display
table headers should be bold
6
table data should be entered correctly
[20]
Downloaded from hlayiso.com
(SEPTEMBER 2014) COMPUTER APPLICATIONS TECHNOLOGY P1 9
QUESTION 7 File: Q7_Intergration
No. Criteria Max. Mark
Open the file Q7_Intergration
7.1 7.1.1 numbering x of y on the right hand side of the footer
2
start on the 2nd page.
7.1.2 Date added correctly and must update
2
automatically
7.2 7.2.1 Correct data exported
Export Totals to Rich text 3
Renamed to Q7_export
7.2.2 Import Register spreadsheet to new table.
Rename table Import 4
Save correctly
7.3 7.3.1 Merge fields Name and Surname added
2
7.3.2 Letters sorted in ascending order by name. 1
7.3.3 Mail merge completed
2
7.4 7.4.1 Track changes accepted 1
7.4.2 Track changes turned off 1
7.4.3 Income renamed to Egos_Income 1
7.4.4 Comment in CELL C4 deleted. (Egos_Income sheet) 1
[20]
TOTAL: 180
Study this subject
Recommended for this subject

Memorandum
Computer Applications Technology Grade 12 2014 Memo (Afr)

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

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

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

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

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