FastSuite: Importing Grades from MyCanvas

At semester's end, faculty must input final grades into FastSuite for approval. Follow these simple steps to export grades from MyCanvas and import them into FastSuite.

Export Grades from MyCanvas

1. Go to Grades in your MyCanvas course. Sort your gradebook by section if your course is cross-listed.
2. In Gradebook, select View > Filters > Sections.
3. Expand the All Sections dropdown and choose the first Section to export.
4. Select Actions > Export Current Gradebook View.
5. The system will prepare a .CSV file, which will be saved in your Downloads Folder.

Prepare the File in Excel

1. Open the .csv file. Delete all columns except SIS ID and Unposted Final Score.
2. Delete the Test Student and any blank headers such as the ‘read only line’.
3. Save the file as an Excel Workbook (.xlsx), e.g., “Winter 24 Accounting 1 Section 1”.
4. Repeat these steps for all current semester courses and any other sections of a MyCanvas cross-listed course.

Import Grades into FastSuite

1. Login to MyMohawk and access FastSuite from the Faculty tab.
2. Go to Student Reporting and select student grades then enter grades.
3. From the dropdown list, select the course you wish to import grades into.
4. At the bottom of the page, select Import and browse to the excel file (.xlsx) saved in the previous step.
5. The system will ask which Excel sheet you would like to import. Click Next on this window.
6. Now you need to tell FastSuite which columns in your Excel spreadsheet match which item in the FastSuite grade sheet. Uncheck Letter Grade and change the drop down for the Student and Percent to match the Excel sheet.
7. Once the items are aligned, click Import. When complete you will be brought to a screen that looks like this:
   
8. The system auto-populates both the letter and percentage grade. Take a few moments to make sure the grades are correct before selecting Submit for Approval.