After importing data, you can begin selecting assignments for each course.
In your Khan2Canvas spreadsheet click on the sheet for one of your courses.
Each column correlates to one assignment. The Green dropdown is for Khan Academy assignments and the Red dropdown is for Canvas assignments.
After selecting a Khan Academy and Canvas assignment, student scores will appear. If a student has not attempted an assignment, an M will appear for their score. Otherwise, their score in Khan Academy scaled to the points the Canvas assignment is worth will appear.
You can also specify settings for individual assignments for individual students’ scores for a given assignment.
Assignment Settings
Individual assignment settings are by default blank and will use the default Grading settings you chose during setup (you can adjust these in the Settings sheet).
Changing the individual assignment settings will only change the defaults for that particular assignment. You can always remove a setting by selecting the field and hitting the Delete key on your keyboard.
- Send: This is used to select the assignment for its scores to be sent if you don’t want every assignment to be sent to Canvas. This is not required to check when sending scores.
- Zero Scores: Choosing a zero scores option for an assignment will override the defaults.
- Yes: Zero scores are allowed. If a student receives a zero on the assignment in Khan Academy, the will receive a score of zero in the spreadsheet and subsequently in Canvas as well.
- No: Zero scores are not allowed. If a student receives a zero on the assignment in Khan Academy, it will be treated as though the assignment is missing for the student and will be handled according to how the Missing setting is configured.
- Missing Scores: Choosing a missing scores option for an assignment will override the defaults.
- Missing: The assignment will be marked as missing in the spreadsheet for the student. When sending scores to Canvas, the assignment will be marked as missing in Canvas if the due date for the Canvas assignment has already passed. Otherwise the student’s score will left blank in Canvas.
- Zero: The student will be given a zero for the assignment.
- No Score: The student will be given no score in Canvas. Their grade for the assignment will be blank.
- Scoring: Choosing a scoring option for an assignment will override the defaults.
- Best Score: The best score the student achieved on Khan Academy, regardless of due date, will be used.
- Due Date: The best score the student achieved by the due date on Khan Academy will be used.
- Completion: The student will receive full points if they have completed an attempt on the assignment on Khan Academy (regardless of due date).
- EC Points: A numeric value that will override the Canvas assignments points in the spreadsheet. This is useful for when an assignment is extra credit and therefore worth 0 points in Canvas. The amount of points specified here will determine how many points the spreadsheet will assign to students for the assignment.
Student Score Options
Next to each students score for an individual assignment is a dropdown that can be used to override their calculated score. You can always remove an option by selecting the field and hitting the Delete key on your keyboard.
- Ignore: Their score will be ignored when sending scores to Canvas. Any score that may already be present in Canvas will not be affected.
- Zero: The student is given a zero (or whatever the Minimum Score was set to).
- Excused: The student’s score will be marked as excused in Canvas.
- Missing: The student’s score will be marked as missing in Canvas (note that assignments are only marked as missing if the current date is past the Canvas assignment due date).
- No Score: The student is given no score. In Canvas their score will appear blank.