University of Cambridge International Examinations General Certificate of Education Ordinary Level
University of Cambridge International Examinations General Certificate of Education Ordinary Level
University of Cambridge International Examinations General Certificate of Education Ordinary Level
w
w
.X
tr
me
eP
ap
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
er
s
General Certificate of Education Ordinary Level
.c
om
*6092681791*
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.
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.
IB08 06_7010_01/RP
© UCLES 2008 [Turn over
2
1 Explain, using examples where appropriate, the meaning of these computer terms. For
Examiner's
Use
(a) batch processing
[2]
(b) interrupt
[2]
[2]
[2]
(e) trackerball
[2]
[2]
3 A company has decided to set up call centres in different countries. Regular training
sessions, using video conferencing, will be carried out.
[1]
[1]
(c) Give one advantage of using video conferencing to carry out the training.
[1]
(d) Give one disadvantage of using video conferencing to carry out the training.
[1]
(e) Describe another method of training staff using modern computer technology.
[1]
4 Name two types of automatic data capture and give one application for each type named. For
Examiner's
Use
Type 1
Application 1
Type 2
Application 2
[4]
[1]
[1]
[1]
(d) Why would backing up data not guard against the effect of a virus?
[1]
6 Students’ records are kept on a stand-alone computer (no network connections) in the For
principal's office. Examiner's
Use
[1]
[1]
(b) Give two examples of when a student’s record would need to be altered.
Example 1
Example 2
[2]
(c) Students are concerned that their personal data could be misused. Name two methods
that could be used to ensure personal data is kept secure.
Method 1
Method 2
[2]
(d) Examination results are stored in students’ records as marks out of 100. Give two
different validation checks that could be performed on students’ marks.
Check 1
Check 2
[2]
50 mm
70 mm
20 mm
20 mm
40 mm 20 mm
Start Finish
PENDOWN
LEFT 90
FORWARD
[4]
8 A student decides to use an Internet search engine at home to help her work on her For
Geography project. She types in: Examiner's
Use
(a) She wanted to know which South American countries exported coffee in 2007. How
could her search be refined to reduce the number of results?
[1]
(b) Give one advantage of searching for information on the Internet rather than using
books.
[1]
(c) Many people have fears about searching for information on the Internet. Give two
reasons for these fears.
[2]
(d) The student wishes to use files stored on her home computer when she is back in class
using one of the school’s computers. How could she do this?
[1]
9 The following flowchart inputs two numbers, carries out a calculation and then outputs the For
result. Examiner's
Use
START
INPUT u, v
Is u + v Yes OUTPUT
= 0? “Error”
No
f = (u * v)/(u + v)
OUTPUT f
(a) Complete the following table for the three sets of input data.
INPUT
OUTPUT
u v
5 5
6 -6
12 4
[3]
(b) The above algorithm has been placed in a library of routines. Give one advantage of
doing this.
[1]
10 A computer system comes equipped with DVD writer/reader, hard disk drive and RAM. For
Examiner's
Use
(a) Give a different use for each of these forms of memory.
DVD
Hard Disk
RAM
[3]
(b) Give another example of a memory device and give one advantage of the named
device.
Example
Advantage
[2]
[4]
12 Algorithms and programs use loops to control the number of times a particular procedure is For
used. Examiner's
Use
(a) Write a procedure using both these loop methods to input 20 numbers into a variable
called x.
[2]
(ii) for … to
[2]
[1]
13 A media retail company has decided to sell CDs and DVDs using an Internet only shop. For
Examiner's
Use
(a) Describe three features you might expect to see on the shop’s website.
[3]
[2]
14 (a) Computer systems are widely used now in simulations such as crash testing new cars. For
Give two advantages of using simulations rather than carrying out actual testing. Examiner's
Use
[2]
(b) Virtual reality is often used in simulations. Describe two man-machine interface
devices which allow communication with virtual reality systems.
[2]
15 A systems analyst has designed a new computer system for a large company. For
Examiner's
Use
(a) Name two methods of implementing this new system and describe one advantage of
using each method. (Do not give the same advantage for Method 1 and Method 2.)
Method 1:
Advantage:
Method 2:
Advantage:
[4]
(b) Before the system is implemented, it needs to be fully tested. One of the tests will be to
check that the company does not pay a worker more than $800 per week.
Use examples of a worker’s pay to explain what is meant by normal test data,
abnormal test data and extreme test data.
Normal
Abnormal
Extreme
[3]
16 The washroom in a hotel uses lights controlled by a computer system. If the washroom is For
unoccupied for 10 minutes, the lights go out automatically. As soon as someone enters, the Examiner's
Use
lights come on.
[2]
(b) Write down a set of instructions which would enable the computer to decide when to
turn out the lights.
[3]
[1]
[3]
(b) How would a user be confident that the output from this expert system was correct?
[1]
(c) Give one advantage of using an expert system to identify chemical compounds.
[1]
18 An entertainment company keeps monthly records on a spreadsheet of all its organised For
rock music events. The information for May 2008 is shown below. Examiner's
Use
A B C D E F G
Total Cost of
No. of No. seats Seat price Profit or
1 Event money event
seats sold ($) Loss
taken ($) ($)
2 The Bugs 4000 1700 45 76500 85000 Loss
3 Static Rocks 3000 3000 50 150000 100000 Profit
4 The Cold Apes 4000 2150 35 75250 90000 Loss
5 Monophonics 5000 4000 35 140000 125000 Profit
6 Human Senses 4000 4000 60 240000 180000 Profit
7 Ice Patrol 3000 1500 50 75000 80000 Loss
8 The Manual 2000 1650 60 99000 115000 Loss
9
(a) (i) What formula is in cell E2 to work out the total money taken for The Bugs event?
[1]
(iii) Total cost of all events is to be shown in cell F9. What formula needs to be placed
in F9?
[1]
(b) If the value in C7 was changed to 2000, which cells would be automatically updated?
[2]
(c) Describe how to find the break even point for any given event (i.e. when cost of event =
total money taken).
[2]
19 Customers can withdraw cash from an Automatic Teller Machine (ATM). For
Examiner's
Use
• withdrawal is refused if amount entered > current balance
• withdrawal is refused if amount entered > daily limit
• if current balance < $100, then a charge of 2% is made
• if current balance $100, no charge is made
Write an algorithm which inputs a request for a sum of money, decides if a withdrawal can
be made and calculates any charges. Appropriate output messages should be included.
[5]
BLANK PAGE
7010/01/M/J/08
19
BLANK PAGE
7010/01/M/J/08
20
BLANK PAGE
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.
7010/01/M/J/08