Column Statistics

Scenario: The Head of Department asks for statistics of your latest assessment.

Item statistics give insight to course members' overall performance on a graded content. Now, instructors can select a column in the gradebook to access summary statistics for any graded item. The statistics page displays key metrics such as:

• Minimum and maximum value
• Range
• Average
• Median
• Standard deviation
• Variance

The number of submissions requiring grading and the distribution of grades also displays.

Follow these steps to access the statistics:

1. Click on Gradebook.

2. Click on Grades.

3. Click on the assessment's name to display the menu options.

4. Click on Statistics.
   

5. This provides a summary of the assessment's grade statistics. To print this, right click inside the window and choose print.
   

Statistics on Progress Mark, Add Calculation or Add Total Calculation

1. To set up the Progress Mark and any other calculations make sure these are 100% correct and final.
2. Then create an item for each of these calculations in your Gradebook, give it the same name but put something in brackets like (Excel) so that you can differentiate. - Follow this link for steps on how to create it.
3. Download the Gradebook - Select all items.
4. Open it in Excel.
5. Paste the Progress Mark items into your self-created item, so just copy and paste the whole column except for the column heading in row 1.
6. Save and close the Excel file (DO NOT CLICK ON SAVE AS).
7. Go back to clickUP and upload the Excel file.
8. Go to that item you created in the Gradable Items view, click on the ellipsis (three dots), and select statistics.

Credit to Blackboard Help