The first example wouldn't work unless you have the same grades for effort and attainment, you will also end up with a long list of resultsets which can't be filtered the same as the list of aspects. The second option in my opinion is the best and will work with tracking grids and allow for useful analysis, as the resultsets are each data collection you can make use of locking resultsets to manage data entry as well.
Tools- System Diagnostics - Database diagnostics can fix this, try running it and see if it has filled in, if not I believe there is a patch which your SIMS support should be able to help with.
Achievement points are recorded separately from Behaviour points, there is a Conduct Points measure that is basically the Achievement minus the Behaviour but that is a separate measure.
That's what we currently have, unfortunately that only writes back the formative data, we would then have to go into SIMS and assign an overall grade, we would end up having teachers going into two different systems.
I thought I would pose the following question to the hive mind... Does anyone know of any Primary Assessment Tracking software that would write back an overall subject grade into SIMS.net? if not does anyone have experience of any software that exports data in a SIMS.net friendly format?
Thanks in advance!