Name | |
Group |
This product
is licenced to
St. Mary Redcliffe and Temple CE School
. Use and reproduction of this workbook is permitted within the
institution named above, subject to the restrictions set out in the online licence
agreement. All other rights are reserved by the author.
Information can be presented in many different ways. The best way to present a piece of information will depend upon the ________________
the information is being used for, ________________
the information is being presented to and what ________________
you have available. For example statistical information could be presented as a table, a ________________
or writing. Computer ________________
can be used to present information. Information presented on paper is known as ________________
. Computers output information on an ________________
.
A microcomputer is a computer that is based around a ________________
. The most common type of microcomputer is the ________________
. These are bulky but cheap to buy and can be easily ________________
. A ________________
is a small microcomputer which is portable and battery powered. A ________________
is designed to fit into a pocket and usually includes software such as a diary and telephone book. Some microcomputers are built into other machines and used to control them. These are known as ________________
.
An optical character recognition (________________
) system is used to input printed text directly into a computer. A ________________
reads the text from the page. This is then analysed by ________________
to determine what letters and words are present. Optical chracter recognition systems can read ________________
text very reliably but are less reliable at reading ________________
text.
Information systems need to be able to store data. ________________
is used to store programs and data that are currently being used. This comes in two types, RAM ( ________________
) which can be read from and written to but which loses its contents when the computer is turned off and ROM ( ________________
) which can not be written to but which keeps its contents when the computer is turned off. Programs and data that are not currently being used are kept in ________________
. This is also known as secondary store. The three main media used for this type of storage are magnetic disks, magnetic tapes and ________________
.
This is a description of batch processing. Input data is collected into batches. No data is processed until a complete ________________
is ready. All of the input data that will be used to update the master file is stored temporarily in a ________________
file. Before processing takes place the transaction file must be ________________
and then sorted. As a result of processing a ________________
and an ________________
are produced.
This is a description of transaction processing. When a transaction is entered it is placed in a ________________
of transactions waiting to be processed. The transactions are processed in the ________________
that they are placed in the queue. The computer system will process ________________
transaction(s) at a time. Once the system starts processing a transaction it will not process any more transactions until the current transaction is________________
.
When a database is created the record ________________
must be defined. Each field in a database file must be given a data ________________
such as ________________
or Boolean. Fields must also be given a length. Each field can be either ________________
or variable length. One of the fields in the file will be chosen as the ________________
________________
field.
The owner of a small store wants to use a database to store information
about the products he sells and to keep a check on the amounts (level) of
stock he currently has. The owner will use the outputs from the database to
reorder products that the shop is running out of. You have been asked to define the record structure to be used by this
database. You will need to identify appropriate field names, data types and
lengths. Then give an example of some data that might be entered into each
field. Using the table below, define an appropriate record structure. A garage sells second hand cars. The garage owner stores the details of
each of the cars he has for sale in a database. The database contains only
one file which is called "Cars". Here are the names of the fields that are
used : Look at the spreadsheet below. Jenny is using it to calculate how much money
she spends each week on different items. Jenny has selected a range
of the spreadsheet using a mouse. This range is What is the range that Jenny has selected ? The operating system (OS) is the most important piece of ________________
software. An operating system will handle communications between the ________________
software and the ________________
. An example operating system is ________________
.
Look at this diagram showing how data has been organised on the backing storage
device of a computer : Write true or false by each of these statements about how the data has been
organised. A GIS presents stored data graphically on a ________________
. One example use of a GIS is as a ________________
system that is used to give a driver directions to get to his destination. This type of system is installed in a car and receives data transmitted by ________________
. From this the system can work out the location of the car. Maps stored on a ________________
or DVD are used to work out directions. These are given to the driver on a monitor and also using ________________
so that he does not have to look away from the road.
Email is also known as ________________
. Email messages are sent via a computer ________________
. Most email is now sent on the ________________
. Each email user has an ________________
such as john@bigcompany.co.uk. Once they have been sent messages are stored in a ________________
. Email messages usually arrive very ________________
and can be sent at very ________________
cost. Text and pictures can be sent by email but ________________
can not.
A ________________
network uses file and ________________
servers to control access to network resources. To access the files you have saved on the network you must log on to the file server with a ________________
and ________________
. Documents that you send to print will be placed in a ________________
. They will usually be printed in the order that they are sent. The alternative method of controlling access to network resources is called a ________________
network. This type of network requires less management but is less ________________
.
Some customers are concerned about how safe it is to purchase goods over the ________________
. When you make a purchase over the Internet you must be careful to ensure that you buy from a reputable company. Most global ICT services take some ________________
from you, process it and return the results of this processing to you. The person or company that uses a service is known as a service ________________
. The person or company that offer a service is known as a service ________________
. ________________
are used to measure ________________
quantities. When a reading has been taken an electrical signal will be sent to the computer. The software in a control system must decide when to turn the ________________
on and off based on the inputs it receives from the ________________
. A computer that is built into another device and used to control it is known as an ________________
. Computers are used to control many devices such as VCRs, washing machines and burglar alarms. ________________
control is when a computer system is used to manage the temperature of a room or building. Most cars contain many computers. These are used in systems such as ________________
and access control. Computers are used because they respond ________________
and do not get ________________
.
Look at this program which uses the REPEAT command. What shape will it draw ? A turtle is going to draw this shape : The turtle starts in the bottom right hand corner of the drawing area,
pointing towards the top of the area. The turtle is shown on the diagram
by a triangle, and the angles and lengths of sides are marked. It is more difficult to maintain ________________
when computers are connected to the ________________
. A ________________
can be used to monitor and restrict the data that flows between a home computer and the Internet. To let the ________________
of an email verify who has sent it you can add a ________________
to the end of it. This will also let the recipient check that the message has not been ________________
.
Write True or False by each of these statements. The most common backup method for a batch processing system is the ancestral system. This is also known as the ________________
system. After each batch of data is processed the ________________
and the transaction file are kept. The three most recent master files and transaction files are kept and known as the Grandfather, Father and ________________
generations. If the ________________
becomes corrupt then the most recent backup master and transaction files are processed again to ________________
the corrupt master file.
Write True or False by each of these statements. A format check is to be performed using an input mask. The input mask is 99990.00. Apply this input mask to the data in the table below. Write a V by data items which are valid and an I by data items which are invalid.
When data is input in ________________
, batch totals and ________________
can be used for validation. A batch total is a ________________
of the number of documents that data will be entered from. It is calculated ________________
by the user before input takes place. After the data has been input the system ________________
counts the number of items entered. If the manual and automatic totals do not match then a document has been ________________
or missed ________________
so the input data must be checked and changed. A hash total is more sophisticated. It is worked out by adding up all of the values in a particular ________________
on each input document. This is done by the user and by the system. If the two totals do not match then either the number of documents entered is incorrect or a mistake was made ________________
one of the values.
Write True or False by each of these statements. A virtual reality (VR) system places the user of a computer simulation in an ________________
created environment. The user must wear a ________________
and a data glove to interact with the computer. Because virtual reality systems must produce very high quality graphics they require a fast ________________
, a lot of ________________
and a large ________________
. Two possible applications of virtual reality systems are ________________
and a ________________
.
Write True or False by each of these statements. These system flowchart symbols each have a letter written on them. Below the symbols is a list of actions.
Write the letters from the symbols next to the actions that they represent. Programs written in a ________________
must be ________________
into ________________
before they can be executed. This can be done automatically by a compiler or an ________________
. A high level language that is commonly used in schools is ________________
. This language can be used to control the movement of a ________________
.
Write True or False by each of these statements. ________________
files are used to store video. They ________________
the data. This means that a whole film can fit on a ________________
. The most common type of file used to store music is ________________
. People often swap music on the ________________
using this file format. Swapping music like this is usually illegal as it is a breach of ________________
.
Write True or False by each of these statements. A customer can ________________
money from his bank account using an ATM. A debit or ________________
card must be inserted into the ATM and a numeric password known as a ________________
must be typed. The card number is read from the card using a ________________
reader. This information is sent to the bank's central computer using a ________________
and telephone line to be checked before the ATM can be used. The information will be ________________
before it is sent.
By each statement write the letter that is in the statement's place on the diagram.
Write TRUE or FALSE by each of these statements about loyalty cards. A feasibility study is carried out as part of the analysis stage of the systems
lifecycle. During this study information is collected about an existing
information system if there is one. This can be done using questionnaires,
interviews and observation. State one advantage and one disadvantage of each
method of collecting information. A ________________
sets out how you will determine whether or not your ________________
meets the ________________
that you set out in the ________________
. Testing should take place using typical, ________________
and erroneous data. For each test that will be carried out the test plan should contain an explanation of what the test will show, how it will be carried out and the ________________
that should be obtained if the test is passed.
Topic Sheet Mark Information 1 Information Systems 2 Hardware 3 Input Devices 4 Output Devices 5 Storage Devices 6 Processing 7 Software 8 Word Processing 9 Desktop Publishing 10 Graphics 11 Databases 12 Spreadsheets 13 Charting 14 Web Design 15 Multimedia 16 Operating Systems 17 Other Software 18 Comms Methods 19 Computer Networks 20 The Internet 21 E-Commerce 22 Global ICT Services 23 Data Logging 24 Control 25 Control Programs 26 Copyright and Hacking 27 Hacking 28 Health & Safety 29 Security 30 Backups 31 Viruses 32 Validate & Verify 33 Data Collection 34 Simulation & Models 35 User Interfaces 36 Algorithms & Charts 37 Programming 38 Data Transfer 39 Social Issues 40 Banking 41 Supermarkets 42 Systems Lifecycle 43
Information and Data Worksheet (1)
Name
Mark
Group
(1)
What is data ?
[1]
_____________________________________________________________________
(2)
What is information ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(3)
What is the difference between information and data ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(4)
Look at these six items. Some are data and some are information. By each item
state whether it is information or data. Write an "I" for information and a "D" for data.
[6]
Twig
__
The horse
__
The box is blue
__
The horse is a mammal
__
Albert & Jane
__
Information Technology is fun
__
(5)
Information can be either quantitative or qualitative.
(a)
Write down one piece of information which is quantitative.
________________________________________________________________
[1]
(b)
Write down one piece of information which is qualitative.
________________________________________________________________
[1]
(6)
Write true or false by each of these statements about coding data.
[5]
Statement True / False Coding data makes it easier to validate (check) it. Coding data can speed up typing it in. All codes use the numbers 0 and 1. Coding data can reduce how much space it takes up. All users must know the codes that a system uses.
(7)
George is designing a simple computer. He wants to be able to store
the letters A to H in its memory. George knows that the computer
will only really be able to store the numbers 0 and 1 and so he must
invent a code to let the computer store the letters. His code starts
like this :
[6]
Letter
Computer Code
Letter
Computer Code
A 000 E
B 001 F
C
G
D
H
Each of the codes will be made up of three digits. Complete the code.
(8)
Fill in the blanks in the following paragraph using the words below.
[7]
graph
who
purpose
output device
software
hard copy
facilities
(9)
Draw lines to link the words on the right hand side of the page with the correct definitions on the left hand side.
[6]
Information=Data+___________
* * Knowledge
The information, skills and experiences that have been learned by a human.
* * Context
Knowledge=Information+___________
* * Coding
Converting information into data that a computer can process and store.
* * Binary
Number system that stores numbers as 0s and 1s.
* * Processing
Standard coding system for representing letters and symbols.
* * ASCII
GCSE ICT Companion 04 - (C) P Meakin 2004
[36]
Information Systems Worksheet (2)
Name
Mark
Group
Hardware Worksheet (3)
Name
Mark
Group
(1)
What does a computer system do ?
[3]
_____________________________________________________________________
(2)
What is a hardware device ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(3)
What do you think is the significance of the direction that the arrows point in on a block diagram ?
[1]
_____________________________________________________________________
(4)
This is a block diagram of a computer system. Some of the labels are missing and are represented
on the diagram by blue letters. The missing labels are written below. Write each letter by
the label that should be in its place.
[6]
__
Modem
__
Magnetic Tape
__
Mouse
__
Hard Disk
__
Computer
__
Printer
(5)
Explain the following terms
(a)
Input Device
________________________________________________________________
________________________________________________________________
[1]
(b)
Output Device
________________________________________________________________
________________________________________________________________
________________________________________________________________
[1]
(c)
Input/Output Device
________________________________________________________________
________________________________________________________________
[1]
(6)
Here is a list of some peripherals that could be connected to a computer. Place a tick before the
ones that are output devices.
[2]
Modem
Scanner
Tracker Ball
Laser Printer
CD-ROM
Keyboard
Mouse
RAM
Joystick
Monitor
(7)
What else is necessary before computer hardware is useful ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(8)
Here is a list of the different types of computer. Write the numbers 1 to 3 in the
column next to the list. Put the 1 by the computer type which can be used by the
most users at once, the 3 by the computer type which can be used by the least users at
once and the 2 by the other type.
[3]
Computer Type Users Order Mainframe Minicomputer Microcomputer
(9)
Fill in the blanks in the following paragraph using the words below.
[6]
PDA
microprocessor
embedded systems
laptop
desktop
upgraded
GCSE ICT Companion 04 - (C) P Meakin 2004
[26]
Input Devices Worksheet (4)
Name
Mark
Group
(1)
What does an input device do ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(2)
There are two different categories of input devices. What are they ?
[2]
(a)
________________________
(b)
________________________
(3)
Here is a list of some peripherals that could be connected to a computer. Place a tick before the ones that are input devices.
[5]
Mouse
V.D.U.
Scanner
O.M.R.
Laser Printer
Keyboard
CD-ROM
Processor
RAM
Joystick
(4)
A cafeteria is replacing its tills. The old tills used numeric keyboards. The waiters and waitresses had to manually enter the prices of the items that they sold. The new tills will have concept
keyboards with an overlay which has separate buttons for each product that the cafe sells.
(a)
Why is a concept keyboard particularly suitable for this application ?
________________________________________________________________
________________________________________________________________
[2]
(b)
Identify two advantages for the customers and employees that the new tills will provide.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(5)
(a) For which type of user interface is a mouse the most common input device ? [3]
________________________________
What alternative input devices could be used for this type of interface instead of a mouse ?
(b)
________________
(c)
________________
(6)
An estate agent produces brochures containing pictures of the houses that he is selling. At the moment the pictures are taken by a photographic camera and glued onto the brochures after they are
printed. The estate agent wants to use his DTP package to put the photographs onto the brochures electronically before they are printed. He is considering buying either a scanner or a digital camera
to transfer house photographs onto his computer.
(a)
Which device would be best for this job ?
________________________________________________________________
[1]
(b)
Why would the device you named in part (a) be best ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(7)
(a)
What information is stored in a barcode attached to a product that is for sale in a supermarket ?
________________________________________________________________
[3]
(b)
Why do you think that the price is not stored in the barcode ?
________________________________________________________________
________________________________________________________________
[1]
(8)
What are the main differences between smart cards and magnetic stripe cards ?
[3]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(9)
Fill in the blanks in the following paragraph using the words below.
[5]
handwritten
scanner
software
OCR
typed
(10)
What do these five acronyms stand for ?
[5]
DDE
____________________________
OMR
____________________________
MICR
____________________________
MIDI
____________________________
PDET
____________________________
(11)
What is a turnaround document ?
[3]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(12)
Draw lines to link the words on the right hand side of the page with the correct uses on the left hand side.
[11]
Inputs music directly from a musical instrument.
* * MIDI
Storing account details on a credit card.
* * Joystick
Entering product codes at a shop checkout.
* * Magnetic Stripe
Piloting an aircraft in a flight simulator.
* * Tracker Ball
Transferring video sequences into a computer.
* * Barcode
Controlling a pointer on a laptop computer.
* * OMR
Using a public information service in an airport
* * Touch Screen
Inputting answers to a multiple choice exam.
* * MICR
Storing account information on a cheque.
* * Video Digitiser
Recognises a unique physical characteristic of a person.
* * Remote Control
Used to control a device from a distance.
* * Biometric
GCSE ICT Companion 04 - (C) P Meakin 2004
[49]
Output Devices Worksheet (5)
Name
Mark
Group
(1)
What does an output device do ?
[1]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(2)
Write down two advantages of using a desktop monitor and two advantages of using a liquid crystal display for producing soft copy output.
[4]
Advantages of Desktop Monitor
Advantages of LCD
__________________________
__________________________
__________________________
__________________________
__________________________
__________________________
__________________________
__________________________
__________________________
__________________________
__________________________
__________________________
(3)
What is resolution ?
[1]
_____________________________________________________________________
(4)
(a)
Identify two advantages of a dot matrix printer.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Identify one disadvantage of a dot matrix printer.
________________________________________________________________
[1]
(5)
Here is a list of some output devices. Place a tick before the ones that can produce high quality colour output.
[4]
Laser Printer
L.C.D.
Loudspeaker
Dot Matrix Printer
Drum Plotter
Ink Jet Printer
(6)
Here is a list of some hard copy output devices. Write the numbers 1 to 3 in the column next to the list. Put the 1 by the device which produces output fastest and the 3 by the slowest device.
[3]
Device Speed Order Laser Printer Plotter Ink Jet Printer
(7)
Draw lines to link the words on the right hand side of the page with the correct statements on the left hand side.
[5]
Prints by heating up special paper.
* * Dot Matrix
A page is held fixed and a pen draws on it
* * Thermal
Good choice for most home computer users.
* * Laser
Prints by hammering pins against a ribbon.
* * Flatbed Plotter
The only page printer.
* * Ink Jet
(8)
What do these four acronyms stand for ?
[4]
LCD
____________________
VDU
____________________
PPM
____________________
CPS
____________________
(9)
Draw lines to link the words on the right hand side of the page with the correct situations on the left hand side.
[7]
To print digital camera photographs.
* * Plotter
To print on a network of 30 computers.
* * LCD
To print architectural plans for buildings.
* * Laser Printer
To produce a synthesized voice.
* * Ink Jet Printer
To display soft copy images on a laptop.
* * COM
To store data on microfilm.
* * MIDI
To playback music on a musical instrument.
* * Voice Synthesizer
(10)
Identify and explain three different things you would consider to help you decide which type of printer to buy.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
GCSE ICT Companion 04 - (C) P Meakin 2004
[35]
Storage Devices Worksheet (6)
Name
Mark
Group
(1)
What two distinct things must a computer be able to store ?
[2]
(a)
_______________________
(b)
_______________________
(2)
What are the two different types of storage that a computer will have ?
[2]
(a)
_______________________
(b)
_______________________
(3)
What type of numbers does a computer store data as ?
[1]
_____________________________________________________________________
(4)
A computer is described as having a 120Gb hard disk drive. How many megabytes is this equivalent to ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(5)
What are the two different types of Immediate Access Store ?
[2]
(a)
_______________________
(b)
_______________________
(6)
What is ROM, and what is it used for ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(7)
What is backing store used for ?
[1]
_____________________________________________________________________
(8)
Hard disks and floppy disks are two different types of magnetic disk. Identify three differences between a hard disk and a floppy disk.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(9)
Name one type of optical disk that can not have data written to it.
[1]
_____________________________________________________________________
(10)
What are the main applications that magnetic tape is used for ?
[2]
(a)
_______________________
(b)
_______________________
(11)
Fill in the blanks in the following paragraph using the words below.
[5]
Random Access Memory
Backing Store
Read Only Memory
Optical Disks
Immediate Access Store
(12)
Draw lines to link the words on the right hand side of the page with the correct applications on the left hand side.
[5]
A multimedia 'book'.
* * ROM
Storing a program to be used in an embedded system in a video recorder.
* * Magentic Tape
Taking backups of a hard disk drive.
* * CD ROM
Storing photographs in a digital camera.
* * Floppy Disk
Copying files from a computer at home to a computer at school.
* * Flash Memory
(13)
Write true or false by each of these statements about caching.
[5]
Statement True / False Caching is a technique used to speed up access to data on a backing storage device. A cache stores data in RAM. Data in a cache remains there permanently. Copies of frequently accessed disk sectors are stored in cache. Caching can only be used with optical disks.
(14)
Explain the following terms.
(a)
Random/Direct Access
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Serial Access
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(c)
Sequential Access
________________________________________________________________
________________________________________________________________
[1]
(15)
(a)
What is compression ?
________________________________________________________________
________________________________________________________________
[2]
(b)
What two factors will affect how much a file can be compressed by ?
________________________________________________________________
________________________________________________________________
[2]
(16)
Software companies often compress computer packages before they are distributed.
(a)
Give two advantages of compressing data in this situation.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Give one disadvantage of compressing data in this situation.
________________________________________________________________
________________________________________________________________
[1]
(17)
Draw lines to link the words on the right hand side of the page with the correct descriptions on the left hand side.
[3]
Putting the records in a file into a particular order.
* * Merging
Combining records in two different files into one file.
* * Sorting
Putting the records in one file at the end of another file.
* * Appending
GCSE ICT Companion 04 - (C) P Meakin 2004
[48]
Processing Worksheet (7)
Name
Mark
Group
(1)
What is processing ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(2)
What are the three different types of processing ?
[3]
(a)
_____________
(b)
_____________
(c)
_____________
(3)
What hardware device carries out the processing in a computer system ?
[1]
_____________________________________________________________________
(4)
What type of computer is unlikely to contain more than one microprocessor ?
[1]
_____________________________________________________________________
(5)
Fill in the blanks in the following paragraph using the words below.
[5]
New Master File
Transaction
Validated
Batch
Error Report
(6)
What storage medium is usually used in batch processing systems ?
[1]
_____________________________________________________________________
(7)
Identify (a) an advantage and (b) a disadvantage of batch processing.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
(8)
(a)
In what type of situation must a transaction processing system be used ?
________________________________________________________________
[1]
(b)
Give an example of a situation in which transaction processing must be used and explain why transaction processing is required.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(9)
Fill in the blanks in the following paragraph using the words below.
[4]
Queue
One
Completed
Order
(10)
(a)
Under a normal workload, how quickly would you expect a transaction processing system to process a transaction ?
________________________________________________________________
[1]
(b)
Under heavy workloads transaction processing systems may slow down. What type of processing must be used when this is not acceptable ?
________________________________________________________________
[1]
(11)
What type of access must a transaction processing system have to the storage device it uses ?
[1]
_____________________________________________________________________
(12)
What is a real time system ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(13)
Real time systems are very expensive. Why do you think this is the case ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(14)
Identify three different situations in which real time processing is used.
[3]
(a)
_____________
(b)
_____________
(c)
_____________
(15)
Draw lines to link the words on the right hand side of the page with the correct computer applications on the left hand side.
[4]
Monitoring the heartbeat of a patient in intensive care and alerting nurses if it becomes unstable.
* * Batch
Looking up the registration numbers of (possibly) stolen vehicles on the Police National Computer (PNC).
* * Transaction
Marking multiple-choice exam papers using Optical Mark Recognition.
* * Real Time
Controlling a reaction in a chemical processing plant.
* * Real Time
GCSE ICT Companion 04 - (C) P Meakin 2004
[35]
Software Worksheet (8)
Name
Mark
Group
(1)
What is software ?
[1]
_____________________________________________________________________
(2)
How is software produced ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(3)
Define these terms :
(a)
Systems Software
________________________________________________________________
________________________________________________________________
[1]
(b)
Application Software
________________________________________________________________
________________________________________________________________
[1]
(4)
This 'family tree' of computer software shows how the various packages and types of software are related. Some of the labels are missing and are represented on the diagram by blue numbers. The missing labels are written below.
[4]
__
Desktop Publisher
__
Utility Programs
__
Application Software
__
Generic
(5)
Draw lines to link the words on the right hand side of the page with the correct tasks on the left hand side.
[5]
Storing details of the members of a club.
* * Spreadsheet
Calculating the cost of a shopping bill.
* * Word Processor
Typing an essay.
* * DTP
Drawing a graph.
* * Database
Producing a school newsletter.
* * Spreadsheet
(6)
A school is updating its computer software. The school needs a new word processor and a new database package. The school can buy either :
(a)
Suggest two advantages of buying the integrated package.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Suggest one possible advantage of buying two separate packages.
________________________________________________________________
________________________________________________________________
[1]
(7)
A company that sells clothing is setting up an information system to store details of its customers. No 'off-the-shelf' package suits the companies requirements so it must either :
(a)
Suggest two advantages of the first solution.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Suggest one advantage of the second solution.
________________________________________________________________
________________________________________________________________
[1]
GCSE ICT Companion 04 - (C) P Meakin 2004
[20]
Word Processing Worksheet (9)
Name
Mark
Group
(1)
What is a word processor used for ?
[1]
_____________________________________________________________________
(2)
What alternative package can be used instead of a word processor if more sophisticated presentation tools are required ?
[1]
_____________________________________________________________________
(3)
Look at this diagram showing the layout of a page in a document.
(a)
What orientation is the page in ?
________________________________________________________________
[1]
(b)
What name is given to the area shaded in light grey ?
________________________________________________________________
[1]
(c)
What is the name given to the text which will appear at the position that is shaded in dark grey on every page in the document ?
________________________________________________________________
[1]
(4)
Give two reasons why it is important to leave a left margin on the page when you produce a document.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(5)
Identify as many differences as you can between the presentation of these two words.
[4]
_____________________________________________________________________
_____________________________________________________________________
(6)
What is alignment ?
[1]
_____________________________________________________________________
(7)
(a)
What will a spelling checker do if it finds a spelling mistake ?
________________________________________________________________
________________________________________________________________
[2]
(b)
Give an example of a mistake which a spelling checker would not identify. Explain why it would not be identified.
________________________________________________________________
________________________________________________________________
[2]
(8)
Explain how a company could benefit from using templates to produce documents.
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(9)
(a)
In addition to a word processor, what other package is also usually needed to perform a mailmerge ?
________________________________________________________________
[1]
(b)
Explain what a mailmerge is.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[3]
(10)
Some word processors will automatically calculate statistics about the document that you are editing and display them on the screen. Suggest two different statistics that a word processor might provide you with.
[2]
(a)
_______________________
(b)
_______________________
GCSE ICT Companion 04 - (C) P Meakin 2004
[24]
Desktop Publishing Worksheet (10)
Name
Mark
Group
(1)
Describe four features that you would expect to find in a desktop publisher that you would not find in a word processor.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(d)
________________________________________________________________
[1]
(2)
(a)
What is a frame ?
________________________________________________________________
________________________________________________________________
[2]
(b)
Why can text frames be linked ?
________________________________________________________________
________________________________________________________________
[2]
(3)
(a)
What is importing ?
________________________________________________________________
________________________________________________________________
[1]
(b)
Give two reasons why you might want to import information into a desktop publisher.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(4)
What is a guideline, and what does a guideline do ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(5)
These four tasks could be carried out using either a desktop publisher or a word processor. Place a tick next to the two tasks that you think would benefit most from the use of a desktop publisher instead of a word processor.
[2]
Activity Tick Writing an essay for school. Producing a poster to advertise a club. Writing a letter to a newspaper. Creating a menu for a cafe.
(6)
Choose one of the tasks you have ticked in question (5) and explain why it would benefit from being produced by a desktop publisher.
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(7)
Explain what a wizard is and give an example of a task that you might use a wizard for.
[3]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
GCSE ICT Companion 04 - (C) P Meakin 2004
[20]
Graphics Worksheet (11)
Name
Mark
Group
(1)
A graphic designer has been employed to produce twelve pictures to illustrate a childrens book. The designer could produce the pictures using traditional methods such as paints and pencils or use a
computer graphics package instead.
(a)
Suggest two reasons why the designer might prefer to use the graphics package.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Suggest two reasons why the designer might prefer to produce the drawings using paint and canvas.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(2)
What are the three different types of computer graphics package ?
[3]
(a)
_____________
(b)
_____________
(c)
_____________
(3)
Suggest three input devices that would be useful in a computer system used to produce graphics but that wouldn't be included in a standard computer system.
[3]
(a)
_____________
(b)
_____________
(c)
_____________
(4)
Draw lines to link the words on the right hand side of the page with the correct descriptions on the left hand side.
[4]
Lets you draw on screen by moving pointer.
* * Palette
Used to select the colour to draw with.
* * Flood Fill
Lets you enlarge the image to see it in more detail.
* * Zoom
Fills an area of the screen with the current colour.
* * Freehand Brush
(5)
What is a bitmap file, and how does a bitmap file store data ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(6)
Identify two disadvantages of using a painting package to produce an image compared to producing the same image using a drawing package.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(7)
Why are graphics files created by painting packages often compressed ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(8)
Here is a list of some of the tools that would be provided by a painting package. Place a tick next to the one that would not also be provided by a drawing package.
[1]
Shapes Text Flood Fill Zoom
(9)
Write true or false by each of these statements.
[4]
Activity True? When enlarged, images produced by a drawing package will
look pixelated/jagged. Drawing packages are the most expensive type of graphics package. A drawing package stores images by remembering the properties of the objects that make up the image. Drawing packages are used to design three dimensional objects.
(10)
Explain how objects may be accurately positioned when a drawing package is in use.
[3]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(11)
What do these two acronyms stand for ?
[2]
CAD
____________________
CAM
___________________________
(12)
Name two features that would be provided by a CAD package that would not be provided by any other type of graphics package.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
GCSE ICT Companion 04 - (C) P Meakin 2004
[31]
Databases Worksheet (12)
Name
Mark
Group
(1)
What is a database ?
[1]
_____________________________________________________________________
(2)
You may encounter two different types of database. What are they ?
[2]
(a)
_______________________
(b)
_______________________
(3)
You are creating a database with a flat file database package. What is the maximum number of files/tables that the database can contain ?
[1]
_____________________________________________________________________
(4)
Define these important database terms.
[3]
File
_________________________________________________
_________________________________________________
Record
_________________________________________________
_________________________________________________
Field
_________________________________________________
_________________________________________________
(5)
Fill in the blanks in the following paragraph using the words below.
[6]
Key
Fixed
Structure
Alphanumeric
Type
Primary
(6)
What is the purpose of a key field ?
[1]
_____________________________________________________________________
(7)
Write true or false by each of these statements about defining records in a database.
[4]
Statement True / False The Boolean data type stores true or false values. A fixed length field can store a data item however long it is. Using fixed length fields makes it easy to update records. The alphabetic data type can store letters and numbers.
(8)
Data stored in a database field can be coded.
(a)
Identify two advantages of coding data.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Identify one disadvantage of coding data.
________________________________________________________________
________________________________________________________________
[1]
(9)
List the three different operations that can be carried out when data is entered into a database.
[3]
(a)
_____________
(b)
_____________
(c)
_____________
(10)
[5]
Field Name Data Type Length Example Item Name Alphanumeric Fixed - 25 Baked Beans
(11)
Draw lines to link the words on the right hand side of the page with the correct descriptions on the left hand side.
[8]
Putting records into an order.
* * Importing
Bringing data into a database from another package.
* * Sorting
Performing checks to ensure that data entered into a database is sensible.
* * Validation
Searching through a database to find records that match particular criteria.
* * Relationship
A link between two files/tables in a relational database.
* * Form
A short sequence of instructions used to automate a task.
* * Query
Another name for a file.
* * Macro
Database feature that lets users enter and view data easily.
* * Table
(12)
A school is going to store information about its students in a database.
So far the following records have been entered :
Pupil No Surname Gender Form 01 Marshall M 5RM 02 Jones F 5SB 03 Toomer M 4UU 04 Burns M 5RM 05 Wright F 4UU 06 Critchley F 5SB
By writing down the appropriate Pupil Nos, list the records that will be
found by each of these queries :
(a) Form = "5SB"
______________________________________________________________
[1]
(b) NOT Form = "4UU"
______________________________________________________________
[1]
(c) Gender = "M" AND Form = "4UU"
______________________________________________________________
[1]
(d) Form = "4UU" OR Form = "5SB"
______________________________________________________________
[1]
(13)
Registration No.
Make
Model Engine Size
Colour
No of Doors Fuel Type
Date Registered
Sale Price
(a) Which of these fields could be used as the primary key field ?
______________________________________________________________
[1]
(b) The Date Registered field
is used to store the date that the car was first registered or driven in the UK.
Why is the date registered stored instead of the age of the car ?
______________________________________________________________
______________________________________________________________
[1]
(c) Write queries which will
answer each of these questions. The first one has been done for you.
(i) What Ford cars are for sale ?
Make = "Ford"
(ii) What Peugeot cars are for sale ?
______________________________________________________________
[1]
(iii) What blue cars are for sale ?
______________________________________________________________
[1]
(iv) What cars are for sale that cost less that £5000 ?
______________________________________________________________
[1]
(v) What four door diesel cars are for sale ?
______________________________________________________________
[3]
(d) A salesman is
printing out a report listing twelve cars that meet a customer's
requirements.
(i) What order might the salesman sort the cars into to help the customer ?
______________________________________________________________
[1]
(ii) Would the list be printed as a tabular or a columnar report ?
______________________________________________________________
[1]
(14)
Two important advantages of using a relational database instead of a flat file database are control over data redundancy and eliminating data inconsistency. Explain these two terms :
(a)
Data Redundancy
________________________________________________________________
________________________________________________________________
[2]
(b)
Data Inconsistency
________________________________________________________________
________________________________________________________________
[2]
GCSE ICT Companion 04 - (C) P Meakin 2004
[55]
Spreadsheets Worksheet (13)
Name
Mark
Group
(1)
What are the two main purposes for which a spreadsheet package is used ?
[2]
(a)
________________________
(b)
________________________
(2)
Define these important spreadsheet terms.
[4]
Cell
________________________________________________
Row
________________________________________________
Cell
Reference
______________________________________________
______________________________________________
Range
______________________________________________
______________________________________________
(3)
(a)
Give an example of a task that you might use a spreadsheet to complete.
________________________________________________________________
________________________________________________________________
[1]
(b)
Explain why the spreadsheet package is suitable for this task.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(4)
What three types of data can be entered into a spreadsheet cell ?
[3]
(a)
____________
(b)
____________
(c)
____________
(5)
What is the purpose of each of these two functions ?
[2]
SUM
_________________________________________________
_________________________________________________
AVG
_________________________________________________
_________________________________________________
(6)
Why is it useful to be able to replicate formulae ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(7)
Suggest how a cell containing the total price of a meal in a restaurant might be formatted.
[2]
_____________________________________________________________________
(8)
(a) Which cell contains the
number £1.60 ?
______________________________________________________________
[1]
(b)
surrounded by a box like this :
______________________________________________________________
[2]
(c) What are the
numbers in the column labelled Quantity used for ?
______________________________________________________________
[2]
(d) Jenny wants to work
out how much money she spends in total each week.
(i) Into which cell should the formula to calculate the total be placed ?
______________________________________________________________
[1]
(ii) What should the formula be ?
______________________________________________________________
[2]
(9)
(a)
What is a macro ?
________________________________________________________________
________________________________________________________________
[2]
(b)
When would you use a macro ?
________________________________________________________________
[1]
(10)
Explain how you would go about testing whether or not the formulae in a spreadsheet that you have created work.
[3]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(11)
Draw lines to link the words on the right hand side of the page with the correct definitions on the left hand side.
[8]
A cell reference that changes when it is copied to another part of a spreadsheet.
* * Relative Reference
A cell reference that stays the same when it is copied to another part of a spreadsheet.
* * Fill Series
How data in a cell is presented. e.g. alignment, font and style.
* * Database
How data is presented. e.g. 2d.p., currency,percentage, date.
* * Data Format
Type of spreadsheet function which can look up data in a table.
* * Absolute Reference
Type of spreadsheet function that can take decisions based on data.
* * Cell Format
Putting data into an order.
* * Sorting
Spreadsheet function used to generate sequences such as 1,2,3,...
* * Condition
GCSE ICT Companion 04 - (C) P Meakin 2004
[40]
Charting Worksheet (14)
Name
Mark
Group
(1)
Why is numerical information often presented as a chart ?
[1]
_____________________________________________________________________
(2)
Apart from a specialised charting package, what other piece of software can usually draw charts ?
[1]
_____________________________________________________________________
(3)
Here are two different types of chart. Write the name of each type underneath the chart.
[2]
Name
________________________
Name
________________________
(4)
Draw lines to link the words on the right hand side of the page with the correct situtations to use the charts in on the left hand side.
[4]
Showing the results of a science experiment investigating the temperature of a liquid as it cools.
* * Pie
Showing the results of a survey to investigate the relationship between a person's height and shoe size.
* * Bar
Showing the number of hours of sunshine in each month of a year.
* * Scatter
Showing how a family divides its weekly spending up into categories such as food, transport, clothing etc.
* * Line
(5)
(a)
What type of chart can have a best fit line drawn on it ?
________________________________________________________________
[1]
(b)
What is the purpose of a best fit line ?
________________________________________________________________
________________________________________________________________
[1]
(6)
Draw lines to link the words on the right hand side of the page with the correct terms and definitions on the left hand side.
[5]
The axis that runs vertically up the side of a chart.
* * Legend
A key used to distinguish between two different sets of data on the same chart.
* * Scale
The axis that runs horizontally along the bottom of a chart.
* * Y Axis
A label at the top of a chart which states the purpose of the chart.
* * X Axis
The range of numbers that will be plotted on a chart.
* * Title
(7)
Sometimes it is more useful to present numerical information as a table of numbers instead of a chart. Suggest one advantage of presenting numbers in a table instead of a chart.
[1]
_____________________________________________________________________
_____________________________________________________________________
GCSE ICT Companion 04 - (C) P Meakin 2004
[16]
Web Design Worksheet (15)
Name
Mark
Group
(1)
What is meant by the term 'web site structure' ?
[1]
_____________________________________________________________________
(2)
Web site designers usually attempt to make all of the pages at a web site look similar so that they can be clearly identified as belonging together. State three methods that can be used to achieve
this.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(3)
Why is it usually better to use a predefined text style instead of a particular font when including text on a web page ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(4)
Why shouldn't you underline text on a web page ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(5)
(a)
Why are images on web pages usually stored in a compressed format ?
________________________________________________________________
________________________________________________________________
[2]
(b)
What format is usually used to store photographs to be included on a web page ?
________________________________________________________________
[1]
(6)
Identify these two different types of controls that can be used on forms.
[2]
Type
________________________
Type
________________________
(7)
Why are frames used ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(8)
Draw lines to link the words on the right hand side of the page with the correct definitions on the left hand side.
[7]
A link between two web pages which can be clicked on.
* * Hyperlink
File format used to store icons and banners for web pages.
* * Form
The process of putting a web page that you have created onto a web server.
* * GIF
Tool which can be used to create multi-column page layouts.
* * Uploading
An area of an image that acts as a hyperlink.
* * Hotspot
Tool which lets a person looking at a web page provide feedback to the page's owner.
* * Table
Programming language which can be used to write programs to run in a web browser.
* * Java
Multimedia Worksheet (16)
Name
Mark
Group
(1)
What does the term multimedia mean ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(2)
Identify three hardware devices that would be necessary in a multimedia computer.
[3]
(a)
_______________
(b)
_______________
(c)
_______________
(3)
Choose one of the hardware devices that you have identified in (2) and explain why it is needed.
[1]
_____________________________________________________________________
_____________________________________________________________________
(4)
(a)
Identify one storage medium that a multimedia program could be provided on.
________________________________________________________________
[1]
(b)
Explain why this medium is appropriate.
________________________________________________________________
________________________________________________________________
[2]
(5)
Identify two applications of multimedia software.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(6)
Encyclopaedias can be provided as either multimedia applications or as printed books.
(a)
Identify two advantages of providing an encyclopaedia as a multimedia application.
________________________________________________________________
________________________________________________________________
[2]
(b)
Identify two advantages of providing an encyclopaedia as a printed book.
________________________________________________________________
________________________________________________________________
[2]
GCSE ICT Companion 04 - (C) P Meakin 2004
[15]
Operating Systems Worksheet (17)
Name
Mark
Group
(1)
Fill in the blanks in the following paragraph using the words below.
[4]
MS DOS®
System
Hardware
Application
(2)
The operating system will determine the type of user interface that a computer uses. What else will it determine ?
[1]
_____________________________________________________________________
(3)
State four tasks which are carried out by all operating systems.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(d)
________________________________________________________________
[1]
(4)
Identify and explain two situations in which the operating system must manage communications between the computer and connected peripherals.
(a)
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(5)
What are the three different types of user interface that an operating system might provide ?
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(6)
[10]
Statement True / False The data is organised hierarchially. "Chess" is a subdirectory of "Games". The root directory contains four other directories. Directories can be stored within files. "Games" is a subdirectory of "Chess". Files can be stored within directories. "History" is a directory. "RainType.cdr" is a directory. Folder is another name for a directory. Organising data like this makes it easy to find files.
(7)
Explain the following terms.
(a)
Network Operating System
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Multi-Tasking Operating System
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(c)
Multi-User Operating System
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(8)
Give an example of a task that a network operating system would carry out that would not be carried out by an operating system on a non-networked computer.
[1]
_____________________________________________________________________
(9)
Multi-tasking operating systems are also known by another name. What is it ?
[1]
_____________________________________________________________________
(10)
A multi-user operating system divides processing time up into time slices.
(a)
What is a time slice ?
________________________________________________________________
________________________________________________________________
[1]
(b)
These time slices are very short. Why do you think this is the case ? [ Hint : Consider what would happen if the time slices were long. ]
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(11)
Draw lines to link the words on the right hand side of the page with the correct descriptions of operating systems on the left hand side.
[4]
Processes data in batches. There may be a long time delay between data being input into the system and the data being processed.
* * Interactive
Carries out communication with the user as a dialogue.
* * Batch
Allows the user of a computer to interact directly with another central computer.
* * Real Time
Can process data very quickly to meet a real world deadline. Often used in embedded systems.
* * On Line
GCSE ICT Companion 04 - (C) P Meakin 2004
[41]
Other Software Worksheet (18)
Name
Mark
Group
(1)
State three reasons why people like to play computer games.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(2)
Name three different types of device that computer games can be played on.
[3]
(a)
_____________
(b)
_____________
(c)
_____________
(3)
Draw lines to link the words on the right hand side of the page with the correct descriptions on the left hand side.
[3]
Storage medium that many computer games are provided on.
* * Joystick
Device often used to control the movement of a character in a game.
* * Internet
System used to allow people at different locations to play each other.
* * CD ROM
(4)
Identify two advantages of using a CAL system.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
(5)
Identify one disadvantage of using a CAL system.
[1]
_____________________________________________________________________
_____________________________________________________________________
(6)
Fill in the blanks in the following paragraph using the words below.
[5]
SatNav
CD ROM
map
speech synthesis
satellites
(7)
What is meant by the term 'expert system' ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(8)
Identify (a) one advantage of using an expert system and (b) one advantage of using a human expert.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
GCSE ICT Companion 04 - (C) P Meakin 2004
[21]
Communication Methods Worksheet (19)
Name
Mark
Group
(1)
What is communication ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(2)
Identify three factors that you would consider when deciding what method to use to communicate some information to a person living in another country.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(3)
Here is a list of some communication methods. Place a tick before the ones that are suitable for broadcast communications.
[2]
Email
Teletext
Telephone
Fax
Post
Digital TV
(4)
(a)
Why will electronic communication methods such as email and fax never completely replace the traditional postal service ?
________________________________________________________________
________________________________________________________________
[1]
(b)
Why is the postal service sometimes known as 'snail mail' ?
________________________________________________________________
________________________________________________________________
[1]
(5)
State three factors that usually affect the cost of a telephone call.
[3]
(a)
_____________
(b)
_____________
(c)
_____________
(6)
(a)
Give one advantage of a cellular telephone over an ordinary telephone.
________________________________________________________________
[1]
(b)
Give one advantage of an ordinary telephone over a cellular telephone.
________________________________________________________________
[1]
(7)
(a)
Give one advantage of sending a printed document by fax instead of post.
________________________________________________________________
[1]
(b)
Give one advantage of sending a printed document by post instead of fax.
________________________________________________________________
[1]
(8)
Fill in the blanks in the following paragraph using the words below.
[8]
Parcels
Network
Quickly
Electronic Mail
Low
Address
Internet
Mailbox
(9)
(a)
What is teletext ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[3]
(b)
Why do you have to wait for a teletext page to be displayed?
________________________________________________________________
[1]
(10)
State three advantages of digital television over traditional analogue television.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(11)
Draw lines to link the words on the right hand side of the page with the correct descriptions on the left hand side.
[6]
System that sends spoken information by radio wave.
* * Cellular Telephone
Can transmit more channels at once than analogue TV.
* * Teletext
Stores messages in a mailbox.
* * Video Conferencing
Sends moving images via the telephone network.
* * Fax
Sends printed documents via the telephone network.
* * Digital TV
Used to display subtitles for television programmes.
* * Email
(12)
Here is a list of some communication methods. You need to rank the methods according to the proportion of the UK population that has access to them. Put a number one by the method which most people have access to and a number 4 by the meth
[4]
Device Access Order Post Email Telephone Cellular Telephone
GCSE ICT Companion 04 - (C) P Meakin 2004
[41]
Networks Worksheet (20)
Name
Mark
Group
(1)
What is a computer network ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(2)
Explain these two terms.
(a)
LAN
________________________________________________________________
________________________________________________________________
[2]
(b)
WAN
________________________________________________________________
________________________________________________________________
[2]
(3)
Identify two important differences between a LAN and a WAN.
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(4)
Write LAN or WAN by the descriptions of these four computer systems to identify whether the network is most likely to be a LAN or WAN.
[4]
System LAN/WAN ? A network of cash dispensers. The stock control system for a nationwide supermarket. The appointments system in a doctors' surgery. The network of ticket machines used to sell lottery tickets.
(5)
Computers are usually connected to a LAN using a Network Interface Card and some cable.
(a)
Identify two different types of cable that could be used.
________________________________________________________________
[2]
(b)
Computers can also be connected to a LAN by radio. State an advantage of connecting a computer to a LAN using radio instead of cable.
________________________________________________________________
________________________________________________________________
[1]
(6)
Three methods of connecting a computer to a WAN are using a modem and telephone line, using a terminal adaptor and ISDN channel and using broadband.
(a)
What does a modem do ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Does a signal travel down a telephone line in analogue or digital form ?
________________________________________________________________
[1]
(c)
Does a signal travel down an ISDN channel in analogue or digital form ?
________________________________________________________________
[1]
(d)
What units are used to measure the speed at which data travels down a telephone line or ISDN channel ?
________________________________________________________________
[1]
(e)
Give one advantage of using ISDN instead of a telephone line and modem.
________________________________________________________________
[1]
(f)
Give one advantage of using a telephone line and modem instead of ISDN.
________________________________________________________________
[1]
(g)
Give two advantages of using broadband over ISDN or a modem and telephone line.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(7)
This is a list of the three most common methods of connecting to a WAN. Write the numbers 1 to 3 next to the list. Put the 1 by the method that provides the fastest communication speed, 2 by the second fastest and 3 by the slowest.
[3]
Method Speed Order ISDN Using 2 Channels Modem and Telephone Line Broadband
(8)
Fill in the blanks in the following paragraph using the words below.
[7]
Peer to Peer
Printer
Username
File
Secure
Local Area
Queue
Server Based
Password
(9)
Look at these two diagrams showing different network topologies. Under each
diagram write the name of the topology and an advantage and disadvantage of
the topology.
[6]
Name
_____________________
Name
_____________________
Adv
____________________
____________________
____________________
Adv
____________________
____________________
____________________
Dis
____________________
____________________
____________________
Dis
____________________
____________________
____________________
(10)
What is the difference between a bridge and a gateway ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(11)
Draw lines to link the words on the right hand side of the page with the correct descriptions on the left hand side.
[5]
Device which decides which route to send data down in a complex network.
* * Backbone
Type of light used to send data slowly over short distances.
* * Router
The main cable in a network.
* * Infra Red
Device used to connect computers to the main cable in a network.
* * Hub
Wireless communication method that sends data through space.
* * Satellite
(12)
State two reasons why it is harder to keep data secure on a networked computer than on a standalone system.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
(13)
Name two methods that can help keep data on a network secure.
[2]
_____________________________________________________________________
(14)
Identify two advantages of connecting a group of computers in an office using a computer network.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
Identify one disadvantage of connecting a group of computers in an office using a computer network.
(c)
________________________________________________________________
[1]
GCSE ICT Companion 04 - (C) P Meakin 2004
[54]
Internet Worksheet (21)
Name
Mark
Group
(1)
List five items that you need to gain access to the Internet.
[5]
(a)
____________________________________________________
(b)
____________________________________________________
(c)
____________________________________________________
(d)
____________________________________________________
(e)
____________________________________________________
(2)
A small company is considering investing in an electronic mail system.
(a)
Identify two advantages of using electronic mail instead of the normal post system.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Identify two disadvantages of using electronic mail instead of the normal post system
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(3)
Draw lines to link the words on the right hand side of the page with the correct descriptions on the left hand side.
[5]
Unwanted messages such as adverts.
* * Digital Signature
List of people who's email addresses you keep.
* * Address Book
Method used to identify the sender of an email.
* * SPAM
File sent with an email.
* * Inbox
Where newly received messages are stored.
* * Attachment
(4)
You are working on a geography project about volcanoes.
(a)
Outline two advantages of using a printed encyclopaedia to find out about volcanoes.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Outline two advantages of using a search engine on the World Wide Web to find out about volcanoes.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(5)
Draw lines to link the words on the right hand side of the page with the correct descriptions on the left hand side.
[7]
Web page that acts as a starting point to obtain information.
* * HTML
Special language used to produce web pages.
* * History
List of web pages that you have visited recently.
* * Search Engine
Site used to find information on the web.
* * Hyperlink
Text that you click on to move between two web pages.
* * Web Portal
Program that is used to look at web pages.
* * Caching
Method used to speed up access to recently viewed pages.
* * Web Browser
(6)
Describe the purpose and use of each of these three Internet services.
(a)
Newsgroups
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[3]
(b)
Internet Relay Chat (IRC)
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[3]
(c)
File Transfer Protocol (FTP)
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(7)
Write true or false by each of these statements about web broadcasting.
[6]
Statement True / False Broadcasting on the Internet is known as webcasting. It is easier to start broadcasting on the Internet that to start broadcasting on normal TV. It is easier to receive Internet broadcasts that normal TV. You need broadband to receive video broadcasts. The picture quality of video broadcast on the Internet is excellent. Information broadcast on the Internet can be received worldwide.
(8)
Schools and some Internet Service Providers filter information on the Internet before it can be viewed.
(a)
Why is filtering necessary ?
________________________________________________________________
________________________________________________________________
[2]
(b)
Describe two ways that a filter might work.
________________________________________________________________
________________________________________________________________
[2]
(c)
Identify one problem with filtering.
________________________________________________________________
[1]
(9)
What is an Intranet ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(10)
Write true or false by each of these statements.
[7]
Statement True / False The government can control what information is available on the Internet. It is difficult to discover who has put information onto the Internet. The Internet and the World Wide Web are the same thing. If you find some information on the Internet it must be true. Viruses can spread through the Internet. Selling goods on the Internet is known as e-commerce.
GCSE ICT Companion 04 - (C) P Meakin 2004
[52]
Electronic Commerce Worksheet (22)
Name
Mark
Group
(1)
What is e-commerce ?
[1]
_____________________________________________________________________
(2)
What is an e-business?
[1]
_____________________________________________________________________
(3)
List three things that a company will need to do before it can start trading on the Internet.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(4)
Many companies that sell goods on the Internet lose money from doing this. Why do you think that they continue to want to trade on the Internet ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(5)
After you purchase an item on the Internet the company that you make the purchase from usually sends you an email to confirm the details of the order. What is the purpose of this email ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(6)
(a)
Name an item that you can purchase on the Internet.
________________________________________________________________
[1]
(b)
Identify two advantages for a customer of being able to buy this item on the Internet.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(7)
Fill in the blanks in the following paragraph using the words below.
[8]
Credit or Debit
WAN
Encrypted
Web Sites
Information Systems
Security
Internet
Data Protection Act
Many ________________
measures are taken when an e-commerce transaction takes place. Because customer ________________
card details are transferred over a public ________________
they are ________________
to make it difficult for a hacker to steal them.
E-commerce ________________
are often linked to other ________________
owned by e-commerce companies. There have been a number of cases where hackers have been able to access these other systems through the web site due to poor security. Companies that let this happen have probably broken the 1998 ________________
.
(8)
Identify two benefits to a company of being able to sell goods by e-commerce.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
Give two reasons why it is unlikely that it will ever be the case that all goods are purchased by e-commerce.
(c)
________________________________________________________________
________________________________________________________________
[1]
(d)
________________________________________________________________
________________________________________________________________
[1]
(9)
Write true or false by each of these statements.
[4]
Statement True / False You can buy books on the Internet. Goods purchased on the Internet are usually paid for in cash. Details of orders placed on the Internet are usually stored in a database. Goods can be sold more cheaply over the Internet because the amount
of human activity involved in making a sale is reduced.
GCSE ICT Companion 04 - (C) P Meakin 2004
[28]
Global ICT Services Worksheet (23)
Name
Mark
Group
(1)
What is a service ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(2)
What is a global ICT service ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(3)
Here is a list of some things that you can buy. Some are global ICT services, some are services that can not be obtained over the Internet and some are not services at all.
Write a letter by each item to identify which category it falls into. Use this code :
G = Global ICT Service,
S = Service (Not Global), N = Not a Service
[6]
Item Category Book Haircut Secretarial Service Web Design Hospital Operation New Car
(4)
Fill in the blanks in the following paragraph using the words below.
[6]
Global
In Code
Supplier
Information
Money
Purchaser
Irrelevant
Important
Electronically
Slowly
The information that is to be processed will be transferred ________________
. Because of this the location of the people using and offering the service is ________________
. They can be located anywhere in the world. This is why these services are known as ________________
services.
(5)
A company has decided to pay a web design service to create a web site for them. The company must choose between a local web design service and a web design service located in another country.
(a)
Explain two advantages to the company of being able to choose a web design service located anywhere in the world.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Explain why the company may prefer to work with a local web design service.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
GCSE ICT Companion 04 - (C) P Meakin 2004
[20]
Data Logging Worksheet (24)
Name
Mark
Group
(1)
What does a data logging system do ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(2)
What are the four components of a data logging system ?
[4]
(a)
_______________________
(b)
_______________________
(c)
_______________________
(d)
_______________________
(3)
Fill in the blanks in the following paragraph using the words below.
[5]
Digital
On
Sensors
Size
Physical
Sensors can be either analogue or ________________
. If an analogue sensor is being used then the ________________
of the electrical signal will indicate the size of the quantity that has been measured. Digital sensors can only be ________________
or off.
(4)
Write analogue or digital by each of these sensor names.
[4]
System Analogue/Digital Temperature Sensor Button Pressure Pad Light Sensor
(5)
Describe the two tasks performed by an interface.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
(6)
Calibration matches sensor voltages with units that humans can understand. A
temperature sensor has been calibrated.
[2]
(a) The sensor is now producing
1 volt. What is the temperature ?
__ ºC
(b) The maximum voltage that the
sensor should produce is 5 volts. What is the highest temperature that it can
measure ?
__ ºC
(7)
(a)
When must remote data logging be used ?
________________________________________________________________
________________________________________________________________
[1]
(b)
What are the two different methods that can be used to transfer data from the sensors to the computer ?
________________________________________________________________
[2]
(8)
A local council is using data logging equipment to record the number of cars that pass through a road junction each hour. Before the council purchased the equipment a council employee had to count the
cars that passed through junctions.
(a)
Identify two advantages of the new data logging system.
________________________________________________________________
________________________________________________________________
[2]
(b)
Identify one disadvantage of the new system.
________________________________________________________________
[1]
(9)
Commerical aircraft always have two "black boxes". One of these boxes is in fact a data logging system which records information about the flight of the aircraft using hundreds of sensors. If an aircraft should crash then the data s
[4]
(a)
_______________________
(b)
_______________________
(c)
_______________________
(d)
_______________________
GCSE ICT Companion 04 - (C) P Meakin 2004
[29]
Control Worksheet (25)
Name
Mark
Group
(1)
What is a control system ?
[1]
_____________________________________________________________________
(2)
What are the five components of a control system ?
[5]
(a)
________________________
(b)
________________________
(c)
________________________
(d)
________________________
(e)
________________________
(3)
Here is a list of some sensors and devices. Place a tick before the
ones that are devices.
[5]
Light Gate
Button
Motor
Buzzer
Pump
Pressure Pad
Bulb
Heater
(4)
The interface in a control system contains an ADC and a DAC. Define and explain
the function of these two devices.
DAC ________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
ADC ________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(5)
Fill in the blanks in the following paragraph using the words below.
[5]
algorithm
sensors
programming language
flowchart
devices
The procedure which the software follows to take these decisions is known as an ________________
. This procedure would be planned with a ________________
. The procedure will be entered into the computer using a ________________
.
(6)
A central heating system consists of a temperature sensor and a boiler. The system is
used to keep the temperature in a house above 22ºC. The flowchart below shows how the system operates. Some of the flowchart labels are missing and are represented by blue letters. The missing labels are written below. Write each letter by
the label that should be in its place.
[7]
__
Yes
__
No
__
Is temperature < 22ºC ?
__
Start
__
Turn boiler on
__
Is temperature > 22ºC ?
__
Turn boiler off
(7)
(a)
What is feedback ?
________________________________________________________________
________________________________________________________________
[2]
(b)
Explain how the central heating system described in question 6 makes use of feedback.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[3]
(8)
Fill in the blanks in the following paragraph using the words below.
[5]
Anti Lock Brakes
Environmental
Tired
Embedded System
Quickly
(9)
Draw lines to link the words on the right hand side of the page with the correct descriptions on the left hand side.
[4]
The use of computers to manufacture products.
* * CNC
Standard system used to pass instuctions to machinery.
* * CAM
Machine used to cut and drill.
* * CAD
Type of software used to design products to make.
* * Mill
(10)
(a)
Give three reasons why robots are often used to manufacture an item instead of humans.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[3]
(b)
Give one limitation of using a robot to manufacture an item.
________________________________________________________________
________________________________________________________________
[1]
(11)
Explain how a computerised control system can be used to co-ordinate the flow of traffic.
[3]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
GCSE ICT Companion 04 - (C) P Meakin 2004
[48]
Control Programming Worksheet (26)
Name
Mark
Group
(1)
(a)
What is a turtle ?
________________________________________________________________
________________________________________________________________
[2]
(b)
What is a command ?
________________________________________________________________
[1]
(2)
A turtle is pointing towards the top of a page. It executes the commands listed below.
1. PENDOWN 9. FORWARD 80 2. RIGHT 90 10. RIGHT 180 3. FORWARD 100 11. FORWARD 80 4. RIGHT 180 12. RIGHT 90 5. FORWARD 100 13. FORWARD 70 6. RIGHT 90 14. RIGHT 90 7. FORWARD 70 15. FORWARD 100 8. RIGHT 90 16. PENUP
(a)
Which letter does the turtle draw ?
________________________________________________________________
[2]
(b)
How many units tall is the letter ?
________________________________________________________________
[1]
(3)
[1]
_____________________________________________________________________
(4)
(a) Write a program which does not use the REPEAT command
to draw this shape.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
[6]
(b) Change your program to use the REPEAT command.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
[3]
GCSE ICT Companion 04 - (C) P Meakin 2004
[16]
Data Protection Act Worksheet (27)
Name
Mark
Group
(1)
Computers have revolutionised the way organisations store and use data. Identify two advantages of storing and using data with a computerised system rather than on paper.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
(2)
State three reasons why it is easier to misuse data that is stored on a computerised information system rather than a manual system.
(a)
________________________________________________________________
________________________________________________________________
[2]
(b)
________________________________________________________________
________________________________________________________________
[2]
(c)
________________________________________________________________
________________________________________________________________
[2]
(3)
Draw lines to link the words on the right hand side of the page with the correct definitions on the left hand side.
[3]
A person or organisation that stores personal data.
* * Data Subject
An individual who is the subject of personal data.
* * Data Controller
Information about a living individual who can be identified.
* * Personal Data
(4)
Here are some pieces of information. Some are personal data and some are not. By each piece of information say whether or not you think it is personal data and then explain your answer.
(a)
A person's bank account number.
________________________________________________________________
________________________________________________________________
[2]
(b)
The name and address of a company.
________________________________________________________________
________________________________________________________________
[2]
(c)
A graph showing the number of people in your class who like each of five different flavours of crisps.
________________________________________________________________
________________________________________________________________
[2]
(5)
Write down four rules (or principles) that any organisation that stores personal data must obey.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
(c)
________________________________________________________________
________________________________________________________________
[1]
(d)
________________________________________________________________
________________________________________________________________
[1]
(6)
Here is a list of some different types of data. Some of the data is covered by the Act and some of it is exempt. By each data item write one of these descriptions : "Covered", "Not Covered", "Completely Exempt" or "Partially Exempt". All of the data
[6]
Data Type Covered by Act ? A student's school report. The bank records of a customer who is accused of tax fraud. A home computer user's Christmas card list. A list of British spies working in Russia. A stock list in a supermarket. Medical records in a hospital.
(7)
Write down two rights that a data subject has.
(a)
________________________________________________________________
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
________________________________________________________________
[1]
(8)
A data controller may charge a data subject a small fee if the data subject wants to view the information that is stored about her. Why is the data controller allowed to do this ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(9)
Identify two limitations of the Data Protection Act.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
Copyright and Hacking Worksheet (28)
Name
Mark
Group
(1)
What does it mean when a software package is described as being 'copyright' ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(2)
Why does it matter if people make illegal copies of software ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(3)
What are the three different offences under the Copyright, Designs and Patents Act ?
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(4)
Copying a software package is illegal. Suggest one reason why people break this law
[1]
_____________________________________________________________________
_____________________________________________________________________
(5)
(a)
What is a dongle ?
________________________________________________________________
________________________________________________________________
[2]
(b)
How does the use of a dongle discourage software piracy ?
________________________________________________________________
________________________________________________________________
[1]
(c)
What is a multi-user licence agreement ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(6)
What is a hacker ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(7)
For each of the illegal activities in (a) to (b) suggest one specific reason why an employee of a bank may want to carry out the activity.
(a)
Stealing confidential data.
________________________________________________________________
________________________________________________________________
[1]
(b)
Changing information stored on a computer.
________________________________________________________________
________________________________________________________________
[1]
(8)
Despite the fact that hacking is illegal, companies still employ security measure to make it harder for a hacker to access a computer system. Why is this ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(9)
What are the three different offences under the Computer Misuse Act 1990 ?
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(10)
Here is a list of some activities which may or may not be legal. By each activity write :
[7]
Activity Legal ? Accidentally introducing a virus onto a computer. Making a backup copy of a software package. Selling a software package that you know has been copied. Owning a CD writer which can put data onto CD-R disks. Changing your examination grades on the school's computer. Lending a CD-ROM to a friend to install on her computer. Logging onto a computer network using another user's password.
GCSE ICT Companion 04 - (C) P Meakin 2004
[28]
Health and Safety Worksheet (29)
Name
Mark
Group
(1)
Identify two jobs which involve using computers for long periods of time.
[2]
(a)
________________________
(b)
________________________
(2)
Draw lines to link the words on the right hand side of the page with the correct definitions or causes on the left hand side.
[4]
Can produce headaches. Caused by poor positioning of monitor or bad lighting.
* * Wrist Problems
Can be caused by prolonged periods of concentration or poorly designed software.
* * Stress
Caused by a person remaining seated in a poor position for a long time.
* * Back and Neck Problems
A type of repetitive strain injury caused by keyboard use.
* * Eye Strain
(3)
For each of the potential risks to health or safety listed below, identify two measures which can be taken to reduce the risk.
(a)
Eye Strain
________________________________________________________________
________________________________________________________________
[2]
(b)
Back and Neck Problems
________________________________________________________________
________________________________________________________________
[2]
(c)
Wrist Problems
________________________________________________________________
________________________________________________________________
[2]
(d)
Stress
________________________________________________________________
________________________________________________________________
[2]
(e)
Electrical Safety
________________________________________________________________
________________________________________________________________
[2]
(4)
Name three different laws or regulations which control the use of computer equipment in the workplace within the United Kingdom.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
GCSE ICT Companion 04 - (C) P Meakin 2004
[19]
Security Worksheet (30)
Name
Mark
Group
(1)
What is data security ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(2)
What are the four main threats to the safety of data ?
[4]
(a)
________________________
(b)
________________________
(c)
________________________
(d)
________________________
(3)
Identify two possible causes of accidental damage to a file.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(4)
Limiting physical access to a computer system is one way of increasing the security of data.
(a)
Identify two methods which can be used to limit physical access.
________________________________________________________________
[2]
(b)
Suggest one computer system for which it would not be possible to limit physical access.
________________________________________________________________
[1]
(c)
Explain why it would not be possible to limit access in this situation.
________________________________________________________________
________________________________________________________________
[1]
(5)
Which law made it illegal to try to gain access to a computer system using another user's password ?
[1]
_____________________________________________________________________
(6)
Biometric measures are used to control access by recognising a unique physical characteristic of a peson.
(a)
State two suitable characteristics that can be measured.
________________________________________________________________
[2]
(b)
Give two reasons why biometric measures are usually preferred to a username and password system.
________________________________________________________________
________________________________________________________________
[2]
(7)
File access rights determine what actions a user can take on a file or directory Explain the effect of these two different access rights :
(a)
Read Only
________________________________________________________________
[1]
(b)
Change
________________________________________________________________
[1]
(8)
State one advantage and one disadvantage of the use of a log as a security measure.
(a)
Advantage
________________________________________________________________
[1]
(b)
Disadvantage
________________________________________________________________
[1]
(9)
Draw lines to link the words on the right hand side of the page with the correct definitions on the left hand side.
[4]
Method designed to prevent 'infection' of a computer.
* * Passwords
An extra copy of data used to restore lost or damaged files.
* * Backup
Stored data files are encoded by this method.
* * Virus Check
Commonly used on a computer network to control access to data files.
* * Encryption
(10)
Many security measures are not effective at preventing the theft of data by authorised users. Identify two security measures which reduce the risk of data theft by authorised users and explain why they are effective.
[4]
Measure ___________________________________________________
Reason ___________________________________________________
Measure ___________________________________________________
Reason ___________________________________________________
(11)
Fill in the blanks in the following paragraph using the words below.
[6]
changed
firewall
Internet
security
digital signature
recipient
(12)
[8]
Statement True / False A log can only be used in conjunction with a password system. Personal data must be kept secure to comply with the Data
Protection Act. Data stored on CD-ROM should be kept away from magnetic fields. Encrypting a file will prevent accidental deletion of the file. Passwords can be used to control which files a user can access. Data theft is often carried out by a member of the organisation from
which the data is stolen. It is always possible to limit physical access to a computer. Different users can have different file access rights to the
same file.
(13)
Why do you think that it is usually harder to maintain the security of data when many computers are linked together on a network ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
GCSE ICT Companion 04 - (C) P Meakin 2004
[45]
Backups Worksheet (31)
Name
Mark
Group
(1)
(a)
What is a backup ?
________________________________________________________________
________________________________________________________________
[1]
(b)
Why are backups kept ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(c)
What is an archive file ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(2)
Identify five points which should be considered in a backup strategy.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(d)
________________________________________________________________
[1]
(e)
________________________________________________________________
[1]
(3)
Draw lines to link the words on the right hand side of the page with the correct appropriate situations on the left hand side.
[3]
A network file server which stores 160Gb of data for 100 users.
* * CD RW
A small home computer which is mainly used for word processing documents.
* * Magnetic Tape
An office computer which stores a 200Mb customer database.
* * Floppy Disk
(4)
In a large company backups could be made in one of two ways :
(a)
Give one advantage of each employee backing up his own work.
________________________________________________________________
________________________________________________________________
[1]
(b)
Give one advantage of a selected employee backing up everyone's work.
________________________________________________________________
________________________________________________________________
[1]
(5)
Fill in the blanks in the following paragraph using the words below.
[5]
Ancestral
Transaction File
Current Master File
Child
File Generations
Son
Old Master File
Recreate
Erase
Transaction Log File
(6)
Explain the following terms which refer to parts of the backup procedure for a transaction processing system.
(a)
File Dump
________________________________________________________________
________________________________________________________________
[2]
(b)
Transaction Log File
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(7)
(a)
Explain how the data would be restored in a transaction processing system if the master file became corrupt.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
What is the importance of the transaction log file in the restoration procedure ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
[1]
GCSE ICT Companion 04 - (C) P Meakin 2004
[27]
Viruses Worksheet (32)
Name
Mark
Group
(1)
What three features do viruses usually have ?
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
(c)
________________________________________________________________
________________________________________________________________
[1]
(2)
(a)
You are about to use a program which is stored on a floppy disk. Unknown to you the program has been infected by a virus. Explain how the virus will be transferred onto your computer.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[3]
(b)
Identify two other sources from which viruses might be transferred.
________________________________________________________________
[2]
(3)
Why do you think that it is important to detect and delete a virus as soon as possible?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(4)
Identify two steps that you can take to reduce the likelihood of a virus getting on to your computer.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(5)
[7]
Statement True / False Viruses can be attached to email documents. A virus checking program will prevent any viruses from copying
themselves onto your computer. A virus could damage your printer. All viruses delete files from your computer. Viruses are usually introduced onto a computer system by accident. It is illegal to deliberately introduce a virus onto a computer. A worm is a type of virus that spreads without the user doing anything.
GCSE ICT Companion 04 - (C) P Meakin 2004
[19]
Validation and Verification Worksheet (33)
Name
Mark
Group
(1)
(a)
If the data inputted into a computer system is incorrect, what will be the effect on the outputs of the system ?
________________________________________________________________
[1]
(b)
What does the acronym GIGO stand for ?
________________________________________________________________
[1]
(c)
Why is it particularly important that data entered into a batch processing system is correct ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(2)
(a)
Define the term validation.
________________________________________________________________
________________________________________________________________
[3]
(b)
If some data passes a validation check, does this mean that the data is correct ?
________________________________________________________________
[1]
(3)
(a)
Suggest the name of a field on which a range check could be used
________________________________________________________________
[1]
(b)
State the range that should be used by this range check.
________________________________________________________________
[1]
(4)
[4]
Value Valid? 2.38 4.A8 98564.53 878979.93
(5)
(a)
What is a table lookup check ?
________________________________________________________________
________________________________________________________________
[1]
(b)
What two other names is a table lookup check known by ?
________________________________________________________________
[1]
(6)
Calculate the check digit to complete the ISBN number 185029553. Show your working.
[6]
Digit 1 8 5 0 2
9 5 5 3 Weighting
Total
Result
______________________________________________________
______________________________________________________
(7)
Is the ISBN number 045050638X valid ? Show your working.
[6]
Digit 0 4 5 0 5
0 6 3 8 X Weighting
Total
Result
____________________________________________________
____________________________________________________
(8)
(a)
A computer system uses even parity to transmit data. Has byte (i) or byte (ii) been received correctly ?
(i) 10010110 (ii) 01001010
________________________________________________________________
[1]
(b)
The byte 10010110 is to be transmitted by an even parity system. Can you think of an error that might occur during transmission which would not be detected when the byte was received. Why would it not
be detected ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(9)
Fill in the blanks in the following paragraph using the words below.
[9]
field
count
hash totals
manually
batches
typing in
entered twice
automatically
out
(10)
Draw lines to link the words on the right hand side of the page with the correct fields to use them on on the left hand side.
[4]
Month of the Year
* * Format
Gender
* * Type
Postcode
* * Range
Surname
* * Length
(11)
What is verification ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(12)
(a)
Give one advantage of the dual input method of verification.
________________________________________________________________
[1]
(b)
Give one advantage of the on screen prompt method of verification.
________________________________________________________________
[1]
(13)
[7]
Statement True/False Verification checks ensure that entered data is correct. A range check tests that entered data is no longer than a specified number of characters. A limit check has only one boundary. The dual input method is a validation check. Parity checks are used to test data entered from a bar code. Validation and verification checks can only be performed by a database package. Validation checks are performed automatically by a computer.
GCSE ICT Companion 04 - (C) P Meakin 2004
[55]
Data Collection Worksheet (34)
Name
Mark
Group
(1)
State two objectives that you should consider when designing a data collection form.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(2)
A garage sells cars. When a customer visits the garage to buy a car he or she is asked to fill in a data collection form to help the garage identify what type of car they want to buy. This is the
first draft of a design for a suitable form : 
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(d)
________________________________________________________________
[1]
(e)
________________________________________________________________
[1]
(3)
State two advantages that could be gained from entering data into a computer using a direct data entry device rather than having a computer operator type the data in manually.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(4)
What restriction does the use of optical mark recognition to input data place on the type of question that can be asked on a data collection form ?
[1]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(5)
(a)
Explain what is meant by the term 'turnaround document'.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[4]
(b)
Name a company that could make use of turnaround documents.
________________________________________________________________
[1]
(c)
Explain an alternative system that could be used instead of turnaround documents.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[3]
Simulation Worksheet (35)
Name
Mark
Group
(1)
Identify the three main reasons why simulations are used
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(2)
Suggest a situation in which a simulation might be used.
[1]
_____________________________________________________________________
(3)
Explain these three terms.
(a)
Variable
________________________________________________________________
[1]
(b)
Rule
________________________________________________________________
________________________________________________________________
[1]
(c)
Model
________________________________________________________________
[1]
(4)
You are developing a simulation to show what happens when a car is hit by another car. Suggest two variables that the simulation may use.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(5)
A spreadsheet is being used to model the cost of making a packed lunch. 
(a)
What cell would need to be changed to discover the effect of an increase in the price of a slice of ham to 20p ?
________________________________________________________________
[1]
(b)
What cell would need to be changed to discover the effect of giving the person taking the lunch two cans of drink instead of one ?
________________________________________________________________
[1]
(c)
What feature of a spreadsheet is used to create rules in a simulation like this ?
________________________________________________________________
[1]
(6)
Pilots are often trained using flight simulators. However before a pilot can fly an aircraft with passengers he must also gain a lot of experience of flying real aeroplanes. Why do you think this is
the case ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(7)
Fill in the blanks in the following paragraph using the words below.
[7]
Backing Store
Aritficially
Virtual Office
VR Headset
RAM
User
Microprocessor
Training
(8)
[5]
Statement True/False VR stands for visual recognition software. ____ Some simulations require specialised input and output devices. ____ Hydraulic pistons are used to create movement in a flight simulator. ____ A simulation is only as reliable as the rules it is based on. ____ A data glove detects the movement of a user's head in a VR system. ____
GCSE ICT Companion 04 - (C) P Meakin 2004
[26]
User Interface Worksheet (36)
Name
Mark
Group
(1)
What is a user interface ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(2)
What are the three different types of user interface ?
[3]
(a)
________________________________________________
(b)
________________________________________________
(c)
________________________________________________
(3)
Explain how a user interacts with a computer when a Command Line Interface is in use.
[3]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(4)
(a)
State one advantage of a command line interface over a menu driven interface.
________________________________________________________________
[1]
(b)
State one advantage of a menu driven interface over a command line interface.
________________________________________________________________
[1]
(5)
Define these terms.
[7]
GUI
________________________________________________
WIMP
________________________________________________
Window
________________________________________________
Icon
________________________________________________
Menu
________________________________________________
Pointer
________________________________________________
WYSIWYG
________________________________________________
(6)
Name three input devices that could be used to control a pointer for a GUI.
[2]
_____________________________________________________________________
_____________________________________________________________________
(7)
Write true or false by each of these statements about speech driven user interfaces.
[5]
Statement True / False Controlled by user speaking commands. Can be used by anyone. Very little training is required. Reduces the risk of repetitive strain injury. May need to be trained to a user's voice.
(8)
Explain some issues that you should consider when designing a user interface.
[4]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(9)
Here are some points that you should consider when assessing a user interface. Explain why you think each point is important.
(a)
How many other programs use the same user interface.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[1]
(b)
What help facilities are provided.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
Algorithms and Charts Worksheet (37)
Name
Mark
Group
(1)
Explain these terms.
(a)
Algorithm
________________________________________________________________
________________________________________________________________
[1]
(b)
Flowchart
________________________________________________________________
________________________________________________________________
[1]
(c)
System Flowchart
________________________________________________________________
________________________________________________________________
[1]
(2)
Why are flowcharts used to describe algorithms instead of a natural language such as English ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(3)
What does the direction of the arrows indicate in :
(a)
A flowchart ?
________________________________________________________________
________________________________________________________________
[1]
(b)
A system flowchart ?
________________________________________________________________
________________________________________________________________
[1]
(4)
This algorithm describes how to make a cup of instant coffee.
[13]
The flowchart below represents the same algorithm. A letter has been written on each symbol. The labels that belong on the symbols are written next to the flowchart.
Write the letters from the symbols next to the labels that belong on them.
Yes __ Fill Kettle __ Add Milk __ Start __ Put Water In Cup __ Milk Wanted? __ Stop __ Stir And Serve __ Put Coffee In Cup __ No __ Add Sugar __ Turn Kettle On __ Wait For Kettle To Boil __
(5)
[8]
Manual Operation __
Output on Screen __
Printed Output __
Process __
Disk Storage __
Input or Output __
Manual Input __
Tape Storage __
GCSE ICT Companion 04 - (C) P Meakin 2004
[27]
Programming Worksheet (38)
Name
Mark
Group
(1)
What is a program ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(2)
What are the two different levels of programming language ?
[2]
(a)
________________________
(b)
________________________
(3)
Identify one situation in which a program would be written in a low level language.
[1]
_____________________________________________________________________
_____________________________________________________________________
(4)
Why are there so many different high level programming languages ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(5)
Fill in the blanks in the following paragraph using the words below.
[6]
Translated
Machine Code
Logo
Turtle
High Level Language
Interpreter
(6)
(a)
State one advantage of using a compiler for translation.
________________________________________________________________
[1]
(b)
State one advantage of using an interpreter for translation.
________________________________________________________________
[1]
(7)
Identify three differences between a low level language program and a high level language program.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
(c)
________________________________________________________________
________________________________________________________________
[1]
(8)
[7]
Statement True/False Programs written in a low level language execute more quickly than
programs written in a high level language. A high level language instruction can do the job of many low level
language instructions. The COBOL high level language is used to control a turtle. Interpreted programs run more slowly than compiled programs. BASIC is a low level language. Low level language programs are portable. An assembler converts a program from machine code into assembly
language.
GCSE ICT Companion 04 - (C) P Meakin 2004
[24]
Data Transfer Worksheet (39)
Name
Mark
Group
(1)
Why is it convenient to be able to transfer data from one package to another ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(2)
Name the two methods that can be used to transfer data between packages.
[2]
(a)
________________________
(b)
________________________
(3)
Define these two terms.
(a)
Importing
________________________________________________________________
________________________________________________________________
[1]
(b)
Exporting
________________________________________________________________
________________________________________________________________
[1]
(4)
Text files and Rich Text Files are both standard formats for files containing written information.
(a)
If you have created a document in a word processor which format would you prefer to save the file in ?
________________________________________________________________
[1]
(b)
Why would you choose this format ?
________________________________________________________________
________________________________________________________________
[1]
(5)
What are the two standard file formats that can be used to store data from a database ?
[2]
(a)
________________________
(b)
________________________
(6)
Here is a list of the three most common standard formats for saving graphics files. Write 'Big' by the format which usually generates the largest files, 'Small' by the format that usually generates the smallest files
and 'Medium' by the remaining format.
[3]
Format Size JPEG Bitmap GIF
(7)
(a)
Identify one problem with images that are saved in bitmap format.
________________________________________________________________
________________________________________________________________
[1]
(b)
Identify one problem with images that are saved in JPEG format.
________________________________________________________________
________________________________________________________________
[1]
(8)
Fill in the blanks in the following paragraph using the words below.
[6]
MP3
compress
MPEG
copyright
Internet
DVD
(9)
There are many standard file formats yet most application packages save files in their own unique format. Why do you think this is the case ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
GCSE ICT Companion 04 - (C) P Meakin 2004
[22]
Social Issues Worksheet (40)
Name
Mark
Group
(1)
Explain three reasons why the growth in the use of communications technologies such as the Internet has been of benefit to society.
[3]
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
(2)
Explain two reasons why the growth in the use of communications technologies has caused problems for society
[2]
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
(3)
(a)
How can the use of ICT benefit people with special needs ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
How can ICT be used to help educate people ?
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(4)
Discuss the impact of the use of computerised information systems on employment.
[4]
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
(5)
(a)
Suggest two possible advantages of each person having to carry a National Identity Card.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Suggest one possible disadvantage of each person having to carry a National Identity Card.
________________________________________________________________
________________________________________________________________
[1]
(6)
Explain these terms.
(a)
Global Village
________________________________________________________________
________________________________________________________________
[1]
(b)
Teleworker
________________________________________________________________
________________________________________________________________
[1]
(c)
Globalisation
________________________________________________________________
________________________________________________________________
[1]
(d)
Cultural Homogenisation
________________________________________________________________
________________________________________________________________
[1]
(7)
'Computers have a negative effect on the environment. They use lots of electricity and power generating stations produce pollution.' Whilst this statement is true, computers can also have a positive
effect on the environment. List three ways in which this can happen.
(a)
________________________________________________________________
________________________________________________________________
[2]
(b)
________________________________________________________________
________________________________________________________________
[2]
(c)
________________________________________________________________
________________________________________________________________
[2]
GCSE ICT Companion 04 - (C) P Meakin 2004
[26]
Banking Worksheet (41)
Name
Mark
Group
(1)
State three reasons why banks use computerised information systems to manage customer accounts.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
(c)
________________________________________________________________
________________________________________________________________
[1]
(2)
[4]
Statement True/False Debit cards can be used to pay for goods by EFTPOS. Data is stored on a debit card using a magnetic stripe. All debit cards are smart cards. A debit card number must be entered using a keyboard.
(3)
What is the difference between a debit card and a credit card ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(4)
Fill in the blanks in the following paragraph using the words below.
[6]
encrypted
magnetic stripe
credit
withdraw
modem
cheque
passcode
PIN
OMR
email
(5)
Explain how an EFTPOS purchase takes place.
[6]
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
(6)
List the items of information that are printed on a cheque in machine readable form.
[3]
(a)
_____________
(b)
_____________
(c)
_____________
(7)
Why is the amount to be paid written onto a cheque twice ?
[2]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
(8)
EFTPOS and cheques are two different methods of paying for goods using money in a bank account. Identify an advantage and disadvantage of each method of payment for the customer.
[4]
EFTPOS
Cheque
Advantage
_______________
_______________
_______________
_______________
_______________
_______________
_______________
_______________
Disadvantage
_______________
_______________
_______________
_______________
_______________
_______________
_______________
_______________
(9)
Statements are produced regularly from an accounts database. Which database function would be used for each of these tasks ?
[3]
Task Function To put transactions in order by date. To arrange the transactions and account information on the page. To select which transactions to include on a statement.
(10)
Identify three actions that a bank customer could carry out when he accesses his bank account using the Internet.
[3]
(a)
______________
(b)
______________
(c)
______________
(11)
Some new banks only operate on the Internet. Why is it cheaper to run an Internet only bank ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(12)
What do these five acronyms stand for ?
[5]
ATM
________________________________________
PIN
________________________________________
EFTPOS
________________________________________
MICR
________________________________________
BACS
________________________________________
(13)
Ensuring security is vital when banks make use of computers. Explain when each of these two security measures could be used and what each will do.
(a)
Password / PIN
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(b)
Encryption
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(14)
Draw lines to link the words on the right hand side of the page with the correct terms and statements on the left hand side.
[7]
System used by companies to transfer money from one account to another.
* * Laser
List of transactions periodically sent to a customer.
* * Clearing
Type of printer used to produce bank statements.
* * Statement
Method used to print numbers on a cheque.
* * PIN
The process by which money is transferred after a cheque has been written.
* * BACS
One method of automatically paying regular bills.
* * Standing Order
Numeric password required to use an ATM.
* * MICR
GCSE ICT Companion 04 - (C) P Meakin 2004
[53]
Supermarket Worksheet (42)
Name
Mark
Group
(1)
A supermarket has a computerised information system. What three tasks should it perform ?
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(2)
A supermarket stores information about the products that it sells in a stock database. The most important product details are stored in the products file.
(a)
Which field is the key field in the products file ?
________________________________________________________________
[1]
(b)
Some information in the products file is coded. Why is this ?
________________________________________________________________
________________________________________________________________
[2]
(c)
Name two files other than the products file which might be stored in the stock database.
________________________________________________________________
[2]
(3)
Many supermarkets use computerised tills which are linked to the stock database to form a stock control system. These tills are known as EPOS terminals.
(a)
What does EPOS stand for ?
________________________________________________________________
[1]
(b)
How are the EPOS terminals connected to the computer that stores the stock database ?
________________________________________________________________
[1]
(c)
What method is used to validate the product codes as they are scanned ?
________________________________________________________________
[1]
(d)
Product codes can be entered in two different ways. Why is the barcode method preferred ?
________________________________________________________________
________________________________________________________________
[2]
(e)
What type of processing is used when the EPOS terminals update the stock database to record sales ?
________________________________________________________________
[1]
(f)
Using EPOS terminals linked to a stock database for stock control has many advantages. Explain two advantages of the system for the customers of a supermarket.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(g)
Using EPOS terminals linked to a stock database for stock control has many advantages. Explain two advantages of the system for the supermarket's manager.
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
[2]
(4)
Draw lines to link the words on the right hand side of the page with the correct purposes on the left hand side.
[5]
Temporarily outputs the name and price of each product as the product is scanned.
* * Barcode Reader
Preferred method of entering a product code into the terminal.
* * Keyboard
Makes a noise to inform the till operator that a product code has been scanned correctly.
* * Printer
Outputs a hard copy itemised receipt for the customer.
* * LCD Display
Alternative method of entering a product code into the terminal.
* * Buzzer
(5)
Look at this small extract from the products file of a stock database.
Product Code
Item Name
Stock Level
Re-Order Level
Order Quantity
Price
Category
Supplier Code 100200432492
Pork Sausages 454g
280
200
400
£1.99
ME
PC 100297487532
Sweetcorn 250g
865
300
600
£0.19
CA
HZ 102313538763
Red Potatos 5Kg
15
100
150
£2.59
FV
MF 403244976252
Cherries Small Tin
32
40
26
£0.65
CA
JW
(a)
How can you identify the products that need to be reordered ?
________________________________________________________________
________________________________________________________________
[2]
(b)
Which products need to be reordered ?
________________________________________________________________
[2]
(c)
Explain what the QUERY function of a database would be used for in an automatic reordering system.
________________________________________________________________
________________________________________________________________
[1]
(d)
Explain what the REPORT function of a database would be used for in an automatic reordering system.
________________________________________________________________
________________________________________________________________
[1]
(e)
The orders could be sent to the supermarket's suppliers by EMAIL or by POST. State one advantage of using EMAIL.
________________________________________________________________
[1]
(f)
The orders could be sent to the supermarket's suppliers by EMAIL or by POST. State one advantage of using POST.
________________________________________________________________
[1]
(6)
The stock level field of the products file should contain the number of units of each product that are currently in stock at the supermarket. Sometimes the figure stored in this field is incorrect.
How could this happen ?
[2]
_____________________________________________________________________
_____________________________________________________________________
(7)
Periodically a supermarket will carry out a stock check to ensure that the stock level field in the products
file correctly stores the number of items of each product that are in stock. The flowchart below shows the steps involved in a stock check. The statements that belong on the symbols are listed to the right of the chart.
[7]
Display name of product and expected number in stock. __ Stop. __ Scan barcode of a product to check. __ Change stored stock level to actual stock level if required. __ Start. __ Any products left to check? __ Count and enter actual number in stock. __
(8)
[4]
Statement True/False You can pay for purchases using a loyalty card. You can earn a discount if you use a loyalty card when you shop. Information is stored on a loyalty card as a barcode. Supermarkets collect information about you when you use a loyalty card.
(9)
What is self scanning and what advantage does it offer the shopper ?
[3]
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
GCSE ICT Companion 04 - (C) P Meakin 2004
[47]
Systems Lifecycle Worksheet (43)
Name
Mark
Group
This worksheet covers the "systems lifecycle",
"analysis", "design",
"implementation", "testing"
"evaluation" and "user guide" topics.
(1)
This diagram illustrates the five stages of the systems lifecycle. The labels that should appear in the boxes have been replaced by letters.
Write the letter that matches each label by the list of labels that appears on the right hand side of the diagram.
[5]
Testing __ Implementation __ Analysis __ Evaluation __ Design __
(2)
[6]
Method Advantage Disadvantage Questionnaire
Interview
Observation
(3)
What is top down design ?
[1]
_____________________________________________________________________
_____________________________________________________________________
(4)
(a)
Input
________________________________________________________________
[1]
(b)
Output
________________________________________________________________
[1]
(c)
Desired Outcome
________________________________________________________________
________________________________________________________________
[1]
(5)
You are selecting software to keep track of the income and expenditure of a local sports club. Suggest two different criteria you might use to compare software packages.
(a)
________________________________________________________________
________________________________________________________________
[1]
(b)
________________________________________________________________
________________________________________________________________
[1]
(6)
Fill in the blanks in the following paragraph using the words below.
[6]
Analysis
Expected Results
Desired Outcomes
Test Plan
Information System
Extreme
(7)
(a)
What is implementation ?
________________________________________________________________
________________________________________________________________
[2]
(b)
You have implemented a membership card system using a database. Suggest three items that you might collect as evidence of your work.
________________________________________________________________
________________________________________________________________
________________________________________________________________
[3]
(8)
Draw lines to link the words on the right hand side of the page with the correct descriptions of changeover methods on the left hand side.
[4]
The new system is tried out alongside the old system on a small scale (e.g. on one till), processing some of the data that the old system processes. When the new system appears to work satisfactorily it replaces the old one. * Phased
The old and new systems are used together until users and confident that the new system works. During the changeover all data is entered into both systems.
* * Parallel
The new system replaces the old one in parts, e.g at one branch of a store at a time.
* * Pilot
At a particular time the old system is scrapped and completely replaced by the new system.
* * Direct
(9)
(a)
What is annotation of testing ?
________________________________________________________________
________________________________________________________________
[2]
(b)
You carry out a test on an information system that you have created and the system fails the test. What should you do ?
________________________________________________________________
________________________________________________________________
[2]
(10)
You are writing an evaluation. To what two things should you refer when assessing the success of the information system you have developed ?
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(11)
You are producing a user guide for an information system that will be used by a school office to record details of student attendances at the school. Suggest four items that you might include in the
user guide for this system.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(d)
________________________________________________________________
[1]
(12)
Name three items that might be included in the system (technical) documentation for a new computer system.
(a)
________________________________________________________________
[1]
(b)
________________________________________________________________
[1]
(c)
________________________________________________________________
[1]
(13)
Draw lines to link the words on the right hand side of the page with the correct stages in the system lifecycle on the left hand side.
[6]
Writing a test plan.
* * Design
Collecting evidence showing the information system at different levels of development.
* * Analysis
Selecting appropriate hardware to use.
* * Testing
Deciding whether or not to set up a computerised information system.
* * Implementation
Producing a requirements specification.
* * Analysis
Obtaining actual results from an information system.
* * Design
GCSE ICT Companion 04 - (C) P Meakin 2004
[51]
