# Computer Applications Technology Grade 12 P2 2015 Memo (Eng)

> Grade 12 Computer Applications Technology Paper 2 memorandum from the NSC November Exam 2015 (English), 19 pages. Read online or download the free PDF.

- Page: https://www.hlayiso.com/library/cat-p2-nov-2015-memo-eng/f1235bb1-b756-4cea-859a-56092ca7b3e0
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2015
- Exam period: NSC November Exam
- Paper: 2
- Curriculum: CAPS
- Pages: 19

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Computer Applications Technology](https://www.hlayiso.com/library/grade-12/computer-applications-technology) › [Computer Applications Technology Grade 12 P2 2015 Memo (Eng)](https://www.hlayiso.com/library/cat-p2-nov-2015-memo-eng/f1235bb1-b756-4cea-859a-56092ca7b3e0)

## About this document

Computer Applications Technology · Grade 12 · NSC November Exam · 2015. Memorandum, 19 pages. Read online or download the PDF.

Read it free online on the page above; download the PDF from there.

## Document text

Text extracted from the PDF. Layout, diagrams and tables may not survive extraction.

### Page 1

Downloaded from hlayiso.com

                                    NATIONAL
                               SENIOR CERTIFICATE

                                     GRADE 12

                     COMPUTER APPLICATIONS TECHNOLOGY P2

                                  NOVEMBER 2015

                                   MEMORANDUM

MARKS: 150

                         This memorandum consists of 19 pages.

Copyright reserved                                               Please turn over

### Page 2

Downloaded from hlayiso.com
Computer Applications Technology/P2           2                     DBE/November 2015
                                      NSC – Memorandum

SUGGESTIONS AND RECOMMENDATIONS TO MARKERS

•     Revisit the questions and the memorandum/marking guideline frequently during the
      marking session.

•     It is advisable to read the question frequently (and re-read) together with the
      candidate's response to check that it correlates, so that you are not misled by the
      candidate's statements/answers.

•     Be careful not to focus on keywords or general statements, but rather read the entire
      answer. If in doubt, read the entire answer and then the question paper and
      memorandum. Ask yourself or your senior marker if the response could ΄fit΄ into the
      memorandum before allocating the correct marks to the candidate. For example, the
      memorandum states 'cheap' and the learner responds with 'less expensive'.

•     Beware of overlapping answers to a specific question. In general, ONE mark is
      awarded per fact.

SECTION A
QUESTION 1: MATCHING ITEMS                         QUESTION 2: MULTIPLE-CHOICE

1.1           N                        1          2.1         A                          1

1.2           I                        1          2.2         C                          1

1.3           A                        1          2.3         B                          1

1.4          B/P                       1          2.4         D                          1

1.5           O                        1          2.5         C                          1

1.6           G                        1          2.6         A                          1

1.7           R                        1          2.7         C                          1

1.8           E                        1          2.8         C                          1

1.9           H                        1          2.9         D                          1

1.10          D                        1          2.10        D                          1

                               Total: [10]                                       Total: [10]

Copyright reserved                                                      Please turn over

### Page 3

Downloaded from hlayiso.com
Computer Applications Technology/P2           3                          DBE/November 2015
                                      NSC – Memorandum

QUESTION 3: MODIFIED TRUE OR FALSE
(Note to marker: In Question 3.2, 3.3 and 3.4 candidates need to give the correct term,
e.g. printers, in order to get the mark.)
3.1          True                                                                     1
3.2          False – OLE object/attachment                                            1
3.3          False – social engineering                                               1
3.4          False – conditional     OR True                                          1
3.5          True                                                                     1
                                                                                      [5]
                                                             TOTAL SECTION A:        [25]

Copyright reserved                                                         Please-turn-over

### Page 4

Downloaded from hlayiso.com
Computer Applications Technology/P2            4                            DBE/November 2015
                                       NSC – Memorandum

 SECTION B

 QUESTION 4: SYSTEMS TECHNOLOGIES
 4.1         •       i7 3.0 GHz CPU
             •       8 GB DDR3
             •       1600 MHz RAM
             •       802.11 a/b/g/n
                                                                   (Any two)

             (Note to marker: Accept any valid reference to the specifications.)          2
 4.2         RAM temporarily only holds/stores programs/data currently
             being/waiting to be processed by the CPU.

             Hard drive stores all programs/data/files/information/Hard drive is
             permanent storage.                                                          2
 4.3         •       Architect
             •       Gamer
             •       Scientist/Engineer
             •       Programmer/Software developer
             •       Photographer
             •       Video editor
             •       Games developer/designer
             •       Web designer
             •       Graphics designer, etc.
                                                                   (Any two)

             (Note to marker: Accept any valid answer that relates to a
             category of power user as opposed to typical end-user
             categories.)                                                                 2
 4.4.1       One device that has the functionality of many devices/Combining        1
             functions of multiple devices in a single device
 4.4.2       •       Smartphone/Cell phone                                          1
             •       Tablet/Phablet
             •       Smart watch
             •       Smart TV
             •       Multi-function printer, etc.
                                                                     (Any one)

             (Note to marker: Accept any valid example.)                                  2
 4.5         •       USB 3.0
             •       802.11 a/b/g (Wi-Fi)
                                                                     (Any one)           1
 4.6         Driver                                                                      1
 4.7         OCR                                                                         1
Copyright reserved                                                            Please-turn-over

### Page 5

Downloaded from hlayiso.com
Computer Applications Technology/P2           5                               DBE/November 2015
                                      NSC – Memorandum

 4.8         8 MP webcam/Higher resolution webcam produces
             images/video of a higher quality that uses more data                           2
 4.9         •       More durable/No moving parts
             •       Faster (data transfer rates)
             •       More energy efficient/Uses less power/Promotes green
                     computing
             •       No noise
             •       Not affected by magnetism
                                                                   (Any two)               2
 4.10        •       (Wi-Fi) router
             •       Wireless access point (WAP)
             •       (USB) modem or dongle or mobile phone
                                                                       (Any one)

             (Note to marker: Do not accept the 802.11 specification or
             hotspot.)                                                                       1
 4.11.1      Microphone/Headset                                                       1

             (Note to marker: Do not accept headphones.)
 4.11.2      •       Can take long to train the software to the individual/Is not      2
                     very accurate
             •       Background noise can affect the recognition process
             •       Microphone quality can reduce effectiveness of recognition
             •       Easily affected by voice inflections/accents/changes in voice
                     due to colds, etc.
                                                                        (Any two)

             (Note to marker: Do not accept any items not related to using
             voice recognition software such as cost, etc. Accept 'not readily
             available in all languages'.)                                                   3
 4.12        •       Anti-virus scan running
             •       Defragmentation program running
             •       Large download occurring/Uploads such as cloud storage
                     sync occurring
             •       Accept any issues relating to updates not being done or
                     updates being done and slowing down performance
             •       Outdated drivers or software
             •       Too many add-ons installed on the browser
             •       Using memory intensive programs
             •       Too many applications open/Excessive use of virtual
                     memory, etc.
                                                                     (Any two)

             (Note to marker: Do not accept any items relating to hardware.)                 2

Copyright reserved                                                               Please-turn-over

### Page 6

Downloaded from hlayiso.com
Computer Applications Technology/P2           6                                DBE/November 2015
                                      NSC – Memorandum

 4.13        •       Central updating/changing of prices
             •       More efficient stock control/keep track of goods
             •       Much faster process at checkout
             •       Facilitates analysis of sales data
             •       Greater accuracy/Fewer mistakes by scanning
                     barcodes/prices, etc.
                                                                         (Any two)         2
 4.14        •       Provide basic security
             •       Provide a user interface/GUI
             •       Starting up and shutting down a computer
             •       Manage software
             •       Manage memory
             •       Co-ordinate tasks
             •       Configure devices/Install drivers
             •       Manage hardware/peripherals/manage resources/manage
                     storage/file management, etc.
                                                                (Any two)                  2
                                                                                            [25]

Copyright reserved                                                               Please-turn-over

### Page 7

Downloaded from hlayiso.com
Computer Applications Technology/P2           7                              DBE/November 2015
                                      NSC – Memorandum

 QUESTION 5: INTERNET AND NETWORK TECHNOLOGIES
 5.1         •       Much cheaper
             •       Call costs the same irrespective of distance
             •       Allows for audio and visual transmission/video conferencing
             •       Can make calls wherever there is Internet access
             •       Widely available/Can be used on different devices, etc.
                                                                      (Any two)            2
 5.2         •       Servers provide services/resources to client computer
                     OR
             •       Clients request services/resources from servers 

             (Note to marker: Accept examples of specific services/resources
             generally provided by servers.)                                                 1
 5.3         •       WAN
             •       VPN
             •       GAN
             •       WRAN
                                                                        (Any one)           1
 5.4         •       Grid computing refers to the use of multiple
                     computers/servers
             •       for processing/solving problems/as if it is one
                     computer/pooling resources                                             2
 5.5         •       (URL starts with) https
             •       Part of the address bar turns green
             •       The icon/image of a 'padlock' appearing, etc.
                                                                        (Any one)

             (Note to marker: Accept reference to digital/security certificate
             /privacy icon.)                                                                 1
 5.6         Upgrade to/install suitable software such as a media player/plug-
             in e.g. Adobe Flash Player, QuickTime, Shockwave player, etc.

             (Note to marker: Do not accept using another browser or trying to
             view the video on another computer or website. Accept upgrading
             to another version of the same the browser.)                                    1
 5.7.1       Downloading is when data is received by you, and uploading is            2
             when the data is sent by you.

             (Note to marker: Accept specific examples of uploading or
             downloading.)

Copyright reserved                                                               Please-turn-over

### Page 8

Downloaded from hlayiso.com
Computer Applications Technology/P2           8                               DBE/November 2015
                                      NSC – Memorandum

 5.7.2       Downloading is usually faster than uploading/uploading is               1
             normally slower than downloading.

             (Note to marker: Learner must specify which one is faster/slower.)             3
 5.8         •       Upload to the Internet/cloud (DropBox/One Drive/Google
                     Drive, etc.)/web server (and share a link to the file)
             •       Use social networking tools that provide file sharing
                     capabilities (accept suitable examples)
             •       Use FTP
             •       Send the file as a torrent, etc.
                                                                        (Any two)         2
 5.9         •       Previously accessed web pages stored on local
                     machine/hard drive 
             •       Provides quicker access to web page in the future/Less
                     bandwidth/data/'cap' is used                                          2
                                                                                           [15]

Copyright reserved                                                              Please-turn-over

### Page 9

Downloaded from hlayiso.com
Computer Applications Technology/P2           9                           DBE/November 2015
                                      NSC – Memorandum

 QUESTION 6: INFORMATION MANAGEMENT
 6.1    •     For collecting individual perspectives/experiences/opinions
        •     Easy/Quick way to gather information from
              individuals/groups
        •     For targeting specific respondents, etc.
                                                                (Any one)
             (Note to marker: Accept any reference to getting information not
             available from other sources. Accept a specific example.)                    1
 6.2         •   Limits range of possible responses
             •   Limits data capturing mistakes/Fewer issues with
                 handwriting
             •   Data validation
             •   Easier to summarise/analyse responses
             •   Faster to capture responses
             •   Increased likelihood of respondents answering/Quicker to fill
                 out survey/questionnaire
                                                                  (Any two)             2
 6.3         •   Charts/Graphs/'Sparklines'
             •   Wide range of functions/formulas e.g. logical and statistical
                 functions
             •   Sorting
             •   Filters
             •   Pivot tables
             •   Validation facilities
             •   Conditional formatting
             •   Results of functions/formulae update automatically, etc.
                                                                  (Any two)             2
 6.4         Sources  via the source manager
             (Note to marker: Accept Citations. Do not accept referencing.)               1
 6.5         Track changes 
             (Note to marker: 'Manual' methods such as shading are not
             accepted.)                                                                   1
 6.6         •    The information cannot be confirmed/corroborated by other
                  sources/no bibliography
             •    The author is not an authority in the field/The author is
                  unknown
             •    The information is not current/Publishing date cannot be
                  established
             •    Bias/Prejudice is evident in the information
             •    Poor language use/Spelling and grammar errors, etc.
                                                                    (Any two)           2
 6.7         Indicates that the content of the website could have changed
             since the date it was used/Indicates what the information was on
             that date                                                                   1
                                                                                         [10]

Copyright reserved                                                            Please-turn-over

### Page 10

Downloaded from hlayiso.com
Computer Applications Technology/P2          10                                DBE/November 2015
                                      NSC – Memorandum

 QUESTION 7: SOCIAL IMPLICATIONS
 7.1         •       Turn off display/hard disk automatically after a period of time
             •       Put the computer to sleep automatically after a period of time
             •       Turn on Wireless Adapter Maximum Power Saving
             •       Turn down the brightness of the screen
             •       Battery/Power schemes/settings
             •       Switch off any unused communication mediums/features
                     such as Bluetooth, GPS or Wi-Fi
             •       Disable any start-up programs
                                                                        (Any two)

             (Note to marker: Do not accept a power-saving technique that
             does not involve modifying operating system settings, e.g.
             switching off the laptop when not in use, etc.)                                 2
 7.2         •       Using unlicensed software/Performing illegal downloads of
                     copyrighted material
             •       Violating licensing agreement of software/Installing software
                     on more machines than you have licences for
             •       Bandwidth piracy
             •       Not paying when using services that require an online
                     subscription
             •       Copying and selling media such as movies on DVD/
                     software, etc.
                                                                      (Any two)

             (Note to marker: Do not accept answers related to the theft of
             intellectual property and plagiarism, etc.)                                     2
 7.3         •       Use/Install Linux/FOSS/Free Open source operating system
             •       Find out about academic/student/workplace discount or
                     version
             •       Get a less expensive version of Windows
             •       Inquire about a downgraded license/option, etc.
                                                                     (Any two)

             (Note to marker: Do not accept responses outside of the ICT
             context, e.g. get a decent job. Do not accept any illegal options
             such as pirating, etc. Accept trial version.)                                   2

Copyright reserved                                                               Please-turn-over

### Page 11

Downloaded from hlayiso.com
Computer Applications Technology/P2          11                              DBE/November 2015
                                      NSC – Memorandum

 7.4         •       Make use of the 'alt' HTML tag for images (or any other
                     features that make the website more easily interpreted by
                     text-to-speech software)
             •       Text-to-speech software/'Narrator'
             •       Make use of sound files, e.g. for navigation/feedback
             •       Enlarge fonts/Use of theme fonts/magnifier
             •       Use suitable colour contrasts/schemes, etc.
                                                                       (Any two)

             (Note to marker: Do not accept Braille keyboard.)                             2
 7.5         •       There is too much data/information to process sensibly/make
                     sense of
             •       The user does not know how to respond to the large volume
                     of information/data
             •       The user cannot cope with the amount of information/data
                                                                      (Any one)

             AND

             •       Time is wasted trying to make sense of the data
             •       The user is less productive
             •       Easily distracted
                                                                        (Any one)

             (Note to marker: Accept any specific example of information
             overload reducing productivity.)                                              2
                                                                                          [10]

Copyright reserved                                                             Please-turn-over

### Page 12

Downloaded from hlayiso.com
Computer Applications Technology/P2          12                             DBE/November 2015
                                      NSC – Memorandum

 QUESTION 8: SOLUTION DEVELOPMENT
 8.1.1     •     Table/Query in a database                                                    2
           •     Spreadsheet/CSV (comma delimited) file
           •     Contacts file e.g. in Microsoft Outlook
           •     Table in a word processing document
           •     Text file, etc.
                                                                           (Any two)

           (Note to marker: Do not accept reference to a word processing document
           without table.)
 8.1.2     To act as a placeholder for the merged data/To indicate where each                 1
           data/field from the source should go/must be added during the merge
           process                                                                                  3
 8.2.1     Must be 60 or older                                                               2
           Must not be working
           (Note to marker: Do not accept 'older than 60' for the first mark.)
 8.2.2     Blank cell                                                                        1
           (Note to marker: Accept 'nothing' as an answer. Do not accept if the
           answer is left blank, i.e. unanswered.)                                                  3
 8.3       •     Paste only characters with no formatting
           •     Paste as a hyperlink
           •     Paste as a link
           •     To choose whether to use the source or destination formatting or not
           •     To leave out or 'skip' blanks
           •     To transpose rows/columns
           •     Paste values and not functions/formulae, etc.
                                                                         (Any one)                 1
 8.4.1     To comment/document 

           (Note to marker: Accept as an indication of where to put the data.)                1
 8.4.2     None of the content within the HTML comment tag is displayed
           (Note to marker: Accept 'nothing' as an answer. Do not accept if the
           answer is left blank, i.e. unanswered.)                                            1     2
 8.5       The text that is displayed if for any reason the image cannot be
           displayed                                                                               1

Copyright reserved                                                               Please-turn-over

### Page 13

Downloaded from hlayiso.com
Computer Applications Technology/P2          13                           DBE/November 2015
                                      NSC – Memorandum

 8.6.1     The Stock ID field has already been set as the primary key                     1
 8.6.2     Validation rule/Combo/List box/Lookup table
           (Note to marker: Do not accept Input mask as an answer.)                        1      2
 8.7.1     The criteria in each line is treated separately/as an OR option
           Place both the criteria in the same 'line'
           (Note to marker: Accept if the candidate draws a diagram correctly
           reflecting the solution.)                                                       2
 8.7.2     Description                                                                    1      3
                                                                                                 [15]
                                                                      TOTAL SECTION B:           [75]

Copyright reserved                                                            Please-turn-over

### Page 14

Downloaded from hlayiso.com
Computer Applications Technology/P2          14                            DBE/November 2015
                                      NSC – Memorandum

 SECTION C

 QUESTION 9: INTEGRATED SCENARIO
 9.1       •     Adjustable height/set to correct height/arms at right angles
           •     Ability to swivel
           •     Wheels for easy movement
           •     Lumbar/Back support, etc.
                                                                             (Any one)

           (Note to marker: Do not accept a general answer such as 'comfortable'.)              1
 9.2.1     The lowest/minimum possible specifications  (hardware/software)
           needed for the program to load/run                                            2
 9.2.2     •     While programs will run with the minimum specifications they will
                 perform optimally with higher specifications
           •     Hardware would be relevant/usable for a longer period of time/Will
                 be able to run newer/later versions of software
           •     More resources to enable multi-tasking
           •     Computer would be compatible with a wider range of
                 software/hardware, etc.
                                                                      (Any two)         2
 9.2.3     Monitor/Screen/Display                                                        1
 9.2.4     •     More expensive to buy/Not free
           •     Cannot copy or distribute
           •     Do not have access to/Cannot alter or add to source code
           •     Newer versions often need higher hardware specifications
           •     Proprietary software sometimes needs higher hardware
                 specifications to run than OSS, etc.
                                                                        (Any two)       2
 9.2.5     •     Remove unwanted programs/files
           •     Perform housekeeping to remove duplicate files
           •     Move/Archive unused/large files to a different storage device/the
                 cloud
           •     Remove temporary/cached files
           •     Uninstall operating system features/components not required
           •     Compress files/folders
           •     Disable hibernation
           •     Reduce virtual memory files
           •     Empty recycle bin, etc.
                                                                          (Any two)

           (Note to marker: Accept references to using utilities such as Disk Cleanup
           but do not accept a reference to installing a new hard drive or replacing
           the current one.)                                                              2

Copyright reserved                                                           Please-turn-over

### Page 15

Downloaded from hlayiso.com
Computer Applications Technology/P2          15                            DBE/November 2015
                                      NSC – Memorandum

 9.2.6     •     Limited functions available/Less functionality
           •     Uses data/cap/data bundle
           •     Must have Internet connectivity
           •     Can drastically slow down the Internet connection speed when many
                 people are using the programs
           •     Increased data costs, etc.
                                                                        (Any two)       2     11
 9.3       •     Service packs contain all patches/updates released to date/Patches
                 and updates do not have to be done individually/fixes bugs
           •     Improved security options/New features included
           •     Ensures that all available patches/updates (to that point) have been
                 installed
           •     Service packs can be obtained on media that does not require
                 Internet access/use of cap, etc.
                                                                           (Any two)          2
 9.4.1     •     Print directly from memory cards
           •     Allows a variety of media types to be used
           •     Saves time by not having to log on and send to the printer
           •     Can use printer without logging on.
           •     Do not even need to have printer connected to a
                 network/computer/device, etc.
                                                                         (Any two)

           (Note to marker: Do not accept answers relating to connecting the printer
           to a USB port.)                                                                2
 9.4.2     Filter/Pivot Table 

           (Note to marker: Do not accept sorting.)                                       1
 9.4.3     •     Use print preview before printing/Proofread electronically
           •     Print multiple pages on a single piece of paper
           •     Print on both sides of a page
           •     E-mail documents/Use cloud storage
           •     Reduce font sizes
           •     Only print sections needed and not full documents, etc.
                                                                          (Any two)     2
 9.4.4     •     Refill the cartridge
           •     Return to manufacturer/seller/dispose of it in an eco-friendly way
           •     Take to a recycling facility/Take to a refurbishing/
                 re-manufacturing company, etc.
                                                                            (Any two)   2     7

Copyright reserved                                                           Please-turn-over

### Page 16

Downloaded from hlayiso.com
Computer Applications Technology/P2          16                              DBE/November 2015
                                      NSC – Memorandum

 9.5.1     •     On a manufacturer/third party website/On the Internet
           •     Already part of/supported by the operating system/On the computer
                 already
                                                                          (Any one)

           (Note to marker: Do not accept 'from a shop'. Accept a specific
           explanation of getting the driver.)                                              1
 9.5.2     (a) Colour depth refers to the number of colours that can be
               recognised by the scanner.

           (b) The dpi indicates the resolution/amount of pixels the scanner uses
               to compose a scanned image.                                                  2     3
 9.6.1     •     More up-to-date information
           •     Potentially wider range of information
           •     Easier to narrow down search/results
           •     Already in electronic format/ quicker to manipulate
           •     Easier to share/distribute information
           •     Many learners can access the same resources at the same time
           •     Faster/Easier to compare/access information from different sources
           •     Access to multimedia materials, etc.
                                                                         (Any two)

           (Note to marker: Do not accept faster without qualification.)                    2
 9.6.2     Firewall                                                                        1
 9.6.3     A website (web page) that allows multiple users to add/edit content
           directly on the website.                                                         2     5
 9.7.1     •     Can easily lose/damage a flash drive
           •     Flash drives have a limited life-span
           •     Basic versions of cloud storage are free
           •     Can access the information from any computer connected to the
                 Internet/No need to carry around a flash drive
           •     Allows for easy sharing of files
           •     Potentially larger storage capacity of cloud storage
           •     Automatic synchronisation of files/folders
           •     Copies of files are available in a secure location
           •     Automatic services such as security and backup handled by the
                 storage provider, etc.
                                                                       (Any two)

           (Note to marker: Accept any specific example.)                                   2

Copyright reserved                                                             Please-turn-over

### Page 17

Downloaded from hlayiso.com
Computer Applications Technology/P2          17                             DBE/November 2015
                                      NSC – Memorandum

 9.7.2     •     Synchronisation/Synching functionality
           •     Set reminders
           •     Use scheduling utility/scheduling option on backup software, etc.
                                                                          (Any one)       1     3
 9.8.1     •     Webcam
           •     Microphone
                                                                            (Any one)     1
 9.8.2     •     Access to/Interact with expert teachers (without having to travel)
           •     Saves travel costs/time
           •     Teacher can teach to a wider audience
           •     Lesson can be recorded/Re-used, etc.
                                                                          (Any two)

           (Note to marker: Do not accept answers that are common to
           'conventional' teaching such as 'set a test', etc.)                             2
 9.8.3     •     Need not wait for entire download to finish before watching it
           •     Live feeds can be streamed
           •     Do not need to have the storage required to save large videos before
                 watching
                                                                            (Any one)     1
 9.8.4     •     Potentially better quality images/video
           •     No/Less need for darkened conditions
           •     Can use video conferencing features provided with some of these
                 devices
           •     Limited lamp life
           •     No need for a separate projection screen/flat surface to project onto,
                 etc.
                                                                          (Any two)      2     6
 9.9.1     •     Prevent theft/Expensive asset/Potential loss of data if stolen
           •     Only staff with correct credentials will have access to the
                 room/machine
           •     Security reasons/Easier to control access to a separate room, etc.
                                                                              (Any one)   1

Copyright reserved                                                            Please-turn-over

### Page 18

Downloaded from hlayiso.com
Computer Applications Technology/P2          18                             DBE/November 2015
                                      NSC – Memorandum

 9.9.2     •     Injury to your finger will reduce the effectiveness of the biometric
                 sensor
           •     Some users have fingerprints which are not recognised/no
                 fingerprints
           •     Person has to be physically present to be added to the system
           •     Faulty sensors/Power failure can cause authorised users to be
                 locked out
                                                                             (Any two)

           (Note to marker: Do not accept cost issues or answers such as
           'no one else can access the system'.)                                           2     3
 9.10      •     Relevant data can be more easily extracted using queries/ Easier to
                 perform queries/more facilities for querying
           •     Professional reports can easily be created/Better reporting facilities
           •     Ease of capturing data using forms
           •     More validation tools/validation techniques
           •     Designed to work with larger volumes of information
           •     Designed specifically to work with records/Spreadsheet more suited
                 to numerical calculations
           •     Relational tables are possible
           •     Automatic saving and updating after adding records, etc.
                                                                          (Any two)

           (Note to marker: Accept any example of data validation tools or
           techniques not present in a spreadsheet.)                                             2
 9.11.1    Currency

           (Note to marker: Do not accept Number only. Accept number formatted to
           currency.)                                                                      1
 9.11.2    Short Text/Text

           (Note to marker: Do not accept Number/Memo/Long text.)                          1
 9.11.3    Memo/Long Text                                                                 1
 9.11.4    OLE object/attachment

           (Note to marker: Do not accept 'hyperlink' or 'attachment' as the picture
           must be stored in the field itself.)                                            1     4

Copyright reserved                                                            Please-turn-over

### Page 19

Downloaded from hlayiso.com
Computer Applications Technology/P2          19                          DBE/November 2015
                                      NSC – Memorandum

 9.12      •     Create a query that sorts the amounts/select the option to choose
                 the top 10 highest amounts 

                 OR

                 Sort the table according to the total and select the top 10 and copy
                 the top 10 records to a new table

           •     Create a report based on the query/table produced with top 10
                 donors

           (Note to marker: Do not accept a rewording of the question such as
           'create a report'.)                                                                 3
                                                                    TOTAL SECTION C:         [50]
                                                                        GRAND TOTAL:         [150]

Copyright reserved                                                                      *

## Related documents

- [CAT P2 Nov 2015 Memo Afr](https://www.hlayiso.com/library/cat-p2-nov-2015-memo-afr/115caf00-247d-4a39-8840-ffe617d18f14) — Computer Applications Technology · Memo · 2015 · Afr
- [Computer Applications Technology P2 Nov 2015 Eng](https://www.hlayiso.com/library/computer-applications-technology-p2-nov-2015-eng/c078f157-bdd6-48fb-9bbf-af58939034e2) — Computer Applications Technology · QP · 2015 · Eng
- [CAT P1 Nov 2015 Memo Afr](https://www.hlayiso.com/library/cat-p1-nov-2015-memo-afr/ec56d95b-8740-4d2e-970a-bdbe22ca475f) — Computer Applications Technology · Memo · 2015 · Afr
- [CAT P1 Nov 2015 Memo Eng](https://www.hlayiso.com/library/cat-p1-nov-2015-memo-eng/665607d0-ebce-4a13-8397-d47212e70694) — Computer Applications Technology · Memo · 2015 · Eng
- [CATN P2 MEMO GR12 AFR SEP 2015](https://www.hlayiso.com/library/catn-p2-memo-gr12-afr-sep-2015/e93173b1-3656-4239-af0b-822a4acf42d0) — Computer Applications Technology · Memo · 2015 · Afr
- [CAT P2 June July 2015 Memo Eng](https://www.hlayiso.com/library/cat-p2-june-july-2015-memo-eng/47884231-c123-4a6a-b162-51e0310d342c) — Computer Applications Technology · Memo · 2015 · Eng

## More from Grade 12 Computer Applications Technology

- [CAT P1 QP GR12 SEPT 2025 AFRIK watermark](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2025-afrik-watermark/1b848d13-4e0f-4b33-91ef-2fcd3dc2e6b9) — QP · 2025 · Afr
- [CAT P2 GR12 QP September 2025 ENG watermark](https://www.hlayiso.com/library/cat-p2-gr12-qp-september-2025-eng-watermark/fd63d968-a454-409d-9293-0862b56232b1) — QP · 2025 · Eng
- [CAT P1 QP GR12 SEPT 2024 Afrikaans](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-afrikaans/82b87849-4ee6-4b20-8b30-633307bd7329) — QP · 2024 · Afr
- [CAT P1 QP GR12 SEPT 2024 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-english/bf2518c3-ae79-4251-8145-1b062895b12f) — QP · 2024 · Eng
- [CAT P2 GR12 QP SEPT 2024 English](https://www.hlayiso.com/library/cat-p2-gr12-qp-sept-2024-english/b8b0a9f3-f8c6-4f0a-8ddf-30b58008b603) — QP · 2024 · Eng
- [Computer Applications Technology P1 Nov 2024 Afr](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2024-afr/502fe6df-4d11-41d1-8e23-b219565e715b) — QP · 2024 · Afr

## Collection

- [Grade 12 past papers](https://www.hlayiso.com/grade-12/past-papers)

---

Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.
