PHS badge

PHS CyberSchool

Computer Studies SG Grade 12 - 2002

Last updated 01 Jun 2002

Theory examination May 2002 - 90 minutes - 100 marks

Section A - 25 marks

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

Select the one answer to each question.

  1. Routines that are executed before the operating system interprets and executes the commands entered:
    1. Bootstrap loader
    2. Command processor
    3. Operating system
    4. POST

     

  2. The built-in facility of Windows 98+ to automatically add new hardware:
    1. 32-bit data bus
    2. Plug and Play
    3. TCP/IP 
    4. Windows Explorer

     

  3. Which of the following is not an example of an operating system?
    1. Linux
    2. MS DOS
    3. MS Office
    4. Windows 2000

     

  4. In order to use telephone lines to carry data transmissions, a hardware device that will convert digital signals to analogue signals is required. This device is called a(n) …
    1. encryptor.
    2. interface.
    3. modem.
    4. translator.

     

  1. A dedicated channel or circuit is established connecting the sender and receiver by a single path for the duration of the call:
    1. Cell switching
    2. Line switching
    3. Message switching
    4. Packet switching
  2. A technique used to prevent unauthorised use of sensitive information is …
    1. blocking.
    2. decryption.
    3. encryption.
    4. hashing.

     

  3. Which of the following characteristics of an operating system will be sufficient if it is required that a numbers of users, interactively, via terminals, simultaneously need access to a program on a central server?
    1. Remote job entry
    2. Multiprogramming (also called multi-tasking)
    3. Multi-access
    4. Timesharing

     

  4. A disadvantage of satellite transmission is …
    1. bad weather can influence transmission.
    2. it is slower than other transmission media.
    3. it uses coaxial cable.
    4. it works on the line-of-sight principle.

     

  5. The most popular LAN architecture today is ...
    1. ArcNet.
    2. CSMA/CD.
    3. Ethernet.
    4. Token passing.

     

  6. An angry or insulting message directed to one person on the Internet.
    1. emoticon
    2. FAQ
    3. flame
    4. spam

/10/

 

Question 2 - Matching columns - 1 each - 10 marks

Write down the letter of the item in Column B which best matches the description in Column A.

 

Column A Column B
  1. Computer qualification for most senior executive secretary
  2. In local area networks, a device that enables networks with identical architectures, to exchange data
  3. In the early years of computers it required a separate utility program but now it is part of modern operating systems
  4. Operation performed to prepare a disk before information can be stored on it
  5. Programs written on chips like the Basic input/output system (BIOS)
  6. Qualification for Novel Netware system engineer
  7. Rules and procedures to govern the way data is transmitted between any two devices in a computer network
  8. Software used to compress files on two disks so that they fit onto one disk
  9. Some operating systems use it to manage secondary memory
  10. Version of Windows used on palmtops 
  1. Amadeus and Galileo 
  2. Amazon 
  3. Attenuation 
  4. Bridge 
  5. CD-ROM 
  6. CNE 
  7. Defrag 
  8. Digital literacy 
  9. DVD-ROM 
  10. Ergonomics 
  11. File allocation table (FAT) 
  12. Firmware 
  13. Format 
  14. Hard drive
  15. ICDL 
  16. Linux 
  17. MOUS 
  18. MSCE 
  19. Netiquette 
  20. PkZip 
  21. Protocol 
  22. Router 
  23. WebWhacker
  24. WebZip 
  25. Windows 3.1
  26. Windows CE

/10/

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

State whether each statement is True or False. Correct each of the false statements by rewriting the statement, changing the bold-printed portions only. No marks will be awarded for simply negating the false statement.

  1. Within Access the text key serves to prevent duplicate entries, blank entries, and automatically sorts or alphabetizes. 
  2. In client-server based networks each workstation can both request and provide services which include devices like CD-ROM drives, tape drives and removable cartridge drives.
  3. The source code of Windows NT is copyrighted under the GNU public licence, i.e. the system is freely distributed with the source code made available.
  4. WinZip is shareware software used to compress files on two disks so that they fit onto one disk.
  5. In desktop publishing the advantage of Quark is that one is able to use moveable objects.

/5/

 

Section B - 65 marks

Question 4 - Software - 28 marks

  1. Everyday I use my computer for typing out lesson plans for the following day.  For the past month, I have been deleting a huge number of old lessons that are now out of date.  I have also been saving several very large documents that people sent to me via email.  My computer has become very slow especially when I try to retrieve data from the hard drive.  Why has it become so slow? [1] What should I do about it?   [1]

