+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, [SIMS] - scripted whole school graphical view? in Technical; I've just been through SIMs with our HeadTeacher. There is obviously a huge amount of individual pupil data put into ...
  1. #1

    Join Date
    Nov 2013
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    [SIMS] - scripted whole school graphical view?

    I've just been through SIMs with our HeadTeacher. There is obviously a huge amount of individual pupil data put into the system, but it seems a very time consuming process to extract whole-school or averaged views; for example a graphical breakdown of progress for a cohort across subgroups such as FSM, or cohort APS or threshold level graphs. Something like this:
    example_graph.png
    .. or like the school or FFT dashboard summaries. Is this possible? Has anyone written scripts to access the underlying database and extract & graph the data like this?
    Obviously something like SIMs --> Gapminder would be great!

  2. #2

    Join Date
    Nov 2013
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Of course just being able to script the extraction of the that data such as grade distributions per subject per year, would be useful. This seems like such a common task to want to do and it seems very laborious to do it manually, that someone much have a set of pre-canned scripts for things like this.

  3. #3
    CAM
    CAM is online now

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,119
    Thank Post
    826
    Thanked 358 Times in 282 Posts
    Blog Entries
    60
    Rep Power
    281
    Set up one column per subject in Assessment Manager containing the grades entered by teachers. Then you can right click the column header and choose Show Dsitribution by Grade.

    I think Discover may help with whole school.

  4. #4

    Join Date
    Apr 2013
    Location
    Newcastle Upon Tyne
    Posts
    21
    Thank Post
    2
    Thanked 6 Times in 5 Posts
    Rep Power
    4
    Have a read of these two thread Idiot's guide to report templates? and Macros for excel - reporting
    I used these to make a report to chart our merit system in sims. Easiest way i found was to dump the data to a flat sheet then run a macro which generates a pivot table and pivot charts to show the data they wanted.

  5. #5

    Join Date
    Nov 2013
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks, I'll read through the links. The current situation is that the school extracts the data to spreadsheet; but this involves many clicks through many pages - each subject, each year group etc. It would be great just to run a script to automate this repetitive task. Any other links you have would to scripting multiple data extraction from SIMs would be most welcome. I'd like to go in and help them set something up, but want to get as much research and preparation done as possibile beforehand.

  6. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    I do exactly what @CAM describes. Set up a template that contains all of your aspects you want to analyse, then you can export this spreadsheet to Excel and analyse from there. Make sure to set up your Excel workbook in such a way as that next time, you can just copy and paste in the new data and all of your various formulae and graphs will update automatically. Takes a little time to setup the initial workbook, after that it's 5 minutes to copy and paste.

    You can of course script automatic data extraction (involves a mixture of SIMS reports and CommandReporter) but to be honest, for the work you'll put in to doing that and verifying the output once you have it, it's much easier to use a summary template.

  7. #7
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,152
    Thank Post
    130
    Thanked 54 Times in 47 Posts
    Rep Power
    38
    One of our Deputy Heads who is in charge of assessment stuff has recently bough 4Matrix software 4Matrix and its a good bit of software, shows nice RAG ratings for the students and pie charts/bar graphs. Hooks into sims and extracts the data and photos of students and can do print outs of which students are not achieving xyz and print off there photos if some staff cant put a name to face.

    SLT love it and its just been rolled out to all HOD's.

  8. #8
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    Prior to my school changing the assessment schedule I set all this up in Discover - works wonderfully, and with the batch creation tool, can be done extremely fast - I think to set up an entire year group only took about 15 minutes.

    From there you use the various other discover groups to add to the whole school graph, and you can very quickly see how much certain groups are under (over) performing from the whole school average.

    during the christmas break I'm hoping to get it set up with our new assessment schedule

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Whole School Assessment Summary
    By CAM in forum MIS Systems
    Replies: 5
    Last Post: 20th March 2013, 01:29 PM
  2. [SIMS] SIMS Integration (Secondary Schools)
    By dabrowa in forum MIS Systems
    Replies: 1
    Last Post: 10th March 2013, 01:00 PM
  3. Replies: 3
    Last Post: 28th June 2012, 03:43 PM
  4. SIMS: Printing whole school timetable?
    By Oops_my_bad in forum MIS Systems
    Replies: 1
    Last Post: 20th October 2009, 08:47 PM
  5. Replies: 7
    Last Post: 30th November 2006, 06:57 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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