2001 Model Answers

 

 

 

 

 

 

 

 

 

 

 

 

 

 

COMPUTER STUDIES

 

 

2001

 

 

MODEL ANSWERS

 

 

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? B is answer.

 

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

Central Processing Unit

(1 mark)

(ii) Explain what the CPU does.

It accepts and processes the input and produces the output (any sensible

answer gains the mark)

(1 mark)

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

PRIMARY Random Access Memory 32 MB or RAM 32MB

SECONDARY Hard Disk 520 MB or HDD 520MD

ALL FOUR ANSWERS REQUIRED TO GAIN THE MARK.

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

To clean out all the unwanted files.

(1 mark)

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

Any disadvantage eg She loses all information from the hard drive.

(1 mark)

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

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

Any sensible purpose eg To control the flow of data within the computer; to

act as an interface between the user and the hardware; etc

(1 mark)

(ii) Name one operating system.

Any operating system eg windows; macos; Linux; unix; DOS etc

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

No. Ana�s friend bought the operating system and she is allowed to give

away the original.

(1 mark)

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

The publisher of the software. (But an intelligent answer about other

licencing systems gets the mark � eg GNU, shareware, freeware etc.)

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

That the keyboard is plugged in properly; or that there is nothing resting on

the keyboard depressing a key.

(1 mark)

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

Any sensible answer. Eg To provide input.

(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

1 mark for every 2 correct answers. NO HALF MARKS!

(g) Ana needs some applications for her computer.

(i) What is an application?

Software used to accomplish a specific task. (any answer that contains the

the idea of software that the user directly interacts with gets the mark)

(1 mark)

(ii) List four different applications Ana might need.

1. Any four applications eg wordprocessor, spreadsheet, database

2. Communications, web browser; OR the specific names of the application

3. eg Word; Internet explorer; Excel etc. One mark is awarded for every

4. two correct answers. NO HALF MARKS ARE TO BE GIVEN!

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

Any description that fits an appropriate word processor. Most students will

be using MSWord, so their answer should be: “Go to page setup, choose

A5, or set the page dimensions to those of A5”

(1 mark)

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

 

 

 

 

 

 

 

 

 

 

 

 

The length must be obviously greater than the width.

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

Serif fonts have extra pieces (serifs) at the ends of the strokes that form the

letters but sans serif fonts do not have these (serifs).

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

Any two of bold, centred, underlined, uppercase, larger font size

(1 mark)

(ii) Describe the alignment of PARAGRAPH 1.

Justified or full justified.

(1 mark)

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

Cut and paste. (the order of operation is unimportant)

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

Wysiwyg; or what you see is what you get.

(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

Ben�sComputer:\projects\book\MyBook (punctuation not important)

(1 mark)

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

To store things neatly, in a logical manner. Easier or quicker to find files.

Easier or quicker to store files.

(1 mark)

(f) Ben should back up his file MyBook

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

In case the original gets damaged.

(1 mark)

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

Any advantage. Eg it is easily taken to another computer; it can be .

Stored in another location

(1 mark)

 

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

Use SaveAs command; use copy command and then rename command;

use windows explorer to drag and drop file to floppy and then rename;

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

By heat, magnetism, strong sunlight, fungus or mildew, fingerprints on disk

Surface; water; (Any correct answer gets mark)

(1 mark)

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

Dry place away from magnets and direct heat. Air conditioned room is

likely to be the most common answer.

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

Out of paper; paper jam; out of ink or toner; cable fallen out;

(1 mark)

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

1. Any two. Eg pascal; cobol; basic; fortran. Student must have two

2. answers to gain the mark.

(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 Sudden large increase in voltage.

CAUSE Lightening; switching of large electric motor

(1 mark)

BLACKOUT Lose of power

CAUSE Electricity line fallen down; fuse blown; power company develops

fault in supply, etc

(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 __ hardware

but blackouts damage data or software .(2 marks)

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

Install a UPS.

(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. Designed to reproduce. Designed to spread.

(1 mark)

2. Can be destructive. It is a set of instructions (like a program).

(1 mark)

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

Any antivirus procedure. Eg install antivirus software; don�t use disks of

unknown origin;

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

Every two answers gains one mark (No half 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.

Use format command; use windows explorer and the format command there

Use MyComputer window and the format command there.

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

Use MD command in DOS; or use windows explorer and Create New

Folder command; or use windows Create New Folder from File menu; etc

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

Use drag and drop; or copy and rename commands in DOS;

(1 mark)

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

Moving the file does not leave a copy of it in the Nov folder, but copying it

does leave a copy of the file in the Nov folder.

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

Use a search utility, eg find files in windows.

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

Labels or headings or text.

(1 mark)

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

Data or numbers or numeric data

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

So that the formula in D5 can be filled down or copied to other cells

and still contain a reference to the price per page (to cell E1).

(1 mark)

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

E2

(1 mark)

(iii) Write a suitable formula for cell D5.

= $E$1*B5+$E$2*C5 or = $E1*B5+$E2*C5 The = sign is optional

(1 mark)

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

The absolute cell reference always refers to the same cell when copied, but

the relative cell reference changes relative where the cell is pasted.

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

The cell E1 needs to be changed to $0.17 and cell E2 needs to be changed

to $0.27. (No other changes are required if constructed properly)

(1 mark)

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

= E5 � D5

(1 mark)

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

This column shows whether the student has any money left for paying for

the photocopying.

(1 mark)

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

(i) Row 4 Bold, centred, wrapped text (any two answers required)

(1 mark)

(ii) Cell F5 Currency

(1 mark)

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

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

Any sensible explanation about functions being more appropriate.

(1 mark)

(ii) Write an appropriate entry for cell F11.

= SUM(F5:F9)

(1 mark)

(g)

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

Any sensible reason. Eg This situation requires calculations rather than

the processing of written data.

(1 mark)

(ii) Name one spreadsheet.

Any name, eg Excel, MSWorks, etc

(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? 5 (1 mark)

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

(b)

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

Title, Author, and Type ALL THREE ANSWERS NEEDED TO GAIN MARK

(1 mark)

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

ISBN

(1 mark)

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

Date (in PUBLISHED)

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

Wicked Words

(1 mark)

 

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

So that when the AUTHOR field is sorted the names are sorted in alphabet-

ical order by surname, and not by the author�s initial.

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

The AUTHOR field should be split into two fields. One to hold the surname

of the author, the other to hold the INITIAL of the author.

(1 mark)

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

The initial and the author�s surname are two different (separate) pieces of

information and so should have their own separate fields in the database.

(1 mark)

(e)

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

The main task is the sorting and storage of written data, not the working

out of calculations

(1 mark)

(ii) Name one database.

Any database. Eg Access, paradox etc

(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

More Murderous Maths

Wicked words

(Order and spelling unimportant)

 

 

 

 

 

 

 

(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

Pyramid Plot

Asterix and the Secret Weapon

Science Fun

BFG, The

(Spelling and order is unimportant)

 

 

 

 

 

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

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

Any sensible difference. Eg a report is often printed but a query is not

Or A report has titles and summaries more easily inserted.

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

 

This information is contained in the heading of the report. (any sensible

reason)

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

Any data integrity practice suited to this task. Eg double check information

that is typed with the original list; set data definitions in fields with ranges

for input; etc

(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