Legal Forms Templates for Free - Excel

Document Sample
Legal Forms Templates for Free - Excel Powered By Docstoc
					                                                                                                                                                                            7/19/2010
                                          ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls Lookup Templates                                                                        Page 1 of 9


                                 Grade Level Lookup Template
                District Grade                                     NYS RIC Standard
District Code                     NYS RIC Standard Grade Code                              Effective Date   Discontinue Date
                 Level Code                                         Grade Ordinal
  NY000000                       K                                KDG                       2006-06-30
  NY000000                       1                                1st                       2006-06-30
  NY000000                       2                                2nd                       2006-06-30
  NY000000                       3                                3rd                       2006-06-30
  NY000000                       4                                4th                       2006-06-30




                                                                                                                                      <------ Please continue with form.
  NY000000                       5                                5th                       2006-06-30
  NY000000                       6                                6th                       2006-06-30
  NY000000                       7                                7th                       2006-06-30
  NY000000                       8                                8th                       2006-06-30
  NY000000                       9                                9th                       2006-06-30
  NY000000                       10                               10th                      2006-06-30
  NY000000                       11                               11th                      2006-06-30
  NY000000                       12                               12th                      2006-06-30
  NY000000                       13                               K-6                       2006-06-30
  NY000000                       14                               7-12                      2006-06-30
  NY000000                       PS                               PRES                      2006-06-30
  NY000000                       PK                               PREK                      2006-06-30
  NY000000                       GD                               GED                       2006-06-30




Rules for this template
District Grade Level Codes must map to NYS RIC Standard descriptions.
                Enter your local grade levels in the "District Grade Level Code"column .
More than one of your local codes can map to a NYS RIC Standard Code
                All dates must be in YYYY-MM-DD format
Effective Date is the date where the code came into effect in the district.
The default should be the current year 2006-06-30
Discontinue date is the date when the code is no longer valid in your district.
                The default is blank




                                 Gender Code Lookup Template

                   District         NYS RIC Standard Gender
 DistrictCode                                                        EffectiveDate      DiscontinueDate
                 GenderCode               Description
  NY000000                       Male                                  6/30/2006
  NY000000                       Female                                6/30/2006

   Prepared by LHRIC DW Team                                                                                            ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls - File name
   44 Executive Blvd Elmsford, NY 10523                                            (914) 592-4203                                            Lookup Templates - Sheet name
                                                                                                                                                                                                      7/19/2010
                                             ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls Lookup Templates                                                                                               Page 2 of 9


Rules for this template
District Gender Codes must map to NYS RIC Standard descriptions.
                 Enter your local gender codes in the "District Gender Code"column .
More than one of your local codes can map to a NYS RIC Standard Code




                                                                                                                                        <------ Please continue with form.
All dates must be in YYYY-MM-DD format
Effective Date is the date where the code came into effect in the district.
                The default should be the current year 2006-06-30
Discontinue date is the date when the code is no longer valid in your district.
                The default is blank.




                                     Ethnic Code Lookup Template

                   District Ethnic       NYS RIC Standard Ethnic
 District Code                                                              EffectiveDate    DiscontinueDate
                        Code                     Description
   NY000000                          American Indian or Alaskan Native       2006-06-30
   NY000000                          Black or African American               2006-06-30
   NY000000                          Asian                                   2006-06-30
   NY000000                          Hispanic or Latino                      2006-06-30
   NY000000                          White                                   2006-06-30
   NY000000                          Native Hawaiian/ Other Pacific Islander 2006-06-30

Rules for this template
District Ethnic Codes must map to NYS RIC Standard descriptions.
                 Enter your local ethnic codes in the "District Ethnic Code"column .
More than one of your local codes can map to a NYS RIC Standard Code
All dates must be in YYYY-MM-DD format
Effective Date is the date where the code came into effect in the district.
                The default should be the current year 2006-06-30
Discontinue date is the date when the code is no longer valid in your district.
                The default is blank.


                  Location Code Lookup Template


                                                                               Local
                                                                                                  Building
                             Location Name                                 Building Code                       Effective Date    Discontinue Date
                                                                                                 bedscode
                                                                             /Number
