IN THIS ARTICLE
1. Access Import File Template (Import Classes tab)
2. File Format (Required Columns)
The Import Classes File is used to create multiple new classes or update class information.
Note: Every separately scheduled class must have a unique Class ID. Each class section must have a unique Class ID for effective identification. This ensures the flexibility to modify and update various fields associated with classes at any time.
Access Import File Template (Import Classes tab)
From Admin Mode, select the Classes OR More > Imports tab to access and click a blue New button. From the drop-down menu, select Import Classes. From the Import Classes pop-up window, click the linked import file template text to make a copy of the Import File Template as a Google Sheet.
To use the Import Classes tab, click the drop-down arrow in the tab > Copy to > New spreadsheet, to copy only the Import Classes tab to a new sheet before populating your data OR Download the tab as a .CSV file after you have populated your data.
Make a copy of the Import File Template (Import Classes tab) as a Google Sheet, or create your own file using the Import Classes File Format section below.
File Format (Required Columns)
| Column Header | Description |
| Term_ID | Create or Edit Terms in Gradient prior to creating your import file so that you know both the Term_ID to include in the file and have verified the dates for terms that will be associated with the classes being imported. |
| School_ID | 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). |
| Staff_ID |
List staff member's unique ID. Staff IDs can not be recycled from year to year. Tip! We recommend using a unique Staff ID from your SIS (not an email) to enable staff updates (even if last names or email domains change later). |
| Class_Name |
Name of class as you want it displayed for staff within Gradient when they print forms, scan, set up online access, or view reports. Tip! Using staff last name, period, or a section # from your SIS in the Class Name may help teachers differentiate classes. |
| Class_ID |
Class_IDs must be unique per section; otherwise, all students will get lumped into the same class. Use a unique class number (typically section # from your SIS) to identify a class (unique # within a term). Tip! Concatenate the Class ID with the Period number to create a unique ID. For example, put Class ID 12345 and Period #2 together like this: 12345-2. The Class_ID will not show for staff. It is a unique identifier that will appear within Admin Mode and will allow for updates to Class_Name and Class_Period if needed. |
| Class_Period | *OPTIONAL - Included to allow staff to differentiate between classes that may have similar Class Names. This field will display to staff and students. |
| Class_Display_Name | *OPTIONAL - Included to allow staff to differentiate between classes that may have similar Class Names. This field will display to staff and students. |
Note: *OPTIONAL = Optional column to populate with data, column header must be in the file.
Run Classes Import
There are 2 ways to import the Import Classes File:
- From Admin Mode, click the More tab to reveal the drop-down menu > Imports > New button > Import Classes.
- OR reference Add or Edits Classes - Import Classes.
The feature(s) mentioned are only available to Gradient for Schools & Districts subscribers. Please contact sales@gradecam.com to upgrade your subscription.
Comments
0 comments
Article is closed for comments.