[sims] Teachers of a Year Group

[tben2505]

Often it's useful to generate a list of all teachers of a specific year group.

 

I can do this using reports on SIMS.

 

However it doesn't bring through every teacher. When a class is shared by more than one member of staff, it seems only to bring through 1 teacher - I think the one identified as "main teacher" in NOVA (it might be "main supervisor" or simlar, I can't recall)

 

We know that's necessary to do because the name of the teacher on the report should be the teacher that teaches the most, which is why we identify them as such in NOVA.

 

But this might be the reason why we can't get all supervisors of a class on a report. Even if I reverse the report and ask for teachers of a class, they still don't come through.

 

Any thoughts?

 

Cheers

 

T

[RootsSchImp]

Have you tried basing your report on Staff and filtering 'where classes exist'...'where students exist'...in year x

 

An alternative would be to call up a selection timetable of everybody in NovaT, copy it to excel. Then use =if(countif(,"7*")>0,"Y","N") to highlight all teachers of year 7, repeat in separate columns for other years, then filter the excel list for teachers of a given year.

[tben2505]

Have you tried basing your report on Staff and filtering 'where classes exist'...'where students exist'...in year x

 

An alternative would be to call up a selection timetable of everybody in NovaT, copy it to excel. Then use =if(countif(,"7*")>0,"Y","N") to highlight all teachers of year 7, repeat in separate columns for other years, then filter the excel list for teachers of a given year.

 

Thank you - yes I did - and still no shared staff - I managed it my using GROUPS instead of classes - just a bit more work needed at the end in excel - shame because it's a relatively straightforward requests - expecially since all classes have a year attached to them (which isn't a selectable field)

 

Cheers

 

T

[123sch]

Interested in how you did it with groups as, like you, couldn't get it out of reports after much testing - ended up doing as Roots Schimp suggested from Nova

[tben2505]

Here you go

[123sch]

Thanks, I was concentrating my effort on "Class" in the sub report. Clever, I didn't even think of using "Group". I'm guessing the only other groups that staff would be members of, other than classes, would be a User Defined Groups.

[tben2505]

Thanks, I was concentrating my effort on "Class" in the sub report. Clever, I didn't even think of using "Group". I'm guessing the only other groups that staff would be members of, other than classes, would be a User Defined Groups.

 

Largely, yes - but it does throw out some odd ones, however filtering by year as I have tends to clean it up

Cheers