Pre-reg evidence tracker

There are 76 performance standards the GPhC states pre-registration students should meet.  The standards read like the ingredient list for a competent pharmacist (baked for one year in the heat of a dispensary).

The process of collecting evidence of meeting the performance standards is laborious.  You can at least take solace in the fact that, whilst you need more than a single piece of evidence to prove you've met a performance standard, a single piece of evidence can be proof of several performance standards.  Feel free to read that again, slowly.

Keeping track of how many pieces of evidence you have for a performance standard is important.  At worst, not doing so can mean nearing the end of your pre-registration year and finding you don't have evidence for several performance standards.  Tracking also allows you to prioritise areas which you need to gather evidence for during your year.

I've put together a spreadsheet which I hope people will find useful in tracking which performance standards they have evidence for.  You'll have to enable macros when prompted on opening.

The first worksheet titled ‘standards' is a list of all the performance standards with further information provided in comments.  I find it easier to look through than the list provided in the GPhC pre-reg manual which spans 15 pages and includes multiple asterisks.

The second worksheet titled ‘tracker' is where you'd record which performance standards you have evidence for: 

An ‘X' in the box below the performance standard represents a piece of evidence.  The number in the column named ‘#' is the reference number for that piece of evidence.  For example, in the screenshot above I have one piece of evidence for performance standard A1.5 found in evidence number 9.

The tracker only goes to five mainly to keep the size of the spreadsheet manageable.  But also because once you have more than five pieces of evidence for a performance standard you should be confident you have enough to prove you've met it (with the normal caveats of quality vs quantity).

Pressing the ‘hide detail' button provides a dashboard overview of the evidence collected so far: 

The greener the box, the more evidence collected for that performance standard.  Red indicates no evidence for the performance standard.  You might want to print this off for appraisal meetings.  It fits onto a single A4 page when set to landscape mode with narrow margins.

Lastly, checking the box next to a performance standard indicates sign-off for that standard.  An overview of which is found in the worksheet titled ‘sign-off': 

Happy tracking.

AKNOWLEDGEMENT  Thanks to Kasim Parvaiz, Gurinder Singh and Neesha Parmar for their suggestions and testing.

Download the tracker here.