Computer Applications Technology Grade 12

Computer Applications Technology · Grade 12 · Exam Revision Date: Top Journal

Every distinction begins with one topic at a time.- start now

CAT · Two Papers · 150 + 150 = 300 external marks

REVISION · START HERE HOW THE CAT EXAM WORKS

Two papers, one project and a full year of class marks all carry the same weight. The exam does not reward panic, it rewards the learner who already knew the shape of what was coming.· know the map before the race

Computer Applications Technology is really two subjects wearing one name. One half lives at a keyboard, where you build real documents, spreadsheets, queries and web pages against the clock. The other half lives on paper, where you explain in precise, marked words how the technology works. On top of both sits a year-long project and your ordinary class marks, and each of those four things counts for exactly the same. Get the shape of the assessment clear now, and every revision hour afterwards spends itself in the right place.

The two papers at a glance

Paper	Type	Marks	Time	What it holds
Paper 1	Practical, hands-on at a computer	150	3 hours	Word processing, spreadsheets, databases, and web pages built in HTML, plus integration of data across them
Paper 2	Theory, written	150	3 hours	Systems technologies, networks and the internet, information management, social implications, and the theory behind the practical applications

⚡ MUST MEMORISE Two papers, each 3 hours long and each worth 150 marks, so 300 marks are written in the final exams. Paper 1 (practical) was cut from 180 to 150 with the 2021 CAPS amendments, so an older book or past paper may still show 180 and a 330 total; the current papers are 150 and 150. The promotion mark is then built from THREE components, not four quarters: the SBA year mark 25%, the PAT 25%, and the two external papers together 50%: Paper 1, Paper 2, the PAT and the SBA. In the theory paper the cognitive levels run 30% recall, 40% application and 30% higher-order, with up to 10% of the paper on newer technology.

The marks that promote you

Your final promotion mark is not the exam alone. It is built from three components: the two external papers together (50%), the PAT (25%) and the internal SBA year mark (25%). The PAT and the SBA therefore decide half of your result before you even sit the final papers.

📖 KEY DEFINITION The PAT (Practical Assessment Task) is a compulsory practical project completed on a computer across the year, built around a single scenario and producing real files (a document, a spreadsheet, a database and an integrated report). The SBA (School-Based Assessment) is your internal year mark, earned from class tests and the mid-year and trial examinations. Both are marked long before you sit the final papers, yet together they settle half of your promotion mark.

The PAT is worked in three phases spread through the first three terms, with one scenario carried the whole way:

⚠️ COMMON MISTAKE Treating the PAT as a small side task. It is a full quarter of your final mark and it is built up in phases through the year, so work left to the last week cannot be recovered. A strong PAT and SBA can carry a learner who has a shaky day in one of the written papers, which is exactly why they are worth guarding.

What the written paper is testing

Every question in the theory paper is pitched at one of three thinking levels, and the paper is balanced to a set spread. Knowing the spread tells you why pure memorising is not enough on its own.

Level	What it asks of you	Share of the paper
Level 1	Remember facts and follow routine steps: name it, list it, define it	about 30%
Level 2	Understand and apply: explain why, and work through a multi-step situation	about 40%
Level 3	Analyse, evaluate and solve: weigh options, then recommend and justify	about 30%

⭐ EXAM FAVOURITE The integrated scenario that closes the theory paper. One realistic situation, often a school, a small business or an event, pulls in systems, networks, social implications and the theory of the applications all at once, and asks you to recommend and justify. Roughly a third of the whole theory paper sits in that single scenario, so the learner who can argue a choice, not just recite a fact, gains the most marks here.

🔥 FREQUENTLY TESTED The marking convention itself. One mark is one distinct fact, so a question worth two marks needs two separate points. Vague comparatives such as "cheaper", "faster" or "easier" score nothing on their own; each must be finished with a reason. A modified true/false answer must supply the corrected word, not just "false".

