dcf.cymru stimulus sheet · Health and Well-being · Year 6

Class 6 water challenge log

Ysgol Penrhos, Class 6, the pupils and every number on this sheet are invented for practice. The drinks advice is from the NHS.

1. The challenge

The Healthy Schools group at Ysgol Penrhos, a primary school near Pwllheli, asked 6 pupils in Class 6 to record how many cups of water they drank during the school day (09:00 to 15:15) for one week. Each school cup holds 200 ml. Drinks at home, at breakfast and at tea were not recorded. Milk and other drinks were not recorded.

The group wants to put the results into a spreadsheet so they can find totals and means quickly.

2. The paper log (cups of water at school)

Pupil	Monday	Tuesday	Wednesday	Thursday	Friday
Ffion	2	3	2	4	4
Dylan	1	1	2	1	0
Amira	4	4	5	3	4
Rhys	3	2	3	3	4
Leah	2	2	1	3	2
Tomos	3	4	3	4	6

3. Notes from the week

Monday: rainy, 11 °C. Indoor PE.
Thursday: dry, 15 °C.
Friday: sunny, 22 °C. Sports afternoon on the field.
Dylan went home at 10:00 on Friday for a dentist appointment.

4. What the NHS says about drinks

The Eatwell Guide says people should aim to drink 6 to 8 cups or glasses of fluid a day. Water, lower fat milk and sugar-free drinks all count.
The best drinks for children are water and milk.
Children should avoid sugary fizzy drinks, squash and juice drinks.

5. Spreadsheet help card

A spreadsheet is a grid. Columns have letters (A, B, C …) and rows have numbers (1, 2, 3 …). Each box is a cell, named by its column and row, for example C4. A formula always starts with =.

Formula	What it does
`=SUM(B2:F2)`	Adds up every cell from B2 to F2 (B2, C2, D2, E2 and F2).
`=AVERAGE(B2:F2)`	Finds the mean: adds up B2 to F2, then divides by how many cells there are (5).
`=MAX(G2:G7)`	Finds the biggest number from G2 to G7. It gives the number, not the name.
`=MIN(G2:G7)`	Finds the smallest number from G2 to G7.

The colon : means “from … to”. B2:F2 goes along a row. B2:B7 goes down a column.