Gr 12 CAT November exam notes - compiled by using at 2019 – 2021 DBE/ SACAI previous examination papers. The notes are compact, colourful and easy to study – giving possible answers directly from the memorandums. Making it perfect for learners with learning barriers or that struggles to remembe...
COMPUTER
APPLICATIONS
TECHNOLOGY
Grade 12
NOV EXAM
PAPER 2
2023
These notes were compiled by previous papers of NSC NOV: CAT PAPER 2/2018, NSC NOV: CAT PAPER
2/2019, NSC NOV: CAT PAPER 2/2022NOTE: These are only suggested answers. Some information is
repeated, I want to show you the different ways the same information is asked for.
I encourage you to answer the computation/illustration questions without even looking at the answers.
Good luck . Juffrou Ansie
Topics:
1. Multiple questions
2. System technologies
3. Network And Internet Technology
4. Information Management
5. Social Implications
6. Solution Development
GPS A series of satellites and receiving devices used to determine positions on
the earth
Cookie A text file containing information about the user's preferences and choices
regarding a specific website. The way a website remembers you, your habits
online and your preferences.
,Input mask Database feature used to ensure the correct format of data input by the user
Cap The limit placed on the amount of data a user can transfer via the internet in
a period of time, for example a month
SUMIF A spreadsheet function used to add together the values of all the cells
matching certain criteria
Thread A feature in many e-mail clients, online forums, newsgroups, IM clients, etc.,
which automatically groups messages according to a topic or sender
Thumbnail A small picture that provides a preview of the file without opening the file
BYOD Employees are allowed to bring and use their own portable devices such as
smartphones, laptops, tablets, etc. to work on and access the work’s
network.
Copyright Laws that are put in place to protect ownership and rights to intellectual
property.
A podcast A podcast is a recorded audio message stored on a website that can be
downloaded to a digital device.
Click jacking Click jacking is when users are tricked into clicking on an item on a web page
which acts as a concealed link.
GEO-tagging GEO-tagging is a process where the geographical position of an item, such as
where a picture was taken, is added to the metadata of the file
Validation Validation is used to check the correctness of the data in a database or a
spreadsheet application.
Proprietary Proprietary software is software for which a licence needs to be purchased in
order to use it.
CPU Hardware components that can be replaced/upgraded to increase the
RAM performance of your computer
Hard drive
Device driver It is software/program/utility that allows the device to communicate with/be
used by the operating system/computer.
Graphical User An interface which allows the user to interact with text, graphics and icons
Interface (GUI) on the screen
,ISP ISP is a company with a permanent connection to the Internet that
provides/offers Internet access/services
OCR The type of software needed to convert scanned text to editable text, do not
give the name of specific software or a brand name.
Adware Software that displays adverts/cause pop-up adverts.
Product key A code linked to software which users need to enter to install/use/activate
the software
Why storing data → To access files on the Internet from any device.
online is a good idea → You don’t have to carry storage devices with you.
→ All team member will have access to the files
Integrated It is built into the computer/motherboard
Apps A term/name for a program designed for use on smartphones.
GIGO This principle refers to the concept that inaccurate data will produce
inaccurate information/results.
Blu-Ray A type of DVD technology.
A query criteria in a A condition that you specify for a field.
database
Adobe Flash A program used to create animations for use on websites
Count Blank The Count Blank spreadsheet formula counts the number of empty cells in a
specified range of cells.
FTP (File Transfer FTP (File Transfer protocol) allows for the transfer of files between computers
protocol) that use the internet.
CSV the type of file or the extension of the file where the data on each line in the
file is separated by commas.
A zombie computer A zombie computer on a network is a computer that has been hacked to
perform malicious tasks.
Bots/Zombie A computer that has been accessed and can be controlled remotely when
connected to the internet.
Botnet Multiple computers that have been infected/accessed (many bots/zombies)
A soft cap With a soft cap the user is allowed restricted internet connectivity after the
limit has been reached.
,An all-in-one memory One memory card reader will work with all memory cards
card reader
Firewall Monitors programs on your computer that tries to access the internet and
monitors outside attempts made to access your computer
Text/txt file a file format that can be used to import data to various applications e.g.,
import data into a spreadsheet or database application.
Date picker content a control that can be used in the questionnaire to ensure that the format of
control the date will be correct.
Information.exe This file is most likely to be blocked by one’s e-mail system
Infrared Wireless communication technologies that has the shortest reach
The aim of this testing is to stop a bot program in order to stop Spam
The Review tab The Review tab on the Microsoft Word ribbon includes functions such as
accepting or rejecting changes.
<> The relational operator <> is used to exclude a value.
=NOW() Function to return the current date and time.
Content aggregator Website that gathers different web content from many different online
sources.
Email icon: Add an attachment
Email icon: To indicate that it is an important e-mail. OR To get back to the
flagged/starred e-mail later.
Errors/ problems Possible solutions
non-system disk error • Re-install/Repair the operating system and restart
the computer.
• Remove CD/flash disk and restart the computer.
• Disconnect any USB/Firewire devices.
• Check the SATA or IDE cables
,Survey A set of written/typed questions completed by many
people
Interview A verbally administered set of questions completed
by one person (such as an expert).
You need to print the preliminary version of a → Print at a lower quality/draft/resolution.
document. Without making any changes to the → Print in greyscale/economic mode.
document, indicate what you would do to use
as little printer ink as possible.
How the school can stop learners from → Use a program that will block specific types of
accessing some social media sites while sites. (Accept brand names such as iCop, Net
allowing access to others. Nanny or NetOp, etc.
→ Use proxy server/firewall to block the sites.
(Accept only proxy or only server).
Square brackets are used around the field name.
The between the square brackets, [ ], and the Round brackets are used for calculations or to force
round brackets, ( ), in the formula above by the correct order in which calculations are
describing the purpose of each one. performed
Reduce the size of the attachment. → Save it in a different format, e.g. jpeg.
→ Save it with a lower resolution.
→ Compress or zip the file, etc.
→ Cropping/resizing the picture.
What could have happened to e-mails that → Problem with ISP/Internet Service Provider.
were sent out successfully but are not visible → E-mail may have been identified as
in the inbox of the receiver? spam/Placed in/junk mail folder.
→ Sent to the wrong e-mail address.
→ E-mail attachment size too large.
→ Insufficient storage/Inbox is full.
→ Addresses have been blacklisted.
A document is not printing to the installed The installed printer is not selected / default printer
printer. incorrect. It will print to/as a PDF document.
, You have inserted a picture in a word Correct/change the formatting/wrapping style.
processing document. The problem is that you Steps: Format tab Wrap text. Right click Format
are unable to move the picture to a different picture.
location on the page in the document.
Criteria to apply in which to improve the ❖ Use special characters.
following password: 4M4m4M4M ❖ Do not use patterns.
❖ Increase the length of the password.
❖ Use a variety of letters, characters and digits.
2. SYSTEM TECHNOLOGIES
You use your smart phone to take a couple of photographs. Each one of the JPEG
photographs was 2 MB in size.
Hardware components that can be used to record a video of a choir singing NSC NOV: CAT PAPER 2 2022
↘ Video camera
↘ Webcam
↘ Microphone
Picture file formats NSC NOV: CAT PAPER 2 2018
• JPEG
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ansiestudynotes. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R87,00. You're not tied to anything after your purchase.
