Using Excel's Vlookup function to copy grades into a Learn@UW spreadsheet
The scenario is that you have a spreadsheet in a format specific to your course that includes student IDs, grades, and perhaps other information. One way to submit these grades is to export a grades spreadsheet from Learn@UW, copy the grades from your spreadsheet into the designated column in the Learn@UW spreadsheet, and import that spreadsheet into Learn@UW.
The procedure below shows how to use Excel's Vlookup function to copy the grades from your spreadsheet into the Learn@UW spreadsheet.
Example class grade sheet
Example Learn@UW sheet
