+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 25
MIS Systems Thread, Creating teaching group profile/context sheets in SIMS in Technical; Hi We wish to use SIMS to print off sheets for teachers which have the following information on them, to ...
  1. #1

    Join Date
    Sep 2008
    Posts
    42
    Thank Post
    10
    Thanked 3 Times in 3 Posts
    Rep Power
    12

    Creating teaching group profile/context sheets in SIMS

    Hi

    We wish to use SIMS to print off sheets for teachers which have the following information on them, to assist themwith their planning. Has anyone managed to do this (and how!)?

    Class profile sheets for every teacher/every group, showing:
    • Name
    • Vulnerable group membership: EAL, FSM, CLA, YC, BME, Mobile, Service
    • Prior Attainment Band: U/M/L
    • Gender
    • Previous levels/grades (from previous academic year) – maybe VA on there would be good too
    • Last year’s % attendance
    • KS2 Test Scores
    • Target for year and key stage
    • Medical info as necessary e.g. allergies, diabetes, asthma, colour-blindness
    • SEN status
    • a note if applicable stating ‘See SIMS’ if there is an urgent family/social/personal note


    Cheers

  2. #2

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    211
    Thank Post
    7
    Thanked 50 Times in 45 Posts
    Rep Power
    27
    Some of these are easy, and some of them harder. The select additional columns functionality in AM covers some of them, but some would require appropriate Aspects to be created in AM first (f the data was not already in the system)and populated with data.
    I think you might struggle with the Medical info, and also with Last Years attendance - attendance to date in the current year is easy to do, but from a previous acacademic year, I am not sure how you would do that.
    The alternative is to use the Student List Reporting functionality. This would be an easy way of doing hardcopy lists with most of what you want on it - its easier to get the medical information on from here but you would struggle with attendance and
    assessment data.
    Last edited by Linfit; 15th June 2012 at 10:14 AM.

  3. #3
    pubgrub277's Avatar
    Join Date
    Jul 2010
    Location
    Newcastle
    Posts
    83
    Thank Post
    4
    Thanked 17 Times in 10 Posts
    Rep Power
    17
    class sample.png
    Ive been working on student and class profiles for a number of years now.

    sample student.png

    I use command reporter to run reports from sims to gather all the data (as xml outputs), (student basic info, sen,fsm, attendance, behavior and assessment). Then use excel templates to create a set of profile sheets for staff.

    Staff have been very receptive to them and find them useful, rather than looking solely at lists of information in assessment manager for example.

    I'm confident that any information can be added into these templates to suit the needs of other schools.
    Im thinking of creating a standard template and set of reports for sims, would anyone be interested in trialing it on another site?
    Last edited by pubgrub277; 15th June 2012 at 10:59 AM.

  4. 5 Thanks to pubgrub277:

    CaterinaAnna (21st June 2012), CatherineMay (28th June 2012), kiran (16th June 2012), vikpaw (16th June 2012), Wallgo (26th June 2012)

  5. #4

    Join Date
    Sep 2008
    Posts
    42
    Thank Post
    10
    Thanked 3 Times in 3 Posts
    Rep Power
    12

    Thumbs up

    Quote Originally Posted by pubgrub277 View Post
    class sample.png
    Ive been working on student and class profiles for a number of years now.

    sample student.png

    I use command reporter to run reports from sims to gather all the data (as xml outputs), (student basic info, sen,fsm, attendance, behavior and assessment). Then use excel templates to create a set of profile sheets for staff.

    Staff have been very receptive to them and find them useful, rather than looking solely at lists of information in assessment manager for example.

    I'm confident that any information can be added into these templates to suit the needs of other schools.
    Im thinking of creating a standard template and set of reports for sims, would anyone be interested in trialing it on another site?
    Hi

    Our Data Manager and I love the look of those Excel templates you created. Exactly what we want to do here! We would love to trial it out our end if that's okay with you?

  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
    @pubgrub277 Yes, that's awesome. @Wallgo as @Linfit said some info is hard, other is easy. I've got a basic profile sheet they user per pupil to aid handover at classes in primary at end of year, but it's hard to get some data on in a report, it would take ages to run.
    It's definitely possible to get something though if experiment.

  7. #6

    Join Date
    Apr 2006
    Location
    West Midlands
    Posts
    314
    Thank Post
    29
    Thanked 19 Times in 18 Posts
    Rep Power
    20
    Quote Originally Posted by pubgrub277 View Post
    class sample.png
    Ive been working on student and class profiles for a number of years now.

    sample student.png

    I use command reporter to run reports from sims to gather all the data (as xml outputs), (student basic info, sen,fsm, attendance, behavior and assessment). Then use excel templates to create a set of profile sheets for staff.

    Staff have been very receptive to them and find them useful, rather than looking solely at lists of information in assessment manager for example.

    I'm confident that any information can be added into these templates to suit the needs of other schools.
    Im thinking of creating a standard template and set of reports for sims, would anyone be interested in trialing it on another site?
    I would love to test them at our site.... these are great! I'd also be very interested to know how you go from the .xml output to the excel template. Any info would be great.
    Last edited by kiran; 16th June 2012 at 04:45 PM.

  8. #7

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    23
    I'm in full agreement with the others on this, they look great. Put me down to have a trial as well please.

  9. #8
    pubgrub277's Avatar
    Join Date
    Jul 2010
    Location
    Newcastle
    Posts
    83
    Thank Post
    4
    Thanked 17 Times in 10 Posts
    Rep Power
    17
    Sorry, Ive been out of the office a couple of days.

    I'm busy doing a write up on how i create these, along with the reportdefs for sims and the excel sheet. The big problem i can see is the assessment data aspects in sims will vary from school to school.

    How would people feel with importing aspects specifically to make these sheets work? or would a cut and paste for the assesment data be ok for everyone?

  10. #9
    pubgrub277's Avatar
    Join Date
    Jul 2010
    Location
    Newcastle
    Posts
    83
    Thank Post
    4
    Thanked 17 Times in 10 Posts
    Rep Power
    17
    Quote Originally Posted by kiran View Post
    I would love to test them at our site.... these are great! I'd also be very interested to know how you go from the .xml output to the excel template. Any info would be great.
    In excel use the data from other sources option on the data tab (office 2007/2010). using the "from xml" option. This allows you to map the xml headers to columns in you spread sheet. You can update the xml file anytime then just click refresh all (again on the data tab) in excel an it pulls in the new info.

    This way you can set up your spread sheet template and have almost live data being pulled form sims using commandreporter.

  11. Thanks to pubgrub277 from:

    kiran (19th June 2012)

  12. #10

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    23
    I would be happy to use your reports and excel sheets as examples to work from. Cut and paste would be fine, especially as we have data held in our aspects.

  13. #11

    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
    Yep, i think if you describe the link from the aspects in report def to the spreadsheet if that's even required, each user can redefine their own report def with their own custom aspects.

  14. #12
    CaterinaAnna's Avatar
    Join Date
    Jun 2008
    Location
    Coventry
    Posts
    57
    Thank Post
    21
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    Would love to have a closer look - at the moment I end up pulling the volatile stuff from SIMs and manually lining it up with the historic data in excel ...
    However, I would need some guidance because the phrase 'command reporter' is rather scary looking.

  15. #13

    Join Date
    Jun 2012
    Location
    Bridgend
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi

    I would love to have a look at these templates, I am desperate to be able to pull information form assessment manager into excel in a template.

    Could you please add me to your list???

    Many thanks

    Tracey

  16. #14

    Join Date
    Feb 2012
    Location
    East Yorkshire
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hello

    I would really like to see this in detail as well, so would appreciate being added the list.

    Thanks

    Steve

  17. #15
    CatherineMay's Avatar
    Join Date
    Jun 2011
    Location
    Wigan
    Posts
    68
    Thank Post
    24
    Thanked 5 Times in 3 Posts
    Rep Power
    7
    Hi

    I would love to have a look at these templates, I am desperate to be able to pull information form assessment manager into excel in a template.

    Could you please add me to your list???

    Many thanks

    Catherine

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

Similar Threads

  1. [SIMS] Making your own Data Collection Sheets in SIMS
    By Stuart_C in forum MIS Systems
    Replies: 12
    Last Post: 2nd March 2013, 10:56 AM
  2. [SIMS] Creating photolists of students based on assessment data in SIMs
    By dveldtman in forum MIS Systems
    Replies: 3
    Last Post: 14th September 2011, 07:48 AM
  3. [SIMS] Batch create Aspects in SIMS?
    By tben2505 in forum MIS Systems
    Replies: 33
    Last Post: 18th May 2011, 03:56 PM
  4. [SIMS] Creating Intervention Groups into existing blocks in Nova T6
    By ellisteph10 in forum MIS Systems
    Replies: 4
    Last Post: 30th March 2011, 09:58 AM
  5. Explorer context menu in Group Policy
    By jman167 in forum Windows
    Replies: 1
    Last Post: 25th April 2008, 12:11 PM

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (1 members and 1 guests)

  1. polwd

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •