|
⇤ ← Revision 1 as of 2015-12-17 18:08:39
Size: 618
Comment:
|
Size: 731
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 8: | Line 8: |
{{attachment:example_grades.png}} == Example Learn@UW sheet == {{attachment:example_learn_at_uw_1.png}} |
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