Your exam-day plan

Both papers give you 3 hours for 150 marks, so a clean rule of thumb is about one minute per mark, which still leaves roughly half an hour spare for reading at the start and checking at the end. Budget each question by its marks and the clock stops being the enemy.

Marks on the question	Rough time to give it
2 marks	about 2 minutes
5 marks	about 5 minutes
10 marks	about 10 to 12 minutes
The large integrated scenario (about 50 marks)	about 50 to 55 minutes, kept safe at the end

On the day · Paper 1, the practical

Spend the first few minutes reading the whole paper and opening every data file named in the instructions, so nothing is a surprise later.
Work question by question and save the moment a question is done, using the exact file name, format and folder the question demands. A file saved wrongly can score zero even when the work inside it is right.
Press save constantly while you work, not only at the end. A practical paper is one power dip away from lost work.
Never leave a formula or query half-built. A broken formula that returns an error usually earns less than a simpler one that actually works.
Keep the last few minutes to save every file once more and confirm each is stored in the right place.

On the day · Paper 2, the theory

Read each question and note its mark value in the margin. The marks tell you exactly how many facts to give.
Give one clear, distinct point per mark, and finish every comparative such as "faster" or "cheaper" with its reason.
Answer precisely what is asked: "name" wants a word, "explain" wants a because, "discuss" wants both sides.
Leave a solid block of time, close to an hour, for the integrated scenario at the end, where the higher-order marks live.
Use any spare minutes to fill blanks. An unanswered question is a guaranteed zero, a reasoned attempt is not.

💡 EASY MARK The reading minutes at the very start of each paper are the cheapest marks you will ever earn. Learners who begin typing or writing immediately misread the instructions, save files wrongly and answer the question they imagined instead of the one printed. Read first, then work.

⚠️ COMMON MISTAKE Two costly habits sink good learners. In the practical paper, forgetting to save often and in the exact format asked. In the theory paper, spending so long on the early short questions that the large scenario at the end is rushed. Guard the clock and guard your files.

Seeing the whole assessment at once can feel heavy. It is only four equal parts, and you meet them one at a time. Take a breath →

P1 · Word Processing · ≈ 45 marks

PAPER 1 REVISION WORD PROCESSING

The document never has to be clever, it has to match the example exactly, and every feature you truly insert is a mark you truly keep.· build it, do not fake it

Word Processing opens Paper 1 and it is where the fastest marks live, because almost every instruction is "make this document look exactly like the printed example". The marks are awarded feature by feature, not for the finished look: an inserted table of contents, a real caption, a footnote in the right place, a cross-reference that updates itself. The single skill that separates a distinction here is knowing which ribbon tab hides each feature, and never typing by hand what the program is supposed to insert.

What you must be able to do

Insert an automatic table of contents built from applied heading styles, then update the entire table with F9
Caption figures and tables as fields so they auto-number, and generate a table of figures from those captions
Place a footnote at the foot of its own page and an endnote at the end of the document, choosing correctly between the two
Insert a cross-reference to a heading, figure or page number that updates itself when the item moves
Switch on Track Changes, then accept or reject edits and insert or delete comments as the instruction asks
Insert a Next Page section break and unlink Link to Previous so one part can carry its own orientation, header or footer
Run a mail merge from a main document, a recipient list and merge fields, and hand in the file the question names

Where the marks are won

Insert and update an automatic table of contents built from heading styles, and a table of figures built from captions
Caption figures and tables so they auto-number, and tell a footnote from an endnote
Insert a cross-reference to a heading, figure or page number that updates itself
Review a document: Track Changes, accept or reject, and insert and manage comments
Break a document correctly, a page break versus a section break, and unlink Link to Previous for a one-section header or footer
Run a mail merge from a main document, a recipient list and merge fields
Build a protected form and clean a file with the Document Inspector

