+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Spreadsheet timetable for several students in Technical; Is there a way of producing a selection timetable for a mis-matched set of students in SIMs? I can't find ...
  1. #1
    CaterinaAnna's Avatar
    Join Date
    Jun 2008
    Location
    Coventry
    Posts
    57
    Thank Post
    21
    Thanked 2 Times in 2 Posts
    Rep Power
    14

    Spreadsheet timetable for several students

    Is there a way of producing a selection timetable for a mis-matched set of students in SIMs?
    I can't find anyone asking the question here or on Support Net, so I'm beginning to woonder if it's obvious and I'm just being thick/blind.
    Or am I the only one who wants to see where Fred and Jas and Gina are throughout the week?
    Thanks in advance for any suggestions.

    Catherine

  2. #2

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    226
    Thank Post
    7
    Thanked 54 Times in 49 Posts
    Rep Power
    29
    Thats Reports>Timetables>Student Timetables

    The chooser gives you a list of all pupils on roll and you can just pick the ones to print or save out to disc.

  3. #3
    CaterinaAnna's Avatar
    Join Date
    Jun 2008
    Location
    Coventry
    Posts
    57
    Thank Post
    21
    Thanked 2 Times in 2 Posts
    Rep Power
    14
    It's not selecting the students that's the problem, it's getting the output spreadsheet style: periods along the top and a row for each pupil (or vice versa).

  4. #4

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    226
    Thank Post
    7
    Thanked 54 Times in 49 Posts
    Rep Power
    29
    Ah. I don't know a way of doing that in SIMS directly - I would normally export into Excel and do some shuffling to get that format.

  5. #5
    CaterinaAnna's Avatar
    Join Date
    Jun 2008
    Location
    Coventry
    Posts
    57
    Thank Post
    21
    Thanked 2 Times in 2 Posts
    Rep Power
    14
    Bother! I was afraid that would be the case.
    Looks like it's macro-writing time.

  6. #6
    pubgrub277's Avatar
    Join Date
    Jul 2010
    Location
    Newcastle
    Posts
    89
    Thank Post
    5
    Thanked 19 Times in 11 Posts
    Rep Power
    18
    go to reports > student list > general student list.

    On the right hand side "select data area" change the top drop down box to a"academic" information. change the second dropdown box to "timetable".
    You can then drag and drop each period onto your report to the left or use the "all periods" option to add them all at once.

    Use the filter and sort buttons at the top to change the selection of students. Then use the export button to move the data to excel.

    Think that will give you what you want.

  7. Thanks to pubgrub277 from:

    CaterinaAnna (22nd June 2012)

  8. #7
    CaterinaAnna's Avatar
    Join Date
    Jun 2008
    Location
    Coventry
    Posts
    57
    Thank Post
    21
    Thanked 2 Times in 2 Posts
    Rep Power
    14
    Thank you: that's a lot better! Not exactly what I want of course - the data for each student is spread across three rows in excel, but I can fix that.

    I've never used Student Lists, so didn't realise they were this flexible. In fact, I'm not sure any of my colleagues use it for more than printing off the default lists ...

  9. #8
    pubgrub277's Avatar
    Join Date
    Jul 2010
    Location
    Newcastle
    Posts
    89
    Thank Post
    5
    Thanked 19 Times in 11 Posts
    Rep Power
    18
    just came in a couple of releases ago i think, i've found it very useful for all kinds of quick little jobs. Much quicker than designing custom reports every time for simple jobs.
    Just wish the catalog of fields was a bit more complete, seems a bit like half a job from capita but i'm sure they'll be expanding on what you can pull into this type of report in future.

  10. #9
    CaterinaAnna's Avatar
    Join Date
    Jun 2008
    Location
    Coventry
    Posts
    57
    Thank Post
    21
    Thanked 2 Times in 2 Posts
    Rep Power
    14
    I think it came in when T4 was being phased out: I know the people that do use it here are those who would have used Nova for printing class lists in the past. Since I'd already 'done' reporting training by then, and seldom needed individual class lists, no-one showed me and I didn't play.
    I expect that Capita's response to a request for more choices will be that they're all available in Discover: bad luck for those of us who prefer tables to fancy charts (or have clunky machines). Cynical? Me? never.

  11. #10
    pubgrub277's Avatar
    Join Date
    Jul 2010
    Location
    Newcastle
    Posts
    89
    Thank Post
    5
    Thanked 19 Times in 11 Posts
    Rep Power
    18
    Quote Originally Posted by CaterinaAnna View Post
    I expect that Capita's response to a request for more choices will be that they're all available in Discover: bad luck for those of us who prefer tables to fancy charts (or have clunky machines). Cynical? Me? never.
    This is how i feel sometimes: Pic1.png
    But who likes charts anyway......

  12. #11
    CaterinaAnna's Avatar
    Join Date
    Jun 2008
    Location
    Coventry
    Posts
    57
    Thank Post
    21
    Thanked 2 Times in 2 Posts
    Rep Power
    14



SHARE:
+ Post New Thread

Similar Threads

  1. [Android] For Your Students/Teaching Staff: Timetable
    By DaveP in forum Netbooks, PDA and Phones
    Replies: 0
    Last Post: 14th February 2012, 03:06 PM
  2. Replies: 21
    Last Post: 24th October 2010, 09:13 PM
  3. Autodesk Student Community - free software for your students
    By AngryTechnician in forum Downloads
    Replies: 1
    Last Post: 18th February 2009, 01:12 PM
  4. Voting Software - Elections for Head Students!
    By Zoom7000 in forum Educational Software
    Replies: 3
    Last Post: 15th August 2007, 09:52 AM
  5. How to block GChat....Just for the students!
    By acrobson in forum General Chat
    Replies: 6
    Last Post: 13th June 2007, 03:10 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
  •