First off, apologies for writing about the exams and revision etc again, just can't help it. It is the number one priority for many students right now, including myself, hence this blog post (as the ultimate procrastination?). Now lets get to it...
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.
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.
| revision_progress_template.xlsx |
Instructions:
1) Open it up and you will see something like this:
1) Open it up and you will see something like this:
2) Fill in the columns Date/Time, Location, Exam, Comments (sorry, it is on the left because it is a bit of an after thought...) and Topics. You can also change the descriptions above the percentages/formating/cell borders etc to suit your tastes if you don't like mine.
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:
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:
3) Now simply mark your progress of each Topic on the scale with an x for how you think you are doing in said Topic (It will only work with a single, lower case x, and it will "count" up to the right most x). The "app" will then colour in the topics and give you a nicely coloured bar automatically up to and including the x.
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:
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:
4) Now it is very obvious that I really need to do some work on "Fourier" and then probably all the lower Oranges as well. Also I can prioritise in terms of which exams are the more imminent. Time to crack on!
A few last words:
I hope this helps you in your revision and that it is not too late. Fellow Durhamites, last week before exams!
Good luck!
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.
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!
Good luck!
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.
RSS Feed