🔥 FREQUENTLY TESTED Per-step marking. A referencing or formatting task worth six marks earns a mark for each separate feature built correctly, not one mark for the whole page. Build every feature the instruction lists, in order, and claim each mark on its own, even if one step defeats you.

Referencing: the References tab

📖 KEY DEFINITION A table of contents is an automatic list of the document's headings with their page numbers, generated from the heading styles (Heading 1, 2, 3), not from text you type. A caption is a numbered label attached to a figure or table (for example Figure 1) that renumbers itself when figures are added or removed. A cross-reference is a link to another item (a heading, figure, table or page number) that updates automatically when that item moves.

Feature	How to build it	What earns the mark
Table of contents	Apply Heading 1/2/3 styles to the headings, then References, Table of Contents, choose an automatic style. Update with F9 or right-click, Update Field, Update entire table.	A mark for an inserted TOC field (not typed), a mark for it reading the heading styles, a mark for updating the whole table
Caption + table of figures	Select the image or table, References, Insert Caption, pick the Figure or Table label. Then References, Insert Table of Figures to list them all.	A mark for a caption inserted as a field that auto-numbers, a mark for the generated table of figures
Footnote / endnote	Click at the reference mark, then References, Insert Footnote (foot of the page) or Insert Endnote (end of the document), and type the note.	A mark for the note at the correct mark, a mark for choosing footnote versus endnote correctly
Cross-reference	Insert, Cross-reference, choose the Reference type (heading, figure, table) and Insert reference to (page number, heading text, label and number), tick Insert as hyperlink.	A mark for the correct reference type, a mark for a reference that updates with F9

Footnote versus endnote is a guaranteed distinguish-pair, so keep the difference exact:

Feature	Footnote	Endnote
Where it appears	At the foot of the same page as its reference mark	Gathered at the very end of the document (or section)
Typical use	A short note or source needed on that page	A full list of notes collected together at the end
Numbering	Auto-numbered superscript, renumbers when notes change	Auto-numbered, often i, ii, iii, and also renumbers

⭐ EXAM FAVOURITE The "make it match the example" front-matter block is almost guaranteed: apply heading styles, insert an automatic table of contents, caption the figures, add a footnote, and cross-reference one item to its page. Each feature is its own mark, and the closing instruction is nearly always to update the fields, so finish by pressing F9 and choosing Update entire table.

⚠️ COMMON MISTAKE A table of contents typed by hand, or generated before any heading styles were applied, so it stays empty or wrong. Updating only the page numbers when Update entire table was needed. A caption typed as plain text, so it will not auto-number. A footnote inserted where an endnote was asked for, or the reverse.

Reviewing: the Review tab

Feature	How	Mark-earning detail
Track Changes	Review, Track Changes on. Edits then show as coloured insertions and deletions.	A mark for turning it on so edits are recorded
Display for Review	The view box: All Markup shows the changes, No Markup shows the clean result, Original shows the start. It only changes the VIEW.	A mark for choosing the right view when asked to show or hide markup
Accept / Reject	Review, Accept or Reject (this one, all shown, or all in the document). This actually applies or removes the change.	A mark for a genuinely clean final document
Comment	Select the text, Review, New Comment, and type. Reply, Resolve or Delete it. A comment is a margin note, not a tracked change.	A mark for the comment on the correct text

⚠️ COMMON MISTAKE Confusing No Markup (a view that only hides the changes on screen) with Accept All (which permanently applies them): a document set to No Markup still carries every tracked change underneath. Deleting a comment when the instruction was to delete a tracked change. Leaving Track Changes switched on, so the marker's own corrections get tracked too.

Breaks, headers and footers

📖 KEY DEFINITION A page break forces the following content onto a new page but keeps it in the same section, so the whole document still shares one set of headers, footers, orientation, columns and page numbering. A section break starts a new section, which may have its own headers and footers, page orientation, columns, margins and page numbering. Anything that must differ between parts of a document can only differ across a section break.

