Hi,
Sorry for posting two questions within the one post- my reason for this is that I do not know which I would need to complete first in order to achieve end result. ???
So...
I have created (with a lot of help) a tracking and monitoring module to record information regarding pupil assessments and pastoral notes. This worked fine for our school last year, however now that we are into a new session I have experienced some problems that need resolved.
1. Pupils need moved up a year group.
- By clicking on the link titled 'Add or Remove Pupil Names' I can manage the children within the system. The rest of the pages update from this one. Each child has moved up a year group with new children coming into nursery. I was planning on just going through the list and changing everyone's 'stage' to a year on (so for example P4 would change to P7). I would then remove the leavers (last years P7s) then add the new nursery children.
HOWEVER- Please can anyone spot if this would cause any errors with the system and is there an easier way to do this? Can there be a macro created that I could click on each year that would automatically update each child's year group.
2. This looks to be the bigger issue... By clicking on the link titled 'Summative Assessments' assessment data is displayed for each child. Unlike some of the other data within this system- this sheet will not be updated throughout the year- instead I need to archive this information then create a new sheet for this session. This will allow us to track a child's attainment year on year. I am thinking that when you click on 'Summative Assessments' instead of it displaying the data straight away, it would be better if it took us to an intermediate sheet that displayed five separate links- one for each year for the next five years ('2014-2015', '2015-2016', '2016-2017' etc). By clicking on each of these it would then show the summative assessments for that particular session.
The Summative Assessment sheet reads information from other sheets in the workbook. Therefore, a similar pathway may need created within the links titled 'Raw Data Pips+' and 'Raw Data InCAS+' ??
I would be extremely grateful for any input into this problem. Thank you all so much for your ongoing support!!
Please note: all names have been removed from this workbook for confidentiality reasons.
Kev
Bookmarks