Computer Application Technology Paper 1 (English)

November 2021 — Grade 12 / Matric — Computer Application Technology

Past Paper 2021 Grade 12 English

↓ Download PDF 📄 783 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 1 marks ⏱️ 3h 📄 6 pages 📝 64 items found 📚 6 topics 🔑 1 key info

See full analysis

Questions — A Preview of What to Expect in the Document

This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.

Q1— Section header —

1.1Change the page size of the document to A4. (1\

1.2Change the line spacing of the paragraph starting with The following is and end ing with

1.3Replace all the occurrences of the exact text ozone to appear in Arial arrow

1.4Insert a 9 cm high by 8 cm wide text box and move the text that begins with

1.5Find the text that begins with the heading DOES IT MAKE A DIFFERENCE WHERE I LIVE and end with

1.6Find the text that begins with the heading n the road and ends with keeping windows closed

1.7Change the UK Health Department source to a website source with the URL http://www.airquality.co.uk. (2\

1.8Add an automatic bibliography below the heading Bibliography at the end of the document. (1\

1.9Insert the picture 1Clean as a watermark to the document. Scale the watermark image to 1 50 (2\

1.10Inspect the document for issues and remove all hidden text from the document. (1\ Save and close the Health document. [25] Computer Applications Technology/P125

Q2— Section header —

2.1Change the font of the document title UNESCO : Marine Pollution to

2.2Format the heading s of the document so that you can insert a table of contents below the heading TABLE OF CONTENTS to appear

2.3Remove the automatic hyphenation from the document. (1\

2.4Insert a caption to the picture under the heading What is polluting our Oceans? The caption text can be found in the picture s alternative text.

2.5Remove the hyperlink on the picture by Chris Deacutis. (1\

2.6Restore the picture below the heading What can I do? to its original colour. (1\

2.7Find the text

Q2— Section header —

2.8Insert a footnote on the text UNEP found on the last page of the document as follows:

2.9Insert a field below the text INSERT HERE to display the number of words in the document. (1\ Computer Applications Technology/P1

2.10Insert automatic page numbering in the footer of the document as follows: Use the ilde format. Ensure that numbering does not appear on the cover page

Q3— Section header —

3.1Insert the 3Logo picture, found in your examination folder, in cell A1 so that it covers the entire cell. (2\

3.2Fill cell A3 to appear the same as cell A2 (1\

3.3Rename the worksheet Sheet1 to Missions (1\

3.4Use a COUNTIF function in cell F3 to determine how many project s have a budget greater than 55 000 .00

3.5he data in column G incorrectly displays values for recycling air pollution. Apply a spreadsheet feature to column G to fill the cells with a colour of your choice whenever the targeted pollution ( column C

3.6A project is categorised as small, medium or large depending on the number of pa rticipants ( column D \olved in the project. Insert a suitable LOOKUP function in cell J6 to determine the project category

3.7The project coordinator will send notifications to prospective participants for projects that will start within the next 60 days column E , inclusive of the current date. Use a nested IF function/formula in

Q4— Section header —

4.1Insert a function in cell D3 to determine the second smallest air quality index (AQI\nt per year ( column E (3\

4.2Add the option Urban to the existing data validation rule in cell B7 using the list in cells J7:J8

4.3The measuring station is given a risk rating column G \depending on the AQI level in

4.4Set the print area to cells A6:H40 (1\ Work in the Graph worksheet.

4.5Use a SUMIFS function in cell H2 and the data in the Quality worksheet to determine the total number of health incidents of all the measuring stations in the Eastern Cape in

4.6Create a graph/chart to appear as follows: (5\ Save and close the 4Air spreadsheet [19] Computer Applications Technology/P1 1119

Q5— Section header —

5.1Open the tbl5_1 table in Design View and edit as follows:

5.1.1Change the field size of the Coverage field to Decimal. (1\

5.1.2Insert a combo box for the PollutionType field with the values Air, Land and Water. (2\

5.1.3Values entered for the Level field must range from 100 to 1 000. Insert a suitable validation rule to ensure that the data entered is valid. (3\

5.1.4Insert a field called Evidence with a suitable data type so that documents/files with proof of actions can be included in this field. (2\ Save and close the tbl5_1 table.

5.2Modify the form called frm5_2 based on the tblData table in Design View as follows:

5.3Open the query called qry5_3 based on the tbl_Data table in Design View. Display the average number of drop

5.4Modify the qry5_4 query based on the tbl_Data table in Design View.

5.5Open the qry5_5 query based on the tbl_Data table in Design View.

5.6Open the rpt5_6 report based on the qry5_4 query in Design View and change it

Q6— Section header —

6.1Open the incomplete 6_1Clean file in a web browser and also in a text/HTML editor Computer Applications Technology/P1 14 DBE/November 2021

6.1.1Insert your examination number so that it displays in the tab of the browser. (2\

6.1.2Change the font colour of the heading The Global Crisis of Plastic ollution to red. (1\

6.1.3Modify the code so that the image displays. (2\

6.1.4Modify the table so that it displays as shown in the image of the web page on the previous page. (3\ Save and close the 6_1Clean file

6.2Open the incomplete 6_2Pollute web file in a web browser and also in a text/HTML editor. Complete the web page to look exactly like the example below. Save and close the 6_2Pollute

Q7— Section header —

7.1After monitoring the pollution in a specific area, a letter must be prepared for the companies with a concerning pollution history. Open the 7Letter document to be used for a mail merge.

7.1.1Change the form controls in the letter as follows Change the form field control below the text Date

7.1.2Prepare the mail merge as follows: Link the 7Letter document with the data source, the 7Company spreadsheet. Select only the companies that have a high

7.2Complete the function/formula in cell D3 to display the name of the companies that have a low level ( column B \ of pollution and where the monitor date

7.3worksheet

7.3Display a alphabetical list of names of all the companies with a ery igh

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total150 marks

Sections25 + 20 + 21 + 19 + 35 + 15 + 15 = 150 marks

Key Information

Websitewww.airquality.co.uk

Paper information

SubjectComputer Application Technology

Year2021

SessionNovember

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages21

Downloads5

Examination context

Decade2020s

Years ago5y

SeasonSpring (SH)

Start dayFriday

Exam periodNovember 2021

Days since exam1,814

About Computer Application Technology examination preparation

This Grade 12 examination resource can be used as part of a structured revision programme. Past papers are most useful when learners attempt questions independently, work within a realistic time limit, and review their answers afterwards.

How to use this resource for revision

A past examination paper is most useful when it is treated as an active revision exercise. Try the questions yourself before checking the corresponding memorandum. Where you make an error, identify the reason — was it a knowledge gap, a calculation mistake, an interpretation issue, or an examination technique problem?

For stronger examination practice, complete the paper without unnecessary interruptions and keep track of the questions that take the most time. Afterwards, review the memorandum and separate knowledge gaps from mistakes caused by interpretation, calculation, structure, or examination technique.

understanding question requirements

applying subject knowledge

working under time constraints

checking answers

identifying revision priorities

A practical revision approach

Start by completing the resource without looking at the memorandum. Review incorrect and incomplete answers afterwards and make a short revision list based on the areas that caused difficulty.

Grade 12 subject hubs

Each matric subject has its own dedicated hub on Freemode with every past paper and marking memorandum we have archived for that subject.

➗ Mathematics View papers → 📊 Mathematical Literacy View papers → ⚗️ Physical Sciences View papers → 🧬 Life Sciences View papers → 📒 Accounting View papers → 💼 Business Studies View papers → 📈 Economics View papers → 🌍 Geography View papers → 🏛️ History View papers → 📖 English View papers → 🇿🇦 Afrikaans View papers → 🗣️ IsiNdebele View papers → 🗣️ IsiXhosa View papers → 🗣️ IsiZulu View papers → 🗣️ Sepedi View papers → 🗣️ Sesotho View papers → 🗣️ Setswana View papers → 🌾 Agricultural Sciences View papers →

Corresponding marking memorandum

Marking memorandum available

Use the corresponding memorandum after completing the paper to review your answers and identify areas that require further revision. The memorandum shows the marking approach used by DBE examiners, including method-mark allocations.

Computer Application Technology Memo 1 (English) →

File details

File size783 KB

Pages21

Archived on7 September 2026

File age47d

ContributorFreeMode

FingerprintB43A3B7E8DD9

Questions and learner discussion

No questions or discussions have been posted yet.