Appendix H2 Appendix H2 LTT 2020 Student Information Instructions

NATIONAL CENTER FOR EDUCATION STATISTICS

NATIONAL ASSESSMENT OF EDUCATIONAL PROGRESS

National Assessment of Educational Progress (NAEP) 2019 and 2020

Long-Term Trend (LTT) 2020 Update

Appendix H2

Long Term Trend (LTT) 2020 Instructions for Entering Student Information

OMB# 1850-0928 v.15

March 2019

The text provided in this document reflects the final text for the 2020 LTT E-filing in the MyNAEP system. The screenshots provided reflect the 2019 E-filing in the MyNAEP system – the final screenshots for LTT 2020 E-filing will be provided as a non-substantive change request by August 2019.

Table of Contents

Appendix H2-1: Age 9 students 4

Appendix H2-2: Age 13 students 12

Appendix H2-3: Age 17 students 20

Information on Log-in Screen:

Paperwork Burden Statement, OMB Information

According to the Paperwork Reduction Act of 1995, no persons are required to respond to a collection of information unless it displays a valid OMB control number. The valid OMB control number for this voluntary information collection is 1850-0928. The time required to complete this information collection is estimated to be average 120 minutes, including the time to review instructions, search existing data resources, gather the data needed, and complete and review the information collection. If you have any comments concerning the accuracy of the time estimate, suggestions for improving this collection, or any comments or concerns regarding the status of your individual submission of form, please write to: National Assessment of Educational Progress (NAEP), National Center for Education Statistics (NCES), Potomac Center Plaza, 550 12^th St., SW, 4th floor, Washington, DC 20202.

Authorization and Confidentiality Assurance

National Center for Education Statistics (NCES) is authorized to conduct NAEP by the National Assessment of Educational Progress Authorization Act (20 U.S.C. §9622) and to collect students’ education records from education agencies or institutions for the purposes of evaluating federally supported education programs under the Family Educational Rights and Privacy Act (FERPA, 34 CFR §§ 99.31(a)(3)(iii) and 99.35). All of the information provided by participants may be used only for statistical purposes and may not be disclosed, or used, in identifiable form for any other purpose except as required by law (20 U.S.C. §9573 and 6 U.S.C. §151). By law, every NCES employee as well as every NCES agent, such as contractors and NAEP coordinators, has taken an oath and is subject to a jail term of up to 5 years, a fine of $250,000, or both if he or she willfully discloses ANY identifiable information about students. Electronic submission of student information will be monitored for viruses, malware, and other threats by Federal employees and contractors in accordance with the Cybersecurity Enhancement Act of 2015. The collected information will be combined across respondents to produce statistical reports.

Appendix H2-1: Age 9 students

N AEP 2020 LTT Age 9

INSTRUCTIONS FOR PREPARING AND SUBMITTING

AN ELECTRONIC FILE OF STUDENTS

(One Column Race/Ethnicity)

NAEP needs a complete list of students in the selected age group(s) at your school in order to draw a random sample of students to participate in the assessment. Your student data electronic file (E-File) must be submitted as a Microsoft Excel file.

We recommend that you create your student file using the NAEP E-File Excel Template, which is available on the MyNAEP website’s “Submit Student List” page. If necessary, you may alternatively provide an Excel file with the same column headers and data in a different order. If you cannot submit your student data in an Excel file, call the NAEP Help Desk at 1-800-283-6237.

Step 1 — The E-Filing Template

Download and review the E-Filing Template. Note the column headers (fields) that must be included in your student list. If you do not have data for a particular field, you may leave the column blank.

Step 2 — Compile Data for the Template

Prepare and submit a separate Excel file of all students in your school with birthdates between 01/01/2010 and 12/31/2010. Students may be in any grade however we expect most of the students to be in the following grades: 2, 3, 4, and 5.

• Include in the file all students in the age group, even those students who typically may be excluded from other testing programs, such as students with IEPs (SD) and English language learners (ELL). Make sure there are no duplicate students in your file.

• Also include students in the sampled age group who were displaced from other locations due to hurricanes and other disasters.

• If this is a year-round school,¹ include students who will be on break/on vacation on the scheduled assessment day along with all of the other students in the sampled age group who are enrolled. The NAEP E-File Excel Template contains an “On Break” column you will use to identify those students who will be on break/on vacation by filling in “Yes.” (If you are not using the template, be sure to create and provide data for an “On Break” column in your file.)

