Computer Application Technology Memo 1 (English)

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

Memo 2024 Grade 12 English

↓ Download PDF 📄 500.8 KB View Exam Paper

Preparing document

📋 Document Analysis

🎯 150 marks 📄 15 pages 📝 61 items found 📚 5 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.1Hyphenation Automatic hyphenation applied

1.2Cover Page Cover page inserted: Slice (Light\ Only Title and Subtitle controls display AND other controls removed

1.3Heading 1: Text effect and Character spacing Character spacing: Expanded by 3 pt Text effect: 3 D format: Top bevel: 5 pt height

1.4Header: Date ield Date field inserted in the header Header: Year right aligned Format: YYYY (Accept yyyy\ Alt+F9: { DATE

1.5Footnote Layout: 3 columns Numbering format

1.6Paragraph setting: Pagination Page Break: Did you know? Pagination: Page break before (Note to marker: Do NOT

1.7Table: Below Prices start from Text modified to display in one table Appear as the example ast

1.8Track changes: Above Emergency contact info Track changes : Accepted (Note to marker: No text appears between the table, basis' and the heading 'Emergency contact info'\

1.9Tab settings: Tab stop position: 7 cm Alignment: Bar Tabs applied to text as shown below

1.10Table of igures Table of igures inserted No page numbers Alt+F9: { TOC

1.11Find and Replace: 'Johannesburg Zoo' replaced with 'JHB Replacement text: 'JHB' Red Webdings symbol: 246 ( Only

Q1— Section header —

Q2— Section header —

2.1Page layout Margins Top margin: 2 cm Gutter position Left

2.2Page Numbering in footer Format: Outline circle 'Different Odd & Even Pages' selected Position of even page numbers: Right side

2.3Synonym: Endangered Endangered changed one word synonym to: rare

2.4Drop Cap: List Drop cap applied: In margin Distance from text: 0.5 cm

2.5Multi level list Below First level Numbering Style : 1

2.6Hyperlink: E mail address Linked to e mail address: mailto:anna@cityzoo.org.za

2.7Tiger Picture and Callout S hape Callout shape appears ( modified and white fill

2.8Form Controls Drop down item added: Blank option Blank option appears as the first item in option list Payment Amount

Q2— Section header —

Q3— Section header —

3.1Tab colour Tab colour : A ny orange colour

3.2Page Setup: Page and Sheet Correct area: A1: 59 Scaling: Fit to : 1 page wide

3.3Cell E 3: =SUMIFS(G7:G59,D7:D59,"Mammals",F7:F59, ">=2016/01/01"\ OR =SUMIFS(G7:G59, F7:F59,">=2016/01/01", D7:D59,"Mammals"\ OR =SUMIFS(G7:G59,D7:D59,"Mammals",F7:F59,

3.4Column H: Conditional formatting Icon Flag order Red, Yellow, Green Second condition value: >=10000

3.5Cell 7: =SUM(G7*12,H7\0225+SUM(G7*12,H7\ OR =SUM(G7*12,H7\25/100+SUM(G7*12,H7\ OR =SUM(G7*12,H7\0225 OR

Q3— Section header —

Q4— Section header —

4.1Worksheet moved Trip worksheet appears before 4_ worksheet

4.2Cell C 3: =COUNTIF( E7:E 153,"EC"\ Function: COUNTIF Cell r ange: E7:E 153

4.3Cell G3: =M ODE (H7:H153\ Function and cell range: M ODE (H7:H153\

4.4Cell D7: =CONCATENATE("+27 ",RIGHT(C7,9\ OR =CONCATENATE("+27 ," ",RIGHT(C7,9\ OR

4.6Column H: Data Validation Data validation setting: Start Date: 202 /12/ Screenshot of cells H5:H30

Q4— Section header —

Q5— Section header —

5.1.1Field: Keeper Name Required: Yes

5.1.2Field: Time Data type: Date/Time Format: Short Time /00 :00

5.1.3Field: Enclosure: Validation Rule AND Text Validation Rule: "Habitat" Or "Exhibit" Habitat Or Exhibit Validation Text

5.1.4Field: AccessCode: Input mask L"@"00 00 OR

5.1.5Field: NextFeed Field deleted Form: frm5_2

5.2.1

5.2.2Field Group Row Source: "Carnivore", "Herbivore", "Omnivore" Row Source Type: Value list Calculation Formula: =[ Lifespan

5.3Only Animal and Status fields display Origin criteria: Africa Group

5.4Status criteria: 'Endangered' '*Endangered' Lifes pan criteria: <20 OR <=19

5.5Fields: Lifespan and Group ONLY Group field Totals row: Group by Lifespan field Totals Row: Avg

5.6Report named rpt5_6 created Fields: Animal Origin Status

Q5— Section header —

Q6— Section header —

6.1.6Image <br/><br/><br/><br/> <img src="6Map. gif alt ="Zoo map"

Q6— Section header —

Q7— Section header —

7.1File management Q7 file renamed to Lions Folder compressed

7.2Filter: Filter according to different criteria Species: Text Filter: Contains: bear Reproduction in Captivity: Filter: Very Easy (Expected number of results: 2\

7.3Unique values display Remove Duplicates applied (Expected results: 10 unique mating systems\ 7Reproduction: Q7_4

7.4Subtotal Reproduction in captivity: Sort ed alphabetically At ach hange in: Reproduction in captivity

7.5.1Mail merge SELECT * FROM "Info" WHERE "DateJoined">= #2000/01/01# And "DateJoined"<=#2020/12/31# OR >#2019/12/31# nd <#2021/01/01 7AccessCard linked to data source

7.5.2Merged document Merged document saved as 7Merged (Note to marker: Ignore blank access card at the end of the merged document\ Total for

Q7— Section header —

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworking

Mark Allocation

Total150 marks

Sections19 + 35 + 15 + 15 = 84 marks

Key Information

Email Addressanna@cityzoo.org.za

Paper information

SubjectComputer Application Technology

Year2024

SessionMay-June

TypeMemo

PaperPaper 1

LanguageEnglish

Pages15

Downloads5

Examination context

Decade2020s

Years ago2y

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 size500.8 KB

Pages15

Archived on7 September 2026

File age47d

ContributorFreeMode

FingerprintDED72E8A7043

Questions and learner discussion

No questions or discussions have been posted yet.