Gradebook: calculate assignment completion rates

Step 1: Access the Admin Area

Log in to your account.

Navigate to the Admin Area from the main dashboard.

Step 2: Open the Gradebook

Click on Assignments & Gradebook in the menu.

Then select Gradebook from the dropdown.

Step 3: Select the Classes

Choose the relevant classes manually, or

Tick Select all classes if you want to include every class.

Step 4: Set the Date Range

Adjust the date range to cover the period you want to analyze.

Step 5: Download the Student Data

Scroll down to the second table showing all students in the selected classes.

Click the Download button to export the data.

Step 6: Open the CSV File

Open the downloaded file in Excel or another spreadsheet program.

Step 7: Sum the Totals

Scroll to the bottom of the table.

Use the AutoSum function to calculate:

- The total number of assignments set (Column C) - The total number of assignments completed (Column D)

Step 8: Calculate the Completion Rate

In a new cell, divide the total in Column D by the total in Column C:

=D[n]/C[n] (where n is the row number of the totals)

Step 9: Format as a Percentage

Click on the result cell.

Then click the % symbol in the toolbar to format it as a percentage.