This is my holy grail to staying organised with student data and having the one document with all the information in the one place to track data. It is also amazing when it comes to reporting time.
I have used Microsoft Excel with coding to make entering data easy. I have included tips within the document to help you understand the process.
For example: There are tabs for subject areas that you can keep, add, or remove to suit your preference. When entering an A, B, C, D or E grading the box automatically changes colour to help make it easier to track visually.
My pride and joy in particular is the Reading tab that has coloured boxes depending on the Year/Term/Semester the student was tested so you can easily track their progress and set goals.
This and so much more!
Keep in mind you may need to tweak the information here and there to make it suitable to your specific year level, grading used, assessment titles, curriculum, etc.
I hope this makes data entering and tracking easier for you.