[sims] SIMs attendance reports per lesson

[syc]

Hi there

I am trying (unsuccessfully) to create attendance reports for A level reports. At present our SLT link says that it can only be done by class and not by individual teacher as the class code is identical. As such staff are having to manually input attendance into their reports because SIMS combines subject teachers for the same A level class. Is there anyone who can help me divise a way of enabling these figures to go directly from Lesson monitor into a report so that a teacher does not have to take a paper register and count up individual lessons. Is there a code that I can add to specific subjects to enable the data to go to the right teacher?

 

thanks

[skunk]

I have a SIMS.net Report that outputs every mark in a year group to a csv file and then I use a pivot table in excel (I could probably macro this if I wanted) to find out attendance for particular groups/staff.

 

Not super efficient, but only take a couple of minutes.

[syc]

I have a SIMS.net Report that outputs every mark in a year group to a csv file and then I use a pivot table in excel (I could probably macro this if I wanted) to find out attendance for particular groups/staff.

 

Not super efficient, but only take a couple of minutes.

 

#Hi Skunk

 

Thanks, will get on to it tomorrow

[vikpaw]

@skunk - does that work for when a class is split taught? I'd have thought it would still dump it all under the same class code.

The only way i could see it, is when looked at from a teacher focus, and in their register they look at the history and it omits classes they don't teach.

@syc - Do you really need to have attendance by teacher? Not just for the class.

[syc]

Yes, Vikpaw I do need it for individual teachers. We have to write separate reports and give our attendance. They may show in our lesson but not someone elses!

[skunk]

When the staff are tt'ed to take the class, the mark gets attributed to them, regardless of the code. I think SIMS may now actually record who takes the mark, it only used to record who should take the mark.

[vikpaw]

Crazy. The default reports only want to report by the class name and show the teacher as whoever is marked as the main class teacher.

Looks like pivot table is the way to go then.

unless you timetable the group so that the different teacher has a different class code. we're looking at doing that, as our IB classes are split between Higher and Standard and the higher kids get an extra 2 periods in the same block. some kind of derived / sub-class.

[PhilNeal]

I suspect there must be something that I'm missing but if your teachers are reporting separately it sounds as if there is more than one class? Is there any reason that you can't create two classes and give complete freedom for reporting on all aspects?

[vikpaw]

Same class/course taught by multiple teachers is the scenario i was thinking of. We have it all the time. It's easier if the class code is the same.

[PhilNeal]

I still don't understand why would want to report to parents by teacher if its the same class?

[syc]

Yes, I teach British History and other teacher teaches the same kids European History. Our classes are run at different times but as the class has the same code 12B/H1 attendance marks get merged when you go parent reports. We cannot distinguish which lesson they attended with which teacher which is why I keep a paper register. Sound like there has to be a simple way of doing this.

[syc]

So i need to see if my SLT link knows that SIMs can do this! I am dealing with people who don't really know the software and think I'm making problems for them. i just want my staff to have the technology work for them.

[vikpaw]

I do find it odd that the teachers send a separate report, like for each module of the same course. I'm assuming that both histories are part of the same History Course.

When we have split teaching only the main teacher writes the report and takes comments from the other teacher if required and merges them in.

 

I can see that from the SIMS / Lesson Monitor point of view, it takes attendance for a class. Not for a teacher. The teacher is assigned to the class, so they haven't thought about reporting by teacher. You wouldn't really want to see all marks for a teacher, it would always need to be sub-filtered by class for it to be useful. Unless you want to prove that Teacher A is less popular than Teacher B.

 

If the marks are attributed to the teacher somehow, then @skunk 's report should work. Can you share it?

[skunk]

I have attached the exported report. Just remove the .txt extension to import into SIMS.

 

This lists all the marks for all the students in a given year group (7 in this case) between two dates and exports it all to a .csv file.

 

 

Column list:

 

Forename & Surname

Reg Group

Lesson marks (filtered by date)

-Mark

-Date

-Class

-Subject

-Teacher

-Recorded By

 

Hope this is of assistance.

 

Obviously I give no warranty of mechantability, am not liable, at your own risk, etc.

LM Marks - By Date.RptDef.txt

[syc]

Thank you!

I'm going to have a go and then see if it will work for what I want.I've also had someone from SIMs say to me that it sounds like a simple timetabling issue on NOVA.

[syc]

Hi Vikpaw, at my school everyone is expected to write a separate report as clearly students progress differently even in the same module. As it is, some kids attend some lessons more than others and this is what the issue is at my school over us having to report our own figures. I tell parents how many of my lessons a student has attended and so do other teachers. Merging attendance doesn't assist us in our report writing. I hope that skunks report works. If it does a VERY big thanbk you to all of you who have offered suggestions/ solutions rather than problems. x

[skunk]

@syc Our timetabler would say this is a case of the school changing because of software limitations, not the software working for the school.

[PhilNeal]

This is about the definition of a class - our definiton is same pupils same subject and any number of teachers. The pupil's class is the main reporting vechile.

[Cambridge]

Hi guys, I've solved it:The report should have the following columns:NameYearGroup membership (filtered by group and teacher where the filter 'contains' the surname of the teacher 'and' the name of the subject). There are two filters here.Why group membership is because that is how you allocate them into teacher groups of one lesson (you do that in the assignment by scheme spreadsheet).The filters need to have 'Prompt at the Run time' ticked so that anybody can form the list they need.