+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Whole School Assessment Summary in Technical; How would you go about presenting an overall summary of each year group's assessment results to all staff on-demand by ...
  1. #1
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,203
    Thank Post
    843
    Thanked 377 Times in 292 Posts
    Blog Entries
    60
    Rep Power
    285

    Whole School Assessment Summary

    How would you go about presenting an overall summary of each year group's assessment results to all staff on-demand by using SIMS? Currently we put all results into a very large spreadsheet but even though it can be filtered, staff complain it's too big and that filtering takes hours. (It's a drop-down box!)

    I keep thinking of making marksheets with all results by year (and ideal for the sake of keeping data up-to-date!) but it always leads back to having to filter anyway just like the current solution, but harder to work with and find the data due to the often choppy SIMS UI.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,641
    Thank Post
    685
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    I always made whole year group summary marksheets with every result. In my last school, this meant 3 separate marksheets, Core, Langs and DT+options etc.
    Here we can fit it all on one due to only two main reporting cycles.
    I think Spring takes the limit off columns.
    You could create multiple clones, and filter them per clone, but then you might as well delete the extraneous columns. (Always easier to make a massive global sheet and delete columns )

  3. Thanks to vikpaw from:

    CAM (20th March 2013)

  4. #3
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    we have marksheets that cover the whole year group, and all courses that are being taken.

    we task our HoDs with pulling data from the marksheets so that they are aware.

    I pull data out and populate a master spreadsheet that kicks out charts for SLT, as well as maintains our "Ofsted Ready" document.

    ML with data responsibilities types up a word document that goes over all the key stuff and emails that around to all staff.

    Currently I'm setting discover up so that teaching staff can quickly look at their departments and know where students are/have been during the various reporting periods - really nice things can be done when you include UDGs and such in discover - dragging my ever-6 group onto the attainment charts gives me an instant view of where they are at compared to the whole school, and saves me having to do it in AM.

    I'm actually spending more time recently trying to get HoDs and their staff to use the data that is in SIMS so that I can get rid of some of the spreadsheets - as personally I love Excel, but as soon as data goes in, it's out of date.

  5. Thanks to tombry from:

    CAM (20th March 2013)

  6. #4
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,203
    Thank Post
    843
    Thanked 377 Times in 292 Posts
    Blog Entries
    60
    Rep Power
    285
    Ditching Excel for keeping everything in AM7 is something both me and the teacher unions would love. My concern though is the spreadsheet is in a well known area of the network drive whilst AM7 will involve hunting for it in Marksheet Entry, if possible at all to see it. I'd love to make say, a Year 11 sheet but pointless if only the Y11 HOD can see it instead of everyone.

  7. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,641
    Thank Post
    685
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    You can make marksheets favourite / categorise for easier finding, but as you say, the groups and view permissions are not easily configured.

  8. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,512
    Thank Post
    1,457
    Thanked 1,206 Times in 818 Posts
    Rep Power
    723
    Quote Originally Posted by CAM View Post
    Ditching Excel for keeping everything in AM7 is something both me and the teacher unions would love.
    We have the same situation here but unfortunately, you just can't produce the summarised data, statistics, overviews, graphs, charts etc. that Excel is easily capable of in SIMS. That's why for the time being at least, we have a basic marksheet in AM7 with all subjects on for each year group and relevant marksheets set up within that (tutor groups, intervention groups etc.) and teach users how to use filters and pull percentages from the grade distribution option. That is OK for basic, quick peek type "analysis", but for the real useful trending and focus area things, we populate a spreadsheet from a whole year marksheet (taken from the same template) and put this on our VLE for staff to access.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 13
    Last Post: 11th June 2009, 11:38 PM
  2. Whole school to go Mac?
    By birchanger in forum Mac
    Replies: 43
    Last Post: 3rd April 2009, 08:17 AM
  3. Whole School Network Manager - Dewsbury
    By jcollings in forum Educational IT Jobs
    Replies: 0
    Last Post: 3rd November 2008, 05:55 PM
  4. Whole school network freezing
    By standunstan in forum ICT KS3 SATS Tests
    Replies: 15
    Last Post: 28th March 2007, 08:59 AM
  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)

Posting Permissions

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