Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

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.

"Get 15%discount on your first 3 orderswith us"
Use the following coupon
"FIRST15"

testimonials icon
Your case brief for the week involves a search and seizure case.Brief the 1991 United States Supreme Court case Florida v. Jimeno....
testimonials icon
FIND A SOLUTION AT All A+ Essays Read t...
testimonials icon
Topic should be at least 350 words and should reflect the fact that you have completed the Reading and activities. Use your words wisely s...
testimonials icon
Commercial Damages, Liability, and Remediation Process” Please respond to the following:Give your opinion on the type...
testimonials icon
MIT OpenCourseWarehttp://ocw.mit.edu18.01 Single Variable CalculusFall 2006For information about citing these materials or our Terms of Use, visit: h...
testimonials icon
  MGT 601 Week 2 assignmentStrategic Planning Process In a four- to five-page paper (excluding the ti...
testimonials icon
Lab 2: The Chemistry of Life...
testimonials icon
Thanks a lot for sharing this good web site. Feel free to surf to my blog; %anchor_text (http://leighluna.jimdo.com/)...
testimonials icon
“Mom, they want me to play for the National Women’s Hockey League!” Josie yelled as she ran into the living room. She...
testimonials icon
please open the attached file and make sure that you can do all the question correct , number of words 3000 words : reference are Harvard s...
testimonials icon
Once you have successfully been granted a job interview you need to then prepare for that interview. Those individuals most successful durin...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65