Capture Teacher fulltime equivalent by Certified /Qualified status

[Brian Lewis]

Extend the table warehouse.TeacherActivitySchool to include numbers and weightings of staff for all staff (as currently) certified , qualified, certified and qualified.

See Sheet A10 of the UIS Survey, rows 38-44

Example - suppose a teacher is Qualified, and teaches in 4 class levels. Then that teacher contributes .25 FTE Qualified teacher to each of their 4 class levels.

TeacherActivitySchool breaks this down by class level. For UIS Survey, we total these again by ISCED.

[Ghislain Hachey]

@Brian Lewis Sounds good. Just to make sure, this will not change any of the existing analysis that was based on warehouse.TeacherActivitySchool, correct?

[Brian Lewis]

It adds additional columns: currently we have

Staff - gross number of staff that teach at this class level

StaffW - “weighted” ( aka FTE) staff teaching at the class level.

This mod adds:

StaffQ - gross number of qualified staff teaching at this class level

StaffC

StaffQC

StaffQ_W - weighted number of qualified staff at the class level

StaffC_W

StaffQC_W

Just as the sum of StaffW = the total number of Staff at the school, we have

sum(StaffQ_W) = number of certified staff at the school; etc.

‌

[Brian Lewis]

feat(warehouse): sql changes for teacher activity by certified / qualified status

Resolves #1113

→ <<cset 90828a3f2ee1>>

[Brian Lewis]

applied to pacificemisdb , fedemis 6 July 20201

‌

[Brian Lewis]

Doh! Realised sheet A10 requires this split by gender, which this table still won't provide.

But I won't change warehouse.TeacherActivitySchool becuase it provides an easy way to get a range of PTRs, which to be meaningful require the teacher number NOT to split by gender (and don't want to break anything built already on this).

I’ll review again in warehouse.TeachBuildLocation and I think output a new table.