Thank you for this! Can you tell how do you manage the settings where students put you in spotlight or start recording meetings and mute you. How to get that in control?
Hello Leila, thanks for these hot tips! May I give you a suggestion for a new video? I use the attendance list in my classes, I always download it to my default download folder. With Power Query I collect these files once in a month and do some modifications. Mostly you download the attendance list at the end of the meeting, in the meantime people join and leave. I add an index for every lesson. You can see on the time stamp wich lesson or group it was. In the end I use a Pivot table so see the attandance in time and per student. I also can see the duration, what time a student attended and what time he/she left? Your PQ course was of great value here...;) Greetings Bart
Thank you! I’m glad to see the polls and whiteboard options. I use Nearpod and teams with my online and face to face students. I really appreciate the tips. 🙏🏽
Nice tutorial. Teams has a lot to want though. For instance, why do you have to pick a class when creating an assignment? You should be able to create templates and add them to classes afterwards. Same with the surveys.
I have a quick question. I may have students that try to complete “Hail Mary assignments.” What that means is they will not doing any work Mon through Thursday and then the assignment is due Fri. I think you showed how to do this, but I am not sure. What I would like to do is have a MW class, turn in work Friday, or TR CLASS TURN IN Fri. A) What can I do to make it so that 25 percent of the work needs to me done by Wed, 50 by Wed, and the balance by Fri end of school day 3p. And then I believe that I could allow students to turn it in by Sun and then close it? B) Do I need to set up three different classes because I teach the same class multiple times? What is the best way to do this. 4) lol, can I just get a teams tutor? Why? I have lesson plans due every Tues and I use a certain school grading book. I would like to set everything up and be ready. Do you know of such a thing? Lastly, do you know how to integrate teams with a Promethean board?
I love the broadened agenda to include the other MSoft products. IMHO, several of the tips in today's tutorial can be applied to other Team meetings, not just for teachers and students. However, I did forward the link to today's tutorial to several teachers. And as frequently is the case w/Leila's tutorials, I hear about functions that I previously had not been aware, i.e. ZoomIt. Always informative ... always well done ... and always worthwhile. PS Does anyone really believe Leila Gharani scored a 10 out of 20 on the assignment? Not me. My guess is 'payback' time has begun from the victims of her earlier "Pranks'. How do you like it now???
I hope MS Teams can create an exam that can be timed per item (an item expires after a specified time then another comes up, but the previously closed item cannot be answered anymore). Also, if the exam can randomly sample a number of items from a pool (like getting 10 from a pool of 50) for a specific students to provide randomization, it would minimize cheating. 😅 It still makes use of MS Forms and it's just a fixed set of items for all students. Failing to turn in at MS Forms in the Quiz tab will not retain the answers or uploaded files of the students unlike when using the Assignment tab. 😅 Great guide, Leila! 🥰🤓😂
Your tutorials have got me a promotion Literally. I am so thankful to you. There is something that has been holding me back for 1 year. How do you get specific data (date ranges for example) from another CLOSED workbook? I can’t find an effective solution to this problem
Thank you! And congratulations for your promotion! The most efficient way is to use Get & Transform from the data tab (aka Power Query). This way you have what you need with a few clicks. The formula way is to do a direct reference to the cell or range and then do the other more complex sides on the main workbook. Another option is to use VBA to open and close the workbook in the background but this does require some knowledge of VBA.
@@LeilaGharani OMG this could be mega useful! The sheet I use analyses the data of a table as big as 30MB. Each week it grows 0.5MB. I am thinking -CAN I use google sheets to store this mega table, and keep my workbook solely for my formulas sheet? What is your experience with google sheets (as a ultra fast tool) to load the data for your excel workbooks to read and work with?
Great tips Leila and once again just in time! I am shifting soon to conduct internal trainings on Teams and these tips are going to be very helpful! Thank you! 😊👍
Yes. They have other options but it's the same Teams you have download for Office 365. Only if you login with your education tenant you get all those options.
Hey Leila, i have a query in excel and it would be great if you can help me resolve it, i wanted to know how to trace precedent when offset formula is applied, Thanks in advance
Hi, this is very useful. If I add a meeting to a channel, the tabs (i.e. forms) become unavailable, so I can't add polls to a meeting if the meeting is within a Team Channel (mi classes usually are set inside the course channel). Do you know if it is possible to have these tabs available in a meeting if it is assigned to a channel?
Hi I have a solution for this if you want to add a pole to a channel select new conversation select the forms icon then a new pole will appear type in your question and your options preview it and then Send it
You have to register for an education account. You can have multiple accounts too. Business and education. You use the same Teams. Just logout of the one and then sign back in with the other.
Do you get copyright issues from ms excel ? Please make a video on how to start an excel tutorial channel. And what software you use for recording and editing. Thankyou.
That depends on where you're updating date and time. Is it in the same file? Do you have the number of days you need to add? You can use formulas like networkdays, edate etc to update date and time.
We use Microsoft Teams for School. But why my Microsoft teams application so heavy. Or because my The laptop processor? Btw my laptop processor is Intel Celeron 😌😆
@@LeilaGharani Ya, So far I have been using the web version, but I was tried the application because through the application you can use the background effect, while the web version can't😌😁
While I have really liked you content, I feel the channel is taking a turn and targeting a different audience. I am sorry to say but I am not really interested in the content for the last few weeks. I understand the push to grow the channel but with that push what I liked of your channel is left behind
I understand. The push was more for me. I love to learn new tools and expand my knowledge. I can’t see myself in one specific niche. Many thanks for your support in the past months.
![15 Microsoft Teams Tips & Tricks for Online Teaching [ 2021 ]](/img/n.gif)
You're simply amazing Leila,You are my hero.
i have learnt something new from this video, thanks for all your effort to organize these tutorials.
You're very welcome!
Thank you for the video! Here is a song you can use for Breakout rooms, ua-cam.com/video/ZcHGnL7OO_s/v-deo.html@@LeilaGharani
I always find your videos very useful... Every day something new... I did not know about the last one.. Thank you very much ma'am..
It's my pleasure :)
Thank you for this! Can you tell how do you manage the settings where students put you in spotlight or start recording meetings and mute you. How to get that in control?
These are genuinely excellent tips that have significantly enhanced my online teaching. Thank you so much!
You're so welcome!
Hello Leila, thanks for these hot tips! May I give you a suggestion for a new video? I use the attendance list in my classes, I always download it to my default download folder. With Power Query I collect these files once in a month and do some modifications. Mostly you download the attendance list at the end of the meeting, in the meantime people join and leave. I add an index for every lesson. You can see on the time stamp wich lesson or group it was. In the end I use a Pivot table so see the attandance in time and per student. I also can see the duration, what time a student attended and what time he/she left? Your PQ course was of great value here...;) Greetings Bart
That's a great idea Bart! I like it. Thank you for sharing.
Thank you! I’m glad to see the polls and whiteboard options. I use Nearpod and teams with my online and face to face students. I really appreciate the tips. 🙏🏽
Thanks Leila. Always interesting and enlightening topics at your channel :)) Thumbs up!!
Nice tutorial. Teams has a lot to want though. For instance, why do you have to pick a class when creating an assignment? You should be able to create templates and add them to classes afterwards. Same with the surveys.
Awesome video ! Very well explained and also entertaining !
Glad you enjoyed it, Philip!
Thank you so much for great video. I hope to do more videos about Microsoft teams for education
Thank you Leila ji for providing good knowledge
I have a quick question. I may have students that try to complete “Hail Mary assignments.” What that means is they will not doing any work Mon through Thursday and then the assignment is due Fri. I think you showed how to do this, but I am not sure. What I would like to do is have a MW class, turn in work Friday, or TR CLASS TURN IN Fri. A) What can I do to make it so that 25 percent of the work needs to me done by Wed, 50 by Wed, and the balance by Fri end of school day 3p. And then I believe that I could allow students to turn it in by Sun and then close it? B) Do I need to set up three different classes because I teach the same class multiple times? What is the best way to do this. 4) lol, can I just get a teams tutor? Why? I have lesson plans due every Tues and I use a certain school grading book. I would like to set everything up and be ready. Do you know of such a thing? Lastly, do you know how to integrate teams with a Promethean board?
Awesome tips! Thank you!
Thanks Leila. This video is very useful. Enjoyed the video :)
Glad it was helpful!
I love the broadened agenda to include the other MSoft products. IMHO, several of the tips in today's tutorial can be applied to other Team meetings, not just for teachers and students. However, I did forward the link to today's tutorial to several teachers.
And as frequently is the case w/Leila's tutorials, I hear about functions that I previously had not been aware, i.e. ZoomIt. Always informative ... always well done ... and always worthwhile.
PS
Does anyone really believe Leila Gharani scored a 10 out of 20 on the assignment? Not me. My guess is 'payback' time has begun from the victims of her earlier "Pranks'. How do you like it now???
I hope they will find it helpful. Regarding the payback: It's definitely better to be on the other side of the prank 😎
I hope MS Teams can create an exam that can be timed per item (an item expires after a specified time then another comes up, but the previously closed item cannot be answered anymore). Also, if the exam can randomly sample a number of items from a pool (like getting 10 from a pool of 50) for a specific students to provide randomization, it would minimize cheating. 😅
It still makes use of MS Forms and it's just a fixed set of items for all students. Failing to turn in at MS Forms in the Quiz tab will not retain the answers or uploaded files of the students unlike when using the Assignment tab. 😅
Great guide, Leila! 🥰🤓😂
Good points, Reynaldo! Thank you for the feedback!
Your tutorials have got me a promotion
Literally. I am so thankful to you.
There is something that has been holding me back for 1 year.
How do you get specific data (date ranges for example) from another CLOSED workbook?
I can’t find an effective solution to this problem
Thank you! And congratulations for your promotion! The most efficient way is to use Get & Transform from the data tab (aka Power Query). This way you have what you need with a few clicks. The formula way is to do a direct reference to the cell or range and then do the other more complex sides on the main workbook. Another option is to use VBA to open and close the workbook in the background but this does require some knowledge of VBA.
@@LeilaGharani
OMG this could be mega useful!
The sheet I use analyses the data of a table as big as 30MB. Each week it grows 0.5MB.
I am thinking -CAN I use google sheets to store this mega table, and keep my workbook solely for my formulas sheet?
What is your experience with google sheets (as a ultra fast tool) to load the data for your excel workbooks to read and work with?
Great tutorial! I will share with my colleague tomorrow. Especially about the chat. ❤️
Thanks for sharing!
Hi Leila,
Very helpful information. Thanks for posting such educational videos, easy to follow and will increase productivity. All the best !
Happy to hear that!
Great tips Leila and once again just in time! I am shifting soon to conduct internal trainings on Teams and these tips are going to be very helpful! Thank you! 😊👍
Wonderful! I hope all will go well with the change.
Excellent video. Some options I didn't know were available. Thanks
Thanks for watching!
Very good information.thanks👍 I also share with my Teachers
Thanks for sharing
Thank you, you’re very helpful.. can you make more video bout teams for teacher?
Hi Leila, I want to know whether there is a particular configuration for Education, as few features aren't there in Office 365
Yes. They have other options but it's the same Teams you have download for Office 365. Only if you login with your education tenant you get all those options.
Thank you for these great tutorial Leila!!! That's very useful!
You're so welcome!
Thanks for this wonderful video.
Glad you enjoyed it!
Hey Leila, i have a query in excel and it would be great if you can help me resolve it, i wanted to know how to trace precedent when offset formula is applied, Thanks in advance
Hi, this is very useful. If I add a meeting to a channel, the tabs (i.e. forms) become unavailable, so I can't add polls to a meeting if the meeting is within a Team Channel (mi classes usually are set inside the course channel). Do you know if it is possible to have these tabs available in a meeting if it is assigned to a channel?
Hi I have a solution for this if you want to add a pole to a channel select new conversation select the forms icon then a new pole will appear type in your question and your options preview it and then
Send it
Teams can you have assignments for business use? Or do you need a edu tenant?
As far as I'm aware it's only a part of educational tenant.
@@LeilaGharani do I need to upgrade it to a EDU tenant if I have a . Com domain?
You have to register for an education account. You can have multiple accounts too. Business and education. You use the same Teams. Just logout of the one and then sign back in with the other.
the zoomit app works only if we share the desktop, the effect is not possible if i share a window. Is there a solution for it.
In presenter mode the movies don’t play. Why?
This is fixed in the new updates.
@@LeilaGharani I will try tomorrow. Thank you.
Thanks 💜
I'd like to have the ability to customise our own background in together mode
Do you get copyright issues from ms excel ?
Please make a video on how to start an excel tutorial channel. And what software you use for recording and editing. Thankyou.
Hello mam,
Please make a video on automatically update date and time, whenever I change the value of a cell. ( Without VBA)
Your videos are amazing :)
That depends on where you're updating date and time. Is it in the same file? Do you have the number of days you need to add? You can use formulas like networkdays, edate etc to update date and time.
As much as I like the ‘GEEK’ mug, I hope you've placed an order for those customised mugs and we'll see them shortly! ☕️
Working on it! Can't wait to get new mugs 😁
Leila help us with Power Automate, please!
I just recorded a Excel & Power Automate video. It should go live next week Thursday :)
Value added tips
I am Student may I know how to on teacher video
How to know who is muting???
The dislikes are from students
Hahahahhaha
We use Microsoft Teams for School. But why my Microsoft teams application so heavy. Or because my The laptop processor? Btw my laptop processor is Intel Celeron 😌😆
I haven't experienced performance issues with Teams. Perhaps try using the web version?
@@LeilaGharani Ya, So far I have been using the web version, but I was tried the application because through the application you can use the background effect, while the web version can't😌😁
This Iranian Lady is gorgeous
Teachers won’t see this in the U.S., they’re all in their basements hiding from COVID...or on Spring Break in Mexico! 🤣😂🤣😂🤣😂🤣😂🤣😂🤣😂
While I have really liked you content, I feel the channel is taking a turn and targeting a different audience. I am sorry to say but I am not really interested in the content for the last few weeks. I understand the push to grow the channel but with that push what I liked of your channel is left behind
I understand. The push was more for me. I love to learn new tools and expand my knowledge. I can’t see myself in one specific niche. Many thanks for your support in the past months.