| Full
Course Foundation Tier Answers (page 359) |
|
1
|
|
Computers
could be more readily stolen from houses. Pupils could load
games onto the machines so there could be copyright violations.
Games loaded could also introduce viruses. |
|
|
|
|
|
2(a)
|
|
Description,
Price, Quantity in stock, Supplier name etc. |
|
(b)
|
|
Goods
do not need to be individually priced and the price can be put
on the shelf edge. Bar codes are scanned and this reduced the
number of mistakes. Much faster than the check out person inputting
codes using a keyboard. |
|
(c)
|
|
The
screen for the new customers will need to contain places to
input the information about the customer such as name, address,
tel no etc. With existing customers this is known already and
can simply be obtained from the customer file. |
|
(d)
|
|
Any
sensible screen design with the more important fields in a prominent
position. Each new customer should have a unique field such
as customer number. |
|
(e)
|
(i)
(ii) |
Postal code
Using the DBMS, a query could be constructed to add up the totals
of the orders made and the amounts of those orders last year.
The same could be done for the orders for this year. This data
could then be exported to a spreadsheet so that graphs could
be drawn so that comparisons can be made between the two years.
|
|
|
|
|
|
3(a)
|
|
120
to see if the range check disallows numbers greater than 100.
-1 to see if the range check disallows numbers less than zero.
34 to make sure that the range check allows a valid number.
100 to test upper end of range. 0 to test lower end of range.
|
|
(b)
|
|
Installation
instructions; How to make back up copies of the software; How
to correct common errors; How to contact the help-line; How
to customise the system. |
|
|
|
|
|
4(a)
|
|
User
training to make sure everyone who is to use the system, understands
it thoroughly. Conversion of the data onto the new system. |
|
(b)
|
|
Installation
instructions; How to make back up copies of the software; How
to correct common errors; How to contact the help-line; How
to customise the system. |
|
(c)
|
|
Two
people could enter the same data and only if they agree, will
it be accepted for processing. Get the person inputting the
data to check (i.e. proofread) what they have typed against
the paper order. |
|
(d)
|
|
Quicker
to type in a code, so this saves time. Codes are used to uniquely
define a product. |
|
(e)
|
|
Regular
backup copies are taken. Copies are dumped to a tape streamer
and then removed off site. |
|
|
|
|
|
5
|
|
What
outputs from the system are needed; The method of data capture
used for the input (OMR, bar coding, magnetic stripes etc.);
The design of any codes used; The design of the files used by
the system; the hardware configuration used; the purchase/writing
of any software used; testing the system. |
|
|
|
|
|
6(a)
|
|
Controlling
data input and output. Controlling the disk drives and how and
where the data is stored on the disk. Providing an interface
between the user and the hardware. etc. |
|
(b)
|
|
Windows
98, OS/2, Windows 2000, Windows ME, Unix etc. |
|
(c)
|
|
The ability of a computer to be able to perform more than one
task at the same time. |
|
(d)
|
|
Any
sensible network topology can be drawn. |
|
(e)
|
|
Ability
to share expensive peripherals. Ability for all authorised users
to access the same data files. Able to use e-mail between terminals
etc. |
|
(f)
|
|
Use
of passwords to allow only certain users access to certain data
files. No disk drives so that viruses cannot be introduced via
floppy disks. Central backing up of data so that ordinary users
do not have to remember to do this. |
|
|
|
|
|
7
|
|
Data
should be obtained and processed fairly and lawfully. Personal
data should be accurate and up-to-date. Appropriate security
measures should be taken to protect the personal data. People
should be allowed to see the personal data held about them so
that they may check it for its accuracy. Etc. |
|
|
|
|
|
8(a)
|
|
Columns,
fonts and sizes (or vice versa), clip art. |
|
(b)
|
|
A
laser printer prints good quality text and graphics. |
|
(c)
|
|
Scanner
to scan photographs and then import them into documents. |
|
(d)
|
(i)
(ii) |
Formats a floppy disk Displays a screen saver when the computer
is not being used.
Formats a floppy disk Displays a screen saver when the computer
is not being used. |
|
(e)
|
(i)
(ii) |
index, hardware
The language used should be easy to understand. There should
be no missing instructions. It should be easy to find the information
you want. |
|
(f)
|
|
The tennis club has twelve members. None of the Tennis Club's
members can use information technology. The hardware and software
needed cost more than £2500. |
|
|
|
|
|
9(a)
|
|
The
number printed under the bar code is also stored in the bar
code. Every member has a different number on their membership
card. Bar codes can be read into the computer without the need
for data preparation. |
|
(b)
|
|
It
is faster to use a bar code reader than to type the number into
the computer. The librarian types the number into the computer
if the bar code reader is not working. The librarian could make
a mistake typing in the number. |
|
(c)
|
|
When
a bar code is read, the check digit is worked out. If it is
correct then the computer assumes that the car code has been
read accurately. Every bar code has a different check digit.
When you work out the check digit on a bar code, you should
always get the same answer. |
|
(d)
|
(i)
(ii) |
One records the book being borrowed and the other records the
member borrowing the book. In other words the two are linked
together.
The computer will already know who the member is since the book
and member numbers are stored together. |
|
(e)
|
|
on-line, multitasking, multi-access |
