Useful for any subject following an end-of-project assessment: enables the user to enter a maximum of 40 students names and their results into the table. When selected the student information is highlighted and the results are graphically displayed on the left of the screen. Additional information is also automatically provided including the average result, class size, the students class ranking as well as the highest and lowest scores.
This is an excellent resource for tracking and monitoring students progress in each unit, as well as providing a clear record of progress and development, supporting differentiation when revisiting the topic, aiding the completion of reports and highlighting areas for improvement/revision.
This resource has been built using Microsoft Excel 2010 and is compatible with both Excel 2010 and 2013. It uses VBA programming to run the additional features including dynamic selection highlighting and automatic formatting.