1999 Model Answers

 

 

 

 

         

 

 

 

 

COMPUTER STUDIES

 

 

1999

 

 

QUESTION AND ANSWER BOOKLET

MODEL ANSWERS

ANSWERS ARE GIVEN IN PLAIN TYPE.

COMMENTS AND GUIDELINES ARE GIVEN IN ITALICS

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. Computers contain a microprocessor. A microprocessor is

A. a set of instructions in Machine Code.

B. a part of the Basic Input Output System (BIOS).

C. a large scale integrated circuit made from silicon.

D. a video display system developed before computer technology.

 

2. A mouse belongs to which category ?

A. Software

B. Hardware

C. Firmware

D. Shareware

 

3. ROM is used for storing

A. overflow from RAM.

B. temporary information only.

C. output from the Central Processing Unit.

D. instructions for the start up sequence of a computer.

 

4. A Hard Disk stores information as a sequence of

A. electrical pulses.

B. magnetic dipoles.

C. light and dark optical barcodes.

D. up and down steps in the disk surface.

 

5. A back-up should be created for all important files. This can be done by

A. printing the files.

B. copying the files into RAM.

C. moving the files to a new directory (folder).

D. copying the files onto a floppy disk or other external storage device.

6. A menu is a device that

A. issues commands to a computer.

B. receives output from a computer.

C. processes long lists of data with a computer.

D. never sends information to the operating system of a computer.

 

7. You have a file called test1 on a floppy disk. You use the operating system to copy it to the directory (folder) called form6 on the hard drive. When you finish you will have

A. only one file called test1.

B. two separate files both called test1.

C. two separate directories both called form6.

D. an error message because the operating system cannot do this.

 

8. Directories (folders) let a computer operator

A. open a file directly.

B. store files in a logical and ordered way.

C. create new files whenever she wants to.

D. save all new files in the root of a floppy disk.

 

9. Which structure shows the document trees.doc saved in the forest directory (folder) on the a: drive?

A. a:\forest\trees.doc

B. trees.doc\forest\a:

C. a:\trees.doc\forest

D. trees.doc:forest:a:

 

10. Software companies (like Microsoft) are the only ones permitted to copy and distribute their software. This is because they own the

A. copyright.

B. distribution channels.

C. floppy disk on which the software is saved.

D. computer on which the software was created.

 

11. While using a word processor you highlight some text and choose cut from the edit menu. What happens ?

A. Nothing at all.

B. The highlighted text disappears from the computer altogether.

C. The highlighted text is removed from the screen and placed on the clipboard.

D. The highlighted text remains on the screen and is also placed on the clipboard.

12. Which tab is needed to correctly align numbers in a column?

A. Left

B. Right

C. Decimal

D. Justified

 

QUESTIONS 13 TO 16

The actual entries in the cells of a spreadsheet are shown in the diagram.

 

A

B

C

1

Name

Amount

Tax

2

Moala

$10.00

=B2*0.1

3

Seth

$54.00

=B3*0.1

4

Jones

$35.20

=B4*0.1

5

 

13. What is the entry in Cell B2 known as?

A. Data

B. A label

C. A formula

D. A calculation

 

14. If the total tax is to be calculated in cell C5 which of the following entries will do this correctly?

A. = A4+B4+C4

B. = SUM(C2:C4)

C. = SUM(B2:B4)

D. =C1+C2+C3+C4

 

15. Cell C3 is copied and pasted to cell B5. What is the actual entry that is written to cell B5?

A. =B3*0.1

B. =B3*C3

C. =A5*B5

D. =A5*0.1

16. In this spreadsheet which cell contains an absolute reference to another cell?

A. Cell A2

B. Cell B3

C. Cell C4

D. No cell

 

QUESTIONS 17 TO 20

A list of equipment used in a school includes the following three items. These are shown entered into a database.

ITEM

SIZE

LOCATION

QUANTITY

Desk

2 seater

Room 5

15

Chair

1 seater

Library

30

Chalk

1 box of 100 sticks

Room 1

500

 

17. What are the columns and rows called in a database?

A. Fields and Records

B. Records and Fields

C. Fields and Strings

D. Strings and Fields

 

18. The ITEM column is sorted in a descending alphabetical order. In what order will the items now be listed?

A. Desk, Chair, Chalk

B. Chalk, Chair, Desk

C. Desk, Chalk, Chair

D. Chair, Chalk, Desk

 

19. Why is a database used in this situation instead of a spreadsheet?

A. Because the data is easier to display in a database.

B. Because calculating with the data is the greatest priority.

C. Because processing non-numeric data is the greatest priority.