Your Excel file must contain the following data:

Excel Header/Field Name

NAEP Values

Comments

State unique Student ID

N/A

If available; do not use the student’s Social Security number

Student First Name

N/A

Text, must be in its own column

Student Middle Name

N/A

Text--Middle Name is optional, but the column must be included in the Excel file

Student Last Name

N/A

Text, must be in its own column

Grade in School

Any

Use current year data

Homeroom or other Locator

N/A

If available, locator information is helpful in finding students and notifying them of the assessment

Month of Birth

M or MM (numeric format)

Numeric format; must be in its own column

Year of Birth

YYYY (numeric format)

The expected ranges for Year of Birth are listed:

2010

Numeric format; must be in its own column

Sex

School-defined codes

Codes (numeric or text) for Male/Female

Race/Ethnicity – one column

School-defined codes for:

Use ONE code per student, text or numeric

• Hispanic, of any race: A person of Mexican, Puerto Rican, Cuban, Central or South American, or other Spanish (but not Portuguese) culture of origin, regardless of race

• White, not Hispanic: A person having origins in any of the original peoples of Europe (except Spain), North Africa, or the Middle East

• Black or African American, not Hispanic: A person having origins in any of the Black peoples of Africa

• Asian, not Hispanic: A person having origins in any of the original peoples of the Far East, Southeast Asia, the Indian Subcontinent, including, for example, Cambodia, China, Japan, India, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam

• American Indian or Alaska Native, not Hispanic: A person having origins in any of the original peoples of North and South America (including Central America), and who maintains tribal affiliation or community attachment

• Native Hawaiian or Pacific Islander, not Hispanic: A person having origins in any of the original people of Hawaii, Guam, Samoa or other Pacific Islands

• Two or More Races, not Hispanic: A person who identifies with two or more of the non-Hispanic categories above

• School does not collect this information: Available to nonpublic schools only. When used, this code must be applied to all students.

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

National School Lunch Program (NSLP)

School defined codes for:

Use ONE code per student, text or numeric

• Student not eligible to participate: Student is not eligible for free or reduced-price lunch.

• Free lunch: Student is eligible for free lunch. Schools participating in Provisions 2 or 3 of the NSLP should code all students as “free lunch.” ²

• Reduced-price lunch: Student is eligible for reduced-price lunch.

• School not participating: School does not participate in the NSLP. When used, this code must be applied to all students.

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

SPECIAL INSTRUCTIONS FOR CEP SCHOOLS: If your school participates in the Community Eligibility Provision (CEP), note that for NAEP, only students who are economically disadvantaged students can be classified as eligible for free or reduced-price lunch.

---------------------------------------------------------------------------CEP Direct Only

In CEP schools in our state, economically disadvantaged students are those who are directly certified through participation in assistance programs such as the Supplemental Nutrition Assistance Program (SNAP) and the Temporary Assistance for Needy Families (TANF).

Please code your students as follows

Is the student economically disadvantaged?	How should student be coded on NAEP?
Yes	1. Eligible for free or reduced prince lunch
No	2. Student not eligible
Information missing	3. Information unavailable

---------------------------------------------------------------------------CEP Direct Certification Plus

In CEP schools in our state, economically disadvantaged students are identified in two ways: a) directly certified through participation in assistance programs such as the Supplemental Nutrition Assistance Program (SNAP) and the Temporary Assistance for Needy Families (TANF); b) through a household income survey.

Please code your students as follows:

Is the student economically disadvantaged?	How should student be coded on NAEP?
Yes	1. Eligible for free or reduced price lunch
No	2. Student not eligible
Information missing	3. Information unavailable

---------------------------------------------------------------------------

CEP All

In our state, all students in CEP schools are considered economically disadvantaged.

Please code your students as follows:

Is the student economically disadvantaged?	How should student be coded on NAEP?
Yes	1. Eligible for free lunch

Students with Disabilities (SD)

School defined codes for:

• Yes, IEP: Student has a formal Individualized Education Plan (IEP), the student’s IEP is in progress, or the student has an equivalent classification for private schools. If some students have both an IEP and a 504 Plan, code these students as “Yes, IEP.”

Use ONE code per student, text or numeric

• No, not SD: Student does not have an IEP. If students have a 504 Plan without an IEP, code these students as “No, not SD.”

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

English Language Learner (ELL)

