0420 s12 QP 12

UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education
*9702994269*
0420/12
COMPUTER STUDIES
May/June 2012
Paper 1
2 hours 30 minutes
Candidates answer on the Question Paper.
No Additional Materials are required.
READ THESE INSTRUCTIONS FIRST
Write your Centre number, candidate number and name on all the work you hand in.
Write in dark blue or black pen.
You may use a soft pencil for any diagrams, graphs or rough working.
Do not use staples, paper clips, highlighters, glue or correction fluid.
DO NOT WRITE IN ANY BARCODES.
Answer all questions.
No marks will be awarded for using brand names of software packages or hardware.
At the end of the examination, fasten all your work securely together.
The number of marks is given in brackets [ ] at the end of each question or part question.
For Examiner's Use
This document consists of 20 printed pages.

IB12 06_0420_12/2RP
UCLES 2012
[Turn over
2
1
Write down three of the stages in the system life cycle.
For
Examiner's
Use
3
[3]
Both email and mobile phones can be used to send messages.

Give one advantage and one disadvantage of using each method when compared to each
other.
(i) Email:
Advantage
Disadvantage
(ii) Mobile phones:

Advantage
Disadvantage
[4]
UCLES 2012
0420/12/M/J/12
3
3
A computer system is to have wireless access (Wi-Fi) to the Internet.
For
Examiner's
Use
State five potential security issues.

1
5
[5]
UCLES 2012
0420/12/M/J/12
[Turn over
4
4
A list of four printers and four different applications which use printers is shown below.
For
Examiner's
Use
(a) Using arrows, link each printer to the most appropriate application.
Printing documents in a
factory environment which
is dusty and damp
3D printer
High quality printing of

30 000 colour booklets per
day
Dot matrix printer
Producing prototypes in
resin of a new design
Colour inkjet printer
Producing a colour poster
Colour laser printer
[4]
UCLES 2012
0420/12/M/J/12
5
(b) Give one feature of each printer which makes it appropriate for the application.
For
Examiner's
Use
3D printer
Dot matrix printer
Colour inkjet printer
Colour laser printer
[4]
UCLES 2012
0420/12/M/J/12
[Turn over
6
5
(a) Give three features you would expect to see in a typical Computer Aided Design (CAD)
program.
1
[3]
(b) Describe three specialist output devices which could be used with a CAD program
when developing a new product.
1
[3]
UCLES 2012
0420/12/M/J/12
For
Examiner's
Use
7
(c) Describe two potential health risks and one potential safety risk when using computer
systems.
For
Examiner's
Use
Health risk 1
Health risk 2
Safety risk
[3]
UCLES 2012
0420/12/M/J/12
[Turn over
8
6
Carefully study the following flowchart:
For
Examiner's
Use
START
M = 32
T=1
S=0
C=1
INPUT D
T=D*M
M = M/2
S=S+T
C=C+1
Yes
No
OUTPUT S
STOP
UCLES 2012
0420/12/M/J/12
9
(a) Complete the trace table for the following data:
For
Examiner's
Use
1, 0, 1, 1, 0, 1
M
[4]
(b) What process does this flowchart perform?
[1]
(c) Predict the output from the flowchart for an input of 1, 1, 1, 1, 0, 0
[1]
UCLES 2012
0420/12/M/J/12
[Turn over
10
7
An expert system is being developed to diagnose faults in electronic equipment. Each piece
of equipment is made up of the following components:
screen
keypad (containing F1 to F9 keys)
sound card and speakers
RAM and ROM
microphone
(a) The following series of questions were asked by the expert system. The responses by
the user are also shown:
Response
Question
Is the screen operating?
Yes
If the F2 key is pressed, does the screen go green?
Yes
If the F1 key is pressed, can sound output be heard?
No
(i) In which component is the fault likely to be?
[1]
(ii) What would the expert system do next to help diagnose the exact fault in the
component(s)?
[2]
(iii) What output would the expert system produce?
[1]
UCLES 2012
0420/12/M/J/12
For
Examiner's
Use
11
(b) An expert system has an input-output interface. State three other parts that make up a
typical expert system.
For
Examiner's
Use
1
2
3
[3]
(c) The electronic equipment contains RAM and ROM.

Give one use of each type of memory.
RAM
ROM
[2]
UCLES 2012
0420/12/M/J/12
[Turn over
12
8
Body mass index (bmi) is calculated using the following formula:

bmi =
For
Examiner's
Use
weight
(height)2
Six peoples data are shown in the spreadsheet below:

A
1
name
2
3
4
5
6
7
8
Theo
Sujatmi
Angela
Juan
Jatinder
Igor
weight
(kg)
70.0
63.6
72.4
110.0
76.4
70.5
height
(m)
1.87
2.03
1.70
1.90
1.65
1.98
D
bmi
E
underweight,
normal or
overweight
20.0
15.4
25.1
30.5
28.1
18.0
(a) What formulas must be in column D to calculate each persons bmi?

D
1
bmi
2
3
4
5
6
7
[2]
(b) Column E indicates whether the person is underweight, normal or overweight.
(i) The following formula was typed into E2:
= IF(D2<18.5, underweight, IF(D2>25, overweight, normal))
What output would appear in E2?
[1]
(ii) What formula needs to be placed in D8 to find the average (mean) bmi?
[1]
UCLES 2012
0420/12/M/J/12
13
(iii) If the formula in E2 were replicated down to E8, what formula would appear in E8?
For
Examiner's
Use
[2]
(c) Column F was added to the spreadsheet to show each persons ideal weight. This is
calculated using twenty times the square of a persons height.
What formula needs to be placed in F2?
[1]
(a) Give a suitable application for each of the following data capture devices:
barcode reader
radio frequency identification (RFID) reader
magnetic stripe reader

[3]
(b) State two different validation checks and give an example of their use. Each example
should be different.
Check 1
Use
Check 2
Use
[4]
UCLES 2012
0420/12/M/J/12
[Turn over
14
10 (a) Complete the truth table for the following logic circuit, which is made up of NAND
gates:
A
B
X
[4]
UCLES 2012
0420/12/M/J/12
For
Examiner's
Use
15
(b) Name two other types of logic gate and complete their associated truth tables:
Gate 1:
For
Examiner's
Use
Gate 2:
[4]
UCLES 2012
0420/12/M/J/12
[Turn over
16
11 A room in a house is fitted with a computerised intruder alarm system:
window
For
Examiner's
Use
= infra red sensors

= pressure sensors
door
(a) (i) Describe how the sensors and computer would be used to detect intruders.
(ii) Describe how the system warns that an intruder has been detected.
[4]
(b) It is decided to automatically close door and window shutters if an intruder is detected.
What additional processing and hardware would be needed?
[2]
(c) Name another sensor that could have been used in this intruder alarm system.
[1]
UCLES 2012
0420/12/M/J/12
17
(d) What measures could be taken to stop or minimise the number of false alarms?
For
Examiner's
Use
[2]
12 (a) John has bought a 4 Gbyte MP3 player.

(You may assume: 1 byte = 8 bits, 1 Mbyte = 1024 kbytes and 1Gbyte = 1024 Mbytes)
(i) We can assume that each song lasts 3 minutes and is recorded at 128 kbps
(kilobits per second).
How much memory is required per song?
[2]
(ii) Using your answer in (i), how many songs can be stored on Johns MP3 player?
[2]
(b) John also bought a device for recording television programmes. It allows him to record
a programme at the same time as he is watching an earlier recording.
Describe how such a system would work.
[3]
UCLES 2012
0420/12/M/J/12
[Turn over
18
13 Look at these two pieces of code:
A:
CLC
LDX
loop: LDA
ADC
STA
INX
CPX
BNE
#0
A,X
B,X
C,X
B: FOR Loop
INPUT
Sum =
PRINT
NEXT
For
Examiner's
Use
= 1 TO 4
Number1, Number2
Number1 + Number2
Sum
#16
loop
(a) Which of these pieces of code is written in a high-level language?

[1]
(b) Give one benefit of writing code in a high-level language.
[1]
(c) Give one benefit of writing code in a low-level language.
[1]
(d) High-level languages can be compiled or interpreted.

Give two differences between a compiler and an interpreter.
1
2
[2]
UCLES 2012
0420/12/M/J/12
19
14 A ship at sea uses Global Positioning System (GPS) technology to navigate.
For
Examiner's
Use
(a) Describe how GPS technology is used to help the ships navigation.
[4]
(b) Describe two benefits to the ships personnel through using GPS technology.
1
[2]
(c) How should the ships satnav device give navigation instructions to the ships
personnel?
[1]
UCLES 2012
0420/12/M/J/12
[Turn over
20
15 An estate agent advertises houses for sale. The customer enquiries for a 7-day working
week are entered weekly into a computer.
For
Examiner's
Use
Write an algorithm, using pseudocode or a program flowchart only, which:
inputs the number of customer enquiries each day,

inputs the house price each customer enquires about,
outputs how many customers enquired each day about houses costing less than
$100 000,
outputs the percentage of all enquiries made during the week about houses costing
more than $500 000.
[6]
Permission to reproduce items where third-party owned material protected by copyright is included has been sought and cleared where possible. Every
reasonable effort has been made by the publisher (UCLES) to trace copyright holders, but if any items requiring clearance have unwittingly been included, the
publisher will be pleased to make amends at the earliest possible opportunity.
University of Cambridge International Examinations is part of the Cambridge Assessment Group. Cambridge Assessment is the brand name of University of
Cambridge Local Examinations Syndicate (UCLES), which is itself a department of the University of Cambridge.
UCLES 2012
0420/12/M/J/12

0420 s12 QP 12

Uploaded by

Copyright:

Available Formats

0420 s12 QP 12

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

0420 s12 QP 12

Uploaded by

Copyright:

Available Formats

UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS

International General Certificate of Secondary Education

For Examiner's Use

This document consists of 20 printed pages.

Write down three of the stages in the system life cycle.

Both email and mobile phones can be used to send messages.

(ii) Mobile phones:

A computer system is to have wireless access (Wi-Fi) to the Internet.

State five potential security issues.

High quality printing of

Dot matrix printer

Colour inkjet printer

Producing a colour poster

Colour laser printer

Dot matrix printer

Colour inkjet printer

Colour laser printer

Carefully study the following flowchart:

(b) What process does this flowchart perform?

(c) Predict the output from the flowchart for an input of 1, 1, 1, 1, 0, 0

If the F2 key is pressed, does the screen go green?

If the F1 key is pressed, can sound output be heard?

(i) In which component is the fault likely to be?

(c) The electronic equipment contains RAM and ROM.

Body mass index (bmi) is calculated using the following formula:

Six peoples data are shown in the spreadsheet below:

(a) What formulas must be in column D to calculate each persons bmi?

radio frequency identification (RFID) reader

magnetic stripe reader

= infra red sensors

12 (a) John has bought a 4 Gbyte MP3 player.

(a) Which of these pieces of code is written in a high-level language?

(b) Give one benefit of writing code in a high-level language.

(c) Give one benefit of writing code in a low-level language.

(d) High-level languages can be compiled or interpreted.

Write an algorithm, using pseudocode or a program flowchart only, which:

inputs the number of customer enquiries each day,

You might also like