Viewing and analysing your audit data
Data can be viewed in two different ways - as a summary in a bar chart, and as a table containing all the details of each peice of audit data collected. You can also download the data you have collected as a CSV file, which you can then open in a spreadsheet.
When you have set up different audits, you will be able to view and manipulate the data contained in your audits by clicking on the icons in the table pictured above. Here is a summary of what they do:
| View a summary (bar chart) of the audit data. |
| View the data in a printable table, similar to the printed version available in the downloads section. |
| Edit the audit - change the name, move data from one audit to another, and delete entries. |
| Activate the audit (to start collecting data for it) |
| Delete the audit (along with all the data collected in it) - you will be warned before doing this! |
In addition, you can compare the data collected in each audit by ticking the checkboxes on the left, then clicking on the “compare selected” button. This will show you a composite bar chart where you can view the audit data side by side.
Viewing a summary of your data
When you view your data as a summary in a bar chart, the chart shows all the food groups which are counted as part of the audit process, a bar representing how many pupils taking part in the audit have chosen these food groups, and a percentage score.
The chart also alows you to compare the data for school dinners and packed lunches by showing the data together or separately (if you uncheck the boxes at the top of the chart, you will see the chart change accordingly).
Viewing details for your audit data
You can also download the data presented in a table, showing each entry in the audit as a row in the table. This is similar to using the printable sheets in the downloads section of the website.
Comparing data between different audits
You can compare the results from up to six different audits by checking the boxes in the table showing the audits, then clicking on the “compare selected” button.
