+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
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 ...
  1. #1
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75

    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?

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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.

  3. Thanks to vikpaw from:

    enjay (5th October 2010)

  4. #3
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    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.

  5. #4

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    173
    Should be simple with an RTF report.

    I'll have a go.

  6. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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.

  7. #6

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    173
    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?

  8. #7

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,905
    Thank Post
    1,186
    Thanked 1,057 Times in 749 Posts
    Rep Power
    328
    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.

  9. #8

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    173
    You could be right. can't get it to list subject classes only reg classes.

  10. #9
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    Quote Originally Posted by creese View Post
    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?
    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.

  11. #10

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    173
    Quote Originally Posted by enjay View Post
    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.
    Sorry for the false hope :-) I'll have another play after lunch.

  12. #11
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    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.
    Attached Files Attached Files

  13. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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...

  14. #13
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    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...

  15. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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.

  16. #15
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    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.

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

Similar Threads

  1. BCS Membership
    By garethedmondson in forum General Chat
    Replies: 29
    Last Post: 6th October 2009, 09:06 AM
  2. Is this possible - membership?
    By Diffie in forum EduGeek Joomla 1.5 Package
    Replies: 11
    Last Post: 16th March 2009, 01:07 PM
  3. Class Teacher on Grade Report
    By mioiskute in forum MIS Systems
    Replies: 1
    Last Post: 6th February 2009, 05:45 PM
  4. SIMS Report Class List with Siblings
    By mmuk08 in forum MIS Systems
    Replies: 1
    Last Post: 24th September 2008, 03:55 PM
  5. Class Server Authentication and Class Sites
    By dagza in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 15th November 2006, 12:05 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
  •