Meeting Statistics Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1691842%22%20slang%3D%22en-US%22%3EMeeting%20Statistics%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1691842%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20issue%20concerning%20statistics%20in%20Microsoft%20Teams%2C%20I%20administrate%20a%20school%20with%20different%20students%20and%20classes%2C%20and%20they%20need%20to%20have%26nbsp%3Bevery%20connection%20time%20and%20duration%20of%20every%20class%20they're%20doing.%3C%2FP%3E%3CP%3EThere%20is%20an%20%22HR%20guy%22%20who's%20job%20is%20to%20monitor%20theses%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERight%20now%20I%20know%20two%20options%20to%20have%20this%20information%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20The%20first%20one%20is%20to%20go%20to%20the%20teacher's%20user%20page%20in%20the%20Teams%20Administration%20Center%2C%20then%20go%20to%20call%20history%2C%26nbsp%3B%20and%20click%20on%20the%20meeting%20I%20want%20to%20see%2C%20(see%20screenshot1)%20this%20method%20is%20not%20ergonomic%20because%20when%20the%20%22HR%22%20guy%20match%20the%20students%20presence%20and%20delay%2C%20the%20names%20are%20disordered%20and%20when%20a%20student%20have%20a%20disconnection%2C%20we%20need%20to%20add%20every%20connection%20time%20one%20by%20one%20and%20it%20makes%20it%20very%20long%20when%20you%20have%20multiple%20class%20and%20lots%20of%20disconnections.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20The%20second%20way%20would%20be%20that%20at%20the%20end%20of%20a%20class%2C%20the%20teacher%20need%20to%20go%20to%20the%20attendee%20list%20and%20download%20the%20attendee%20list%20so%20he%20can%20get%20an%20excel%20of%20who%20disconnected%20when%20and%20order%20people%20by%20name%20(see%20screenshot2)%2C%20which%20solve%20my%20two%20problems%20said%20earlier%2C%20but%20the%20method%20to%20get%20that%20excel%20file%20is%20to%20complicated%20and%20some%20teacher%20might%20forget%20to%20do%20it%2C%20I%20would%20need%20to%20have%20this%20excel%20file%20by%20anytime.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20do%20you%20know%20any%20better%20and%20simpler%20way%20to%20do%20that%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20advice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGabriel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1691842%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eclass%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EConversations%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMeetings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Estatistics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi,

 

I have an issue concerning statistics in Microsoft Teams, I administrate a school with different students and classes, and they need to have every connection time and duration of every class they're doing.

There is an "HR guy" who's job is to monitor theses information.

 

Right now I know two options to have this information :

 

- The first one is to go to the teacher's user page in the Teams Administration Center, then go to call history,  and click on the meeting I want to see, (see screenshot1) this method is not ergonomic because when the "HR" guy match the students presence and delay, the names are disordered and when a student have a disconnection, we need to add every connection time one by one and it makes it very long when you have multiple class and lots of disconnections.

 

- The second way would be that at the end of a class, the teacher need to go to the attendee list and download the attendee list so he can get an excel of who disconnected when and order people by name (see screenshot2), which solve my two problems said earlier, but the method to get that excel file is to complicated and some teacher might forget to do it, I would need to have this excel file by anytime.

 

So, do you know any better and simpler way to do that ?

 

Thank you for any advice.

 

Gabriel

0 Replies