PHS CyberSchool

Computer Studies SG Grade 12 - 2001

Theory examination May 2001 - 90 minutes - 100 marks

Section A - 30 marks

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

1. In May 2001 the second largest (or by the end of May it may be the largest) ISP in South Africa is …
   1. ABSA.
   2. AOL.
   3. Kingsley.
   4. Western Cape Schools' Network.
   
   
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.
   
   
5. To read a downloaded bank statement from an online bank which of the following format groupings is unsuitable?
   1. ASCII format, Microsoft Money, Quicken, Pastel Formats
   2. Comma-delimited text file viewable by word processors or spreadsheets
   3. Excel, Microsoft Money
   4. PowerPoint, Windows Metafile Format
   
   
6. A technique used to prevent unauthorised use of sensitive information is …
   1. blocking.
   2. decryption.
   3. encryption.
   4. hashing.
   
   
7. 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
   
   
8. A disadvantage of satellite transmission is …
   1. it is slower than other transmission media.
   2. it works on the line-of-sight principle.
   3. bad weather can influence transmission.
   4. it uses coaxial cable.
   
   
9. Which of the following physical or architectural features will enhance a good desktop publishing computer?
   1. CD-ROM drive, colour printer, 1.44 Mb disk drive
   2. desktop publishing software application, keyboard, mouse
   3. fast processor, large amounts of RAM, large storage capacity
   4. large monitor, clipart, scanner
   
   
10. BSA (Business Software Alliance) is a South African firm concerned with …
    1. e-commerce.
    2. unauthorized use of software applications.
    3. virus software.
    4. Year 2000 (Y2K) computer issues.

/10/

Question 2 - Matching columns - 1 each - 10 marks

 

Column A

Column B

In local area networks, a device that enables networks with identical architectures, to exchange data In the early years of computers it required a separate utility program but now it is part of modern operating systems Operation performed to prepare a disk before information can be stored on it Programs written on chips like the Basic input/output system (BIOS) Computer qualification for most senior executive secretary Qualification for Novel Netware system engineer Rules and procedures to govern the way data is transmitted between any two devices in a computer network Software used to compress files on two disks so that they fit onto one disk Some operating systems use it to manage secondary memory Version of Windows used on palmtops

Amadeus and Galileo  Amazon  Attenuation  Bridge  CD-ROM  CNE  Defrag  Digital literacy  DVD-ROM  Ergonomics  File allocation table (FAT)  Firmware  Format  Hard drive ICDL  Linux  MOUS  MSCE  Netiquette  PkZip  Protocol  Router  WebWhacker WebZip  Windows 3.1 Windows CE

/10/

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

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. A system analyst deals with breakdowns in computers and related equipment. They have usually qualified at a technikon and / or have an A+ certificate.
5. In desktop publishing the advantage of Quark is that one is able to use moveable objects.

/5/

Question 4 - Dear Doctor Byte ... - 1 mark each - 5 marks

Answer each question with a short answer.

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.   What should I do about it?
2. 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?
3. I create wonderful presentations on my computer at home and need to take them to school to use in class but they cannot fit on a 3½" disk.   How can I take a large file from one place to another, on a 3½" disk?
4. I took some wonderful holiday photographs and want to send copies of them to the people in Thailand with whom I spent my holiday.  I could send the photographs to them by normal postage but it is too slow and expensive.  What is a cheap and quick way to send photographs to people far away?
5. I pressed Print by mistake and wasted a great deal of paper printing rubbish.  What can I do, if and when I press Print by mistake, and want to stop 'mistake' printing.

/5/

Section B - 50 marks

Question 5 - Software - 20 marks

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

   [3]

2. 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. Utility package?

   [4]

3. 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]

4. Windows NT is the operating system at Old Mutual on which all system software and applications software is based. 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]

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

   [5]

   /20/

Question 6 - Data communication and networks - 30 marks

1. A daily newspaper has a local area network (LAN) which links all the computers in their Cape Town headquarters. The headquarters consists of a newsroom, an editorial office and a printing works. The newspaper also has a wide area network (WAN) linking it to a regional office in Bellville and an overseas office in London. The local area network is linked using cable connectors. How might the wide area network be linked between:
   1. Bellville and Cape Town?
   2. London and Cape Town?

   [2]

2. A small school is setting up a new computer centre, with 5 stand-alone computers, for learners. The school could have installed a network, but decided against this idea. Give two reasons for this decision using computer terminology.

   [2]

3. "The Internet is changing commerce."
   1. What type of commercial transactions can successfully take place via the Internet? Explain and give an example.(1)
   2. Give two advantages for a company to do sales over the Internet. (2)

   [3]

4. 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]

5. The network in a computer centre in a poorly resourced school is set up so that it is possible to log on to the Internet.
   1. Describe one advantage of the Internet for such a school. (1)
   2. Describe two technical problems a school must consider when using the Internet. (2)
   3. Describe one non-technical problems a school must consider when using the Internet. (1)

   [4]

6. 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]

7. With reference to Old Mutual and/or Woolworths' network describe fully the purpose of each the following.  Your answers must be meaningful with reference to these firms. 
   1. dedicated digital line
   2. firewall
   3. frame relay backbone cloud
   4. gateway
   5. hub
   6. packet/packet switching
   7. RAID
   8. regional node
   9. router
   10. UPS

   [10]

/30/

Section C - 20 marks

Question 7 - 20 marks

1. A tennis club's secretary treasurer wishes to create a database of the members of the club including their personal details and membership fees. Each member has a unique membership number. There are 50 members of the club.
   Note these facts and answer the following questions:
   1. Name two types of data, which can be used in the design of fields. Next to each type of data give an example that could be found in this database.(2)
   2. How many records will be in this database? (1)
   3. Give a suitable file name (with an extension), for the file in which this database is stored. (1)
   4. Name a primary key field found in this database. (1)
   5. Which function of the word processor can be used to personally invite every club member to the annual dance? (1)
   6. How can she use this database to address these invitations? (1)

   [7]

2. A sawmill has two depots, A and B, 5 km apart. The head office is situated at depot A. Data, necessary for processing is entered by the managers of the two depots using two workstations, into a central server which is situated at the head office. A third workstation at head office handles all office administration. At depot A there are 110 workers and at depot B 75 workers.
   Note these facts and answer the following questions:
   1. Why is a printer at depot B not necessary? (1)
   2. A dedicated line links depot B to the head office. What is meant by a "dedicated line"? (1)
   3. Name two kinds of connections you would recommend for this line. (2)
   4. What application package (word processor, spreadsheet, database, desktop publisher) is necessary to ...
      1. keep a comprehensive record of the personal details and appointment conditions of each worker? (1)
      2. prepare an attractive notice for the workers giving details of the arrangements for the Christmas party? The notice would be fixed to the workshop door.(1)
      3. calculate weekly the workers' salary? (1)

   [7]

3. You have been asked to help organise a concert.
   1. You have to create advertising for the concert. There are two types of graphics - vector and bitmap. Which type of graphic would you use if you wished to enlarge or make the graphic smaller without creating fuzzy lines? (1)
   2. Give the name of a well-known computer program that will let you create graphics in bitmap format. (1)
   3. Owing to certain problems you will have to create the brochure at one centre and print it at another centre. Name two fonts that are certain to be on both computers. (2)
   4. Name two advantages of desktop publishing over current (2001) word processing applications. (2)

[6]

/20/

/100/