[2]

  1. I recently cleaned up my hard drive by deleting many files and tidying up my Desktop.  I can't use my printer any more.  It says that a printer is not installed.  What has happened? [1]  What can I do about it? [1]

    [2]

  2. Select the operating system for different users. Choose from Linux, Windows NT, UNIX or Windows 98.
    1. Office network of 20 computers
    2. Single home user
    3. Small office of 2 computers

    [3]

  3. Drivers.

    1. What is a driver?
    2. Who supplies the drivers which are loaded onto the operating system for the different hardware components?
    3. Name another type of system software (apart from the drivers) that plays an important role in enabling the computer to 'talk' to devices.

      4. [3]

  4. Most viruses are file infectors that spread from program to program and do damage to code, data and directories. A file virus infects executable files.
    1. Name TWO other types of viruses and describe shortly what their aim is.[2] 
    2. How can one prevent viruses reaching a computer via the stiffy drive? [1]
    3. How can one prevent viruses reaching a computer via the Internet? [1]

    [4]

  5. Windows NT is the operating system at Old Mutual on which all system software and applications software is based.  (They may be changing to LINUX.)  This operating system supports time allocation, memory management, resource allocation, input/output management, process management, error handling and protection, user interface and accounting. Which ONE of these functions is applicable when …
    1. spoolers are created?
    2. icons of different programs are displayed on the desktop?
    3. virtual memory is created?
    4. it seems that more than one program is executed simultaneously?

    [4]

  6. On the shelf at your local software store are the following items: Doom, Internet Explorer, Laplink, Norton Anti-Virus, Office 2000, PC Handyman, QuickBooks Accounting, Windows 2000 and WordPerfect8. Which of the items is a(n): 
    1. Data communication software package?
    2. Integrated package?
    3. Operating system?
    4. Single function package?
    5. Utility package?

    [5]

  7. When a computer is switched on, control is automatically given to the … 8.1 … The computer then does a self-test and compares all components against the record in the … 8.2 … If any components are faulty a(n) … 8.3 … message will be displayed on the screen. The … 8.4 … program then decides if the … 8.5 … from the A drive or the C drive must be loaded.

    [5]

/28/

Question 5 - Data communication and networks - 37 marks

  1. How can a LAN could develop into a MAN?

    [2]

  2. The Internet uses the TCP/IP protocol suite.  List three things a protocol does?  

    [3]

  3. How can WAP get you connected to the Internet?  Use the following words to explain the process, with illustrations if you wish:  cell phone, stylus, microbrowser, HTML, WML, WAP enabled phones, WAP gateway and Nokia.

    [4]

  4. Discuss four ways in which data can be protected (not security controls).

    [4]

  5. When a network needs expansion, the following devices are used: hub, bridge, router, repeater or a gateway. Which device does the following refer to?
    1. Is usually used between mainframe computers and other microcomputers that use different operating systems and protocols.
    2. A device that connects many UTP-cables so that signals can be transmitted between the different computers.
    3. Amplify and regenerate signals received from one LAN cable and then transmit the upgraded signal on another LAN cable.
    4. Links LANs that use the same medium, topology and architecture.
    5. Determines the best possible path to send information to a segment in the network.

    [5]

  6. Hubs
    1. What is the function of a hub? [1]
    2. There are three main types of hubs.  Discuss how they differ from each other. [3]
    3. What type of network would use a hub? What cable type [1], topology [1] and architecture [1] would it use?

    [7]

  7. A school has 20 Pentium stand alone computers they want to network. 
    1. What hardware would they require to accomplish this aim? [4]
    2. What software would they require to accomplish this aim? [2]
    3. To provide email that will offer external communication they could use a dial-up or a dedicated line.  Discuss each of these options [2] as well as giving one advantage [2] and one disadvantage [2] of each.

    [12]

/37/

Section C - 10 marks

Question 6 - 10 marks

  1. The table below shows an extract from as spreadsheet.

  A B C D
1 111 222 333 444
2        
3        
4        

In each of the following cases write down the formula which will

  1. calculate 111 + 222 + 333 + 444 by using only two cell references.
  2. give the answer to 111 + 444 in cell A3.
  3. increase the value of D1 by 20%.
  4. count how many entries are made in cells A1, B1, C1, D1, A2, B2, C2, D2, A3, B3, C3 and D3, and place the answer in D4.

[4]

 

computer67.gif (12625 bytes)

 

  1. XYZ Chicken Chain employs 2000 workers.  All their staff details are found in a database.  One of their aims is to place workers in the right position according to their talents and qualifications.   They believe that workers' past experience must be used and developed in their work.  The firm has identified a new project suitable for workers who have had training and experience as cashiers and are between the ages of 25 and 30.

  1. Which three fields in the database will be definitely be used in the query to select workers who can work on this project? [3]
  2. What will the range of ages be that will be incorporated in the query of the question above, if the criteria for age are as follows? [3]
  1. >25 AND <30
  2. >25 OR <30
  3. >25 AND =<30

[6]

/10/

/100/

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