+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Assessment in Technical; Hi, Our Deputy Head would like a new report generated for every student in year 11. We currently collected Estimated ...
  1. #1
    dsm
    dsm is offline

    Join Date
    Nov 2008
    Location
    Kent
    Posts
    82
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    12

    Assessment

    Hi,

    Our Deputy Head would like a new report generated for every student in year 11.

    We currently collected Estimated Grades for each subject three times a year whilst students are in KS4. He wants to take the last 5 results and plot this on a graph for each subject.

    This feature is coming soon in our VLE however he would like this before then. An example screenshot is attached.

    What is the best way (apart from waiting for our VLE to do it in September!) to do this now? We are running SIMS - can this do what I want?

    Regards

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,528
    Thank Post
    1,460
    Thanked 1,214 Times in 823 Posts
    Rep Power
    724
    Quote Originally Posted by dsm View Post
    We are running SIMS - can this do what I want?
    This is where result sets become a heaven send! Are you using them?

    Presuming that you are using result sets, set yourself up a marksheet with all the subject's estimated grades on it (not essential but will make your life easier). Export this marksheet (unformatted) in to Excel after each grade sweep.

    What you should then have is an Excel spreadsheet with all KS4 students estimated grades in it, identifiable by the result sets used, the aspect name (which should remain constant for each subject, this is why I advise using level based titles; such as "GCSE English Estimated Grade"; rather than year based titles like "Year 10 English Estimated Grade", it makes tracking much simpler in my opinion). It's then just a case of using Excel's graph wizard to plot a chart based on these.

    All a bit vague I know, but just let me know if you want me to clarify anything
    Last edited by LosOjos; 11th May 2010 at 09:45 AM. Reason: grammar, clarification

  3. #3
    dsm
    dsm is offline

    Join Date
    Nov 2008
    Location
    Kent
    Posts
    82
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    12
    Hi,

    Thank you for your quick reply. Yes we have all of this in place using result sets. What I'm after is a system that will generate the graphs for me automatically. Generating one graph per student (160+) will take me a while :0)

    Regards

  4. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,528
    Thank Post
    1,460
    Thanked 1,214 Times in 823 Posts
    Rep Power
    724
    And that's where skim reading gets me every time

    You could try playing with Individual Reports in SIMS and adding graphs in to those, but if I remember right, that will only work with numerical results, no good in this case I don't think.

    Your other alternative is to do what I said earlier, but copy the spreadsheets in to Access, then set up a report to automatically generate the graph for each student. Again, sorry to be vague, just throwing around ideas...

  5. #5
    dsm
    dsm is offline

    Join Date
    Nov 2008
    Location
    Kent
    Posts
    82
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    12
    BUMP!

    Has anyone else had experience with this?

    Many thanks

  6. #6
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    388
    Thank Post
    161
    Thanked 67 Times in 56 Posts
    Blog Entries
    8
    Rep Power
    23
    I've tried this before, but SIMS Individual reports, as far as i can make out, doesn't seem to change the grades (A*-F) into the values you set in a result set. I've just tried to create the graph in your example, but it gave me three different values for an A grade (0.18, 9.8 and 10.5) rendering the graph useless.

    It could be that I'm missing something obviousl (no training on the individual report side of things) so I'd also be interested if anyone has any ideas...

  7. #7
    CaterinaAnna's Avatar
    Join Date
    Jun 2008
    Location
    Coventry
    Posts
    57
    Thank Post
    21
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    How many sheets is one allowed in an Excel Workbook these days?
    I ask because I can think of how to code the production (not saying I can do it mind), but it could get very messy ...

  8. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    Quote Originally Posted by CaterinaAnna View Post
    How many sheets is one allowed in an Excel Workbook these days?
    I ask because I can think of how to code the production (not saying I can do it mind), but it could get very messy ...

    In Office 2k7 limited by memory only.
    http://office.microsoft.com/en-us/ex...738491033.aspx

  9. Thanks to vikpaw from:

    CaterinaAnna (19th May 2010)

  10. #9
    CaterinaAnna's Avatar
    Join Date
    Jun 2008
    Location
    Coventry
    Posts
    57
    Thank Post
    21
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    I've got something I'd like to do a similar job for, so I'll maybe give it a go over half term.
    No promisies mind ...

  11. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    Quote Originally Posted by CaterinaAnna View Post
    I've got something I'd like to do a similar job for, so I'll maybe give it a go over half term.
    No promisies mind ...
    oh no. you've said it now. we'll hold you to it.

  12. #11
    CaterinaAnna's Avatar
    Join Date
    Jun 2008
    Location
    Coventry
    Posts
    57
    Thank Post
    21
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    Me and my big mouth!
    (Or rather fat fingers)

  13. #12
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    388
    Thank Post
    161
    Thanked 67 Times in 56 Posts
    Blog Entries
    8
    Rep Power
    23
    The only way I could think of doing it would be to export a marksheet which has all the students as rows, and the grades you want to graph as columns. Then Find and Replace the Grades with appropriate numbers (A* - 10, A - 9, B - 8 etc) and then record a macro of creating a graph for each student onto a new sheet.

    That might work...

SHARE:
+ Post New Thread

Similar Threads

  1. Assessment Manager
    By Edu-IT in forum MIS Systems
    Replies: 11
    Last Post: 29th October 2010, 02:10 PM
  2. DT Assessment sheet.
    By rush_tech in forum How do you do....it?
    Replies: 1
    Last Post: 23rd June 2008, 09:11 AM
  3. Head of Assessment
    By SpecialAgent in forum Educational IT Jobs
    Replies: 0
    Last Post: 27th April 2007, 10:52 AM
  4. Assessment for Learning
    By neoice5009 in forum Educational Software
    Replies: 1
    Last Post: 30th October 2005, 02:21 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
  •