PHS CyberSchool

Computer Studies SG Grade 12 - 2000

Last updated 4 May 2000

Theory examination May 2000 - 90 minutes - 100 marks

Section A - 30 marks

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

Select the one answer to each question.

1. The Internet ...
   1. cannot be accessed from a computer which does not have a modem.
   2. in the USA is distinct from the Internet in Africa and Asia.
   3. is a global collection of LANs, WANs and individual users.
   4. is another name for a Wide Area Network.
2. Which of the following could best be described as a WAN?
   1. A local area network in a school which allows learners to dial in from their homes to the server in the evenings
   2. A network in a Cape Town university which communicates with the Library of Congress network in Washington digital child (USA)
   3. An engineering firm that has networks at branches in Cape Town, Port Elizabeth and Durban
   4. The Internet
3. The network component which links a network cable to the motherboard is a …
   1. EMI
   2. FDDI
   3. NIC
   4. UPS
4. What does the system area on a diskette consist of? Select one of the following sets.
   1. boot record, CMOS, FAT
   2. boot record, FAT, root directory
   3. boot record, FAT, spooler
   4. eof, FAT, root directory
5. Which of the following sets are made up of ALL system software:
   1. Antivirus software, BIOS, Databases, Spreadsheets
   2. Antivirus software, Communication software, Drivers, Spreadsheets
   3. BIOS, Databases, Operating systems, Utilities
   4. BIOS, Drivers, Operating systems, Utilities

   
   
   

6. Data set by the user such as date, time, boot sequence, how fast your computer reads from memory, whether or not your cache is enabled or disabled, whether or not your CPU's cache is enabled or disabled is stored in …
   1. BIOS.
   2. CMOS.
   3. drivers.
   4. RAM.
7. In the communication of data … act as microwave relay stations.
   1. modems
   2. fibre-optic cables
   3. satelittes
   4. routers
8. What kind of communication cable links a firm which has branches in Bellville and Kensington?
   1. coaxial
   2. fibre optic
   3. high frequency radio waves
   4. twisted pair
9. A file that is automatically executed after DOS has been loaded is …
   1. autoexec.bat
   2. BIOS.
   3. DOS's utiliy program.
   4. Windows NT.

10. The following characteristics describe the … operating system:
    Limited primary store, only one process per time, character based interface.

    1. DOS
    2. Windows 3.1
    3. Windows 95
    4. Windows NT

/10/

Question 2 - Matching columns - 1 each - 10 marks

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

/10/

Question 3 - True or False - 1 mark each - 10 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. A new call centre that will offer mapping directions (via the Internet) as well as a wide ranging information service, is being established for Vodacom (cell telephone) subscribers (Intelligence April 2000 p. 23 and ). WAP (Wireless Application Port) technology will be used to integrate the Internet and cellular technology.
2. In clinet-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 main or primary memory of a PC is the hard disk because the PC stores information here first and cannot function without it.
4. A gateway is a device that can interpret and translate the different communication rules (protocols) that are used on two different networks so that communication can occur.
5. A system analyst deals with breakdowns in computers and related equipment. They have usually qualified at a technikon and / or have an A+ certificate.

/10/

Section B - 50 marks

Question 4 - System software - 17 marks

1. Name two things that are transferred to the disk during the formatting process. [2]

   [2]

2. Peripheral devices can slow down the overall speed of a computer system.
   1. Why does a peripheral device cause slowness? [1]
   2. Explain the working of a spooler with different work stations on a network which have to share one printer. [2]

   [3]

3. Viruses:
   1. How can a computer system become infected with a virus? Name the source of the virus and describe how it is transferred to the computer system. [2]
   2. How would you ensure that a computer system does not become infected? Name two precautions.[4]

   [4]

4. Plug and Play:
   1. What does Plug and Play mean? [2]
   2. Name two items which utilise this Plug and Play facility. [2]
   3. Name two advantages of Plug and Play. [2]
   4. Where does Windows keep track of Plug and Play devices? [2]

[8]

/17/

Question 5 - Data communication and networks - 33 marks

