+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, SIMS - Struggling to make a report in Technical; I'm struggling to make a report and hope for some of you SIMS gurus can help! The report needs to ...
  1. #1

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181

    SIMS - Struggling to make a report

    I'm struggling to make a report and hope for some of you SIMS gurus can help!

    The report needs to read as follows:

    Code:
    Year Group | Reg Group | Surname | Forname | Teacher | Room
    The report needs to contain all those pupils with a '-' mark (i.e. a missing registration mark) for PM registration and display their period 5 teacher and the room that they should be in.

    It doesn't sound very hard, does it? Instructions or report definitions welcomed

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,638
    Thank Post
    683
    Thanked 1,399 Times in 1,159 Posts
    Rep Power
    353
    could do with more detail.
    is period 5 designated as your pm session or is it the one after?
    there is probably a built-in report that does most of what you want, but not all.
    room doesn't normally come up.
    can you live with forename surname in one field?
    is reg group enough to let you infer the year..?
    i'd be tempted to write a custom report.

  3. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,498
    Thank Post
    1,456
    Thanked 1,201 Times in 814 Posts
    Rep Power
    712
    I have one that will give you all the info you want but in reverse, (i.e. Teacher | Room | Student Forename | Student Surname | Year | Reg etc.) I can send you that or I could probably reverse it for you if it absolutely has to be in the order you specified (I'm just trying the lazy option first )

    EDIT:
    Also forgot to mention, it has filters for which period on which day so you can re-use it (if you want any more filters I can add those in for you too)

  4. #4

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181
    @JoshJohnson: That would be awesome! I'm sure I could rearange it myself (or just read it the other way!)... will that filter on PM registration mark for a given date?

  5. #5

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181
    Quote Originally Posted by vikpaw View Post
    could do with more detail.
    is period 5 designated as your pm session or is it the one after?
    there is probably a built-in report that does most of what you want, but not all.
    room doesn't normally come up.
    can you live with forename surname in one field?
    is reg group enough to let you infer the year..?
    i'd be tempted to write a custom report.
    It probably does need to be a custom report... period 5 and PM registration are the same but they're not. We just record AM/PM reigtration in SIMS

    The object of the report is find which teachers keep failing to register kids correctly during period 5.

  6. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,498
    Thank Post
    1,456
    Thanked 1,201 Times in 814 Posts
    Rep Power
    712
    This should do the trick, you have filters for date, period, AM/PM mark and what mark they got, as well as year group. I strongly recommend you do it a year at a time, there are 3 sub reports in it which means it'll cripple your memory if you try to run it on too many students at once!

    The period name works as follows:

    D = Day
    P = Period
    W = Week

    1 week timetable - DDD:P (e.g. Mon:1)
    2 week timetable - WDDD:AP (e.g. BMon:A1)

    (note the 'A', in our system this represents week 1, and is always 'A' even if you're looking at week 2/'B'. This might work slightly differently in your system depending how your timetables are set up)

    Let me know if you have any trouble with it, particularly with period names, they're far too awkward for my liking!

    EDIT:
    Oh I forgot to say, it will be in "Focus > Period > Student - Current Class" once you import!
    Attached Files Attached Files
    Last edited by LosOjos; 3rd March 2010 at 12:29 PM.

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,638
    Thank Post
    683
    Thanked 1,399 Times in 1,159 Posts
    Rep Power
    353
    why don't you run missing marks report or missing registers report.
    or even better activate the missing registers homepage panel and just send them high pitched squeeling messages when they dont do the register...

  8. #8

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181
    Quote Originally Posted by vikpaw View Post
    why don't you run missing marks report or missing registers report.
    or even better activate the missing registers homepage panel and just send them high pitched squeeling messages when they dont do the register...
    Because I want to see who is messing up... missing marks only shows the registration tutor (who isn't necessarily the one registering them in the afternoon).

    You'd think that they'd get the idea of how to use the registrators but some people simply aren't registering the kids correctly!

  9. #9

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181
    @JoshJohnson: Thanks for the report but it won't import

  10. #10

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,498
    Thank Post
    1,456
    Thanked 1,201 Times in 814 Posts
    Rep Power
    712
    Quote Originally Posted by Ric_ View Post
    @JoshJohnson: Thanks for the report but it won't import
    Strange... Sorry to state the bleeding obvious, but you have unzipped it?

  11. #11

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,498
    Thank Post
    1,456
    Thanked 1,201 Times in 814 Posts
    Rep Power
    712
    Maybe it's not liking the attached template (even though it's only the default Excel Portrait one...) try this version instead:

    EDIT:
    Same file size, mustn't have included it anyway... Never had a problem importing a report before
    Attached Files Attached Files

  12. Thanks to LosOjos from:

    Ric_ (3rd March 2010)

  13. #12
    danrhodes's Avatar
    Join Date
    Sep 2008
    Location
    Wath Upon Dearne
    Posts
    1,513
    Thank Post
    157
    Thanked 181 Times in 150 Posts
    Rep Power
    68
    PM Sivadam he's the Sims Guru I know!

  14. #13

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181
    Quote Originally Posted by JoshJohnson View Post
    Maybe it's not liking the attached template (even though it's only the default Excel Portrait one...) try this version instead:

    EDIT:
    Same file size, mustn't have included it anyway... Never had a problem importing a report before
    You are a genius (the report was zipped funny it turned out - I had to unzip it and then extract the file that I'd just extracted from the zip ).

    That is perfect... only thing is that our day naming strcture is different so period 5 on Tuesday of week 2 becomes 2Tue:5

  15. #14

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,498
    Thank Post
    1,456
    Thanked 1,201 Times in 814 Posts
    Rep Power
    712
    Quote Originally Posted by Ric_ View Post
    You are a genius (the report was zipped funny it turned out - I had to unzip it and then extract the file that I'd just extracted from the zip ).

    That is perfect... only thing is that our day naming strcture is different so period 5 on Tuesday of week 2 becomes 2Tue:5
    Thank God for that! Glad to be of assistance The day naming structure in Sims can get confusing beyond belief, glad you sussed it and it works though

SHARE:
+ Post New Thread

Similar Threads

  1. Sims Report with Photos
    By Geoff in forum MIS Systems
    Replies: 8
    Last Post: 18th September 2009, 10:24 PM
  2. Sims report help
    By Jamie_a in forum MIS Systems
    Replies: 1
    Last Post: 4th October 2008, 04:34 PM
  3. Report Wisely: Make Sense of Your Online Assessment Results
    By W.Peterson in forum Virtual Learning Platforms
    Replies: 6
    Last Post: 10th September 2008, 03:51 AM
  4. Sims report Template
    By imiddleton25 in forum MIS Systems
    Replies: 1
    Last Post: 27th June 2008, 05:08 PM
  5. Another Sims Report
    By Jamie_a in forum MIS Systems
    Replies: 2
    Last Post: 29th January 2008, 04:58 PM

Thread Information

Users Browsing this Thread

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

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
  •