Copy Summary Faculty Class List:

• Log in to Banner for Faculty
• Navigate to the correct Summary Class List
• Click and drag in the margin to select the table contents
• Edit menu: Copy
  [Ctrl C/C]

Paste list into Excel:

• Open Excel
• Click on cell A1 of a blank spreadsheet
• Edit menu:
  Paste Special:
  Select Text, Click OK

Convert list into columns:

• With column A selected
• Data menu: Text to Columns
•    Select delimited:
     Click Next

• Select space:
• Click Finish
  (text should separate into individual columns)

Transfer to gradebook:

• Select the first two columns
• Edit menu: Copy
  [Ctrl C/C]
• Select the first cell in the Gradebook on the Scores sheet
• Edit menu: Paste
  [Ctrl V/V]