...
Contact Hours and Field Course Hours are drawn from timetabling information.
Ready Reckoner / Stats
These are primarily used when building the WAM but give a quick indication of how an annual allowance translates into hours or days a week, and provides a summary overview of allocations within the WAM.
Teaching Tab
This provides allocations for staff members on each of the modules, excluding assessment.
...
In the example above, clicking the cell with the 134 hours allocated to Kate on Ecological Principles will show the breakdown of the number in the formula bar: 40 hours for convening and 94 hours for teaching (47 contact hours):
Assessment Tab
This shows the allocation of workload for assessment for each module in a similar way:
These currently rely on the "old measure" of time allocated to assessments shown on the modules tab - i.e. 45 minutes per assessment per student on each module.
Admin Tab
This covers all administration, leadership and citizenship roles, including general allowances and administrative buyouts external to the Department:
In the example above, Katherine is allocated the roles of Library Representative and White Rose DTP BoS.
Research Tab
This covers both research and scholarship:
In this example, Jon and Mark receive the allowance of 400 hours as their standard research allowance for ART staff, and Claire receives 200 hours of scholarship time as a member of T&S staff. All receive credit for their research contract buy-outs.
Supervision/Misc Tab
This tab includes hours allocations for supervision of PhD, pastoral and supervision students.
PhD students are credited at 1 for the primary supervisor and 0.25 for the secondary supervisor (sorry, I missed an important point when I designed the spreadsheet so apologies that this is a bit confusing).
This sheet also includes credit for the Covid transition to online teaching, at a nominal 25% of the overall teaching allocation.