The 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 MAUI in ICON integration to transfer grades, you will want to post all assignments in the gradebook before sending grades to MAUI.
    • This ensures that the grades you see on the page in ICON will be the same grades that are transferred to MAUI.  
  • 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).
    Navigation Menu
  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 "MAUI in ICON" to your course Navigation Menu

By default, the MAUI in ICON integration should already be in your course in the Navigation Menu.  If you do not see it in your Navigation Menu, please visit the following link for instructions on how to add it: https://community.canvaslms.com/docs/DOC-12933-415257079

Navigation Menu

 

Go to Top

Step 4: Exporting Grades

Important! Post all grades for assignments in your course before sending grades from ICON to MAUI.

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

 

Export grades from ICON to MAUI using the MAUI in ICON 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 MAUI in ICON.
  3. Enter your hawkid and password.
  4. Click Login.
    MAUI Integration
  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 "MAUI in ICON" 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.
    Grade Submission Types
  8. Your grades will be placed in the processing queue.

     
    Import Error


    Successful Import

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.
    Section Selection
  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 posted assignments (excludes hidden assignments).
         B) Unposted Current Grade: Score based on only submitted assignments and hidden assignments (excludes unsubmitted assignments).
         C) Final Grade: Overall score including unsubmitted assignments as zero (excludes hidden assignments).
         D) Unposted Final Grade: Overall score including unsubmitted assignments as zero and hidden assignments (if any).
  4. Log into MAUI.
  5. Click on My Courses.
  6. Click on the Edit link under the Final List column.
  7. Click Upload Final Grades
  8. Click Browse and select the file from your computer.
  9. Click Show Sample data. The next page will show a sample of the data that was imported from the file.
  10. 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.
  11. Click Import File to import the grades from the csv file into MAUI.
  12. 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.

It's possible to create your own CSV file and upload grades to MAUI. 

Visit https://registrar.uiowa.edu/grade-upload for more information on how to do this. 

​​​​​​​

Go to Top