Class Teams Assignments Statistics

%3CLINGO-SUB%20id%3D%22lingo-sub-1268614%22%20slang%3D%22en-US%22%3EClass%20Teams%20Assignments%20Statistics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1268614%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20of%20any%20way%20to%20pull%20assignment%20statistics%20from%20class%20teams%20using%20PowerBI%20or%20Graph%20or%20equiv%3F%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20School%20exec's%20want%20to%20see%20the%20usage%20of%20Teams%20and%20how%20many%20students%20are%20returning%20work%20etc.%20I%20cant%20see%20any%20PowerBI%20or%20Graph%20extensions%20for%20Teams%20classes%20so%20I%20don't%20have%20high%20hopes.%20I'm%20aware%20of%20the%20usage%20graph%20however%20am%20looking%20for%20specific%20data%20regarding%20assignments.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1268614%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%20for%20Education%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerBi%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529998%22%20slang%3D%22en-US%22%3ERe%3A%20Class%20Teams%20Assignments%20Statistics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529998%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174201%22%20target%3D%22_blank%22%3E%40Rhys%20Williams%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESeconded%2C%20we%20really%20need%20a%20way%20to%20do%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530748%22%20slang%3D%22en-US%22%3ERe%3A%20Class%20Teams%20Assignments%20Statistics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530748%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F615435%22%20target%3D%22_blank%22%3E%40dave10x%3C%2FA%3E%26nbsp%3BThe%20Insights%20%22add%20on%22%20does%20this%20for%20you.%20Add%20it%20as%20a%20tab%20in%20a%20Class%20Team.%20Only%20the%20teacher%20or%20%22owner%22%20of%20the%20team%20will%20see%20it.%20It%20provides%20you%20with%20all%20the%20statistics%20you%20need.%20You%20can%20drill%20down%20into%20detail%20of%20time%20spent%2C%20on%20what%2C%20assignments%20submitted%20per%20learner%20etc.%3C%2FP%3E%3CP%3EI%20noticed%20this%20some%20time%20ago%20and%20wondered%20why%20it%20had%20not%20been%20published%20more%20widely.%20I%20called%20it%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-teams-for-education%2Fbest-kept-secret-new-class-insights-preview-app%2Fm-p%2F1355312%23M333%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Eone%20of%20the%20best%20kept%20secrets%20of%20Microsoft%20Teams%20for%20Education%3C%2FA%3E.%20I%20have%20some%20screenshots%20in%20that%20post%20that%20shows%20you%20the%20kind%20of%20information%20one%20can%20obtain.%20Here%20is%20a%20video%20posted%20by%20Microsoft%20Education%20on%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dzsrx_JjXVgU%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EInsights%20feature%3C%2FA%3E%20just%20after%20my%20%3CSTRONG%3Ebest%20kept%20secret%3C%2FSTRONG%3E%20post.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530783%22%20slang%3D%22en-US%22%3ERe%3A%20Class%20Teams%20Assignments%20Statistics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F164657%22%20target%3D%22_blank%22%3E%40Marius%20Pretorius%3C%2FA%3E%26nbsp%3Bwe%20do%20currently%20use%20the%20Insights%20app%20however%20it%20doesnt%20give%20a%20top%20level%20view%20of%20the%20entire%20tenant's%20classes.%20School%20senior%20leaders%20need%20to%20know%20the%20overviews%20and%20averages%2C%20which%20currently%20cannot%20be%20pulled%20from%20Graph%20or%20any%20alternative.%3C%2FP%3E%3CP%3EThe%20current%20solution%20is%20to%20use%20the%20export%20from%20excel%20option%20in%20Insights%20and%20then%20pull%20that%20into%20a%20PowerBI%20dashboard%2C%20but%20this%20requires%20all%20owners%20of%20all%20classes%20to%20do%20this%20consistently.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Does anyone know of any way to pull assignment statistics from class teams using PowerBI or Graph or equiv? 

Our School exec's want to see the usage of Teams and how many students are returning work etc. I cant see any PowerBI or Graph extensions for Teams classes so I don't have high hopes. I'm aware of the usage graph however am looking for specific data regarding assignments.

3 Replies

@Rhys Williams 

 

Seconded, we really need a way to do this.

@dave10x The Insights "add on" does this for you. Add it as a tab in a Class Team. Only the teacher or "owner" of the team will see it. It provides you with all the statistics you need. You can drill down into detail of time spent, on what, assignments submitted per learner etc.

I noticed this some time ago and wondered why it had not been published more widely. I called it one of the best kept secrets of Microsoft Teams for Education. I have some screenshots in that post that shows you the kind of information one can obtain. Here is a video posted by Microsoft Education on the Insights feature just after my best kept secret post.

@Marius Pretorius we do currently use the Insights app however it doesnt give a top level view of the entire tenant's classes. School senior leaders need to know the overviews and averages, which currently cannot be pulled from Graph or any alternative.

The current solution is to use the export from excel option in Insights and then pull that into a PowerBI dashboard, but this requires all owners of all classes to do this consistently.