Enter Building Name Here                                                        000            000000000000     2006-06-30
                                                                                                                2006-06-30




                                                                                                                                                                             e continue with form.
                                                                                                                2006-06-30
                                                                                                                2006-06-30
                                                                                                                2006-06-30
                                                                                                                2006-06-30
    Prepared by LHRIC DW Team                                                                                             ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls - File name
    44 Executive Blvd Elmsford, NY 10523                                                (914) 592-4203                                         Lookup Templates - Sheet name
                                                                                                                                                                     <------ Please continue with form.
                                                                                                                                                                                                           7/19/2010
                                          ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls Lookup Templates                                                                                                       Page 3 of 9

                                                                                                         2006-06-30
                                                                                                         2006-06-30
                                                                                                         2006-06-30
                                                                                                         2006-06-30




Rules for this template
*District Location Codes must map to NYS BED's code numbers.
                 Enter your local building codes in the "Local Building Code/Number"column .
Contact the LHRIC to review your loacal school/building numbers
More than one of your local building codes can map to a NYS BED's Code
All dates must be in YYYY-MM-DD format
Effective Date is the date when the code came into effect in the district.
                 The default should be the current year 2006-06-30
Discontinue date is the date when the code is no longer valid in your district.
                 The Default is blank.




                Home Language Code Lookup Template


                 District Home       NYS RIC Standard Home
 DistrictCode                                                     Language Region      EffectiveDate   DiscontinueDate
                Language Code         Language Description
  NY000000                       *English                                                2006-06-30
  NY000000                       *Chinese                                                2006-06-30
  NY000000                       *French                                                 2006-06-30
  NY000000                       *Italian                                                2006-06-30
                                                                                         2006-06-30



Rules for this template




                                                                                                                                <------ Please continue with form.
*District Home Language Codes must map to NYS RIC Standard descriptions.
                Enter your local home language codes in the "District Home Language Code"column .
See Home Language Appendix for NYS standard descriptions
More than one of your local codes can map to a NYS RIC Standard Code
All dates must be in YYYY-MM-DD format
Language Region is not used. Leave spaceholder.
Effective Date is the date when the code came into effect in the district.
                The default should be the current year 2006-06-30
Discontinue date is the date when the code is no longer valid in your district.
                The Default is blank.


   Prepared by LHRIC DW Team                                                                                      ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls - File name
   44 Executive Blvd Elmsford, NY 10523                                         (914) 592-4203                                         Lookup Templates - Sheet name
                                                                                                                                                                                                   7/19/2010
                                        ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls Lookup Templates                                                                                                 Page 4 of 9



                                                                  ENROLLMENT CODE MAPPING
