2000 Model Answers




















Time Allowed: 2 hours




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:




Suggested Time


There are 20 Multiple Choice questions.


24 minutes


There are 5 Short Answer questions.

All are compulsory.


96 minutes


(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 the

A. ESC key.

B. ENTER key.

C. arrow keys and then the TAB key.

D. 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.



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



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







Time Worked

Pay Rate





$ 1.50

$ 3.75




$ 1.00

$ 2.00




$ 3.25

$ 4.55


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


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� LastName field now in the database is 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 field now in the database is arranged in ascending alphabetical order. Which statement is true?

A. The order of the field names changes.

B. The contents of each individual record remains unaltered.

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

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



(80 marks)


David wants to buy a computer. He is offered two computers.

Computer 1 8 MB of RAM 127 MB hard drive.

Computer 2 16 MB of RAM 1 GB hard drive.


(i) What does RAM stand for?

Random Access Memory

(1 mark)

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

To store data, and application and operating system software so that the computer can process the data.

(1 mark)

(iii) Explain the relationship between MB and GB.

One gigabyte equals one thousand megabytes; 1G = 1024 M

(1 mark)

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

To permanently store files, applications, and operating system software, (The concept of permanent storage is the important point here, and gets the mark.)

(1 mark)

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

(i) What does OS stand for?

Operating System

(1 mark)

(ii) What is the purpose of the OS?

To act as a controller for the operation of the computer. It controls all the processes that go on in the computer. (The concept of control is the important point, and must be in the answer in order to gain the mark.) (1 mark)

(iii) Name one OS.

Any operating system. (eg Windows, MSDOS, Linux, FreeBSD, MacOS etc)

(1 mark)

© David tests the two computers. He finds that the word processor in Computer 1 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 was running slowly.

Not enough RAM to run the application properly. (Answers that refer to the hard drive capacity do NOT get the mark unless the correct answer is also given).

(1 mark)

(d) The picture shos four plugs that need to be wired to various computer components. What computer component do the cables belong to?

(i) Keyboard__ (ii) Video, monitor, (iii) Mouse, or any (iv) Power, or CPU,

____________ VDU, screen, etc serial device or monitor

One mark is awarded to every 2 correct answers (NO half marks allowed) (2 marks)

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

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

A. CDROM drive (possibly CD writer, or CD rewriter)

B. Floppy disk drive

(2 marks)

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

It has no user parts that are removable, or serviceable. There is never a need to take out a disk, or renew the disk inside it.

(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)


One mark for every two correctly placed arrows. NO half marks awarded!!




Pita wants to format a 1.44MB floppy disk.

(a) Describe one way that he could format the disk. (Assume the computer is already turned on.)

Any correct way that relates appropriately to the OS referred to,

(1 mark)

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

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

Any correct way that relates appropriately to the OS referred to,

(1 mark)

(ii) What is the root directory in the directory (folder) structure given?

3 � Floppy or A: (Either is acceptable)

(1 mark)

(iii) Explain why files should be kept in directories (folders).

So that files are kept in an ordered or logical manner.

(1 mark)

© Pita 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.

3 � Floppy (A:)\letters\November\mango.doc or A:\letters\November\mango.doc

(1 mark)

(d) Pita wishes to make a copy of the file mango.doc and then place this copy in the LastMonth directory (folder).

(i) Describe how Pita could carry out the above task.

Use the save as function, or use the operating system (eg copy and paste through windows)

(1 mark)

(ii) Can Pita name the copy of the file as mango.doc? Explain why or why not.

YES. The paths are different.

(1 mark)

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

(i) Explain why this is software piracy.

It is the unauthorised copying of copyrighted software.

(1 mark)

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

Any valid reason. eg it is illegal, it is unethical, it is not right, he wishes to avoid the possibility of catching a virus, he wishes to lead by example etc

(1 mark)

(f) Power fluctuations can cause damage to computers. The graph shows the normal power requirements for a computer.


The graphs below show the four possible power fluctuations (spike, brown out, failure, surge).

Label each graph with the correct type of power fluctuation.



(A) Surge (B) Brown out


© Spike (D) Failure

(1 mark)

ALL four must be correct to gain the mark. NO partial marks to be awarded!!!

(g) UPS protects computers 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.

The important thing is that the UPS is between the computer and wall socket. (1 mark)

(h) Computers need to be guarded against viruses.

(i) What is a virus?

A self-replicating computer program that can interfere with a computer’s hardware or operating system or applications. (Viruses are designed to replicate and to elude detection.)

(1 mark)

(ii) How can viruses be prevented from damaging a computer system?

By using virus protection software. (If a specific virus scanner is named, then the mark is gained.) or By NOT putting disks of unknown origin in his machine, or by not opening unknown files from the internet including email attachments.

(1 mark)

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

Formatting destroys ALL files on a disk, including the virus file.

(1 mark)

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

ADVANTAGE It is guaranteed to remove the virus.

DISADVANTAGE It destroys all files on the disk, including any that may be useful to the owner of the disk.

(2 marks)




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 in detail where the cursor is located in the text.

Two spaces to the right of the words “Dear Sir”

(1 mark)

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

Bold and centred. (Other formatting like captilised may be mentioned, but they don�t get the mark.) (Both formats must be described to gain the mark)

(1 mark)

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

Describe the most efficient way to do this.

Use the replace function. Search for “tomato” and replace with “Superior Tomato”.

(1 mark)

© John writes another letter. Here is a picture of his screen.

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

He used the decimal tab to create the columns

(1 mark)

(ii) John wishes to move the last line on the list (shown below) so that it is the first line on the list.

Bush Knife 5 $ 6.45 $ 32.25

Explain how he can do this without using the delete function.

Highlight the line. Go to edit/cut. Click at the start of the first line. Go to edit/paste. (He may have to insert a line break also, depending on exactly how the cut&paste was done) (all steps must be mentioned, or at least implied, in order to gain the mark)

(1 mark)


(d) John realises that he should have a quick way to create his letterhead. The diagram shows the letterhead he wants for his business.


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

(i) What is a macro?

A set of keystrokes and instructions recorded and saved (under a short key code, or menu item, or radio button icon). When the key code is typed,(or menu called, or button pushed) the program carries out the instructions of the macro.

(1 mark)

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

1. Any four of: Open a new file; centre text; choose bold; write first line; push enter to create new line; choose italics; type the second line of text; insert the picture; add two blank lines; insert the date

2. (The order of creation is NOT asked for in this question.) (All four steps must be correct in order to gain the mark.)



(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?

An OKI OKIPAGE 4w Plus2 (just OKIPAGE gains the mark)

(1 mark)

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

Because the print requester is set to print TO A FILE.

(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.

Any MOVE operation that is appropriate to the operating system gains the mark. (NB this is a move not a copy function; but an answer that copies and then deletes the original gains the mark)

(1 mark)

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

(i) Explain why he did this.

To protect the information on his files from being destroyed if a natural disaster or hardware failure occurs.

(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.

A write-protected disk, or a full disk being used to copy to, (“files that are too big to fit on the disk” is to be awarded the mark, in spite of being illogical because he starts with a floppy disk.)

(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?

Prepares the disk so that the operating system can save files on to it.

(1 mark)

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

Act as a boot disk.

(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 what you see is what you get. This describes the view of the document � what is visible on the screen is the way in which the document prints on paper. (An explanation is required to get the mark, Just the expansion of the acronym wysiwyg does NOT get the mark.)

eg The minimum response should be something like: What you see on the screen is what you get on the printed page.

thesaurus A program that suggests alternative words with similar meanings (synonyms),

(2 marks)







John uses a spreadsheet to calculate the money he earns from his business.

  1. 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. Row 1 & col A (any variation acceptable) (1 mark)

(ii) The data for the week�s sales. Cells B2,B3,C2,C3 (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. D2,D3 (1 mark)

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

(1 mark)















= B2*C2





= B3*C3


= D2+D3

or = SUM(D2:D3)

(Other layouts are possible, but the logic must flow correctly through the spreadsheet.)

(b) 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.

(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) 600

= COUNT(B2:B7) 6

= MAX(B2:B7) 170

= SUM(B2:B7)/6 100

(2 marks)

Any two correct answers gain 1 mark. All four need to be correct to gain the 2 marks. NO HALF MARKS ARE TO BE AWARDED.


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

Bold and centred (both required to gain the mark)

(1 mark)

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

Currency (1 mark); zero decimal places OR right aligned (1 mark)


  1. John wants to 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.












Interest rate =













$8 400

= B3 * $E$112


= D3 � C3



= B3 � E3




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

B3 8 400 or $8 400 $E$1 0.10 or 0.1 or .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.

70 or $ 70 or 70.00 or $70.00

(1 mark)

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

B4 * $E$112

(1 mark)

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

D4 $100 or 100 (the $ sign is optional) E4 D4 � C4

(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.

Spread columns A to E down the spreadsheet until the amount of capital owing becomes zero. Column A will then tell John the month that this occurs.

(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.

Change cell E1 to 0.125

(1 mark)





John keeps a database of the crops he has in his fields. The entries in his database are shown here.









Root crop




Plot B






Plot G






Plot J






Plot A






Plot F


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

(1 mark)

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

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

7 (cabbage is the largest entry, with 7 letters)

(1 mark)

(iv) Which crop was the most recently planted? Banana

(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. Sort on field called Location

2. Select the fields called Location and Crop to go in the report

3. Print the report. OR Create the title (Steps 1&2 can be interchanged)

(3 marks)

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

John only needs these two fields to find out where his crops are planted.

(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.

Any advantage of using a database. eg the fields can be easily sorted, reports of part of the database can be obtained, etc.

(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.








Root Crop






One mark is to awarded to the Type field, one to the crop field. (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.




Cabbage is the only acceptable answer, no other entries must occur. (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.







(The order of the records is unimportant) (1 mark)

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

(i) What does data integrity mean?

The data is accurate, it is up to date, it is complete. (any answer which conveys the idea of accuracy is acceptable)

(1 mark)

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

Update the information regularly, or define the type of data that can be entered into each field, or remove (replace) out of date data.

(1 mark)

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

Any database will do. eg Access, paradox, foxpro, etc

(1 mark)










Remember you are to write the letter

of the correct answer only. Marker Use Only




Question No.