Memory hook: a PAGE break just pushes text down; a SECTION break separates the document so each part can differ.

⚠️ COMMON MISTAKE Confusing a section break with a page break. A page break only moves content to a new page, it cannot give that page its own header or footer, a landscape orientation, a different column layout, or restarted page numbers. Every one of those needs a section break (Layout, Breaks, Next Page). If you use a page break where a section break was required, one change spreads to the whole document instead of the one part you meant.

⚡ MUST MEMORISE Which ribbon tab hides the mark: References = table of contents, captions, footnotes, cross-references. Review = track changes and comments. Layout = page and section breaks. Mailings = mail merge. Developer = form fields and protect. After a section break, Link to Previous is still ON, so the new header copies the old one until you turn it off, that is how a "last page only" footer or a mid-document page-number restart is done.

Worked example · a 14-page heritage report, marked feature by feature

Q: You are given a long report and a printed example, and asked to finish the front matter and references so they match. (9 marks)

(a) Style every main section title as Heading 1 and each sub-title as Heading 2, so the contents page can find them. (1)

(b) On a new first page, insert an automatic table of contents (References, Table of Contents) showing Heading 1 and 2 only. (2)

(d) Caption each remaining image, then insert a table of figures on the contents page so all captions are listed and auto-numbered. (2)

(e) Add a footnote to the word sponsorship at the foot of its page, explaining the sponsor. (1)

(f) Cross-reference the phrase see the results table to that table's page number, ticked as a hyperlink. (2)

Finish by updating the whole table of contents and the cross-reference with F9. Each feature is a separate mark, and each is lost the moment it is typed by hand.

Worked example · one landscape page and a last-page footer

Q: A portrait report must contain one landscape page for a wide table, and the file path must appear in the footer of the last page only. (5 marks)

(a) Put the cursor before the wide table and insert a Next Page section break (Layout, Breaks, Next Page); insert another after it. The table now sits in its own section. (2)

(b) With the cursor in that middle section, set the orientation to Landscape. The portrait pages on either side are untouched, because they are separate sections. (1)

(c) Double-click the last-page footer and switch off Link to Previous, so this footer stops copying the one before it. (1)

(d) Insert the file-path field (Quick Parts, Field, FileName with path). It now shows on the last page only. (1)

Try this with page breaks instead, and every page turns landscape and every footer shows the path, because without a section break the document is still one section.

Mail merge: the Mailings tab

