Computer Application Technology Memo 1 (English)

May-June 2023 — Grade 12 / Matric — Computer Application Technology

Memo 2023 Grade 12 English

↓ Download PDF 📄 695.4 KB View Exam Paper

Preparing document

📋 Document Analysis

🎯 150 marks 📄 7 pages 📝 65 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.1Header Double strikethrough removed Position: Header from Top/From edge: 1 cm

1.2Hyphenation Hyphenate words in CAPS : U nchecked

1.3Footnote: Reasons Footnote inserted on the word 'Reasons' Custom mark: @ Text added: 'Elements of life' (I gnore spelling\

1.4Columns: Line between First column width: 6 cm Spacing between columns : 1 cm

1.5Citation: (Mark from the Dialog box\ Citation: Sterne Suppress: Year ALT+F9: { CITATION Ste16

1.6Comment: Two oceans Reply : sometimes

1.7Watermark Font: Arial Narrow WordArt: Shape: Arch Down (Curve\ Computer Applications Technology/P1

1.8Tab Stops: Funicular Tickets First tab stop Position: 6 cm AND Alignment: Left Leader: Second tab stop

1.9Page border Any p age border inserted (Accept any style\ 3 pt box border Measure from: Tex

2.1File Properties Subject: 'Mountain' (Note to marker:

2.2Cover page: Picture Picture replaced with 2Table Any half reflection variation effect applied

2.3Page numbering Automatic page numbering format

2.4Table of Contents TOC inserted n Distinctive style with a solid line Show levels: 2 Second level heading style: TableSub Alt+F9: TOC

2.5Cross reference: 'cable way Reference type: Bookmark: cableway Reference to: Page number Alt+F9

2.6Paragraph: Pagination on 'Hiking with a group Keep with next AND Keep lines together

2.7Multilevel List: Below 'Facts' List style: TableList modified 2nd Level : Bullets Bullet: Webdings, Character Code: 77 ( (Note to marker: In the

Q2— Section header —

Q3— Section header —

3.1Delete worksheet Sheet3 deleted

3.2Cells A12:E 62: Print Area Print area set to A12:E 62

3.3Cell A3: Image: Alt text Alt text : Marathon Logo

3.4Cell F5: =AVERAGE( 13: 62\ Function: AVERAGE

3.5Cell F8: =ROUNDDOWN (( F3 /5\2,0\ OR =ROUNDDOWN(( F3 /5\2

3.6Cell B20: CONCATENATE RANDBETWEEN(1, 50 LEFT(C20,2\A20\ OR

3.7Cell J17: =VLOOKUP(F17,Band!$A$1:$B$6,2\ Lookup value: F17 Table array: Band!$A$1:$B$6 OR Band!$A$2:$B$6 OR Band!A$1:B$6

Q3— Section header —

Q4— Section header —

4.1Cells A2:M Wrap text Top and bottom borders ONLY Any broken line s tyle

4.2Cell C4: =COUNTBLANK( 10: 70\ OR =COUNTIF(H10:H70,""\ Function:

4.3Cell F10: =IF(E10>100,"Long",(IF(E10>SMALL($E$10:$E$70,6\,"Medi um","Short"\\\ OR =IF(E10<=SMALL($E$10:$E$70,6\,"Short", IF(E10>100,"Long","Medium"\\ Concept marking 1. Test

4.4Cell G10: =AND(C10<1000,L 10="Yes"\ OR =AND(L10="Yes",C10<1000\ OR =IF(AND(C10<1000,L10="Yes"\True","False"\ Criteria 1: C10<1000 Criteria 2: L10="Yes"

4.5Cell M13: =C13 (C13*12.5%\ OR =C13*0.875 OR =C13

4.6Chart/Graph Column chart with data series _6'!$A$1:$B$6 Hotels bar: Fill Texture: Paper bag

Q4— Section header —

Q5— Section header —

5.1.1Field: IDNo Field size: 13 Set as Primary Key

5.1.2Field: Experience : Lookup 'Safari' added to value list Allow ultiple alues: Yes

5.1.3Field: Date : Validation Rule and Validation Text >=#2023/07/01# AND <=#2024/08/31# OR >#2023/06/3 # AND <#2024/09/01# OR

5.1.4Field: Picture Data type: OLE object OR Hyperlink\ Position: Appears below IDNo

5.1.5Gridlines (Mark in Datasheet View (CTRL+.\ Colour: Black Only horizontal gridlines display

5.2Image Display When: Screen Only Field: Duration Conditional formatting (Mark in Form View (CTRL+.\

5.3Morning criteria: Game drive Morning criteria: "Shark cage diving" Transport

5.4Design view Experience and TourName fields display Experience: Total: Group by Experience criteria:

5.5Calculated field: Hours : [ Duration /60 Calculated field: Hours

5.6Experience textbox moved from Detail section to Experience header Keep the whole group together on one page Mark

Q5— Section header —

Q6— Section header —

6.1.1Bold tag <center> </center> Bold tags and exam ination number inserted

6.1.2Image <img src: 6_1Banner.png align=" left

6.1.3Horizontal line <hr color="black" width="80%" /> Attribute: width="80%"

6.1.4Font colour <font color =" black Colour: black

6.1.5Image <td><img src=" 6_1Urban.jpg" height="250" width="180"></td> Image inserted: 6_1Urban.jpg Attribute: height="250"

6.1.6Break tag <td>Surfing; kayaking; hiking; <br/> discovering flower </td> Break tag inserted

6.1.7Unordered list <ul type="square"> <ol> changed to <ul type="square">

6.1.8Link tag <a href ="https://video.eko.com/v/A98brG"> Attribute: name changed to href

6.26_2Big6 table border="0" cellspacing="50"> <tr> <th bgcolor="lightblue">V&A Waterfront</th> <td row span= "6"

Q6— Section header —

Q7— Section header —

7.1.1Table: Formatting Inside borders: Any blue colour

7.1.2Table: Formatting First c ell in first row split into 2 cells Tourist Name and Tourist Surname

7.1.3Table: Formula Note to marker: Mark from the ialog box or ALT+F9

7.2.1Convert ext to olumns Column A converted into columns Find and Replace 'Maybe' replaced with 'No' (10 occurrences\

7.2.2Cell D2: =DATE(YEAR(TODAY(\\ONTH(C2\ 1,DAY(C2\ Function: DATE Function: YEAR (TODAY(\

Q7— Section header —

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total150 marks

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

Paper information

SubjectComputer Application Technology

Year2023

SessionMay-June

TypeMemo

PaperPaper 1

LanguageEnglish

Pages17

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.

➗ 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 examination paper

Examination paper available

Open the corresponding examination paper to practise the questions before reviewing the marking memorandum on this page. Attempt every question under timed conditions for the most realistic preparation.

Computer Application Technology Paper 1 (English) →

File details

File size695.4 KB

Pages17

Archived on7 September 2026

File age46d

ContributorFreeMode

FingerprintFA367BA0B8C9

Questions and learner discussion

No questions or discussions have been posted yet.