dcf.cymru stimulus sheet · Science and Technology · Year 5
Ysgol Maes y Wawr data logger results: which cup keeps a drink hot?
Ysgol Maes y Wawr and every reading on this sheet are invented for practice.
1. How the test was done
- The teacher poured 200 ml of hot water at 80°C into each of 4 cups. Pupils did not touch the hot water.
- Only the flask had a lid.
- A data logger probe sat in each cup and took a reading every 5 minutes for 30 minutes.
- The classroom was 20°C.
- The test was done once.
2. The spreadsheet
Rows 9 and 10 use formulas. Only the paper cup’s formulas have been typed in so far.
| A | B | C | D | E |
|---|
| 1 | Time (min) | Paper cup (°C) | Plastic cup (°C) | China mug (°C) | Flask with lid (°C) |
|---|
| 2 | 0 | 80 | 80 | 80 | 80 |
|---|
| 3 | 5 | 68 | 70 | 72 | 78 |
|---|
| 4 | 10 | 59 | 62 | 65 | 76 |
|---|
| 5 | 15 | 52 | 55 | 59 | 74 |
|---|
| 6 | 20 | 46 | 50 | 54 | 72 |
|---|
| 7 | 25 | 41 | 45 | 50 | 70 |
|---|
| 8 | 30 | 37 | 41 | 46 | 68 |
|---|
| 9 | Drop | =B2-B8
43 | | | |
|---|
| 10 | Lowest | =MIN(B2:B8)
37 | | | |
|---|
3. The line graph
Red solid line: paper cup. Blue dashed line: plastic cup. Green dotted line: china mug. Thick black line: flask with lid. Readings every 5 minutes.