PHS badge

PHS CyberSchool

Computer Studies SG Grade 12 - 2002

Last updated 06 Sep 2002

Theory examination September 2002 - 90 minutes - 100 marks - Answers

Section A - 25 marks

Question 1 - Multiple-choice questions - 1 mark each - 10 marks

  1. 2
  2. 2
  3. 4
  4. 4
  5. 4
  6. 2
  7. 4
  8. 3
  9. 4
  10. 4

/10/

Question 2 - Matching columns - 1 each - 10 marks

  1. Compares data as a part of a whole - L or 12 - Pie graph
  2. Creates a temporary subset of records - B or 2 - Filter
  3. Device which can read the special characters printed on bank cheques - J or 10 - MICR
  4. Device which makes it possible to transfer several messages simultaneously on a communication medium - K or 11 - Multiplexer
  5. Graphic representation of a program on the desktop - G or 7 - Icon
  6. Protocol which enables users with wireless devices, e.g. a cellphone, to interact instantaneously with information and services over the Internet  - P or 16 - WAP
  7. Self-loading instructions of a computer are stored here - N or 14 - ROM
  8. System designed to prevent Internet users from gaining access to private information - C or 3 - Firewalls
  9. Total amount of data that a communication medium can transmit in a time interval - A or 1 - Bandwidth
  10. Used to download programs from the Internet to your personal computer - D or 4 - FTP

/10/

Question 3 - True or False - 1 mark each - 10 marks

  1. False - bank debit card
  2. False - Cell
  3. False - Clipart
  4. True
  5. True
  6. True
  7. False - Peer to peer 
  8. False - hard drive 
  9. False - Wordwrap
  10. False = Primary key

/10/

Section B - 50 marks

Question 4 - Architecture - 20 marks

  1.  
  1. 1 GHz (1)
  2. AGP (1)
  3. modem (1)
  4. OEM Middle Tower ATX 200W PSU (1)
  5. ready sound (1)
  6. normal basic keyboard, not enhanced (1)
  7. storage device for carry or backing up data (1)
  8. transfers data 24 writes X 10 reads-writes X 40 reads  (1)
  9. mouse which uses a PS2 port (1)
  10. Uninterrupted power supply (1)
  11. Seagate, Maxtor (2)
  12. 128 Mb SDRAM primary memory, 60 GB secondary memory on the hard drive or 1.44 Mb stiffy (2)
  13. compare the secondary memory, compare the primary memory, compare the removable siffy memory, compare the SDRAM and DRAM (6)

[20]

 

Question 5 - Operating systems and system software - 17 marks

  1. the graphic user interface (1)
  2. system software controls, supports and operates the computer, e.g Windows 98 and Linux
    application software are programs that the user buys or develops in order to solve a specific problem or perform particular tasks, e.g. Word, computer games, Excel (2)
  3. defrag, scandisk,  (2)
  4. support and updates available online
    built-in web application service
    designed for business environment
    in order to use new software
    user interface simplified
    support for latest hardware
    built on Windows NT technology
    has Internet security (3)
  5. input/output management
    user interface
    memory management
    process management, resource allocation, time allocation  (4)
  6. 1. BIOS
    2. CMOS
    3. ERROR (not warining - use computer terminology)
    4. Bootstraploader
    5. Operating system  (5)

/17/

Question 6 - Data communication and networks - 13 marks

  1.  

    1. look in textbook - so easy (4)
    2. ring, star, bus, hybrid (3)
    3. look in textbook - so easy. (2)
    4. network interface card (1)
    5. look in textbook - so easy (3)

    [13]

Section C - 20 marks

Question 7 - 20 marks

  1.  

  1. =sum(A1:D1) (1)
  2. =A1+$E$1 (1)
  3. =countA1:E3)  (1)
  4. E1*120% (1)

[4]

  1.  

    1. salaries, accounting of comapny, graphs, price lists - not staff details (2)
    2. cell not formatted as Date/Time (1)
    3. headings bold (1)

    [4]

  2.  

    1. save it with a different name (1)
    2. both primary and secondary memory? (1)
    3.  
      1. leave enough space for the letterhead details, then put pre-printed letterheads in the printer tray and print on them (1)
      2. use a template (1)

      [4]

  3.  
    1. can do queries easier, manipulate data, print reports (2)
    2. Date/Time - date bought
      Hyperlink - Link to web site of artists
      Number - Number in stock
      Currency - Price (3)
    3.  
      1. table, database (1)
      2. primary key (1)
      3. record (1)

      [8]

      /20/

      /100/

This work may be freely copied for non-commercial use only. Copyright © Pam Miller.