NATIONAL
SENIOR CERTIFICATE
GRADE 12
SEPTEMBER 2019
COMPUTER APPLICATIONS TECHNOLOGY P1
MARKS: 180
TIME: 3 hours
This question paper consists of 17 pages, including an input mask
character sheet, an information sheet and an HTML tag sheet.
Skip to contentAll 2019 papers 





View all





Computer Applications Technology Grade 12 P1 2019 QP (Eng)
Grade 12 Computer Applications Technology Paper 1 question paper from the Eastern Cape Mock Exam 2019 (English), 17 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2019 · English. Question paper, 17 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Language
- English
- Document type
- Question paper
- Year
- 2019
- Exam period
- Eastern Cape Mock Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 17
- File size
- 1.2 MB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 17
This exam
Eastern Cape Mock Exam 2019
Questions in this paper
Document textSearch extracted text and jump to a page.
2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019)
INSTRUCTIONS AND INFORMATION
1. Owing to the nature of this three-hour examination, it is important to note
that you will NOT be permitted to leave the examination room before the end
of the examination period.
2. Insert your surname and name in the header of EVERY document that you
create or save.
3. The invigilator will give you a disk containing ALL the files needed for the
examination OR you will be told where the files can be found on the network
or computer. If a disk has been issued to you, you must write your centre
number and examination number on the label. If you are working on the
network, you must follow the instructions provided by the invigilator.
4. A copy of the master files will be available from the invigilator. Should there
be any problems with a file, you may request another copy from the
invigilator.
5. This question paper consists of SIX questions.
6. Answer ALL the questions.
7. Ensure that you save each document using the file name given in the
question paper. Save your work at regular intervals as a precaution against
possible power failures.
8. Read through each question before answering or solving the problem. Do
NOT do more than required by the question.
9. At the end of the examination you must hand in the disk given to you by the
invigilator with ALL the files saved on the disk, OR you should make sure that
ALL the files are saved on the network/computer as explained to you by the
invigilator/teacher. Make absolutely sure that ALL files can be read.
10. During the examination you may make use of the help functions of the
programs which you are using. You may NOT use any other resource
material.
11. If data is derived from a previous question that you cannot answer, you
should still proceed with the questions that follow.
12. Unless instructed otherwise, you must use formulae and/or functions for ALL
calculations in questions involving spreadsheets. Use absolute cell references
only where necessary to ensure that formulae are correct when you copy them
to other cells in a spreadsheet.
Copyright reserved Please turn over
(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P1 3
13. In all questions involving word processing, you should set the language to
English (South Africa). The paper size is assumed to be A4 Portrait, unless
instructed otherwise.
14. In Annexure A the HTML Tag sheet is provided.
15. The examination folder/data disk that you receive with this question paper
will contain the folder and files listed below. Ensure that you have the folder
and all the files before you begin this examination.
Copyright reserved Please turn over
4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019)
SCENARIO
Land pollution is a serious problem that impacts on humans, animals and the earth.
Without taking measures now to reduce pollution levels, permanent changes to the
land can occur. The adverse changes to the environment due to land pollution are
subtle, but the problem is much bigger than it appears. It is therefore important to
Save our Land. The school asked the Grade 12 learners to assist in a campaign to
promote sustainable living.
QUESTION 1: WORD PROCESSING
A document was created to give an insight about what land pollution is. Edit the
document as requested.
Open the 1LandPollution word processing document.
1.1 Insert a cover page in the document. The cover page must display the
following:
1.1.1 A “Facet” cover page at the beginning of the document. (1)
1.1.2 Type Land Pollution in the title field, Save our Land in the subtitle field
and landhighschool@ecdept.gov.za in the email field. Delete the
abstract field. (3)
1.2 Insert an automatic table of contents below the heading “Table of Contents” as
follows:
1.2.1 Use the “Title” style for the level 1 headings. (1)
1.2.2 Use the “Heading 1” style for the level 2 headings. (1)
1.2.3 Use the “Heading 2” style for the level 3 headings. (1)
1.3 Apply automatic page numbering to the document as follows:
1.3.1 Insert the Accent Bar Right page numbers in the document. (1)
1.3.2 Start the page numbering from the second page of the document,
numbering the pages from page 1 onwards. (2)
1.4 Format the first paragraph under the heading “Land Pollution”, starting with the
text “What’s beneath …” and ending with “… closer look”. as follows:
1.4.1 Change the paragraph spacing to 6 pt before and 6 pt after the
paragraph. (1)
1.4.2 Change the line spacing to exactly 16 pt. (2)
1.4.3 Expand the character spacing by 1.5 pt. (1)
1.5 The word “Contaminate” appears twice in this document. Replace the two
occurrences of this word with the word “infect”. (2)
Copyright reserved Please turn over
(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P1 5
1.6 Locate the word ‘In factories and offices’ in the text under the heading ‘Waste
disposal’.
Add a hyperlink to this text as follows:
The hyperlink must link to the website www.explainthatstuff.com/land-
pollution.html.
The text “HowStuffWorks” must display when the mouse hovers (is
moved) over the hyperlink. (3)
1.7 Attach a footnote to the word “Radioactive Waste” under the heading “Waste
Disposal”. Use the symbol (Wingdings character 83) as a custom symbol and
type in ‘by-product of nuclear power’ as the footnote text. (3)
1.8 Justify and automatically hyphenate the whole document. (2)
1.9 Add the source displayed at the end of the document to the other sources of
the document. (3)
1.10 The bibliography at the end of the document does not display any records.
Format the bibliography so that it shows at least ONE source. (1)
1.11 Insert a field next to the text “Date Created” to display the date that this
document was created. (1)
[29]
Copyright reserved Please turn over
6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019)
QUESTION 2: WORD PROCESSING
You are requested to modify the brochure that was created in Word. This
brochure will be distributed to people as a form of awareness.
Open the 2LandPollutionBrochure word processing document and modify it as
follows:
2.1 Change the page orientation to landscape. (1)
2.2 Place a 2¼ pt wide, red double-line page border around the document. (3)
2.3 Place the highlighted text of the document into three columns.
Insert a 1 cm/0.39 inches space between the columns.
Insert a line between columns.
Headings must be at the top of each column. (4)
2.4 Change the heading “What is land pollution?” by using a WordArt with a
gold colour Accent 4 Soft Bevel. (4)
2.5 Locate the bulleted list under the heading “How to prevent land pollution?”.
Change the format of the bullets to the picture 2Bullet.jpg found in the
data folder.
Set the indentation of the bullets at 0 cm and the paragraphs must be
hanging at 1.5 cm. (4)
2.6 Insert an Oval Callout Shape at the bottom of the first column with the text
“Save Our Land!” (3)
2.7 Use the image 2LandPollution.jpg as a watermark WITHOUT any
washout effect and set the scaling to 120%. (4)
[23]
Copyright reserved Please turn over
(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P1 7
QUESTION 3: SPREADSHEET
A spreadsheet file containing results of the event has been stored in the
3_LandPollution spreadsheet.
Open the 3_LandPollution spreadsheet and work in the Stats per Province
worksheet.
3.1 Format the worksheet as follows:
3.1.1 Change the tab colour of the Stats per Province worksheet to any
colour other than the original. (1)
3.1.2 Merge and centre cells from cell A1 to cell T1. (1)
3.1.3 Apply a thin diagonal stripe pattern style fill effect with a red colour to
the merged cell. (2)
3.1.4 Format Row 4 so that all contents is visible without enlarging the cells. (1)
3.2 Freeze the pane in column A so that all columns display when you scroll right. (2)
3.3 The date the land pollution report was created is stored in cell A3. Format the
date to display as follows: (28)-(02)-(2019). (3)
3.4 Use suitable functions to create a code in cell A5. The code is created by
combining the following:
First two letters of the province.
A hyphen (-).
Number of characters of the province.
All these in capital letters. (5)
3.5 Insert a function in cell C3 to determine the position of the space in the name
‘Eastern Cape’ in cell B5. (3)
3.6 Use a spreadsheet feature to force the user to enter a whole number that
cannot be greater than 999 999 in column D. Add a suitable error message
that the user will receive if invalid data is entered. (4)
3.7 Some provinces are densely populated than others; this creates a lot of land
pollution.
Insert a function in cell E3 to determine the number of provinces that are bigger
than 100000 (Square metres) (column D) AND whose population density is
less than 55 (column E). (5)
Copyright reserved Please turn over
8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019)
3.8 The population density of each province is recorded in column E and is
expressed in percentages. The percentages can be translated as follows:
Population Density Density
<51 Less Dense
51 to100 Dense
>100 Highly Dense
Insert a suitable function in cell F5 to determine the density of the Eastern
Cape. (4)
3.9 In column O, daily inflows per province are recorded. Use an appropriate
spreadsheet feature to apply a red data bar to represent the value in the cell.
The higher the value, the longer the bar. (3)
3.10 Insert a function in cell Q15 to determine the total budget of all the “Cape”
provinces. (4)
3.11 The amount budgeted by each province is in column P and expenditure in
column Q. Calculate in cell R5 the amount that is left after the expenditure of
the province has been paid. Copy the result for all provinces. (3)
3.12 Some provinces used their whole budget for Waste Management. Some have
money left in their budget. Use a function in cell S5 to determine whether the
province(s) need a Top Up or not. Insert “Top Up” for those provinces that
need Top Up and leave cell blank for province(s) that do not need a Top Up.
Copy the answer to the rest of the column C. (4)
3.13 A town per province was identified for the study of land pollution. These towns
are stored as worksheet Towns.
Insert a function in cell T9 to identify the town in the province of Limpopo. (5)
Copyright reserved Please turn over
(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P1 9
Work in the Graph worksheet.
3.14 Create a graph using the data in the ranges B5:B13; L5:L13 and M5:M13.
The chart/graph must resemble the chart/graph below. Adhere to the
instructions that follow.
WASTE TREATMENT
35
30
Waste Treatment Facilities
25
20
15
10
5
0
Provinces
Water Recovery Facilities Water Treatment Facilities
The graph must have two series points plotted correctly.
Series 1 (Waste Recovery Facilities) must be a column graph and Series 2
(Waste Treatment Facilities) must be a line graph.
Legends must be correctly placed and edited.
Both axes must be renamed.
Format chart area to picture.
Use a spreadsheet feature to move the chart to the graph worksheet. (7)
[57]
Copyright reserved Please turn over
10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019)
QUESTION 4: DATABASE
A database of all waste management facilities is created. Modify the database and
work in the design view.
Open the 4_LandPollution database.
4.1 Edit the Waste Pollution table as follows:
4.1.1 Remove the ID field. (1)
4.1.2 Add a new field named Image after the province field:
This field must be able to store a picture.
Provide the field with an appropriate data type. (3)
4.1.3 Set the primary key to a more appropriate field type. (1)
4.1.4 Change the field properties of Hazardous Waste field so that the user
is forced to enter a value. (1)
4.1.5 Change the Own refuse dump field so that:
The user can only enter values greater than 2 or less than 99.
Appropriate validation text is inserted. (3)
4.1.6 Set the default value of the Budget field to R10 000. (1)
4.2 Create the form frm4_2 based on the LandPollution table.
Insert only the following fields: Province; Hazardous Waste; Budget and
Expenditure.
Change the background colour of the form header to red.
Change the content of the label in the form header to Waste.
Insert the date as a field in the header of the form.
Insert a calculation in the form footer to determine the total number of
provinces. (7)
4.3 Open the query qry4_3 and modify it as follows:
Edit the qry4_3 to show only Province, Population served by Municipality
and Own Refuse dump.
Only show those who are 50% and above of population served by municipal
waste collection.
Also show those who have a Hazardous Waste.
Sort them from smallest to biggest of the Own Refuse Dump field. (5)
Copyright reserved Please turn over
(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P1 11
4.4 Open query qry4_4.
Modify the query so that it displays the total of the provinces whose budget for
waste management is R50 000 and more, as shown below.
Province SumOfBudget
Eastern Cape R 105 740.00
Free State R 50 314.00
Gauteng R 236 324.00
KwaZulu-Natal R 209 726.00
Western Cape R 291 920.00 (3)
4.5 Open query qry4_5.
Create a calculated field called Balance in the query qry4_5. Calculate which
province(s) spend more than their budget and have a Hazardous Waste. (6)
4.6 Create a report from the LandPollution table.
Show all fields other than the ID field.
Group according to the Licensed facilities and then by Hazardous Waste.
Sort from the smallest to the biggest budget.
Page orientation must be landscape.
Calculate the total amount used in the Licensed Facilities footer.
The total amount must be in a suitable format.
Insert the picture 4LandPollution.jpg in the header of the report.
Save as Report. (10)
[41]
Copyright reserved Please turn over
12 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019)
QUESTION 5: WEB DESIGN (HTML)
A web page has been created to create an awareness about land pollution.
Open the incomplete 5_LandPollution.html web page in a web browser and in a
text editor e.g. Notepad.
NOTE:
Question numbers are inserted as comments in the coding as guidelines to
show approximately where the answer(s) should be inserted.
An HTML tag sheet has been attached for reference.
Your final web page should look like the example below.
Copyright reserved Please turn over
(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P1 13
5.1 Insert tags to ensure that the text “Land Pollution” displays in the browser
tab. (1)
5.2 Adjust the heading “Land Pollution” as follows:
The heading “Land Pollution” must be centred.
Change font colour to brown. (2)
5.3 Change the size of the horizontal line under the heading “Triathlon” to 7 and
colour red. (2)
5.4 Change the information under the heading “Sources of Land Pollution” to a
bulleted list by using capital Roman figures as shown in the example of the
website. (3)
5.5 A table has been created but does not show correctly. Correct it as follows:
Change the first row as table headings.
Set the table border to 2.
Set the space between text and the cell borders to 25.
The heading row must be shaded in pink colour.
Merge the cells in the last row of the table and insert the picture
5LandPollution.
The picture height must be 200 and width 300.
The picture must be in the centre of the cell.
The word “Dump” must show if the picture does not display. (9)
5.6 Insert a link on the word Home below the table, to link to the Top of the
website. (3)
[20]
Copyright reserved Please turn over
14 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019)
QUESTION 6: GENERAL
A community member of Waterfall Park has written a letter to the mayor of the city to
complain about the land pollution.
Open and edit the file 6Letter.docx.
6.1 The following changes must be done to the letterhead:
6.1.1 There are two pictures in the letterhead. Use a word processing
feature to combine the two pictures to appear as one. Move the
picture below the heading “Waterfall Community”. (2)
6.1.2 Add a cross reference next to the highlighted “my” in first paragraph
that links to the endnote found in the letter. (2)
6.1.3 The graph created had an error where the values of the Plastic
pollutants were swapped with Broken Metal pollutants. Correct the
graph to show the correct percentages. (2)
6.1.4 Use a paragraph setting to ensure that the lines in the paragraph
starting with “There” and ending with “earth” will stay together and not
split if the paragraph runs over to another page. (2)
6.1.5 A poster called 6Poster.docx has been created to educate people
about land pollution.
Insert 6Poster.docx as an icon in the space provided in the letter. (2)
[10]
TOTAL: 180
Copyright reserved Please turn over
(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P1 15
ANNEXURE A – HTML TAG SHEET
Basic Tags Formatting Tags continued
Tag Description Tag Description
<body></body> Defines the body of the web <li></li> Inserted before each list
page item, and adds a number or
<body Sets the background colour symbol depending upon the
bgcolor="pink"> of the web page type of list selected
<body text="black"> Sets the colour of the body <img src="name"> Adds an image
text
<head></head> Contains information about <img src="name" Aligns an image: can also be
the document align="left"> "right", "center"; "bottom",
"top", "middle"
<html></html> Creates an HTML document <img src="name" Sets size of border around
– starts and ends a web border="1"> an image
page
<title></title> Defines a title for the <img src="name" Sets the height and width of
document width="200" an image
<!-- --> Comment height
="200">
Text Tags <img src="name" Displays alternative text
alt="alternative when the mouse hovers over
Tag Description text"> the image or when the image
<hl></hl> Creates the largest heading is not found
<h6></h6> Creates the smallest <hr/> Inserts a horizontal line
heading
<b></b> Creates bold text <hr size="3"/> Sets size (height) of line
<i></i> Creates italic text
<font Sets size of font, from "1" to <hr Sets width of line, in
size="3"></font> "7" width="80%"/> percentage or absolute value
<font Sets font colour <hr Sets the colour of the line
color="green"></font> color="ff0000"/>
<font face="Times Sets font type Table Tags
New Roman"></font>
Link Tags Tag Description
Tag Description <table></table> Creates a table
<a href="URL"></a> Creates a hyperlink <tr></tr> Creates a row in a table
<a href="URL"><img Creates an image link <td></td> Creates a cell in a table
src="URL"></a>
<a name="NAME"></a> Creates a target location <th></th> Creates a table header (a
cell with bold, centered text)
<a href="#NAME"></a> Links to a target location <table Sets the width of the table
created somewhere else in width="50">
the document
Formatting Tags <table Sets the width of the border
border="1"> around the table cells
Tag Description <table Sets the space between the
cellspacing="1"> table cells
<p></p> Creates a new paragraph <table Sets the space between a
cellpadding="1"> cell border and its contents
<p align="left"> Aligns a paragraph to the <tr Sets the alignment for cell(s)
"left" (default), can also be align="left"> (can also be "center" or
"right", or "center" "right")
<br/> Inserts a line break
<ol></ol> Creates a numbered list <tr Sets the vertical alignment
<ol type="A","a", Defines the type of valign="top"> for cell(s) (can also be
"I","i","1"></ol> numbering used "middle" or "bottom")
<ul></ul> Creates a bulleted list <td colspan="2"> Sets the number of columns
a cell should span
<ul type="disc", Defines the type of bullets <td rowspan="4"> Sets the number of rows a
"square","circle"></ used cell should span
ul>
Copyright reserved Please turn over
16 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2019)
INPUT MASK CHARACTER SHEET
CHARACTER DESCRIPTION
0 Digit (0 to 9, entry required, plus [+] and minus [–] signs not allowed)
Digit or space (entry not required, plus [+] and minus [–] signs not
9
allowed)
Digit or space (entry not required; spaces are displayed as blanks while
# in Edit mode, but blanks are removed when data is saved; plus [+] and
minus [–] signs allowed)
L Letter (A to Z, entry required)
? Letter (A to Z, entry optional)
A Letter or digit (entry required)
a Letter or digit (entry optional)
& Any character or a space (entry required)
C Any character or a space (entry optional)
Decimal placeholder and thousand, date and time separators (The actual
.,:;-/ character used depends on the settings in the Regional Settings
Properties dialog box in the Windows Control Panel.)
< Causes all characters to be converted to lower case
Causes all characters to be converted to upper case
> to right. You can include the exclamation point anywhere in the input
mask.
Causes the input mask to display from right to left, rather than from left to
! right. Characters typed into the mask always fill it from left to right. You
can include the exclamation point anywhere in the input mask.
Causes the character that follows to be displayed as the literal character
\
(for example, \A is displayed as just A)
Copyright reserved Please turn over
(EC/SEPTEMBER 2019) COMPUTER APPLICATIONS TECHNOLOGY P1 17
COMPUTER APPLICATIONS TECHNOLOGY P1 – SEPTEMBER 2019
INFORMATION SHEET (to be completed by the candidate AFTER the 3-hour session)
SCHOOL:
NAME:
WORK STATION NUMBER:
SUITE USED Microsoft Office Microsoft Office Microsoft Office Office 365
(Mark appropriate 2010 2013 2016
box with a cross (X))
WEB BROWSER USED Other
(QUESTION 6) (Specify)
Mozilla Firefox Google Chrome Internet Explorer
(Mark appropriate
box with a cross (X))
FOLDER NAME:
Tick if saved and/or attempted.
Question File name Saved Attempted Maximum Maximum Marker HOD Cluster EM
Number (√) (√) mark achieved
1 1_1Land Pollution 29
2_2LandPollution-
23
2 Brochure
3 3_LandSheet 57
4 4_LandPollution 41
5 5_MyWebsite 20
6 6Letter.docx 10
TOTAL: 180
Comment (for marker use only)
Copyright reserved Please turn over
Study this subject
Recommended for this subject

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

Memorandum
Computer Applications Technology Grade 12 P2 2019 Memo (Eng)

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

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

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

Question paper
Computer Applications Technology Grade 12 P2 2022 QP (Eng)
More from Grade 12 Computer Applications Technology

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

Memorandum
Computer Applications Technology Grade 12 P2 2025 Memo (Afr)

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

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

Memorandum
Computer Applications Technology Grade 12 P2 2024 Memo (Eng)

Errata