Computer Applications Technology Grade 11 Term 4 November 2025 Questions and Answers Quiz

Computer Applications Technology (CAT) Grade 11 Term 4 November 2025 Questions and Answers Quiz is an interactive CAPS-aligned quiz page created to help learners practise and prepare for the final DBE exam. This quiz focuses on the Term 4 CAT curriculum — including data management, spreadsheets, databases, and internet technologies — giving you the same experience as the real November 2025 CAT Grade 11 exam format.

For more practice resources, question papers, and marking memos, visit:Computer Applications Technology Grade 11 Past Papers and Memos

About the Computer Applications Technology Grade 11 Term 4 November 2025 Quiz

This CAT Grade 11 Term 4 quiz includes true or false and multiple-choice questions that are based on real DBE exam topics. You will be able to test your knowledge of theory and practical application skills, including spreadsheets, databases, and communication technologies. After submitting your answers, instant feedback will help you identify your weak areas and understand the correct concepts.

Paper 1:

CAT Grade 11 Paper 1 – Practice Paper with Answers

Section A: Instructions and Setup • Section B: Word Processing • Section C: Spreadsheet • Section D: Database • Section E: HTML • Section F: General

Section A: Instructions and Setup
1) During a practical examination, what must you do with your answer files at the end?
All answer files must be readable and submitted as instructed.
2) Regional settings must be set to South Africa for date, time, number, and currency.
Settings affect formats used in marking.
3) In spreadsheets, calculations must be done using:
Use robust formulae with relative or absolute references where needed.
4) If files are provided on a flash drive, what must be written on it?
Identification is required on supplied media.
Section B: Word Processing
5) An endnote is best used to:
Endnotes collect reference details at the end page.
6) A citation does not need source name or address when inserted.
Citations require source details for validity.
7) To apply the same formatting to several subheadings quickly, create and apply a:
Styles enforce consistent formatting across headings.
8) To make the first page unnumbered and then show numbers on following pages, you would:
Different first page hides numbering on page 1.
9) Removing a hyperlink from an image can be done by clearing the link in the image formatting menu or context menu.
Right click and remove link, or use insert link controls.
Section C: Spreadsheet
10) To keep headings in row 7 visible while scrolling down a long list you should:
Freeze panes keeps header rows in view.
11) You need the most recent date in a range of dates. Which function is correct?
The most recent date is the maximum value.
12) To count numbers that start with 084 in a text column, use:
COUNTIF with a wildcard matches prefixes.
13) Conditional formatting can colour cells that contain the word “Paid”.
Text rules can format matching cells.
14) You want the total in column C only where the text in column B equals “Sales”. Which is most direct?
SUMIF sums values that match a criterion.
15) A chart must exclude one category without deleting the data. What should you do?
Chart filters control which categories are shown.
Section D: Database
16) To force a Short Text field to display uppercase letters, you can set:
Format or mask can force uppercase display.
17) Setting field size of a Short Text field to 15 allows unlimited characters to be stored.
Field size limits characters to the set maximum.
18) To store pictures in a record, the most suitable data type in Access is:
Attachments store files with records.
19) Which input mask validates two lowercase letters, a literal asterisk, then one required digit and one optional digit?
< forces lowercase, L letters, \* literal asterisk, 0 digit required, 9 digit optional.
20) A value list combo box with options such as BnB, Lodge, Hotel helps standardise entries in a field.
Drop-down lists control entries and reduce errors.
21) To return records with dates between 1 January 2004 and 31 December 2004, the correct criteria is:
Use a date range to restrict results to that year.
22) Grouping a report by one field and then sorting by another means:
Grouping controls sections. Sorting orders within them.
See also  Hospitality Studies Grade 11 Term 4 November 2025 Questions and Answers Quiz
Section E: HTML
23) Which tag sets the text that appears on the browser tab?
<title> controls the browser tab text.
24) The attribute alt=”Logo” shows alternative text if an image does not load.
Alt text is used by screen readers and when images fail.
25) To make an ordered list with Roman capital letters you would write:
Type “I” gives Roman capitals in ordered lists.
26) Which attributes correctly set an image to width 100 and height 100 and centre it using simple HTML only?
Legacy align=”center” can centre images in simple contexts. CSS is preferred.
27) The colour of a horizontal rule can be set with <hr color=”ff0000″>.
Older HTML supports the colour attribute. CSS is preferred now.
28) To create a link on the text “Visit site” you would use which structure?
Anchor tags with href create hyperlinks.
Section F: General
29) To print a large spreadsheet on one page without changing font sizes or column widths you should adjust:
Print scaling fits output to a page.
30) “Rows to repeat at top” ensures the top row prints on each page of the spreadsheet.
This header repeats for readability.
31) You want to export only rows where the Town column equals a specific value. What should you apply first?
Filtering restricts rows to a chosen value.
32) For an envelope mail merge that needs Surname, Name and Town, the best data source is usually:
Mail merge reads structured data from a spreadsheet.
33) Saving a worksheet as a PDF preserves layout for submission.
PDF keeps formatting stable for submission.

