MIS Systems Thread, SIMs attendance reports per lesson in Technical; Hi there
I am trying (unsuccessfully) to create attendance reports for A level reports. At present our SLT link says ...
1st October 2012, 01:40 PM #1
- Rep Power
SIMs attendance reports per lesson
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?
1st October 2012, 06:04 PM #2
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.
1st October 2012, 08:59 PM #3
- Rep Power
Originally Posted by skunk
Thanks, will get on to it tomorrow
3rd October 2012, 09:18 AM #4
@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.
3rd October 2012, 09:42 AM #5
- Rep Power
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!
3rd October 2012, 09:56 AM #6
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.
3rd October 2012, 10:55 AM #7
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.
3rd October 2012, 11:09 AM #8
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?
3rd October 2012, 12:50 PM #9
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.
3rd October 2012, 01:46 PM #10
I still don't understand why would want to report to parents by teacher if its the same class?
3rd October 2012, 02:56 PM #11
- Rep Power
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.
3rd October 2012, 02:58 PM #12
- Rep Power
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.
3rd October 2012, 03:53 PM #13
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?
3rd October 2012, 04:21 PM #14
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.
Forename & Surname
Lesson marks (filtered by date)
Hope this is of assistance.
Obviously I give no warranty of mechantability, am not liable, at your own risk, etc.
2 Thanks to skunk:
syc (3rd October 2012), vikpaw (4th October 2012)
3rd October 2012, 04:28 PM #15
- Rep Power
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.
By Shuriken1 in forum MIS Systems
Last Post: 25th August 2012, 01:25 PM
By saundersmatt in forum MIS Systems
Last Post: 14th May 2012, 11:53 AM
By IrritableTech in forum MIS Systems
Last Post: 4th May 2012, 02:38 PM
By Stuart_C in forum MIS Systems
Last Post: 3rd March 2009, 12:16 PM
By mark in forum MIS Systems
Last Post: 6th November 2006, 08:50 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)