# How do I view average course grade analytics in a data table in New Analytics?

By default, the analytics page displays an [interactive analytics chart graph](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-view-average-course-grade-analytics-in-an-interactive/ta-p/1193) of all course grade data. However, you can choose to view analytics data as a table by percentage. Data is for viewing only and cannot directly be changed. You can view analytics in both active and concluded courses.

New Analytics allows you to track an average course grade for student submissions. The average course grade is the average of all student totals from the Gradebook. Course analytics will show you student activity, assignment submissions, grades, and student names. Page views and participation metrics include an aggregate across all devices, including Canvas mobile apps.

Only active student enrollments are included in data for New Analytics.

**Notes:**

<div id="bkmrk-if-you-cannot-view-t"><div>- If you cannot view the New Analytics link in Course Navigation, you may have to make the link visible via the Navigation tab in Course Settings. If the New Analytics link is not available in the Navigation tab, your institution has disabled this feature.
- Data is refreshed in New Analytics every 24 hours. Please confirm the time the data was last updated in the course, as content may be outdated compared to recent course activity and student submissions.
- In order for New Analytics to display in Canvas, third-party cookies may need to be enabled in your browser settings.

</div></div><div id="bkmrk-embed-this-video"><iframe allowfullscreen="allowfullscreen" data-mce-fragment="1" frameborder="0" height="400px" sandbox="allow-popups allow-popups-to-escape-sandbox allow-scripts allow-forms allow-same-origin allow-presentation" src="https://embed.app.guidde.com/playbooks/oPB4gCBA5QRdCeAjxUDjiY" title="How do I view average course grade analytics in a data table in New Analytics?" width="700px"></iframe>

<button class="embed-button">Embed this Video</button></div>## Open Course

