2001 Question Paper

 

 

 

 

 

         

 

 

 

 

COMPUTER STUDIES

 

 

2001

 

 

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. A mouse is mainly used as

A. a static device.

B. an input device.

C. an output device.

D. an independent device.

 

2. A monitor is mainly used as

A. a tactile device.

B. an input device.

C. a storage device.

D. an output device.

 

3. Which diagram best shows the way the user relates to the parts of a computer system?

 

 

4. Data cannot be stored permanently in RAM because

A. RAM size quickly gets too small.

B. RAM overheats when used for a long time.

C. data is damaged when left in RAM for a long time.

D. data is lost when the electric power goes off.

 

5. When you try to delete a file from a floppy disk you get an error message. What could cause this error?

A. The disk is full.

B. The file is too big.

C. The disk is write protected.

D. The file is of the wrong type.

 

6. Which of the following is an application?

A. A printer

B. A spreadsheet

C. An operating system

D. A computer instruction book

 

7. Summer weather in the tropics can cause damage to floppy disks. This is because the

A. disks are always warm.

B. light intensity is too high for the disk.

C. high humidity lets fungus grow on the disk surface.

D. summer temperature causes bending of the disk surface.


8. The file SmallLetter is in the sub-folder (sub-directory) Letters, which is in the folder (directory) correspondence. The disk is called MyDisk. What is the correct path to the file?

A. MyDisk:\correspondence\Letters\SmallLetter

B. correspondence\Letters\SmallLetter\MyDisk:

C. MyDisk:\Letters\correspondence\SmallLetter

D. MyDisk:\SmallLetter\Letters\correspondence

 

9. Copyright regulations apply

A. to all software.

B. only to software over 10 kB in size.

C. only to software over 10 MB in size.

D. only to programs made by publishing houses.

10. Corporate confidentiality is a phrase that means

A. having confidence in large corporations.

B. we can confidently tell others about a corporation’s sensitive information.

C. sensitive information owned by a corporation should not be told to others.

D. no one owns sensitive information in a corporation because it is confidential.

 

11. A student is using a word processor. She wishes to change a word to another word with a similar meaning. To do this she could use the

A. thesaurus.

B. spelling checker.

C. grammar checker.

D. document template.

 

12. Which of these devices is not a magnetic storage medium?

A. Tape

B. Hard disk

C. Floppy disk

D. Compact disk

 

QUESTIONS 13 TO 16

Use this spreadsheet to answer questions 13 to 16.


A

B

C

D

E

1

Fishing

Club Funds

2

NAME

SUBS

GIFTS

TOTAL

PERCENT

3

Olga

$12.00

$7.00

$19.00

28.4

4

Ben

$12.00

$2.00

$14.00

20.9

5

Josiah

$12.00

$0.00

$12.00

17.9

6

Ruth

$12.00

$10.00

$22.00

32.8

7

TOTALS

$48.00

$19.00

$67.00

100.0

 

13. What was entered in cell A1?

A. Nothing

B. Fishing

C. Fishing Club

D. Fishing Club Funds

 

14. Which formula is in cell D3?

A. = B3+C3

B. = B3+B4

C. = C3+C4

D. = E3*100

 

15. Josiah makes a gift of $5.00. If the spreadsheet is properly constructed which cell or cells must be altered to calculate the percent that each person has paid?

A. E5 only

B. C5 only

C. C5 and C6

D. C5, C6, E3, E4, E5, and E6

 

16. Cell E3 calculates the percent that Olga has paid. The arithmetic of the calculation is 19.00 x 100 / 67.00. What formula should be used in cell E3?

A. = D3*100/D7

B. = D3*10067.00

C. = D3*100/$D$7

D. = 19.00*100/$D$7

 

QUESTIONS 17 TO 20

The table view of a database called RugbyClub is shown in the diagram. Use this database to answer questions 17 to 20.

17. Which field or fields are defined as a number?

A. Height only

B. Weight only

C. Height and Weight

D. Height, Weight and Date of Birth

 

