# COMPUTING STUDIES

Jason runs a small bookshop and records the sales using a spreadsheet.
Part of it is shown below.
A
B
C
D
E
1
Weekly sales figures
2
Title
Author
Number
Sold
Price
Income
3
A Dictionary
Chambon
5
£15
·
00
£75
·
00
4
One Day
Diana Nichols
25
£3
·
50
£87
·
50
5
Raoul, My Story
Raoul Medil
8
£4
·
99
£39
·
92
6
Without a Sign
Neris Redoubt
14
£4
·
99
£69
·
86
7
8
Weekly Sales
52
Total Income
£272
·
28
9
Best Seller
25
(
a
)
(i)
The formula entered in cell E8 was E3+E4+E5+E6. Use a
function to write this in a different format.
(
:
)
(ii)
A formula is entered in cell E3.
State the formula.
(
b
)
The formula in cell E3 has been
replicated
down the column.
State what is meant by replication.
(
c
)
State
two
possible cell attributes that have been applied to cell C2.
1
2

(continued)
(
d
)
Jason wants to add a new book called, “Story of my Life”, into his
Explain how Jason could place this in the correct alphabetic order of
title
.
(
e
)
When Jason is finished updating the figures in his spreadsheet, he
decides to produce a
bar chart
showing the figures for the
Number
Sold
.
Explain why he has produced a bar chart.
(
f
)
The spreadsheet program that Jason is using is part of an
integrated
package
.
Describe
two
possible benefits to Jason of using an integrated
package.

The local boatyard keeps a list of the boats it has for sale on a database.
A sample of the information is shown below.
Make
Stormcat
Model
Storm Angler
Year Built
2009
Length (m)
5·2
Width (m)
1·8
Colour
Red
Price (£)
3,600
(
a
)
A customer is looking for a boat made by Hillyard that costs less than
£5,000.
Describe how the database could be searched to display suitable boats.
(
b
)
A customer is interested in old boats.
Describe how the data would be ordered to display this.
(
c
)
The boatyard has purchased a new boat.
State what has to be done to add this data into the database.

2.
(continued)
(
d
)
Databases can contain images.
State a suitable field type that can contain images.
(
e
)
The company has expanded and now has three boatyards throughout
Scotland.
State what has to be done to the database to show where each boat is
located.
(
f
)
As data is entered into the database it is stored in RAM rather than
ROM.
Explain why RAM is used instead of ROM.
[Turn over