Import Students This table identifies the name of each column and explains the data that need to be entered for each.   This field contains... This field is for entering the... The paramaters for this data are... When the data includes numeric options, the choices are as follows: Username unique username Username is not required but if added, it must be between 5 and 50 alphanumeric characters or the following special characters: period, hyphen, underscore, @ sign. This is not a required field. The system will generate if left blank. It cannot be changed for the new account once it is created.   Password password Password is not required but if added, it must be between 5 and 20 alphanumeric characters. Alphanumeric characters This is not a required field. The system will generate if left blank. It cannot be changed for the new account once it is created.. Case Sensitive   First first Name First name is a required field.Will allow alphanumeric characters as well as spaces and , ' - .   Middle Middle initial     Last last Name Last name is a required field. Will allow alphanumeric characters as well as spaces and , ' - .   Student ID assigned ID a number of 15 characters or less Located in student records.If Student ID's are longer than 15 characters. Please truncate to 15. Grade grade Numerals zero through 12 with a maximum of 2 characters 0 = K Gender gender Numerals 1, and 2 1 = female 2 = male Ethnicity ethnic background Numerals zero through 7 and multiples separated by a pipe ( | ) 0 = unknown 1 = American Indian/Alaskan Native 2 = Asian 3 = Black or African American 4 = Hispanic or Latino 5 = Native Hawaiian or other Pacific Islander 6 = White 7 = Other Special Services required special services Numerals zero through 5 and multiples separated by a pipe ( | ) 0 = unknown 1 = IEP 2 = 504 3 = Gifted/Talented 4 = Migrant Education 5 = Title I English Proficiency level of proficiency with English Numerals zero through 6 0 = unknown 1 = Fully/Only 2 = English Proficient 3 = English Student Level 1 - Beginning/Pre-production 4 = English Student Level 2 - Beginning/Production 5 = English Student Level 3 - Intermediate 6 = English Student Level 4 - Advanced Special Conditions special conditions Numerals zero through 13 and multiples separated by a pipe ( | ) 0 = None of the below 1 = Autism 2 = Visual Impairment 3 = Deaf - Blindness 4 = Developmental Delay 5 = Hearing Impairment 6 = Orthopedic Impairment 7 = Multiple Disabilities 8 = Mental Retardation 9 = Emotional Disturbance 10 = Speech and Language Disorders 11 = Specific Learning Disabilities 12 = Other Health Care Needs 13 = Traumatic Brain Injury Economic Status economic status Numerals zero through 4 0 = unknown 1 = No - NOT economically disadvantaged 2 = Eligible for free lunch program 3 = Eligible for reduced price lunch program 4 = Economically disadvantaged by other criteria School current school Must match an institution PID value in MDR PID table and is mandatory for district-level import only   Activate Indicator that this Record should be set to Active or Inactive Accepted values are A to activate the Teacher/Student/Roster or I to make the Teacher/Student/Roster inactive   Update flag to indicate the information in this spreadsheet should overwrite any existing information "Y"if updating an existing user account when creating new accounts it is not a required field     Notes: Red text indicates a required field The header row is required with the correct amount of columns for import, but the field names in the header row are not static and can be changed. The position of the data though, cannot. NOTE: When you save this file, you must save it as a .csv (comma delimited) file Perform a final review of the import file using Notepad for Windows and Text Edit for Macs When updating student accounts the username is a required field.

Copyright © by Holt, Rinehart and Winston . All Rights Reserved. Terms of use . Credits . Contact Us . Privacy Policy .