School-defined codes for:

Use ONE code per student, text or numeric

• Yes, ELL

• No, Not ELL

• No, Formerly ELL : If a student has achieved full English proficiency within the previous 2 years and the state includes formerly ELL students in its accountability reports, the student should be coded as “No, formerly ELL.” Public schools, contact your NAEP State Coordinator if you have any questions about using this code.

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

On-Break Indicator

School-defined code

Only for year-round schools; column can be left off if school is not year-round

Student ZIP Code

Numeric only

If available; format can be 5 digits or 5 plus 4

Tips for ensuring the E-File process goes smoothly:

• The NAEP E-File template should be used if possible. Please use it as is. Do not change the column headers. Student information must begin on the second row. There should be no empty rows between the headings and the student data or within the student data, and no headings within the data.

• If you are not able to use the NAEP E-File Excel Template (for example, because of the way your data system works), the columns in your Excel E-File should have the same, or similar, names but do not have to be in any particular order. You will be able to identify the contents of each column after you have submitted your file. (For example, you will be able to indicate that your column labeled “Gender” is what provides the NAEP “Sex” information, and your value of “1” is “Male” and a “2” is “Female,” or whatever the correct interpretation.)

• Be sure to give your file a unique, descriptive name. Select “File,” then “Save As,” and give it a name such as “Your School Name Age 9.xls.” Should you need to reference your file again, this will help you locate it after E-Filing.

• The first row of data in your file will be read as the column header unless you indicate otherwise on the E-Filing “Welcome” page. Each succeeding row will be considered a student record.

• If you merge or cut and paste data from another Excel file into the template, review the file afterward to be sure there are properly aligned student data in every row and there are no column headers or blank rows in the middle of the data.

• Be sure that your file contains only a heading row and student data, not notes or text in additional columns, or they will be read as data resulting in a warning or error message.

• There should be only one worksheet with data in the Excel file. If there are other worksheets, they must not contain any data.

Step 3 – E-File

Once your file is prepared and checked for accuracy and completeness, log into the MyNAEP website and select “Submit Student List” from the left-hand menu.

• Select the “Start E-Filing” button

• You will see a checklist come up on the screen; review it carefully to be sure your file is set up correctly and is ready to be submitted. Then select “Continue.”

• Enter the required fields and then browse for the name of your file and select “Upload.”

Step 4 – Map Your Columns and Rows to NAEP Values

The field names used by your database system may not have the same names as the NAEP values. You will need to match the names of your columns to the names of the NAEP columns and then match row values to NAEP values.

Shown on the next page is an example of row mapping. You need to match the values in each of your columns to the NAEP codes (in drop-down). Once you map a value, select “Next” to move to the next value.

When you finish row mapping, the E-Filing process will continue and you will be prompted to verify your data.

If you need assistance, call the NAEP Help Desk at 1-800-283-6237.

Appendix H2-2: Age 13 students

N AEP 2020 LTT Age 13

INSTRUCTIONS FOR PREPARING AND SUBMITTING

AN ELECTRONIC FILE OF STUDENTS

(One Column Race/Ethnicity)

NAEP needs a complete list of students in the selected age group(s) at your school in order to draw a random sample of students to participate in the assessment. Your student data electronic file (E-File) must be submitted as a Microsoft Excel file.

We recommend that you create your student file using the NAEP E-File Excel Template, which is available on the MyNAEP website’s “Submit Student List” page. If necessary, you may alternatively provide an Excel file with the same column headers and data in a different order. If you cannot submit your student data in an Excel file, call the NAEP Help Desk at 1-800-283-6237.

Step 1 — The E-Filing Template

Download and review the E-Filing Template. Note the column headers (fields) that must be included in your student list. If you do not have data for a particular field, you may leave the column blank.

Step 2 — Compile Data for the Template

Prepare and submit a separate Excel file of all students in your school with birthdates between 01/01/2006 and 12/31/2006. Students may be in any grade however we expect most of the students to be in the following grades: 6, 7, 8, and 9.

• Include in the file all students in the age group, even those students who typically may be excluded from other testing programs, such as students with IEPs (SD) and English language learners (ELL). Make sure there are no duplicate students in your file.

• Also include students in the age group who were displaced from other locations due to hurricanes and other disasters.

