Worksheet: Healthy Habits Tracker

Cover teacher — you need no subject knowledge

Print: this sheet, one per pupil. Pupils need a spreadsheet (Excel, Google Sheets or LibreOffice Calc) and the file sample-habits-week.csv, which is the same seven rows printed in the table below. If there are no computers, pupils do every calculation by hand in the answer column and write the formula they would have typed — the data is small enough to do on paper and the formulae are the assessed part.

Run: 5 min — read the data and the two national guidelines aloud · 8 min — type or open the seven rows · 15 min — work down the formula table · 8 min — add the conditional formatting rule and the chart · 10 min — write the two conclusions · 4 min — ask the class what the correlation figure did not prove.

Collect: this sheet with the formula table and both conclusions completed. Spreadsheets are saved into the class folder, not emailed anywhere.

Note: the data is one invented week. Nobody is asked to record or share their own sleep, weight, or eating.

The data

This is the whole of sample-habits-week.csv. In a spreadsheet the headings sit in row 1 and Monday is row 2, so the seven days occupy rows 2 to 8.

Row	A: Day	B: Sleep hours	C: Active minutes	D: Water glasses	E: Screen time minutes	F: Mood 1–5
2	Monday	7.5	45	5	180	3
3	Tuesday	8	60	6	150	4
4	Wednesday	6.5	30	4	240	2
5	Thursday	8.5	75	7	120	4
6	Friday	7	90	6	200	4
7	Saturday	9	105	8	300	5
8	Sunday	8.5	15	5	140	3

The two national guidelines you are measuring against

Activity: the UK guidance for children and young people is an average of at least 60 minutes of moderate or vigorous activity a day across the week.
Sleep: NHS advice for teenagers is around 8 to 10 hours a night.

What you are doing

You are turning seven rows of numbers into something that answers a question. You will write real formulae, add a rule that colours the days that missed the activity target, draw one chart, and then write two conclusions — one the data supports, and one it does not.

Step by step

Formula table

Conditional formatting

Add a rule so that any day below the activity target colours itself. Write down exactly what you set.

Your chart

Two conclusions

Cells the rule applies to
The condition
The formatting applied
How many cells changed colour, and which days

Chart type I chose
What is on the horizontal axis
What is on the vertical axis, and its units
My chart title (it must state what the chart shows)
Why this chart type rather than a pie chart

Conclusion 1 — something the data does support. Quote a number from your formula table.

Conclusion 2 — something you might have expected that the data does not support. Again, quote a number.

Success criteria

My formulae use cell ranges such as B2:B8, not numbers typed in by hand.
I use the right function for the question: SUM for a total, AVERAGE for a mean, COUNTIF to count how many days met a target.
My conditional formatting rule uses the real 60-minute guideline, and I can say which days it highlighted.
My chart has a title and labelled axes with units, and I can justify the chart type.
One of my conclusions says what the data does not show, because seven days of one invented week cannot prove a cause.

What you need to find out	The formula you typed	The answer
Total sleep for the week
Mean sleep per night, to 2 decimal places
Best and worst night’s sleep
Total active minutes for the week
Mean active minutes per day
How many days hit the 60-minute activity target
Mean screen time per day
Mean mood score, to 2 decimal places
A column that prints “Target met” or “Below target” for each night’s sleep

Healthy habits tracker