Kyle Wong Photography
  • Home
  • Portfolio
    • Event
    • Miscellaneous
    • Nightlife
    • Portrait
    • Sports
    • Stage/Theatre
    • Wedding
  • Blog
  • Testimonials
  • About
  • Contact Me

A little Revision "app" to help visualise your progress

10/5/2014

Comments

 
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.

revision_progress_template.xlsx
File Size: 59 kb
File Type: xlsx
Download File

Instructions:
1) Open it up and you will see something like this:
Picture
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:
Picture
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:
Picture
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:
  • 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.
Comments

    Author

    Engineering Graduate from Durham University
    Freelance Photographer,
    specialised in Nightlife/Event.

    Twitter:@kyle_wong
    Instagram:@instakylewong


    My Flickr
    @instakylewong
    Instagram

    RSS Feed

    Archives

    July 2016
    March 2016
    November 2015
    July 2015
    June 2015
    April 2015
    March 2015
    January 2015
    December 2014
    August 2014
    June 2014
    May 2014
    April 2014

    Categories

    All
    Durham
    Equipment
    Event
    Misc
    Photos
    Sports
    Tips/Tutorial
    Travel
    Uni Life
    Wedding

Instagram: @instakylewong
© Copyright Kyle Wong 2020. All Rights Reserved.