Presentation: Healthy Habits Tracker

Slide 1 of 7 · Settling starter · PSE / Well-being · Year 8

3 minutes

Healthy habits tracker: 7 rows of numbers, 2 conclusions

One invented week of sleep, activity, water, screen time and mood. You will turn the 7 rows into formulae, a colour rule, a chart and 2 conclusions. Nobody records or shares their own habits.

While the register is called: write your name, class and date on your worksheet, then read the data table and the 2 national guidelines: at least 60 active minutes a day on average, and 8 to 10 hours of sleep a night.

Starter question: Which day had the fewest active minutes, and which night had the least sleep?

DCF: Data and computational thinking → Data and information literacy The data is invented · nobody shares their own

Supply teacher script (no subject knowledge needed)

Hand out: one worksheet per pupil. Pupils need a spreadsheet (Excel, Google Sheets or LibreOffice Calc) and the file sample-habits-week.csv, which is the same 7 rows printed on the worksheet. If there are no computers, pupils do every calculation by hand in the answer column and write the formula they would have typed; the formulae are the assessed part.

Say aloud: “Name, class and date at the top. While I take the register, read the data table and the 2 guidelines in the box: young people should average at least 60 active minutes a day, and teenagers should sleep around 8 to 10 hours a night. Find the day with the fewest active minutes and the night with the least sleep.”

Starter answer: fewest active minutes is Sunday, 15; least sleep is Wednesday, 6.5 hours.

Slide 2 of 7 · Today’s brief and key words · PSE / Well-being · Year 8

2 minutes

Your brief: real formulae, one rule, one chart, 2 conclusions

You will write formulae for 9 questions, add a rule that colours the days that missed the activity target, draw 1 labelled chart, and write 2 conclusions: one the data supports, and one it does not.

Range

A block of cells, written first cell to last, such as B2:B8. Formulae use ranges, not numbers typed in by hand.

SUM, AVERAGE, COUNTIF

SUM for a total, AVERAGE for a mean, COUNTIF to count how many cells meet a condition.

Conditional formatting

A rule that changes a cell’s colour when its value meets a condition, such as less than 60.

Correlation

How closely 2 columns rise and fall together. It does not prove that one causes the other.

DCF: Data and computational thinking → Data and information literacy Headings in row 1, Monday in row 2, Sunday in row 8

Slide 3 of 7 · Step 1: open or type the data · PSE / Well-being · Year 8

8 minutes

Step 1: get the 7 rows into your spreadsheet

Open sample-habits-week.csv or type the table from your worksheet. Headings go in row 1, Monday in row 2, Sunday in row 8. Check every number against the worksheet before you move on.

Row	A: Day	B: Sleep hours	C: Active minutes	D: Water glasses	E: Screen time minutes	F: Mood 1 to 5
2	Monday	7.5	45	5	180	3
3	Tuesday	8	60	6	150	4

Step 1 on your worksheet · 8 minutes Save into the class folder, not emailed anywhere

Slide 4 of 7 · Step 2: the formula table · PSE / Well-being · Year 8

15 minutes

Step 2: work down the formula table, formula and answer

For each of the 9 questions write the formula you typed and the answer it gives. Use ranges such as B2:B8, never numbers typed in by hand.

What you need to find out	The formula you typed	The answer
Total sleep for the week	=SUM(B2:B8)	55 hours
Mean sleep per night, to 2 decimal places	=ROUND(AVERAGE(B2:B8),2)	7.86 hours

Step 2 on your worksheet · 15 minutes Wrong answer? Check the range in the brackets first

Supply teacher script (no subject knowledge needed)

Say aloud: “The first 2 rows are on the board. Copy them, then do the other 7. Write the formula and the answer. If your number is different from the board, the usual cause is B2:B9 instead of B2:B8, which pulls in an empty row.”

Quick check: best and worst sleep =MAX(B2:B8) and =MIN(B2:B8): 9 hours (Saturday) and 6.5 hours (Wednesday). Total active =SUM(C2:C8): 420 minutes. Mean active =AVERAGE(C2:C8): 60 minutes exactly. Days hitting target =COUNTIF(C2:C8,">=60"): 4 days, Tuesday, Thursday, Friday, Saturday. Mean screen time =AVERAGE(E2:E8): 190 minutes, 3 hours 10 minutes. Mean mood =ROUND(AVERAGE(F2:F8),2): 3.57. Sleep column =IF(B2>=8,"Target met","Below target") in G2 dragged to G8: 4 met, 3 below (Monday, Wednesday, Friday).