18. The query Position = Lock OR Fees Paid = no is applied to the database. Which names are selected by this query?

A. None

B. Alfred and John only

C. James and Tevita only

D. Alfred, John, James and Tevita only

 

19. A row of the database is called a

A. field.

B. form.

C. table.

D. record.

 

20. The database is sorted in descending order by Fees Paid then in ascending order by Date of Birth (a nested sort). Which name is now at the top of Name?

A. Jimmy

B. Tevita

C. James

D. Sunia

 

SECTION B: SHORT ANSWERS

(80 marks)

QUESTION ONE

Ana buys a second hand computer. The CPU has a 100 MHz processor with 32 MB RAM and a 520 MB HDD.

(a)

(i) What does CPU stand for?

(1 mark)

(ii) Explain what the CPU does.

(1 mark)

(iii) Describe the primary and secondary storage devices in Ana�s computer and state what size they are.

PRIMARY

SECONDARY

(1 mark)

(b) The hard disk in Ana�s computer has lots of files from the previous owner. Ana formats the hard disk.

(i) Give a reason why she formats the hard disk.

(1 mark)

(ii) What is a disadvantage of formatting the hard disk?

(1 mark)

© Ana wishes to install an operating system after formatting the hard disk.

(i) What is the purpose of an operating system?

(1 mark)

(ii) Name one operating system.

(1 mark)

(d) Ana�s friend owns two operating systems. They were published by a commercial software company. Her friend bought them with computers, which were later destroyed in a cyclone. She gives one of the operating systems to Ana to use.

(i) Is this software piracy? Explain why or why not.

(1 mark)

(ii) Who owns the copyright of the operating system that Ana now possesses?

(1 mark)

(e) Ana installs the operating system. When she boots her computer the message "keyboard error" appears on her screen, and the computer stops booting.

(i) What should she check first?

(1 mark)

(ii) What is the purpose of a keyboard on a computer?

(1 mark)

(f) Ana�s keyboard looks like the one in the picture below. Identify the five major areas in the list above the keyboard. Draw a line from the label and outline the area on the keyboard. (The first one has been done for you.) (2 marks)

Esc Tab Function Shift Numeric

Key Key Keys Key Keypad

(g) Ana needs some applications for her computer.

(i) What is an application?

(1 mark)

(ii) List four different applications Ana might need.

1.

2.

3.

4.

(2 marks)

 

 

 

 

 

 

 

 

 

 

QUESTION TWO

 

(a) Ben writes a story on a word-processor. He wants the story to be on A5 size paper in portrait orientation.

(i) Describe how to make the page size A5 in a word-processor.

(1 mark)

(ii) Sketch the outline of a page that is in portrait orientation. (1 mark)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(b) Ben tries different fonts for his story. Here are two examples:

This is written in Times New Roman, which is a Serif Font

This is written in Arial, which is a Sans Serif Font.

Describe one difference between a serif font and a sans serif font.

(1 mark)

 

© Here is a picture of Ben’s screen as he works on his story:

 

 

 

 

 

 


TITLE

PARAGRAPH 1

 

 

PARAGRAPH 2

 

 

 

 

 

 

 

 

 

(i) Describe the format of the TITLE.

(1 mark)

(ii) Describe the alignment of PARAGRAPH 1.

(1 mark)

(iii) Ben needs to swap PARAGRAPH 1 with PARAGRAPH 2. Describe how he does this without re-typing anything.

(1 mark)

(d) Ben�s word-processor prints the pages the same way that they appear on the screen. What is the computer term that describes this property?

(1 mark)

(e) While Ben writes his book he saves the file to disk. He calls the file MyBook. He puts it in the folder (directory) called Book on his computer. The folder (directory) structure on Ben�s computer looks like this:

Ben�sComputer:

projects work home other

book usp plans letters george mele josiah

 

(i) Write the full path to the file MyBook.

(1 mark)

(ii) Explain why Ben uses folders (directories) on his computer.

(1 mark)

(f) Ben should back up his file MyBook.

(i) Explain why he should make a back up copy.

