Turn on thread page Beta
    • Community Assistant
    • Political Ambassador
    • Thread Starter

    Community Assistant
    Political Ambassador
    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

University open days

  • University of Bradford
    All faculties Undergraduate
    Wed, 21 Nov '18
  • Buckinghamshire New University
    All Faculties Postgraduate
    Wed, 21 Nov '18
  • Heriot-Watt University
    All Schools Postgraduate
    Wed, 21 Nov '18
Black Friday: Yay or Nay?
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

Groups associated with this forum:

View associated groups

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

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