Attachment 235038Hi,
I am a school teacher that is looking at developing the way I track my pupils from entry level to make sure they are making good progress. I have trailed the net for hours and cannot find the answer to my question (however, I am not great on excel so might be getting confused with how to do what it is I need to do).
Anyway, here is are my question:
I have attached my spreadsheet to show what I am trying to do.
In column G4, H4 and I4 I will be entering students levels which are given with a number and a letter for example (3a, 3b, 3c, 4a, 4b, 4c and so on). So what I am trying to do is get the average for these in column J4. Again for example I know that if a give a student a 3a, 3a and 3b that the average is a 3a but to save time I want a formula that automatically calculates this figure.
As well as this, if you look on the spreadsheet attachment I am also trying to calculate a formula that if a pupil comes in with a baseline level of 3a this student should be making 2 sub levels of progress each school year, so for example:
If I give a pupil a baseline level of 3a this pupils end of year target level should be a 4b, can I create a formula that automatically calculates this for the BASELINE LEVEL COLUMN to the END OF YEAR TARGET LEVEL?
Below shows how the levels work:
Low to High
3c
3b
3a
4c
4b
4a
5c
5b
5a
6c
6b
6a
and so on
Hope this makes sense, any help would be much appreciated.
Thanks
Bookmarks