How to Track Dissertation Milestones and References in the UK

Why a Tracking System Matters

Writing a dissertation is a marathon, not a sprint. Between literature reviews, data collection, analysis and writing, it's easy to lose sight of key dates. A simple, visual system helps you:

• See upcoming deadlines at a glance
• Keep reference details tidy and searchable
• Monitor word-count progress against targets
• Reduce stress by breaking the project into manageable chunks

Choose the Right Tool

A spreadsheet works well because it's flexible, searchable and can be accessed from any device. While a spreadsheet alone isn't a "software" for Making Tax Digital, it can be paired with any compatible tool if you need to record income later. For dissertation planning, the spreadsheet is the core organiser.

Step-by-Step Setup

1. Create a new workbook - label the first sheet "Milestones" and the second "References".
2. Set up the Milestones sheet
3. Column A: Date (use UK format DD/MM/YYYY)
4. Column B: Milestone description (e.g., "Submit literature review draft")
5. Column C: Status (Not started, In progress, Completed)
6. Column D: Word-count target for that stage
7. Column E: Notes (any blockers or resources needed)
8. Add conditional formatting - colour-code rows based on Status so you can spot overdue items instantly.
9. Populate key dates - start with university-provided deadlines (proposal submission, ethics approval, final submission) and work backwards to create realistic sub-deadlines.
10. Link to the References sheet - in the Milestones sheet, add a column "Reference IDs" where you can list the IDs of sources you'll need for that task.
11. Set up the References sheet
12. Column A: Reference ID (e.g., R001, R002)
13. Column B: Full citation (Harvard, APA, etc.)
14. Column C: Source type (book, journal, website)
15. Column D: Accessed date
16. Column E: Link or location (library call number, URL)
17. Create a simple search - use the spreadsheet's filter function to pull all references linked to a particular milestone.
18. Track word-count progress - add a summary table at the top of the Milestones sheet that totals the target word-count and compares it with the actual count you enter after each writing session.
19. Review weekly - set a recurring calendar reminder to update the sheet, mark completed tasks and adjust upcoming dates if needed.

Tips for Staying on Track

• Break large tasks into micro-tasks - instead of "Write chapter 3", list "Draft introduction (500 words)" and "Create figure 3.1".
• Use colour wisely - green for completed, amber for in-progress, red for overdue.
• Back-up regularly - store the file on cloud storage (OneDrive, Google Drive) and keep a local copy.
• Link to your writing software - if you write in Word, you can embed a hyperlink to the specific spreadsheet row for quick reference.

Frequently Asked Questions

Q: Can I use a paper planner instead of a spreadsheet? A: Yes, a paper planner works, but a spreadsheet offers instant sorting, automatic totals and easy sharing with supervisors.

Q: How often should I update the word-count targets? A: Update after each writing session. This keeps the total realistic and highlights any shortfalls early.

Q: What if my university changes the submission deadline? A: Simply edit the date in the Milestones sheet; the conditional formatting will automatically flag any new overdue items.

A Quick Shortcut

If you'd rather start with a ready-made layout, the Dissertation Milestone Tracker & Reference Log spreadsheet template provides pre-filled columns, colour-coded status tags and a built-in word-count calculator. At £7.99 it can save you hours of setup time, letting you focus on the research itself.