I have inherited a nightmare of a database which, if there is no solution, is going to take months to sort out. The problem is compounded by other issues which I will lay out here:
Firstly: Last year we became a new school. Unfortunately we could not get our database up and running early so historic Aspects/Templates together with the attached Grade Sets were imported from the old school database into the new. The Head at the time was happy with what we had so it caused us no major issues.
From September this year we will have a new Head, with new ideas all of which she would like implemented by the end of the month. The biggest headache we have in all the subject grade sets are not 'our own' but are our old schools and it the grade set for each and every subject she would like us to add to. I know how do this the long winded way by making new gradesets/aspects adding them to our templates and transferring the results over but with 50+ subjects and hundreds of tmeplates this is going to take a while. Does anyone know if there anyway that this could be sorted painlessly?
Before anyone answers the compounding problem is that any grade sets/aspects, well anything really, we make are never our own but are always marked CES Installation. However once we have made them and they are marked incorrectly we can still change them.
I have brought this up 3 time with different members of Capita and they all say 'that's strange' but never do anything about it!
A little bit about me. I am pretty good with what I know, when it comes to computers, but if it is too technical I would probably need it spelt out.
Thanks for reading and if you can help doubly thank you.
Tan