PHS CyberSchool

Computer Studies SG Grade 11 - 2002

Last updated 28 November 2002

Theory examination November 2002 - 90 minutes - 100 marks

Section A - Multiple-choice questions - 15 marks

Select the one answer to each question which you think is the correct or best answer. Just write down the question number and the letter.

1. You use ... to organise files on the hard disk.
   1. Windows Explorer
   2. the control panel
   3. Internet Explorer
   4. Access
2. Which of the following is a multitasking, multiuser, multiprocessing network operating system?
   1. DOS
   2. Windows 3.1
   3. Windows 95
   4. Windows NT
   5. None of the above
3. Software is integrated when it ...
   1. consists of programs stored on one compact disk.
   2. is a program that was developed for the needs of a specific business only.
   3. consists of a few applications designed to work in combination with one another.
   4. can be used on any computer.
4. Which of the following allows Microsoft Windows users to easily join and share data among applications?
   1. GUI
   2. NOS
   3. NUI
   4. OLE
   5. OS/2
5. XYZ-Traders employs 2000 workers. One of their goals is to place the workers according to their training and skills. They believe that the experience of the employees must be utilised and expanded in their work. The firm has just
   identified a new project in which employees between the ages of 25 and 30 with training and experience as plumbers may be employed to advantage. In a database program doing a query, which will be used as criteria if workers between and of the ages of 25 and 30 must be selected?
   1. >25 AND <30
   2. >25 OR <30
   3. >=25 AND <=30
   4. >=25 OR <=30
6. Which of the following is accessed when you switch on your computer?
   1. coprocessor chip
   2. RAM chip
   3. ROM chip
   4. Simba chip
   5. All of the above
7. Which of the following is a standard LAN component?
   1. cabling system
   2. network interface cards
   3. network operating system
   4. shared devices
   5. All of the above
8. Which of the following best describes the telephone line that is used in most homes today?
   1. coaxial cable
   2. fibre-optic cable
   3. modem cable
   4. twisted-pair cable
   5. None of the above
9. Which of the following configurations always uses a central server?
   1. bus
   2. hybrid
   3. ring
   4. star
   5. All of the above.
10. Which of the following do local area networks enable?
    1. access to databases
    2. better communications
    3. sharing of peripheral devices
    4. sharing of programs and data
    5. All of the above
11. Which of the following enables different computers on different networks to communicate with each other?
    1. FTP
    2. Internet service provider
    3. modems
    4. TCP/IP software
    5. All of the above
12. Which of the following would you use to write files for the Web?
    1. FTP
    2. Gopher
    3. HTM
    4. HTTP
    5. All of the above
13. Which of the following addresses might you use to connect to a non-profit organisation?
    1. clifford@iafrica.com
    2. help@volunteer.mil
    3. petrust@mweb.co.za
    4. susanh@universe.org
    5. All of the above
14. Which transmission medium is immune to interference and eavesdropping from outside the cable, has a low attenuation
    rate, is reliable and secure, but its installation is complex and it is difficult to maintain?
    1. Coaxial cables
    2. Fibre optic cables
    3. Infrared
    4. Twisted pair cables
    5. None of the above
15. Read Only Memory (ROM) is ...
    1. volatile.
    2. is programmable.
    3. is mounted on the mother board.
    4. contains the boot strap loader.
       1. (1) and (4)
       2. (1), (2) and (4)
       3. (3) and (4)
       4. (1) and (3)

Section B - True or False, correct it - 5 marks

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

1. A bank credit card is used to instantly transfer money electronically from your account to the account of the firm where you are buying.
2. If the hard disk of your computer is faulty, a computer technician will be able to replace it.
3. Main memory is non-volatile.
4. A block is the intersection of a row and a column in a spreadsheet.
5. System software consists of several programs, one of which is the operating system.

Section C - Hardware and Software - 25 marks

1. Why is speed an important issue when selecting a modem? [2]
2. What does the term platform refer to? [2]
3. What is the function of the registers? [3]
4. Name the four steps in the machine cycle in the correct order. [4]
5. List the four steps in the booting up process in the correct order. [4]
6. Utilities
   1. Where or how would you find the utilities to run Scandisk or Defrag? [1]
   2. What does the utility Scandisk do? [2]
   3. What does the utility Defrag do? [2]
