Overview
The WAM is designed to show, in a clear and transparent way, how work is allocated.
On each tab, staff are listed with a summary of their workload. This starts off in alphabetical order at the start of the process but due to limitations in Google Sheets formulae it doesn't always stay that way - sorry.
The FTE and Hours columns relate to that individual's nominal working hours.
Overall Hrs is the number of hours allocated in the plan. The Overall % column shows the percentage of an individuals' hours that are currently allocated, considering their FTE. Colour coding gives a quick view as to how fully allocated the individual is (blue is lowest, then green, amber, and red). An ideal workload plan would have all colleagues in amber.
The columns then break down the workload for each individual. In this case, one colleague is allocated 26 hours and another colleague is allocated 6 hours for teaching on Dynamic Earth:
Staff Tab
This gives a simple overview for each staff member, with the information drawn from each tab:
Modules Tab
This provides data for each of the modules and is used to underpin the Teaching and Assessment tabs.
The # Students column draws upon a snapshot of information. This will be refreshed in the Autumn Term to reflect module choices and student enrolments. This and the # Assessments column are used to calculate the hours given for assessment.
Contact Hours and Field Course Hours are drawn from timetabling information.
Teaching Tab
This provides allocations for staff members on each of the modules, excluding assessment.
The time allocations include:
- Contact time
- Non-contact time (i.e. the 2x multiplier for contact time is applied)
- Field course hours
- Convenorship hours
It does not include the additional multiplier for Covid online teaching - this is shown separately on the Misc tab as it's intended to be a one-off.
In the example above, clicking the cell with the 134 hours allocated to Kate will show the breakdown of the number in the formula bar: 40 hours for convening and 94 hours for teaching (47 contact hours):