D. Because it requires less time to enter the information into a database.

 

20. What type of data is entered into the QUANTITY column in the database?

A. Text

B. Numeric

C. Calculation

D. Alphanumeric

SECTION B: SHORT ANSWERS

(80 marks)

QUESTION ONE

(a) A school in the tropical South Pacific decides it must buy a computer. This computer will be used to help run the school. Write a list of four hardware specifications that the computer should have.

 

Any four of : HDD (any size); 1.44MB FDD; SVGA monitor; video RAM; Video card; RAM (any size); CD-ROM drive (any speed); printer; keyboard (any specification); modem (any sort)

Any other sensible hardware specification should receive credit. Students MUST have ANY two correct to get ONE mark, and any FOUR correct to get 2 marks. (Half marks must NOT be awarded) (2 marks)

(b) The school will keep a lot of its information on the computer.

(i) Which computer device is used for long term storage of information?

The Hard Disk or Hard Drive or HDD; or Floppy Disk or FDD or Floppy Drive; or magnetic tape or magnetic drive; or R/W CD ROM (1 mark)

(ii) Describe one physical way that the stored information of question 1 (b) (i) can be damaged.

This answer must link with the previous one.Magnetic media can be damaged by: Putting magnets near it OR Placing near a source of Heat eg the sun OR by strong vibration causing the heads to scratch the disk surface. CD ROMS can be damaged by scratching; OR by sweaty fingerprints (longterm).

Viruses and delete commands are NOT acceptable answers (1 mark)

(iii) Information cannot be stored long term in RAM because RAM is volatile. What does volatile mean?

The information in it disappears when the power is turned off

(1 mark)

 

© The school buys the computer. When the Principal unpacks it the back of the machine looks like this.

Name the component whose lead should be connected to the socket labelled:

(i) serial Mouse

(1 mark)

(ii) parallel printer

(1 mark)

(iii) 230vAC Power, OR mains, OR

Electricity supply (etc)

(1 mark)

 

 

 

 

 

 

 

 

 

 

 

(d) The Principal decides to put the computer in the staff room so staff can use it.

(i) Explain why this room should be air conditioned.

To stop mildew (fungus, mold) growing on the disks OR to stop floppy disks from

being damaged by moisture

(1 mark)

(ii) Give two reasons why the Principal should also install a UPS.

1. To prevent damage to computer by voltage spikes or power surges or lightning

strikes

(1 mark)

2. To prevent loss of information due to main power supply failure

(1 mark)

(e) The school�s computer needs to store files relating to different aspects of the school. These include: the canteen; Principal�s letters; school accounts; and subject departments. The Principal has letters coming in and going out. Subject departments are English, Mathematics, Science, and Geography.

(i) Draw a suitable directory (folder) structure for this school. Include the root directory (folder) in your diagram. Draw your diagram in the space below.

(3 marks)

c:</P>

canteen

principal in

out

accounts

subjects English

Mathematics

Science

Geography

 

The above diagram may vary, but it must be SENSIBLY STRUCTURED to cover all directories and subdirectories shown. Long directory names are acceptable. The root directory can be called any name, it does NOT have to be shown as c:</P>

Marks awarded for:

1 for showing root directory (folder) in correct position at top of tree

1 for showing 4 main directories

1 for showing 2 subdirectories in “principal” and 4 subdirectories in “subjects”

(ii) The Mathematics Department saves a file test.doc on the computer. Write the complete path, according to your diagram in question 1 (e) (i), for the best place to store this file.

This MUST follow the structure of the student�s tree diagram. eg in the diagram above the answer is c:\subjects\mathematics\test.doc

(1 mark)

(iii) The file test.doc is still open. Describe how you would copy this file to a floppy disk without closing it.

Use the SAVE AS command from the FILE menu.

NO OTHER answer is acceptable.

(1 mark)

QUESTION TWO

A school in the South Pacific purchases a new computer. The computer is delivered to the school with its operating system already installed.

(a) (i) What is an operating system ?

Software which controls the way the computer operates.

1 mark for concept of software; 1 mark for concept of control

(2 marks)

(ii) Name one operating system.

Any known OS. eg Windows, MSDOS, Linux, Unix, MacOS, OS/2, warp

(1 mark)

(iii) Describe how the Principal would use the operating system to copy a file from the hard drive onto a floppy disk.

Either Drag and Drop icons in a GUI OS; OR issue a copy command with paths

from a command line interface OS.

(1 mark)

(b) The internal clock on the computer was not set to the correct local time when it was delivered. Describe how the clock could be adjusted to the correct time.

Either open the calendar utility on the GUI OS and adjust with the mouse

