+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 19
MIS Systems Thread, Report for historic attendance figures in Technical; I am trying to write a report that will show pupil attendance figures on a certain date. If I use ...
  1. #1

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,804
    Thank Post
    1,298
    Thanked 1,659 Times in 1,112 Posts
    Blog Entries
    22
    Rep Power
    507

    Report for historic attendance figures

    I am trying to write a report that will show pupil attendance figures on a certain date.

    If I use the field '%Present + AEA' and enable supplying an effective data at runtime, it appears to always return the pupils' latest attendance figures no matter what date is supplied. If I put in any date from a previous academic year it appears to return their ending % figure.

    I can't see any other field that would seem to do the job so does anyone know how to write this report?

    TIA.

  2. #2

    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 sparkeh View Post
    I am trying to write a report that will show pupil attendance figures on a certain date.

    If I use the field '%Present + AEA' and enable supplying an effective data at runtime, it appears to always return the pupils' latest attendance figures no matter what date is supplied. If I put in any date from a previous academic year it appears to return their ending % figure.

    I can't see any other field that would seem to do the job so does anyone know how to write this report?

    TIA.
    How are you with macros?

    SIMS will only give academic year summary figures for attendance, to get more specific you'll need to dump the data out of SIMS (i.e. write a report that exports all attendance marks, filtered by date range) then analyse the data yourself in Excel. The reason I ask about macros is because if it's something that will need doing regularly, you'll be better off spending the time to develop something now so you're not asked to churn through the data manually every day/week/term

  3. Thanks to LosOjos from:

    sparkeh (5th November 2013)

  4. #3

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,804
    Thank Post
    1,298
    Thanked 1,659 Times in 1,112 Posts
    Blog Entries
    22
    Rep Power
    507
    Quote Originally Posted by LosOjos View Post
    How are you with macros?

    SIMS will only give academic year summary figures for attendance, to get more specific you'll need to dump the data out of SIMS (i.e. write a report that exports all attendance marks, filtered by date range) then analyse the data yourself in Excel. The reason I ask about macros is because if it's something that will need doing regularly, you'll be better off spending the time to develop something now so you're not asked to churn through the data manually every day/week/term
    Arrrgggghhh! >:-$

    Ok thanks
    Yeah I can write some code to do that, I have coded the next part which does stuff with the attendance figures once they have been outputted.

    Never easy it it?

  5. #4

    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 sparkeh View Post
    Never easy it it?
    Not where SIMS reports are concerned! (Not once you try to move beyond basic lists or mail merges anyway)

  6. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    At least the macro can live in the report def and run automagically.
    Just out of interest, if you run the display marks routine from lesson monitor and tell it a certain date are the summaries adjusted to that date. I'm sure that's what we used to do. Only snag is you can't schedule them to run, but it did output XML which is useful for some things.

  7. #6

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,804
    Thank Post
    1,298
    Thanked 1,659 Times in 1,112 Posts
    Blog Entries
    22
    Rep Power
    507
    Quote Originally Posted by vikpaw View Post
    At least the macro can live in the report def and run automagically.
    Oh? How do you do that?
    Just out of interest, if you run the display marks routine from lesson monitor
    Primary here, no lesson monitor.

  8. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Quote Originally Posted by sparkeh View Post
    Oh? How do you do that?

    Primary here, no lesson monitor.
    Edit Excel Output for the guide, some other threads have discussed it and potential issues or improvements - @LosOjos is darn good in that area.

    Try Focus | Attendance | Display Marks because i think it's a core report. The LM licence changes a few menu titles so my reference might be wrong.

  9. #8

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,804
    Thank Post
    1,298
    Thanked 1,659 Times in 1,112 Posts
    Blog Entries
    22
    Rep Power
    507
    Ok thanks everyone, its not as onerous as I first thought. I can just use the AM/PM marks report for the dates required and alter my current spreadsheet to calculate the overall attendance, then it can carry on its magic.

    Would be nice to have a report that just gave you the overall attendance between dates.

  10. #9
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    465
    Thank Post
    174
    Thanked 85 Times in 69 Posts
    Rep Power
    50
    One of the advantages of PAR's you can run various Attendance and other reports based on various dates you specify or even switch to previous year and specify dates in that year .

  11. #10

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,804
    Thank Post
    1,298
    Thanked 1,659 Times in 1,112 Posts
    Blog Entries
    22
    Rep Power
    507
    Quote Originally Posted by Steven_Cleaver View Post
    One of the advantages of PAR's you can run various Attendance and other reports based on various dates you specify or even switch to previous year and specify dates in that year .

  12. #11

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,332
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    You can do all sorts of date related queries on attendance etc in SIMS including looking at prior years. The home page widgets can be tailored to report on house, reg or year and to report on various periods. SIMS can even spot attendance absence patterns with pupils.

  13. #12

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,804
    Thank Post
    1,298
    Thanked 1,659 Times in 1,112 Posts
    Blog Entries
    22
    Rep Power
    507
    Thanks @PhilNeal
    Perhaps I am doing this wrong, but all I need is a report that gives a whole school roll with individual pupil overall attendance for that year, up to a given date, output to Excel.
    Can I do this without extra scripting outside of Sims?

  14. Thanks to sparkeh from:

    CAM (7th November 2013)

  15. #13
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,190
    Thank Post
    839
    Thanked 374 Times in 290 Posts
    Blog Entries
    60
    Rep Power
    284
    Agreed, one of the most common requests I get is for a report on attendance and behaviour over a specific date range and there is no way I know of in SIMS to do this via the Reporting tool without faffing around with dumped marks in Excel. If we could allow Reporting to show us data such as the Attendance% field or Behaviour Points total for a specific period instead of the current "on this Effective Date" system that would be great.

  16. 2 Thanks to CAM:

    LosOjos (7th November 2013), sparkeh (7th November 2013)

  17. #14

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,332
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    I'll get an expert to look at this and come back to you.

  18. 3 Thanks to PhilNeal:

    CAM (8th November 2013), sparkeh (7th November 2013), zag (8th November 2013)

  19. #15

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,332
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    This is what I have so far:

    Rather than trying to retrieve this data from the reporting dictionary, it is possible to run one of the built in Attendance reports such as the Percentage Attendance Report. From this you can choose your own date ranges, and then save the output as raw XML, which can then be opened and modified in Excel to then run your macros on.

  20. 2 Thanks to PhilNeal:

    sparkeh (8th November 2013), vikpaw (8th November 2013)

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

Similar Threads

  1. [SIMS] Attendance Reports for date range
    By ieuanprice in forum MIS Systems
    Replies: 1
    Last Post: 11th October 2013, 02:29 PM
  2. Online Reporting for September
    By Cache in forum CLEO
    Replies: 5
    Last Post: 12th October 2009, 07:55 PM
  3. Online reporting for parents
    By pooley in forum How do you do....it?
    Replies: 1
    Last Post: 19th May 2008, 12:15 PM
  4. Individual reports for students in SIMS
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 25th March 2008, 11:27 AM
  5. Attendance figures from SIMS inconsistent
    By kingswood in forum MIS Systems
    Replies: 2
    Last Post: 8th June 2006, 10:28 AM

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
  •