Table of contents

The Grades report gives you a sense of how performance is distributed across the class, both by student and by assignment. You can also track how a student compares to the class and their grade performance over time.


By default, your report reflects all students, all assignments, the last 28 days. You can use the filters to customize your report depending on what you want to see. Select  Down chevron button  for all options in each filter.

  • Student filter: type a student's name in the Search student box to narrow your data to that individual student. 

  • Assignments filter: View all assignments, or select individual assignments to view or compare.

  • Time filter: select Last 28 days to open a dropdown of additional timeframe options. 

    • Select Custom range to enter your own dates for a timeframe that can begin as far back as class creation.

Screenshot of the grades activity data view in insights. Dropdown menus include student search box (type a name or click to view the roster) assignments, and timeframe

Dropdown menu of timeframes available to view data.

Read your data

You can view your Grades report in Distribution view or Trend view. Select  Down chevron button to switch between views. 

Note: Only graded assignments are included in the report. To easily compare the data for these assignments, the grades are normalized. This means that for each assignment, the grades are shown as if they were graded out of 100 points. For example, if there are 5 points available for a quiz, someone who earned a 4 is shown as receiving 80 points.  

Distribution view

  • Grade distribution of grades is represented by bars. When you select an individual student, their grade range is shown in a new bar with a different shade, so you can compare their range to the rest of the class.

  • Hover over the bar to see how many students are in the grade range, what the student’s average grade is, and how many graded assignments are included.

  • Select a bar to filter the student list on the right to only show the students in that grade range.

Trend view 

  • Use the trend view to look at a specific student’s performance for all assignments. One line represents the class average grade, while the other line represents the student's average.

How average grade is calculated 

Scenario: You set a test to be worth 5 points, a quiz to be 10 points, and a report to be 100 points. 

  • Student 1 received 4 points in the comprehension test, 10 points in the quiz, and 80 points for the report.

  • Insights adds up the points that Student 1 received (1+10+80) and divides them by the available points (5+10+100). 

    94/115 = 82 (rounded to the nearest digit). So Student 1's average grade is 82.

We repeat the process for all students, add up their average grades, and divide by the number of students to get the class average. 

Grades distribution graph

Grades trend graph

Export your data 

  1. In your report, select More options  More options button.

  2. Select Export to Excel.

  3. The Assignments sheet contains a list of students, and for each assignment, you see the grade (if graded with points). 

    The Summary sheet provides a student’s average grade for that class. 

    Note: You can view the selected time frame for your exported data in the Excel file name. 

Select Export to Excel from More options dropdown in report

Exported data in Excel from Insights Grades report

Classroom use cases that you can act on using your Grades report: 

  • Tracking a student's grades over time can be a useful way to check in and see if they need help. 

  • In the distribution view, the distribution of grades for a specific assignment—whether grades are unusually high or low—can help you plan future assignments and assessments. 

  • The grade distribution view can be helpful if you want to differentiate an assignment for groups of students in similar grade ranges. 

Learn more

Digital activity data in Insights

Communication activity data in Insights

Assignment status data in Insights

Educator's guide to Insights in Microsoft Teams

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!