Computer Application Technology Paper 1 (English)

November 2022 — Grade 12 / Matric — Computer Application Technology

Past Paper 2022 Grade 12 English

↓ Download PDF 📄 846.4 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 1 marks ⏱️ 3h 📄 7 pages 📝 66 items found 📚 6 topics

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 font of the text 'Extract from Report' to small caps.

1.2Apply a text fill effect to the WordArt text 'KWAZULU NATAL TOURISM' as follows: Rectangular type gradient fill First g radient stop at the 60% position

1.3Modify the tyle named Showcasting so that all the sub headings

1.4Find the citation in the third paragraph that refers to the '( Department of Statistics South Africa

1.5Find the text Question

Q1— Section header —

1.6Find and r eplace all occurrences of the exact word tourism with a highlighted

1.7Find the text that starts with 'PUBLIC RELATIONS AND effect of the pandemic

1.8Find the heading 'Pandemic' and mark it as an index entry AND add a subentry called 'Covid' to this main index entry. (1\

1.9Insert a bibliography in the Harvard Anglia bibliography style below the text

Q1— Section header —

1.10Insert an ndex below the text

Q1— Section header —

1.11Do the following: Open the file 1Poster using the P1* password Paste the group of

Q1— Section header —

Q2— Section header —

2.1odify the Drop Cap 'W' found in the first paragraph as follow

0.5cm (3\

2.2Insert a 3 pt paragraph border around the text that starts with 'Please share via ' and that end the

2.3Create a link on the text 'Win! Win! Win! to navigate to the following

2.4Edi t the form below the heading 'Competition form' as follows

2.4.1Replace the text

Q2— Section header —

2.4.2Format the Cell Number field to an appropriate data type and length (2\

2.4.3The number of extra entries will be twice the number of times a person shared the form via WhatsApp. Modify

2.5Find the text that start with ' Backpackers family' and apply a word processing feature to display the text as

2.6Add a signature line below the text

Q2— Section header —

2.7Find the heading 'Competition Terms and Conditions' and do the following: Change the haracter pacing of this text to condensed. Change the paragraph

Q3— Section header —

3.3Eight job opportunities were created for every R100 000 that tourists spent on accommodation. Insert a formula in cell B18 to determine the number of jobs that were created in 2020. Round off your answer to the next whole number.

3.4The monthly total in column G is calculated by adding the amounts in each column ( columns B to \If a cell in one of the columns is empty, the cell in

3.5Apply conditional formatting to cells F20:F31 to format the cells with a blue fill colour when the amount for shopping in a particular month in 2021 is greater than the amount for shopping in the same month in 2020.

Q4— Section header —

4.1Insert a function in cell D3 to determine the most lions seen on any game drive (1\

4.2Insert a SUMIFS function in cell to deter mine the total number of lions seen at the Mpila Camp (

4.3Insert a VLOOKUP function in cell A7 to display the surname of the ranger based on the ID of the ranger and the list in the Rangers worksheet. (3\

4.4Game drives are classified as follows: Part of day Time of day Morning Start before 12:00 Afternoon Start from 12:00 and end before 17:30

4.5Each game drive lasts 2 hours and 45 minutes. Insert a TIME function in cell F to display the time the game drive will

Q5— Section header —

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

5.1.1Change the field properties of the Surn ame field so that the field may not be left blank. (1\

5.1.2Each trave er has a unique code that automatically links his/her details to

5.1.3Change the field properties of the TravelDate field as follows: Apply the medium dat format.

5.1.4The Accommodation field should display options for accommodation types from the tblAccommodation table Edit

5.1.5Insert field named IDCopy below the Surname field that will link to

5.2Open the frm5_2 form , based on the tblInfo table, in Design View Modify the form to

5.3Open the query called qry5_3 , based on the tbl Info table, in Design View. Display the records of all the travellers who booked in a group size of more than three people through

5.4Open the qry5_ query, based on the tblInfo table, in Design View. Display the total cost per booking agent. Save and close the

5.5Open the qry5_ query, based on the tblInfo table, in Design View. The calculated field Year determines whether a traveller

5.6Create a report called rpt5_6 , based on the tblInfo table as follows: Display the Surname

Q6— Section header —

6.1Open the incomplete 6_1 Dolphin file in a web browser and also in a text/HTML editor NOTE: Use the example

6.1.1Add an attribute to the body tag so that the whole web page will display in blue font

6.1.2Add tag to make the text 'Did you know?' display as a level two heading

6.1.3Format the text that round tropical climate.' as shown i n the screenshot. (1\

6.1.4Create a link to the e mail address as shown at the bottom of the web

6.2Open the incomplete 6_ 2Heritage web page in a web browser and also in a text/HTML editor. Complete the web page to look exactly

Q7— Section header —

7.1Open the 7Map file.

7.1.1Insert a calculation in the table to determine the percentage of KwaZulu Natal's contribution to tourism in South Africa. (2

7.1.2Insert the value of the contribution of KwaZulu Natal in the textbox provided. Format and position the textbox to resemble the screenshot below. (3 Save and close the 7Map

7.2Open the 7TravelMode database. Import the 7Travellers spreadsheet as a linked table named Info

7.3Open the 7BigFive spreadsheet. The KZN Travel Agency is running a competition to promote awareness of the

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total150 marks

Sections26 + 19 + 21 + 19 + 35 + 15 + 15 = 150 marks

Paper information

SubjectComputer Application Technology

Year2022

SessionNovember

TypePast Paper

PaperPaper 1

LanguageEnglish

Pages22

Downloads6

Examination context

Decade2020s

Years ago4y

SeasonSpring (SH)

Start daySaturday

Exam periodNovember 2022

Days since exam1,452

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 size846.4 KB

Pages22

Archived on7 September 2026

File age49d

ContributorFreeMode

Fingerprint6159F058155B

Questions and learner discussion

No questions or discussions have been posted yet.