ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Download a copy of this calculator in excel before entering data
2
For part-time teaching staff in secondary schools
3
This calculator is designed to assist with the creation of work patterns in eFIN for part time teachers.
4
As per the CEMEA2022 Clause 60.4 the maximum amount of scheduled class time for the 2024 and subsequent years is 18.50 hours per week. Therefore the Total hours of SCT have been averaged to 3.7 hours to represent a full day on this calculator.
5
6
Should your schools daily scheduled class time be different, you will need convert the scheduled class time hours to reflect no more than 7.6 hours, then adjust the formular to correctly calculate the decimal hours. Contact ictsupport@macs.vic.edu.au for assistance.
7
8
9
10
Enter the total scheduled class time hours or duties in lieu of scheduled class time to populate the required hours for the work pattern.
11
The result will calculate their FTE and convert to a daily paid hours for a work pattern
12
13
MANUAL ENTRY REQUIRED FOR PINK CELLS ONLY
14
15
Week 1
16
MonTuesWedThursFriHours per week
17
Total hours of SCT 433.53.43.1717.07Total hours should not exceed 18.5 per week as per CEMEA2022 Clause 60.4
18
19
Converts to Decimal hours8.226.167.196.986.5135.06
20
21
Total Converted Time8:126:097:116:596:30
22
23
Start Time 8:30:00 am8:30:00 am8:30:00 am8:30:00 am8:30:00 am
24
Finish Time 4:42:00 pm2:39:00 pm3:41:00 pm3:29:00 pm3:00:00 pm
25
26
FTE - week 1 0.9227NB: must then recaculate for rounded up FTE two decimals only
27
Adjusted FTE rounded up 0.9300Adjusted hours of work per week with rounded FTE 35.34
28
29
Week 2
30
MonTuesWedThursFriHours per week
31
Total hours of SCT 3.173.43.53.43.1716.64Total hours should not exceed 18.5 per week as per CEMEA2022 Clause 60.4
32
33
Converts to Decimal hours6.516.987.196.986.5134.18
34
35
Total Converted Time6:306:306:306:306:30
36
37
Start Time 8:30:00 am8:30:00 am8:30:00 am8:30:00 am8:30:00 am
38
Finish Time 3:00:00 pm3:00:00 pm3:00:00 pm3:00:00 pm3:00:00 pm
39
40
FTE - week 2 0.8995NB: must then recaculate for rounded up FTE two decimals only
41
Adjusted FTE rounded up 0.9000Adjusted hours of work per week with rounded FTE 34.20
42
43
44
45
Total hours per FN69.24
46
FTE - fortnight0.9111
47
48
Total work hours = the number of hours (or part thereof) for scheduled class time for the teacher and/or duties in lieu of those scheduled class times. For avoidance of doubt, duties that are defined as professional expectation in the CEMEA2022 should not be included. Extra's allocated should also not be included.
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100