Docstoc

Reading Certificate Templates - Excel

Document Sample
Reading Certificate Templates - Excel Powered By Docstoc
					                                                                                                                                                                            7/29/2011
                                       1e58d726-2844-4d0b-9b70-318bc626269c.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                                                                                           1e58d726-2844-4d0b-9b70-318bc626269c.xls - File name
   44 Executive Blvd Elmsford, NY 10523                                            (914) 592-4203                                           Lookup Templates - Sheet name
                                                                                                                                                                                                      7/29/2011
                                             1e58d726-2844-4d0b-9b70-318bc626269c.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                                                                                            1e58d726-2844-4d0b-9b70-318bc626269c.xls - File name
    44 Executive Blvd Elmsford, NY 10523                                                (914) 592-4203                                        Lookup Templates - Sheet name
                                                                                                                                                                     <------ Please continue with form.
                                                                                                                                                                                                           7/29/2011
                                        1e58d726-2844-4d0b-9b70-318bc626269c.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                                                                                     1e58d726-2844-4d0b-9b70-318bc626269c.xls - File name
   44 Executive Blvd Elmsford, NY 10523                                         (914) 592-4203                                        Lookup Templates - Sheet name
                                                                                                                                                                                                   7/29/2011
                                       1e58d726-2844-4d0b-9b70-318bc626269c.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)     Left school, no other high school transfer
                                                                 Transferred to documentation of               Dropouts                    425
  NY000000                            Dropouts   (Exit Code)     equivalency (GED) preparation program         Dropouts                    306

   Prepared by LHRIC DW Team                                                                                                 1e58d726-2844-4d0b-9b70-318bc626269c.xls - File name
   44 Executive Blvd Elmsford, NY 10523                                          (914) 592-4203                                                   Lookup Templates - Sheet name
                                                                                                                                                                   7/29/2011
                                    1e58d726-2844-4d0b-9b70-318bc626269c.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                                                                                            1e58d726-2844-4d0b-9b70-318bc626269c.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                         (914) 592-4203                                               Lookup Templates - Sheet name
                                                                                                                                                7/29/2011
                                    1e58d726-2844-4d0b-9b70-318bc626269c.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                                                                           1e58d726-2844-4d0b-9b70-318bc626269c.xls - File name
 44 Executive Blvd Elmsford, NY 10523                               (914) 592-4203                                        Lookup Templates - Sheet name
                                                                                                                                                  7/29/2011
                                    1e58d726-2844-4d0b-9b70-318bc626269c.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                                                                            1e58d726-2844-4d0b-9b70-318bc626269c.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                (914) 592-4203                                        Lookup Templates - Sheet name
                                                                                                                                                   7/29/2011
                                    1e58d726-2844-4d0b-9b70-318bc626269c.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                                                                            1e58d726-2844-4d0b-9b70-318bc626269c.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                (914) 592-4203                                        Lookup Templates - Sheet name
                                                                                                                                                    7/29/2011
                                    1e58d726-2844-4d0b-9b70-318bc626269c.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                                                                           1e58d726-2844-4d0b-9b70-318bc626269c.xls - File name
 44 Executive Blvd Elmsford, NY 10523                               (914) 592-4203                                        Lookup Templates - Sheet name

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:56
posted:7/30/2011
language:English
pages:9
Description: Reading Certificate Templates document sample