So I am trying to set up a simple tracker for a school set of information.
I have the following columns:
Children's names, gender, SEN, EAL, FSM, PP and VA guide.
I'm trying to cross reference some of these with the VA guide (which is a score around the 100 mark. [I will basically be dealing with less than 100, 100 and greater than 100]).
So the problem I am having is that I am trying to count the EAL children (who are de-marked by 1 in the column) who get less than 100, 100 or more than 100.
EAL column is D
VA guide is M
and EAL are not sorted together as the children are sorted by children's names.
I have the following columns:
Children's names, gender, SEN, EAL, FSM, PP and VA guide.
I'm trying to cross reference some of these with the VA guide (which is a score around the 100 mark. [I will basically be dealing with less than 100, 100 and greater than 100]).
So the problem I am having is that I am trying to count the EAL children (who are de-marked by 1 in the column) who get less than 100, 100 or more than 100.
EAL column is D
VA guide is M
and EAL are not sorted together as the children are sorted by children's names.