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.
It is broken into tabs as follows:
- Modules - this provides data for each of the modules. This underpins the teaching and assessment tabs.
- Teaching - this relates to teaching on modules. The numbers shown are the total number of hours allocated in the workload - this will be 2x the number of contact hours to account for the multiplier, plus any allowances for convenorship and field courses