|
|
GCSE ICT
Foundation Written Paper
Attempt ALL questions. Write your answers in the boxes.
A1 The process of data capture might involve:
a collecting the data, entering the data and validating
the data
b collecting the data, entering the data and printing
the results
c collecting the data, entering the data and verifying
the data
d collecting the data, verifying the data and inputting
the results
A2 The network manager of a company has installed
communications software on the server. What is the purpose of communication
software?
a to create a mail merge document
b to use more than one software application at a time
c to use a microphone to enter data
d to send an e-mail over the Internet
A3 Which two of the following processes are handled by
the central processing unit?
1 controlling peripheral devices
2 handling control signals
3 storing data
4 scheduling tasks
a 1 and 2
b 3 and 4
c 2 and 3
d 1 and 3
A4 The type of printer needed to produce good quality
copies at high speed is:
a an inkjet printer
b a dot matrix printer
c a laser printer
d a bubble jet printer
A5 The structure of a database record for a music CD
includes:
a the name, length and type of each field in a record
b a list of all songs on a CD
c the name of the file
d the number of songs on the CD
A6 An advantage of a networked computer system compared
to standalone computers is:
a data is processed faster than with a standalone system
b you can play computer games
c peripheral devices can be shared
d less electricity is needed
A7 George pays for his shopping using a debit card. The
data on the card is captured using:
a an optical mark reader
b a magnetic stripe reader
c a bar code reader
d an optical character reader
A8 When documents are created using a step-by-step
process, help can be provided by a:
a template
b wizard
c spellchecker
d thesaurus
Questions A9, A10 and A11 all refer to the spreadsheet
below:
A9 Which cell contains the formula =B6*$B$1?
a D6
b C7
c B1
d C6
A10 Why are the $ signs included in
the formula B6*$B$1 mentioned in question A9?
a so that the cell reference B1 is relative to the
previous cell
b so that the cell reference B1 remains absolute on
every row
c so that the cell reference B6 is relative to the
previous cell
d so that the cell reference B6 remains absolute on
every row
A11 An error has been noticed; the
data in cell B9 should be 4.00. When the spreadsheet is re-calculated
a the value in cell C9 only will change
b all the values in column C will change
c there will be no change to the values in column D
d the values in cells C9 and D9 will change
A12 A computer model setup using a
spreadsheet is called:
a a real-time model
b a virtual reality model
c a mathematical model
d an expert system
A13 An architect uses a CAD system
to produce detailed technical drawings.
Which is the most likely output device he or she would
use?
a dot matrix printer
b plotter
c digitiser
d touch screen
A14 The fastest way to access a
particular web site is by
a sending an e-mail to your Internet service provider
b keying in the full web address
c searching the web using one key word
d searching the web using several key words
A15 Which storage loses data when
the computer is switched off?
a floppy disk
b DVD
c ROM
d RAM
A16 A company has a head office in
Exeter and five offices throughout the UK.
What computer configuration would you recommend to
link all the sites?
a standalone PCs
b local area network
c wide area network
d intranet
A17 A bitmapped graphic is made up
of a set of:
a bits
b templates
c bytes
d pixels
A18 When drawing a flow chart, for
what purpose would you use the symbol marked X in the following diagram?
a to indicate that a new option can be considered
b to indicate a process
c to indicate that a decision has to be made
d to indicate the expected output
A19 Damien works at a computer all
day long. He has started to suffer from back pain. Which of these should he use
to help reduce the back pain?
a an adjustable chair
b a copy holder
c a wrist rest
d an anti glare screen
A20 An advantage of using a computer
simulation is:
a expensive, full-size models are used
b people are not put in danger
c the results depend on the design of the model
d equipment can be damaged
TOTAL FOR SECTION A – 20 MARKS
Attempt ALL questions using the spaces provided.
B1 Greenfingers use database software to store and access
data in the Staff File.
Part of the database is shown below:
Employee ID Title First Name Last
Name Address 1
1 Mr John Gibbs
15 The Parade
7 Mr
Arthur Mills 45
Tulip Close
3 Mrs
Chloe Morris 24
Market Lane
5 Ms
Julie Morris 24
Market Lane
4 Mr
Kalpesh Patel 6
The Green
2 Miss Sharmin Qureshi
89 Hill Side
6 Mr Andrew Smith
12 Sea View
a How many records are shown?
b For each record state how many fields are shown
c State two other suitable fields that could be included in the
Staff File record:
(Total 4 marks)
B2 Pete and Sandra Wellings think their garden business
will improve if they sell their garden equipment over the Internet.
a What software will they need to use the Internet?
b State one reasons why their business should improve.
c State two reasons why customers may be reluctant to pay by
credit card on the Internet:
(Total 5 marks)
B3 Before sending an e-mail Sandra uses the spellchecker.
Sometimes a word is rejected even though she knows it is spelt correctly.
a 1 Describe, giving an example, how this could occur:
2 Explain how Sandra could use the spellchecker to
make sure this does not happen again with this word:
b Sometimes Sandra spells a word incorrectly but the
spellchecker does not reject it.
Explain, giving an example, how this could happen:
(Total 6 marks)
B4 Greenfingers also use database software to store and
access data in the Suppliers file:
The Supplier ID field is the keyfield for a record in the Suppliers
File.
a Describe what is meant by a keyfield:
Supplier ID Supplier Name Address Town
FUL015 Fullers
Fertilisers 28 Perry Hill DULTON
LAK010 Lakeland
Pottery 12 Lakeside WINDERMERE
SHR005 The
Shrubbery 68 Spinney Lane
SWAFFHAM
SUF001 Suffolk
Seeds 14 London Road IPSWICH
b The Supplier ID field is made up of the first three
letters of the company name followed by three numbers. When the ID is entered
into the
database it is validated. Explain what is meant by
data validation:
c Examples of data validation are:
. range check
. type check.
Explain which of these two methods of validation are
being used for the Supplier ID field and justify your reason.
(Total 6 marks)
B5 Walter Butler, Greenfingers Gardening Advisor, uses a
CAD system to design gardens for customers.
a Explain what is meant by a CAD system.
b State two advantages of using a CAD system.
(Total 5 marks)
B6 Greenfingers will benefit from several advantages over
standalone computers when they introduce a networked ICT system.
State two advantages of a networked system.
(Total 6 marks)
B7 Salim Hassan runs day-to-day sales at the garden
centre. When the new system was being designed he asked for electronic
point-of-sales terminals to be installed in the shop and drive-through sales
areas.
a Describe two benefits of EPOS terminals to Salim in his day-to-day
work:
b All stock in the shop carries a bar code. Explain the
advantages of using bar codes:
c Describe two essential items of hardware Salim needs in order to
use the bar codes:
(Total 6 marks)
TOTAL FOR SECTION B – 40 MARKS