KLB ICT
eResources - Graphs
In preparation for the Y8 Solar System project you need
to practise transferring tables of data from a web page into MS Excel
2000 and then producing a graph.
 Task:
-
Copy and paste the table below in MS Excel 2000
-
Produce an X-Y Scatter graph of Temperature
(Y-axis) vs Time (X-axis)
-
Try and get your graph to look as close as possible to
the example.
| Temperature (ºC) |
Colour of liquid |
Time (mins.) |
| 24 |
Clear |
0 |
| 24 |
Clear |
2 |
| 24 |
Clear |
4 |
| 24 |
Clear |
6 |
| 25 |
Slightly cloudy blue |
8 |
| 26 |
Slightly cloudy blue |
10 |
| 27 |
Thicker cloudy blue |
12 |
| 29 |
Thicker cloudy blue |
14 |
| 31 |
Cloudy blue |
16 |
| 37 |
Cloudy blue |
18 |
| 44 |
Cloudy blue |
20 |
| 48 |
Cloudy blue |
22 |
| 49 |
Cloudy blue |
24 |
| 49 |
Cloudy blue |
26 |
| 50 |
Cloudy blue |
28 |
| 50 |
Cloudy blue |
30 |
| 50 |
Cloudy blue |
32 |
|
