Student Course Data Import Fields
Instructions
Review the details of student course data fields for import into Naviance via a manual data import or automated import with SFTP.
- Note the required data fields and determine the recommended and optional fields you want to import for students.
- Download the corresponding course catalog import template from the Naviance Knowledge Base in the PowerSchool Community. Select PowerSchool Community from the Get Help menu in Naviance to access the Community.
- Prepare the data to import using the template as a guide.
- Import the data using the selected import method.
Student Course Data Import Fields
| Data Field | Requirement | Example | Information |
|---|---|---|---|
| Course ID | Required | M460 | The local course number for the course; can include a period or forward slash. If your Student Information System (SIS) has separate fields or tables for current and past courses, you must merge those fields for import into Naviance. If importing transfer courses for a student, ensure the course ID number already exists in Naviance. If not, you must add those courses to your course catalog before importing student course data. |
| Grade Level Taken | Required | 10 | The student's grade level upon completion of the course. Use a digit to indicate the grade.
If you include courses from previous years, ensure those courses are part of your Naviance course catalog. If not, you should import those courses before importing the student course data.
|
| Term | Recommended | S1 | The term is critical when importing multiple records for the same course in the same grade level for a given student, such as one record per semester for two semesters of Biology in grade 11 for student 82457. |
| Course Status | Required | Completed | The status must be Completed or In Progress. |
| Course Name | Optional | Biology | The descriptive course name or title that is presented to students when browsing the Naviance course catalog. |
| Teacher | Optional | Smith | The name of the course instructor. |
| Credits Attempted | Recommended | 0.5 | The numerical value indicating the credits attempted for the course; Used to calculate credit deficiency. |
| Credits Earned | Recommended | 0.5 | The numerical value indicating the credits awarded for completion of the course; can include decimal points.
Students' plans of study will not populate with credits earned for previously completed courses, including transfer credits, unless you included them in your Naviance course catalog and the plan of study.
|
| Letter Grade | Optional | B+ | The letter grade awarded for completion of the course. |
| Score | Optional | 88 | The number grade awarded for completion of the course. |
