Computer Application Technology Paper 1 (English)

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

Past Paper 2023 Grade 12 English
โ†“ Download PDF Facebook X ๐Ÿ“„ 973.2 KB View Memorandum
Preparing document

๐Ÿ“‹ Document Analysis

๐ŸŽฏ 150 marks โฑ๏ธ 3h ๐Ÿ“„ 8 pages ๐Ÿ“ 61 items found ๐Ÿ“š 6 topics ๐Ÿ”‘ 1 key info
See full analysis

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

61
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.1Make the following changes in the header: Remove the double strikethrough from the text 'CAPE TOWN, SOUTH AFRICA'. Change the position of the header to 1 cm from the top of the first page
1.2Set the hyphenation so that words in capital letter are NOT hyphenated. (1\
1.3Insert a custom mark footnote on the word 'Reasons' found in the main heading, to display as: (3\
1.4Find the text reasons why.' and modify it to display as shown below. NOTE
Q1โ€” Section header โ€”
1.6Find the comment and eply to the comment with the text 'someti mes'.
1.7Edit the watermark as follow Change the font type to Arial Narrow Format the shape of the WordArt to an 'Arch Down (Curve\
1.8Find the text below the heading 'Funicular Tickets' that starts with 'Description' and ends with 'R35'. Change the layout of this text to appear as shown below. (4\
1.9Apply a 3 pt page border to the document and set the top margin to appear 12 pt from the text (3\ Save and close the 1CapePoint word processing
2.1Add the text 'Mountain' as the subject to the file properties of the document. (1\
2.2Replace the picture on the cover page with the 2Table picture. Apply any half reflection effect to this picture. (2\
2.3Insert automatic page numbers to display as shown below. NOTE Page numbers should NOT appear in Section 1. (3\
2.4Insert a Table of Contents using the Distinctive format below the heading 'Question/Vraag .4 ' to appear as
Q2โ€” Section header โ€”
2.6Find the heading 'Hiking' and the text below it that ends with with a group.'
2.7Find the numbered list below the heading 'Facts'. n the Multilevel list dialog , a style TableList appears below the option List Styles
2.10Locate the 2Dates zipped file and do the following: Extract the 2Dates
Q3โ€” Section header โ€”
3.1Delete Sheet3 from the workbook. (1\ Work in the Participants worksheet.
3.2Set the print area to cells A12:E 62 (1\
3.3Add the text 'Marathon Logo' as the Alt Text of the image in cell A3 (1\
3.4Insert a function in cell F5 to determine the average qualifying time. (1\ 3. he distance of the race is stored in
Q4โ€” Section header โ€”
4.1Change cells A2:M and its con tents to display as follows: (3\
4.2Insert a function in cell C4 to determine how many of the place s do NOT allow pets
4.3Distance from the airport to a place of accommodation is displayed as follows: The six shortest distances:
4.4Use n AND function in cell G10 to return 'TRUE' if the price
4.5During the off peak season, places of accommodation give a 12 5%
4.6Create a column chart using the data series A1:B6 to display the total number of reviews for each of the accommodation types as follows: NOTE: The 'Hotels' bar has a Paper bag texture fill.
Q5โ€” Section header โ€”
5.1Open tb l5_1 ab
5.1.1Modify the properties of the IDNo field as follows: Set an appropriate field size. Set the field properties so that records are
5.1.2Add 'Safari' as a value list option to the Experience field. Change the lookup properties so that tourists can choose more than one option as an exper ience type. (2\
5.1.3Change the properties of the Date field to only accept dates from the beginning of July 2023 to the end of August 2024. Display an appropriate message if the date entered is incorrect. (4\
5.1.4Chan e the Picture field as follows: Set an app ropriate data type so that tourist can upload their ID
5.1.5Change the colour of the gridlines to black AND set the option to display only the horizontal gridlines. (2\ Sa an
5.2Open the frm5_2 form based on the tblActivities table in Design View, and
5.3Open the 5_ ue
5.4Create a query named 5_ based on the tblActivities table as
5.5Open the qry5_5 query based on the tblActivities table, in Design View. Insert a calculated field Hours
5.6Open the report called rpt5_6 based on the tblActivities table Modify the report as shown below NOTE:
Q6โ€” Section header โ€”
6.1Open the incomplete 6_ 1Interactive file in a web browser and also in a text/HTML editor (NOT a word processing program such as Word\ Your final web page should look like the example below Computer Applications Technology/P1
6.1.1Insert your examination number between the cent tags to display in bold text. NOTE
6.1.2Insert HTML code so that th image appear next to the text 'Find your Freedom!' as displayed in the screenshot
6.1.3Modify the horizontal line to display across 80% of the web page. (1\
6.1.4Modify the code so that the text colour above the table appears the same as in the table (1\
6.1.5Insert the 6_1Urban image to match the other images as shown in the screenshot. (2\
6.1.6Modify the code so that the words 'discovering flowers' will display on the next line, with no open line between the text. (1\
6.1.7Edit the numbered list in the second column to appear the same as the other two lists found in the last row of the table. (1\
6.1.8Modify the code so that the link will direct the user to the web address given in the data. (1\ Save and close the 6_ 1Interactive file.
6.2Open the incomplete 6_ Big6 file in a web browser and also in a text/HTML editor (NOT a word processing program such as Word\ Modify the HTML code
Q7โ€” Section header โ€”
7.1Open the 7CapeTown word processing document.
7.1.1Change the inside borders of the table to any blue colour. (1\
7.1.2Modify the heading row of the table to appear as shown below. (1\
7.1.3A tourist receives points that can be used as discount on future travels. Insert a formula to calculate the points for Allan Nel as follows:
7.2Open the 7Tourists spreadsheet. Work in the List worksheet.
7.2.1Do the following: Apply a spreadsheet feature to column A to arrange the text into columns. Find and replace all
7.2.2Every year tourists receive a message one month before their birthday about

Topics Identified

6
Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total150 marks
Sections21 + 24 + 35 + 15 + 15 = 110 marks

Key Information

Contact Number0 30000 4500 ยท 0 60000 7500

Paper information

SubjectComputer Application Technology
Year2023
SessionMay-June
TypePast Paper
PaperPaper 1
LanguageEnglish
Pages23
Downloads4

Examination context

Decade2020s
Years ago3y
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 size973.2 KB
Pages23
Archived on7 September 2026
File age46d
ContributorFreeMode
Fingerprint05069DA2A4F7

Questions and learner discussion

Log in to ask a question or leave a review.

No questions or discussions have been posted yet.