Skip to main content

Search

Welcome to the Help Center

Import Students File

Kaitlin Antelmi
  • Updated
  • ~ minute read

IN THIS ARTICLE

1. Access Import File Template (Import Students tab)

2. File Format (Required Columns)

3. Add Custom Fields (Demographic Data)

4. Run Students Import

 

The Import Students File is created to add students to the Student tab list, add students to a class, or add custom field data to students if a Combined Import File has already been imported.

 

 

Access Import File Template (Import Students tab)

From Admin Mode, select the Students OR More > Imports tab to access and click a blue New button. From the drop-down menu, select Import Students. From the Import Students pop-up window, click the linked import file template text to make a copy of the Import File Template as a Google Sheet.

Import pop-up window - Import FIle Template link.png

To use the Import Students tab, click the drop-down arrow in the tab > Copy to > New spreadsheet, to copy only the Import Students tab to a new sheet before populating your data OR Download the tab as a .CSV file after you have populated your data. 

Import Students File Template.png

Make a copy of the Import File Template (Import Students tab) as a Google Sheet, or create your own file using the Import Students File Format section below.

 

 

File Format (Required Columns)

Column Header Description
School_ID *OPTIONAL - School names are already pre-loaded but the School_ID needs to be edited by a Gradient Leader. The School_ID is a label used in the import file to associate each row of data to a school (School IDs may be a numeric code from your SIS or could be an acronym for a school).
Student_First_Name

List student's first name  

Tip! Whatever is listed in this field will be required to be typed by students in order to log in to the Student Portal (if SSO isn't in use).
Student_Last_Name

List student's last name.

Tip! Whatever is listed in this field will be required to be typed by students in order to log in to the Student Portal (if SSO isn't in use).
Student_Middle_Name *OPTIONAL - List student's middle name  
Student_ID List student's Unique ID, likely coming from your SIS. Student IDs can not be recycled from year to year.
GradeCam_ID *OPTIONAL - Student ID for bubbling onto forms. This can be a shorter version of the Student ID or alternate #. You can map this field back to Student ID.
Student_Email *OPTIONAL - A student email can be added but is only visible to Gradient Leaders within Admin Mode.
Grade_Level

Grade level is a NEW required field as of April 2023. This field allows teachers and leaders to analyze reports using this custom field.

Note: *OPTIONAL = Optional column to populate with data, column header must be in the file.

 

 

Add Custom Fields (Demographic Data)

A Gradient Leader can first create Custom Fields, such as Gender, Ethnicity, Achievement Score, At-Risk Level, etc., and then add additional columns to the right of the Import File Template (Import Students tab) required columns to match data for custom fields with students. Remember to use column headers that match the name of the custom fields that were first created in Gradient. Custom Field columns may also be added in the Combined Import File.

Steps to add Custom Fields:

  1. Create Custom Fields in Gradient.
  2. Add columns to the right of the required columns of the Import Students tab of the Import File Template. Make sure the column headers match the custom field names in Gradient. 
  3. Add the custom field data to the applicable students in the file.  
  4. Run a Student Import.

 

 

Run Students Import

There are 2 places to import the Import Students File:

To add students to the Student tab list or import custom fields:

To add students to a Class:

 
The feature(s) mentioned in this article are only available to Gradient for Schools & Districts subscribers. Please contact sales@gradecam.com to upgrade your subscription for this feature.
 
 
 

Related to

Comments

0 comments

Article is closed for comments.