PHS badge

PHS CyberSchool

Computer Studies SG Grade 11 - 2003

Last updated 18 November 2003

Theory examination November 2003 - 90 minutes - 100 marks

Section A - Multiple-choice questions - 20 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. The acronym GUI means ...
    1. greyed user information.
    2. graphical user interface.
    3. group user icons.
    4. group user interconnect.
  2. Main memory is referred to as ...
    1. extended.
    2. primary.
    3. secondary.
    4. temporary.
  3. RAM is ...
    1. long term.
    2. non-volatile.
    3. permanent.
    4. volatile.
  4. A Trojan horse virus is a ...
    1. program that copies itself into memory.
    2. program that copies itself into disk or network connections.
    3. program that executes a command after being initialised.
    4. program which is only executed when it is called up.
  5. Three basic types of viruses: 
    1. Boot sector, executable and macro 
    2. Boot sector, executable and micro 
    3. Boot, set-up and macro 
    4. Logic, executable and macro 
  6. Defrag should not be used without first:
    1. Running Backup 
    2. Running FAT 
    3. Running Scandisk 
    4. Running Utilities 
  7. Typical multiple layers of software are as follows: 
    1. Application software, operating system, drivers then hardware system software 
    2. Application software, system software, drivers operating system then hardware 
    3. Application software, system software, operating system, drivers then hardware 
    4. Application software, system software, operating system, hardware then drivers 

     

  8. The hardware which converts digital signals of a computer to analogue signals which can be carried along a telephone line:
    1. CPU 
    2. Fax 
    3. Modem 
    4. Printers 
  9. What is an operating system? 
    1. Hardware 
    2. Provides a series of utilities and commands that you can use to manage your files, folders and disks. 
    3. Creates a link between the user and the computer hardware by providing an interface, or environment, in which you can communicate with the computer. 
    4. Both (b) and (c) 
  10. To send a printed copy from a personal computer, it is necessary for the transmitting computer to have the following additional equipment: 
    1. Fax modem 
    2. Modem 
    3. Printer
    4. Scanner 
  11. Which ONE of the following functions is NOT provided by an operating system? 
    1. A spell checker for your documents 
    2. Instructions to coordinate the flow of information between the programs, files, printer, storage devices and other components of your computer system 
    3. Programs that allow you to specify the operation of the mouse 
    4. Programs for organising files. 
  12. The CPU loads programs from:
    1. Arithmetic to logic unit 
    2. CD ROM to secondary memory 
    3. Primary memory into secondary memory 
    4. Secondary memory into primary memory 
  13. The term "Utility" refers to: 
    1. Software needed for networking 
    2. Software that detects viruses 
    3. Software that makes our lives a little easier 
    4. Software to extend memory 
  14. Cache memory can also be called: 
    1. Permanent memory 
    2. Primary memory 
    3. Secondary memory 
    4. Slave memory 
  15. What does the Windows Utility "Scandisk" do? 
    1. "Boots" your system 
    2. Finds and fixes logical errors that may occur on disk 
    3. Scans for viruses 
    4. Scans through programs on the hard drive 
  16. Bits refers to:
    1. Basic codes 
    2. Basic input system 
    3. Back-up utilities program 
    4. The smallest unit of storage on a computer 
  17. Clock speed is measured in: 
    1. bps 
    2. Mb
    3. MHz 
    4. RAM 
  18. When a program becomes part of a silicon chip it is called: 
    1. Embedded 
    2. Firmware 
    3. Hardware 
    4. Software 
  19. Which of the following in NOT a characteristic of DRAM: 
    1. Is used for cache 
    2. Must be refreshed 
    3. Slow 
    4. Used for primary memory 
  20. CMOS refers to:
    1. Anti-virus program
    2. Revised version of MS DOS 
    3. Specialised software 
    4. Type of memory chip 

Section B - Computer Architecture - 16 marks

  1. The internal bus is actually a multi-bus because it consists of three different buses. 
    1. What is a bus? (1)
    2. State the name of these three buses and briefly describe the function of each. You may use a diagram to explain your answer. (6)  
  2. What are registers used for in the CPU? (2) 
  3. Differentiate between tracks and sectors using a diagram. (4) 
  4. Label the following diagram:  LPT COM USB (3)

.

 

