MIS Systems Thread, SIMS Homework Diary in Technical; Afternoon Guys,
We have got this and it works well however now I have been asked to create a report ...
14th November 2012, 01:02 PM #1
SIMS Homework Diary
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.
IDG Tech News
14th November 2012, 03:34 PM #2
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.
14th November 2012, 04:07 PM #3
Thanks for the heads up Kyle.
15th November 2012, 09:59 AM #4
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.
16th November 2012, 08:55 PM #5
- Rep Power
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.
19th November 2012, 12:39 PM #6
Yes that would be useful.
19th November 2012, 02:10 PM #7
Would be very useful.
20th November 2012, 03:02 PM #8
- Rep Power
The sql query I used was 'select * from sims.stud_homework'
By Stuart_C in forum MIS Systems
Last Post: 1st September 2011, 11:56 PM
By CatherineMay in forum MIS Systems
Last Post: 29th July 2011, 05:59 PM
By philjones2000 in forum MIS Systems
Last Post: 9th March 2011, 11:57 AM
By Latics4ever in forum Netbooks, PDA and Phones
Last Post: 25th March 2009, 10:51 PM
By the.damon in forum MIS Systems
Last Post: 5th November 2008, 03:55 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)