Candidate’s Name Class Register Number

A. SEMBAWANG SECONDARY SCHOOL

PRELIMINARY EXAMINATION 2012SECONDARY 4 NORMAL (TECHNICAL)

COMPUTER APPLICATIONS 7016/01

Additional Materials: Answer Booklet

19 Sep 2012 0800 - 0915 1 h 15 min

READ THESE INSTRUCTIONS FIRST

Do not open this booklet until you are told to do so.Write your name, class and register number on the cover page.Write in dark blue or black pen on both sides of the paper.Do not use staples, paper clips, highlighters, glue or correction fluid.

Section A. Answer all questions. For each question there are four possible answers A, B, C and D.Choose the one you consider correct and tick the correct box.Each correct answer will score one mark. No mark will be deducted for wrong answer.You are advised to spend no more than 30 minutes on Section A (Questions 1-20).

Section BAnswer all questions.The number of marks is given in brackets [ ] at the end of each question or part question.

Setter: Mr Muzaffar bin Johari This document consists of 12 printed pages including this cover page.

[Turn over]

PARENT’S SIGNATURE

2

Section A [20 marks]

Tick the correct box to answer Questions 1 – 20.

1 Which of the following is a peripheral component of a desktop computer? - CPF

2 Adam scans a hardcopy of an image and transferred the image into his computer.

What is this process called? - CPF

3 Which is a measure to protect a computer from viruses? - CPF

4 Which is an example of a secondary storage device that does NOT rely on any moving or mechanical means by which data can be stored and retrieved? - CPF

A CPU

B hard disk

C keyboard

D RAM

A Cropping

B Digitising

C scanning

D Translating

A Assign passwords to all important files.

B Archive all your files.

C Lock your computers in a safe place.

D Scan the hard disk regularly to check for viruses.

A Hard disk drive

B Flash drive

C Random Access Memory

D Read-Only Memory

A computer is a programmable machine designed to sequentially and automatically carry out a sequence of arithmetic or logical operations.

35 When using a word processor, typist enters the word ‘three’ instead of ‘tree’.

Which word processing feature should the typist use to correct the mistake? - DOP

6 The following paragraph is found in a passage. - DOP

What type of indentation is used in the paragraph?

A first line indent

B hanging indent

C special indent

D tabbed indent

A add word to dictionary

B cut and paste

C search and replace

D spell check

4

7 Page layout refers to the - DOP

8 What have been done to change Graphic 1 to Graphic 2? - COG

Graphic 1 Graphic 2

9 Which of the following is NOT a multimedia element? - MMP

10

One of the advantages of using a word processor is - DOP

A composition of a document

B composition of the graphics

C line spacing

D size of paper used

A cropped.

B Cut

C Resized

D Skewed

A Animation

B Graphic

C Storyboard

D Text

5

11 Which is an example of good netiquette (net etiquette) in email? - CPF

A replying to an email after 48 hours

B typing your message in capital letters

C using short forms and abbreviations

D using proper grammar and spelling

12 What is the disadvantage of computer-based learning (CBL)? - CPF

A it allows you to embed video

B it can suggest the right content

C it improves productivity

D it saves paper

A It allows lessons to be designed as a game.

B It reduces interaction between students.

C Students can learn from home at their own pace.

D The CBL software has unlimited patience.

613 Spyware is a software that - CPF

14 A

man enters his Personal Identification Number (PIN) into the automated teller machine (ATM). What method of security is this called? - CPF

15

In document processing, the short cut key for ‘copy’ is CRTL + C. What is the short cut key for ‘cut’? - DOP

16 Which of the following is a web browser? - CPF

A Bing

B Google

C Yahoo

D Safari

A encrypts data that is sent on the internet

B prevents illegal access to your computer by hackers

C secretly collect data from users and report back to its creator

D reproduce itself and spread from one computer to the next

A copy protection

B Copyright

C data entry

D password protection

A CTRL + I

B CTRL + U

C CTRL + X

D CTRL + V

7

Answer Q17 and Q18 by referring to the spreadsheet below. - SST

17 Part of a spreadsheet is printed out

What is the highlighted data called?

A Digit

B Number

C Formula

D Text

18 What is the range of the cells highlighted?

A A2 : D5

B D2 : D5

C C3 : C5

D D5 : D3

8

19 A chart is produced from spreadsheet data about calories burnt in diffferent type of exercises. - SST

0

100

200

300

400

500

600

Running Swimming Aerobics Yoga

Calo

ries

Burn

t

Which chart menu option is selected to change the title for the vertical axis?

20

Which is the reason for the use of computers in an airport? - CPF

--- End of Section A ---

A Axes

B data labels

C Legend

D Titles

A to account for the number of tourists coming to Singapore

B to account for the number of passengers boarding a plane

C to monitor which are the common hotels that tourists go to

D to monitor the amount of money passengers have during flight

9

Section B [30 marks]

21 Using the following list complete the table. – CPF

Graph plotter Optical Mark Reader Headphones

Keyboard Microphone Projector

Input devices Output devices

[6]

22 Draw lines to match each document processing feature with its function. - DOP

Feature Function

word wrap a set of one or more fonts

typeface Combining a list of names and addresses with a standard letter

mail merge automatically moves to the next line when the end of a line is reached

bullets emphasising points in a list

[4]

10

23 Show what happens to the drawing when the feature has been used. - COG

Before After

(a) skew

[1]

(b) weld

[1]

(c) resize

[1]

(d) rotate

11

[1]

12

24 Circle TRUE if the statement is true of FALSE if the statement is false. - CPF

(a) MAN stands for Multi Access Network. TRUE / FALSE

(b) Data sent on a network is exposed to viruses. TRUE / FALSE

(c) Online shopping can be done on the intranet. TRUE / FALSE

(d) Current technology allow us to surf the internet using the television

TRUE / FALSE

(e) Internet explorer is a search engine. TRUE / FALSE

[5]

25 The worksheet below shows the printer sales information. - SST

A B C D2 Printer Sales Information34 Printer Price (S$) Printer

SoldTotal Sale

(S$)5 HP 320 10 32006 Canon 250 5 12507 Epson 330 3 99089 Average 300 6 181310 Maximum

(a) Give the address of the cell containing Epson.

………………………………………………………………………………..… [1]

(b) Give formula that is used to calculate the value average price of the 3

printers.

………………………………………………………………………………..… [1]

(c) What are the 2 formatting that is applied to the range of cells A4 to D4

……………………………………………………………………………..…… [2]

(d) Write down the value of cell C10 if the formula is MAX(C5:C7)

………………………………………………………………………………….. [1]

?

13

26 Almost all retail outlets makes use of a POS terminal, which handles all the transactions. - CPF

(a) What does POS stand for?

…………………………………………………………………………………. [1]

(b) State one device that is used at the POS terminal to input items’ code.

…………………………………………………………………………………. [1]

(c) How does the POS terminal benefit consumers?

…………………………………………………………………………………. [1]

27 (a) State one example of a special-purpose computer. - CPF

…………………………………………………………………………………. [1]

(b) State the 3 basic operations of a computer.

…………………………………………………………………………………. [2]

--- End of Paper ---