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 ...
26th March 2013, 09:55 AM #1
- Rep Power
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.
26th March 2013, 11:50 AM #2
You'll need to say what MIS ssytem you're using.
It'll be different in Bromcom, SIMS, Aspen etc.
26th March 2013, 12:26 PM #3
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.
26th March 2013, 12:31 PM #4
- Rep Power
26th March 2013, 12:33 PM #5
- Rep Power
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.
26th March 2013, 01:33 PM #6
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.
26th March 2013, 02:18 PM #7
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.
By synaesthesia in forum East Midlands Broadband Consortium (EMBC)
Last Post: 24th January 2013, 01:34 PM
By ldh in forum MIS Systems
Last Post: 29th October 2011, 05:59 PM
By Stuart_C in forum MIS Systems
Last Post: 5th January 2011, 02:39 PM
By Iain.Faulkner in forum MIS Systems
Last Post: 21st November 2009, 10:35 PM
By TechMonkey in forum How do you do....it?
Last Post: 8th February 2008, 08:53 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)