+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Behaviour Report in Technical; Would anybody be able to help me with a report. I need to run a report that generates the number ...
  1. #1

    Join Date
    Oct 2008
    Location
    Brecon
    Posts
    34
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Behaviour Report

    Would anybody be able to help me with a report.

    I need to run a report that generates the number of behaviour points a pupil has received for a date range, but all attempts seems to produce the total for the year and takes hours to run, does anyone have one they could make available to me.

  2. #2
    JohnCondon's Avatar
    Join Date
    Apr 2007
    Location
    Bromcom
    Posts
    283
    Thank Post
    47
    Thanked 64 Times in 41 Posts
    Rep Power
    26
    You'll need to say what MIS ssytem you're using.
    It'll be different in Bromcom, SIMS, Aspen etc.

  3. #3
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    if it's sims, I have a bunch made up - all are slightly tweaked from what the LA Support desk gave me.

    key thing with behaviour/achievement reports is to use Student Conduct Information, then add in that category the Points/Date/Type stuff - then set a filter against the date with "Prompt at runtime"

    it won't give you a total, and you'll have to convert the text numbers to actual numbers in excel to autosum it up, but that's about 2 seconds.

  4. #4

    Join Date
    Oct 2008
    Location
    Brecon
    Posts
    34
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Sorry, Sims

  5. #5

    Join Date
    Oct 2008
    Location
    Brecon
    Posts
    34
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Is it not possible to get it to total up in Sims, the problem is i need to generate a letter based on the highest number of points awarded, and as its SMT that will be running it, there needs to be as few as steps possible, from what your saying there is a formula in Excel then a mail merge to go through.

  6. #6
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    every report my LA Support has provided us for this kind of thing is tied to an excel template, which then does all the calculations.

    since I prefer my excel sheets I've set my own very basic reports up that I paste in - but that's yearly/weekly stuff I run for our house competitions, not on individuals.

    here are two of my LA Support reports - completely unchanged - should be one for AP, one for BP.
    Attached Files Attached Files

  7. #7

    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
    There's a built in report for aggregated student conduct points, but rather the date range is limited to between a date in the past to present. Also probably won't be great for producing the letters.
    Have a look on SupportNet file sharing at #859 or #871, though they may well have been superceded by better versions, it will be a good start. possibly similar to above files.

SHARE:
+ Post New Thread

Similar Threads

  1. Northants behaviour reporting (SIMS)
    By synaesthesia in forum East Midlands Broadband Consortium (EMBC)
    Replies: 6
    Last Post: 24th January 2013, 12:34 PM
  2. Replies: 2
    Last Post: 29th October 2011, 04:59 PM
  3. [SIMS] Reporting a students Behaviour/Achievement points total
    By Stuart_C in forum MIS Systems
    Replies: 7
    Last Post: 5th January 2011, 01:39 PM
  4. Sims.net - Reporting on Achievement and Behaviour
    By Iain.Faulkner in forum MIS Systems
    Replies: 22
    Last Post: 21st November 2009, 09:35 PM
  5. Behaviour Reporting
    By TechMonkey in forum How do you do....it?
    Replies: 8
    Last Post: 8th February 2008, 07:53 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
  •