C
CrimsonGhost
I am doing some coursework and I wan't to be able to set up a
spreadsheet that will automatically detect if pupils are
underacheiving. I had the idea that i could have four Columns, The
pupil name,the predicted grade, and the grade they are currently
working at. and then a final fourth column with a formula to work out
underacheivement.
I Think this will work but i need to be able to assign a value to the
letters
e.g if A grade was 1 and B grade was 2 and so on, i could work out a
formula to calculate the final column
e.g. A+E/2= Grade
1+5/2=3
3=C
so if the predicted grade was A and the final Column was C then it
would be underacheivement.
Does this make any sense to anyone? Or is there any more simpe or
better way of doing this.
any help would be great! thanks
spreadsheet that will automatically detect if pupils are
underacheiving. I had the idea that i could have four Columns, The
pupil name,the predicted grade, and the grade they are currently
working at. and then a final fourth column with a formula to work out
underacheivement.
I Think this will work but i need to be able to assign a value to the
letters
e.g if A grade was 1 and B grade was 2 and so on, i could work out a
formula to calculate the final column
e.g. A+E/2= Grade
1+5/2=3
3=C
so if the predicted grade was A and the final Column was C then it
would be underacheivement.
Does this make any sense to anyone? Or is there any more simpe or
better way of doing this.
any help would be great! thanks