After importing data, you can begin selecting assignments for each course.
In your ALEKS2Canvas Gradebook spreadsheet click on the sheet for one of your courses.
Each column correlates to one assignment. The Blue dropdown is for ALEKS assignments and the Red dropdown is for Canvas assignments.
Note that assignment names in ALEKS and Canvas do not need to be the same! The whole point of selecting an ALEKS and Canvas assignment here it to tell ALEKS2Canvas which assignments should be connected.
After selecting an ALEKS 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 ALEKS 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 ALEKS, 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 ALEKS, 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.
- Bonus Points: A numeric value that indicates the bonus points available for the assignment. Bonus points can be given to a student using the Student Score Options below.
- 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.
- Bonus: The student will be given the bonus points specified in the assignment’s settings. Bonus points are added to the ALEKS score before it is scaled to the Canvas assignment points.
- 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.