year on year tracking
 

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

year on year tracking
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tony Chapman" wrote:

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