Well this is very interesting, the grade and the competency rating all in one place.
I will assume that you are not using Learning Plans, since you have been able to pull everything into your custom Grade Report.
Pulling in the All Students who did/or did not achieve their required level of competency would probably require a custom table, where each Organization and number of skilled students required per competency is stored.
Assembly Area A (organization area ID) - 10 students skilled at Fixture Design (competency ID)
Assembly Area B - 5 students skilled at Fixture Design
Assembly Area C - 25 students skilled at Fixture Design.
Across all organizations - 40 students must be skilled at Fixture Design.
Across all organizations - 25 students have achieved the skill Fixture Design.
Across all organizations - 15 students have not yet achieved the skill Fixture Design - Competency Gap = the 15 students without the Fixture Design competency.
I will assume that you are not using Learning Plans, since you have been able to pull everything into your custom Grade Report.
Pulling in the All Students who did/or did not achieve their required level of competency would probably require a custom table, where each Organization and number of skilled students required per competency is stored.
Assembly Area A (organization area ID) - 10 students skilled at Fixture Design (competency ID)
Assembly Area B - 5 students skilled at Fixture Design
Assembly Area C - 25 students skilled at Fixture Design.
Across all organizations - 40 students must be skilled at Fixture Design.
Across all organizations - 25 students have achieved the skill Fixture Design.
Across all organizations - 15 students have not yet achieved the skill Fixture Design - Competency Gap = the 15 students without the Fixture Design competency.