OR use the DATE and TIME commands from a Command Line Interface OS.

(1 mark)

© The following day the Principal turns on the computer. An error message appears that says the computer is trying to boot from a Non System Disk. The computer stops its boot sequence and waits.

(i) What is causing the problem?

A floppy disk which does NOT contain the system files is in the floppy drive

(1 mark)

(ii) If the fault is not corrected, what would happen if the computer was re-started using a warm reboot?

The same error message would re-appear

(1 mark)

(iii) How can the Principal correct the error that is causing the error message?

Take out the floppy disk from the floppy drive and reboot the computer.

(1 mark)

(d) The Principal gets the computer working properly and then uses a CD-ROM encyclopedia to do some research about computer systems.

(i) What does CD-ROM stand for?

compact disk read only memory

(1 mark)

(ii) The Principal finds a diagram in the encyclopedia about computer systems. This diagram is shown below, but it is not complete. Read the diagram below and fill in each of the spaces labeled A to F with the name of one item that fulfills that category (3 marks)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(iii) The arrow on the diagram shows how information flows between two parts of the computer. Draw in four more arrows on the diagram to show how information flows between the bus and the other parts of the computer. Arrows as shown. Must be in directions shown. 1 mark for two arrows correct. 2 marks for four arrows correct (2 marks)

(e) The Principal wishes to make a bootable disk for the computer. Describe how this can be done with an unformatted 3.5" floppy disk.

Format the floppy disk using either the GUI operating system, or the command line interface (eg MSDOS) 1 mark

Copy the system files to the disk. 1 mark

 

 

 

 

 

QUESTION THREE

A school in the South Pacific buys a new computer. The school then starts to use this new machine.

(a) One day a staff member tries to save a file onto his own floppy disk. Suddenly this message appears on the screen:

Warning: the boot block of the floppy disk in the floppy drive is infected with the appolyon virus!!

(i) What type of application produced this message?

A virus checker

(1 mark)

(ii) Describe one thing the staff member can do to remove the appolyon virus.

Either: remove it with the virus checker. OR re-format the disk

(1 mark)

(iii) Describe one advantage of the removal method you described in question (3) (a) (ii).

Matching the above answer to (ii): Either: keeps the information contained on the disk; OR destroys ALL possible viruses off the disk.

(1 mark)

(b) The school makes a policy that it will not allow any pirated software to be used on its computer.

(i) Explain what pirated software means.

Copies of programs and/or files made without the owner�s permission, OR copies

made without paying for them

(1 mark)

(ii) Give two reasons why a school might make such a policy.

Any two of the following reasons are acceptable (there may be others not listed here that are considered good reasons):

To abide by copyright laws; To avoid prosecution; To act as role models for students so that no student will be allowed to use pirated software; To ensure software is virus free when installed; To get access to advice and support from software suppliers� helplines;

(2 marks)

© When buying the computer the school was supplied with a printer and associated printer driver on disk. They looked like this.

(i) Circle the picture of the item that contains only software.

(1 mark)

(ii) Explain why the software in question 3 © (i) is system software.

It is software that controls the way in which the computer operates.

OR Software that the OS uses to operate a piece of hardware

(1 mark)

(d) The Principal creates a message using a wordprocessor. Here is the message. It is shown actual size.

Reminder to

all staff members

Remember to meet in the libbrary today

after school.

 

 

(i) Describe one difference in thefonts used in the message.

Either Different font faces ( OR type faces) OR Different font sizes

Any answer that expresses one of these concepts gets the mark. (1 mark)

(ii) The first paragraph is double spaced. What line spacing did the Principal use in the second paragraph?

Single No other answer is acceptable

(1 mark)

(iii) When the Principal runs the spelling checker on her document what message appears?

The word library (libbrary) is misspelt.

(1 mark)

(iv) Describe the paragraph formatting that has been applied to the first paragraph.

Centred and underlined.

It is also double space, but this is NOT an acceptable answer because this is

already told to the candidate in a previous part of this question.

(2 marks)

 

 

 

(v) The Principal experiments with the format of the message. She adjusts the look of the words "Reminder to". In the table below draw a line from the text to the correct format description. (The first one is done for you.)

(1 mark)

 

TEXT FORMAT

plain

clean and healthy bold

clean and healthy underline

clean and healthy italic

clean and healthy superscript

clean and healthy strikethrough

subscript

The diagram must be FULLY correct to gain the mark.

(vi) How can you tell that centre formatting has been applied to the diagram in the message?

The lines of text are the same distance from both sides of the page.

(1 mark)

(vii) Explain why the notice should be saved before attempting to print it.

