SK Import Student Marks (formerly Import Blended and Transfer Marks)
Contents
Introduction
This interface is used when importing marks from SDS. Note: This functionality is only available at the school level, marks cannot be imported at the District Office.
Import Marks
Follow the list of steps to import the response file.
- On the Start Page, click Special Functions.
- Click Saskatchewan Data Import System, then click Import Student Marks. The Import Student Marks page appears.
- Specify the file to import (the response file to Query_BySchool_StudentCompletedCourses). Click on the Browse button to find the import file.
- Specify the store code to be used for all marks imported. It is recommended that a new store code (e.g. T1) is created for the current school year that is specifically for imported marks. Only store codes for the current year term will be available.
- Specify the types of marks to import. Options include:
- Blended Marks Only. This will pre-select only marks with type=Blended.
- School - All School Marks Only. This will pre-select only marks with type= School
- School - Filtered School Marks (Non-Current School) Only. This will pre-select marks with type=School that are not from the current school.
- Other - Transferred Marks Only. This will pre-select transfer marks only.
- All Marks (Blended, School and Transfer Types). Select this option to import all marks, regardless of type.
- Press the Process button.
- All marks meeting the types of marks to import will be stored temporarily to allow for data validation.
Review: Import Student Marks
Marks from the import file will be validated for import. This transition page allows the user to see any issues with the importing candidates, as well as displaying currently stored grades that match these based on student and course.
Marks are grouped with existing PowerSchool historical grades (matches based on Student and Course) and are displayed as follows:
Column | Source (from PowerSchool) | Source (from Import) | Notes |
Student Name | [Students]Last_Name, [Students]First_Name | Derived from DeptAssignedPersonId | First initials only are shown. Last names are truncated to 25 characters, as required. Only the first record within a group will display the student name. |
SASK Learning # | [Students]State_StudentNumber | DeptAssignedPersonId | Student with matching LIN must exist within PowerSchool for marks to be importable. Only the first record within a group will display the SASK LIN. Learning numbers are imported if the "Import New Learning IDs to Student Number" option is checked; however, if any other student has a Learning ID with a value equal to that of a Learning ID to be imported, the Learning ID is not imported and an error message is displayed. |
Course Number | [StoredGrades]Course_Number | DeptAssignedCourseId | Import file must have numeric value of 900-9999. |
Section ID | [StoredGrades]SectionID | Always 0 | Import sectionID is zero, as there is no matching section. |
Term | Derived from [StoredGrades]TermID | Derived from SchoolYear |
|
Store Code | [StoredGrades]StoreCode | Import parameter |
|
Date Stored | [StoredGrades]DateStored | CourseEndDate |
|
Grade | [StoredGrades]Grade | FinalMark | Import file must have a numeric value. |
Percent | [StoredGrades]Percent | FinalMark | Import file must have a numeric value. |
Credit Earn | [StoredGrades]EarnedCrHrs | CreditsEarned | Import file must be 0, 0.5 or 1. |
Credit Pot | [StoredGrades]PotentialCrHrs | CreditsEarned | Import file must be 0, 0.5 or 1. |
Credit Type | [StoredGrades]Credit_Type | CompletedCourse type | Import type can only be School, Blended or Transfer. |
Grade Level | [StoredGrades]Grade_Level | Derived from DeptAssignedCourseId |
|
School Name | [StoredGrades]School_Name | SchoolName |
|
Action/Status | Always ‘Existing’ | Option or feedback on data validation | If the mark can be imported, a drop down menu will appear, with options for Ignore (default) or Add. “Ignore” will omit this mark from import. “Add” will add the mark to StoredGrades. If there is an issue with the mark (no matching student, no matching course, improper data types, etc.), an error will display and the mark will not be available to import. |
After reviewing the import candidates:
- Select Add for any marks that are to be imported. To exclude marks that do not need to be imported, please select Ignore.
- If there is a problem with any of the data, simply click the Back button and no import will occur. However, if the data is ready to import and the appropriate marks are set to add, press the Submit button.
- Marks are imported to StoredGrades.
Results: Import Student Marks
Once import is complete, a results page displays showing the results of the import.