This spreadsheet has two worksheets - Data and Display. The Data worksheet is where you can add students first and last names - in adherence with GDPR these names are edited with a formula to display the first name and initial only - as well as the effort, behaviour and homework scores for each student. The scores are in the 1-4 format where 1 is the highest grade. In addition the students current and target grade are entered to allow the spreadsheet to calculate how much progress they have made towards their target.
The Display spreadsheet has a drop-down box with all of the students names. Here you can select a student to view the data as well as a graphical display of their progress.
This has been a valuable resource during parents evenings and for 1:1 discussions with students.