Computer Application Technology Paper 1 (English)

May-June 2026 โ€” Grade 12 / Matric โ€” Computer Application Technology

Past Paper 2026 Grade 12 English
โ†“ Download PDF Facebook X ๐Ÿ“„ 1.09 MB View Memorandum
Preparing document

๐Ÿ“‹ Document Analysis

โฑ๏ธ 3h ๐Ÿ“„ 22 pages ๐Ÿ“ 55 items found ๐Ÿ“š 6 topics ๐Ÿ”‘ 1 key info
See full analysis

Questions โ€” A Preview of What to Expect in the Document

55
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.1Edit the author properties to replace the text ' nsert here' with your examination number. (1\
1.2Modify the two colour gradient fill effect of the page colour as follows: Change the second colour to Green, Accent 6, ighter 60%
1.4Edit the table below the heading 'Savings' as follows: Change only the inside borders of the table to any dash line. Format the formula of the 'Total saving (R\ ' to currency with no decimal
1.5Find the multilevel list below the heading 'Places' and format the list to display as shown in the example below. NOTE: Use Webdings character code 118. (3\
1.6
Q2โ€” Section header โ€”
2.1Add the Integral built in footer style to the cover page only (2\
2.2Find and replace all the occurrences of the exact word 'nights' so that it is highlighted in a bright green colour. (3\
2.3Edit the Figure 2 image and the shape to display as shown in the example below. NOTE: Ensure that the image and shape move as one object. (4\
2.4Find the citation below the heading 'RECOMMENDATION' and add the text 'Recommended' to the omments bibliography field of the source. (1\
2.5
2.6Insert a table of figures below the heading 'Table of figures:' to display as shown in the example below. (4\
2.7Find the text form field controls below the heading 'Enquiries:' and modify the controls as follows:
2.7.1Edit the text form field next to the text 'Time of enquiry:' to display the time the form was opened for completion. (1\
2.7.2Change the length of the text form field below the text 'How can we help you?' to unlimited. (1\
2.7.3Modify the drop down form field below the text 'Tour name' so that 'European Highlights' appears as the last item in the list. (1\
2.7.4Travellers receive a discount of R100 per traveller. Insert a calculation in the text form field below the text 'Total amount' to automatically calculate the total amount payable. NOTE Use the bookmarks of the text form fields.
2.8Insert the text 'Enquiries' as a watermark on the last page only (3\ Save and close the 2Tours document. [26]26
Q3โ€” Section header โ€”
3.1Change the font of the heading in cell A1 to Arial and the font size to 24 pt. (2\
3.2Insert a function in cell G3 to calculate the most common maximum group size olumn of all the tours (1\
3.3Insert a formula in cell G5 to calculate the average length of all the tours olumn Round the answer to the next whole number.
3.4Insert a function in cell G7 to calculate the total cost of all the short break youth package
3.5Insert a suitable lookup function in cell H14 to determine the travel option for the 'Ultimate European' tour name based on the number of days.
3.6Modify the graph/c hart to display as shown in the example below. (5\ Save and close the
Q4โ€” Section header โ€”
4.1Delete the worksheet Sheet1 (1\ Work in the Reservations worksheet.
4.2Insert a function in cell G3 to calculate the second lowest cost per group olumn (2\
4.3Insert a function in cell G5 to determine how many plus packages olumn H were booked (2\
4.4Use a combination of text functions in cell E1 to create a traveller username for each traveller The traveller
4.5travel agent is required to pay a deposit of 60% if the cost per group is more than R150 000 otherwise the deposit remains the general deposit % found in cell Insert an IF function in column M to display the deposit.
4.6Modify the conditional formatting in column F to apply any yellow fill colour to the tours that will depart between January March in the Southern emisphere. 4Bookings
Q5โ€” Section header โ€”
5.1Open the tbl5_1 table in Design View and edit it as follows: NOTE: Select 'Yes' if a warning message appear.
5.1.1Change the field size of the EmployeeSurname field to 30. (1\
5.1.2Change the format of the DateOfBirth field to Short Date (1\
5.1.3Insert an input mask on the EmployeeID field in the following format: FOUR digits , followed by ONE @ symbol , followed by JobTitle
5.1.5New appointments will only be made if person has 5 to 10 years of experience in the travel industry. Insert a validation rule and validation text the YearsExperience
5.2Modify the frm5_2 form based on the tblStaff table in Design View as follows: Add the
5.3Open the query tblTravelClients tab in Design View. Display only the ClientName nline
5.4Open the based on the tblTravelClients table in Design View. Display the total cost per travel status. Save and close the
5.5Open the qry5_5 query based on the tblTravelClients table in Design View. Modify the query as follows: Display all the clients who have
5.6Modify the rpt5_6 report based on the tblTravelClients table in Design View to display as shown in the example below.
Q6โ€” Section header โ€”
6.1
6.1.1Add spacing of 10 between the cells of the table. (1\
6.1.2Centre the image in the top row of the table. (1\
6.1.3
6.1.4Insert the text from the 6_1Info file as the last cell of the table. (2\
6.1.5Create a link to the e mail address as shown at the bottom of the web page. (3\ Save and close the 6_1Travel file.
6.2Open the incomplete 6_2Experiences file in a web browser and also in a text/HTML editor (NOT a word processing program such as Word\. Complete the web page to appear as shown in the example below. Save and close the
Q7โ€” Section header โ€”
7.1Open the 7Discount database. The directors of the OneWorld Adventures want a report of the discount they provided. Create a report called Info
7.2Open the 7Refund spreadsheet. OneWorld Adventures will be closing some of their branches in Europe and Asia. ravellers will be eligible for a refund if: The tour confirmation indicates cancelled, AND The tour was scheduled to Europe OR Asia.

Topics Identified

6
Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Sections19 + 26 + 35 + 15 + 14 = 109 marks

Key Information

Email Addressnshezi73@gmail.com

Paper information

SubjectComputer Application Technology
Year2026
SessionMay-June
TypePast Paper
PaperPaper 1
LanguageEnglish
Pages22
Downloads6

Examination context

Decade2020s
Years ago0y
Seasonโ€”
Start dayโ€”
Exam periodโ€”
Days since examโ€”

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.

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 size1.09 MB
Pages22
Archived on24 September 2026
File age30d
ContributorFreeMode
Fingerprint123E075CFABF

Questions and learner discussion

Log in to ask a question or leave a review.

No questions or discussions have been posted yet.