Hey there! Sign in to join this conversationNew here? Join for free

How to make a spreadsheet to track revision and progress? Watch

    • Community Assistant
    • Thread Starter

    Preferably on google docs, but edexcel would do.

    I want to make a revision tracker to track my progress to revise for my A-Levels. I read this on a TSR article:

    "I'm not one for making and sticking to timetables, but I found this actually really worked. I drew up a table in Excel and had columns for Subject, Date, Topic, Number of Hours Studied, Cumulative Number of Hours Studied for that Subject, Next Topic to Revise. I even colour-coded each subject so I could see how much I had done for each, at a glance. The benefit of doing this was that I could directly compare the number of hours I'd spent revising one subject to another, and which one I should spend longer on. Of course, some subjects may require more hours of revision than others, but I found this to be a good guide. (britchick)"

    I really want to do that but not entirely sure how to achieve the culmative hours etc without having to calculate it all manually. Spreadsheets aren't my strong point at all!

    If I was going to do a spreadsheet with the columns outlined in your post, then I would use a stopwatch to time the number of hours I'd done. For example, start the stopwatch at the beginning of revision for a topic, then stop it at the end and put the number of hours you worked for in the Number of Hours Studied column. Then do the same for each new topic you do, regularly updating the Cumulative Number of Hours Studied column for the overall subject the topics belong to, either using a calculator or spreadsheet formula, i.e. =sum([cell containing most recent cumulative number of hours])+([cell containing most recent number of hours studied]) then press Enter.

    I've attached a couple of images of an example spreadsheet I created in Google Sheets to try and illustrate what I mean about the formula, i.e. what you'd put in and the result you get. I hope that makes some sense!
    Attached Images
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    What newspaper do you read/prefer?
    Help with your A-levels

    All the essentials

    The adventure begins mug

    Student life: what to expect

    What it's really like going to uni


    Essay expert

    Learn to write like a pro with our ultimate essay guide.

    Uni match

    Uni match

    Our tool will help you find the perfect course for you

    Study planner

    Create a study plan

    Get your head around what you need to do and when with the study planner tool.

    Study planner

    Resources by subject

    Everything from mind maps to class notes.

    Hands typing

    Degrees without fees

    Discover more about degree-level apprenticeships.

    A student doing homework

    Study tips from A* students

    Students who got top grades in their A-levels share their secrets

    Study help links and info

    Can you help? Study help unanswered threadsRules and posting guidelines

    Sponsored content:



    Find out how a Higher Education Achievement Report can help you prove your achievements.

    Groups associated with this forum:

    View associated groups
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.