7. Ports
   1. Name three ports found on computers. [3]
   2. Which is the most recent port and how is it an improvement on the previous types? [2]

Section D - Terminology - 10 marks

For each of the following write down the letter of the item in Column B which best matches the description in Column A.

Section E - Data communication - 15 marks

1. Give two characteristics of a situation where each of the following types of operating systems will be preferred, i.e. when should one use peer-to-peer and when server-based network systems?
   1. peer-to-peer [2]
   2. server-based [2]
2. In a computer network data must be safeguarded against accidental loss or corruption of data. Name two ways in which data can be corrupted accidentally and in each case write down one method of protecting the data. [2]
3. Name two tasks of a network administrator. [2]
4. Costs
   1. What is the name of an Open Source operating system? [1]
   2. What is the inexpensive network system called where computers only have a network interface card and boot ROM, and is linked to a server? [1]
5. Identify the pictures with respect to networks and networking in Appendix A. Write down the number of the picture and what it is. Select the words from the given list: BNC connector, Bus topology, Coaxial cable, Fibre optic cable, GAN, Hybrid topology, LAN, MAN, Mixed topology, Ring topology, Star topology, STP - IBM Universal Connector, Twisted pair cable, UTP connector, WAN. [5]

Section F - Social implications of the computer - 10 marks

1. Name two South African shops / stores which have a large online shopping / retail section. [2]
2. Banking
   1. Describe two advantages to the consumer of banking via the Internet. [2]
   2. Describe two disadvantages to the consumer of banking via the Internet. [2]
   3. The ABSA bank web site sometimes takes a long time to open. 
      1. When is it cheapest to access the ABSA web site?  Give the time of day/night and day of week, and motivate your choice. [1]
      2. What would be a good time to access the ABSA web site with reference to fast download time?  Give the time of day/night and day of week, and motivate your choice. [1]
3. Describe two famous persons specifically connected with the ICT aspect of e-commerce, and indicate in which field of e-commerce they are involved. [2]

Section G - Application skills - 20 marks

1. XYZ-Traders employs 2000 workers. One of their goals is to place the workers according to their training and skills. They believe that the experience of the employees must be utilised and expanded in their work. The firm has just identified a new project in which employees between the ages of 25 and 30 with training and experience as plumbers may be employed to advantage.
   1. Name four fields in a database that will definitely be used in a query to select the names of workers who can be assigned to the project. [4]
2. What are the requirements for the titles of a spreadsheet when it is merged with a document in a word-processor? [2]
3. Most organisations use a letterhead on which to type official letters. How will they go about typing letters using a word processor
   1. on pre-printed letterheads? [1]
   2. when the letterhead is added electronically and must always be displayed in exactly the same way? [1]
4. The more time you spend on the Internet the greater your costs.  The spreadsheet below describes telephone usage for accessing the Internet and costs. The costs need to be calculated.  The Minutes are multiplied by Tariff 1 to obtain the Sub-Total.  The VAT is based on the Sub-Total.  The Total is obtained by adding the Sub-Total to the VAT.
   1. What formula was used to find the Total time spent on the Internet, i.e the formula in Cell B11? [2]
   2. What formula was used to find the Average time spent on the Internet, i.e the formula in Cell B12? [2]
   3. Using absolute referencing, what formula was used to find the Sub-Total, i.e the formula in Cell C5? [2]
   4. Using absolute referencing, what formula was used to find the VAT on the Sub-Total, i.e the formula in Cell D5? [2]
   5. What formula was used to find the Total cost on Monday, i.e the formula in Cell E5? [2]
   6. What is Cell C5 formatted as? [2]  

	A	B	C	D	E	F	G	H
1							Tariff 1	VAT
2							R0.50	14%
3
4		Minutes	Sub-Total	VAT	Total
5	Monday	9	R4.50	R0.63	R5.13
6	Tuesday	5
7	Wednesday	7
8	Thursday	6
9	Friday	10
10
11	Total	37
12	Average	7.4

/100/

Appendix A

1	2
Did not print
3	4
5	6