Section C - System Software and Operating Systems - 18 marks

  1. BIOS 
    1. What does BIOS stand for? (1)
    2. In what type of memory is BIOS always stored? (1)
    3. Name the three components of the BIOS and briefly describe the function of each. (6)
  2. Drivers 
    1. What is a driver? (1)
    2. Suppose you have Windows 98 installed. Someone gives you a laser printer which is two years old but has lost the stiffy with the driver. Will it be a problem? Explain. (3) 
  3. Computer viruses 
    1. What is a computer virus? (2)
    2. Give three ways in which a computer virus can be spread. (3)
  4. What is the name of an Open Source operating system? (1)

 

Section D - Data Communication - 20 marks

A high school is planning a second computer centre. This centre will be used for Computer Studies as well as Technical Drawing. The plan is to have eight computers and a printer around every table. 

  1. Give three advantages of a network (3) 
  2. Why would a server-based network be a good idea for the layout in the above example? (2)
  3. What hardware must each computer have in order to link to a network? (1)
  4. What does the term topology refer to? (1)
  5. Of the three major topologies, ring bus and star, which fits each of the following descriptions? (4)
    1. The computers are connected to the network in a line, all attached to the same cable 
    2. Each computer is connected to the next computer, with the first one being connected to the last one 
    3. In what topology are the workstations not affected if one machine is broken? 
    4. In what topology or topologies is it easy to add workstations? 
  6. Ethernet uses the CSMA/CD. Explain briefly how this works. (3) 
  7. At each table is a hub. What is the function of a hub? (2)
  8. Give two functions the network administrator must perform, before the centre can be used. (2)
  9. Give two advantages of a fibre optic cable. (2)

Section E - Social and Ethical Issues - 10 marks

  1. Briefly describe how adjustments have been made in the design of computers and computer equipment in an attempt to curb energy consumption and environmental pollution. Give two examples (2)
  2. List two methods/techniques that are applied in the presentation and usage of web pages in an attempt to attract and keep the attention of visitors. (2)
  3. What is a digital signature? (2)
  4. Describe two advantages to the consumer of banking via the Internet. (2)
  5. Describe two disadvantages to the consumer of banking via the Internet. (2)

Section F - Applications Skills - 16 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. The following characters can be used to construct an Input Mask in Access. What will the result be if the following are used? (2)
      1. < 
      2. >
  2. Explain carefully where would you change the currency from dollar to rand in Excel? (1)
  3. What character is displayed in a cell that is too small to hold the data entered in it? (1)
  4. How do you change text that was entered in Proper case or Title case into Upper case? (1)

 

 

 

 

  1. The formula =$C$3*D3 is located in cell B1. If this was copied and pasted into cell C1, what would the resulting formula be:  (1)
    A B C D
    1   =$C$3*D3 ?????????  
    2 3 3 4 6
    3 5 4 3 8
    4 4 3 4 9
    1. =$C$3*e3
    2. =C3*e3
    3. =$C$3*d3
    4. 24
  2. Which of the following would be a good reason to use conditional formatting?  You want the (1)
    1. cell contents to update automatically
    2. to see if a formula is correct
    3. to be able to move data quickly
    4. to see whether the value in a cell meets a specified condition
  3. Which of the following methods would you use if you want to copy data that will update whenever the data in the source data changes?  (1)
    1. select data to copy, Copy, then Paste
    2. select data to copy, Cut, then Paste Special
    3. select data to copy, Copy, then Paste Special
    4. none of the above
  4. Which of the following are required arguments in a PMT function? (1)
    1. Interest Rate, Number of Payments, Amount of the loan 
    2. Interest Rate, Range affected, Amount of the loan
    3. Comparison, Interest Rate, Amount of the loan
    4. None of the above 
  5. To protect a worksheet, you ... (1)
    1. first select unprotected cells and change settings to an unlocked status.
    2. protect the entire worksheet.
    3. use the Protection command on the Tools menu.
    4. use all of the above.
  6. If you assign the value 42 to cell A1, the value 11 to cell B1, and cell C1 contains the function =IF(A1>4*B1,"Deductions","No deductions"), then cell C1 displays the message: (1)
    1. Deductions
    2. No deductions
    3. #REF!
    4. F5
  7. A pupil wants to calculate, in column D, the percentage out of 50 marks in Column C.  The following formula is typed in D3 and then copied down:  =C3/C1*100.  The following values appear in Column D.  Why is the correct value not calculated and how can it be corrected? (1)
    1.   C D
      1 50  
      2    
      3 30 60
      4 25 #DIV/0?
      5 40 1.33.333

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