Steps to export grades from MyLab & Mastering
- Sign into Pearson's portal to see My Courses and click the Active Member Sections hyperlink, enclosed in red, just above the gear icon in your Coordinator Course card.
- The next screen displays all active sections tied to your Coordinator Course - this example has 2 subsidiary sections. Click into one section; you will follow the same steps for each section on the Member Sections page shown below.
- Locate Manage gradebook in the page's main content area and click the link. Note that your screen may look slightly different than the image below.
- Click Export Data from the horizontal menu toward the top of the Gradebook.
- Click the drop-down menu to identify the data for export. Once you select a Data Set (e.g., homework, quizzes, etc.) you will have the opportunity to specify additional options unique to the data selected. We recommend exporting percentage scores as percents so you don't need to edit score data before importing into Canvas.
- Click the blue Export Data button and save the resulting .csv file to your computer.
- Repeat these steps for as many Pearson data sets (i.e., homework, quizzes, etc.) are used in your course.
- Repeat steps 1 through 7 for each Active Member Section affiliated with your Coordinator Course.
Steps to import grades to Canvas
- Enter the Canvas course (corresponding to the Active Member Section whose grade data you just exported) and navigate to Grades.
- Export the gradebook to ensure you have a file template that Canvas will accept.
- Open the resulting file in Excel and delete all columns except
- Student (Column A)
- ID (Column B)
- SIS User ID (Column C)
- SIS Login ID (Column D)
- Section (Column E)
- Save, but do not close, the file. Be sure to leave .csv as the file extension.
- Use Excel to open the .csv data set(s) exported from Pearson.
- Click the capital letter above each column containing grade data to select the entire column and copy the column.
- Drag the cursor across to bulk-select (as many columns as are grade data).
- Return to the Canvas gradebook export and paste the data into the first available column, typically column F.
- You may need to manipulate the spreadsheet as you copy/paste to ensure that data from Pearson's export is copied into the correct cell.
- Once you have copied the data exported from Pearson and pasted into the Canvas gradebook export file, save the file. Be sure to retain the .csv file extension.
- Navigate back to Grades, within Canvas, and click Import.
- Follow the on-screen prompts to locate and upload the file you saved in step 8. Canvas will recognize that your file includes assignments that do not yet exist (within Canvas) and prompt you accordingly. Follow the on-screen prompts as you tell Canvas to create new assignments and assign point values while grades import. The time it takes Canvas to import grades is contingent upon the size of your file. You will not receive a message when the grade import process completes so we recommend returning to the Canvas gradebook 15 minutes after the process began.
You can consider arranging your newly created assignments, following import, in assignment groups. Learn more about adding assignment groups to your course in this Canvas Guide.
Related Self Help Guides
Adding Open Learning Initiative (OLI) Content to your Canvas Course — SUNY has a partnership with Lumen Learning and Carnegie Mellon University’s Open Learning Initiative (OLI) that provides access to courses at no cost for all SUNY campuses and students. Course adoption is as easy as filling out a request form in our Ready-to-Adopt catalog at oer.suny.edu.
When you adopt an OER course, it can be easily integrated into a Canvas module.
TopHat Canvas Integration & Grades Sync — Linking Top Hat and Canvas together gives you a ton of amazing features! Automagically sync grades, and keep your student roster up-to-date.
Registering and Troubleshooting the Google Drive LTI — Canvas has improved its integration with Google Apps making it easier for instructors to include collaborations, content sharing, engaging course content, and assignment distribution directly within Canvas. The integration also makes it easy for students to collaborate with instructors and fellow students on individual or group assignments.
3rd Party (External Apps) Integration Notes — This self help document is a collection of informations about the integrations installed for all courses. You can link to them through course modules and create assignments for assessment tools
MyLab & Mastering Coordinator courses and Canvas gradebook sync — If you are using a Coordinator course within Pearson, you must enable the Canvas/MyLab & Mastering integration first. Otherwise, when using Pearson’s Coordinator course with corresponding sections, you will not be able to integrate MyLab & Mastering with Canvas. You can, however, follow the steps detailed below to export grades from MyLab & Mastering and import to the Canvas gradebook.
Still Need Help?
Ask CIT! Email us or submit a request and we'll be happy to assist you.
For tips, tricks, and updates on learning technologies at Geneseo, visit our Educational Technology Chat. To explore Canvas Guides (created by Instructure), visit https://community.canvaslms.com/community/answers/guides/canvas-guide