2000 Question Paper

 

 

 

 

 

         

 

 

 

 

COMPUTER STUDIES

 

 

2000

 

 

QUESTION AND ANSWER BOOKLET

 

 

Time Allowed: 2 hours

 

 

INSTRUCTIONS

1. Before you start, write your candidate code on this page and on the back flap.

2. Attempt ALL questions.

3. The answer sheet for Section A is found on the fold out flap on the last page of this booklet. Answers for Section B are to be written on the spaces provided in this booklet.

4. The paper is marked out of 100 and marks are apportioned as follows:

Section

Comments

Marks

Suggested Time

A

There are 20 Multiple Choice questions.

20

24 minutes

B

There are 5 Short Answer questions.

All are compulsory.

80

96 minutes

SECTION A: MULTIPLE CHOICE

(20 Marks)

Answer all questions.

Write the LETTERS of the best answers in the boxes on the back flap.

If you change your mind, put a line through the first answer and write your new choice beside the box.

1. Which list contains only computer input devices?

A. mouse; printer

B. monitor; printer

C. mouse; keyboard

D. monitor; keyboard

 

2. A computer which worked yesterday does not start today when switched on. What should you check first?

A. That the mouse is attached.

B. That the video lead is attached.

C. That the keyboard is plugged in.

D. That the power lead is plugged in.

 

3. While printing a document you get an error message after the first page has printed. What should you check first?

A. That the printer is switched on.

B. That there is paper in the printer.

C. That there is ink, or a ribbon, in the printer.

D. That the correct printer driver is being used.

 

4. Inked ribbons are used in what type of printer?

A. Laser

B. Inkjet

C. Bubblejet

D. Dot matrix

 

5. In which way is data stored on 1.44MB floppy disks?

A. Optically

B. Electrically

C. Dynamically

D. Magnetically

6. Which string of bits represents one byte?

A. 1011

B. 101101

C. 10110100

D. 1011010010

 

7. Data on a 1.44MB floppy disk may be damaged if the disk is

A. stored next to CD ROMs.

B. kept in a warm, dry place.

C. left lying in direct sunlight.

D. left lying in a dark room for days.

 

8. An example of application software is

A. a spreadsheet.

B. an operating system.

C. a central processing unit.

D. a driver for a CDROM drive.

 

9. A menu driven program is running on your computer. The FILE menu is activated. This is shown in the diagram on the right.

To quit the program you use

A. the ESC key.

B. the ENTER key.

C. the arrow keys and then the TAB key.

D. the arrow keys and then the ENTER key.

 

10. All important files on a computer should be backed up regularly. This can be done using

A. random access memory.

B. read only memory.

C. a CD ROM drive.

D. floppy disks.

 

QUESTION 11

The following diagram shows a part of a page created by a word processor.

11. Which alternative best describes the format of the title word COMPUTERS?

A. Plain

B. Bold only

C. Bold and underlined

D. Bold and underlined and centred

 

12. What does the point size of a font measure?

A. The width of the letters on the page

B. The height of the letters on the page

C. The area occupied by each letter on the page

D. The number of pixels each letter uses on the screen

 

QUESTIONS 13 TO 16

The cells of a spreadsheet are shown in the diagram below.

A

B

C

D

1

Name

Time Worked

Pay Rate

Pay

2

Jane

2.5

$ 1.50

$ 3.75

3

Lose

2.0

$ 1.00

$ 2.00

4

Obed

1.4

$ 3.25

$ 4.55

5

Total =

$ 10.30

 

13. What type of information is entered in column A?

A. Data

B. Labels

C. Functions

D. Calculations

14. What entry is most likely entered into cell D2?

A. = B2*C2

B. = B2+C2

C. = SUM(B2:B4)

D. = SUM(B2:C2)

 

15. In the spreadsheet shown, Jane�s pay rate changes to $1.60. If the spreadsheet is properly constructed which cell or cells must be altered to recalculate the pay?

A. C2 only

B. B2 and C2

C. C2 and D2

D. C2, C3 and C4

 

16. What entry is most likely entered into cell D5?

A. = C2+C3+C4

B. = SUM(D1:D4)

C. = SUM(D2:D4)

D. = C1+C2+C3+C4

QUESTIONS 17 TO 20

The table view of a newly defined database called ClassRoll is shown in the diagram.

