COMPUTING STUDIES

1.
Gordon produces a monthly newsletter for the Dr What fan club. An article from
next month’s issue is shown below.
(
a
) State the text justifi
cation Gordon used on the article’s heading.
(
b
) When the article was spell-checked the word Devros was highlighted.
Explain why the spell checker highlighted this word.
(
c
) State the word processing facility that was used to make the list of costume
materials stand out.
Halloween Party
Dr What club members are looking forward to
this year’s Halloween monster costume party in
Glasgow. This is always a well attended event,
with fans travelling from all over the UK to
show off their best homemade costumes.
Last year’s winner, Matthew, spent 20 hours
creating his fabulous Devros costume from:
•
cardboard
•
plastic balls
•
tape
•
spray paint.
[Turn over
2. (continued)
(
e
) When the slides are shown, the audience hears a recording of Dennis describing
each photograph.
(i) What
two
items of hardware did Jean need to capture a sound fi
le of Dennis
describing each photograph?
1
2
(ii) Which of the fi
le types below is a sound fi
le?
Tick (
?
)
one
box.
.txt
.rtf
.avi
.wav
(iii) The sound fi
les were then compressed before they were added to the slides.
Why were the sound fi
les compressed?
(
f
) Jean’s mother asks if she can have a copy of the slideshow.
Which of the backing storage media below should be used to save a copy of the
fi
le for Jean’s mother?
Tick (
?
)
one
box.
CD ROM
DVD ROM
Internal Hard Disk Drive
USB Flash Drive

3.
Joshway Academy Teen Enterprise Club make and sell boxes of chocolates. They
use the application below to calculate how much profi
t they will make from each box.
(
a
) What
type
of application is shown in the above diagram?
Tick (
?
)
one
box.
word processor
spreadsheet
charting
database
(
b
) The Profi
t is the difference between the Selling Price and the Total Cost.
What formula has been entered in cell C16?
(
c
) Teen Enterprise add “Mint Flavouring” to a new batch of chocolates.
How could the fi
le above be altered to include this new information?

1
Teen Enterprise Chocolates
2
3
1 Box of 20 Chocolates Quantity Cost
4 Chocolate 400g £0.89
5 Sugar 50g £0.04
6 Milk 75ml £0.10
7 Cocoa butter 50g £0.23
8 Vanilla Pod 1 £0.40
9 Cardboard Box 1 £0.32
10 Plastic Insert 1 £0.12
11 Chocolate Wrappers 20 £0.05
12
Total Cost
£2.15
13
14
Selling Price
£3.50
15
16
Profi
t
£1.35
3. (continued)
(
d
) The data is sorted so that the ingredients and packaging costs are all in order
from the cheapest to the dearest.
Which sentence below best describes how to sort the data?
Tick (
?
)
one
box.
Highlight cells C4 to C11 and sort in ascending order on column C.
Highlight cells A4 to C11 and sort in ascending order on column C.
Highlight cells C4 to C11 and sort in descending order on column C.
Highlight cells A4 to C11 and sort in descending order on column C.
(
e
) The Enterprise Club use the application to produce the chart below.
State the
type
of chart shown above.