{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["MENU","centrebased 2014","Ratios","ADMIN"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MENU","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,2,1,14],[3,2,5,13],[2,2,2,14]]}
[]
[null,null,"Educator to Child Ratios Calculator"]
[null,null,"National Quality Framework - Centre-based Services"]
[null,null,"Services educating and caring for children, may wish to use this tool to calculate the educator to child ratios specified in regulations 123(1)(a), 123(1)(c), 357 and 355, and the educator qualification requirements of regulations 126 and 356.  \n"]
[]
[]
[null,null,"Minimum number of educators required to educate and care for children"]
[null,null,"Children preschool age or under "]
[null,null,"●  Children less than 36 months of age: 1 educator to 4 children  (regulations 123(1)(a) and 357)."]
[null,null,"●  Children 36 months of age to preschool age: 1 educator to 11 children  (regulation 123(1)(c))."]
[null,null,"Children over preschool age"]
[null,null,"●  Children over preschool age: 1 educator to 15 children  (regulation 355)"]
[]
[null,null,"Qualification requirements of educators"]
[null,null,"Children preschool age or under "]
[null,null,"●  At least 50 per cent of educators required to meet the relevant educator to child ratios for the service must hold, or be actively working towards, "]
[null,null,"    at least an approved diploma level education and care qualification  (regulation 126(1)(a))."]
[null,null,"●  All other educators required to meet the relevant educator to child ratios for the service must hold, or be actively working towards, at least an approved "]
[null,null,"    certificate III level education and care qualification (regulation 126(1)(b))."]
[null,null,"Children over preschool age"]
[null,null,"●  At least 50 per cent of the educators required to meet the educator to child ratios for children over preschool age must hold, or be enrolled in and    "]
[null,null,"    studying for, at least an approved diploma level qualification for educators working with children over preschool age in Victoria (regulation 356(2))."]
[null,null,"●  All other educators required to meet the educator to child ratio for children over preschool age must hold, or be actively working towards,at least an  "]
[null,null,"    approved certificate III level education and care qualification for educators working with children over preschool age, or commence obtaining such a "]
[null,null,"    qualification within 6 months of commencing to educate or care for children (regulation 356(3))."]
[]
[null,null,"To calculate the number of educators required for a centre-based service press Proceed"]