📖 KEY DEFINITION A mail merge combines three ingredients to produce many personalised documents at once: a main document (the letter, label or certificate that stays the same), a recipient list or data source (a Word table, an Excel sheet or an Access table of records), and merge fields (placeholders such as «FirstName» that are replaced by each record's data).

💡 EASY MARK The reliable merge marks are the mechanical steps: Select Recipients and pick the correct existing list, Insert Merge Field at each placeholder, and Preview Results to prove real names appear. Naming the correct data source and previewing without error are marks you can bank before any conditional rule.

⚠️ COMMON MISTAKE No space or comma typed between two adjacent merge fields, so «FirstName»«Surname» prints as TshepoMokoena. Selecting the wrong data source. Sorting or filtering the recipient list when the question asked, then forgetting to apply it. Handing in the setup main document when the merged document was required, or the reverse.

Worked example · personalised award certificates

Q: Produce one certificate per learner from a list, congratulating first-place winners differently. The data source is a sheet with columns FirstName, Surname, Event and Position. (6 marks)

(a) Start Mail Merge and choose Letters (or Directory to fit many on one page). (1)

(b) Select Recipients, Use an Existing List, and pick the spreadsheet. (1)

(c) Type the certificate once in the main document, then insert «FirstName» «Surname» with a space between the two fields, and the «Event» field in the sentence. (2)

(d) Add a rule (Rules, If...Then...Else) so that when Position equals 1 it prints Congratulations on first place. (1)

(e) Preview Results to check real names appear, then Finish and Merge, Edit Individual Documents, to create the completed file to hand in. (1)

Forms and finishing: Developer tab and Document Inspector

📖 KEY DEFINITION An electronic form is a protected document in which users may only fill in form fields, not change the rest. Build the fields on the Developer tab (Legacy Tools): a text field, a check box or a drop-down. A field's Properties set its behaviour, for example an Uppercase text format, a Maximum length of 10 for a phone number, or a date format. Protect it with Restrict Editing, allow only Filling in forms, Start Enforcing Protection. The Document Inspector (File, Info, Check for Issues) finds and removes hidden metadata such as the author name, comments and tracked changes before a file is shared.

💡 EASY MARK Free setup marks come from the standing instructions: switch on the Developer tab and the Ruler, insert your exam number in the header or footer, and save with the exact file name given. In a form, set a field property such as Uppercase rather than retyping the entry in capitals, and remember to enforce protection, or the fields are just ordinary editable text.

Referencing has a lot of small steps to hold at once. Take a breath and reset before the recall →

🧠 ACTIVE RECALL

A heading does not appear in the automatic table of contents. What is almost always the reason?(2)

You need ONE landscape page inside an otherwise portrait document. What must you insert around it?(2)

After a Next Page section break, the new page's footer still shows the previous section's text. What must you switch off?(2)

Which are the three ingredients of a mail merge?(2)

Display for Review is set to No Markup. What does this actually do?(2)

Where does a footnote appear?(2)

What is the Document Inspector used for?(2)

Explain the difference between a page break and a section break, and give one situation where only a section break will work.(4)

Describe the three ingredients of a mail merge and the steps to produce personalised letters, and state what earns the marks.(5)

Explain to a Grade 8: why can an automatic table of contents update its own page numbers, but a contents page you typed by hand cannot?

ONE-MINUTE SUMMARY The referencing features all live on the References tab and must be inserted as fields, never typed: an automatic table of contents reads the heading styles and updates the whole table with F9; captions auto-number figures and feed a table of figures; a footnote sits at the foot of its page while an endnote sits at the end of the document; a cross-reference points at a heading, figure or page and updates itself. Reviewing lives on the Review tab: Track Changes records edits, the Display for Review views only change what you see while Accept or Reject actually applies them, and a comment is a margin note, not a tracked change. A page break only starts a new page; a section break starts a new section, the only way to give a part its own header, orientation, columns or page numbering, and after one you must switch off Link to Previous. A mail merge needs a main document, a recipient list and merge fields. Forms are built on the Developer tab and protected as Filling in forms, and the Document Inspector strips hidden metadata before a file is shared.

IN THE EXAM

Word Processing opens Paper 1 and is marked per step: every feature you insert correctly is its own mark, so build the feature, never fake it by typing.
The single biggest trap is a section break versus a page break, so read whether the change needs a whole new section (header, orientation, columns, numbering) before you press Ctrl+Enter.
Update every field (table of contents, cross-reference, table of figures) with F9 before saving, and choose Update entire table, not just page numbers.
For a mail merge, hand in the document the question asks for, sometimes the main document with its fields, sometimes the finished merged document, saved under the exact given file names.
Switch on the Developer tab and Ruler at the start, insert your exam number in the header or footer, and enforce protection on any form.

🔒 P1: SPREADSHEETS

🔒 P1: DATABASES

🔒 P1: HTML & INTEGRATION

🔒 P2: SYSTEMS

🔒 P2: NETWORKS & INTERNET

🔒 P2: INFO MGMT & SOLUTION DEV

🔒

8 more topics locked

This is a free preview of Topic 1. The full guide has every topic, the self-marking quizzes, mock exams, planner, journal and wellbeing tools.

Unlock the full guide on WhatsApp See pricing

A winner is a loser who tried one more time.- keep going, all the way to the exam