Spreadsheet: 06eaadfe-640d-45a6-b956-968da352fade
Sheet:  Instructions

 | Instructions:
1 | Please download and save the excel worksheet on desktop or other drive in your computer (recommended). You may also use the worksheet
 | on-line, but you would not be able to save changes.
2 | Open the file, and you will see three worksheets (Instructions, SFPR FY2014, and ADM Details).
3 | To view the simulation for a single  JVS School District , find the second worksheet (SFPR FY2014) from your left, and enter the school's IRN
 | in the highlighted IRN field (Cell C7).
4 | To change the factors used in the simulation edit the cells in the one worksheets  ADM Details.
5 | Updating any of the FTE numbers (such as special ed cat. 1) does NOT automatically update the Total Formual ADM.  You have to change Total ADM manually.
6 | The cells may be edited by simply entering a new number (e.g. "40.12" instead of "30.12"). However, it is recommended that you edit by
 | changing "30.12" to "=30.12+10"  or "0.00" to "=0.00+5" to not lose the original figure.
7 | We recommend that you filter the ADM Details FY2014 worksheet in column B or [NAME] the "Select All" box, and then select your IRN or
 | District name. This worksheet contains JVS School District student enrollment including total [NAME], special education category FTE,
 | Economic Disadvantaged FTE, Limited English Proficiency category FTE, and Career Technical category FTE.
 | **See tables below for category descriptions**
8 | If you do another simulation later in the year, check back on ODE's website for an updated version of the spreadsheet with revised data
 | Any questions should be directed to:
 | [NAME] at (614) 728 7849 or [EMAIL] or
 | [NAME] at (614) 466 6253 or [EMAIL] or
 | [NAME] at (614) 995 9936 or [EMAIL]
SPECIAL EDUCATION CATEGORIES
Category | Description | Amount
1 | Speech Only | $1,503 in FY14 and $1,517 in FY15
2 | Cognitive Disabilities, Specific Learning Disability, Developmentally Delayed, Other Health Impaired (Minor) | $3,813 in FY14 and $3,849 in FY15
3 | Hearing Impaired, Emotional Disturbance | $9,160 in FY14 and $9,248 in FY15
4 | Visual Impairment, Other Health Impaired (Major) | $12,225 in FY14 and $12,342 in FY15
5 | Multiple Disabilities, Orthopedic | $16,557 in FY14 and $16,715 in FY15
6 | Deaf-Blind, Autism, Traumatic Brain Injury | $24,407 in FY14 and $24,641 in FY15
CAREER TECH CATEGORIES
Category | [NAME] | Amount
1 | Agricultural & environmental systems, construction technologies, engineering & science technologies, finance, health science, information technology, manufacturing technologies | $4,750 in FY14 and $4,800 in FY15
2 | Business & administration, hospitality & tourism, human services, law & public safety, transportation systems, arts & communications | $4,500 in FY14 and $4,550 in FY15
3 | Career based intervention | $1,650 in FY14 and $1,660 in FY15
4 | Education & training, marketing, workforce development academics, public administration, career development | $1,400 in FY14 and $1,410 in FY15
5 | Family and consumer sciences (which includes students enrolled in GRADs) | $1,200 in FY14 and $1,210 in FY15
LIMITED ENGLISH PROFICIENCY CATEGORIES
Category | Description
1 | A recently arrived Limited English Proficient student who has been enrolled in US schools for no more than 180 school days AND Not previously exempted from taking the spring administration of either of the State’s English language arts assessments (reading or writing).
2 | Limited English Proficient student who has been enrolled in U.S. schools for more than 180 school days or Previously exempted from taking the spring administration of either of the State’s English language arts assessments (reading or writing).
3 | A student considered to be in a Trial-Mainstream period.