<div data-step-uuid="82e3c959-0f7f-4c84-be04-9c221dbe67ac" id="bkmrk-"><div data-step-uuid="82e3c959-0f7f-4c84-be04-9c221dbe67ac"><div>![Open Course](https://media.screensteps.com/image_assets/assets/007/949/746/original/99c83ae9-9b12-42f9-b2e9-b795da78de66.png)</div><div><div></div></div></div></div>In Global Navigation, click the **Courses** link \[1\], then click the name of the course \[2\].

## Open New Analytics

<div data-step-uuid="cb0a7367-c4be-4b45-bd34-1e7d724d6172" id="bkmrk--0"><div data-step-uuid="cb0a7367-c4be-4b45-bd34-1e7d724d6172"><div>[![Open New Analytics](https://media.screensteps.com/image_assets/assets/008/118/090/medium/d5a5f3dc-cda4-40db-8305-18c749ca58f0.png)](https://media.screensteps.com/image_assets/assets/008/118/090/original/d5a5f3dc-cda4-40db-8305-18c749ca58f0.png)</div><div><div></div></div></div></div>To open New Analytics, click the **New Analytics** link in Course Navigation \[1\] or click the **New Analytics** button in the Course Home Page \[2\].

**Note**: If you cannot view the New Analytics link, you may have to make the link visible via the Navigation tab in Course Settings.

## Open Course Grade Analytics

<div data-step-uuid="9fc20c89-94ac-445d-ac98-601ba158ca6c" id="bkmrk--1"><div data-step-uuid="9fc20c89-94ac-445d-ac98-601ba158ca6c"><div>[![Open Course Grade Analytics](https://media.screensteps.com/image_assets/assets/008/122/673/medium/91482fdb-e158-48b6-854e-73717b6d540f.png)](https://media.screensteps.com/image_assets/assets/008/122/673/original/91482fdb-e158-48b6-854e-73717b6d540f.png)</div><div><div></div></div></div></div>Click the **Course Grade** tab.

## View Data Table

<div data-step-uuid="a4139595-4e7a-4d2b-bfbb-718efc291711" id="bkmrk--2"><div data-step-uuid="a4139595-4e7a-4d2b-bfbb-718efc291711"><div>[![View Data Table](https://media.screensteps.com/image_assets/assets/003/279/638/medium/e7c03d1a-9d3d-4169-99a7-4702879bc589.png)](https://media.screensteps.com/image_assets/assets/003/279/638/original/e7c03d1a-9d3d-4169-99a7-4702879bc589.png)</div><div><div></div></div></div></div>Click the **Options** icon \[1\] and select the **Data Table** option \[2\].

## View Data Status

<div data-step-uuid="03558218-288e-44fd-8a64-84dce71fe7a9" id="bkmrk--3"><div data-step-uuid="03558218-288e-44fd-8a64-84dce71fe7a9"><div>[![View Data Status](https://media.screensteps.com/image_assets/assets/008/118/094/medium/41ed85d5-92f3-4a48-a560-35277a0d02f8.png)](https://media.screensteps.com/image_assets/assets/008/118/094/original/41ed85d5-92f3-4a48-a560-35277a0d02f8.png)</div><div><div></div></div></div></div>If the course has been concluded, the analytics page includes a Concluded label.

## View Filter

<div data-step-uuid="ead40222-ae9e-4e72-8147-aa5ea491f97e" id="bkmrk--4"><div data-step-uuid="ead40222-ae9e-4e72-8147-aa5ea491f97e"><div>[![View Filter](https://media.screensteps.com/image_assets/assets/008/118/116/medium/6e053fbe-bd08-417d-bf31-1b3e5a2655c3.png)](https://media.screensteps.com/image_assets/assets/008/118/116/original/6e053fbe-bd08-417d-bf31-1b3e5a2655c3.png)</div><div><div></div></div></div></div>The analytics page is dynamic based on filtered content. By default, all results display the course average, which cannot be removed \[1\].

You can also view the average grade percentage for all students \[2\], which is not affected by any filter.

## Filter by Assignment

<div data-step-uuid="5cfdef4a-b1e3-4013-9076-982dfa301f9a" id="bkmrk--5"><div data-step-uuid="5cfdef4a-b1e3-4013-9076-982dfa301f9a"><div>![Filter by Assignment Type Enabled](https://media.screensteps.com/image_assets/assets/002/875/126/original/728a815a-ff61-4c28-8b89-5f312d742b14.png)</div><div><div></div></div></div></div>By default, analytics selects all assignment types to display within the page.

<div data-step-uuid="5cfdef4a-b1e3-4013-9076-982dfa301f9a" id="bkmrk--6"><div data-step-uuid="5cfdef4a-b1e3-4013-9076-982dfa301f9a"><div><div></div></div><div>![Filter by Assignment Type Removed](https://media.screensteps.com/image_assets/assets/002/875/130/original/8922c4e1-67ff-4733-b3f6-003bead698fa.png)</div><div><div></div></div></div></div>To filter by assignment type, remove the checkbox next to the assignment type. The chart dynamically updates the results based on the assignment type selected or removed in the filter.

**Note:** At least one assignment type is required at all times.

## Compare Course Data

<div data-step-uuid="cc494634-8dd3-4163-bc06-845085d8f204" id="bkmrk--7"><div data-step-uuid="cc494634-8dd3-4163-bc06-845085d8f204"><div>![Compare Course Data](https://media.screensteps.com/image_assets/assets/009/186/176/original/58bf5133-7621-4695-ac1a-536fcdd73830.png)</div><div><div></div></div></div></div>For analytical comparisons, you can [compare table data by filtering a section, student, or assignment.](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-compare-the-course-average-data-table-with-an/ta-p/1189)

## View Student Table

<div data-step-uuid="8d86f345-0cf1-415e-b446-a9f6320a57e0" id="bkmrk--8"><div data-step-uuid="8d86f345-0cf1-415e-b446-a9f6320a57e0"><div>[![View Student Table](https://media.screensteps.com/image_assets/assets/008/122/675/medium/095888ad-a0f0-45fb-a32a-6125c7f03538.png)](https://media.screensteps.com/image_assets/assets/008/122/675/original/095888ad-a0f0-45fb-a32a-6125c7f03538.png)</div><div><div></div></div></div></div>In the Students tab \[1\], you can also view the specific students that are part of each filter.

For each student, the table displays the following data:

<div data-step-uuid="8d86f345-0cf1-415e-b446-a9f6320a57e0" id="bkmrk-students-%5B2%5D%3A-the-li"><div data-step-uuid="8d86f345-0cf1-415e-b446-a9f6320a57e0"><div><div>- Students \[2\]: the list of students in the course sorted by last name. To [view analytics for the student](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-view-New-Analytics-in-a-course-as-an-instructor/ta-p/801), click the student's name \[3\].
- Grade \[4\]: current course grade.
- On Time \[5\]: the percent of assignments submitted on or before a due date.
- Last Participation \[6\]: the date the student last interacted with the course.
- Last Page View \[7\]: the date the student last accessed the course.
- Page Views \[8\]: the total page views for the student.
- Participations \[9\]: the total participations for the student.

</div></div><div data-step-uuid="c104be58-fc1f-4b13-a2a7-91bb1686526f"></div></div></div>### View Additional Students

<div data-step-uuid="8d86f345-0cf1-415e-b446-a9f6320a57e0" id="bkmrk--9"><div data-step-uuid="8d86f345-0cf1-415e-b446-a9f6320a57e0"><div data-step-uuid="c104be58-fc1f-4b13-a2a7-91bb1686526f"><div>[![View Additional Students](https://media.screensteps.com/image_assets/assets/003/782/081/medium/3359432b-34eb-4b02-84fa-73a8e89c6dee.png)](https://media.screensteps.com/image_assets/assets/003/782/081/original/3359432b-34eb-4b02-84fa-73a8e89c6dee.png)</div><div><div></div></div></div></div></div>By default, the students table displays 20 students at a time. You can view additional pages in the pagination bar.

### Sort Student Data

<div data-step-uuid="8d86f345-0cf1-415e-b446-a9f6320a57e0" id="bkmrk--10"><div data-step-uuid="8d86f345-0cf1-415e-b446-a9f6320a57e0"><div data-step-uuid="d87896ce-44c2-44d6-83ac-7761e4aadfb9"><div>[![Sort Student Data](https://media.screensteps.com/image_assets/assets/003/782/084/medium/9da05ed2-e677-46d6-979e-f834cbd52588.png)](https://media.screensteps.com/image_assets/assets/003/782/084/original/9da05ed2-e677-46d6-979e-f834cbd52588.png)</div><div><div></div></div></div></div></div>By default, the table sorts by last name, first name. However, you can sort any column in ascending or descending order by clicking the heading name. The sorted column is indicated by the sort arrow.

## Message Students Who

<div data-step-uuid="a1620ea3-5919-420d-9ab3-78ddfbfe5ff9" id="bkmrk--11"><div data-step-uuid="a1620ea3-5919-420d-9ab3-78ddfbfe5ff9"><div>[![Message Students Who](https://media.screensteps.com/image_assets/assets/009/186/178/medium/d187c83f-46fe-410c-93aa-ddee03b50d65.png)](https://media.screensteps.com/image_assets/assets/009/186/178/original/d187c83f-46fe-410c-93aa-ddee03b50d65.png)</div><div><div></div></div></div></div>To [send a message to students](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-send-a-message-to-all-students-based-on-specific-course/ta-p/1162) whose grades or submissions are within specific criteria, click the **Message** button.

## Export Table CSV

<div data-step-uuid="2f5be100-6ba3-48f7-b2a6-867b1bf50703" id="bkmrk--12"><div data-step-uuid="2f5be100-6ba3-48f7-b2a6-867b1bf50703"><div>![Export Table CSV](https://media.screensteps.com/image_assets/assets/009/186/180/original/97f8213f-0425-47b1-86a2-03d106675e91.png)</div><div><div></div></div></div></div>To export analytics data as a CSV file, click the **Download CSV** button.

CSV data is exported according to the filtered data.

CSV files display a student's full name, sortable name, Canvas user ID, SIS user ID or email (if applicable), overall course grade, the percent that assignments have been on time, the last page view time, the last participation time, and the last time the student logged out.

\[Content retrieved from [https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-view-average-course-grade-analytics-in-a-data-table-in/ta-p/1199](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-view-average-course-grade-analytics-in-a-data-table-in/ta-p/1199)\]