17. According to the diagram how many fields are there in the database called ClassRoll?

A. 4

B. 5

C. 6

D. 7

 

18. Information about 60 students is entered into the database called ClassRoll. How many records are now in the database?

A. 0

B. 60

C. 300

D. 360

19. The 60 students� LastNames now in the database are arranged in ascending alphabetical order. This is performed by using which database capability?

A. Sort

B. Insert

C. Select

D. Report

 

20. The 60 students� LastNames now in the database are arranged in ascending alphabetical order. Which statement is true?

A. The order of the field names changes.

B. The contents of each individual record remain unaltered.

C. The order of the information in the other fields is unaltered.

  1. The students� ages are also arranged in ascending numerical order.

 

SECTION B: SHORT ANSWERS

(80 marks)

QUESTION ONE

John grows vegetables and fruits. He sells them in the local market. He needs to buy a computer to help him with his business.

He is offered two computers for sale. Computer 1 has 8 MB of RAM and 127 MB of hard drive space. Computer 2 has 16 MB of RAM and 1 GB of hard drive space.

(a)

(i) What does RAM stand for?

(1 mark)

(ii) What is the purpose of RAM in a computer?

(1 mark)

(iii) Explain the relationship between MB and GB.

(1 mark)

(iv) What is the purpose of a hard drive in a computer?

(1 mark)

(b) John tries out computer 1. He turns it on, and the computer loads the OS.

(i) What does OS stand for?

(1 mark)

(ii) What is the purpose of the OS?

(1 mark)

 

(iii) Name one OS.

(1 mark)

© John then starts the word processor. He finds that it runs very slowly.

Use the information about computer 1 given at the start of this question one (on page 7). Give one possible reason why the word processor may be running slowly.

(1 mark)

(d) John decides to buy computer 2. When he gets it home he has to re-connect the components. Here is a picture of four of the plugs. What computer component are each of these plugs wired to?

(i) _______________ (ii) _______________ (iii) _______________ (iv) ______________

_______________ _______________ _______________ ______________

(2 marks)

(e) When the computer is assembled it looks like the picture below.


(i) Name the two devices labelled A and B.

A.

B.

(2 marks)

(ii) The hard disk drive is inside the case. Explain why the hard drive is hidden from the user.

(1 mark)

(f) Here is a block diagram showing some of the components of a computer.

Draw arrows on the diagram between the blocks and the Central Processing Unit. The arrows should show the direction in which information flows in the computer.

(3 marks)

 

 

 

 

 

 

QUESTION TWO

John grows vegetables and fruits. He sells them in the local market. He buys a computer to help with his business. John starts the computer and formats a 1.44MB floppy disk.

(a) Describe one way that he could format the disk.

(1 mark)

(b) He then creates a directory (folder) structure on the disk that looks like this:

(i) Describe in detail one way that John could create the personal directory.

(1 mark)

(ii) According to the diagram above, what is the root directory?

(1 mark)

(iii) Explain why John should keep his files in directories (folders).

(1 mark)

© John creates a file called mango.doc and puts it in the November directory (folder).

Write the complete path for that file, according to the diagram above.

(1 mark)

(d) John wishes to make a copy of the file mango.doc. He wants to place this copy in the LastMonth directory (folder).

(i) Describe how he could make a copy of the mango.doc file and place it in the LastMonth directory.

(1 mark)

(ii) Is it possible for the copy of the file to also be called mango.doc? Explain why or why not.

(1 mark)

(e) John needs a spreadsheet. Seth, his friend, wants to give John a copy of a spreadsheet Seth has recently bought.

(i) Explain why this is software piracy.

(1 mark)

(ii) John does not wish to use pirated software. Give one reason why he might make this decision.

(1 mark)

(f) John knows that power fluctuations can cause damage to his computer. Here is a graph showing the normal power requirements for a computer.

The four graphs on the next page show four possible power fluctuations. These are:

  • spike
  • brown out
  • failure
  • surge

Correctly label each graph with one of the given types of power fluctuation (spike, brown out, failure, surge).

(1 mark)

 

(A) (B)

 

© (D)

 

(g) John buys a UPS to protect his computer from possible power supply fluctuations. Draw lines on the diagram below to show how the UPS, the 230 volt wall socket, and the computer should be connected together with interconnecting cables.

