Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Slack のログを Google Spreadsheet に自動的に保存する: Google...

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for Ken Urano Ken Urano
March 24, 2018
Education
2
4.2k

Slack のログを Google Spreadsheet に自動的に保存する: Google Apps Script を使って

外国語教育メディア学会（LET）中部支部
Google Classroom での課題管理と Slack でのコミュニケーション活動入門・第2回
＠名古屋大学
2018.03.24.

Avatar for Ken Urano

Ken Urano

March 24, 2018
Tweet

More Decks by Ken Urano

See All by Ken Urano
Investigating Changes in Self-Assessed Spoken English Proficiency in a Three-Week Study-Abroad Program
Avatar for Ken Urano uranoken
0
70
The Task is not the End: The Role of Task Repetition and Sequencing In Language Teaching
Avatar for Ken Urano uranoken
0
650
学習者を対象にした英語教育研究における倫理的配慮
Avatar for Ken Urano uranoken
0
1.1k
学習者データを「見る」：外国語教師のためのデータの入力、分析、解釈方法
Avatar for Ken Urano uranoken
0
1.3k
英語教育研究でエビデンスを「つくる」：メタ分析、再現性、追試
Avatar for Ken Urano uranoken
0
1.5k
タスク·ベースの英語授業：基本的な考え方とデザイン方法
Avatar for Ken Urano uranoken
0
1.3k
英語の授業をタスクで組み立てる
Avatar for Ken Urano uranoken
0
1.4k
Designing Task-based ESP Syllabi: Two Cases from an English for Business Purposes Program
Avatar for Ken Urano uranoken
0
1.4k
第二言語習得と外国語教育における 「文法知識」の位置づけ
Avatar for Ken Urano uranoken
0
1.4k

Other Decks in Education

See All in Education
SJRC 2526
Avatar for cbtlibrary cbtlibrary
1
220
計算物理におけるGitの使い方 / 01-c-compphys
Avatar for kaityo256 kaityo256
PRO
2
500
アジャイルなマインドセットを「取り戻す」新人研修づくり
Avatar for Tomonori Fukuta chinmo
1
180
バージョン管理とは / 01-a-vcs
Avatar for kaityo256 kaityo256
PRO
1
210
Human Perception and Colour Theory - Lecture 2 - Information Visualisation (4019538FNR)
Avatar for Beat Signer signer
PRO
0
3k
Use Cases and Course Review - Lecture 8 - Human-Computer Interaction (1023841ANR)
Avatar for Beat Signer signer
PRO
0
1.4k
Gitの仕組みと用語 / 01-b-term
Avatar for kaityo256 kaityo256
PRO
0
200
IHLヘルスケアリーダーシップ研究会17期説明資料
Avatar for IHLヘルスケアリーダーシップ研究会 ihlhealthcareleadership
0
2.1k
環境・社会理工学院（建築学系）大学院説明会 2026｜東京科学大学（Science Tokyo）
Avatar for Science Tokyo （東京科学大学） / Science Tokyo (Institute of Science Tokyo) sciencetokyo
PRO
0
600
2025-12-19-LT
Avatar for Shigeki Shoji takesection
0
120
Gluon Recruit Deck
Avatar for Gluon gluon
0
160
Multimodal Interaction - Lecture 3 - Next Generation User Interfaces (4018166FNR)
Avatar for Beat Signer signer
PRO
0
2k

Featured

See All Featured
The SEO identity crisis: Don't let AI make you average
Avatar for Varn varn
0
420
SERP Conf. Vienna - Web Accessibility: Optimizing for Inclusivity and SEO
Avatar for Sara Fernández Carmona sarafernandez
1
1.3k
We Are The Robots
Avatar for Honza Javorek honzajavorek
0
200
StorybookのUI Testing Handbookを読んだ
Avatar for Shingo Yamazaki zakiyama
31
6.6k
CSS Pre-Processors: Stylus, Less & Sass
Avatar for Bermon Painter bermonpainter
360
30k
The Straight Up "How To Draw Better" Workshop
Avatar for Dennis Kardys denniskardys
239
140k
A Soul's Torment
Avatar for Nat Ma seathinner
5
2.5k
Winning Ecommerce Organic Search in an AI Era - #searchnstuff2025
Avatar for Aleyda Solis aleyda
1
1.9k
The agentic SEO stack - context over prompts
Avatar for schlessera schlessera
0
700
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
310
Balancing Empowerment & Direction
Avatar for Lara Hogan lara
5
950
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
Avatar for mongodb mongodb
49
9.9k