• If this is a year-round school,³ include students who will be on break/on vacation on the scheduled assessment day along with all of the other students in the age group. The NAEP E-File Excel Template contains an “On Break” column you will use to identify those students who will be on break/on vacation by filling in “Yes.” (If you are not using the template, be sure to create and provide data for an “On Break” column in your file.)

Your Excel file must contain the following data:

Excel Header/Field Name

NAEP Values

Comments

State unique Student ID

N/A

If available; do not use the student’s Social Security number

Student First Name

N/A

Text, must be in its own column

Student Middle Name

N/A

Text--Middle Name is optional, but the column must be included in the Excel file

Student Last Name

N/A

Text, must be in its own column

Grade in School

Any

Use current year data

Homeroom or other Locator

N/A

If available, locator information is helpful in finding students and notifying them of the assessment

Month of Birth

M or MM (numeric format)

Numeric format; must be in its own column

Year of Birth

YYYY (numeric format)

The expected ranges for Year of Birth are listed:

2006

Numeric format; must be in its own column

Sex

School-defined codes

Codes (numeric or text) for Male/Female

Race/Ethnicity – one column

School-defined codes for:

Use ONE code per student, text or numeric

• Hispanic, of any race: A person of Mexican, Puerto Rican, Cuban, Central or South American, or other Spanish (but not Portuguese) culture of origin, regardless of race

• White, not Hispanic: A person having origins in any of the original peoples of Europe (except Spain), North Africa, or the Middle East

• Black or African American, not Hispanic: A person having origins in any of the Black peoples of Africa

• Asian, not Hispanic: A person having origins in any of the original peoples of the Far East, Southeast Asia, the Indian Subcontinent, including, for example, Cambodia, China, Japan, India, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam

• American Indian or Alaska Native, not Hispanic: A person having origins in any of the original peoples of North and South America (including Central America), and who maintains tribal affiliation or community attachment

• Native Hawaiian or Pacific Islander, not Hispanic: A person having origins in any of the original people of Hawaii, Guam, Samoa or other Pacific Islands

• Two or More Races, not Hispanic: A person who identifies with two or more of the non-Hispanic categories above

• School does not collect this information: Available to nonpublic schools only. When used, this code must be applied to all students.

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

National School Lunch Program (NSLP)

School defined codes for:

Use ONE code per student, text or numeric

• Student not eligible to participate: Student is not eligible for free or reduced-price lunch.

• Free lunch: Student is eligible for free lunch. Schools participating in Provisions 2 or 3 of the NSLP should code all students as “free lunch.” ⁴

• Reduced-price lunch: Student is eligible for reduced-price lunch.

• School not participating: School does not participate in the NSLP. When used, this code must be applied to all students.

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

SPECIAL INSTRUCTIONS FOR CEP SCHOOLS: If your school participates in the Community Eligibility Provision (CEP), note that for NAEP, only students who are economically disadvantaged students can be classified as eligible for free or reduced-price lunch.

---------------------------------------------------------------------------CEP Direct Only

In CEP schools in our state, economically disadvantaged students are those who are directly certified through participation in assistance programs such as the Supplemental Nutrition Assistance Program (SNAP) and the Temporary Assistance for Needy Families (TANF).

Please code your students as follows

Is the student economically disadvantaged?	How should student be coded on NAEP?
Yes	1. Eligible for free or reduced prince lunch
No	2. Student not eligible
Information missing	3. Information unavailable

---------------------------------------------------------------------------CEP Direct Certification Plus

In CEP schools in our state, economically disadvantaged students are identified in two ways: a) directly certified through participation in assistance programs such as the Supplemental Nutrition Assistance Program (SNAP) and the Temporary Assistance for Needy Families (TANF); b) through a household income survey.

Please code your students as follows:

Is the student economically disadvantaged?	How should student be coded on NAEP?
Yes	1. Eligible for free or reduced price lunch
No	2. Student not eligible
Information missing	3. Information unavailable

---------------------------------------------------------------------------

CEP All

In our state, all students in CEP schools are considered economically disadvantaged.

Please code your students as follows:

Is the student economically disadvantaged?	How should student be coded on NAEP?
Yes	1. Eligible for free lunch

Students with Disabilities (SD)

School defined codes for:

• Yes, IEP: Student has a formal Individualized Education Plan (IEP), the student’s IEP is in progress, or the student has an equivalent classification for private schools. If some students have both an IEP and a 504 Plan, code these students as “Yes, IEP.”

