The following instructions will apply to CSV files used to manage users in all four of our products:
Gizmos
Frax
Reflex
Science4Us
This will allow for adding multiple students across multiple grades or promoting preexisting students in your school roster:
To import students, you will need a comma-delimited (CSV) file. Many student information systems and spreadsheet applications can export data in this format.
To add students as an administrator:
On the Account Home page, select Students
Scroll down below the student list
Select Add Students
Select Import Students from File
Select Download Sample File.
Please see the image below on where to find this template and formatting instructions.
Preparing Your CSV File for Import
The first row of the file should contain the column names; the subsequent rows contain the student information that match the column names. Delete the sample student data and replace it with your own data. Once complete, save the file as a CSV file.
Required column names: FirstName, LastName, StudentID, and GradeLevel
Optional column names: MiddleName, Language, Password, Gender, LimitedEnglishProficiency, Ethnicity, EconomicallyDisadvantaged, and SpecialEdStatus
All student IDs must be unique. We recommend using the district-provided student ID to promote consistency across all schools and classes within a district.
For the LimitedEnglishProficiency, EconomicallyDisadvantaged, and SpecialEdStatus columns, the required data is: Yes or No.
Ethnicity is indicated by a code number:
11 (Hispanic/Latino)
12 (American Indian/Alaska Native)
13 (Asian)
14 (Black/African American)
15 (Native Hawaiian, Other Pacific Islander)
16 (White),
17 (Two or more races), and is optional
Once your file is ready, log in to your account:
Creating Student Accounts Using a CSV File:
1. Select the school from the drop-down menu at the top of the page if needed.
2. After creating your .CSV file, select Students on the Account Home page.
3. Select Import Students at the bottom left of the page.
4. Drag and drop or click to select the completed CSV file.
5. Review the changes and, if correct, select Import.
6. The students will then appear in a list from which teachers can choose to add to classes.
*Please note, If you are viewing your CSV in Excel and your studentIDs include leading zeros, Excel may remove them.
*Please note that student names cannot exceed 30 characters in length in their first or last name. Doing so will result in an import failure.
*Please delete unused columns, while there are only four required columns, blank columns can cause errors.
Suggested Articles: