| Examination
Questions (page 355) |
|
1(a)
|
(i)
(ii)
(iii) |
Ambulance B
The time it will take for each ambulance to get to the emergency.
The distance each ambulance will have to travel to get to the
emergency.
Any two such as: There are no roadworks or other obstructions
along any of the routes that they use. The time of day (some
roads may be more congested than others at certain times of
the day). The number of traffic lights/junctions which will
slow the ambulance down. |
|
(b)
|
(i)
(ii)
(iii)
(iv) |
=b3*c3
@sum(d2:d4) or a similar formula.
Cell B2 contains a number Cell C6 contains text The value of
a formula may be recalculated when the value of a number in
a cell is changed.
You could try to lower the unit cost by using a different supplier.
You could lower the quantity of the items and see how this affected
the total value. Each of the numbers could be altered to see
how the total changed. |
|
(c)
|
|
The
systems analyst find out that the problems are by talking to
the users. The systems analyst looks at all the possible ways
of integrating these information systems and works out the costs
of each option. The systems analyst reports the findings of
the feasibility study to the management. |
|
|
|
|
|
2(a)
|
|
A
mathematical representation of a real situation used to investigate
the situation and make predictions. |
|
(b)
|
|
Ability
to perform 'What If' calculations. Ability to re-calculate automatically
when some of the values in the cells are altered. Ability to
produce graphs and charts. |
|
(c)
|
(i)
(ii) |
Branch 1 had much fewer sales (about 1/3) than branch 2 yet
still managed to produce a similar profit. The predicted figures
for branch 1 were lower than the actual figures whereas with
branch 2 it was the reverse situation.
Could have another column to work out the actual sales as a
percentage of predicted sales. Could also work out the percentage
profits for each branch. |
|
|
|
|
4
|
|
Any
five such as:
Ability to zoom in and out
Pre-defined shapes
Ability to see 3D view from plan view
Ability to change colours
Easy to cut/paste
Add dimensions to drawing
Can reflect shapes
Can rotate shapes |
| |
|
|