Use ONE code per student, text or numeric

• No, not SD: Student does not have an IEP. If students have a 504 Plan without an IEP, code these students as “No, not SD.”

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

English Language Learner (ELL)

School-defined codes for:

Use ONE code per student, text or numeric

• Yes, ELL

• No, Not ELL

• No, Formerly ELL: If a student has achieved full English proficiency within the previous 2 years and the state includes formerly ELL students in its accountability reports, the student should be coded as “No, formerly ELL.” Public schools, contact your NAEP State Coordinator if you have any questions about using this code.

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

On-Break Indicator

School-defined code

Only for year-round schools; column can be left off if school is not year-round

Student ZIP Code

Numeric only

If available; format can be 5 digits or 5 plus 4

Tips for ensuring the E-File process goes smoothly:

• The NAEP E-File template should be used if possible. Please use it as is. Do not change the column headers. Student information must begin on the second row. There should be no empty rows between the headings and the student data or within the student data, and no headings within the data.

• If you are not able to use the NAEP E-File Excel Template (for example, because of the way your data system works), the columns in your Excel E-File should have the same, or similar, names but do not have to be in any particular order. You will be able to identify the contents of each column after you have submitted your file. (For example, you will be able to indicate that your column labeled “Gender” is what provides the NAEP “Sex” information, and your value of “1” is “Male” and a “2” is “Female,” or whatever the correct interpretation.)

• Be sure to give your file a unique, descriptive name. Select “File,” then “Save As,” and give it a name such as “Your School Name Age 13.xls.” Should you need to reference your file again, this will help you locate it after E-Filing.

• The first row of data in your file will be read as the column header unless you indicate otherwise on the E-Filing “Welcome” page. Each succeeding row will be considered a student record.

• If you merge or cut and paste data from another Excel file into the template, review the file afterward to be sure there are properly aligned student data in every row and there are no column headers or blank rows in the middle of the data.

• Be sure that your file contains only a heading row and student data, not notes or text in additional columns, or they will be read as data resulting in a warning or error message.

• There should be only one worksheet with data in the Excel file. If there are other worksheets, they must not contain any data.

Step 3 – E-File

Once your file is prepared and checked for accuracy and completeness, log into the MyNAEP website and select “Submit Student List” from the left-hand menu.

• Select the “Start E-Filing” button.

• You will see a checklist come up on the screen; review it carefully to be sure your file is set up correctly and is ready to be submitted. Then select “Continue.”

• Enter the required fields and then browse for the name of your file and select “Upload.”

Step 4 – Map Your Columns and Rows to NAEP Values

The field names used by your database system may not have the same names as the NAEP values. You will need to match the names of your columns to the names of the NAEP columns and then match row values to NAEP values.

Shown on the next page are two examples of row mapping. You need to match the values in each of your columns to the NAEP codes (in drop-down). Once you map a value, select “Next” to move to the next value.

When you finish row mapping, the E-Filing process will continue and you will be prompted to verify your data.

If you need assistance, call the NAEP Help Desk at 1-800-283-6237.

Appendix H2-3: Age 17 students

N AEP 2020 LTT Age17

INSTRUCTIONS FOR PREPARING AND SUBMITTING

AN ELECTRONIC FILE OF STUDENTS

(One Column Race/Ethnicity)

NAEP needs a complete list of students in the selected age group(s) at your school in order to draw a random sample of students to participate in the assessment. Your student data electronic file (E-File) must be submitted as a Microsoft Excel file.

We recommend that you create your student file using the NAEP E-File Excel Template, which is available on the MyNAEP website’s “Submit Student List” page. If necessary, you may alternatively provide an Excel file with the same column headers and data in a different order. If you cannot submit your student data in an Excel file, call the NAEP Help Desk at 1-800-283-6237.

Step 1 — The E-Filing Template

Download and review the E-Filing Template. Note the column headers (fields) that must be included in your student list. If you do not have data for a particular field, you may leave the column blank.

Step 2 — Compile Data for the Template

Prepare and submit a separate Excel file of all students in your school with birthdates between 10/01/2002 and 9/30/2003. Students may be in any grade however we expect most of the students to be in the following grades: 9, 10, 11 and 12.

• Include in the file all students in the age group, even those students who typically may be excluded from other testing programs, such as students with IEPs (SD) and English language learners (ELL). Make sure there are no duplicate students in your file.

