MORTALIDAD INFANTIL EN CHILE Y SU RELACIÓN CON LA POBREZA

The Ministry will populate into EFIS certain board total data from the Excel based Appendix C. Boards are therefore required to submit their appendix C to the following mailbox before they complete their EFIS submission,

[email protected] School boards will receive a confirmation from the Ministry that the Appendix C data is ready for upload in EFIS.

Appendix C, Excel file contains the following worksheets: (i) Top-up

(ii) School Foundation and others (iii) DEA Top-up

(iv) Other status facility

Top-up worksheet

This worksheet is to calculate the top-up allocations for the school operation and school renewal allocations.

Appendix C has been revised to reflect school IDs from 2012-13 with additions for new schools and adjustments for closed schools.

When a board has a new facility created in SFIS to be opened in 2013-14 without a School ID assigned by the Ministry, the facility will appear on the Top-up worksheet with the cells for School ID (Col. 4.2) and School Type (Col. 6.4) opened for input. These input values will be used for the calculation of School Foundation and Supported School allocations in the School Foundation worksheet.

Board should input School ID using the following approach:

 for newly constructed stand alone schools that are growth related, allocate an interim new school ID. Please use the next available School ID from the list in the worksheet, e.g. the last pre-populated School ID in this worksheet is 7300025, then start allocating from 7300026 to the new schools.

 for new SFIS reflecting a newly constructed stand alone replacement school, allocate the school ID of the existing school being replaced

 for new SFIS reflecting a new program, allocate the school ID of an existing school from the list populated in the file e.g. (i) an alternative program could be allocated the school ID of the closest high school or the school ID of an existing alternative school, (ii) a gr 7&8 program moving to a secondary school building would be allocated the same school ID as that of the secondary school

 for newly constructed schools that are built on site that has an existing school, use the same school ID of the existing school.

Board should input School Type under col. 6.4 using the following approach:  if the school is a rural school, enter 1

 if the school is a supported school, enter 3  all other schools are defaulted to zero

 do not enter any value other than 0, 1, 3 in this column

When a board has an isolate elementary school from the school authority amalgamation that provides grade 9 and 10 programs, the board will need to input a negative adjustment to the OTG capacity of the Secondary facility, which makes it equals to the Secondary enrolment, and a corresponding positive

adjustment to the OTG of the Elementary facility (Col. 5.2).

Top-up funding will not be provided to new schools for their first five years of operations. This will be applicable to schools opened in the 2009-10 school year and subsequent years. These schools are identified in column 6.5.

There should be a school ID in column 4.2 for each facility listed on this worksheet for the proper calculations and groupings into the School Foundation worksheet. The foundation allocation will not be calculated for a facility without a School ID.

Report the following in respect of each facility listed:

Col. 6A The projected 2013-14 JK to SK ADE (pupils of the board) for each school facility Col. 6A1 The projected 2013-14 Gr. 1 to Gr. 3 ADE (pupils of the board) for each school facility Col. 6B The projected 2013-14 Gr. 4 to Gr. 8 ADE (pupils of the board) for each school facility Col. 6C The projected 2013-14 Secondary ADE (pupils of the board) for each school facility Col. 6.1 FTE as of October 31, 2013 of principals (exclude instructional component if any) Col. 6.2 FTE as of October 31, 2013 of vice-principals (exclude instructional component if any) Col. 6.3 FTE as of October 31, 2013 of school clerical and secretarial support staff

Where one school administration staff is responsible for a number of facilities, the FTE of the administrative staff should be allocated in accordance to time spent in each facility.

The summary totals of the staffing data reported in the Excel file will be loaded in Appendix C in EFIS. These totals should match the totals reported in Appendix H for principals, vice-principals, clerical and secretarial staff under the non-classroom school administration categories.

The school type of each school facility is simplified to identify rural schools or supported schools. The identification of the school type is done by the Ministry and is preloaded into the board’s file. Col. 9 and Col. 12 - calculates the additional top-up amount on school operations and school renewal for

rural schools, which tops-up the funding to 100%.

Col. 9.1 and Col. 12.1 - calculates the additional top-up amount on school operations and school renewal for supported schools, which tops-up the funding to 100%.

School Foundation Supported Schools and ALF calculation

This worksheet calculates the school foundation allocation for each “qualifying school” as defined in subsection 16(3) of the GSN regulation.

Facilities have been combined for school foundation purpose if  The facilities are situated at the same site

 The facilities have the same BSID number

