University of Iowa

NOTES:

  • Before you export your grades from ICON to MAUI, you’ll want to review the following steps to ensure your grades are ready to transfer.
  • If you are going to use the ICON/MAUI integration within Canvas you will want to unmute all assignments.
  • If you are not using ICON to record your final grades, and wish to import a file to MAUI, see Creating your own CSV file to import to MAUI.

Contents


Prepare to export grades from ICON to MAUI

Step 1: Permissions in ICON and MAUI

  • You must be a Teacher or TA in your ICON course and have the rights to save grades in MAUI for your course.
  • If you are not listed as the instructor of record on MAUI, you will not be able to transfer the grades.

Go to Top

Step 2: Enable grade scheme for course

  • Make sure grade symbols in your grade scheme are acceptable to MAUI, and that the grade scheme is applied to the Course.
  • Grade symbols are the students actual grade (e.g. A, A-, B+, U, S, R, W). To find out what symbols you can use in your course, log into MAUI as though you were entering grades and see what grade symbols are available from the dropdown menu. The symbols you are using in your ICON grade scheme should all be available from this drop list in MAUI. Otherwise, you will need to create and apply a custom grade scheme in ICON that includes only acceptable symbols.
  • Students who are auditing your course will receive either an R (completed) or W (not completed). This is true across the University.
  • To view the grading symbols used in the College of Liberal Arts, go to the Grading System section of the Academic Handbook.

To enable the grade scheme in ICON:

  1. Click Settings (along the left hand side of the page).
  2. Click Course Details (along the top).
  3. Check the box next to Enable course grading scheme.
  4. NOTE: Users MUST click view grading scheme in order to use the University Letter Grade scheme. The checkbox just enables Canvas' default grading scheme which differs from the UI standard which will result in giving students a slightly lower score.
  5. The next window will show you the currently selected Grade Scheme. If you have not altered this it will be Canvas' default. To change the grading scheme click Select Another Scheme.
  6. Choose a grading scheme.
  7. Click Use This Grading Standard.
  8. Click Done.
  9. Click Update Course Details.

Go to Top

Need to create your own Grading Scheme?

  1. If you wish to create your own grading scheme, follow steps 1-4 above. In step 5, instead of clicking Select Another Scheme, click manage grading selection.
  2. Click Add grading scheme.
  3. Give your grading scheme a name. You can add,remove, rename rows and edit grade ranges.
  4. Click Save. You can edit the grade schemes you created if you realize an error after saving.
  5. Click Update Course Details.

Go to Top

Step 3: Add "Export final grade to MAUI" to your course Navigation Menu

  1. Click Settings (along the left hand side of the page).
  2. Click Navigation (along top).
  3. Scroll down until you find Export final grade to MAUI page.
  4. You can either click, hold and drag the Export final grade to MAUI page to the top section (the active links on your course) OR you can click the dropdown arrow next to the gear icon and click Move.
  5. Once the Export final grade to MAUI page has been moved to the active pages section click Save.

Go to Top

Step 4: Exporting Grades

Unmute all assignments in your course.

You have two options for getting final grades from ICON into MAUI:

 

Export grades from ICON to MAUI using the ICON/MAUI Integration

NOTE: You are unable to export grades for a zero-credit hour course. Grade exports must be matched to credit-earning course/section. We have had reports that Internet Explorer is not accepting users credentials. Trying the same procedure in Google Chrome and Firefox allowed the user to successfully login.

  1. Verify that you have the correct grades and scheme (review the three steps above).
  2. Click Export final grade to MAUI.
  3. Enter your hawkid and password.
  4. Click Login.
  5. You will now be transferred to MAUI
    NOTE: If you encounter the MAUI homepage and not the ICON Grade Import page for this class, please try clicking on "Export final grade to MAUI" again after logging in.
  6. Choose what to Import (Current - ignores ungraded, Final - treats ungraded as zero, Grade book item - choose a column from the GradeBook to import).
  7. Click Import.
  8. Your grades will be placed in the processing queue.

     


Go to Top

To Remove the Test Student from your ICON Grade book:

  1. Click Settings (along the left hand side of the page).
  2. Click Sections (along the top).
  3. Click on your course section.
  4. Scroll through the list of enrolled users until you locate the Student, Test and then click the X to remove it.
    NOTE: Accessing Student View at any time creates the Test Student in the GradeBook.
    ALSO, if you have multiple sections in your course you will need to remove the Test Student from each section.


 

Go to Top

Export grades from ICON to a CSV file, and then import that file to MAUI

  • When using this method to import grades to MAUI from ICON, it is important to be aware of how ICON treats ungraded items.
  • Instructors can set the GradeBook to treat ungraded items as zero, but this only changes your personal view of the GradeBook, but does not change the values of the items. See https://community.canvaslms.com/docs/DOC-10225 for details on how to change your view of the GradeBook to see ungraded items as zero.
  • When exporting to a csv and importing to MAUI, we recommend entering zeros for ungraded assignments.

 

  1. Export your grades from Canvas using the steps at https://community.canvaslms.com/docs/DOC-2849
  2. Once the export has completed you will need to verify that the field "SIS User ID" includes any leading zeros. These numbers are the student's UniversityID numbers and they have to match exactly for the upload to work. To change the column of SIS User ID to be 8 digits in length:

    ​​​A. Select the entire column by right-clicking on the column letter


    B. Choose Format Cells


    C. In the Format Cells Window:
         1. Choose Custom
         2. Click the "0"
         3. In the "Type:" field enter 8 zeros - "00000000"
         4. Click OK
             


    D. The cells should now have 8 digit SIS User ID's


    NOTE: Row 11 is the Test Student which is created and added to your Gradebook after you use/access the Student View feature in ICON for testing functionality within a course.
  3. Delete 3 of the 4 ‘Final Letter Grade’ columns listed within the exported gradebook csv file - they are not needed.
         A) Current Grade: Score based on only submitted assignments and unmuted assignments (excludes muted assignments).
         B) Unposted Current Grade: Score based on only submitted assignments and muted assignments (excludes unsubmitted assignments).
         C) Final Grade: Overall score including unsubmitted assignments as zero (excludes muted assignments).
         D) Unposted Final Grade: Overall score including unsubmitted assignments as zero and muted assignments (if any).
  4. Within the CSV file headings, rename the remaining column from ‘Grades’ to ‘Scores’ (e.g. ‘Final Grade’ to ‘Final Score’).
  5. Log into MAUI.
  6. Click on My Courses.
  7. Click on the Edit link under the Final List column.
  8. Click Upload Final Grades
  9. Click Browse and select the file from your computer.
  10. Click Show Sample data. The next page will show a sample of the data that was imported from the file.
  11. If the grade data looks correct to you, click Validate data. MAUI will test the data in the file to make sure it’s in the right format.
  12. Click Import File to import the grades from the csv file into MAUI.
  13. MAUI will show a message about the grades being successfully processed. Click either Save and Complete Course Later or Submit Course to DEO.
    NOTE: - grades cannot be processed until they have been submitted to the DEO for approval. Meaning, you must click Submit Course to DEO some point before the grade submission deadline.

 

Creating your own CSV file from scratch to import to MAUI.

  1. In Excel (or another program), create a file with a list of HawkIDs and grade values.
  2. The column headings should be Student and Grade, see below for an example:
  3. Save the file as a CSV (comma separated value) file.
  4. Pick up at step 5, Log into MAUI, for the rest of the instructions on how to Export grades from ICON to a CSV file, and then import that file to MAUI.
     

Go to Top