OK, if you've been using the vels visual auditing spreadsheet for a while, found it useful, distributed it around your school, then you might want to integrate the results from multiple audits back into one file. (If you haven't been using it, you should start there rather than on this page).

So, now you can use a seperate tool to collate the results from seperate audit files back into one master file.

And keeping up the visual theme, you can see the collated results graphically - ie the cumulative coverage of each dimension, and also still see the individual contributions

looks like this

the total length of each bar is derived from individual audits (either different columns in one audit file, or different audit files)

There is a key, which looks something like this : - in this case showing 4 subjects in the audit.

You can hover the mouse over a segment - in the example above it show us that Year 8 French contributed "1" - the yellow segment - to the "Building Social Relationships" dimension (ie it must have been marked with a dot in the orginal audit). The long purple segment, to the left of this yellow segment, indiciates a year 7 english class, which more fully addresses this dimension - rolling over it would show a value of 3). Similarly there are two subjects which are serious about addressing the community engagement standard.

And you can view it as table of data if you prefer.

You'll need to use some discretion about how you collate the data. It won't stop you from aggregating data from different levels - eg it will let you add Reading at level 4, to Reading at level 6, and while you can still distinguish the bars, it probably doesn't make sense to add them like this. On the other hand you might want to do a whole school audit on "Community Engagement" - and add the results from the levels together. So you'll need to decide if you just aggregate a discipline, or a year level, or a VELS level (2 years) at a time - whatever suits your need.

(There is a "skip" option that lets you skip particular columns during the import, so you can selectively add parts of an audit. Also, for those used to using Excel graphs, you can manipulate the data table and thus the visual display - but thats not assumed; it will display just fine with the default settings.)

As with the orginal audit file, this uses macro programs to get Excel to do what we need - in this case to import the data from the audit files, collate and graph it. You still need set macro security to make that work - read about that here.

Download the file here -right click the link and save as - don't open it inside internet explorer. Problems? - see here.

rob@thinkingcurriculum.com