+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, SIMS Homework Diary in Technical; ...
  1. #1
    knightrider's Avatar
    Join Date
    Mar 2006
    Location
    Leeds
    Posts
    85
    Thank Post
    18
    Thanked 10 Times in 7 Posts
    Rep Power
    19

    SIMS Homework Diary

    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.

  2. #2
    Kyle's Avatar
    Join Date
    Jan 2006
    Posts
    974
    Thank Post
    91
    Thanked 14 Times in 13 Posts
    Rep Power
    21
    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.

  3. #3
    knightrider's Avatar
    Join Date
    Mar 2006
    Location
    Leeds
    Posts
    85
    Thank Post
    18
    Thanked 10 Times in 7 Posts
    Rep Power
    19
    Thanks for the heads up Kyle.

  4. #4
    Kyle's Avatar
    Join Date
    Jan 2006
    Posts
    974
    Thank Post
    91
    Thanked 14 Times in 13 Posts
    Rep Power
    21
    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.

  5. #5

    Join Date
    Aug 2008
    Location
    norwich
    Posts
    44
    Thank Post
    1
    Thanked 7 Times in 7 Posts
    Rep Power
    14
    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.

  6. #6
    Kyle's Avatar
    Join Date
    Jan 2006
    Posts
    974
    Thank Post
    91
    Thanked 14 Times in 13 Posts
    Rep Power
    21
    Yes that would be useful.

  7. #7
    knightrider's Avatar
    Join Date
    Mar 2006
    Location
    Leeds
    Posts
    85
    Thank Post
    18
    Thanked 10 Times in 7 Posts
    Rep Power
    19
    Would be very useful.

    Thanks.

  8. #8

    Join Date
    Aug 2008
    Location
    norwich
    Posts
    44
    Thank Post
    1
    Thanked 7 Times in 7 Posts
    Rep Power
    14
    The sql query I used was 'select * from sims.stud_homework'

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Homework
    By Stuart_C in forum MIS Systems
    Replies: 2
    Last Post: 1st September 2011, 10:56 PM
  2. [SIMS] using SIMS to record homework diary checking
    By CatherineMay in forum MIS Systems
    Replies: 11
    Last Post: 29th July 2011, 04:59 PM
  3. [SIMS] Import into sims.net diary
    By philjones2000 in forum MIS Systems
    Replies: 9
    Last Post: 9th March 2011, 10:57 AM
  4. Sync SIMS Diary with my IPHONE
    By Latics4ever in forum Netbooks, PDA and Phones
    Replies: 4
    Last Post: 25th March 2009, 09:51 PM
  5. Exporting your Sims.net Diary to Outlook 2003
    By the.damon in forum MIS Systems
    Replies: 1
    Last Post: 5th November 2008, 02:55 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •