Reporting Ethnicity for off roll students

[emmaburt]

WE are trying to look at Exclusion data by subgroup over 3 years. However when students go off roll their ethnicity blanks out in sims so when i run a historical report and student that are now off roll have no ethnicity in the report.

 

We look at ethnicity quite a lot as we have around 30% EAL on roll.

 

Any ideas anyone?

 

thanks

 

 

Emma

[SJT]

Hi Emma

You may be able to use the sub-report Group membership (historical) - add a filter for Group Type is Ethnicity and Active During with your choice of dates. Select Group name from the sub report and it should come up with historic Ethnicity.

[PhilNeal]

I think Discover can do this for you.

[emmaburt]

I had a look at discover and i can get the information by half term but we want it weekly.

Also when i look at 2 years ago it still looses the ethnicity for students that have gone off roll

 

- - - Updated - - -

 

thanks for the tip SJT i'll have a look at that, i thought there maybe something in history but wasn't sure where to go with it.