Rules for this spreadsheet:
                Column A, District Code, should be "NY" followed by the first six digits of your district BEDs code.
                Column B, Local SMS Entry/Withdrawal Code, should be your local SMS entry/withdrawal codes.
                Note: If you have more than one local code mapped to a State Code, insert a new row into the spreadsheet for each local code.

                 Local SMS                                                                                                              STATE
  DISTRICT                                                                                                      ENROLLMENT
               Entry/Withdrawa     ENROLLMENT CATEGORY                ENROLLMENT_DESCRIPTION                                         ENROLLMENT
    CODE                                                                                                       CATEGORY LONG
                    l Code                                                                                                              CODE
  NY000000                                    Entry              Enrollment in building or grade under
                                                                 Entry under public school choice              Entry Enrollment          0011
  NY000000                                    Entry              NCLB exchange student enrollment in
                                                                 Foreign                                       Entry Enrollment          5544
  NY000000                                    Entry              building or grade for the purpose of
                                                                 Student enrolled                              Entry Enrollment          0022
  NY000000                                    Entry              recording a test score (walk-in)
                                                                 Enrollment in a AHSEP or HSEP                 Entry Enrollment          5555
  NY000000                                    Entry              Program                                       Entry Enrollment          5654
                                                                 Graduated (earned a Regents or local          High School
  NY000000                           Completers (Exit Code)                                                    Graduates                    799
                                                                 diploma)
                                                                                                               High School
  NY000000                           Completers (Exit Code)                                                    Completers                   085
                                                                 Earned an IEP diploma
                                                                 Earned a Local Certificate (cannot be         High School
  NY000000                           Completers (Exit Code)                                                    Completers                   102
                                                                 used after January 31, 2005)
                                                                                                               High School
  NY000000                           Completers (Exit Code)                                                    Completers                   629
                                                                 Previously earned an IEP diploma
                                                                 Earned a High School Equivalency
  NY000000                            GED        (Exit Code)     Diploma (GED)                                 GED                          816
                                                                 Transferred to Public school choice           Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                   Schools                     5797
                                                                 under NCLB
                                                                 Transferred to another school in this         Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                   Schools                      153
                                                                 district or to an out-of-district placement
                                                                 Transferred to another NYS public school      Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                   Schools                      170
                                                                 outside this district with documentation




                                                                                                                                                             <------ Please continue with form.
                                                                 Transferred to a NYS non-public school        Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                   Schools                      204
                                                                 with documentation
                                                                 Transferred to homebound instruction          Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                   Schools                      238
                                                                 provided by this district
                                                                 Transferred to a school outside NYS with      Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                   Schools                      221
                                                                 documentation
                                                                 Transferred to home-schooling by parent       Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                   Schools                      255
                                                                 or guardian
                                                                 Transferred to a postsecondary school         Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                   Schools                      272
                                                                 prior to earning a diplomaage and has not
                                                                 Reached maximum legal
  NY000000                            Dropouts   (Exit Code)     earned a diploma or certificate               Dropouts                     136
  NY000000                            Dropouts   (Exit Code)     Left school: first-time dropout
                                                                 Long-term absence (20 consecutive             Dropouts                     340
  NY000000                            Dropouts   (Exit Code)     unexcused days)
                                                                 Permanent expulsion (student must be          Dropouts                     391
  NY000000                            Dropouts   (Exit Code)     over compulsory attendance age)               Dropouts                     408
  NY000000                            Dropouts   (Exit Code)     Transferred to documentation of
                                                                 Left school, no other high school transfer    Dropouts                     425
  NY000000                            Dropouts   (Exit Code)     equivalency (GED) preparation program         Dropouts                     306
   Prepared by LHRIC DW Team                                                                                                  ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls - File name
   44 Executive Blvd Elmsford, NY 10523                                          (914) 592-4203                                                    Lookup Templates - Sheet name
                                                                                                                                                                  7/19/2010
                                        ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls Lookup Templates                                                                Page 5 of 9

                                                                                                        Other Circumstance
                                   Other      (Exit Code)   Entry into a different grade in the same    for Ending
NY000000                                                    school building                             Enrollment                 782
                                                                                                        Other Circumstance
                                   Other      (Exit Code)   Transferred to an AHSEP or HSEP             for Ending
NY000000                                                    program                                     Enrollment                 289
                                                                                                        Other Circumstance
                                   Other      (Exit Code)                                               for Ending
NY000000                                                    Transferred outside district by court order Enrollment                 323
                                                                                                        Other Circumstance
                                   Other      (Exit Code)   Left school: previously counted as a        for Ending
NY000000                                                    dropout                                     Enrollment                 357
                                                                                                        Other Circumstance
                                   Other      (Exit Code)                                               for Ending
NY000000                                                    Left the U.S.                               Enrollment                 442
                                                                                                        Other Circumstance
                                   Other      (Exit Code)                                               for Ending
NY000000                                                    Deceased                                    Enrollment                 459




                                                            PROGRAM FACTS LOOKUP TEMPLATE
               LOCAL SIS
DISTRICT                                                                                                                     DISTRICT OR
               PROGRAM                  SCHOOL YEAR         PROGRAM TYPE           PROGRAM CODE          DESCRIPTION
  CODE                                                                                                                       SCHOOL LEVEL
                 CODE


                                                                                                                                                Identifies LEP
NY000000                                 2006-06-30         LEP Eligibility              0231          LEP Eligible               District
                                                                                                                                                  Elligability




NY000000                                 2006-06-30         LEP Programs                 5676          Bilingual Program          District




                                                                                                                                                Identifies LEP
                                                                                                       Two-way Bilingual
NY000000                                 2006-06-30         LEP Programs                 5687                                     District      Services being
                                                                                                       Education Program                        administered.




                                                                                                       LEP - Other
