How to Import a Rubric from Excel into Moodle

Using rubrics in Moodle can streamline grading and provide clear assessment criteria for students. This guide walks you through importing a rubric from an Excel spreadsheet into Moodle using the Moodle Rubric Importer extension. Additionally, we’ll explore how AI can help you generate rubrics efficiently.

Watch the Tutorial

Step-by-Step Guide

Step 1: Prepare Your Rubric in Excel

  1. Open Microsoft Excel (or Google Sheets) and create a rubric.

  2. Format the rubric using the following structure:

    • Column A: Criteria titles (e.g., Clarity, Depth, Organization)

    • Columns B, C, D, etc.: Achievement levels (e.g., Excellent, Good, Fair, Poor)

    • Rows: Detailed descriptions for each criterion and level

    • Numeric Scores: Place a numerical value below each level

  3. Ensure all rows and columns are properly merged to align with the required format.

  4. Save the file as a .CSV or .XLSX format.

Step 2: Install the Moodle Rubric Importer

  1. Open Google Chrome and search for Moodle Rubric Importer (find it here).

  2. Click Add to Chrome and install the extension.

  3. Restart your browser to apply the changes.

Step 3: Import the Rubric into Moodle

  1. Log into Moodle and navigate to your assignment.

  2. Click Advanced Grading and select Rubric.

  3. Choose Import from Spreadsheet.

  4. Upload your Excel rubric file.

  5. Verify that the criteria and scores are correctly mapped.

  6. Click Save and Use this Rubric.

Bonus: Using AI to Generate Rubrics

If you want to create rubrics faster, consider using AI tools like:

  • ChatGPT: Prompt it with rubric criteria, and it will generate structured content.

  • Google Gemini or Copilot: Generate detailed assessment rubrics with customizable grading levels.

  • Moodle AI Plugins: Some AI-powered plugins can automate rubric creation.

How to Use AI for Rubrics

  1. Input your grading criteria into an AI tool.

  2. Let AI generate structured rubric descriptions and scoring levels.

  3. Copy and paste the AI-generated rubric into Excel.

  4. Follow the import steps above to upload it into Moodle.

Conclusion

Importing a rubric into Moodle from Excel is an easy way to enhance grading efficiency. By using AI as an additional tool, educators can automate rubric creation, saving time while maintaining grading accuracy. Try these steps today and improve your assessment workflow!

100% helpful - 1 review
Print Article