Here is a little "app" that I put together in Excel. It is not the prettiest looking but it is simple and everyone can open it. It has only one function: to help you visualise your revision progress, so you know what needs doing the most. Initially I only did it for my own revision, but then I thought it might be helpful so I thought I would share it here (y)
You can download it right here, just click "Download File" below for the .xlsx spreadsheet file.If you found it helpful, feel free to share with your friends. You could even buy me a drink after exams if you are feeling generous :)
Scroll down a bit for instructions.
1) Open it up and you will see something like this:
If you are doing an Art subject the percentages probably won't apply, I would recommend changing and using the descriptions in the next step.
(This part is just to help you keep track of your exams and what topics you can break them down to.)
You should now have something that looks like this:
You will have to do this by evaluating how many questions you can do in a past paper so the percentages sort of reflect how you would do in an exam for each Topic.
The colour of the "bar" will depend on your progress, they are:
Red - 0-20% (Probably a good idea to prioritise these)
Orange - 30-40% (Work a little harder and you can scrape a pass)
Yellow - 50-60% (Going strong, lets go for the 2:1 or even higher now)
Light Green - 70-80% (Great job if you are in this region!)
Nice Green - 90-100% (Out of this world... you are ready!)
And here is mine, completely filled in:
A few last words:
- This "app" is designed to handle 150 rows of Topics, that should be way more than enough for your exams. (If you are running out of space, you have my deepest sympathies, I wish you the best of luck my friend...)
- If you scrolled down to row 200-350 or even 400-550, you will see loads of zero's and one's in columns F to P, please leave them be, the spreadsheet needs them to function properly.
- I know my coding is very long winded, but it works and I couldn't be bothered making it any more efficient, do forgive me.
I hope this helps you in your revision and that it is not too late. Fellow Durhamites, last week before exams!
Disclaimer: I hate to do this, but to prevent any backlash from idiots, I must stress I am not to be held responsible if this spreadsheet reported your progress wrongly and messed up your exams. If you download and use this spreadsheet, you are accepting that it is very rudimentary and simple, would probably have a bug or two that I haven't found in the hour that I spent developing it. The spreadsheet file is provided as it, take it or leave it, completely up to you.