Reporting Weekly Attendance
I've been tasked with producing a report that gives a week by week breakdown of students percentage attendance.
Sounds simple - wish it was!
I'm aware that there are lesson monitor reports that do this, but what I'm aiming for is a spreadsheet with all the pupils listed down the rows, with weeks 1 - 52 (or however many weeks there are in a school year; haven't done that calculation yet!) listed along the columns so you're left with a big table containing all weekly attendance and overall attendance to date.
Exporting the lesson monitor reports is tedious, requires a lot of copy & pasting and throws up problems when you get to a week where a child has left so the rows no longer automatically line up any more...
So my first thought was to pull all the data in to Access and run some reports on it there. Didn't work, just got me frustrated.
My next plan is to develop a simple program that will churn through the data and dump out a CSV when it's done, but before I do that - has anybody already done something similar or know of some obvious, easy way of doing this that I've overlooked?
Don't really want to spend the afternoon coding this if somebody else already has!