may 30 2012 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
May 30, 2012 PowerPoint Presentation
Download Presentation
May 30, 2012

Loading in 2 Seconds...

play fullscreen
1 / 11

May 30, 2012 - PowerPoint PPT Presentation


  • 69 Views
  • Uploaded on

FY 2013 Calculating Teacher Needs. May 30, 2012. Confidential Draft Subject to Change – Not for Distribution. Locating the Request Tool Access Database. 3.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'May 30, 2012' - irish


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
may 30 2012

FY 2013 Calculating Teacher Needs

May 30, 2012

Confidential Draft Subject to Change – Not for Distribution

slide2

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

slide3

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

slide4

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

slide5

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

slide6

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

slide7

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

slide8

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

slide9

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

slide10

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

slide11

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