• Also include students in the age group who were displaced from other locations due to hurricanes and other disasters.

• If this is a year-round school,⁵ include students who will be on break/on vacation on the scheduled assessment day along with all of the other students in the age group. The NAEP E-File Excel Template contains an “On Break” column you will use to identify those students who will be on break/on vacation by filling in “Yes.” (If you are not using the template, be sure to create and provide data for an “On Break” column in your file.)

Your Excel file must contain the following data:

Excel Header/Field Name

NAEP Values

Comments

State unique Student ID

N/A

If available; do not use the student’s Social Security number

Student First Name

N/A

Text, must be in its own column

Student Middle Name

N/A

Text--Middle Name is optional, but the column must be included in the Excel file

Student Last Name

N/A

Text, must be in its own column

Grade in School

Any

Use current year data

Homeroom or other Locator

N/A

If available, locator information is helpful in finding students and notifying them of the assessment

Month of Birth

M or MM (numeric format)

Numeric format; must be in its own column

Year of Birth

YYYY (numeric format)

The expected ranges for Year of Birth are listed:

2002-2003

Numeric format; must be in its own column

Sex

School-defined codes

Codes (numeric or text) for Male/Female

Race/Ethnicity – one column

School-defined codes for:

Use ONE code per student, text or numeric

• Hispanic, of any race: A person of Mexican, Puerto Rican, Cuban, Central or South American, or other Spanish (but not Portuguese) culture of origin, regardless of race

• White, not Hispanic: A person having origins in any of the original peoples of Europe (except Spain), North Africa, or the Middle East

• Black or African American, not Hispanic: A person having origins in any of the Black peoples of Africa

• Asian, not Hispanic: A person having origins in any of the original peoples of the Far East, Southeast Asia, the Indian Subcontinent, including, for example, Cambodia, China, Japan, India, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam

• American Indian or Alaska Native, not Hispanic: A person having origins in any of the original peoples of North and South America (including Central America), and who maintains tribal affiliation or community attachment

• Native Hawaiian or Pacific Islander, not Hispanic: A person having origins in any of the original people of Hawaii, Guam, Samoa or other Pacific Islands

• Two or More Races, not Hispanic: A person who identifies with two or more of the non-Hispanic categories above

• School does not collect this information: Available to nonpublic schools only. When used, this code must be applied to all students.

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

National School Lunch Program (NSLP)

School defined codes for:

Use ONE code per student, text or numeric

• Student not eligible to participate: Student is not eligible for free or reduced-price lunch.

• Free lunch: Student is eligible for free lunch. Schools participating in Provisions 2 or 3 of the NSLP should code all students as “free lunch.” ⁶

• Reduced-price lunch: Student is eligible for reduced-price lunch.

• School not participating: School does not participate in the NSLP. When used, this code must be applied to all students.

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

SPECIAL INSTRUCTIONS FOR CEP SCHOOLS: If your school participates in the Community Eligibility Provision (CEP), note that for NAEP, only students who are economically disadvantaged students can be classified as eligible for free or reduced-price lunch.

---------------------------------------------------------------------------CEP Direct Only

In CEP schools in our state, economically disadvantaged students are those who are directly certified through participation in assistance programs such as the Supplemental Nutrition Assistance Program (SNAP) and the Temporary Assistance for Needy Families (TANF).

Please code your students as follows

Is the student economically disadvantaged?	How should student be coded on NAEP?
Yes	1. Eligible for free or reduced prince lunch
No	2. Student not eligible
Information missing	3. Information unavailable

---------------------------------------------------------------------------CEP Direct Certification Plus

In CEP schools in our state, economically disadvantaged students are identified in two ways: a) directly certified through participation in assistance programs such as the Supplemental Nutrition Assistance Program (SNAP) and the Temporary Assistance for Needy Families (TANF); b) through a household income survey.

Please code your students as follows:

Is the student economically disadvantaged?	How should student be coded on NAEP?
Yes	1. Eligible for free or reduced price lunch
No	2. Student not eligible
Information missing	3. Information unavailable

---------------------------------------------------------------------------

CEP All

In our state, all students in CEP schools are considered economically disadvantaged.

Please code your students as follows:

Is the student economically disadvantaged?	How should student be coded on NAEP?
Yes	1. Eligible for free lunch

Students with Disabilities (SD)

School defined codes for:

