28 Jun COMPUTING STUDIES
COMPUTING STUDIES
1.
A shoe shop uses a software package for calculating shoe sales.
(
a
) State the
type
of application package being used.
(
b
) State how cell D7 has been formatted.
(
c
) (i) The Total Cost is calculated by multiplying the Price and the
Number Sold.
State a suitable formula for cell F7.
(ii) A similar formula is needed in cells F8 and F9.
Name a feature of the application which should be used to do this.
Page two
1
1
1
1
A
B
C
D
E
F
1
Down at Heel
2
3
4
Daily Takings
5
Date
25/04/2010
6
Item Number
Description
Size
Price
Number
Sold
Total
cost
7
3245
leather boot
5
£45·99
6
£275·94
8
6543
strap sandal
7
£25·67
10
£256·70
9
4312
check boot
4
£36·98
4
£147·92
10
11
Total
£680·56
Page three
1. (continued)
(
d
) The number of boots in cell E9 has changed to 6.
Name
one
other cell that would automatically change when this number is
entered.
(
e
) The SUM function has been used in cell F11.
What does this function do?
Tick (
?
)
one
box.
Finds the largest value in a range of cells.
Multiplies the values of a range of cells.
Adds the values of a range of cells.
Finds the average of the values of a range of cells.
(
f
) The staff have decided they need to include the colour of the shoes in their
sales sheet.
This information must be displayed between Size and Price.
Describe how this change would be made.
(g) Staff are trained by listening to an audio file on an MP3
player.
State
one
item of hardware required to
record
the audio
training file.
[Turn over
3.
Tracey is studying art at college. Her designs combine a mixture of hand drawn
and computer drawn shapes.
(
a
) She creates the following shape in a graphics package.
(i) Identify the tool used to make this shape.
Tick (
?
)
one
box.
(ii) Tracey would like to edit her graphic as shown below.
Name the
two
operations which have been carried out on the picture.
1
2
Original graphic
Edited graphic
3. (
a
) (continued)
(iii) She copies her original single leaf three times and creates the following
graphic.
When she clicks on the graphic it can be moved as one shape.
Describe what she has done to make her new graphic into a single shape.
(
b
) Tracey has to demonstrate her artwork to the whole college. Below are two
pages from her multimedia presentation.
(i) Tracey wants every page to have a similar layout. She uses a feature of
the package to do this.
Name this feature.
3. (
b
) (continued)
(ii) Tracey used an input device to enter her hand drawn artwork into the
computer.
State the type of input device Tracey used.
Tick (
?
)
one
box.
Keyboard
Scanner
Web cam
Modem
(iii) During the presentation, once the slide has appeared, the slide title
disappears slowly, allowing her artwork to fill the screen.
State the text effect used on her titles.
(iv) State the most appropriate output device to display her presentation to
the whole college.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.