Paper 2:

CAT Grade 11 Paper 1 – Practice Paper with Answers

Section A: Instructions and Setup • Section B: Word Processing • Section C: Spreadsheet • Section D: Database • Section E: HTML • Section F: General

Section A: Instructions and Setup
1) At the end of the practical examination you must:
All answer files must be readable and submitted as instructed.
2) You may not leave the venue early even if you finish before time.
Administrative checks are completed at the end for everyone.
3) Regional settings must be set to South Africa to ensure correct:
Marking expects SA formats on outputs.
4) If files are issued on a flash drive, you must write on it your:
Identification is required on issued media.
Section B: Word Processing
5) An endnote is used to place referenced text:
Endnotes collect notes at the end page.
6) A citation does not need the source name or address information when inserted.
Citations require complete source details.
7) To apply the same formatting to all subheadings quickly you would create and apply a:
Styles ensure consistency and speed.
8) To leave page 1 unnumbered and use alternating footer alignment thereafter you should:
Header and footer options control numbering.
9) A bullet image like 1Bullet.jpg can be used as a custom bullet for a list.
List bullet picture is supported in word processors.
See also  Mathematics Grade 11 Term 4 November 2025 Questions and Answers Quiz
Section C: Spreadsheet
10) To keep row 7 headings visible while scrolling down you should use:
Freeze panes keeps headers on screen.
11) To find the DOB of the youngest participant in a DOB range you would use:
Youngest has the most recent (maximum) date value.
12) To count participants whose numbers start with 084 (Cell C), use:
COUNTIF with a wildcard matches prefixes.
13) Conditional formatting can colour cells containing “BnB” green with dark green text.
Text contains rules format matches.
14) To total amounts where First Activity equals “Whatif”, the most direct function is:
SUMIF sums values matching a criterion.
15) To show “Send email” only for participants with registration fee > 0 you should use IF to test for greater than zero.
The requirement was to show it for those who have not paid (equals zero).
16) A 3D clustered chart with full cone series and a gradient chart area is created. To exclude Grade 10 without deleting data you should:
Chart filters control visible categories.
Section D: Database
17) To display Surname in uppercase you can use in Access:
“>” converts entered letters to uppercase.
18) Setting field size of a Short Text to 15 allows unlimited characters to be stored.
Field size limits the max characters accepted.
19) To store pictures in a table field use the data type:
Attachment stores files with records.
20) Which input mask validates two lowercase letters, a literal asterisk, then one or two digits?
< forces lowercase, L letters, \* literal, 0 digit required (second could be 9 if optional).
21) A value list combo box with BnB, Lodge, Hotel helps standardise the Accommodation field.
Drop-down lists control entries.
22) To return Grade 10 and 11 participants born in 2004, a criteria on DOB should be:
Use a date range to limit to the year.
23) For a report grouped by Grade then Town and sorted by Surname you would:
Grouping defines sections; sorting orders records in each group.
Section E: HTML
24) Which tag sets the browser tab text to “Girl Child”?
<title> controls the tab text.
25) The attribute alt=”IMAGE” displays alternative text if the picture cannot be displayed.
Alt text is used by screen readers and on load failure.
26) To show an ordered list in Roman capitals you would write:
Ordered list type “I” uses Roman numerals.
27) Which attributes correctly size an image to 100 by 100 and centre it using simple HTML only (legacy) for this task?
Legacy align attribute centres images; CSS is preferred.
28) <hr color=”ff0000″ width=”80%”> sets a red horizontal line that is 80% width.
These attributes are supported in basic HTML for this task.
29) To link the text “Go to Website” to a URL you would use:
Anchor tags create hyperlinks.
Section F: General
30) To print a large sheet on one page without changing column widths or font sizes you should set:
Print scaling fits output to a single page.
31) “Rows to repeat at top” makes the header row print on every page of the sheet.
This keeps headings visible on printouts.
32) To filter participants from “Lady Frere” before exporting you would first:
Filtering restricts rows to the target town.
33) For a mail merge of envelopes containing Surname, Name and Town, the best data source here is:
Spreadsheets provide clean tabular data to merge.
34) Saving the filtered sheet as a PDF named 6_Export Data preserves layout for submission.
PDF keeps formatting stable across devices.

Topics Covered in the Term 4 CAT Quiz

