Pupil assessment database
Not sure if this is the right area. Please move it if not.
Currently we are using individual Excel spreadsheets to store termly pupil assessments, converting them to point scores and various other tweaks.
The issue is, if a problem is discovered with one spreadsheet, it affects all of them and you end up spending hours rectifying dozens of Excel files.
Other than SIMS (which is currently admin-only in our school, and I'm not sure how flexible it would be for this anyway) is there any (preferably free) database which makes use of a nice easy front end for staff to use to input and view data (such as Excel). I'm sure some schools have a set up using an SQL database and I'm wondering if they just design their own or if there's a template around to help me get started, but Googling such things is tricky.
I guess this sort of thing would be easy using an Access database, but SQL would surely be much better, but I've never designed an SQL database.
Am I asking too much?