For any of you wanting to carry out any form of accessibility audit, you are going to need some means to record your results, as it may prove difficult to memorise the results of forty or more checkpoints across a whole swathe of pages.

To this end, I’ve knocked together a little excel spreadsheet to be used for recording Accessibility Audit Results. It has been designed more specifically for the UK public sector, who are generally required to comply with either WCAG 1.0 or 2.0 at the Double-A level of conformance.

The spreadsheet therefore allows you to record results against WCAG 1.0 or 2.0 for up to 25 pages for all checkpoints and success criteria up to and including the Double-A level of conformance. The abbreviated text for each checkpoint/success criterion links to the appropriate WCAG document to provide further information where required. Please note that at present, the triple-A conformance level details have not been included at this stage as these are not usually mandatory for public sector sites.

The spreadsheet requires you to input “PASS”, “n/a” or “FAIL” for the checkpoints/success criteria against which each page is measured. You may include additional text after this, but each cell should begin with one of these three values if you wish the conditional format colour coding and automatic calculation of compliance levels. The document is available under a Creative Commons Attribution Share-Alike licence, so you are free to make other works from it as you see fit, so long as the original attribution text is retained. I would also appreciate it if you could drop me a line to let me know what you have done with it, but this is not mandatory.

So, fill yer boots. Here’s the Accessibility Test Log (XLS, 99kb)