year on year tracking

[Tony Chapman]

I am trying to devise a spreadsheet so that i can track pupil progress from
year to year. I know their age and their assessed reading age and want to
track the improvement year on year over the life of thier primary school
stay. I need to track how much change there is between assessed age from year
to year and also what the margin is between assessed and actual age each year

 

[Luke M]

Simple setup:
Row 1 is your header of years.
Row 2 is actual age (as this is a constant growth, its just here for
reference)
Row 3 is assesed reading age

Row 4 can be delta change in assesed reading age. Assuming data starts in
column B, in C4, input:
=C3-C2
and copy across. This is the change per year.
Similarly, to calculate margin in row 5, input in C5
=C3-B2
and copy across.

The nice thing about this setup is it lends itself easily to making charts,
if desired.