1. Spreadsheets (Microsoft Excel or LibreOffice Calc)

  • Advanced functions and formulas such as IF, VLOOKUP, COUNTIF, and SUMIF.
  • Data validation, conditional formatting, and chart creation.
  • Setting up financial and statistical models for decision-making.
  • Using absolute and relative referencing correctly.
See also  Life Orientation Grade 11 Term 4 November 2025 Questions and Answers Quiz

2. Databases (Microsoft Access or Base)

  • Creating and editing tables, queries, forms, and reports.
  • Understanding data types, primary keys, and relationships.
  • Writing and testing SQL-like queries for sorting, filtering, and calculating data.
  • Linking databases to spreadsheets for integrated data analysis.

3. Word Processing and Document Formatting

  • Creating professional reports using styles, headers, footers, and table of contents.
  • Using mail merge, inserting images, and applying consistent document formatting.
  • Reviewing and tracking changes in collaborative documents.

4. Internet and Network Technologies

  • Understanding LAN, WAN, and network topologies.
  • Revising concepts like IP addresses, firewalls, and data encryption.
  • Safe internet use, digital citizenship, and cybersecurity awareness.
  • Cloud computing and online collaboration tools.

5. Social, Ethical, and Legal Issues

  • Responsible use of technology in education and the workplace.
  • Understanding POPIA, copyright, and plagiarism.
  • Identifying cyber threats such as phishing, malware, and identity theft.

6. Practical Application Integration

  • Combining spreadsheets, databases, and word processing tasks in one project.
  • Producing documents and reports that simulate real-life business or academic tasks.
  • Ensuring correct file management, folder structures, and naming conventions.

Download Term 4 November 2025 CAT Grade 11 Papers and Memos

Boost your exam readiness by working through official and practice papers for Computer Applications Technology Grade 11 Term 4 November 2025. Each paper includes a marking memorandum and detailed solutions for both practical and theory components.

  • Computer Applications Technology Grade 11 Term 4 November 2025 Question Paper 1 (Theory)
  • Computer Applications Technology Grade 11 Term 4 November 2025 Memorandum 1 (Theory)
  • Computer Applications Technology Grade 11 Term 4 November 2025 Question Paper 2 (Practical)
  • Computer Applications Technology Grade 11 Term 4 November 2025 Memorandum 2 (Practical)
  • Term 4 Practice and Revision Pack (PDF)
  • CAT Formula Sheet and Terminology List (PDF)

All available here: Computer Applications Technology Grade 11 Past Papers and Memos

Exam Scope for Computer Applications Technology Grade 11 Term 4 November 2025

Paper 1 (Theory – 100 Marks):

  • Computer hardware, networks, and internet technologies.
  • Social and ethical issues.
  • Systems technologies and security.

Paper 2 (Practical – 150 Marks):

  • Word processing, spreadsheets, and databases.
  • Integrated project requiring multiple software tools.
  • Problem-solving, data handling, and report generation.

Common Mistakes to Avoid

  • Forgetting to save work regularly or using incorrect file names.
  • Incorrect referencing in formulas (mixing relative and absolute).
  • Not checking for spelling, formatting, or layout errors in documents.
  • Failing to back up work on external drives or the cloud.
  • Overlooking data validation and print setup settings in practical tasks.

CAT Grade 11 Term 4 Revision Plan

Week 1: Spreadsheets and formula practice.
Week 2: Databases and queries.
Week 3: Word processing, mail merge, and formatting.
Week 4: Network theory, ethics, and cybersecurity.
Final 3 Days: Take past Paper 1 and Paper 2 under timed exam conditions.

Frequently Asked Questions

What is the purpose of the Computer Applications Technology Grade 11 Term 4 November 2025 Questions and Answers Quiz?

This is a quiz page designed to help learners practise Term 4 CAT concepts, improve accuracy, and prepare effectively for both theory and practical exams.

What topics are tested in this quiz?

The quiz covers spreadsheets, databases, networks, internet safety, and integrated applications, based on the CAPS Term 4 curriculum.

Can I take the quiz more than once?

Yes. You can retake the quiz as many times as needed to reinforce your understanding before the final exam.

Does this content follow the CAPS CAT Grade 11 curriculum?

Yes. Every topic aligns with the DBE CAPS Term 4 CAT Grade 11 requirements used in South African schools.

Final Exam Tip

When preparing for Computer Applications Technology Grade 11 Term 4 November 2025 Questions and Answers Quiz, remember that accuracy and consistency are key. Practise using your software tools daily, focus on applying correct formulas, and double-check formatting in all practical tasks. Use your quiz results to target weak areas and perfect your timing for the DBE final practical and theory exams.

---advert---