[sims] Linking a Grade Set with Attendance

[safcgac]

Hi

 

I was wondering if it was possible to link a grade set with attendance, e.g. if a student is under 80% attendance they cannot achieve the highest learning behaviour as they have not attended enough.

 

Thanks

[ajp233]

The only way to do this would be to create an aspect in which you can copy the pupils attendance. You can then create some hidden formula columns in your template for validation purposes.

 

eg. a formula column (hidden) such as if attendance < 80% then 1 else 0

a second formula column (hidden) to do a grade tally of the highest learning behaviour grade (if the user has entered that grade in the marksheet the grade tally will return 1)

a third formula column (hidden) to multiply formula column 1 by formula column 2

a final formula column (read-only but visible) - if formula column 3 equals 1 then 'learning behaviour too high' else 'OK'. You can also apply coloured shading to the formula such as red shading for the 'learning behaviour too high' message, and green for the 'OK' message.