• Yes, IEP: Student has a formal Individualized Education Plan (IEP), the student’s IEP is in progress, or the student has an equivalent classification for private schools. If some students have both an IEP and a 504 Plan, code these students as “Yes, IEP.”

Use ONE code per student, text or numeric

• No, not SD: Student does not have an IEP. If students have a 504 Plan without an IEP, code these students as “No, not SD.”

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

English Language Learner (ELL)

School-defined codes for:

Use ONE code per student, text or numeric

• Yes, ELL

• No, Not ELL

• No, Formerly ELL: If a student has achieved full English proficiency within the previous 2 years and the state includes formerly ELL students in its accountability reports, the student should be coded as “No, formerly ELL.” Public schools, contact your NAEP State Coordinator if you have any questions about using this code.

• Information unavailable at this time: If you currently do not have this information for one or more students, blank cells or an indicator such as “N/A” (Not Available) in the cell(s) can be mapped to this code to notify your NAEP representative of the need to collect the data at a later date.

On-Break Indicator

School-defined code

Only for year-round schools; column can be left off if school is not year-round

Student ZIP Code

Numeric only

If available; format can be 5 digits or 5 plus 4

Tips for ensuring the E-File process goes smoothly:

• The NAEP E-File template should be used if possible. Please use it as is. Do not change the column headers. Student information must begin on the second row. There should be no empty rows between the headings and the student data or within the student data, and no headings within the data.

• If you are not able to use the NAEP E-File Excel Template (for example, because of the way your data system works), the columns in your Excel E-File should have the same, or similar, names but do not have to be in any particular order. You will be able to identify the contents of each column after you have submitted your file. (For example, you will be able to indicate that your column labeled “Gender” is what provides the NAEP “Sex” information, and your value of “1” is “Male” and a “2” is “Female,” or whatever the correct interpretation.)

• Be sure to give your file a unique, descriptive name. Select “File,” then “Save As,” and give it a name such as “Your School Name Age 17.xls.” Should you need to reference your file again, this will help you locate it after E-Filing.

• The first row of data in your file will be read as the column header unless you indicate otherwise on the E-Filing “Welcome” page. Each succeeding row will be considered a student record.

• If you merge or cut and paste data from another Excel file into the template, review the file afterward to be sure there are properly aligned student data in every row and there are no column headers or blank rows in the middle of the data.

• Be sure that your file contains only a heading row and student data, not notes or text in additional columns, or they will be read as data resulting in a warning or error message.

• There should be only one worksheet with data in the Excel file. If there are other worksheets, they must not contain any data.

Step 3 – E-File

Once your file is prepared and checked for accuracy and completeness, log into the MyNAEP website and select “Submit Student List” from the left-hand menu.

• Select the “Start E-Filing” button.

• You will see a checklist come up on the screen; review it carefully to be sure your file is set up correctly and is ready to be submitted. Then select “Continue.”

• Enter the required fields and then browse for the name of your file and select “Upload.”

Step 4 – Map Your Columns and Rows to NAEP Values

The field names used by your database system may not have the same names as the NAEP values. You will need to match the names of your columns to the names of the NAEP columns and then match row values to NAEP values.

Shown on the next page are two examples of row mapping. You need to match the values in each of your columns to the NAEP codes (in drop-down). Once you map a value, select “Next” to move to the next value.

When you finish row mapping, the E-Filing process will continue and you will be prompted to verify your data.

If you need assistance, call the NAEP Help Desk at 1-800-283-6237.

1 In year-round schools, students attend classes throughout the 12 calendar months, unlike traditional schools that follow the 9-month calendar. However, at any one time during the year a percentage (e.g., 25 percent) of the students will be on break or on vacation.

2 If it is not possible to distinguish between “free” and “reduced-price” for some students, code these students as eligible for free lunch.

3 In year-round schools, students attend classes throughout the 12 calendar months, unlike traditional schools that follow the 9-month calendar. However, at any one time during the year a percentage (e.g., 25 percent) of the students will be on break or on vacation.

4 If it is not possible to distinguish between “free” and “reduced-price” for some students, code these students as eligible for free lunch.

5 In year-round schools, students attend classes throughout the 12 calendar months, unlike traditional schools that follow the 9-month calendar. However, at any one time during the year a percentage (e.g., 25 percent) of the students will be on break or on vacation.

6 If it is not possible to distinguish between “free” and “reduced-price” for some students, code these students as eligible for free lunch.