(1 mark)

 

(h) John also needs to guard against viruses.

(i) What is a virus?

(1 mark)

(ii) How can John guard against viruses damaging his computer system?

(1 mark)

(iii) Explain why formatting a disk will kill any virus on that disk.

(1 mark)

(iv) Give one advantage and one disadvantage of removing a virus by formatting an infected disk.

ADVANTAGE

DISADVANTAGE

(2 marks)

 

 

QUESTION THREE

John grows vegetables and fruits. He sells them in the local market. He uses a computer in his business. One day John writes a letter on his word processor. Here is a picture of his screen:

(a) The whole of the document is single spaced. The letterhead starts in line 1. The insertion point is in line 15, ten characters from the left margin.

(i) Describe fully what will happen if John now types the sentence Please reply soon.

(1 mark)

(ii) Describe the format of the first line of the letterhead.

(1 mark)

 

(b) John wants to use the expression Superior Tomato instead of the word tomato. There are seven times this occurs in the letter.

Describe the most efficient way to do this.

(1 mark)

© John writes another letter to buy some equipment. Here is a picture of his screen.

(i) In order to create the two columns containing the amounts of money, John decided to use the special command that automatically lines up currencies. What command did John use to create these two columns?

(1 mark)

(ii) John wishes to move the whole of the line

Bush Knife 5 $ 6.45 $ 32.25

so that it is the first line in the list. Explain how he can do this without using the delete function.

(1 mark)

(d) John realises that he should have a quick way to create his letterhead. The letterhead is shown in the diagram.

 

He decides to create a macro that will generate this letterhead.

(i) What is a macro?

(1 mark)

(ii) John can create the macro in nine steps. List any four of these steps.

1.

2.

3.

4.

(1 mark)

(e) John wants to print the letter he wrote to order equipment. He opens the file and chooses print from the file menu. The following requester appears.

(i) What printer does John have?

(1 mark)

(ii) If John clicks on the OK button explain why the document will not arrive at the printer.

(1 mark)

(f) After saving his letters in the November directory (folder) John exits the word processor.

He realises the letters should be in the October directory (folder). Describe how he can move them to the October directory (folder) without using the word processor. His directory (folder) structure is shown in the diagram.

(1 mark)

(g) John makes a copy of this floppy disk to create back ups of his files.

(i) Explain why he did this.

(1 mark)

(ii) At the start of the copy process an error message appears. It says that files cannot be copied to the floppy disk. Describe one thing that could have caused this message to occur.

(1 mark)

(h) John formats a different floppy disk. He also copies the system files to the disk at the same time.

(i) What does formatting do to a disk?

(1 mark)

(ii) What do the system files allow the floppy disk to do?

(1 mark)

(i) While reading about word processing in a computer magazine John comes across the words wysiwyg and thesaurus. Explain what these two words have to do with word processing.

wysiwyg

thesaurus

(2 marks)

 

 

 

 

 

QUESTION FOUR

John grows vegetables and fruits. He sells them in the local market. He uses a computer in his business. He uses a spreadsheet to calculate the money he earns.

(a) John sells tomatoes at $0.50 per kilogram and breadfruit at $0.20 per kilogram. One week he sells 120 kg of tomatoes and 48 kg of breadfruit. The grid below shows a blank spreadsheet. On this spreadsheet write in the following entries for his week�s sales:

(i) The labels for a suitable spreadsheet. (1 mark)

(ii) The data for the week�s sales. (1 mark)

(iii) The calculations or formulas used to work out how much money each vegetable made. Write down the calculation or formula as John would enter it into a spreadsheet. (1 mark)

(iv) The calculation or formula used to work out the total amount of money received. (1 mark)

 

A

B

C

D

1

2

3

4

 

 

  1. Over a period of 6 weeks John keeps a spreadsheet of his weekly earnings. It is called Earnings.wks and is shown in the diagram alongside.
  2. (i) John uses this spreadsheet to analyse his income. Write down the answer that the spreadsheet gives when John enters the following functions into cells B9 to B12.

     

    = SUM(B2:B7)

    = COUNT(B2:B7)

    = MAX(B2:B7)

    = SUM(B2:B7)/6

    (2 marks)

     

    (ii) What format has been applied to row 1 of Earnings.wks?

    (1 mark)

    (iii) Describe fully the format of the numbers in column B of Earnings.wks.

    (2 marks)

  3. John knows he could earn more if he could buy a truck. He must borrow $8 400 capital to buy the truck. He must pay 10% interest on the capital each year. He has worked out that he can pay $100 a month in loan repayments. John makes a spreadsheet to calculate his payments. It looks like this.

 

