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

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

- Page: https://www.hlayiso.com/library/computer-application-technology-p2-nov-2019-memo-eng/3598810e-eceb-4ace-bdf0-fd7c3d4f042b
- Updated: 2026-09-27
- Subject: Computer Applications Technology
- Grade: Grade 12
- Document type: Memorandum
- Year: 2019
- Exam period: NSC November Exam
- Paper: 2
- Curriculum: CAPS
- Pages: 20

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 2019 Memo (Eng)](https://www.hlayiso.com/library/computer-application-technology-p2-nov-2019-memo-eng/3598810e-eceb-4ace-bdf0-fd7c3d4f042b)

## About this document

Computer Applications Technology · Grade 12 · NSC November Exam · 2019. Memorandum, 20 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 2019

                                MARKING GUIDELINES

MARKS: 150

                      These marking guidelines consist of 20 pages.

Copyright reserved                                                    Please turn over

### Page 2

Downloaded from hlayiso.com
Computer Applications Technology/P2              2                         DBE/November 2019
                                      NSC – Marking Guidelines

SUGGESTIONS AND RECOMMENDATIONS TO MARKERS

•     Revisit the questions and the 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 the
      marking guideline.
      o Ask yourself or your senior marker if the response could 'fit' into the marking
        guideline before allocating the correct marks to the candidate.
      o Accept correct answers that are expressed differently, e.g. the marking guideline
        states 'slow' and the candidate responds with 'not fast'.
•     Beware of overlapping answers to a specific question. In general, ONE mark is
      awarded per fact.
•     Do not choose answers on the candidate's behalf. Where a question requires a
      candidate to LIST or NAME/STATE: mark the first number of instances required, e.g.
      the first TWO facts if the candidate presents a list of FIVE facts and only TWO facts
      were required, even if presented in paragraph format.
•     Questions requiring longer answers must be regarded as a single unit. Marks can be
      awarded if correct statements are found anywhere in the paragraph.

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

1.1           D                        1            2.1         E                       1

1.2           C                        1            2.2         O                       1

1.3           B                        1            2.3         L                       1

1.4           B                        1            2.4         S                       1

1.5           A                        1            2.5         K                       1

1.6           D                        1            2.6         P                       1

1.7           C                        1            2.7         T                       1

1.8           D                        1            2.8         F                       1

1.9           D                        1            2.9         C                       1

1.10          A                        1            2.10        R                       1

                                Total: [10]                                       Total: [10]

Copyright reserved                                                             Please-turn-over

### Page 3

Downloaded from hlayiso.com
Computer Applications Technology/P2              3                             DBE/November 2019
                                      NSC – Marking Guidelines

QUESTION 3: TRUE/FALSE ITEMS
(Note to marker: In Question 3.1, 3.3, and 3.4 candidates need to provide both the word 'False'
and the correct term, e.g. motherboard, in order to get the mark.)
3.1         False, WAN  /MAN                                                                 1
3.2         True                                                                             1
3.3         False, driver                                                                    1
3.4         False, (Disk) Cleanup                                                            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 2019
                                          NSC – Marking Guidelines

SECTION B

QUESTION 4: SYSTEMS TECHNOLOGIES
4.1         TWO input devices found on a laptop computer

            (1)      Keyboard/Keypad
            (2)      Touch pad/Track pad
            (3)      Microphone
            (4)      Camera/Webcam
            (5)      Fingerprint scanner
            (6)      Track point/Pointing stick

                                                                               (Any two)          2
4.2         TWO reasons why all text on a touch screen device does not
            display

            (1)      On-screen keyboard is blocking the text
            (2)      Font size is too large (zoomed)/Screen size is too small
            (3)      More than one app is opened which takes up screen space
            (4)      Text is scrolled out of view/Auto-rotation is not turned on

                                                                               (Any two)          2
4.3         TWO functions of a UPS

            (1)      Provides temporary backup power during power failures/dips to
                     save work
            (2)      Protects the computer from power surges/fluctuations/dips                     2
4.4         TWO reasons for using a data projector instead of a monitor

            (1)      The display can be used for large groups of people
            (2)      Image size can be varied
            (3)      Can display on a variety of surfaces
            (4)      Data projector is easier to move/carry around (Comparable sizes)

                                                                               (Any two)          2
4.5         TWO advantages of HDMI cables over VGA cables

            (1)      Digital signal results in better audio/video quality (higher
                     resolution)/HDMI enables better quality images/display
            (2)      Transmits both audio and video data
            (3)      Faster data transfer

                                                                               (Any two)          2
4.6         TWO reasons why 3D-printers are not commonly used in home
            offices

            (1)      Not multifunction: cannot scan/copy/cannot print on paper
            (2)      Home office users generally do not need to print 3D models
            (3)      Emissions may possibly be toxic (smelly/odour)
                                                                           (Any two)              2

Copyright reserved                                                                       Please-turn-over

### Page 5

Downloaded from hlayiso.com
Computer Applications Technology/P2                 5                                DBE/November 2019
                                         NSC – Marking Guidelines

4.7.1       ONE reason why 1024x768 does not refer to size of the monitor

            1024x768 refers to the resolution and NOT the physical screen
            size/display ratio/Screen size is given in inches                                1
4.7.2       Term used to describe why software will not work on an earlier
            version of the OS

            Compatibility                                                                    1      2
4.8         TWO reasons for purchasing an office suite rather than
            applications by various software developers

            (1)      Office suite/Applications will have a similar GUI/environment
            (2)      Easy to share data between applications/Integration of data
            (3)      All applications are available from a single installation
            (4)      Only single update required for all applications
                                                                                (Any two)          2
4.9         TWO causes for an application to stop responding

            (1)      Lack of system resources, e.g. Not enough RAM to run
                     application/Lack of disk access/Too many applications running in
                     the background/Application is in the process of updating
            (2)      Lack of network access/connectivity
            (3)      Hardware malfunction, e.g. faulty RAM, CPU overheating, etc.
            (4)      Corruption of the software/Faulty software/Software bug
            (5)      Malware, e.g. Virus infection, Hacking software
                                                                            (Any two)

            (Note to marker: Allocate two marks if the candidate gives two valid
            points in the same bullet, e.g. Faulty RAM and faulty CPU.)                              2
4.10        TWO reasons why a picture becomes blurred or is unclear

            (1)      The picture size was increased/Pixilation
            (2)      It was saved at a lower resolution
            (3)      It was saved in a different file format
            (4)      Aspect ratio was changed
            (5)      Sharpness/Softness/Contrast of the picture was adjusted
            (6)      Graphic effects were applied
                                                                          (Any two)                2
4.11        How convergence contributes to green computing
            Fewer devices means:
            (1) fewer resources/materials being used (in the manufacturing
                process)
            (2) less going to landfills/less e-waste
            (3) fewer emissions (e.g. in manufacturing/transport)
            (4) less power/electricity being consumed
                                                                     (Any two)                     2

Copyright reserved                                                                        Please-turn-over

### Page 6

Downloaded from hlayiso.com
Computer Applications Technology/P2               6                             DBE/November 2019
                                       NSC – Marking Guidelines

4.12.1      Term for analogue broadcast changed to digital broadcast

            (Digital) migration                                                        1
4.12.2      TWO advantages of digital broadcasting technology for the viewer

            (1)      Sharper picture/video/higher resolution/Support HD devices
            (2)      Streaming/video on demand
            (3)      Better quality sound
            (4)      More television channels available
            (5)      Music/Radio channels also available
            (6)      The availability of other services, e.g. optional
                     languages/subtitles/parental lock, etc.
            (7)      Electronic programming guide
                                                                          (Any two)   2      3
                                                                                             [25]

Copyright reserved                                                                  Please-turn-over

### Page 7

Downloaded from hlayiso.com
Computer Applications Technology/P2                 7                             DBE/November 2019
                                         NSC – Marking Guidelines

QUESTION 5: INTERNET AND NETWORK TECHNOLOGIES
5.1         TWO advantages of networked computers over stand-alone
            computers

            (1) Sharing of hardware
            (2) Installing/Sharing of applications
            (3) Sharing of documents/files
            (4) Enables communication between computers
            (5) Centralised/Improved security is possible
            (6) Updates can be shared/centralised
            (7) Device management
            (8) Sharing of internet connectivity
            (9) Backups can be centralised
            (10) Centralised data

                                                                            (Any two)          2
5.2.1       Port to connect computer to a wired network

            Port A/Ethernet port

            (Note to marker: Accept Port B together with a motivation, e.g. adaptor.)     1
5.2.2       Way to connect to a wireless network

            (Wireless) dongle in Port B

            OR

            Router/modem in Port A/B

            (Note to marker: Do not accept Port A or B only.)                             1      2
5.3         Type of connection that uses light for data transmission

            Fibre /Li-Fi                                                                        1
5.4         ONE solution for users to log on to a LAN

            (1) Switch the server/switch on
            (2) Refresh the user accounts/Restart the server/computer/
                switch/Create new user accounts/Roll back the server to previous
                settings
            (3) Plug the network cable in
            (4) Faulty hardware: Replace the damaged network cable/Switch/Port
            (5) Review user permissions (NOT passwords)/firewall/timed access
            (6) Clean virus infection on the server
                                                                        (Any one)               1
5.5         ONE reason why buffering occurs while streaming a video
            (1)      There is not enough bandwidth/High internet traffic
            (2)      ISP throttled your connection
            (3)      Problems with the streaming server
            (4)      Poor signal strength/Connection was interrupted

                                                                             (Any one)          1

Copyright reserved                                                                    Please-turn-over

### Page 8

Downloaded from hlayiso.com
Computer Applications Technology/P2                 8                                DBE/November 2019
                                         NSC – Marking Guidelines

5.6         Purpose of a home page setting in a browser
            Automatically loads a (favourite) web page every time the browser is
            started/Acts as an indirect bookmark                                                   1
5.7         TWO outcomes from clicking on a website hyperlink

            (1)      (Automatically) directs a user to other pages/sections of the
                     website/other websites
            (2)      Opens the e-mail interface
            (3)      Can initiate/trigger file downloads/link to multimedia files
            (4)      Could result in a dialog box, e.g. Error message

                                                                            (Any two)             2
5.8         TWO ways to ensure privacy on social media: Facebook/
            WhatsApp
            (1)      Ensure that only authorised people can see the posts/
                     content/Use privacy settings
            (2)      Disable cookies
            (3)      Disable/Restrict access to 3rd party apps/Disable sharing of data
                     with social network service provider, if possible
            (4)      Block users that you do not want to communicate with
            (5)      Hide/Do not share personal details
            (6)      Disable the 'share location' feature
                                                                            (Any two)
                                                                                                    2
5.9         TWO limitations of e-commerce
            (1)      Items cannot be tried out before purchase
            (2)      Requires some form of banking account/Usually cannot transact in
                     cash
            (3)      Not all services can be purchased through online stores, e.g.
                     haircut, medical visits, etc.
            (4)      Relies on internet connectivity
            (5)      Digital skills
            (6)      Warranty claims can be difficult
            (7)      Can be impersonal
            (8)      May be exposed to fraud/scams
            (9)      Possible delay in delivery
                                                                            (Any two)
                                                                                                    2
5.10        Technology used to secure data
            Encryption /SSL/TLS
                                                                                                    1
                                                                                                  [15]

Copyright reserved                                                                       Please-turn-over

### Page 9

Downloaded from hlayiso.com
Computer Applications Technology/P2                9                               DBE/November 2019
                                        NSC – Marking Guidelines

QUESTION 6: INFORMATION MANAGEMENT
6.1.1       Purpose of an abstract
            A brief summary/overview/outline of the report                                  1
6.1.2       Purpose of an introduction
            (1)      To give a (description of the) purpose of the report
            (2)      To give background information about the topic
            (3)      To give a brief idea of what the researcher did/research process
                     was to solve the problem

                                                                             (Any one)
            (Note to marker: Do not accept 'target audience'.)                               1      2
6.2         TWO reasons for information not being suitable
            (1)      The author is not an authority on the topic/Cannot obtain
                     bibliographical information
            (2)      The information is too old
            (3)      Information in the document was found to be plagiarised
            (4)      The information is biased
            (5)      The information is contradictory
            (6)      Information cannot be cross-referenced
            (7)      The information is very limited and does not adequately cover the
                     topic

                                                                           (Any two)              2
6.3.1       ONE limitation of closed questions in a questionnaire

            (1)      Limited options may lead to skewed data
            (2)      Options may be biased towards a point of view
            (3)      Respondent may want to give an answer not in the list/Limits
                     possible responses that could be given by the respondent
            (4)      No indications of whether the respondent understood the questions

                                                                             (Any one)      1
6.3.2       TWO benefits for a researcher when closed questions are
            answered electronically
            (1)      Easier to process/analyse responses in a graph/spreadsheet/
                     database
            (2)      The creation of graphs can be automated
            (3)      Can read all responses/Bad handwriting is not an issue/Do not
                     have to retype the responses/Fewer errors in data
            (4)      Data capturing can be automated
            (5)      Easy to share data with others/publish dataset
            (6)      Data validation of responses can be done
            (7)      Possible response times are quicker
            (8)      Higher return rate is possible

                                                                          (Any two)        2      3

Copyright reserved                                                                       Please-turn-over

### Page 10

Downloaded from hlayiso.com
Computer Applications Technology/P2               10                              DBE/November 2019
                                        NSC – Marking Guidelines

0
6.4         THREE reasons why the graph is difficult to interpret

            (1)      The title obscures the content of the graph/The title may make it
                     difficult to see detail/interpret the graph
            (2)      The graph shows a big difference in the bars but values are very
                     close
            (3)      The combined percentages go well beyond 100%/It is not obvious
                     that the graph displays parts of a whole/A pie chart would be more
                     suitable
            (4)      The Y-axis starts at 80% rather than 0%/Incorrect upper and lower
                     limits of the Y-axis
            (5)      The legend has a meaningless label
            (6)      Axes are not labelled

                                                                       (Any three)                3
                                                                                                   [10]

Copyright reserved                                                                        Please-turn-over

### Page 11

Downloaded from hlayiso.com
Computer Applications Technology/P2                11                               DBE/November 2019
                                         NSC – Marking Guidelines

QUESTION 7: SOCIAL IMPLICATIONS
7.1.1       TWO activities on the internet that could lead to addiction
            (1)      Social networking/Constantly checking messages
            (2)      Checking profiles of others
            (3)      (Online) gaming
            (4)      Watching inappropriate content/pornography
            (5)      (Online) shopping/(online) auctions
            (6)      Watching (online) videos
            (7)      (Online) dating
            (8)      (Online) gambling

                                                                            (Any two)         2
7.1.2       TWO warning signs of internet addiction

            (1)      Withdrawal from/Dislike of social activities/Isolation
            (2)      Obsessed with their internet activities/Spend all their time at the
                     computer/Constant need for data
            (3)      Mental health issues/Depression/Anxiety/Aggression/Withdrawal
            (4)      Physical symptoms: Repetitive stress injuries/Carpal Tunnel
                     Syndrome/Headaches/Fatigue
            (5)      Secretive behaviour with computing devices
            (6)      Truancy/Absence from school/work

                                                                            (Any two)

            (Note to marker: Allocate two marks even if candidate lists two points
            from the same bullet.)                                                              2      4
7.2         TWO potential ethical problems of companies accessing big data

            (1)      Breach of privacy: Use of data for certain purposes/tasks without
                     permission, e.g. selling people's data profiles to third parties for
                     marketing
            (2)      Use of personal data to target/tempt specific people into making
                     unnecessary purchases
            (3)      Companies may exploit data/Unfair bias becomes the accepted
                     norm
            (4)      Lack of security controls/Open to cyber-attacks

                                                                            (Any two)                2
7.3         ONE way law enforcement authorities could trace cyber criminals

            (1)      Track/Trace/Check on the internet activities of users, e.g. visiting
                     questionable sites, posting offensive comments, etc.
            (2)      Internet activities leave behind data (breadcrumbs/History/cookies)
                     that can be traced
            (3)      Profile users based on their internet activities
            (4)      Information provided by victims

                                                                              (Any one)               1

Copyright reserved                                                                          Please-turn-over

### Page 12

Downloaded from hlayiso.com
Computer Applications Technology/P2             12                             DBE/November 2019
                                      NSC – Marking Guidelines

7.4         ONE way in which social media is able to influence public opinion

            Posts (opinions) made by influencers/celebrities/authorities/companies
            on social media manipulate/could influence public opinion/behaviour
            both positively or negatively 

            (Note to marker: Accept any realistic response related to the influence
            of social media, e.g. Fake news, trending posts/comments, etc.)                      1
7.5         TWO negative effects of software piracy for creators

            (1) Software manufacturers lose revenue/Loss of sales
            (2) Discourages the creation of new software/Can affect the quality of
                new software developed
            (3) Possible job losses
            (4) Reputational damage because users are unaware of malware in the
                pirated software

                                                                       (Any two)               2
                                                                                                [10]

Copyright reserved                                                                    Please-turn-over

### Page 13

Downloaded from hlayiso.com
Computer Applications Technology/P2                13                                DBE/November 2019
                                         NSC – Marking Guidelines

QUESTION 8: SOLUTION DEVELOPMENT
8.1         ONE benefit of using styles for headings in a long WP document

            (1)      Easy to create a table of contents/Enables the use of automatic
                     table of contents
            (2)      Consistent format of headings/Professional layout of document
            (3)      Easy to modify/update multiple headings at the same time

                                                                               (Any one)

            (Note to marker: Only accept time saving when motivated.)                                   1
8.2         TWO reasons for using sections breaks

            (1)      Different headers and footers can be applied to a document
            (2)      Different page numbering can be applied in one document
            (3)      Watermarks can be inserted on only some pages in one document
            (4)      Various page settings, e.g. page orientations/paper
                     sizes/margins/borders can be applied to one document
            (5)      Various column layouts can be applied to one document
            (6)      Different vertical alignment options can be applied in one
                     document

                                                                             (Any two)                2
8.3         TWO word processing features used by a reviewer

            (1)      Tracking/Track changes/Markup
            (2)      Comments
            (3)      Use highlighting/use different colour fonts/strikethrough to indicate
                     suggested changes                                                                  2
8.4.1       ONE reason for the display of non-printing symbols

            Show/Hide feature is activated/Show formatting, e.g. spaces, tabs,
            etc.                                                                                1
8.4.2       Reason why there is no bullet next to 'Shelter'

            Soft return/enter was used/Pressed Shift+Enter/Did not press the Enter
            key on its own/It is part of the bulleted text                                      1      2
8.5         How to use Page Break Preview in a spreadsheet

            Drag the (blue) page break  with the mouse to customise the printable
            area                                                                                        1

Copyright reserved                                                                           Please-turn-over

### Page 14

Downloaded from hlayiso.com
Computer Applications Technology/P2               14                               DBE/November 2019
                                        NSC – Marking Guidelines

8.6         Purpose of the exclamation mark in a spreadsheet

            Exclamation mark indicates a reference to another sheet/workbook/The
            cell A1 is in the 'data' worksheet                                                     1
8.7         Cell format of a time answer in a spreadsheet

            General/Number                                                                         1
8.8         TWO mistakes in a formula preventing correct autofill

            (1)      The reference to cell A2 should not be an absolute reference/The
                     row reference cell A2 should not be an absolute cell reference/It
                     should be A2 or $A2
            (2)      There should be absolute cell referencing ($) in cell E1/Cell E1
                     should be a complete absolute cell reference/It should be $E$1

            (Note to marker: Allocate one mark for reference to absolute cell
            referencing without specifying the cells.)                                              2
8.9         Purpose of square brackets in a database calculation

            Square brackets reference a field (name)  or a table

            (Note to marker: Accept reference to extract a value from a column.
            Do not accept 'Column heading' per se.)                                                 1
8.10        Effect of moving =Count(*) from DB group footer to report footer

            The function will count all the values  of all the records in the
            table/report instead of just the values of a group/It results in only one
            answer at the end of the report                                                         1
8.11        Tag for text to appear on the web browser tab

            Move the text 'December Holidays' to between the title tags

            (Note to marker: Accept <title> December holidays </title>.)                            1
                                                                                                   [15]
                                                                         TOTAL SECTION B:           75

Copyright reserved                                                                       Please-turn-over

### Page 15

Downloaded from hlayiso.com
Computer Applications Technology/P2               15                               DBE/November 2019
                                        NSC – Marking Guidelines

SECTION C

QUESTION 9: INTEGRATED SCENARIO
9.1.1       Speed of the faster CPU
            2.4 GHz                                                                        1
9.1.2       ONE reason for the tablet being more suitable for outdoor use

            (1)      A tablet is portable/Not dependent on external power source
            (2)      The tablet is LTE/4G/Wi-Fi enabled
            (3)      Can be easily tilted/moved around to avoid glare

                                                                           (Any one)       1
9.1.3       TWO ways to extend the storage space of the tablet

            (1)      Use an SD Card/memory card
            (2)      Use an (OTG) flash drive/external hard drive
            (3)      Use an online/cloud storage service

                                                                         (Any two)        2
9.1.4       ONE reason for the desktop computer being better for graphics
            processing

            (1)      Has a (dedicated) video/graphics card
            (2)      Has more RAM

                                                                           (Any one)       1
9.1.5       Explanation of an on-site warranty
            The manufacturer will arrange for pickup or repair the device at the
            client's premises
            Reason why tablets do not have on-site warranties
            Tablets are small/portable enough for the owner to easily take it back to
            the store                                                                      2      7

Copyright reserved                                                                      Please-turn-over

### Page 16

Downloaded from hlayiso.com
Computer Applications Technology/P2               16                           DBE/November 2019
                                        NSC – Marking Guidelines

9.2.1       ONE advantage of real-time communication

            Interaction/Help is immediate/No delays in messages                          1
9.2.2       TWO types of internet connection needed during the competition

            (1)      Satellite
            (2)      Cellular (3G, 4G, 5G, LTE)
            (3)      Wi-Fi/Wireless

                                                                       (Any two)        2
9.2.3       TWO hardware devices used for video conferencing

            (1)      Webcam/Camera
            (2)      Speakers/Earphones/Headphones
            (3)      Microphone
            (4)      (Bluetooth) Headset
            (5)      Monitor/Screen/Projector
            (6)      Smartphone/Computer/Tablet

                                                                       (Any two)        2      5
9.3.1       TWO online platforms to publish videos

            (1) YouTube
            (2) School's website/other websites
            (3) Blogs/Vlogs
            (4) WhatsApp/WeChat/Telegram (group)
            (5) Facebook
            (6) Instagram
            (7) Snapchat
            (8) TikTok
            (9) Twitter
            (10) Vimeo, etc.

                                                                       (Any two)        2
9.3.2       How to locate a video on the internet

            (1)      Use the word 'video' in the search string/Set search type to
                     video/video tab (advanced search)
            (2)      Search string must include the school name/cooking competition
                     name/dish name/video name                                           2

Copyright reserved                                                                    Please-turn-over

### Page 17

Downloaded from hlayiso.com
Computer Applications Technology/P2                17                           DBE/November 2019
                                         NSC – Marking Guidelines

9.3.3       TWO specifications of a camera that influence video quality other
            than the sensor

            (1)      Resolution/Megapixels
            (2)      Colour depth
            (3)      (Quality of the) lens
            (4)      Optical (vs digital) zoom
            (5)      Frame rate
            (6)      ISO rating
            (7)      File formats available for saving
            (8)      Video stabilisation/Shudder is reduced
            (9)      Speed of the memory card, etc.
                                                                         (Any two)      2
9.3.4       TWO reasons for compressing video files

            (1)      To decrease the amount of data used when sharing files/Limited
                     bandwidth for sharing files
            (2)      Possible limited storage space on the device/cloud service
            (3)      Faster uploading

                                                                         (Any two)      2      8
9.4.1       TWO spreadsheet features for accurate data capturing

            (1)      Data validation/Drop down list
            (2)      Lock cells/Protect cells
            (3)      Conditional formatting
            (4)      Freeze panes

                                                                         (Any two)      2
9.4.2       An alternative way to add values in a range

            Use the SUM  function                                                        1
9.4.3       Function to lookup data

            VLOOKUP/HLOOKUP/XLOOKUP

            (Note to marker: Accept an answer that uses MATCH and INDEX
            together.)                                                                    1
9.4.4       ONE way to make a spreadsheet document available on any OS

            (1)      Save as PDF
            (2)      Print to PDF
            (3)      Save/Convert a screenshot to any picture format

                                                                          (Any one)      1      5
                                                                                                [25]

Copyright reserved                                                                    Please-turn-over

### Page 18

Downloaded from hlayiso.com
 Computer Applications Technology/P2             18                             DBE/November 2019
                                       NSC – Marking Guidelines

QUESTION 10: INTEGRATED SCENARIO
10.1         TWO specifications to consider when buying a printer

             (1) Resolution/DPI/Quality of the printouts
             (2) Printer speed/PPM
             (3) Connectivity options, e.g. Wireless, USB, etc.
             (4) Printer capacity (industrial level)/Duty cycle
             (5) Multifunction ability, e.g. copying, scanning, etc.
             (6) Paper size/Borderless printing
             (7) User interface options
             (8) Duplex/Two-sided printing option
             (9) Colour/Monochrome printing
             (10) Printing technology, i.e. size and number of ink tanks, toner, etc.
             (11) Paper tray capacity
                                                                         (Any two)    2     2
10.2.1       ONE kind of damage to a computer from a power surge

             (1)   Hardware damage, e.g. to power supply, motherboard, etc.
             (2)   Corruption/Loss of data

                                                                           (Any one)   1
10.2.2       TWO ways to dispose of a computer in an environmentally friendly
             way

             (1)   Recycle the components
             (2)   Use a service provider/retailer that disposes of e-waste
             (3)   Re-use/sell/donate working components

                                                                          (Any two)   2     3
10.3.1       Type of user that uses high-end hardware and software
             Super/Power user                                                          1
10.3.2       TWO reasons to restrict access to the server room

             (1)   Additional layer of access control for employees
             (2)   To prevent burglaries/theft of data/hardware
             (3)   To prevent physical damage/vandalism/tampering with the network

                                                                          (Any two)   2
10.3.3       TWO reasons for blocking USB ports

             (1)   Theft of data/Unauthorised copying of data
             (2)   Flash drives often carry viruses
             (3)   Prevents employees from attaching other devices
             (4)   Prevents employees from bringing in games/personal
                   documents/software, etc.

                                                                          (Any two)   2     5

 Copyright reserved                                                                 Please-turn-over

### Page 19

Downloaded from hlayiso.com
 Computer Applications Technology/P2             19                                  DBE/November 2019
                                       NSC – Marking Guidelines

10.4         TWO benefits of grid computing

             (1)   Large processing tasks are shared over many
                   computers/Enormous processing power
             (2)   Can use existing resources/No need to buy an expensive
                   supercomputer
             (3)   The failure of one computer will not affect processing of tasks
             (4)   Scaling of processing power is easy
             (5)   Uses idle resources

                                                                          (Any two)             2
10.5.1       Cause of the software problem

             Bug 

             Solution

             (1)   System restore/Roll back to previous date/time where the software
                   worked properly
             (2)   Install a patch/service pack (from the vendor website)
             (3)   Re-install the software

                                                                            (Any one)

             (Note to marker: Accept 'Glitch' as the cause with 'Restart' as the
             solution.)                                                                     2
10.5.2       TWO reasons why OS updates should NOT automatically
             download on networked computers

             (1)   Automatic updates may use a lot of bandwidth
             (2)   Automatic updates may use a lot of storage space
             (3)   Updates may slow down the network/Computers may restart
                   automatically to install updates during times when they are in use
             (4)   Updates may cause the computers/network to become
                   unstable/May cause compatibility issues with existing software/
                   Possible introduction of bugs
             (5)   OS updates may not be needed by the users

                                                                          (Any two)

             (Note to marker: Do not accept any answer related to data usage and
             cost.)                                                                         2     4

 Copyright reserved                                                                     Please-turn-over

### Page 20

Downloaded from hlayiso.com
 Computer Applications Technology/P2             20                               DBE/November 2019
                                       NSC – Marking Guidelines

10.6.1       TWO reasons for automatic backups
             (1)   Saves time due to scheduled backups/No user intervention
                   required for backups
             (2)   Ensures backup is always/regularly/timeously done/Employees
                   may forget if done manually
             (3)   Time/schedule backups when computers are not in use
                                                                         (Any two)
             (Note to marker: Do NOT accept reasons for a backup that is NOT
             automatic.)                                                                 2
10.6.2       TWO guidelines in the policy for making backups, other than
             making regular backups or setting automatic backups
             (1)   Only backup when computers are not being used
             (2)   Do not store backups in the same location as the original
                   data/Specify location of backups
             (3)   Specify a storage medium
             (4)   Backup to multiple types of media
             (5)   Do incremental backups to save space/data/Only backup recent
                   data and not everything
             (6)   Do not backup software/programs that can be reinstalled
             (7)   Encrypt sensitive data on backup/Ensure changes cannot be made
                   to the backup
             (8)   Testing of backups
             (9)   Responsible person for backups
                                                                         (Any two)     2    4
10.7.1       Technology that is used to obtain location data
             GPS                                                                        1
10.7.2       Term for the data that is embedded in a picture file
             Metadata /Geotagging                                                       1    2
10.8.1       Why the data type of StationID is Short Text
             (1)   No calculations will be done
             (2)   The zero at the start of the number will display/In a Number data
                   type the zero at the start of the number will not display
             (3)   It may be a code in which the numbers carry a specific meaning
                                                                           (Any one)    1
10.8.2       How to sort rainfall values in ascending order per station
             (1)   Group by StationName
             (2)   Sort by Rainfall                                                     2    3
                                                                                             [25]
                                                                       TOTAL SECTION C:      50
                                                                           GRAND TOTAL:      150

 Copyright reserved                                                                                 *

## Related documents

- [Computer Application Technology P2 Nov 2019 Memo Afr](https://www.hlayiso.com/library/computer-application-technology-p2-nov-2019-memo-afr/2f72e6ce-b51a-4e66-9a85-593b7ef5e1aa) — Computer Applications Technology · Memo · 2019 · Afr
- [Computer Application Technology P2 Nov 2019 Afr](https://www.hlayiso.com/library/computer-application-technology-p2-nov-2019-afr/fe86afd5-0b52-4fb3-964c-f5cb7a49bedb) — Computer Applications Technology · QP · 2019 · Afr
- [Computer Application Technology P1 Nov 2019 Memo Afr](https://www.hlayiso.com/library/computer-application-technology-p1-nov-2019-memo-afr/4a07e78a-9b1c-44e8-a466-b6c73c8cac4b) — Computer Applications Technology · Memo · 2019 · Afr
- [CAT P2 GR12 MEMO SEPT2019 English](https://www.hlayiso.com/library/cat-p2-gr12-memo-sept2019-english/be90bdf5-3d2f-40b0-8dfd-16e7142e74e6) — Computer Applications Technology · Memo · 2019 · Eng
- [Computer Application Technology P2 Nov 2020 Memo Eng](https://www.hlayiso.com/library/computer-application-technology-p2-nov-2020-memo-eng/549aa96b-d6a9-4246-9d63-80e2ba254c10) — Computer Applications Technology · Memo · 2021 · Eng
- [Computer Application Technology P2 Nov 2018 FINAL Memo Eng1](https://www.hlayiso.com/library/computer-application-technology-p2-nov-2018-final-memo-eng1/f2cc1f64-6313-4ca1-a9d6-bae862968fc7) — Computer Applications Technology · Memo · 2018

## 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.