NY000000                                 2006-06-30         LEP Programs                 5698                                     District
                                                                                                       Programs



 Prepared by LHRIC DW Team                                                                                            ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                         (914) 592-4203                                               Lookup Templates - Sheet name
                                                                                                                                                   7/19/2010
                                        ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls Lookup Templates                                                 Page 6 of 9



                                                                                        English as a Second
NY000000                                 2006-06-30    LEP Programs              5709                                District
                                                                                        Language


                                                                                        Title I - Part D:
                                                                                        Prevention &
NY000000                                 2006-06-30    NCLB                      0187   Intervention                 District
                                                                                        Programs for
                                                                                        Children and Youth
                                                                                        who are Neglected,
                                                                                        Title I - Part A:
                                                                                        Improving Basic
NY000000                                 2006-06-30    NCLB                      0286                                School
                                                                                        Programs (other
                                                                                        than 5533)


                                                                                        Title I - Part C:
NY000000                                 2006-06-30    NCLB                      0330   Education of                 District
                                                                                        Migratory Children


                                                                                        Supplemental
                                                                                        Services for Schools
NY000000                                 2006-06-30    NCLB                      5533                                School
                                                                                        in Improvement
                                                                                        Status under Title I
                                                                                                                                    Identifies
                                                                                        Title X - Part C:
                                                                                                                                      Funds
                                                                                        Homeless
NY000000                                 2006-06-30    NCLB                      5566                                District        Student
                                                                                        Education/McKinney-
                                                                                                                                     receives
                                                                                        Vento
                                                                                                                                    benefit of.

                                                                                        Title III: Services to
NY000000                                 2006-06-30    NCLB                      5720   Non-Immigrant LEP            School
                                                                                        Students


                                                                                        Title III: Language
                                                                                        Instruction
NY000000                                 2006-06-30    NCLB                      5731                                School
                                                                                        Immigrant LEP
                                                                                        Students
                                                                                        Title III - Part B,
                                                                                        subpart 4:
NY000000                                 2006-06-30    NCLB                      5742   Emergency                    School
                                                                                        Immigration
                                                                                        Education Program

                                                                                        Title I - Part B,
NY000000                                 2006-06-30    NCLB                      5764   subpart 1: Reading           School
                                                                                        First
 Prepared by LHRIC DW Team                                                                               ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                 (914) 592-4203                                          Lookup Templates - Sheet name
                                                                                                                                                     7/19/2010
                                        ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls Lookup Templates                                                   Page 7 of 9



NY000000                                 2006-06-30    Type of Disability         0352   Autism                      District




                                                                                                                                                        <------ Please continue with form.
                                                                                         Emotional
NY000000                                 2006-06-30    Type of Disability         0363                               District
                                                                                         Disturbance




NY000000                                 2006-06-30    Type of Disability         0385   Learning Disability         District




NY000000                                 2006-06-30    Type of Disability         0396   Mental Retardation          District




                                                                                                                                    Disability of
NY000000                                 2006-06-30    Type of Disability         0407   Deafness                    District
                                                                                                                                    the Student




NY000000                                 2006-06-30    Type of Disability         0418   Hearing Impairment          District




                                                                                         Speech or Language
NY000000                                 2006-06-30    Type of Disability         0429                               District
                                                                                         Impairment




                                                                                         Visual Impairment
NY000000                                 2006-06-30    Type of Disability         0440                               District
                                                                                         (includes Blindness)




                                                                                         Orthopedic
NY000000                                 2006-06-30    Type of Disability         0451                               District
                                                                                         Impairment




                                                                                         Other Health
NY000000                                 2006-06-30    Type of Disability         0462                               District
                                                                                         Impairment

 Prepared by LHRIC DW Team                                                                               ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                  (914) 592-4203                                         Lookup Templates - Sheet name
                                                                                                                                                      7/19/2010
                                        ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls Lookup Templates                                                    Page 8 of 9



NY000000                                 2006-06-30    Type of Disability         0473   Multiple Disabilities        District




NY000000                                 2006-06-30    Type of Disability         0484   Deaf-Blindness               District




                                                                                         Traumatic Brain