1. Give two characteristics of a situation where each of the following types of network operating systems will be preferred:
   1. Peer-to-peer [2[
   2. Client-server [2]

   [4]

2. Connecting:
   1. Why would one use a modem? [2]
   2. What are the differences between analog and digital switching? [2]
   3. Briefly discuss the terms BAUD and Bits Per Second detailing how they differ. [2]

   [6]

3. One of the most useful facilities provided by the Internet is the World Wide Web.
   1. What is hypertext? [1]
   2. What hardware will an individual require in order to get connected to the Internet? [1]
   3. When someone wants to use the Internet he first has to decide on a Service Provider. In this regard what is a Service Provider? [1]
   4. What type of network is the Internet? [1]
   5. Describe two useful features of the World Wide Web. [2]

   [6]

4. A high school recently installed a local area network in order to give all learners access to the Internet.
   1. Name a suitable topology for this network. [2]
   2. Draw a simple diagram to show the topology and the equipment needed to connect to the Internet. [2]
   3. What type of cabling should the school have and why? [2]
   4. Draw a diagram to indicate what this type of cable looks like. [2]

      [8]

5. A repeater, bridge and router connect network segments. Compare these three devices by completing the following table. Draw and complete the table.

   Device	Function	Architecture linked - Similar / Different	Use in a ... environment - LAN / WAN
   Repeater
   Bridge
   Router

   [9]

/33/

Section C - 20 marks

Answer only one question from this section, i.e. Business Skills Module or Presentation Skills Module. If you answer both, i.e. Question 6 and Question 7, only the first question will be marked.

Question 6 - Business Skills Module - 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. Why is alphanumeric (or text), selected as the data type for the address field? [1]
   2. How many records will be in this database? [1]
   3. Name a primary key field found in this database. [1]
   4. Which function of the word processor can be used to personally invite every club member to the annual dance? [1]
   5. How can she use this database to address these invitations? [1]
   6. Give a suitable file name (with an extension), for the file in which this database is stored, if the computer uses a DOS operating system.[1]
   7. Name TWO other 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]

   [8]

2. In a certain database there are amongst others, two fields: a field "YYYY" for the year in which children were born. This field is defined as an integer with a length of 4. a field SMALLPOX which indicates if a learner has been vaccinated against smallpox. It is defined as Boolean (Yes/No).
   1. Do you think this database is Year 2000 compatible? Why? [2]
   2. If we wish to define the age of a child for sports purposes we say he/she is Under 12 if he/she is born in 1987 (1999 - 1987 = 12). Which age group will be obtained with the following queries?
      1. YYYY = 1986 [1]
      2. YYYY > 1986 AND
      3. Which group of children will be obtained with the following queries?
         1. YYYY > 1986 AND SMALLPOX = TRUE [2]
         2. NOT SMALLPOX AND YYYY <> 1987 [2]
      4. Name TWO other data types (apart from Integer and Boolean) whereby fields in a database can be defined. Give an example of such a field with every type which you give. [4]

         [12]

/20/

Question 7 - Presentation Skills Module - 20 marks

1. Answer the following questions very carefully backing up your choices with good reasons:
   1. When would you use a desktop publishing rather than a word processor package? Why? [2]
   2. When would you use a CAD package such as KeyCad, rather than a graphics package such as MS Draw, the package in MSWord? Why? (Both can draw straight lines, boxes and shapes.) [2]
   3. Which type of font is preferable for headings, road signs or advertisements? - Serif or sans serif. Why? [2]
   4. When is the best time of day and or week to access the World Wide Web? Why? [2]
   5. Why would you try not to use (digitised) speech on a web site to be viewed in South Africa? When could you use (digitised) speech in South Africa? Why? [2]

   [10]

2. The postmaster at Pinelands High School received a request from letskeepitprivate@ih2000.net to put information on the Pinelands High School Past Pupils' web page recently. She complied with the request. The information between brackets is the information on the Pinelands High School web page a few days later.

   (The 1951 graduating class are organising a class union on October 2, 1999. They will take part in the activities of Pineland Day, then class members will gather at the Catfish Cabin in Jasper for dinner that evening. Helen Rake Class of '51 is the contact person.

   Oh dear. I have made a huge mistake. I received an email letter from Helen. I checked the dates and it did not sound correct but I put up the information as requested. It took a day to register. The message was aimed at Pineland High School in the USA! - Oops, Sorry - Pam Miller, PHS Postmaster)

   Answer the following questions:

   1. When Helen Rake emailed the postmaster, how should she have known the country in which the school was situated? Explain with examples. [1]
   2. The postmaster at Pinelands High School did not recognise the domain in Helen Rake's address.
      1. What is a common domain in South African email addresses? [1]
      2. What is a common domain for American email addresses? [1]
   3. What is the role or duty of a postmaster (not webmaster)? [1]
   4. How did Helen Rake in Texas find the URL of PinelandS High School? Explain very carefully giving names and examples. [1]
   5. What are the first 10 characters of the URL of the Pinelands High School web site? [1]
   6. When Helen Rake looked at the Pinelands High School web page, what web browser would she probably have used? [1]
   7. If Helen Rake had looked at the web page closely she could have seen the Pinelands High School badge. Explain carefully how she could have taken the GIF badge off the page to use in her own newsletter describing the funny incident. [1]
   8. If she had used the GIF badge and made it a different size it would have developed fuzzy lines. Is the file format a bitmap or a vector format? [1]
   9. What Internet feature would allow the two people to have a private discussion in real time? [1]

[10]

/20/

/100/

Return to Grade 12 lessons in 2000 or Computer Studies lesson plan index of Pinelands High School. The views expressed do not necessarily express those of Pinelands High School. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.