Importing School Speak student records to Gradelink can be done in just a few clicks. The key to success is ensuring your data is extremely clean and normalized. Like tidying up a room or garage by sorting everything into properly labelled bins, cleaning up data ensures records are easy to retrieve and reporting is accurate.
- Download the import template, a .csv (comma separated value) formatted file.
- Paste your date into the template. Below are the columns and what should go in them.
- Save the template file, and drag it to the Upload area.
- If Student IDs you pasted came from Gradelink rather than another system, check the box "Student IDs are from Gradelink"
- Click Submit
If any errors are detected in your upload, the import gets completely aborted (no records imported) and we'll present a returned .csv file that includes specific error notations.
Field | Examples | Required? | Explanation |
| Old SIS ID | 0012345678 | No | Used for mapping in certain cases |
| First Name | John | Yes | First name of student |
| Middle Name | C. Chapman | No | Middle name of student |
| Last Name | Appleseed | Yes | Last name of student |
| Nick Name | Johnny | No | Nick name of student |
| Grade Level | 5 | Yes | Grade level of student |
| Division | A | No | Sub-division of grade level. |
| Address-Street | 123 Anystreet | No | Home address of student |
| Address-City | Anytown | No | Home city of student |
| Address-State | MA | No | Home state of student |
| Address-ZIP | 99999 99999-9999 | No | Home zip/postal code of student |
| Date of Birth | 07/04/1872 7/4/1872 July 4, 1872 | No | Birth date of student |
| Gender | Male Female | No | Gender of student |
| Home Landline | 123-456-7890 (123)456-7890 | No | Used as Work/Other for Parent/Guardian 1 if P1 - Work/Other not provided |
| Mobile Phone | 123-456-7890 (123)456-7890 | No | Student mobile number. Used as Mobile for Parent/Guardian 1 if P1 - Mobile not provided |
| appleseed@example.com | No | Email address of student | |
| Race | Asian White | No | Race of student |
| Religion / Is Catholic | Yes No | No | Used for NCEA survey |
| Eligible for Free or Reduced Price Lunch (FRL) | Yes No | No | Used for NCEA survey |
| English Language Learner (ELL) | Yes No | No | Used for district-specific reporting purposes |
| Title I Reading (Receiving Title I Reading Services) | Yes No | No | Used for NCEA survey |
| Support Team Education Plan (STEP) | Yes No | No | Used for district-specific reporting purposes |
| P1 - First Name | Nathaniel | No | Parent/Guardian 1 first name |
| P1 - Middle Name | C | No | Parent/Guardian 1 middle name |
| P1 - Last Name | Chapman | No | Parent/Guardian 1 last name |
| P1 - Type | Father | No | Used in determining relationship |
| P1 - Gender | Male | No | Parent/Guardian 1 gender |
| P1 - Mobile Phone | 123-456-7890 (123)456-7890 | No | Parent/Guardian 1 mobile number, if different from Student mobile |
| P1 - Work/Other Phone | 123-456-7890 (123)456-7890 | No | Parent/Guardian 1 work/other number |
| P1 - Email Address | dad@example.com | No | Parent/Guardian 1 email address |
| P1 - Address-Street | 123 Anystreet | No | Parent/Guardian 1 street address |
| P1 - Address-City | Anytown | No | Parent/Guardian 1 city |
| P1 - Address-State | MA | No | Parent/Guardian 1 state |
| P1 - Address-Zip | 99999 | No | Parent/Guardian 1 zip/postal code |
| P2 - First Name | Elizabeth | No | Parent/Guardian 2 first name |
| P2 - Middle Name | R | No | Parent/Guardian 2 middle name |
| P2 - Last Name | Chapman | No | Parent/Guardian 2 last name |
| P2 - Type | Mother | No | Used in determining relationship |
| P2 - Gender | Female | No | Parent/Guardian 2 gender |
| P2 - Mobile Phone | 123-456-7890 (123)456-7890 | No | Parent/Guardian 2 mobile number |
| P2 - Work/Other Phone | 123-456-7890 (123)456-7890 | No | Parent/Guardian 2 work/other number |
| P2 - Email Address | mom@example.com | No | Parent/Guardian 2 email address |
| P2 - Address-Street | 123 Anystreet | No | Parent/Guardian 2 street address |
| P2 - Address-City | Anytown | No | Parent/Guardian 2 city |
| P2 - Address-State | MA | No | Parent/Guardian 2 state |
| P2 - Address-Zip | 99999 | No | Parent/Guardian 2 zip/postal code |