The Ministry assigned a unique school identification number for each school used in the calculation of the school foundation. ADE of the schools/combined schools are populated from the “Top-up” worksheet based on the unique school identification number.

This worksheet will open up additional lines for input based on the number of new facilities without School ID in the Top-up worksheet, e.g. if there are 3 facilities without School ID shown on the Top-up

worksheet, 3 additional lines will be added at the bottom of the School Foundation & others worksheet which will allow boards to input School ID and School Type.

Follow these rules in School ID and School Type input:

 All School IDs in this worksheet are unique for the grant calculation purpose, do not repeat any School ID in this worksheet

 Enter the same interim School ID and School Type input in Top-up worksheet in col. 1 and col. 1.1 except if the interim School ID of a new school is using one of the existing School IDs, then do not enter that interim School ID and interim School Type of that school in this worksheet.

An example to show how School ID and School Type are input (white cells are input cells): Top up worksheet

SFIS # BSID # School NamPanel School ID

School type

School type

# SIIS Nom de l'écPalier

Type d'école Type d'école Col. 4.2 Col. 6.4 1234 345678 Existing Sc E 7300001 0 1235 345678 Existing Sc S 7300002 3 Supported 1236 345678 Existing Sc S 7300003 1 Rural

1237 345678 New Schoo E 7300004 0 Supported

1238 345678 New Schoo E 7300002 3 Supported

1239 345678 New Schoo S 7300005 1 Rural

School Foundation & other worksheet

Col. 1 Col. X Col. 11

SchoolID School type School type Identité d'école Type d'école Type d'école 7300001 0 7300002 3 Supported 7300003 1 Rural 7300004 0 7300005 1 Rural

This school is not entered in the blank lines in the School Foundation & others

worksheet as it is using an existing School ID/

Columns 11 to 14 calculate the supported schools amount for each school. The ALF amount is also calculated for each secondary school. Note that where supported secondary schools are also attracting ALF funding, the supported school amount will be adjusted. The adjustment amount is calculated in column 14.

The parent engagement school amount is calculated on Col. 15. Each school is entitled to $500 and in the case of a combined school with elementary enrolment greater than 300 and secondary enrolment greater than 500, an additional amount of $500 is provided.

DEA – Top-up

This worksheet calculates the school operation top-up amount for declining enrolment adjustment purposes. Only schools with enrolment in both 2012-13 and 2013-14 will be included in the calculation. Column 6B in the Excel Appendix C is for boards to input the 2012-13 ADE based on what the boards would have reported in its 2012-13 Financial Statements Excel Appendix C, which is used to calculate the 2012-13 Top-up amount for DEA purposes using 2013-14 on the ground capacity and benchmarks. If this column is not input, the preloaded 2012-13 ADE from the submitted 2012-13 Revised Estimates Excel Appendix C will be used for that calculation. The results on Column 21 and Column 22 will be used in Section 16, item 16.1.7.

In the case that boards find a school facility not appearing on Excel Appendix C or the facility is without a School ID or the OTG is not correct, please follow the procedures below:

Boards are advised to check the Excel Appendix C for the missing information as soon as possible as it may take a few weeks to gather all the necessary information, set up in SFIS and GIS system and for the Ministry to validate the data and assign School.

Procedure for the school facility not appearing on Excel Appendix C

(i) Boards should create their new SFIS records in the 2013-14 school year with all required information (as known at that time): address, BSID, classrooms, etc.

(ii) Boards should check that the status of the school facility is “Open” and with On the Ground Capacity (OTG) greater than zero.

(iii) The “Other status facility” worksheet facilitates the boards in identifying the reason for school facilities not appearing on Excel Appendix C. This worksheet lists the school facilities in the 2013-14 school year with status other than “Open” in SFIS. This will help boards to identify schools that are planned to open in 2013-14 but do not appear on Excel Appendix C because of incorrect status such as “Planned” or “Under Construction”. In that case, boards should change the status to “Open”.

(iv) If the school facility’s record in SFIS meets the conditions at (i) and (ii), but still does not appear on Excel Appendix C, Boards could send an e-mail to

[email protected] and [email protected] in the Capital Programs Branch for assistance.

Procedure for Modification of On the Ground Capacity (OTG) for the 2013-14 school year:

(i) If the pre-loaded OTG is not correct for a school facility, board could make the change in the OTG in SFIS for 2013-14. Luminita Popescu and Christie Kapos are available for assistance.