|
|
GCSE ICT
Attempt ALL questions. Write your answers in the
boxes.
A1 A
relational database will contain:
a two or
more related tables
b two or
more related fields
c two or
more related records
d two or
more related reports
A2 The best
way to access a regularly visited web site is:
a go to a
bulletin board to find the web page address
b use a
search engine to find the page each time you want to visit it
c send an e-mail
to your ISP
d bookmark
the site and save it as a favourite
A3 Which is
a benefit of using robots in a factory?
a they
design better products
b they
don’t need any maintenance
c they
don’t cost much to install
d they
perform repetitive tasks efficiently
A4 When
text automatically moves on to a new line during word processing it is called:
a indenting
b pasting
c word
wrapping
d deleting
A5 Which two of the
following are indicated in the record structure of a database:
1 the
number of fields in the record
2 the name
of the record
3 the
definition of each field in the record
4 the
number of tables in the record
a 1 &
4
b 2 &
4
c 1 &
3
d 3 &
4
A6 A company has its office in Edinburgh.
The company has seven computers that are linked
together. What type of computer system do they have?
a local area network
b standalone PCs
c distributed network
d wide area network
A7 Which two of the following are functions of the central
processing unit?
1. performing calculations
2. creating a backup of a disk
3. handling control signals
4. display graphics on the monitor
a 2 & 4
b 1 & 3
c 2 & 3
d 1 & 2
A8 A thesaurus in a word processing application is used
to:
a count the number of words on a page
b check spelling
c work out a calculation
d find a word of a similar meaning
A9 A video library is using a computer to enter details
of new videos. A data entry screen is to be created for the receptionist.
The information needed before the screen can be
designed is:
a a list of all new videos
b a list of all videos in the shop
c a list of all data items for each video
d a list of the most popular videos
A10 A computer simulation is a
program which:
a models a real-life system
b designs a web site
c creates a database
d controls the temperature of a greenhouse
A11 Customers wishing to play the lottery select their numbers and
mark them on a slip of paper.
Which is the name of the device that reads the
numbers?
a optical mark reader
b optical character reader
c bar code reader
d magnetic stripe reader
A12 The Meteorological Office use
very sophisticated models of the earth’s atmosphere to provide weather
forecasts.
Why is the use of a computer model an advantage for
weather forecasters?
a they will never be wrong when forecasting the weather
b they can predict the weather forecast more accurately
c they will be certain of the best time to book their
holidays
d they can be certain what the weather will be in the
next few days
A13 In a data entry form, an example
of a sensible and economical coding for a field asking if a person’s age is
over 21 would be:
a true false
b yes no
c Y N
d over under
A14 Which of the following
statements with reference to e-mail is incorrect?
a you can send an e-mail to several people at once
b you can attach a file to an e-mail
c it is slower than sending a letter
d you can send an e-mail at any time of day
A15 Terry has installed new
application software on his computer. Which sequence will he use to test the
software?
a retrieve file, enter data, save file, close file,
access software, print file
b access software, retrieve file, enter data, print
file, save file, close file
c access software, enter data, save file, close file,
retrieve file, print file
d retrieve file, access software, enter data, close
file, print file, save file
A16 Amir is designing a badge for
his local sports club. The badge will be adapted to represent different
sporting activities. The most appropriate graphics software would be:
a vector graphics
b pixel graphics
c bitmap graphics
d compressed graphics
A17 A payroll clerk wants to use one
cell address in a spreadsheet for the hourly rate of pay. The essential feature
of the spreadsheet for this task is:
a relative addressing
b absolute addressing
c AutoSum
d automatic recalculation
A18 A customer of a company wishes
to connect to the Internet. Which one of the following is not required to access the Internet?
a Internet service provider
b sound card
c web browser
d modem
A19 Which is a problem when
introducing a new computer system?
a staff will have to work longer hours
b staff will lose their jobs
c staff may need training before they can use it
d the business will have to close when the system is
introduced
Two years ago Andrew and Brindley became partners in a
night-club called Trends in Seahaven on the south coast of England.
Jennifer carries out administrative tasks, including
typing letters and keeping the accounts. She also keeps details of club
members, which are stored on the MEMBERS_FILE so that they can be sent details of future events.
Jennifer uses the PAYROLL_FILE to work out staff wages and to print their payslips.
B1 When Andrew and Brindley took over Trends, they immediately
upgraded the computer system.
a State two functions of an operating system.
b Explain the term RAM and describe the benefit of an
upgraded computer system with increased RAM.
c Explain the need for both a hard drive and a CD-RW
drive.
(Total 6 marks)
B2 The ICT system, which links Andrew’s and Brindley’s
office to that of the Office Manager at the Seahaven night-club, is a Local
Area Network.
a Describe the difference between a Local Area Network
and a Wide Area Network.
b Explain the advantages of a Local Area Network
compared with a standalone system.
(Total 5 marks)
B3 Jennifer uses both the desk top publishing and
mailmerge facilities on her word processing software to send details of future
events to all club members.
a Describe four desk top publishing facilities that Jennifer might use
to produce a newsletter.
b Describe the process of mailmerge and explain why it
is a benefit to Jennifer in sending out details of future events.
(Total 8 marks)
B4 When a new member joins Trends, details of name,
address, date of birth, telephone number and date joined are stored in the Members’ file.
Some fields are validated.
a Explain what is meant by data validation.
b State two fields which might be validated and explain which
validation technique is used.
c Design a data capture form so that this data can be input to the
database.
Member ID, Title, First Name, Last Name, Address,
Postcode,Phone Number, Date of Birth, and Date of Joining.
(Total 6 marks)
B5 Jennifer has decided she would like to work from home
and Andrew and Brindley have agreed she can do this.
a Describe how Information Technology can make it easier
for Jennifer to work from home.
b Describe the advantages to Jennifer.
c Describe the disadvantages of working from home for Jennifer.
(Total 6 marks)
B6 Trends uses e-mail for sending orders to the record
companies.
Explain why e-mail would be used rather than
telephone, fax or letter:
(Total 3 marks)
B7 The field that records the hourly rate of pay in the Payroll
File is validated by a range check. When preparing a log of testing to check
the database design,it is good practice to test typical, extreme and invalid
data. Explain what is meant by:
a typical data and give an example for the field – hourly rate
b extreme data and give an example for the field – hourly rate
c invalid data and give an example for the field – hourly rate
(Total 6 marks)
TOTAL FOR SECTION B – 40 MARKS