A

B

C

D

E

1

 

JOHN’S TRUCK

 

 

Interest rate =

0.10

 

2

MONTH

CAPITAL OWING

INTEREST

PAID THIS

MONTH

MONTHLY PAYMENT

CAPITAL REPAID THIS MONTH

3

1

$8 400

= B3 * $E$112

$100

= D3 � C3

4

2

= B3 � E3

5

3

       

(i) Cell C3 has the calculation B3 * $E$1 / 12. What numbers will the spreadsheet use for B3 and $E$1 ?

B3 $E$1

(1 mark)

(ii) Cell C3 answers the question “Can John afford to borrow $8 400 at 10%?”. Calculate the amount that appears in C3.

(1 mark)

(iii) John copies and pastes cell C3 to cell C4. Write the calculation that actually appears in cell C4.

(1 mark)

(iv) Cells D3 and E3 are filled down to cells D4 and E4. What actually is inserted in D4 and E4?

D4 E4

(2 marks)

 

(v) John can use this spreadsheet to find how many months it will take to pay off all the $8 400 capital. Describe how he can do this.

(1 mark)

(vi) John knows that interest rates could change to 12.5%. He can perform a what if on his spreadsheet to see how this would affect him. Describe how he would do this what if.

(1 mark)

 

 

 

QUESTION FIVE

John grows vegetables and fruits. He sells them in the local market. He keeps a database of the crops he has in his fields. The entries in his database are shown here.

TYPE

CROP

DATE

PLANTED

NUMBER OF PLANTS

LOCATION

METHOD OF

PLANTING

Root crop

Kumala

06.05.2000

50

Plot B

Cuttings

Vegetable

Corn

12.07.2000

400

Plot G

Seeds

Fruit

Melon

30.05.2000

250

Plot J

Seeds

Fruit

Banana

20.10.2000

40

Plot A

Cuttings

Vegetable

Cabbage

18.08.2000

170

Plot F

Seeds

(a) (i) How many records are in this database?

(1 mark)

(ii) Draw a rectangle around one field that is defined as numeric. (1 mark)

(iii) What minimum size must the database field called Crop be ? Use the information in the given database.

(1 mark)

(iv) Which crop was the most recently planted?

(1 mark)

  1. John needs to know what is growing in each part of his garden. Here is a diagram showing a report that John has printed on paper from his database.

 

 

(i) List the 3 steps John went through to get this report.

1.

2.

3.

(3 marks)

(ii) Why does this report contain only two fields?

(1 mark)

© John could have kept the same information about his crops on a spreadsheet.

Describe one advantage of using a database instead of using a spreadsheet.

(1 mark)

(d) John does a descending sort of his database by the Type field, and then does a secondary ascending sort (nested sort) by the Crop field.

Write down the order in which the fields type and crop are now listed in his database.

 

TYPE

CROP

(2 marks)

(e) John is not quite sure of the difference between a logical AND query, and a logical OR query. So he experiments by applying the following query first:

TYPE = “vegetable” AND NUMBER OF PLANTS < 200

(i) Write down the Crop names that are selected in this query.

 

CROP

(1 mark)

John chooses show all records. Next he applies the following query:

TYPE = “vegetable” OR NUMBER OF PLANTS < 200

 

(ii) Write down the Crop names that are selected in this query.

 

CROP

(1 mark)

(f) John knows that for a database to be useful the data must have integrity.

(i) What does data integrity mean?

(1 mark)

(ii) Describe one thing John can do to ensure his data has integrity.

(1 mark)

(g) Name one database program that John could use.

(1 mark)

 

 

 

 

 

 

         

ANSWER SHEET

MULTIPLE CHOICE

Remember you are to write the letter

of the correct answer only. Marker Use Only

 

 

 

Question No.

 

Mark

 

1

 

 

16

2

 

 

16

3

 

 

16

4

 

 

16

5

 

 

16

M/C

 

 

20

TOTAL

 

 

100