42Uploads
61k+Views
2k+Downloads
Whole school
Student Test Tracking Spreadsheet v3.5 - multiple tests
This spreadsheet will allow you to track the performance of up to 40 students for up to 10 tests. It will automatically calculate totals, percentages, grades (according to grade boundaries that you specify), comparisons to target grades, averages etc. It will also colour code performances on questions against the maximum marks available and provide you with the opportunity to print out individually tailored feedback sheets to your students.
I have found that this gives me an excellent method for communicating with students about their relative performance, rather than simply telling them that they have achieved 58% for example.
The file will come to you as a password protected document. The reason for this is so that it is not possible to make changes to the formulae and thus make it so that it does not work. You do not need to unprotect it to make full use of it, but just in case you wish to make changes, the password for the file is “table”.
I have made a video demonstrating it and telling you how to use it, which can be found at:
https://youtu.be/-_PgyXItLik
I also have a smaller version, available here on the TES website, for the analysis of just one test.
Maths quotes and inspirational posters
This is a collection of 15 posters containing quotes from a variety of mathematicians and other notable people, concerning Mathematics and inspirational things to think about success and failure. A useful addition to any classroom.
Growth Mindset Display - learning a new skill. (Can be adapted to any subject)
This flowchart display can either be printed out as a single sheet poster, or as individual components of the flowchart to be stuck to the wall. Both types are included in the resource file. It shows the methodology behind learning and acquiring a new skill. Whilst the flowchart is written for Mathematics, it can easily be adapted to any subject.
Student Test Tracking spreadsheet - single test
This spreadsheet will allow you to greater analyse the performance of your students in a test. It will automatically calculate totals, percentages, grades (according to grade boundaries that you specify) etc. It will also colour-code performances on questions against the maximum marks available and provide you with the opportunity to print out individually tailored feedback sheets to your students.
I have found that this gives me an excellent method for communicating with students about their relative performance, rather than simply telling them that they have achieved 58% for example.
The file will come to you as a password protected document. The reason for this is so that it is not possible to make changes to the formulae and thus make it so that it does not work. You do not need to unprotect it to make full use of it, but just in case you wish to make changes, the password for the file is “table”.
I have made a video demonstrating it and telling you how to use it, which can be found at:
https://youtu.be/G0_WWFINHqM
I also have a larger version available, also on the TES website, for the analysis of up to ten tests, allowing you to compare a student or class throughout those tests.