2022 年 9 月 28 日
September 28, 2022
向下滾動以獲取我們團隊的精彩提示!
Scroll down for great tips from our team!
蔡欣翰
(Hsin-han)
製作學生名單、成績公告、編班名單公告時,需要用〇替代名字中間的字時,可以用 replace函數幫忙。
使用 REPLACE函數將名字中的第二個字取代為〇
在儲存格填入:
=REPLACE(A2,2,1,"〇")
如果名字有四個字,想要取代中間 2 個字為〇〇,可以再加入 if 函數。
在儲存格填入:
=IF(LEN(A2)=4,REPLACE(A2,2,2,"〇〇"),REPLACE(A2,2,1,"〇"))
🔗範例檔案
When making student lists, grade announcements, and class list announcements, you can use the replace function to help when you need to use 〇 to replace the words in the middle of the name.
Use the REPLACE function to replace the second word in the name with 〇
Fill in the cell with:
=REPLACE(A2,2,1,"〇")
If the name has four characters, and you want to replace the middle two characters with 00, you can add the if function.
Fill in the cell with:
=IF(LEN(A2)=4,REPLACE(A2,2,2,"〇〇"),REPLACE(A2,2,1,"〇"))
張淑瑜
(Shuyu)
用Edpuzzle也能讓學生製作影片專案
培養學生有高層次的思考能力,可以利用Edpuzzle來指定七種方式的作業:
製作Ted Talk並彼此觀摩
創造一個影片的密室逃脫
書籍閱讀與推薦
錄製朗讀影片
詩或演講分析
錄製實驗過程或製作多媒體實驗紀錄
展示數學解題過程
You can use Edpuzzle to assign your students video projects now.
Here are 7 ways recommend by Edpuzzle
1.Give a TED Talk
2. Create a Video Escape Room
3. Do a Book Review
4. Record a Read-Aloud
5. Analyze a Poetry Reading or Speech
6. Complete a Video Lab Report
7. Demonstrate a Math Problem
🎯 https://blog.edpuzzle.com/edtech/
廖婉雯
(Wanwen)
欣翰老師在這次的小技巧介紹 REPLACE 這個函數,但是我金魚腦記不住怎麼辦?沒關係,我們可以利用「已命名函式」新增函式,以後直接套用公式。
一起跟著以下圖片操作吧!
Hsin-han introduced the tech tip — how to replace the middle character of a certain Chinese name with O using the REPLACE function. If you have difficulty memorizing the function like me, perhaps making use of "Named functions" would be a good idea.
🎯 More information: https://workspaceupdates.googleblog.com/2022/08/named-functions-google-sheets.html