Import Rubrics from Excel
Import rubrics from Excel is the ability to upload a .xls or .xslx file to the Turnitin rubric/form manager in order to create a new rubric.
What rules must the imported rubric follow?
The Excel file must follow these rules:
- The file must be a .xls or .xlsx file
- Only one rubric can be uploaded per Excel file
- The rubric in the spreadsheet must have the scales of the rubric as its first row
- The rubric in the spreadsheet must have the criteria of the rubric as its first column
- If included, criteria descriptions should be in the same cells as the criteria titles separated by a line break
- Descriptors for the body of the rubric can be included
- Criteria titles must be 13 characters or less
- Grading formulas will not be imported with the Excel file
- Numerical values cannot be imported. If you would like to use numerical values, add them to the rubric after import using the rubric/form manager.
An example template for constructing your rubric in Excel is available from the import rubric screen.
Where can the rubric be imported?
The rubric can be imported from the import rubric screen in the Turnitin Rubric/Form Manager. The link to the import screen is found under the icon that looks like a rectangle with an escaping arrow in the upper right of the rubric/form manager.
On this screen rubrics can be imported from Excel or rubrics that were previously exported from Turnitin (as .rbc files) can be imported.
What will the imported rubric look like?
Clicking "View" from any imported rubric will open that rubric in the rubric/form manager.
Closing the import screen after completing an import will open the last rubric imported.
The rubric will appear with the file name as the rubric title.
The rubric will not have any scoring values when you first import it. You may add scoring using the rubric/form manager:
The rubric type can be changed using the "RUBRIC SCORING" buttons at the bottom center of the rubric/form manager. Use the "%" button for standard rubrics (with scale values as points and criteria values as percentages). The "pen-and-notepad" button is for custom rubrics where each cell inside the rubric gets a value. Leave the rubric scoring setting as "0" for qualitative or non-scoring rubrics.