Entering grades from PEAR into LEARN

Part One

  1. Navigate to the desired project. 
  2. Select the Grades tab. Select the Grades tab
  3. From the Project Stage drop-down list, select the project stages whose grades you want to import into LEARN. 
  4. Select/highlight the table and copy the selection. Image of grades table highlighted and copied
  5. Open a blank Excel spreadsheet/worksheet. 
  6. In the Excel worksheet, select the upper-left corner of the worksheet area (the triangle), the whole worksheet should now be selected can also select Ctrl + A, and paste the table. Image of the whole excel worksheet highlighted

    Note: If you get a warning saying "The data you're pasting isn't the same size as your selection. Do you want to paste anyway?" Click OK.
  7. Paste the copied table into cell A1. Image of data copied from PEAR pasted into Excel spreadsheet
  8. Cut and paste columns C and D into columns A and B. Column A should now contain student's @uwaterloo.ca emails and column B should contain their raw score. Image of users email in column A and raw scores in column B
  9. Click Crtl+F or Cmd + F, and select the Replace tab. Enter @uwaterloo.ca in the Find what field, leave the Replace with field blank and click Replace All. Image of @uwaterloo.ca being removed using Find and Replace
  10. Leave this file open as you will need to paste information into it later. 

Part Two 

  1. Open the associated LEARN course. 
  2. Select the Grades hyperlink from the course navigation bar in your LEARN course and select Enter Grades from the top panel of the gradebook.
  3. Select Export Grades. 
  4. Confirm that “username” is selected as the key field and “Points grade” is selected for Grade Values.
  5. Choose the grade item(s) into which the grades will be imported from the list of grade items.
  6. Click on the Export to CSV button.
  7. Click on the filename and select Open.
  8. Leave this file open as you will be copying and pasting information from this file into the one you first created. 

Part Three 

  1. Open your file from Part two and copy the column headers (username, Grade Item Name, End-of-Line Indicator).Image of the headers from the second workbook pasted
     
  2. Open your file from Part one and paste the column headers. 
  3. Populate each row in The End-of-Line Indicator column with a number sign (hash mark). Image of a hash mark symbol in populated in all of the row of column C

    Note:  the easiest way to do this is to add a number sign in cell C2, then hold down the mouse button to select the remaining rows in column C until you arrive at the last student then press CTRL-D to autofill.
  4. Save the worksheet as a .CSV file. 

Part Four 

  1. Select the Grades hyperlink from the course navigation bar in your LEARN course and select Enter Grades from the upper panel.
  2. Select Import Grades and browse for your CSV file from Step three.
  3. Select Next to finish the process.