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
spreadsheet.
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.
1
2
Page three
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.
Page five
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.
3.
Corinne is a journalist who works in Scotland for an online newspaper.
(
a
)
Corinne mainly uses a laptop computer.
State
one
reason why she would find this more useful than using a
desktop computer.
(
b
)
She mistyped one of her stories, entering the word “audio” when it
should have been “video” throughout the story.
(i)
Name the feature that would allow her to make this change in
one operation.
(ii)
Explain how she would make the changes described above.
(
c
)
Corinne makes use of a
spelling check
.
State
two
limitations of spelling checks.
1
2
(
d
)
When starting a new page of her newspaper, Corinne makes use of a
template
.
State
two
reasons why templates are used.
1
2
(continued)
(
e
)
Some of the stories she writes make use of
hyperlinks
.
State the purpose of a hyperlink.
(
f
)
When new customers subscribe to the site they are given a user ID.
Part of this user ID is a
check digit
.
State the purpose of a check digit.
(
g
)
Customers can only look at their own personal information held by
the newspaper.
State
one
group of people who are allowed to look at anybody’s
information held on a computer system.
(
h
)
The newspaper sometimes sells lists of its customers details that have
subscribed to the website.
(i)
State
one
benefit for the newspaper of selling these customer
lists.
(ii)
State
one
benefit for the company that buys these customer lists.
(iii)
Some subscribers do not want to be on these lists.
Give
one
reason why they may
not
want to be on these customer
lists.
Page seven
Page eight
4.
John is a new Internet banking customer.
(
a
)
The bank provides
online help
and
online tutorials
.
(i)
Describe what is meant by online help.
(ii)
Describe what is meant by online tutorials.
(
b
)
To access his account he has to enter a password.
When he enters his password it appears as *******
Give a reason for this.
(
c
)
John can pay his bills using
EFT
.
(i)
State what EFT stands for.
E
F
Transfer
(ii)
State
two
reasons why
shops
encourage customers to use EFT.
1
2
(
d
)
Encryption
is used when data is transferred between John’s computer
and the bank’s computers.
State what is meant by the term encryption.
(continued)
(
e
)
State
one
running cost that John will have to pay for Internet
banking.
(
f
)
Give
one
reason why banks are encouraging customers to use Internet
banking.
.
Part of an advert for a new computer system is shown below.
The Peach Computer
• The
new
computer
brings
a
new
era
in
Graphical User Interfaces
• The
latest
TFT
technology to enhance your experience
• Large
main
memory
•
Wireless
connection to the Internet possible
(
a
)
What is meant by a
Graphical User Interface
?
(
b
)
The computer system has a
TFT
monitor.
(i)
State what TFT stands for.
T
Film T
(ii)
State
one
reason why the computer system has a TFT monitor.
(
c
)
The computer system is advertised as having a large amount of
main
memory
.
Select the amount of memory the computer is most likely to have.
Tick (
?
)
one
box only.
Tick
4 Gigabyte of RAM
4 Kilobyte of RAM
4 Terabyte of RAM
Page ten
(continued)
(
d
)
The computer makes use of a wireless connection to the Internet.
State
one
advantage and
one
disadvantage of a wireless connection.
Advantage
Disadvantage
(
e
)
The computer can make use of either CD-RWs or DVD-Rs.
State
one
similarity and
one
difference between them.
Similarity
Difference
(
f
)
Programmers use a
high level language
to write programs for the
computer.
State
two
common features of high level languages.
1
2
[Turn over