Related topics
×
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Export your Digital engagement data from Education Insights Premium

Export organization-level data to build your own reports and share with other educators in Microsoft Teams for Education. You have a choice between exporting to CSV and exporting to Excel, which will give you different data perspectives. 

  • Export to CSV: With exporting to CSV from the main dashboard page, you'll see specific, drilled-down data on time spent in meetings, number of meetings, posts created, replies to posts, files opened, and assignments opened.

  • Export to Excel: Export to Excel from the drilled-in Engagement view to see days students were active, time they spent in meetings, assignments turned in, and communication activity (a total of posts, replies, and reactions).

From your dashboard

  1. Select More options  Select the More Options icon from your dashboard.

  2. Select Export to CSV from the dropdown menu.

More options from Insights dashboard

More options menu with Export, Help, and Permissions

Choose what you want to export 

Note: When you go to export from your dashboard, take note of the organization level your dashboard is set to—if you're looking at data across multiple schools, grades, and classes, all data will be an average across students. A more drilled-in view at the single class level will show individual students, with data showing as totals instead of averages.

  1. Select the data you want to see in your                exported file:

    Time frame
    Activity level (inactive or active students)
    Schools (all schools or a specific school)

  2. Once you've made your selections, select Export to CSV. Check the downloads folder on your device for a zip file of your Insights data.

CSV export of an Insights report

Time spent in meetings 

  • Measured in minutes, this is time spent in meetings that took place during the selected time period.

Time spent in meetings in CSV file

Number of meetings 

  • Number of meetings attended during the selected time frame

Number of meetings CSV data column

Posts

  • A total of posts created in class channels

Posts CSV data column

Replies and reactions

  • A total of replies and reactions to posts in class channels

Replies CSV data column

Files activity

  • Reflects whether a student (or any student in the select organization level) has opened a class file. A will appear in the cell if they didn't open any files during the selected time period.

Files CSV data column

Assignments activity

  • Reflects whether a student (or any student in the select organization level) has opened an assignment—a will appear in the cell if they didn't open an assignment that was assigned during the selected time period.

Assignments activity CSV data column

Choose what you want to export 

  1. Select More options  Select the More Options icon from your Digital engagement view. 

  2. Select Export to Excel.

More options from Insights dashboard

Your exported data

  • The data you see in your exported report will depend on the organization level your Digital engagement view is set to.

  • if you're looking at data across multiple schools, grades, and classes, all data will be an average across students.

  • A more drilled-in view at the single class level will show individual students, with data showing as totals instead of averages.

Exported Insights file in Excel

CSV data cells of schools, active days, and meeting participation

Active days

Active days reflects a day when a student logged at least one kind of activity in Teams: 

  • Attended a meeting

  • Opened or turning in an assignment

  • Opened a class file

  • In a channel: ​​Created, replied to, or reacted to a post

Active days data in CSV export from Insights

Meeting participation

  • Time spent in meetings during the selected time frame

CSV data for student time spent in Teams meetings

Assignments turned in 

  • Percentage of due assignments turned in during the selected time period

CSV data for assignment turn-in

Communication activity 

  • Number of student responses to posts during the selected time frame

Communication activity column in Excel

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×