Check the arithmetic: sleep 7.5 + 8 + 6.5 + 8.5 + 7 + 9 + 8.5 = 55, and 55 ÷ 7 = 7.86. Activity 45 + 60 + 30 + 75 + 90 + 105 + 15 = 420, and 420 ÷ 7 = 60. Screen time 180 + 150 + 240 + 120 + 200 + 300 + 140 = 1330, and 1330 ÷ 7 = 190. Mood 3 + 4 + 2 + 4 + 4 + 5 + 3 = 25, and 25 ÷ 7 = 3.57.

Slide 5 of 7 · Steps 3 and 4: colour rule, chart, conclusions · PSE / Well-being · Year 8

16 minutes

Step 3 & Step 4: the colour rule and chart, then 2 conclusions

Step 3 (7 min): add a conditional formatting rule so any day below the 60-minute activity target colours itself, and write down exactly what you set. Then insert 1 chart with a title and labelled axes, and fill in the chart table.

Step 4 (9 min): write Conclusion 1, something the data does support, and Conclusion 2, something you expected that the data does not support. Quote a number from your formula table in each.

Cells the rule applies to	C2:C8, the Active minutes column only
The condition	“Format cells if less than” with the value 60

Steps 3 and 4 on your worksheet · 16 minutes 7 days of 1 invented week cannot prove a cause

Supply teacher script (no subject knowledge needed)

Say aloud: “The first 2 rows of the formatting table are on the board. In Excel it is Home, Conditional Formatting, Highlight Cells Rules, Less Than; in Google Sheets it is Format, Conditional formatting, Less than. Then make 1 chart of active minutes per day, give it a title that says what it shows, and label both axes with units. Finish with your 2 conclusions, each quoting a number.”

Quick check, formatting and chart: formatting such as red fill with dark red bold text. 3 cells change colour: Monday (45), Wednesday (30) and Sunday (15). Tuesday is exactly 60, which is not less than 60, so it stays unhighlighted. Chart: a column chart, day of the week Monday to Sunday on the horizontal axis, active minutes 0 to 120 on the vertical axis, title such as “Active minutes per day against the 60-minute target”. Not a pie chart because a pie shows parts of a whole; these are 7 separate measurements over time and a pie cannot show a target line at 60.

Quick check, conclusions: Conclusion 1: the week averaged exactly 60 active minutes, meeting the guideline, but only 4 of 7 days reached 60, Sunday managed 15, and Saturday alone contributed 105 of the 420 minutes. Conclusion 2: more screen time does not mean a worse mood here; =CORREL(E2:E8,F2:F8) gives 0.19, very weak and positive, and Saturday has the highest screen time (300) and the highest mood (5). Sleep against mood gives 0.68, but 7 days of 1 invented week cannot prove that sleep causes mood; a better mood might make sleep easier, or both might follow from whether it was a school day.

Slide 6 of 7 · Step 5: self and partner check · PSE / Well-being · Year 8

3 minutes

Step 5: check your answers against a partner’s

Compare your formula table with your partner. If 2 people disagree, one of you has the wrong range in the brackets. Tick each success criterion you meet, then correct 1 thing.

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 7 days of 1 invented week cannot prove a cause.

Step 5 on your worksheet · 3 minutes Finished early? Try =CORREL(E2:E8,F2:F8) and =CORREL(B2:B8,F2:F8)

Supply teacher script (no subject knowledge needed)

Say aloud: “Compare your 9 answers with your partner’s. Where you disagree, look at the range inside the brackets: it should be row 2 to row 8. Tick the success criteria you meet and correct 1 thing, most often a typed-in number where a range should be.”

Extension answers: screen time against mood is 0.19, sleep against mood is 0.68, so sleep is the stronger relationship, and neither proves a cause. Saturday has the most sleep (9), the most activity (105) and the most screen time (300), so a “screens are bad” headline is unsafe: the highest screen day is also the best mood day. For an 8th day dragging the activity mean below 55: the total must be below 440, so the new day needs fewer than 20 minutes (420 + x < 440).

Slide 7 of 7 · Plenary review · PSE / Well-being · Year 8

3 minutes

What did the correlation figure not prove?

Check your main answers before your worksheets are collected.

Question	Correct answer
What is the mean active minutes per day, and how many days actually hit 60?	60 minutes exactly, but only 4 of 7 days reached it.
Which days did the conditional formatting rule colour?	Monday, Wednesday and Sunday. Tuesday on exactly 60 stays uncoloured.
Sleep against mood correlates at 0.68. What does that not prove?	That sleep causes a better mood. Mood could affect sleep, or both could follow from a school day.

Check your name and class are on your worksheet Save your spreadsheet into the class folder