NY000000                                 2006-06-30    Type of Disability         0495                                District
                                                                                         Injury




                                                                                         Pre-School Student
NY000000                                 2006-06-30    Type of Disability         5786                                District
                                                                                         with a Disability


                                                                                         Removed from
                                                                                         general education
NY000000                                 2006-06-30    Level of Integration       0506                                District
                                                                                         classes for 20% or
                                                                                         less


                                                                                         Removed from
NY000000                                 2006-06-30    Level of Integration       0517   general education            District     Required for a
                                                                                         classes for 21-60%                           Disabled
                                                                                                                                       student
                                                                                                                                      Level of
                                                                                         Removed from
                                                                                                                                   integration for
                                                                                         general education
NY000000                                 2006-06-30    Level of Integration       0528                                District       a Disabled
                                                                                         classes for more
                                                                                                                                       student
                                                                                         than 60%



NY000000                                 2006-06-30    Level of Integration       0539   All separate setting         District




                                                       504 Plan - Safety                 Eligible for safety net
NY000000                                 2006-06-30                               0550                                District
                                                       Net                               in English




                                                       504 Plan - Safety                 Eligible for safety net
NY000000                                 2006-06-30                               0572                                District
                                                       Net                               in Mathematics

 Prepared by LHRIC DW Team                                                                                ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                  (914) 592-4203                                          Lookup Templates - Sheet name
                                                                                                                                                    7/19/2010
                                        ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls Lookup Templates                                                  Page 9 of 9


                                                                                        Eligible for safety net
                                                       504 Plan - Safety
NY000000                                 2006-06-30                              0583   in Global History &         District
                                                       Net
                                                                                        Geography


                                                                                        Eligible for safety net                     Regents -
                                                       504 Plan - Safety
NY000000                                 2006-06-30                              0594   in U.S. History &           District       Safety Net
                                                       Net
                                                                                        Government                                 Exemptions



                                                       504 Plan - Safety                Eligible for safety net
NY000000                                 2006-06-30                              0605                               District
                                                       Net                              in Science




                                                       504 Plan - Safety                Eligible for safety net
NY000000                                 2006-06-30                              5775                               District
                                                       Net                              in All Subjects


                                                                                                                                     May be
                                                                                                                                   determined
                                                                                        Poverty - from low-
NY000000                                 2006-06-30    Other                     0198                               District        based on
                                                                                        income family
                                                                                                                                  Free/Reduced
                                                                                                                                      Lunch
                                                                                                                                  Report all AIS
                                                                                        Academic
                                                                                                                                     services
NY000000                                 2006-06-30    Other                     0209   Intervention Services       School
                                                                                                                                   (required or
                                                                                        - AIS
                                                                                                                                       not)
                                                                                                                                   Must be used
                                                                                                                                    to identify AA
                                                                                        Eligible for Alternate
NY000000                                 2006-06-30    Other                     0220                                 District      student even
                                                                                        Assessment
                                                                                                                                     if not eligible
                                                                                                                                   for testing this
                                                                                                                                       Reporting
                                                                                                                                   Students who
                                                                                                                                          have a
NY000000                                 2006-06-30    Other                     0264   Section 504 Plan              District     subject safety
                                                                                                                                   net must have
                                                                                                                                   a Section 504
                                                                                                                                           Plan
                                                                                                                                    Report for all
                                                                                        Summer School
                                                                                                                                    students who
                                                                                        Participation
NY000000                                 2006-06-30    Other                     0275                                 School       participated in
                                                                                        (beginning summer
                                                                                                                                         summer
                                                                                        2006)
                                                                                                                                          school




                                                                                                                                                       End of forms.
                                                                                                                                         Federal
                                                                                        Early Intervening                          Funding code
NY000000                                 2006-06-30    Other                     5753   Services supported            District          use when
                                                                                        with IDEA funds                              applicable to
                                                                                                                                         student
 Prepared by LHRIC DW Team                                                                                ac22b0c4-8f02-4be9-a91b-34a5f68732aa.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                 (914) 592-4203                                           Lookup Templates - Sheet name

				
DOCUMENT INFO
Description: Legal Forms Templates for Free document sample