If an error occurs during printing then the file is recoverable, and the printing task can be repeated. OR It is always good practice to save work regularly.

(1 mark)

 

 

 

 

 

 

 

 

 

QUESTION FOUR

A school in the South Pacific buys a new computer.

(a) The school canteen decides to keep its business records on a spreadsheet on the computer. The canteen sells bags of peanuts for 20 cents each. These bags of peanuts cost the canteen 7 cents each. On the chart below show the entries in a spreadsheet that could be used to calculate the profit for each bag sold. Make sure you label the entries correctly.

1 mark for having sensible labels; 1 mark for 3 correct data entries; 1 mark for correct formula. The spreadsheet can have the labels in column A, and the data and formula in Column B and still gain full marks.

(3 marks)

A

B

C

D

1

ITEM

COST PRICE

SELLING PRICE

PROFIT

2

Peanuts

$0.07

$0.20

= C2 - B2

3

4

(b) The canteen keeps a record of the number of bags of peanuts sold each day for a week. Here is the information as it appears on the screen of the computer in a spreadsheet application:

A

B

C

D

1

WEEK ONE

ITEMS SOLD

2

DAY

PEANUTS

3

Mon

25

4

Tue

40

5

Wed

38

6

Thu

17

7

Fri

24

8

TOTAL

144

9

AVERAGE

(i) Describe the function that is entered into cell B8.

The SUM function should be used; OR use = sum(B3:B7); OR use SUM(B3:B7)

The formula B3+B4+B5+B6+B7 is NOT acceptable.

(1 mark)

(ii) Write down a suitable entry that will give the required answer in cell B9.

Average(B3:B7) or equivalent; OR (B3+B4+B5+B6+B7)/count(B3:B6);

OR B3+B4+B5+B6+B7)/5 OR B8/5

(2 marks)

© The canteen also keeps a record of the number of ice blocks sold. Here is the information:

Mon 15; Tue 12; Wed 21; Thu 19; Fri 1121.

(i) Which number is probably incorrectly recorded?

1121

(1 mark)

(ii) Explain why you think this number is wrong.

It is extremely large compared to the other numbers.

The concept of checking data for accuracy is being tested here. Other answers will give this concept, and hence gain the mark.

(1 mark)

(d) The canteen soon expands its spreadsheet to include other sales. Here is the expanded sheet:

 

A

B

C

D

E

1

WEEK ONE

ITEMS SOLD

     

2

DAY

PEANUTS

PIES

BONGOS

CHIPS

3

Mon

25

8

15

29

4

Tue

40

4

13

35

5

Wed

38

10

14

26

6

Thu

17

13

12

43

7

Fri

24

9

16

39

8

TOTAL

144

     

9

AVERAGE

       

10

         

(i) Explain why the numbers shown in the spreadsheet are formatted with zero decimal places.

All items sold are in whole numbers. Ie No fractions are involved in any item.

(1 mark)

(ii) The formula

=max($B$3:$B$7)

is entered into cell B10. It is then spread across to cell E10. What value actually appears in cell E10?

40

(1 mark)

(iii) Write down the correct formula that should have been placed in cell B10 in the first instance.

MAX(B3:B7) OR MAX(B$3:B$7)

(1 mark)

(iv) Explain the difference between absolute cell references and relative cell references.

Absolute references ALWAYS refer to the same cell no matter where a cell containing a reference is copied and pasted on the spreadsheet. However Relative references always refer to a cell the same distance away on the spreadsheet, and so the reference changes when the cell is cut and pasted.

(1 mark)

(e) The canteen calculates its profit for the week by entering some calculations at the bottom of the spreadsheet. These are shown in the diagram below.

 

A

B

C

D

E

1

WEEK ONE

ITEMS SOLD

     

2

DAY

PEANUTS

ROLLS

BONGOS

CHIPS

3

Mon

25

8

15

29

4

Tue

40

4

13

35

5

Wed

38

10

14

26

6

Thu

17

13

12

43

7

Fri

24

9

16

39

8

TOTAL

144

     

9

AVERAGE

       

10

         

11

Profit per sale

$0.13

$0.54

$0.35

$1.05

12

Weekly Profit

= B8*B11

     

13

         

The formula

= B8 * B11

is entered into cell B12, as shown. This is then spread to cell E12.

(i) On the spreadsheet on page 18 draw one rectangular box around all the cells that should be formatted as currency. Shown above. (1 mark)

 

 

(ii) What format has been applied to the labels in the spreadsheet?

Bold and Centred Both descriptions are necessary to gain the mark

(1 mark)

