Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

[Template] Translate Meeting Chat to ALL Languages

[Template] Translate Meeting Chat to ALL Languages
YouTube video

I was talking with a teacher who is teaching students who come from a variety of backgrounds. The issue she was having while on a video meeting was the chat. The chat doesn’t translate and there were more than two languages being spoken.

Template

Directions

After making a copy of the template, share the spreadsheet with the students with edit access.

Students have the spreadsheet visible side by side with the video meeting. Instead of chatting into the video platform chat, students can use the spreadsheet and chat in Column B. You will need to work with students to look for a cell having a colored border. This indicates that someone is typing in that cell.

ANY supported language of Google Translate typed into Column B will automatically be translated into English in Column C.

Column D and all of the columns to the right translate what the student typed into all of the other supported languages. Delete the columns for translation that you do not need supported during the chat.

Tips:

Since you are the owner of the spreadsheet you can highlight columns C to BK and right click to protect range to prevent students from editing the translation columns

As the chat moves, highlight the rows that are already read by everyone and right click to HIDE the rows.
1b492f65-6292-40d6-956e-e1c962b347f4-0323462d-0d5f-47d6-b264-2997b4778b75-v1.png?transparent=1&palette=1

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.