Editing Members List of a class

%3CLINGO-SUB%20id%3D%22lingo-sub-1712507%22%20slang%3D%22en-US%22%3EEditing%20Members%20List%20of%20a%20class%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1712507%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%2C%20I%20am%20teaching%20at%20a%20University%20and%20using%20MS-Teams%20for%20lecturing.%20The%20classes%20(teams)%20%26nbsp%3Bwas%20created%20by%20some%20how%20the%20register%20all%20I%20did%20was%20to%20activate%20them%20which%20create%20the%20members%20list%20of%20the%20student%20and%20me%20as%20owner%20.%20%26nbsp%3Bwhen%20I%20list%20the%20members%20%2C%20I%20get%20Student%20name%20and%20his%20academic%20rank%20(Freshman%2C%20Sophomore%20..etc)%20.%20When%20I%20download%20the%20attendance%20list%20%26nbsp%3Bat%20the%20end%20of%20the%20lecture%20(%20excel%20csv%20sheet)%20it%20shows%20me%203%20columns%20%2C%20The%20name%20%2C%20user%20action%20(%20Joined%20or%20Left%20)%20and%20date%20and%20time%20.%20However%20I%20have%20my%20excel%20sheet%20that%20I%20use%20for%20grades%20which%20has%20the%20name%20of%20the%20student%20written%20%26nbsp%3Bdifferently%20than%20the%20excel%20I%20get%20from%20attendance%20list%20%26nbsp%3Bin%20Teams%20(%20Last%20then%20first%20and%20opposite%20in%20Teams%20list)%26nbsp%3B%20also%20detail%20about%20the%20student%20like%20the%20ID%20number%20.%20I%20need%20to%20insert%20the%20ID%20on%20MS-Teams%20so%20when%20I%20download%20the%20attendance%20list%20%2C%20the%20ID%20will%20be%20associated%20with%20student%20this%20way%20I%20can%20compare%20who%20attended%20using%20the%20number%20by%20sorting%20both%20sheets.%20I%20tried%20Visual%20Basic%20(VB)%20however%20my%20lack%20of%20experience%20with%20it%20will%20cost%20me%20a%20lot%20of%20time%20.%20Any%20suggestion%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1712507%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMS-Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi , I am teaching at a University and using MS-Teams for lecturing. The classes (teams)  was created by some how the register all I did was to activate them which create the members list of the student and me as owner .  when I list the members , I get Student name and his academic rank (Freshman, Sophomore ..etc) . When I download the attendance list  at the end of the lecture ( excel csv sheet) it shows me 3 columns , The name , user action ( Joined or Left ) and date and time . However I have my excel sheet that I use for grades which has the name of the student written  differently than the excel I get from attendance list  in Teams ( Last then first and opposite in Teams list)  also detail about the student like the ID number . I need to insert the ID on MS-Teams so when I download the attendance list , the ID will be associated with student this way I can compare who attended using the number by sorting both sheets. I tried Visual Basic (VB) however my lack of experience with it will cost me a lot of time . Any suggestion

0 Replies