Site Data Imports

Multiple Site Import

Multiple placement sites may be added or edited at one time using this import. Note: Sites listed in the NCES database cannot be added or edited.

Fields

All headers in the template must be uploaded as provided. Optional fields may be left blank but the header must remain on the column. The file must contain the following columns in the following order:

Site ID

Explanation: Unique Identifier for site
Example: 5f7d3d58
Field Type and Length: text
Sample file column: A
Import Status: Optional*

*If no site ID is provided the system will create a new site and assign an ID. If an existing Site ID is provided, the system will update that record with details provided in the CSV file.

Site Name

Explanation: Name of the site
Example: Austin Elementary School
Field Type and Length: text
Sample file column: A
Import Status: Required

Street Address

Explanation: Street number and Street where the site is located
Example: 123 Main St
Field Type and Length: Alphanumeric
Sample file column: B
Import Status: Optional

City or Zip Code

Explanation: Either the city or the zip code of the site can be provided
Example: “Austin” or “73301”
Field Type and Length: alphanumeric
Sample file column: C
Import Status: Required

Country

Explanation: Country where the site is located
Example: United States
Field Type and Length: Text
Sample file column: D
Import Status: Required

Site Website

Explanation: Provide a link to the partner site website
Example: www.elementaryschool.com
Field Type and Length: text
Sample file column: E
Import Status: Optional

Site Type

Explanation: Use “Ed Prep” if the site if for an education prep related placement; use “Other Program” if the placement is for another program (ie. social work or other clinical placement)
Example: “Ed Prep” or “Other Program”
Field Type and Length: text
Sample file column: F
Import Status: Required

The following fields are only relevant for “Ed Prep” type sites; please leave these fields blank if the site type is “Other Program”

Lowest Grade

Explanation: Lowest grade available for placements at the site; the system will select all grades between the “Lowest Grade” and “Highest Grade” provided. Accepted Values are:
- Pre-Kindergarten
- Kindergarten
- 1st
- 2nd
- 3rd
- 4th
- 5th
- 6th
- 7th
- 8th
- 9th
- 10th
- 11th
- 12th
- 13th
- Adult Education
Example: Pre-Kindergarten
Field Type and Length: text
Sample file column: G
Import Status: Optional

Highest Grade

Explanation: Highest grade available for placements at the site; the system will select all grades between the “Lowest Grade” and “Highest Grade” provided. For example, if “Pre-Kindergarten” is provided in “lowest grade” and “2nd” is provided in “Highest Grade”, then values of “Pre-Kindergarten”, “Kindergarten”, “1st”, and “2nd” will be included. Accepted Values are:
- Pre-Kindergarten
- Kindergarten
- 1st
- 2nd
- 3rd
- 4th
- 5th
- 6th
- 7th
- 8th
- 9th
- 10th
- 11th
- 12th
- 13th
- Adult Education
Example: 2nd
Field Type and Length: text
Sample file column: H
Import Status: Optional

Title 1 Status

Explanation: Is the school a Title 1 site? Accepted values are “yes”, “no”, or “unknown”. If no value is provided then “Unknown” will be selected.
Example: Yes
Field Type and Length: text
Sample file column: I
Import Status: Optional

School Type

Explanation: Accepted values are:
- Regular school
- Special Education School
- Vocational School
- Other/Alternative School
- Reportable Program
Example: Vocational School
Field Type and Length: text
Sample file column: J
Import Status: Optional

Charter

Explanation: Is the school a charter school? Accepted values are “yes” or “no”
Example: Yes
Field Type and Length: text
Sample file column: K
Import Status: Optional

Magnet

Explanation: Is the school a magnet school? Accepted values are “yes” or “no”
Example: Yes
Field Type and Length: text
Sample file column: K
Import Status: Optional

Geographic Locale

Explanation: Accepted values are “City”, “Suburban”, “Town”, “Rural”
Example: Rural
Field Type and Length: text
Sample file column: L
Import Status: Optional

The following 7 fields record student enrollment demographics. The enrollment counts will be used to generate a pie chart that will be displayed on the site detail page. Please enter a percentage value.

American Indian/Alaska Native American

Explanation: Percentage of student enrollment that is American Indian or Alaska Native American
Example: 15
Field Type and Length: numeric
Sample file column: M
Import Status: Optional

Asian

Explanation: Percentage of student enrollment that is Asian
Example: 15
Field Type and Length: numeric
Sample file column: N
Import Status: Optional

Black

Explanation: Percentage of student enrollment that is Black
Example: 15
Field Type and Length: numeric
Sample file column: O
Import Status: Optional

Hispanic

Explanation: Percentage of student enrollment that is Hispanic
Example: 15
Field Type and Length: numeric
Sample file column: P
Import Status: Optional

Native Hawaiian/Pacific Islander

Explanation: Percentage of student enrollment that is Native Hawaiian or Pacific Islander
Example: 15
Field Type and Length: numeric
Sample file column: Q
Import Status: Optional

White

Explanation: Percentage of student enrollment that is White
Example: 15
Field Type and Length: numeric
Sample file column: R
Import Status: Optional

Two or more races

Explanation: Percentage of student enrollment that is two or more races
Example: 15
Field Type and Length: numeric
Sample file column: S
Import Status: Optional

Free Lunch Eligible

Explanation: The percentage of the student population eligible to participate in the free or reduced-price programs under the National School Lunch Act of 1946
Example: 35
Field Type and Length: numeric
Sample file column: T
Import Status: Optional

Reduced Price Lunch Eligible

Explanation: The percentage of the student population eligible to participate in the Reduced-Price Lunch programs under the National School Lunch Act of 1946
Example: 35
Field Type and Length: numeric
Sample file column: U
Import Status: Optional