(iii) Suppose the profit on each sale of peanuts can be increased by 2 cents if a different supplier is used. Describe how the canteen could run a what-if analysis on their spreadsheet to find the new weekly profit.

Enter the value 0.15 into cell B11

(1 mark)

(iv) Describe how the canteen could use the spreadsheet to create a pie graph showing how each product contributes to the weekly profit.

EITHER: Highlight the cells B12 to B15 and use the graph maker of the spreadsheet.

OR: specify the menus and submenus that are used by the spreadsheet in order to make a pie graph

(1 mark)

 

 

QUESTION FIVE

A school in the South Pacific buys a new computer to help run the school.

The Head of Science puts information about the Science Department�s equipment into a database on the computer.

The table on this page is a small part of the information in the database of Science Department equipment..

Room

Subject

Item

Quantity

Date

purchased

9

Physics

Tickertimer

5

1 Feb 85

10

Physics

Spring

10

12 May 94

10

Chemistry

Test-tube

148

2 Mar 98

9

Biology

Scalpel

5

6 Jul 84

8

Chemistry

Boiling Flask

24

15 Nov 89

8

Biology

Aquarium

3

30 Apr 90

10

Biology

Hand Lens

16

3 May 98

9

Chemistry

Bunsen Burners

7

12 Jun 79

8

Physics

Trolley

2

9 Oct 96

 

(a) (i) Describe one advantage in using a database for such a task.

Any sensible answer is awarded the mark. Examples of acceptable answers are: It is easy to sort information; It is easy to select only certain parts of the information; It is possible to get reports of subsets of data; IT is a way of handling large amounts of data and making sense of it. (1 mark)

(ii) On the table above draw a rectangle around any one complete record.

Any ONE record (row). It must be completely drawn from one side of the table to the other (1 mark)

(iii) Based on the table above what size should the Subject field be?

9 (Nine)

(1 mark)

(iv) What type of field is the Quantity field?

Numeric

(1 mark)

(v) If the Date Purchased field is sorted in ascending order which Item appears at the top of the Item field?

Bunsen Burners

(1 mark)

(b) (i) The Head of Science wants a hard copy of all Physics equipment listed in alphabetical order. Describe the three steps needed to achieve this.

1. Select Physics from the "Department" field

2. Sort the "Item" field in ascending order

3. Print a report

The SELECT and SORT processes can occur at any stage. The Print process must be the last one.

(3 marks)

(ii) Use only the information given in the table on page20. Write down one possible way the report of question 4 (b) (i) could look.

Room

Subject

Item

Quantity

Date

purchased

10

Physics

Spring

10

12 May 94

9

Physics

Tickertimer

5

1 Feb 85

8

Physics

Trolley

2

9 Oct 96

The only field actually required is the ITEM field. Any answer that contains the 3 ITEMS (but only these 3 ITEMS) in correct order is awarded the mark. The order of the fields is unimportant.

(1 mark)

© The Head of Science wants to find all the Chemistry equipment that is stored in Room 9. To do this she applies these conditions to the database:

Subject = "Chemistry" AND Room = "9"

(i) Explain what the logical AND statement does in this situation.

It selects information that fulfills BOTH criteria. The data selected will include both "Chemistry" as the "Subject" and "9" as the "Room".

(1 mark)

(ii) How many records from the table shown on the previous page are selected by this query?

ONE (1)

(1 mark)

(d) The Head of Science wants to know if any equipment is older than 15 years. Describe in general how this could be done using the database she made.

Perform a query that selects records in the "Date Purchased" field with a date greater than 15 years ago.OR The actual date must be less than 1984 Any answer that expresses the concepts of comparison and selection by the correct criterion gains the mark.

(1 mark)

(e) The Head of Science needs to find all the equipment purchased in 1998. She gets an appropriate report from the database. This is what the report looks like:

 

EQUIPMENT PURCHASED IN 1998

ROOM ITEM QUANTITY

10 Test tubes 100

10 Hand Lens 15

 

(i) Explain why the report has only three fields in it.

These fields are the only ones required to get the answer to the original question (which was "What equipment was purchased in 1998).

(1 mark)

(f) Databases can be useful in many real-life situations.

.(i) Name one database program.

Any correct answer gets the mark. Eg Access, MSWorks, foxpro, paradox etc

(1 mark)

(ii) Give one example where a database would be a useful tool to employ.

Any situation which involves the sorting and /or selection of data from a large amount of information. Eg constructing a telephone directory; membership lists; school rolls;

(1 mark)

(iii) Explain why it is important to keep data in a database up to date.

Any answer that expresses the idea that data needs to be current for it to have any value, gains the mark

(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