+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, Batch export marksheets with summary rows in Technical; Is it possible? If you go via "Tools > Performance > Assessment > Marksheets" then the "Print Marksheets" option allows ...
  1. #1

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752

    Batch export marksheets with summary rows

    Is it possible?

    If you go via "Tools > Performance > Assessment > Marksheets" then the "Print Marksheets" option allows you to add the summary rows but the export option doesn't.

  2. #2
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    If the extra columns are saved on the Template then they do export!

    In fact I have just edited the columns on a Template by removing the pre-defined ones and re-inserting others and it still does work. i.e. it delivers the amended columns!

  3. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    I'm talking about the Summary Rows that you can add to the bottom of the sheet, you can't save their on/off status and whilst the option is there to add them via print marksheet routine, it's not in export

  4. #4
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Apologies. I misread your post! Senility is fast kicking in!
    If you export 'Unformatted' then they do export!

  5. #5

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    We're getting crossed wires I think

    I know I can export them manually, one by one, from assessment manager, but what I want to do is export a batch of them in one go. I know how to export a batch (via Tools > Performance > Assessment > Marksheets), but doing it that way there is no option to add summary rows to the exported sheets

  6. #6
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Again apologies.
    Exporting Marksheets via the Bulk export method does give you the option of adding extra columns, which do then export.
    Last edited by Sivadam; 4th February 2011 at 02:01 PM.

  7. #7

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752


    I'm not trying to export the additional student data columns, I'm trying to export the summary rows. They're the 4 rows detailing Mean Points, Mean Grade, Total and Number of Results that you can add to marksheets.

  8. #8
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    It's Friday PM!
    I better go home ....................

  9. #9

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    Me too! Could do without this (apparent) SIMS fail today

  10. #10
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    I don't think it is possible.
    Looks like you will have to do it individually - or better still get the subject staff to export their own.
    Then again I ain't a clue who wants 'em or what you are hoping to do with them!

  11. #11

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    All I want to do is print them, but the formatting on SIMS' own batch print routine is awful for comment fields (they remain the same width as a grade column and end up having a word per line) so I'm having to export them and print via Excel (where, without any editing, they are formatted better!)

    If I had my way, none of them would be printed because they have access to them through SIMS, but it's very apparent that I'm here to do my job and keep my mouth shut (but that's a whole other rant!)

    Time to log another CR I think (or find an existing one).

    I think Capita could vastly improve SIMS if they got somebody to go through with a fine tooth comb and instil some consistency in to the system - it's infuriating that you can go from one screen to the next and be given completely different options, despite essentially working toward the same end goal! (this isn't the only place where SIMS lacks consistency, but I don't have time to go through picking out other examples right now)

  12. #12
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    I agree with you to some extent but what you are being asked to do seems inappropriate to me. If the Staff have access and it is them that needs the printout or whatever, then they should be doing that as it is just one/two click(s) of a button.
    The workforce reform agreement should be a two way agreement!
    And once committed to paper the data is outdated and a Data Protection risk!
    Capita have worked very hard to get SIMS available for Teacher use in the classroom - to save everybody time - including the Support Staff!
    Last edited by Sivadam; 4th February 2011 at 02:27 PM.

  13. #13

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    That's fine in theory, but this is not omission by design. If it was, then you would not be able to print directly from SIMS the exact same data, as that holds the exact same problems. I'm all for ensuring data protection, but this clearly isn't that, this is just a missing feature that would have otherwise been useful

  14. #14
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    It looks a new CR needs to be created!

  15. Thanks to Sivadam from:

    LosOjos (4th February 2011)

  16. #15

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    Did that really just happen? Somebody pinch me, I must be dreaming! Sivadam, are you agreeing with me?!

    LOL jesting aside, CR number is: 1102-843533

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [MS Office - 2003] Show standard and formatting toolbars on two rows
    By jonnykewell1 in forum Office Software
    Replies: 1
    Last Post: 16th November 2011, 11:36 AM
  2. Deleted students still appearing on marksheets
    By newcareer in forum MIS Systems
    Replies: 3
    Last Post: 6th October 2010, 08:56 AM
  3. [SIMS] Reset the completion status of marksheets?
    By LosOjos in forum MIS Systems
    Replies: 5
    Last Post: 26th May 2010, 12:21 PM
  4. Excel LOOKUP() won't work for first 384 rows
    By smithmath in forum Windows
    Replies: 0
    Last Post: 4th October 2009, 03:32 AM
  5. Export/Import into SIMS Marksheets
    By Sleepmaster in forum MIS Systems
    Replies: 1
    Last Post: 24th September 2008, 12: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
  •