Ideas for automating analysis of SIMS assessment data in Excel
Think this is a long shot but thought I would post anyway.
I run assessment at a large sec. modern and currently produce a report (ring bound booklet) containing lists of specific pupils (pupils on target 5A*-C, pupils with <85% attendance, pupils arriving with KS2 L4 etc) along with headlines and various bits of analysis.
I have an excel spreadsheet set up which has a tab for the raw data (targets and attainment) and these feed in to the analyses to give me the headlines etc. The arduous part comes in when printing the report. There are 20 focus groups in all, which we have to filter from the raw data to start with on whatever the criteria is, then hide out the columns we dont need, then rename the header to say the name of the group then print page by page. For 20 focus groups this takes about a day or so to produce the whole thing. This is far too long and I can't help thinking there must be a quicker way.
Any feedback or input would be gratefully recieved. I've spent so long staring at it I've lost any sense of objectivity or idea!!!