Christie wants to use her computer to make a newsletter.
(
a
)
State a suitable type of software used to create a newsletter.
(
b
)
Christie is unsure how to create her newsletter. She needs some help
and decides to look at the
wizard
and
template
features.
Using the words below complete the sentences.
Wizard Template
(i)
A
is a pre-designed
page that contains a basic structure of a document.
(ii)
A
is a guide which
helps the user to complete a task.
(
c
)
Below are the
input
and
output
devices used by Christie to create her
newsletter.
Beside each device tick (
3
) whether it is input or output.
One has been done for you.
Device
Input
Output
Printer
Graphics Tablet
3
Trackpad
Monitor
Keyboard
(
d
)
When Christie enters text into her newsletter she notices the
computer automatically takes a new line when needed.
State what this feature is called.
(continued)
(
e
)
Christie saves her newsletter to a CD-RW which is a form of backing
storage media.
(i)
Which two sentences below correctly describe a CD-RW?
Tick (
3
)
two
boxes only.
A CD-RW:
needs a laser to read the data
cannot have its data changed
stands for Computer Disc —Rewritable
stands for Compact Disc —Rewritable.
(ii)
State
two
other backing storage media.
1
2
(
f
)
Christie designs the logo below for the newsletter using a graphics
package.
State
two
graphics tools used to create this logo.
1
2
Recycle
Use
The
Correct
Bin
Page four
2.
Fred is the secretary of Lowland Rugby Club.
Fred creates a database to store a list of players who are allowed to play for
the under 18 rugby team.
(
a
)
Fred stores the following information for each of the 30 players.
Forename
Surname
Date of Birth
Games Played
Position
(i)
How many records are there in the database?
(ii)
How many fields are there in the database?
(
b
)
Here is part of the database.
Forename
Surname
Date of Birth
Games Played
Position
Omar
Ali
31/01/1995
5
Scrum Half
Adam
McGregor
30/03/1998
1
Hooker
Derek
McAlpine
07/05/1999
2
Full Back
Douglas
Smith
02/08/1996
8
Hooker
Juan
Gonzalez
21/02/1998
3
Left Wing
Peter
Ulrich
11/10/1997
11
Right Wing
Complete the sentences below to show how Fred will do the
following.
(i)
Fred wants to find all players who play as a Scrum Half.
He will
on the field
.
(ii)
Fred also needs to find the oldest player.
He will
on the field
.
c
)
State
two
advantages of storing information on a computer database
instead of a paper based system.
1
2
(
d
)
Fred saves the database on his computer’s hard drive and a second
copy on a CD-R.
(i)
State the name given to a second copy.
(ii)
State
one
reason why Fred would make a second copy.
(
e
)
(i)
Juan would like to see the information that the rugby club has
stored about him on the database.
Is Juan allowed to see this information?
Tick (
3
)
one
box only.
Yes
No
(ii)
His friend Douglas would also like to view information stored
about Juan.
Is Douglas allowed to see this information?
Tick (
3
)
one
box only.
Yes
No