{"sheet":"centrebased 2014","index":1,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,4,1,14],[2,5,2,13],[2,14,7,14],[4,13,7,13],[6,12,7,12],[27,5,27,13],[24,5,24,13],[19,5,19,13],[23,5,23,13],[17,4,17,13],[20,5,20,13],[22,5,22,13],[25,5,25,13],[26,5,26,13]]}
[]
[null,null,null,null,"Educator to Child Ratios Calculator"]
[null,null,null,null,null,"National Quality Framework - Centre-based Services",null,null,null,null,null,null,null,null,"Minimum number of educators required to hold at least an approved diploma level qualification*"]
[]
[null,null,null,null,"From 1 January 2016",null,null,null,null,null,null,null,null,"Educators required (includes diploma level educators)"]
[null,null,null,null,"Insert number of children "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of children"]
[null,null,null,null,"Age of children"]
[]
[null,null,null,null,"Less than 36 months of age",null,null,null,null,null,null,null,0,{"$f":"IF($M$10=0,0,SUM(ROUNDUP($M$10/Ratios!$G$30,)))","v":0},{"$f":"ROUNDUP(N10/Ratios!H18,)","v":0}]
[null,null,null,null,"36 months of age to preschool age",null,null,null,null,null,null,null,0,{"$f":"IF($M$11=0,0,SUM(ROUNDUP($M$11/Ratios!$G$31,)))","v":0},{"$f":"ROUNDUP(N11/2,)","v":0}]
[null,null,null,null,"Over preschool age",null,null,null,null,null,null,null,0,{"$f":"IF($M$12=0,0,SUM(ROUNDUP($M$12/Ratios!$G$32,)))","v":0},{"$f":"ROUNDUP(N12/2,)","v":0}]
[null,null,null,null,"Total educators required",null,null,null,null,null,null,null,null,{"$f":"N10+N11+N12","v":0},{"$f":"O10+O11+O12","v":0}]
[null,null,null,null,"Minimum number of diploma level educators required * (50% of total educators)",null,null,null,null,null,null,null,null,{"$f":"ROUND(N13/2,0)","v":0}]
[null,null,null,null,"Minimum number of certificate III level educators required *",null,null,null,null,null,null,null,null,{"$f":"N13-N14","v":0}]
[]
[]
[null,null,null,null,"Important information              "]
[]
[null,null,null,null,"●","This calculator assists in determining the minimum educator to child ratios and the educator qualifications requirements"]
[null,null,null,null,"●","An educator included in the educator to child ratio must be working directly with children at the service (regulation 122)."]
[null,null,null,null,"●","Educators may be actively working towards an approved qualification (regulation 10)"]
[null,null,null,null,"*","At least 50 per cent of required educators must hold, or be actively working towards, at least an approved diploma level education and care qualification (regulation 126(1)(a))"]
[null,null,null,null,null,"Note: Diploma level educators working with children over preschool age must hold or be enrolled in and studying for, at least an approved diploma level qualification (regulation 356(2))"]
[null,null,null,null,"\n\n*","All other required educators must hold, or be actively working towards, at least an approved certificate III level education and care qualification  (regulation 126(1)(b)) and regulation 356(3)(a))\nNote: in the case of educators working with children over preschool age, commence obtaining such a qualification within 6 months of commencing to educate and care for children (regulation 356(3)(b))."]
[null,null,null,null,null,"Note: The educator qualification requirements are different for educators working with children preschool age and under and children over preschool age and this needs to be taken into consideration when determining the qualification level of the educators to meet the educator to child ratio requirements. \nThe approved qualifications are available on the ACECQA website at www.acecqa.gov.au/Qualifications.aspx"]
[null,null,null,null,"●","Further information about the educator to child ratios from 1 January 2016 for centre-based services is available on the Department's website in the fact sheets entitled: "]
[null,null,null,null,null,"Educator to child ratios for funded kindergarten programs from 1 January 2016\nEducator to child ratios from 1 January 2016 – centre-based services"]

{"sheet":"Ratios","index":2,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":true,"merged":[[7,0,7,1],[14,0,14,1],[1,4,1,5],[7,4,7,5],[14,4,14,5],[1,0,1,1],[20,4,20,5],[27,0,27,1],[33,0,33,1],[27,4,27,5],[33,4,33,5],[20,0,20,1]]}
["Standard Service",null,null,null,"Centre Based Services"]
["UNTIL 31 DECEMBER 2011",null,null,null,"From 1 Jan 2012 to 31 Dec 2013"]
[null,null,"Total Staff","Qualified Staff",null,null,"Educator to child ratio","Qualified Staff"]
[null,"Under 3",5,15,null,"Birth to 24 Months",4,3]
[null,"Over 3",15,30,null,"Over 24 months but less than 36 months of age",4,3]
[null,null,null,null,null,"Children preschool age or under who are aged 36 months or over",15,2]
[null,null,null,null,null,"Over preschool age",15,2]
["FROM 1 JANUARY 2012",null,null,null,"FROM 1 JANUARY 2012"]
[null,null,"Total Staff","Qualified Staff",null,null,"Total Staff","Qualified Staff"]
[null,"Under 3",4,12,null,"Under 3",4,12]
[null,"Over 3",15,30,null,"Over 3",15,30]
[]
[]
["OSHC",null,null,null,"Centre Based Services"]
["UNTIL 31 DECEMBER 2011",null,null,null,"From 1 Jan 2014 "]
[null,null,"Total Staff","Qualified Staff",null,null,"Educator to child ratio","Qualified Staff"]
[null,"Over 3",15,30]
[null,null,null,null,null,"Children aged less than 36 months of age",4,2]
[null,null,null,null,null,"Children preschool age or under who are aged 36 months or over",11,2]
[null,null,null,null,null,"Over preschool age",15,2]
["FROM 1 JANUARY 2012"]
[null,null,"Total Staff","Qualified Staff",null,null,"Total Staff","Qualified Staff"]
[null,"Over 3",15,30,null,"Under 3",4,12]
[null,null,null,null,null,"Over 3",15,30]
[]
[]
["Limited Hours Type 1",null,null,null,"Centre Based Services"]
["UNTIL 31 DECEMBER 2011",null,null,null,"From 1 Jan 2016"]
[null,null,"Total Staff","Qualified Staff",null,null,"Educator to child ratio","Qualified Staff",">16 Children Qualified Staff"]
[null,"Under 3",5,15,null,"Children aged less than 36 months of age",4]
[null,"Over 3",15,30,null,"Children preschool age or under who are aged 36 months or over",11]
[null,null,null,null,null,"Over preschool age",15]
[]
["FROM 1 JANUARY 2012",null,null,null,"FROM 1 JANUARY 2012"]
[null,null,"Total Staff","Qualified Staff",null,null,"Total Staff","Qualified Staff",">16 Children Qualified Staff"]
[null,"Under 3",4,12,null,"Under 3",4,12,30]
[null,"Over 3",15,30,null,"Over 3",15,30]

{"sheet":"ADMIN","index":3,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,0,5,12]]}
[]
[]
[]
[]
[]
["Administration"]