(1 mark)

(ii) Give one advantage of backing up to a floppy disk rather than to a hard disk.

(1 mark)

 

(iii) Ben will call the back up file MyBookBackUp. Describe one way he could create the file MyBookBackUp on a floppy disk.

(1 mark)

(iv) Files on floppy disks can be damaged. Describe one way that the file MyBookBackUp could be damaged while the floppy disk is stored away from the computer.

(1 mark)

(v) Describe the best conditions in which to store floppy disks so as to prevent damage to the information on the disk.

(1 mark)

(g) Ben prints his file MyBook.

(i) During printing the computer gives an error message, and stops printing. Describe one thing that could have caused the error.

(1 mark)

(ii) The software that contrals the printer is a computer program. Name two programming languages.

1.

2.

(1 mark)

 

 

 

 

 

QUESTION THREE

 

(a) Mere uses her computer in a village where the electrical power supply is not reliable. The supply suffers from spikes and blackouts.

(i) Explain the terms spike and blackout. Give a possible cause for each one.

SPIKE

CAUSE

(1 mark)

BLACKOUT

CAUSE

(1 mark)

(ii) In the following sentence insert a word or phrase in each blank space to complete the sentence correctly.

As a general rule spikes damage ______________________________ but blackouts damage _______________________________ . (2 marks)

(iii) What can Mere do to stop damage caused by spikes and blackouts?

(1 mark)

 

(b) A friend gives Mere a piece of paper. On the page is written a joke about viruses. Here is the page.

(i) Describe two ways that this joke is like a real computer virus.

1.

(1 mark)

2.

(1 mark)

(ii) Describe one thing Mere can do to protect her computer from viruses.

(1 mark)

 

© Mere’s computer has these six devices which exchange data with her CPU:

Keyboard Floppy Drive Hard Drive

CDROM Drive RAM ROM

The arrows in the following diagram show the flow of data. Write the name of one device in each box so that the diagram correctly shows how data flows between the CPU and other devices. (3 marks)

(d) Mere needs a floppy disk to store her files.

(i) Mere begins by formatting a floppy disk. Describe one way that she could format the disk.

(1 mark)

(ii) Mere then creates a folder (directory) structure on the floppy disk that looks like this:

Name one way that Mere could create this folder (directory) structure on her floppy disk.

(1 mark)

(e) Mere creates a word processor file and saves this file to her disk. She names the file ThirdWeek and puts it in the Nov subfolder. She then quits the word processor.

(i) Describe how Mere can move the file ThirdWeek to the Oct folder (directory), without using the word processor.

(1 mark)

(ii) Explain why moving the file ThirdWeek is different than copying the file to the Oct folder (directory).

(1 mark)

(iii) Later Mere forgets where this file is stored. Describe one way that she could have the computer search for the missing file.

(1 mark)

QUESTION FOUR

  1. Students can have photocopying done in their school library. Students pay $20.00 at the start of the year for photocopying. Each page they photocopy costs $0.15 single, or $0.25 backed. Pupils can only get photocopying done if they still have some of their $20.00 left.

Here is the spreadsheet that accounts for each student�s use of the photocopier. This spreadsheet shows the numbers as they appear on the screen.

 

A

B

C

D

E

F

1

PHOTOCOPY

ACCOUNTS

 

 

 

Single costs

$ 0.15

 

2

     

Backed costs

$ 0.25

 

3

           

4

STUDENT

NO. OF SINGLE

NO. OF BACKED

PHOTOCOPYING TOTAL COST

FEE PAID

MONEY LEFT

5

George

10

0

$ 1.50

$20.00

$ 18.50

6

Helen

13

4

$ 2.95

$20.00

$ 17.05

7

Peti

6

2

$ 1.40

$20.00

$ 18.60

8

Sami

3

16

$ 4.45

$20.00

$ 15.55

9

Esta

100

20

$ 20.00

$20.00

$ 0.00

10

           

11

       

TOTAL

$ 69.70

(a)

(i) What type of entry is in row 4?

(1 mark)

