What can I do with my audits?- Matron…

Calculations

Firstly, you need to make sure you have completed your totals and frequencies.

You also need to find out your overall %’s for each audit.

To do this, divide the total that you gave, by the maximum possible for the audit, and times the result by hundred.

For example,

The total was 15. The maximum score possible on the audit was 50.

15/50*100= 30 %

Obviously, the higher the audit % the better!

What can I do with my audits then?

Several things…

For each audit you could bar graph the frequencies, which would look like this…

frequency

Of course, you can then tidy this up and paste into a Word document.

You could also bar graph the results of each audit according to the category, this person has actually stuck their graphs on to their map.

auditmap

It would be really useful to bar graph the overall %’s for each audit, this will allow you to compare them with ease.

%environmentaudit

Remember, the higher the %, the better the feature you have investigated.

Make sure all your graphs have labelled axes and titles.

Also try to make sure graphs are the same scale, this makes them easier to compare.

Mapping the location of where you took your audits is also useful. 🙂

If you need help on Excel, let me know.

This entry was posted in My place. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*

  • Subscribe

    Enter your email address:

    Delivered by FeedBurner

  • Top Posts & Pages

  • Pages

  • Categories

  • Archives