| Examination
Questions (page 350) |
|
1(a)
|
|
Simple
to set up and use. All the information can be fitted onto a
single sheet. Easy to make alterations if patients have to cancel
and re-arrange appointments. |
|
(b)
|
|
Appointment
sheet should have the following features: The times starting
at 10.00 in steps of twenty minutes and with the required lunch
hour and finishing at 4.00 pm. There should be a place for the
patient's name and possibly their patient number (in case there
are two patients with the same name on the same day). |
|
(c)
|
|
Working
out the cost of treatment for each patient to produce a bill.
Preparing the end-of-year accounts for the surgery. |
|
|
|
|
|
2(a)
|
|
C8 |
|
(b)
|
|
E8
and G8 |
|
(c)
|
|
C5/D5 |
|
(d)
|
|
Any
of the cells from G5 to G9 will contain a different formula.
|
|
(e)
|
|
If
costs change then the spreadsheet will re-calculate automatically.
Perform 'what if' investigations. Easy to edit the cell contents.
Can produce graphs/charts so that comparisons can be made. Can
save the spreadsheet and re-use. |
| |
|
|
|
3(a)
|
|
System
B |
|
(b)
|
|
System
D |
|
(c)
|
|
E7*C18 |
|
(d)
|
|
A15:C22
|
|
(e)
|
(i)
(ii) |
Once
the number is changed from a 4 to a 9, all those cells containing
formulae that refer to this cell will be automatically re-calculated
using the new value. Hence the spreadsheet would show the new
values instantaneously.
The new total scores are re-calculated. The new totals now suggest
that System C with the highest score should be chosen. |
|
|
|
|
|
4(a)
|
|
Cell
C5 should be shaded. |
|
(b)
|
(i)
(ii) |
SUM(I2:I6) or =I2+I3+I4+I5+I6 etc.
=B3+C3+D3+E3 |
|
(c)
|
(i)
(ii) |
H3
I3 and I7 |
| |
|
|
|
5(a)
|
|
The
size of the font can be varied which makes it more interesting
to look at.
Different fonts can be used to make the design more interesting.
Graphics or pictures can be added to attract the reader's attention.
A spellchecker can be used to make sure that the document contains
no spelling mistakes.
A grammar checker can be used to make sure that the document
contains no grammatical errors. |
|
(b)
|
|
Any
three from:
No need to learn how to use the computer
Cheaper to use the typewriter that they already have
Can take a typewriter anywhere and you are not limited by the
duration of the power supply |
| |
|
|