(ii) What type of entry is in cells B5 to B9?

(1 mark)

(b)

(i) Cell D5 contains a formula. In it there is a reference to cell E1. Explain why it is an absolute reference.

(1 mark)

(ii) The formula in D5 contains another absolute reference. Which cell is referred to in this second reference?

(1 mark)

(iii) Write a suitable formula for cell D5.

(1 mark)

(iv) Describe the difference between a relative cell reference and an absolute cell reference.

(1 mark)

(v) Suppose the cost of paper goes up by two cents a sheet. Describe in detail what change or changes need to be made to the spreadsheet.

(1 mark)

© Cell F5 contains a formula. Write down what this formula is.

(1 mark)

(d) Explain why the librarian should look in column F before doing any photocopying for a student.

(1 mark)

(e) Describe in detail the format of row 4, and the format of cell F5.

(i) Row 4

(1 mark)

(ii) Cell F5

(1 mark)

(f) Cell F11 contains a total of the money for photocopying.

(i) Expalin why a function and not a formula should be used in F11.

(1 mark)

(ii) Write an appropriate entry for cell F11.

(1 mark)

(g)

(i) Explain why a spreadsheet is used in this library situation and not a database.

(1 mark)

(ii) Name one spreadsheet.

(1 mark)

(h) George leaves school. He is paid his Money Left of $18.50. Describe what the librarian should do to update the spreadsheet.

(1 mark)

 

 

QUESTION FIVE

A school library creates a database of its books. Here is the database at the very start of its construction.

TITLE

AUTHOR

PUBLISHED

TYPE

ISBN

Pyramid Plot

Sauper J

25/10/1992

Non Fiction

0746005067

Asterix and the Secret Weapon

Uderzo A

15/02/1991

Fiction

0340568712

Science Fun

Johnson M

02/04/1988

Non Fiction

0746003617

BFG, The

Dahl R

19/07/1982

Fiction

0294106323

More Murderous Maths

Poskitt K

12/09/1998

Non Fiction

0590112600

Wicked Words

Deary T

28/01/1996

Non Fiction

0590542575

(a)

(i) How many fields are in this database? (1 mark)

(ii) How many records are in this database? (1 mark)

(b)

(i) Which field or fields are defined as text?

(1 mark)

(ii) Which field or fields are defined as numeric?

(1 mark)

(iii) What other type of field definition is there is this database?

(1 mark)

© To test the database the librarian selects all non fiction books. She then does an ascending sort by AUTHOR. (Use the information shown in the diagram to answer this question.)

(i) Write down the title of the first book listed in this process.

(1 mark)

 

(ii) Explain why the authors� names are entered in the order of Lastname Initial; and not in the order of Initial Lastname.

(1 mark)

(d) The database is not well designed. The poor design is the storage of the Author�s names.

(i) Describe how the database should be changed to correct this design fault.

(1 mark)

(ii) Give a reason for your answer to question (d) (i).

(1 mark)

(e)

(i) Explain why a database is used for this task in the library, and not a spreadsheet.

(1 mark)

(ii) Name one database.

(1 mark)

 

(f) The librarian wants to learn about queries which have AND and OR statements.

(i) The librarian applies the following query to the database shown on page 22.

TYPE = Non Fiction AND DATE >= 01/01/1996

In the table write down the TITLES that are selected by this query. (1 mark)

TITLE

 

 

 

 

 

 

 

 

 

 

 

 

(ii) The librarian applies the following query to the database shown on page 22.

ISBN > 0700000000 OR TYPE LIKE "Fiction"

In the table write down the TITLES that are selected by this query. (1 mark)

TITLE

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(g) The librarian also wants to learn about reports from a database.

(i) Describe one difference between a report and a query.

(1 mark)

(ii) The librarian makes a report of all Non Fiction TITLES in the database. Here is her report.

. To get the report she used TYPE = Non Fiction. Why does the report not have a column named TYPE in it?

 

(1 mark)

(h) The librarian must enter the data about all the books in the library. Describe one data integrity practice she could use while doing this job.

(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