Academic Advising: Scheduling Matrix

Scheduling Matrix

To look at the scheduling Matrix:

  • Open Excel
  • Go to File on the menu bar
  • Click Open
  • The window that comes up gives you a pull down menu option that says "Look in: ".
  • Click on the down arrow... Choose the I drive.
  • Double click on ‘Banner Data"
  • Double click on "Scheduling Matrix"
  • Double Click on the semester you want to view.


To create a shortcut for the Scheduling Matrix on your desktop:

  • Double click on My Computer
  • Double click on I: drive
  • Double click on "Banner Data"
  • Double click on "Scheduling Matrix"
  • Right click and drag the semester matrix you want.
  • Once you get to the desktop let go
  • You will be given a menu...choose "create shortcut"


To filter data on the Matrix:

  • Go to Data on the menu bar
  • Choose filter then auto filter
  • Down arrows will appear on each of the column headings
  • Choose the column heading you want to filter (look through)
  • Click the data that you are looking for (i.e. course name, instructor, etc. )


Excel will show you only those classes that you asked for

Go to Sidebar Content