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 Class Roster Sheets to Microsoft Excel

Want Your Roster Sheet in Excel?

There are two ways to get your roll sheet into Microsoft Excel. See the steps below for options.

From myGate:

  1. Log in to myGate and click on the Teaching/Advising tab.
  2. Click on the classlist icon next to the desired course.    The roster for the course should be visible.
  3. Using your mouse, click to the left of the first student name in front of the number 1. Drag your mouse while holding down the left mouse button all the way to the bottom-right of the last student name.
  4. Release the mouse button and you should see the selected student information. 
  5. Right-click on the select area and select Copy.
  6. Open Microsoft Excel.
  7. 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.
  10. To remove email icon images from your sheet later, click on the Page Layout tab and select Selection Pane.
  11. A new window will appear. Select Hide All at the bottom of the pane.

For a video version of these instructions, click here.

** The above instructions target Microsoft Excel 2007. If you have an older version or need additional help please contact the Service Desk at 270-809-2346.

From Canvas:

All courses are automatically created for all instructors.  Students are populated into the courses every hour.  To download a list of students from your course, follow these instructions.  Downloading the gradebook will give you an excel compatible listing of your students.  http://guides.instructure.com/s/2204/m/4152/l/55012-how-do-i-download-scores-from-the-gradebook

Modified 8/18/2015
Article ID: 611