MIS Systems Thread, Report of Class Membership in Technical; I want to run a report on SIMS which looks like:
Student A - English set 1 - Science set ...
5th October 2010, 09:37 AM #1
Report of Class Membership
I want to run a report on SIMS which looks like:
Student A - English set 1 - Science set 1 - Spanish set 2 (i.e. their teaching groups)
Student B - English set 2 - Science set 2 - Spanish set 1
I know how to get a list of everyone in English Y and how to see on-screen all group memberships for a given pupil, but can't find a way to export a list of all pupils and their class groups.
Does anyone know if this is possible?
5th October 2010, 12:31 PM #2
Use the new Student List Reports in SIMS. Available to all users.
Reports | Student List | General Student List
or, you can narrow it down by using the Class List or Reg Group option.
On General List however, you can add any number of filters to get the right student(s) then from the Data Area on right go to curriculum drop down and drag classes to the main screen. This populates all their classes.
Next hit Export and choose the Excel option.
Bingo Bango if i read your problem right.
5th October 2010, 12:42 PM #3
Not what I'm after (although possibly helpful, as I didn't know you could export from that screen). What you describe gives me a list of which students are in group 7 English X. What I want is a list of all the groups which a particular student (or rather, every student in a year group) is in. So, rather than seeing, as you suggest, that Maths A comprises Fred, Bill and Bob, I want to know that Fred is in Maths A, English B and Science Z, and so on. The "Focus - School - Curriculum Assignment by Pupil" option does this, but that has to be done individually for each pupil and can't be exported.
5th October 2010, 12:51 PM #4
Should be simple with an RTF report.
I'll have a go.
5th October 2010, 12:52 PM #5
I'm a little confused, i think the instructions i gave you are pupil-centric. i.e. a list of students down the page with columns representing each of their classes. Maybe i'm misunderstanding the problem still. TBH i've assumed the function does what i described and haven't looked closely at the output!
I don't mean that you should filter the list down to a class. Just filter it down to a group of students e.g. Y10. If you apply no filters you should (i think) get a list of subjects for every student on roll.
5th October 2010, 01:04 PM #6
I've got 2 columns left column pupil's name right column lists pupils classes (groups) listing down the page.
So pupils name appears once, groups list to the right, next pupil, groups to right and so on.
Filtered so far by year group.
Does that sound right?
5th October 2010, 01:17 PM #7
I was asked the very self same question by a member of our staff and although it seemed quite an easy ask it is not possible in Sims at this moment in time or so I have been told (if anyone does have the answer I will be grateful to them) but as it stands this is what I have come up against.
As you have stated enjay you can get it in singular student form but not for a group of students.
Last edited by bossman; 5th October 2010 at 01:19 PM.
5th October 2010, 01:38 PM #8
You could be right. can't get it to list subject classes only reg classes.
5th October 2010, 02:04 PM #9
That sounds exactly what I'm after, although as you said in your next post, I need this to list all their subject classes, not just registration.
Originally Posted by creese
5th October 2010, 02:10 PM #10
Sorry for the false hope :-) I'll have another play after lunch.
Originally Posted by enjay
5th October 2010, 02:10 PM #11
Okay, not sure I'm explaining myself very well, so to clear up confusion, I've mocked up what I'm after and attached it to this post.
5th October 2010, 02:15 PM #12
I'm really lost, can someone explain the problem to me please. The curriculum assignment by pupil lists the classes for a student down the page.
My export puts a list of students down the page and their classes as columns along the top. This just needs transposing.
If you make a pivot table with all data as rows, it will move the class names beneath each student name, which is like having lots of curriculum assignment by pupil lists beneath eachother...
5th October 2010, 02:17 PM #13
That does sound like what I'm looking for Vikpaw; I'll take another look at your instructions above and see where I went wrong...
5th October 2010, 02:24 PM #14
I see now.
Mine isn't quite what you want, because you'd have to extract info from the class name field to get it into your format, though in principle it would work with a couple of formulas. Otherwise you have to rely on the fact that each student does every subject, and they appear alphabetically. So ok i guess for the bulk of KS3.
5th October 2010, 02:31 PM #15
My apologies, Vikpaw - you were entirely correct, and as such are officially Da Man! I had misunderstood your line about the data area on the right. Everything sorted now.
By garethedmondson in forum General Chat
Last Post: 6th October 2009, 09:06 AM
By Diffie in forum EduGeek Joomla 1.5 Package
Last Post: 16th March 2009, 01:07 PM
By mioiskute in forum MIS Systems
Last Post: 6th February 2009, 05:45 PM
By mmuk08 in forum MIS Systems
Last Post: 24th September 2008, 03:55 PM
By dagza in forum Virtual Learning Platforms
Last Post: 15th November 2006, 12:05 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)