Whole School Teacher Periods
Periods per week in the timetable cycle
25
These are teaching periods allocated to tea
Teacher periods timetables which are not included in the tot
allocated on the periods (tp) periods shown for each year gr
Curriculum Area Pupil Roll timetable
For example in this school 10 tp are allocat
Year 7 150 133
of staff to extract individual students from th
Year 8 150 133
curriculum at specific times of the week for
Year 9 150 158 A total of 10 tp has therefore been entered
Year 10 150 215 "Intervention".
Year 11 150 215
Year 12 80 90 The school has set up an 'Inclusion Unit'. A
Year 13 70 90 teaching staff are used so a teacher presen
Whole school teacher lesson of the week in the unit. These period
periods (See text box) on on the Inclusion line as 25tp.
Learning Support n/a 20
Intervention n/a 25 There are 20 tp used in Learning Support e
Inclusion n/a 10 extraction of pupils or by working in classes
Other(user define) n/a 0 other colleagues.
Other(user define) n/a 0
One of the spare categories, currently show
Other(user define) n/a 0
Other(user define) could be used in the pla
Totals 900 1089
to account for timetable 'slack' known to be
write a timetable with suitable expertise ma
Average Class Size (See may eventually be allocated as different typ
text box) 20.66
This sheet can be unlocked with the password PASSWORD.
It is possible to extend this idea by allocating the whole school teacher periods across year groups for which they are
Sam Ellis. ASCL Funding Specialist. November 2010
School Teacher Periods Average Class Size
are teaching periods allocated to teacher This statistic is calculated as follows
bles which are not included in the total teacher
s (tp) periods shown for each year group. The total number of teacher periods on the timetable (cell C19) is divided
by the number of periods per week in the timetable cycle (cell C2). This
ample in this school 10 tp are allocated to a range gives the average number of teachers on the timetable on any one period
to extract individual students from the main in the week. This result is then divided into the total roll to give the
um at specific times of the week for intervention. average number of pupils per teacher on any one period in the week. This
of 10 tp has therefore been entered on the line is the Average Class Size statistic referred to in the Leader article in
December 2010 and links directly to the school's finances in the manner
described in the article
hool has set up an 'Inclusion Unit'. A range of
g staff are used so a teacher present for every Please note that this is not the same thing as a typical class size. It
of the week in the unit. These periods are shown incorporates the whole school periods into the individual year group
he Inclusion line as 25tp. periods. It also does not take any account of students, particularly in
years 12 and 13 who may have non contact time.
are 20 tp used in Learning Support either by
on of pupils or by working in classes to support Please note that the definition of average class size used here is not the
same as that in some timetable software. Variations in results occur
where classes are allocated more then one teacher as the software may
the spare categories, currently shown as count class periods rather than teacher periods and also account for
user define) could be used in the planning stage student non contact time in post 16 areas.
unt for timetable 'slack' known to be required to
timetable with suitable expertise matching which
entually be allocated as different types of class
cross year groups for which they are appropriate and to derive individual Average Class Size statistics.
ble (cell C19) is divided
e cycle (cell C2). This
able on any one period
l roll to give the
period in the week. This
e Leader article in
nances in the manner
ical class size. It
vidual year group
nts, particularly in
e used here is not the
s in results occur
r as the software may
d also account for
Periods per week in the timetable cycle
0
Teacher periods
allocated on the
Curriculum Area Pupil Roll timetable
Year 7 0 0
Year 8 0 0
Year 9 0 0
Year 10 0 0
Year 11 0 0
Year 12 0 0
Year 13 0 0
Whole school teacher
periods
Learning Support n/a 0
Intervention n/a 0
Inclusion n/a 0
Other(user define) n/a 0
Other(user define) n/a 0
Other(user define) n/a 0
Totals 0 0
Average Class Size n/a
This sheet can be unlocked with the password PASSWORD.
Sam Ellis, ASCL Funding Specialist
sam.ellis@ascl.org.uk
£ per pupil by area
Reference Year
Teachers E01 £2,912
All other staff E02 to E11 £1,196
Premises E12 to E18 £305
Learning Resources E19 to E20 £272
Supplies & Services E21 to E28 £447
Other E29 to E32 £39
Funding I01 to I07 plus I14 to I17 £4,965
Income I08 to I13 £258
Balance/Deficit(Planned Overspend) £52
Parameters/Targets
Reference Year
Average teacher cost £43,440
Roll 995
FTE Teachers 66.7
PTR 14.9
Sam Ellis, ASCL Funding Specialist
sam.ellis@ascl.org.uk
£ per pupil by area Input cells have a blue font on a white background. The
Projected Password is PASSWORD. Note that the funding needs
£2,926 adjusting to that which is notionally available in an academic
£921 year.
£0
£0
£0
£556
Divide the Average teacher cost
£4,403 by
£0
the £ per pupil on E01
£0 to get
Parameters/Targets the PTR
Projected
£49,000
900 The 'Reference Year' is an Academic Year. it may be
53.7 necessary to make 5/12 and 7/12 adjustments where
16.7 funding changes significantly from Financial Year to
Financial Year
round. The
e in an academic
nts where
Timetable Cycle 25 A B
Name Initials Employed FTE Load PPA MGT Other Check Allocated Variance
Archie Andrews AA 25 1 22 3 25 22 0 ok
Arthur Hun AH 25 1 20 2 3 25 20 0 ok
Agnes Macbeth AM 25 1 20 2 3 25 20 0 ok
Anne Ode AO 25 1 22 3 25 22 0 ok 8
Brian Bear BB 25 1 22 3 25 22 0 ok
Bill Flowerpot BF 25 1 20 2 3 25 20 0 ok 8
BiIllie Holiday BH 25 1 20 2 3 25 20 0 ok 20
Bram Stoker BS 25 1 22 3 25 22 0 ok
Cliff Edge CE 25 1 22 3 25 22 0 ok
Charles Dickens CD 25 1 22 3 25 22 0 ok
Claudia Metulla CM 25 1 4 1 20 25 4 0 ok
Caligula Notnice CN 25 1 9 1 15 25 9 0 ok
Colin Roland CR 25 1 22 3 25 22 0 ok
Dorothy Fields DF 25 1 22 3 25 22 0 ok
Di Ode DO 25 1 20 2 3 25 20 0 ok
Eric Bee EB 25 1 22 3 25 22 0 ok
Eileen Dover ED 25 1 22 3 25 22 0 ok 4
Ella Fitzgerald EF 25 1 22 3 25 22 0 ok
Emily Pankhurst EP 25 1 22 3 25 22 0 ok
Elizabeth Tudor ET 25 1 22 3 25 22 0 ok
Emile Zola EZ 25 1 20 2 3 25 20 0 ok
Francis Drake FD 25 1 20 2 3 25 20 0 ok
Flora Margarine FMA 25 1 22 3 25 22 0 ok
Frank Trance FT 25 1 20 2 3 25 20 0 ok
Gibson Guitar GG 25 1 22 3 25 22 0 ok
Greta Garbo GGA 25 1 22 3 25 22 0 ok
Ida Down ID 25 1 22 3 25 22 0 ok
Isaac Newton IN 25 1 20 2 3 25 20 0 ok
Jayne Austen JA 25 1 22 3 25 22 0 ok
Jayne Grey JG 25 1 22 3 25 22 0 ok
Jon Satre JPS 25 1 22 3 25 22 0 ok
Kath Ode KO 25 1 22 3 25 22 0 ok 6
Marie Curie MC 25 1 20 2 3 25 20 0 ok
Martha Hari MH 25 1 22 3 25 22 0 ok
Michael Mouse MM 25 1 13 2 10 25 13 0 ok
Maria Martin MMN 25 1 13 2 10 25 13 0 ok
Mick Stability MS 25 1 22 3 25 22 0 ok
Mary Tudor MT 25 1 22 3 25 22 0 ok
Norma-Jean Baker NJB 25 1 20 2 3 25 20 0 ok
Orville Gibson OG 25 1 22 3 25 22 0 ok
Paul Tarsus PT 25 1 22 3 25 22 0 ok
Justin Time JT 25 1 22 3 25 22 0 ok
Sid Carton SC 25 1 22 3 25 22 0 ok
Charles Darnay CDN 25 1 22 3 25 22 0 ok
Rupert Bear RB 25 1 22 3 25 22 0 ok
Joshua Wedgewood JW 25 1 22 3 25 22 0 ok 4
Peter Rabbit PR 15 0.6 12 2 1 15 12 0 ok
Queenie Boudica QB 13 0.5 10 1 2 13 10 0 ok
Robert Bisto RB 5 0.2 4 1 1 6 4 0 ok
Sonja Foote SF 17 0.7 14 2 1 17 14 0 ok
Victoria Albert VA 17 0.7 14 2 1 17 14 0 ok
Walt Raleigh WR 13 0.5 10 1 2 13 10 0 ok
1230 49.2 1005 130 88 8 1005 36 14
Roll A B
Contact Ratio 0.8170732 149 y7 5 0
Total Roll 911 148 y8 5 0
Average Class Size 23.239796 145 y9 6 0
150 y10 6 3
152 y11 6 3
This sheet is locked with the password PASSWORD
85 y12 4 4
82 y13 4 4
Need 36 14
Resource 36 14
Balance 0 0
copyright ASCL MAPS Principles of timetable construction 2008-09
Bs C Dr E F Fd G Gm H It La Li Ls M Mu Os P Pe Ps Rm Rs Sc So Tk Tx
18 4
20
20
14
8 14
2 10
18 4
6 16
22
4
9
22
10 12
16 4
9 13
18
22
18 4
14 8
20
20
12 3 7
9 11
16 6
22
22
4 16
18 4
5 17
11 11
16
3 17
4 18
9 4
4 9
8 14
22
2 18
22
22
22
22
22
8 7 7
14 4
12
10
4
14
14
10
8 8 20 98 56 12 67 18 74 8 8 0 104 30
58 0 8 99 32 29 32 112 8 48 18 1005
Bs C Dr E F Fd G Gm H It La Li Ls M Mu Os P Pe Ps Rm Rs Sc So Tk Tx Totals
0 0 0 15 15 0 10 0 10 5 0 0 0 15 5 0 0 12 5 0 5 15 0 16 0 133
0 0 0 15 15 0 10 0 10 5 0 0 0 15 5 0 0 12 5 0 5 15 0 16 0 133
0 0 0 18 18 0 12 0 12 6 0 0 0 18 6 0 0 16 6 0 6 18 0 16 0 158
0 0 3 24 0 6 9 3 9 25 0 0 0 24 3 0 0 22 8 12 8 32 0 0 9 206
0 0 3 24 0 6 9 3 9 25 0 0 0 24 3 0 0 22 8 12 8 32 0 0 9 206
4 4 4 0 4 0 8 4 4 4 4 4 0 4 4 0 4 4 0 0 0 0 4 0 0 72
4 4 4 0 4 0 8 4 4 4 4 4 0 4 4 0 4 4 0 0 0 0 4 0 0 72
8 8 14 96 56 12 66 14 58 74 8 8 0 104 30 0 8 92 32 24 32 112 8 48 18 980
8 8 20 98 56 12 67 18 58 74 8 8 0 104 30 0 8 99 32 29 32 112 8 48 18 1005
0 0 6 2 0 0 1 4 0 0 0 0 0 0 0 0 0 7 0 5 0 0 0 0 0 25
All the worksheets in this workbook have the same convention. They are locked with the password PASSWORD. Cells that
input cells and are unlocked. All of these sheets are taken from materials used on training courses and consultancies availa
Professional Services (MAPS) available at www.ascl.org.uk/training
The sheets included here are free download samples originally designed for ASCL members to use in developing efficiency
curriculum and now being made available on a wider front. The sheets can be unlocked and modified by the user to suit th
STAFF CONTACT
This sheet is a basic timetabler's spreadsheet with staff names and timetable loadings down the right hand columns. Subje
sheet. The period allocation of staff to departments is given in the main body of the sheet and the total available staffing
curriculum demand which is input along the lower rows of the sheet. The overall timetable balance is given on the lowest
the global balance which needs to be as low as possible from a financial efficiency point of view but will need to be a few p
from a timetabling point of view.
FINANCIAL PROJECTION
This sheet uses the relationship Average Teacher Cost divided by Teaching Expenditure in pounds per pupil equals afforda
PTR in a particular year based on the expenditure estimates for a known academic year.
AVERAGE CLASS SIZE
This statistic describes the number of pupils that would be with each teacher on the timetable if the total number of teach
all the periods in the timetable cycle and then the roll was evenly divided amongst the staff with timetabled teaching perio
the size of an average class. For example in a school where there is one class of 30 students being taught by one teacher b
with individual students extracted for learning support, the average class size will be 15. It may be better to think of this
ratio. There are two versions of this sheet, a worked example and a blank sheet. Increasing the average class size in a scho
could well be at the expense of curriculum suitability and flexibility.
Sam Ellis, ASCL Funding Specialist
sam.ellis@ascl.org.uk
d PASSWORD. Cells that have a blue font on a white background are
s and consultancies available through ASCL Management and
in developing efficiency tools linked to the secondary school
Click here to go to
fied by the user to suit their own purpose.
the training page
of the ASCL
website
ght hand columns. Subject area codes run along the top of the
e total available staffing in each department is compared to the
ce is given on the lowest line. The extreme lower right hand cell gives
ut will need to be a few percent of the overall curriculum demand
per pupil equals affordable PTR (pupil teacher ratio) to estimate the
he total number of teacher periods were evenly distributed across
imetabled teaching periods. This will almost certainly not represent
taught by one teacher but a second teacher is timetabled to work
e better to think of this statistic as the operational pupil teacher
erage class size in a school will improve financial efficiency but that