ArticlesArticles Most Popular ArticlesMost Popular Articles Most Helpful ArticlesMost Helpful Articles Submit A QuestionSubmit A Question
RSS Feeds
DrillDown Icon Home
DrillDown Icon Welcome
DrillDown Icon Administrative / Procedures
DrillDown Icon Banner 9 Training Materials
DrillDown Icon Canvas
DrillDown Icon Forms
DrillDown Icon Listservs
DrillDown Icon Mobile Devices
DrillDown Icon myGate
DrillDown Icon Faculty & Staff
DrillDown Icon Admin Tools/Banner
DrillDown Icon Employee
DrillDown Icon Money
DrillDown Icon Teaching/Advising
DrillDown Icon Copying Class Roster Sheets to Microsoft Excel
DrillDown Icon Copying Grades from myGate to Microsoft Excel
DrillDown Icon Course Exception Form (Substitution) - Undergraduate
DrillDown Icon Creating an Email List from a Class Roster
DrillDown Icon Printing Class Roster Sheets
DrillDown Icon Printing Grades from myGate
DrillDown Icon Releasing Advisor Holds
DrillDown Icon Submitting Grades and Incomplete Grades
DrillDown Icon University Studies Course Substitution-Undergraduate
DrillDown Icon Using Consent to Release Information
DrillDown Icon Viewing More Rows in myGate Channels
DrillDown Icon Change Your Mailing Address or Telephone Number
DrillDown Icon NSF Charges for Online Check Payments
DrillDown Icon Sign-Up for Emergency Mobile Alerts
DrillDown Icon Students
DrillDown Icon Account Management Procedures
DrillDown Icon Change Your Mailing Address or Telephone Number
DrillDown Icon Change Your myGate Password
DrillDown Icon Class Schedule and Course Catalog
DrillDown Icon Consolidated Credentials
DrillDown Icon Log in to myGate
DrillDown Icon Maintenance Windows for MSU Systems
DrillDown Icon Mobile Alerts FAQ
DrillDown Icon myGate Authorized Users FAQ
DrillDown Icon Password Help
DrillDown Icon Register Your Vehicle for Parking
DrillDown Icon Request a Username Change
DrillDown Icon Temporary Parking Permit Requests
DrillDown Icon Network / Internet Access
DrillDown Icon Other
DrillDown Icon Police Dept/Emergency Management
DrillDown Icon RacerMail / Google Apps
DrillDown Icon University Libraries
  Email This ArticlePrint PreviewPrint Preview Current Article/Category with all Sub-Articles/Sub-Categories
 
Copying Grades from myGate to Microsoft Excel
This is a tricky process and can be affected by various browser settings.  If you have problems, contact the Service Desk at 270-809-2346.  Make sure you indicate you are trying to copy grades from myGate to Excel.

Instructions to Copy to Excel:
*If you haven't submitted grades yet, see this article, Submitting Grades in myGate.

  1. Log in myGate
  2. Select the Teaching/Advising tab
  3. Click on the classlist icon next to the desired course.    The roster for the course should be visible with midterm and/or final grades.
  4. Click to the left of the 1 in front of the first student name and highlight each row by holding down the left mouse button and dragging toward the bottom-right of the screen.
  5. Release the mouse button and you should see the selected student information. 
  6. Right-click on the select area and select Copy.
  7. Open Microsoft Excel.  Click in the desired cell (most likely A1 in the top-left corner of the spreadsheet)
  8. From the Home tab, click on the Paste icon.  (Firefox users should choose the Paste drop-down and select Paste Special, then Unicode Text.)
  9. Click OK.

*To remove email icon images from your sheet later, click on the Page Layout tab and select Selection Pane.A new window will appear. Select Hide All at the bottom of the pane.

**Some browsers format the grade sheet differently.  Best results were found using Internet Explorer and Chrome.



Modified 7/24/2014
Article ID: 615