Transcript

  1. Slack ͷϩάΛ Google Spreadsheet ʹࣗಈతʹอଘ͢Δ —Google Apps Script Λ࢖ͬͯ— Ӝ໺

    ݚʢ๺ւֶԂେֶʣ email: [email protected] ֎ࠃޠڭҭϝσΟΞֶձʢLETʣத෦ࢧ෦ Google ClassroomͰͷ՝୊؅ཧͱSlackͰͷίϛϡχέʔγϣϯ׆ಈೖ໳ɾୈ2ճ ˏ໊ݹ԰େֶ ɹɹ2018. 3.24.

  2. Slack ͷϩάΛ Google Spreadsheet ʹࣗಈతʹอଘ͢Δ —Google Apps Script Λ࢖ͬͯ— Disclaimer

    ຊൃද͸ɺ2017೥10݄14೔ʹߦΘΕͨLETؔ੢ࢧ෦2017 ೥౓ळقݚڀେձʢˏྲྀ௨ՊֶେֶʣͰͷ Classroom Tips ൃදʮϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ʯͷ಺༰ͷ Ұ෦Λൈਮ͠ɺิ଍ͨ͠΋ͷͰ͢ɻ

  3. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  4. तۀ֓ཁ ̎೥࣍։ߨՊ໨ʢఆһ15໊ʣ ʻ໨ඪᶃʼ ϥΠςΟϯάͷ fluency ޲্ ʻ໨ඪᶄʼ ύϥάϥϑˍΤοηΠ࡞੒ೳྗ޲্ ϥΠςΟϯάतۀʹ͓͚Δ Slack

    ͷ׆༻

  5. ʻ໨ඪᶃʼ ϥΠςΟϯάͷ fluency ޲্ तۀ͚࣌ؒͩͰ͸ॻ͘ػձ͕଍Γͳ͍ ڭࣨ֎ϥΠςΟϯά׆ಈ ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  6. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  7. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  8. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  9. तۀ࣌ؒ֎ʹߦ͏ϥΠςΟϯά׆ಈ ޷͖ͳ͜ͱΛॻ͘νϟϯωϧͱ
 ຖिࢦఆ͞Εͨ࿩୊ʹ͍ͭͯॻ͘νϟϯωϧ ֓ཁ ҙຯॏࢹͰޡΓ΁ͷࢦఠ͸ߦΘͳ͍ ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ ධՁ͸ྔʢ૯ޠ਺ʣɾ੒੷ͷ30%

  10. ΢Σϒϒϥ΢βͰͷར༻΋Ͱ͖Δ Slack બ୒ͷཧ༝ ϩάͷΤΫεϙʔτ͕Ͱ͖ΔʢJSONܗࣜʣ ޠ਺Χ΢ϯτͳͲɺ੒੷ධՁͷͨΊͷ෼ੳ͕Ͱ͖Δ ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  11. ϩάͷΤΫεϙʔτ͕Ͱ͖ΔʢJSONܗࣜʣ ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  12. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  13. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  14. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ Ϣʔβʔ໊΋ίʔυԽ͞Ε͍ͯΔ

  15. ϩάͷΤΫεϙʔτ͕Ͱ͖ΔʢJSONܗࣜʣ ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ ༷ʑͳ෼ੳΛߦ͏ʹ͸ศར લॲཧ͕ඞཁ ͨͩ͠ ʮޠ਺ΛΧ΢ϯτ͍͚ͨͩ͠ͳΜ͚ͩͲ…ʯ

  16. Google ઌੜʹ૬ஊ Έ͚ͭͨʂ ෼ੳ͠΍͍͢ܗʹࣗಈతʹม׵͍ͨ͠ ʮSlack ͷϩάΛࣗಈͰ Google Spreadsheet ʹอଘ͢Δʯ http://motemen.hatenablog.com/entry/2015/11/gas-slack-log-spreadsheet

    ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  17. ʮSlack ͷϩάΛࣗಈͰ Google Spreadsheet ʹอଘ͢Δʯ http://motemen.hatenablog.com/entry/2015/11/gas-slack-log-spreadsheet ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  18. ʮSlack ͷϩάΛࣗಈͰ Google Spreadsheet ʹอଘ͢Δʯ http://motemen.hatenablog.com/entry/2015/11/gas-slack-log-spreadsheet ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ Google

    Apps Script Λར༻ ఆظతʹ Slack ͷϩάΛऔಘ ݟ΍͍͢ܗʹม׵ͯ͠ Spreadsheet ʹࣗಈอଘ

  19. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  20. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ Ϣʔβʔ໊΋ࣗಈऔಘ

  21. ʮSlack ͷϩάΛࣗಈͰ Google Spreadsheet ʹอଘ͢Δʯ http://motemen.hatenablog.com/entry/2015/11/gas-slack-log-spreadsheet ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ Google

    Spreadsheet ͷσʔλͳͷͰ Ϣʔβʔ໊΍౤ߘ೔࣌Ͱͷιʔτ͕؆୯ ͦͷ··੒੷ධՁʹ࢖͑Δ

  22. ڭ͑ͯ΄͍͠

  23. ڭ͑ͯ΄͍͠ • Spreadsheet ʹࣗಈతʹอଘ͞Εͨϩάͷϝοηʔδ෦ ෼ʢCྻʣͷޠ਺ΛΧ΢ϯτ͠ɺ৽͍͠ྻʹॻ͖ग़͢࡞ ۀΛࣗಈతʹͰ͖ͨΒ͏Ε͍͠ɻ • Ϣʔβ͝ͱͷ૯ޠ਺·Ͱग़ͯ͘͠ΕͨΒ͞Βʹ͏Ε͍͠ɻ • ͦΕΛਵ࣌ਤࣔͯ͘͠ΕͨΓͨ͠Βٽ͍ͯتͼ·͢ɻ

  24. ·ͱΊ

  25. • तۀ࣌ؒ֎ͷӳޠ࢖༻Λ૿΍͍ͨ͠ • Slack Λར༻ͨ͠ڭࣨ֎ϥΠςΟϯά׆ಈ • Google Apps Script Λར༻ͨ͠ϩάͷࣗಈอଘͱ੔ཧ

    • ͍ͣΕ͸͞ΒʹࣗಈԽΛਐΊ͍ͨ Ken Urano [email protected] ·ͱΊ