[sims] SIMS Homework Diary

[knightrider]

Afternoon Guys,

 

We have got this and it works well however now I have been asked to create a report for SMT showing which staff are actually setting homework and which are not. Easy I thought. Nope. I can’t for the life of me find any definitions to use when designing a report. I’ve looked in staff, student focus and looked to see if there is a specific focus for homework but nothing. Has anyone succeeded in creating a report with data from the Homework Diary?

 

Any help much appreciated.

 

Knightrider.

[Kyle]

At this moment in time you cant create reports. Capita have promised to do somthing about this according to a post on the Support Forum. I have to do a similar thing for our SMT and at the moment i use snipping tool in WIndows 7 to put the screenshots in a document.

[knightrider]

Thanks for the heads up Kyle.

[Kyle]

This is the latest update from the Capita Forums posted yesterday:

 

We are looking to add further enhancements to Homework as part of a larger project in 2013 to include allowing teachers to record if homework has been handed in, not handed in or handed in late and perhaps also record a mark so that it can then be reported upon. Reporting was going to form part of this project however, we have taken feedback and are currently looking to see if we can fit the reporting of what is already there into the reporting dictionary for the Spring 2013 release and add further functionality to this later in the year.

[cullingsh]

I had the same request from our data manager after he had trawled through all the reports.

 

I ended up going through the sql server management studio, sims database and found the homework table, I can't remember the name of it off the top of my head. Ran a select all on the table and exported the result to excel, which the data manager could then play round with.

 

If you want me to dig up the sql query i used (inc table name etc) then I can do so on Tuesday when I'm next in, let me know.

[Kyle]

Yes that would be useful.

[knightrider]

Would be very useful.

 

Thanks.

[cullingsh]

The sql query I used was 'select * from sims.stud_homework'