May 30, 2012

1. FY 2013 Calculating Teacher Needs May 30, 2012 Confidential Draft Subject to Change – Not for Distribution

2. Locating the Request Tool Access Database 3 • Locate the Calculation of Teacher Need Tool in R:\All Central Offices\CFN Contact Database\Excesses and Appeals FY13 \Teacher Need.xlsx • Double click on the file Confidential – Not for Distribution Confidential Draft Subject to Change – Not for Distribution

3. Opening the tool 1 2 If a security warning message appears click Option button Select Enable this content Click OK Confidential Internal Draft Subject to Change – Not for Distribution Confidential – Not for Distribution Confidential Draft Subject to Change – Not for Distribution

4. Model Assumptions Found in the “Key” tab Confidential Internal Draft Subject to Change – Not for Distribution Confidential – Not for Distribution Confidential Draft Subject to Change – Not for Distribution 4

5. 3 Tabs for viewing and changing data Tab #2: Register Changes Only (registers pre-populate from initial projections, but can be changed) • Tab #3: Program Changes Only (registers pre-populated from Tab #2 and cannot be changed) Tab #1: Initial Register Projections. (No changes can be made on this sheet.) On each sheet the top box shows model with no bridging, the bottom box shows a bridged model. Between these two tabs the difference in teacher need is only due to register changes Between these two tabs the difference in teacher need is only due to programming changes Confidential Internal Draft Subject to Change – Not for Distribution Confidential – Not for Distribution Confidential Draft Subject to Change – Not for Distribution 5

6. DOE Projected Tab 1 3 First, enter or select a DBN from the drop down list The sheet will pre-populate with your school’s register There are 2 models on this page: “Basic” and “Bridged”. Scroll down to see bridging options Confidential Internal Draft Subject to Change – Not for Distribution Confidential – Not for Distribution Confidential Draft Subject to Change – Not for Distribution

7. DOE Projected Tab: Basic Model 2 Data can not be updated on this tab Number of teachers needed is calculated within each category; a total number of teachers is calculated at the bottom-right of the spreadsheet Confidential Internal Draft Subject to Change – Not for Distribution Confidential – Not for Distribution Confidential Draft Subject to Change – Not for Distribution

8. DOE Projected Tab: Bridging Model The Bridging Model calculates teacher need when combining grade levels Confidential Internal Draft Subject to Change – Not for Distribution Confidential Draft Subject to Change – Not for Distribution Confidential – Not for Distribution

9. School Actual Register Changes Tab 1 2 On this tab, adjustments can be made to the number of students in each category, for both basic and bridged models Comments can be entered to the right for internal record keeping Confidential Internal Draft Subject to Change – Not for Distribution Confidential Draft Subject to Change – Not for Distribution Confidential – Not for Distribution

10. School Actual Program Changes 2 1 On the Program Changes Tab, adjustments can be made to the number of Classes Needed Bridging options across grade levels can also be modified Confidential Internal Draft Subject to Change – Not for Distribution Confidential Draft Subject to Change – Not for Distribution Confidential – Not for Distribution

11. School Actual Program Changes Click on a plus sign to bridge grades—in each grouping, the highest bridging grade is shown as the default For example, selecting the plus sign above 3rd grade, allows the user to bridge 1st 2nd & 3rd grade AND/OR 1st & 2nd grade ***Registers by grade and program MUST match registers entered on school register change tab*** Confidential Internal Draft Subject to Change – Not for Distribution Confidential Draft Subject to Change – Not for Distribution Confidential – Not for Distribution