+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Automatically generating report for classes with assessment data in Technical; I have been running reports on SIMS using commandreporter.exe and feeding the results into excel which automatically (using scheduled tasks) ...
  1. #1

    Join Date
    Oct 2011
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Automatically generating report for classes with assessment data

    I have been running reports on SIMS using commandreporter.exe and feeding the results into excel which automatically (using scheduled tasks) updates based on the new data. I would like to do the same with the classes that I teach to give me an up-to-date spreadsheet with all their assessment data on it. I realise that I can get this information from our pupil tracking sheets but I would like control over the data I get and of course I want it to update automatically.

    My problem is that I don't know where in the report designer I can find the assessment data. I have tried 'assessment results'>'results' but I can't seem to find the variable that has my data stored in it. I'm specifically looking for 'Y7 Collection 1 Grade'.

    I would like the resulting file to look something like this:

    Surname Forename Y7 Collection 1 Grade

    Bloggs Joe 4b

    I'm really sorry if this question has been answered elsewhere, I have looked but I cant find it. I'd really appreciate if someone would point me towards the solution if it has.

    Any ideas?

    James

  2. #2

    Join Date
    Jun 2010
    Location
    Leicestershire
    Posts
    152
    Thank Post
    17
    Thanked 18 Times in 16 Posts
    Rep Power
    12
    You would need to design a report with a student focus, then choose Assessment as a sub report where you can specify aspect name & result set.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 30
    Last Post: 14th September 2011, 10:05 PM
  2. Replies: 3
    Last Post: 6th November 2006, 07:50 PM
  3. Replies: 10
    Last Post: 25th October 2006, 04:49 PM
  4. For those with Mac Minis
    By Ric_ in forum General Chat
    Replies: 1
    Last Post: 24th November 2005, 07:46 AM

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
  •