Rescaling grades in a csv file

Suppose you have several assignments each worth a different amount. In order to get Canvas to weigh them all equally, you will have to rescale each one. The first step is to open your csv file containing scores in a spreadsheet editor, such as LibreOffice Calc or Microsoft Excel.

A csv file containing several unscaled assignments.

We can delete row 8, which does not correspond to a student. We can also delete columns K and L.
- To delete a row in LibreOffice Calc:
  1. Click on the row number.
  2. Select Sheet > Delete Rows.
- To delete a row in Microsoft Excel:
  1. Click on the row number.
  2. Select Home > Insert > Delete Sheet Rows.
- Deleting columns is similar.
Extraneous rows and columns removed.
Now we'll rescale column G.
1. In cell K8, enter the formula =G8/G$6*100.
  
  Formula for rescaling column G is in cell K8.
2. Select cell K8 and all the cells below it, all the way down to the last student row.
  
  Cells in column K selected.
3. In LibreOffice Calc, select Data > Fill Cells > Down.
  In Microsoft Excel, select Home > Fill > Down.
  
  Scores in column G have been rescaled.
4. In LibreOffice Calc, select Data > Fill Cells > Down.
  In Microsoft Excel, select Home > Fill > Down.
  
  Scores in column G have been rescaled.
Now we'll rescale the other columns.
1. In this example, we want to rescale three more columns, so we'll select all the rescaled scores in column K and then three more empty columns to the right.
  
  Three empty columns selected.
2. In LibreOffice Calc, select Data > Fill Cells > Right.
  In Microsoft Excel, select Home > Fill > Right.
  
  Scores in columns G-J have been rescaled.
Finally, we need to save our rescaled scores as data, not formulas.
1. Select all the rescaled scores.
  
  All rescaled scores selected.
2. In LibreOffice Calc, select Edit > Cut.
  In Microsoft Excel, select Home > Cut.
  
  Rescaled scores have been cut to clipboard.
3. Select all the original (unscaled) scores.
  
  All unscaled scores selected.
4. In LibreOffice Calc, select Edit > Paste Special. Then uncheck "Paste all" and check only "Numbers".
  
  The "paste special" window.
  
  In Microsoft Excel, select Home > Paste > Paste Values. Then select "Values".
Now that we're done, it would be a good idea to change each total to 100.

Totals are now 100.