Grading Matrix > Managing Grade Matrix Templates

Use the Report Printing module to manage grade matrix templates. Grade matrix templates determine the formatting for grade matrices displayed in an Excel spreadsheet.

Choose to:

Add a grade matrix template.

1. Open a blank Excel template spreadsheet.
   1. Add column and row headers to the spreadsheet to suit your requirements.
   2. Add conditional formatting to selected cells in the spreadsheet to suit you. For example, set up the spreadsheet to so that all cells containing a grade '1' are displayed in green. It is useful if you are familiar with the number of columns and rows which appear in the grade matrix you are generating.
   3. Save the Excel spreadsheet as an .xls file. This is your grade matrix template.
2. Open the Report Printing module, select the Grading Matrix tab:
   
3. Click Manage next to the Template field.
   The Manage Templates window is displayed:
   
4. Click Choose File and select the template that you want to add.
5. Click Upload in the Manage Templates window.
   The template is listed:
   
6. Click Cancel & Close.

Edit a grade matrix template.

1. Open the Report Printing module, select the Grading Matrix tab:
   
2. Click Manage next to the Template field.
   The Manage Templates window is displayed:
   
3. Download and edit the template:
   1. Click  in your selected template to download it.
   2. Open the .xls file.
   3. Edit the conditional formatting in the spreadsheet, as required.
   4. Save the .xls file and close it.
4. Upload the revised template:
   1. Click Choose File in the Manage Templates window and select the template that you want to add.
   2. Click Upload.
      The revised template is listed and ready to use.
5. Click Cancel & Close.

Delete a grade matrix template.

1. Open the Report Printing module, select the Grading Matrix tab:
   
2. Click Manage next to the Template field.
   The Manage Templates window is displayed:
   
3. Click  in your selected template.
   You are prompted that the File deleted successfully.
4. Click Cancel & Close.