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 ...
21st June 2012, 04:21 PM #1
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.
21st June 2012, 05:11 PM #2
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.
21st June 2012, 06:10 PM #3
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).
22nd June 2012, 09:15 AM #4
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.
22nd June 2012, 09:22 AM #5
Bother! I was afraid that would be the case.
Looks like it's macro-writing time.
22nd June 2012, 09:43 AM #6
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.
Thanks to pubgrub277 from:
CaterinaAnna (22nd June 2012)
22nd June 2012, 10:53 AM #7
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 ...
22nd June 2012, 11:06 AM #8
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.
22nd June 2012, 11:19 AM #9
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.
22nd June 2012, 11:33 AM #10
This is how i feel sometimes: Pic1.png
Originally Posted by CaterinaAnna
But who likes charts anyway......
22nd June 2012, 11:34 AM #11
By DaveP in forum Netbooks, PDA and Phones
Last Post: 14th February 2012, 03:06 PM
By adder1230 in forum General Chat
Last Post: 24th October 2010, 09:13 PM
By AngryTechnician in forum Downloads
Last Post: 18th February 2009, 01:12 PM
By Zoom7000 in forum Educational Software
Last Post: 15th August 2007, 09:52 AM
By acrobson in forum General Chat
Last Post: 13th June 2007, 03:10 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)